UniFirst is seeking a Junior Azure Data Engineer to help deliver reliable data pipelines and support the migration from a legacy data warehouse environment to Azure Fabric Lakehouse/Warehouse. This hybrid role is based in Wilmington, Massachusetts and emphasizes SQL and Python development, automation, and operational support for analytics and reporting across business functions.
Key Responsibilities
- Support data-pipeline development and migration activities from the Legacy Data Warehouse (LDW) to Azure Fabric Lakehouse/Warehouse.
- Write efficient SQL queries to enable data extraction, transformation, and validation across SQL Server 2022, Azure SQL MI, and Synapse.
- Develop and debug Python scripts for automation, file ingestion, and data-quality checks.
- Assist in building Fabric dataflows, pipelines, and lakehouse tables following enterprise data-modeling standards.
- Work with senior engineers on ETL design, optimization, and performance tuning.
- Perform unit testing, participate in peer code reviews, and maintain technical documentation in Confluence and 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 efforts.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Systems, Engineering, or a 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 for learning enterprise-scale systems and delivering high-quality, production-ready code.
Technologies and Tools
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.
Compensation and Benefits
The estimated annual salary range for this position is $68,000 to $85,000.
- 401K with Company Match
- Profit Sharing
- Health Insurance
- Employee Assistance Program
- Life Insurance
- Paid Time Off
- Tuition Reimbursement
- 30% Employee Discount
- Employee Referral Bonuses
Location
Wilmington, Massachusetts (hybrid). This role requires on-site presence in Wilmington, MA, and candidates must reside within commuting distance to the greater Boston area.
Job Details