Senior Data Engineer

UniFirst•Wilmington, MA

21d•$109,000 - $152,000•Hybrid

About The Position

We are seeking a highly skilled and experienced Senior Data Engineer specializing in Microsoft SQL Server. The role designs, develops, and maintains enterprise data warehouses and SSIS packages, ensuring data reliability, performance, quality, and security. The Senior Data Engineer collaborates with software developers, data analysts, and other stakeholders to deliver trusted data for reporting, analytics, and business processes. This is a hybrid role with an on-site requirement in Wilmington, Massachusetts. Candidates must reside within commuting distance of the greater Boston area.

Requirements

At least 9 years of experience in data engineering and database development focused on Microsoft technologies.
Proven experience with Microsoft SQL Server and T-SQL, SSIS, Azure data services, and Microsoft Fabric; familiarity with SSRS and Power BI.
Proficiency in SQL Server, T-SQL programming, and dimensional data modeling.
Experience developing ETL and ELT pipelines using SSIS.
Hands-on experience with SSIS Catalog deployments, including SSIS package parameterization, environment variables, and Package and Project Deployment models.
Experience with database performance tuning and optimization techniques.
Knowledge of data security, access management, backup, and recovery practices across SQL Server.
Strong analytical and problem-solving skills.
Excellent communication and teamwork abilities.
Ability to work independently and manage multiple tasks and projects simultaneously.
Detail-oriented, with a focus on quality and accuracy.
Bachelor’s degree in computer science, Information Technology, or a related field.

Nice To Haves

Strong SSIS development skills, including package parameters, environment variables, catalog deployments, and expressions.
Knowledge of data modeling and database design principles, including dimensional data models such as star schemas, facts and dimensions, slowly changing dimensions, and data denormalization.
Master’s degree preferred.

Responsibilities

Design, implement, and maintain SQL Server database structures and dimensional data models, including tables, views, indexes, and schemas.
Develop complex SQL queries, stored procedures, functions, and triggers for application development and data processing.
Optimize database performance through indexing, query optimization, and other tuning techniques.
Design and develop ETL and ELT processes using SSIS to ingest and transform data from multiple sources.
Parameterize SSIS packages and create environment variables for SSIS Catalog package deployment.
Use expressions with package parameters to make connections dynamic and streamline deployment across environments.
Ensure data quality, consistency, and integrity across systems and environments.
Monitor and troubleshoot data pipelines; implement logging and error handling; and ensure timely, accurate data processing.
Analyze and optimize SQL queries to improve execution times and reduce resource consumption.
Implement indexing strategies to speed up data retrieval.
Rewrite complex queries to improve efficiency and maintainability.
Collaborate with developers to optimize queries embedded within applications.
Work with software developers, data analysts, and other IT team members to understand requirements and provide 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.
Ensure compliance with data governance, security policies, and industry regulations.