Junior Azure Data Engineer
Job Description
UniFirst is hiring a Junior Azure Data Engineer to help modernize how data is delivered to analytics and reporting. This hybrid role supports a migration from a legacy data warehouse to Azure Fabric Lakehouse/Warehouse, with opportunities to build data pipelines, improve data quality, and collaborate with senior engineers on ETL and performance tuning. The compensation range for this position is $68,000 to $85,000 per year.
Location: Wilmington, Massachusetts. This is a hybrid position with an on-site requirement in Wilmington, MA. Candidates must reside within commuting distance to the greater Boston area.
Responsibilities
- Support data-pipeline development and migration from Legacy Data Warehouse (LDW) to Azure Fabric Lakehouse/Warehouse.
- Write efficient SQL for data extraction, transformation, and validation across multiple databases, including SQL Server 2022, Azure SQL MI, and Synapse.
- Develop and debug Python scripts for automation, file ingestion, and data-quality checks.
- Assist with building Fabric dataflows, pipelines, and lakehouse tables aligned with enterprise data-modeling standards.
- Collaborate with senior engineers on ETL design, optimization, and performance tuning.
- Perform unit testing, participate in peer code reviews, and maintain technical documentation in Confluence/Git.
- Monitor data-load processes and help resolve job failures, including Zephyr test case execution and JIRA updates.
- Continuously learn emerging Azure technologies such as Databricks, Fabric, and Power BI, and contribute to process-improvement initiatives.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
- 1–2 years of hands-on experience with SQL (T-SQL preferred) and Python scripting.
- Basic understanding of data-warehousing concepts including ETL, staging, and fact/dimension modeling.
- Exposure to Azure services such as Data Factory, Synapse, or Fabric components.
- Strong curiosity, analytical mindset, and attention to detail.
- Enthusiasm to learn enterprise-scale systems and deliver high-quality, production-ready code.
Benefits
- 401K with Company Match
- Profit Sharing
- Health Insurance
- Employee Assistance Program
- Life Insurance
- Paid Time Off
- Tuition Reimbursement
- 30% Employee Discount
- Employee Referral Bonuses
Technologies: SQL, T-SQL, Python, Azure Fabric, Azure Fabric Lakehouse, Azure Fabric Warehouse, SQL Server 2022, Azure SQL MI, Synapse, Data Factory, Fabric dataflows, lakehouse tables, ETL, Confluence, Git, Zephyr, JIRA, Databricks, Power BI.
Job ID: 2605317