Quick overview
Job description
Title: SQL/SSIS Lead (Data Engineer)
Duration: 9-12 Months - CONTRACT [NO BENEFITS]
Location: Remote (some onsite in Jefferson City, MO)
Job Summary:
Owns the data layer of a data warehouse modernization program: source-to-target mapping, ETL/SSIS build, data loads, and reconciliation of financial, HR, and payroll data from DB2 z/OS into the target warehouse.
Responsibilities:
- Analyze data warehouse sources (DB2 z/OS tables, VSAM, and flat-file extracts) and document data lineage.
- Design and build SSIS packages and T-SQL for extract, transform, and load into the target warehouse.
- Write source-to-target mappings and data-quality rules with the Business Analyst and Solution Architect.
- Build reconciliation and balancing controls that prove legacy and new outputs match.
- Tune SQL and load performance; support batch schedules and restart/recovery.
- Own unit and system testing of data components, tracked in Azure DevOps.
- Support SIT, UAT, and parallel runs; fix data defects.
Required Qualifications:
- 7+ years of full SDLC application development, with 7+ years of QA testing.
- 7+ years of SQL (T-SQL and DB2 SQL), including system/unit testing and batch processing.
- 7+ years of DB2 z/OS with performance knowledge (reading, extracting, and tuning queries).
- Working knowledge of COBOL and JCL (7+ years), enough to read extract programs and job streams.
- Exposure to C# .NET.
- Azure DevOps (ADO).
- 5+ years of hands-on SSIS and data warehouse ETL.
Preferred Qualifications:
- State or local government data warehouse experience (finance, HR, payroll).
- Experience with CGI Advantage or another public sector ERP.
- Accounting or payroll data domain knowledge; VSAM.
- Azure Data Factory or Synapse, if the target is cloud.
Similar jobs
- ED

Sr. Data Engineer (only w2 role)Recently posted
EdgeAll · Foster City, CA · On-site · Posted 16 Nov 2026 🇺🇸
SQLAWSAirflow+3TechnologySalary not listed - CB

Data Engineer, Reporting & AnalyticsRecently posted
Cobalt Benefits Group LLC · New Hampshire · Hybrid · Posted 10 Nov 2026 🇺🇸
SQLGitETL+13TechnologySalary not listed - CB

Data Engineer, Reporting & Analytics - $85000 - $125000 Yearly SalaryRecently posted
Cobalt Benefits Group LLC · New Hampshire · Hybrid · Posted 10 Nov 2026 🇺🇸
SQLGitETL+13Technology$85k - $125k/yr - OR
Data Engineer & Application Development (TS/SCI w/ Poly) Auto Apply
Orbis · McLean · Hybrid · Posted 3 Nov 2026 🇺🇸
SQLGitData Pipeline+7TechnologySalary not listed - WE

Staff Data Engineer Auto Apply
Webflow · United States · Remote · Posted 20 Oct 2026 🇺🇸
SQLAirflowEMR+5Technology$212.5k - $255k/yr - GS
Data Engineer Lead / Data Warehouse ArchitectRecently posted
Govan Systems inc · Michigan · Hybrid · Posted 16 Nov 2026 🇺🇸
DockerSQLGit+18TechnologySalary not listed - GD

NCIS Data Engineer | Active Secret clearance
General Dynamics Information Technology · Quantico, VA · Hybrid · Posted 19 Oct 2026 🇺🇸
DockerPL/SQLSQL+14Technology$142.8k - $166.8k/yr - GS
Data Engineer Lead / Data Warehouse ArchitectRecently posted
Govan Systems inc · Lansing, MI · Hybrid · Posted 15 Nov 2026 🇺🇸
DockerSQLGit+18TechnologySalary not listed - CB

Data Engineer, Reporting & AnalyticsRecently posted
Cobalt Benefits Group LLC · Raleigh, North Carolina · Hybrid · Posted 9 Nov 2026 🇺🇸
SQLGitETL+13TechnologySalary not listed - SA
Data Operations EngineerRecently posted
SAIC · Honolulu, HI · Remote · Posted 15 Nov 2026 🇺🇸
Microsoft ExcelGitApache Spark+15Technology$80.0k - $120k/yr - ES
Lead Data Architect / Data EngineerRecently posted
Estaff LLC · Sacramento, CA · Hybrid · Posted 13 Nov 2026 🇺🇸
Stakeholder ManagementSQLApache Spark+8TechnologySalary not listed - AE

Sr. Data Engineer/Sr. Data ArchitectRecently posted
Aerospace Corporation · El Segundo, CA · On-site · Posted 13 Nov 2026 🇺🇸
DynamoDBMicroservicesMongoDB+10Technology$144.5k - $216.7k/yr