Junior Azure Data Engineer

UniFirst; Wilmington (MA); Hybrid; USD 68,000 - 85,000; Full time

Benefits offered by this job

401K with Company Match

Profit Sharing

Health Insurance

Employee Assistance Program

Life Insurance

Paid Time Off

Tuition Reimbursement

30% Employee Discount

Employee Referral Bonuses

Job summary

UniFirst is hiring a Junior Azure Data Engineer to build and migrate data pipelines from a legacy warehouse to Azure Fabric Lakehouse/Warehouse. You will work with SQL (T-SQL) and Python to develop, test, and automate data workflows.

You will collaborate with senior engineers on ETL design, optimization, and performance tuning while learning Azure Databricks, Fabric, and Power BI. Hybrid on-site role in Wilmington, MA with logging in Confluence and Git documentation.

Qualifications

• Bachelor’s degree in CS/IS/Engineering or related field
• 1–2 years hands-on experience with SQL and Python scripting
• Understanding of data warehousing concepts including ETL, staging, and fact/dimension modeling
• Exposure to Azure Data Factory, Synapse, or Fabric components

Responsibilities

• Support data-pipeline development and migration from the Legacy Data Warehouse to Azure Fabric Lakehouse/Warehouse
• Write efficient SQL queries across 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 on ETL design, optimization, and performance tuning
• Complete unit testing, code reviews, and maintain 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 (Databricks, Fabric, Power BI) and contribute to process-improvement initiatives

Skills

SQL

Python

T-SQL

Education

Bachelor's degree in CS/IS/Engineering

Tools

Azure Data Factory

Azure Synapse

Fabric

Databricks

Power BI

Git

Confluence

JIRA

Zephyr

Job description

UniFirst seeks a Junior Azure Data Engineer to help build and migrate data pipelines from a legacy warehouse to Azure Fabric Lakehouse/Warehouse.

Responsibilities

• Support data-pipeline development and migration from the Legacy Data Warehouse (LDW) to Azure Fabric Lakehouse/Warehouse
• Write efficient SQL queries for 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
• Complete 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 (including Databricks, Fabric, and Power BI) and contribute to process-improvement initiatives

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field
• 1 to 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

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

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

Location

• Wilmington, Massachusetts
• Hybrid role with an on-site requirement in Wilmington, MA
• Candidates must reside within commuting distance to the greater Boston area

Job ID: 2605317

Estimated Annual Salary Range: $68,000 to $85,000