Senior Data Engineer

UniFirst is hiring a Senior Data Engineer for an onsite role in Wilmington, Massachusetts. In this position, you will design and maintain enterprise data warehouses, lakehouses, and data pipelines, with a focus on reliability, performance, quality, security, and delivering trusted data for reporting, analytics, and business operations.

As part of the data engineering team, you will build database structures and integration workflows across Microsoft SQL Server and Azure, and support Microsoft Fabric solutions using Fabric Warehouse, Lakehouse, and OneLake. The work also includes governance and compliance alignment, along with collaboration across developers, analysts, and IT stakeholders.

What you’ll do

• Design, implement, and maintain database structures and dimensional data models, including tables, views, indexes, and schemas using Microsoft SQL Server, Azure SQL, and Microsoft Fabric Warehouse and Lakehouse.
• Build complex SQL queries and create stored procedures, functions, and triggers to support application development and data processing.
• Improve database performance using indexing, query optimization, and other performance tuning techniques.
• Develop ETL and ELT processes using SQL Server Integration Services (SSIS), Azure Data Factory, and Microsoft Fabric Data Factory pipelines and notebooks to ingest and transform data from multiple sources.
• Maintain data quality, consistency, and integrity across systems and environments.
• Monitor and troubleshoot data pipelines, implementing logging and error handling to ensure timely, accurate processing.
• Analyze and rewrite complex SQL to improve execution time, reduce resource consumption, and support maintainability.
• Collaborate with developers to optimize queries embedded within applications.
• Design and maintain cloud data solutions using Azure SQL Database, Azure Data Lake Storage, and Microsoft Fabric OneLake, Lakehouse, and Warehouse.
• Develop and maintain data integration solutions connecting SQL Server, Azure data services, and Microsoft Fabric, including incremental loads and bronze, silver, and gold layers.
• Apply best practices for Azure and Microsoft Fabric, including workspace organization, access controls, monitoring, and performance and cost optimization.
• Provide database-related technical support and troubleshooting.
• Mentor and guide junior data engineers and other team members.
• Create and maintain comprehensive documentation for database designs, processes, and procedures.
• Ensure compliance with data governance, security policies, and industry regulations.

What you’ll need

• Minimum 9 years of experience in data engineering and database development with a focus on Microsoft technologies.
• Proven experience with Microsoft SQL Server and T-SQL, SSIS, Azure data services, and Microsoft Fabric, with familiarity with SSRS and Power BI.
• Expertise with Azure data services and Microsoft Fabric for enterprise data warehousing and lakehouse solutions.
• Experience with Microsoft Fabric medallion architecture, Delta tables, incremental processing, and pipeline orchestration.
• Knowledge of data modeling and database design principles.
• Familiarity with Azure Synapse Analytics, Microsoft Purview, and Git-based version control and CI/CD for data solutions.
• Strong analytical and problem-solving skills, along with excellent communication and teamwork abilities.
• Ability to work independently and manage multiple tasks and projects at the same time.
• Detail-oriented approach focused on quality and accuracy.
• Bachelor’s degree in computer science, Information Technology, or a related field (Master’s degree preferred).

Compensation and location

• Location: Wilmington, MA (onsite)
• Salary: USD 109,000 - 152,000 per year
• Job ID: 2605390

Key technologies

• Microsoft SQL Server, Microsoft Fabric, Azure data services
• Microsoft Fabric Warehouse, Microsoft Fabric Lakehouse, Azure SQL
• T-SQL, SQL Server Integration Services (SSIS), Azure Data Factory
• Microsoft Fabric Data Factory
• Azure SQL Database, Azure Data Lake Storage
• Microsoft Fabric OneLake, Incremental loads, bronze/silver/gold data layers
• SSRS, Power BI
• Microsoft Fabric medallion architecture, Delta tables, pipeline orchestration
• Azure Synapse Analytics, Microsoft Purview
• Git, CI/CD
• Stored procedures, functions, triggers, dimensional data models