Azure Data Engineer

Azure Data Engineer

Location: Wilmington, MA (Hybrid - 2 days onsite, remainder remote; must be local to MA or NH)

Duration: Long Term Contract

Position Summary

We are seeking a highly motivated Azure Data Engineer with 7-9 years of experience to join our enterprise data engineering team. The ideal candidate will bring strong expertise in SQL, Python, and Azure cloud services, with a solid understanding of data warehousing concepts and handson experience in Azure Data Factory and Synapse. Exposure to Microsoft Fabric is preferred but not required.

This role will focus on supporting data pipeline development, migration, and optimization efforts, enabling scalable and reliable data solutions across Finance, Operations, and Enterprise functions.

Key Responsibilities

• Support data pipeline development and migration from legacy data warehouses to Azure Fabric Lakehouse/Warehouse.

• Write efficient SQL queries (TSQL preferred) for extraction, transformation, and validation across multiple databases (SQL Server 2022, Azure SQL MI, Synapse).

• Develop and debug Python scripts for automation, ingestion, and data quality checks.

• Assist in building Fabric dataflows, pipelines, and lakehouse tables aligned with enterprise datamodeling standards.

• Collaborate with senior engineers on ETL design, optimization, and performance tuning.

• Perform unit testing, peer code reviews, and maintain documentation in Confluence/Git.

• Monitor and troubleshoot data load processes, resolving job failures and updating JIRA/Zephyr test cases.

• Continuously learn and apply emerging Azure technologies (Databricks, Fabric, Power BI) to improve processes.

Required Skills & Qualifications

• Bachelor s degree in Computer Science, Information Systems, Engineering, or related field.

• 7-9 years of professional experience in data engineering.

• Strong proficiency in SQL (TSQL preferred).

• Handson experience with Python scripting.

• Solid understanding of data warehousing concepts (ETL, staging, fact/dimension modeling).

• Strong expertise with Azure services: Data Factory, Synapse (Fabric experience a plus).

• Experience with Git/Azure DevOps, Confluence, JIRA.

• Knowledge of data modeling, metadata management, and data quality principles.

• Familiarity with Agile/Scrum environments.

• Exposure to Power BI and basic DAX concepts.

• Strong analytical mindset, attention to detail, and enthusiasm for learning enterprisescale systems.