Quick overview
Job description
Must be local to MA to go onsite to Wilmington, MA 2-3 days a week
Must have at least 9+ years of experience
Client: Unifirst
Sr Data Engineer
Duration: Contract, these have been starting off as 4+ months and could extend. We are getting more information today
Location: Wilmington, MA Hybrid onsite in Wilmington, MA 2-3 days a week
Pay Rate: $70/hr on W2
No H1B
Position Notes
Position Summary: We are seeking a highly skilled and experienced Senior Data Engineer specializing in Microsoft SQL Server. The ideal candidate will design, develop, and maintain enterprise data warehouses, and SSIS Packages, ensuring data reliability, performance, quality, and security. The Senior Data Engineer will collaborate closely with software developers, data analysts, and other stakeholders to deliver trusted data for reporting, analytics, and business processes.
Key Responsibilities:
Database Design and Development:
- Design, implement, and maintain database structures and dimensional data models, including tables, views, indexes, and schemas using Microsoft SQL Server.
- Develop complex SQL queries, stored procedures, functions, and triggers to support application development and data processing.
- Optimize database performance through indexing, query optimization, and other performance tuning techniques.
Data Integration and ETL Processes:
- Design and develop ETL and ELT processes using SQL Server Integration Services (SSIS) to ingest and transform data from multiple sources.
- Parameterize SSIS packages and create environment variables for SSIS Catalog package deployment
- Use expressions in concert with package parameters to make connections dynamic and streamline package deployment/promotion across environments
- Ensure data quality, consistency, and integrity across different systems and environments.
- Monitor and troubleshoot data pipelines, implement logging and error handling, and ensure timely and accurate data processing.
Query Optimization:
- Analyze and optimize SQL queries to improve execution times and reduce resource consumption.
- Implement indexing strategies to speed up data retrieval operations.
- Rewrite complex queries to make them more efficient and easier to maintain.
- Collaborate with developers to optimize queries embedded within applications.
Collaboration and Support:
- Work closely 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.
Documentation and Compliance:
- Create and maintain comprehensive documentation for database designs, processes, and procedures.
- Ensure compliance with data governance, security policies, and industry regulations.
Qualifications:
Education:
- Bachelor’s degree in computer science, Information Technology, or a related field. Master’s degree preferred.
Experience:
- Minimum of 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.
Technical Skills:
- 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.
Soft Skills:
- 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.
Preferred Qualifications:
- Strong SSIS development skills, including package parameters, environment variables, catalog deployments and expressions.
- Knowledge of data modeling and database design principles, including strong understanding of dimensional data models (star schemas, facts and dimensions, slowly changing dimensions, and data denormalization)
Nice to Have
- Azure/Fabric exposure
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- LE

Data Engineer Intern with Security ClearanceRecently posted
Leidos · Fort Belvoir, VA · Hybrid · Posted 20 Nov 2026 🇺🇸
Prompt EngineeringTechnology$41.6k - $75.2k/yr - AG

Senior Data Engineer with AIRecently posted
AIT Global, Inc. · Dallas, TX · Hybrid · Posted 20 Nov 2026 🇺🇸
DockerNeo4jSQL+29TechnologySalary not listed - DD

Jr. Data EngineerRecently posted
Dexian DISYS · Durham, NC · Hybrid · Posted 20 Nov 2026 🇺🇸
DynamoDBOracleSQL+7TechnologySalary not listed - DO

INFORMATION TECHNOLOGY SPECIALIST (DATA MANAGEMENT) with Security ClearanceRecently posted
Department of Defense · Bremerton, WA · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLData AnalysisLinuxTechnologySalary not listed - MT

Data Engineer (ETL)Recently posted
MHK TECH INC · United States · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLScalaAWS+12TechnologySalary not listed - FA

Data EngineerRecently posted
Factspan Inc · Atlanta, GA · On-site · Posted 20 Nov 2026 🇺🇸
OracleSQLETL+6TechnologySalary not listed - TE
Data Engineer - Minneapolis, MN, Detroit, MI, Madison, WI, Columbus, OH, Chicago, IL.Recently posted
TechniPros, LLC · Minneapolis, MN · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLApache SparkAWS+8TechnologySalary not listed - DT
Data Engineer (W2 only)Recently posted
Digipulse Technologies, Inc · Durham, NC · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLETLSnowflake+3TechnologySalary not listed - DA

Data EngineerRecently posted
DatamanUSA, LLC · Denver, CO · Hybrid · Posted 20 Nov 2026 🇺🇸
GitETLSnowflake+4TechnologySalary not listed - GF
Senior Data Engineer - W2 (No C2C or 1099) - Onsite in Wilmington, MA (Posted SAM)Recently posted
Global Force USA · Wilmington, MA · Hybrid · Posted 20 Nov 2026 🇺🇸
SQLETLSQL ServerTechnologySalary not listed - PE

Sr. Data Engineer (OBI Advanced Analytic Method Augmentation) with Security ClearanceRecently posted
Prescient Edge · Washington, DC · Hybrid · Posted 18 Nov 2026 🇺🇸
DockerSQLETL+5Technology$160k - $180k/yr - RT

Lead Data EngineerRecently posted
Rapsys Technologies · Columbus, OH · Hybrid · Posted 20 Nov 2026 🇺🇸
Apache SparkAWSETL+7TechnologySalary not listed