Senior Data Engineer

Senior Data Engineer role focused on building reliable, high-performance Microsoft-based data platforms for reporting, analytics, and business operations.

Responsibilities

• Design, implement, and maintain enterprise data warehouse, lakehouse, and database structures using Microsoft SQL Server, Azure SQL, and Microsoft Fabric (Warehouse and Lakehouse).
• Build dimensional data models and support structures, including tables, views, indexes, and schemas.
• Develop and maintain complex SQL queries, stored procedures, functions, and triggers to enable application development and data processing.
• Improve performance using indexing, query optimization, and other database tuning approaches.
• Develop ETL and ELT workflows with SSIS, Azure Data Factory, and Microsoft Fabric Data Factory pipelines and notebooks.
• Ingest and transform data from multiple sources; ensure consistent integration across environments.
• Maintain data quality, consistency, and integrity across systems.
• Monitor and troubleshoot data pipelines; implement logging and error handling to support timely and accurate processing.
• Rewrite complex queries to improve execution time and make them easier to maintain.
• Collaborate with developers to optimize SQL queries embedded in applications.
• Design and support cloud data solutions with Azure SQL Database, Azure Data Lake Storage, and Microsoft Fabric OneLake, including Fabric Lakehouse and Warehouse.
• Build and maintain data integration solutions connecting SQL Server, Azure data services, and Microsoft Fabric, including incremental loads and layered datasets (bronze, silver, and gold).
• Apply best practices for Azure and Microsoft Fabric, including workspace organization, access controls, monitoring, and performance and cost optimization.
• Work with software developers, data analysts, and other IT team members to translate requirements into database solutions.
• Provide technical support and troubleshooting for database-related issues.
• Mentor and guide junior data engineers and other team members.
• Create and maintain documentation for database designs, processes, and procedures.
• Support compliance with data governance, security policies, and industry regulations.

Requirements

• 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, plus 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 with CI/CD for data solutions.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Ability to work independently and manage multiple tasks and projects at once.
• Detail-oriented approach with focus on quality and accuracy.
• Bachelor’s degree in computer science, Information Technology, or related field (Master’s degree preferred).

Tech Stack

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

Location: Wilmington, Massachusetts (onsite)

Salary: USD 109,000 - 152,000 per year

Job ID: 2605390