Senior Data Engineer - W2 (No C2C or 1099) - Onsite in Wilmington, MA (Posted SAM)
Quick overview
Job description
REQUIRED SKILLS
- 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.
Will your resume get past this employer's screening? Check your resume against this job, free
Similar jobs
- 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 - 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 - TE
Senior Data Engineer - Phoenix, AZ, St. Louis, MO, Nashville, TN, Kansas City, KS, Denver, CO.Recently posted
TechniPros, LLC · Phoenix, AZ · Hybrid · Posted 20 Nov 2026 🇺🇸
DockerSQLGit+16TechnologySalary not listed - TE

Sr. Data EngineerRecently posted
Tekfortune Inc. · West Chester, PA · On-site · Posted 20 Nov 2026 🇺🇸
SQLApache SparkETL+4TechnologySalary not listed - CT

Software Engineer / Data EngineerRecently posted
Conch Technologies · Wilmington, DE · Hybrid · Posted 20 Nov 2026 🇺🇸
AWSSnowflakeDatabricks+5TechnologySalary not listed - ZP

Data Migration Engineer Mid (CLEARANCE REQUIRED) with Security ClearanceRecently posted
Zachary Piper Solutions, LLC · Huntsville, AL · Hybrid · Posted 20 Nov 2026 🇺🇸
EngineeringSalary not listed - LT

Data Engineer with Security ClearanceRecently posted
L3Harris Technologies · Salt Lake City, UT · Hybrid · Posted 20 Nov 2026 🇺🇸
DockerMySQLSQL+21TechnologySalary not listed - BA

Palantir Data EngineerRecently posted
Booz Allen Hamilton · Atlanta, GA · On-site · Posted 18 Nov 2026 🇺🇸
Stakeholder ManagementGitHTML+12Technology$99k - $225k/yr - BA

Data Engineer
BOOZ, ALLEN & HAMILTON, INC. · Stafford, VA · On-site 🇺🇸
SQLTableauIoT+5Technology$62k - $141k/yr - AT

Sr. Oracle DBARecently posted
Acadia Technologies, Inc. · Atlanta, GA · Hybrid · Posted 19 Nov 2026 🇺🇸
OraclePL/SQLSQL+2TechnologySalary not listed