Senior Data Engineer
Senior
Azure
Azure Data Factory
Azure Sql
Business Intelligence
Data Architecture
Data Engineer
Data Engineering
Data Factory
Data Factory Azure
Data Integration
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Database
Databases
ETL
Integration
Lakehouse
Microsoft Azure
Microsoft Fabric
Power BI
Reporting and Analytics
SQL
Job Description
UniFirst is hiring a Senior Data Engineer to help design and operate enterprise data platforms that support reliable reporting, analytics, and business processes. This onsite role in the United States centers on building data warehouses and lakehouses, developing SQL-based pipelines, and integrating Microsoft Azure and Microsoft Fabric capabilities to deliver trusted data.
What you’ll do
- Design, develop, and maintain enterprise data warehouses, lakehouses, and data pipelines with an emphasis on reliability, performance, data quality, and security.
- Work closely with software developers, data analysts, and other stakeholders to deliver data that supports reporting, analytics, and business processes.
- 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.
- Develop complex SQL assets such as queries, stored procedures, functions, and triggers for application development and data processing.
- Optimize database performance through indexing, query optimization, and other performance tuning techniques.
- Create and improve 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.
- Ensure data quality, consistency, and integrity across systems and environments.
- Monitor and troubleshoot pipelines, implement logging and error handling, and ensure data processing is timely and accurate.
- Analyze and rewrite complex SQL queries to improve execution time, reduce resource consumption, and enhance maintainability.
- Collaborate with developers to optimize SQL 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 data layers.
- Apply best practices for Azure and Microsoft Fabric, including workspace organization, access controls, monitoring, and performance and cost optimization.
- Provide technical support and troubleshooting for database-related issues.
- 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 bring
- 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 simultaneously.
- Detail-oriented approach focused on quality and accuracy.
Education
- Bachelor's degree in computer science, Information Technology, or a related field (Master's degree preferred).
Salary
- USD 109,000 - 152,000 per year
Key technologies
- Microsoft SQL Server, Azure SQL
- Microsoft Fabric Warehouse, Microsoft Fabric Lakehouse
- T-SQL, SQL Server Integration Services (SSIS)
- Azure Data Factory, Microsoft Fabric Data Factory pipelines, Microsoft Fabric notebooks
- Azure SQL Database, Azure Data Lake Storage
- Microsoft Fabric OneLake
- Microsoft Fabric medallion architecture, Delta tables, pipeline orchestration
- Azure Synapse Analytics, Microsoft Purview
- SSRS, Power BI
- Git-based version control, CI/CD
Similar Jobs
