> Markdown version of [/jobs/ext/4693706-sql-ssis-lead-data-engineer-26-16417](https://www.wearedevelopers.com/jobs/ext/4693706-sql-ssis-lead-data-engineer-26-16417). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# SQL/SSIS Lead (Data Engineer) - 26-16417

- **Company:** Compu-Vision Consulting Inc.
- **Location:** St. Louis, MO, United States (Remote available)
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Unit Testing, Microsoft Azure, Batch Processing, C Sharp (Programming Language), COBOL (Programming Language), Databases, Extract Transform Load (ETL), Data Warehousing, IBM DB2, DB2 SQL, Document-Oriented Databases, Job Control Language (JCL), Systems Development Life Cycle, Software Engineering, SQL Databases, SQL Server Integration Services, System Testing, Transact-SQL, Virtual Storage Access Methods, Z/OS, Azure Data Factory, Data Layers, Build Management
- **Published:** November 12, 2026
- **Apply:** https://www.careerbuilder.com/job-details/sql-ssis-lead-data-engineer-26-16417-saint-louis-mo--1fb78d49-4dc6-4259-acce-b8b5589b36f9

## About the Role

SQL Server Integration Services (SSIS), SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL (Structured Query Language), IBM z-OS Operating System, Warehousing, Data Warehousing, Database Extract Transform and Load (ETL), IBM DB2, Reconciliation, * 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.

## Description

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., * 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.