SQL/SSIS Lead (Data Engineer) (26-16417) -
Compu-Vision Consulting · Remote
Strong hiring record · median 31 days open
- First seen
- 12 November 2026
- Reposted
- Not since September 2026
- Last checked
- Today · still on the employer's board
All reasons
- No location stated
In its favour
- Posted 4 days ago
- Still listed on the employer's own board
- Someone has already applied through it
Job Title
SQL/SSIS Lead (Data Engineer)
Duration
9-12 months
Work Location
Remote (some onsite in Jefferson City, MO. No travel reimbursement, so Missouri or Midwest candidates are preferred)
Job Description
Owns the data layer of the SAMII data warehouse modernization: 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 -
- Analyse SAMII DW 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 BA and Solution Architect.
- Build reconciliation and balancing controls proving 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 (State minimums) -
- 7+ yrs full SDLC application development, with 7+ yrs QA testing
- 7+ yrs SQL (T-SQL and DB2 SQL), with system/unit testing and batch processing
- 7+ yrs DB2 z/OS with performance knowledge (reading, extracting and tuning queries)
- COBOL and JCL working knowledge (7+ yrs on the State matrix), enough to read the extract programs and job streams
- C# .NET exposure (scored on the State matrix)
- Azure DevOps (ADO)
- 5+ yrs hands-on SSIS and data warehouse ETL
Preferred -
- State or local government data warehouse experience (finance, HR, payroll)
- CGI Advantage / SAMII, or another public sector ERP
- Accounting or payroll data domain knowledge; VSAM
- Azure Data Factory or Synapse, if the target is cloud
Skills
- SQL
- T-SQL
- DB2 SQL
- SSIS
- C# .NET
- Azure DevOps
- COBOL
- JCL
- Data Warehouse
- ETL
- VSAM
- Azure Data Factory
- Synapse
More jobs at Compu-Vision Consulting
All 62- Senior HPC Lustre Parallel File System & Network Infrastructure Engineer (Early Demand)Compu-Vision Consulting · Lemont, IL2d ago
- IT Infrastructure Support ConsultantCompu-Vision Consulting · New York, NY2d ago
- Senior Software Engineer / SME (26-16628) -Compu-Vision Consulting · Location not stated2d ago
- Integration/DevOps Engineer (Data/App Engineer) (26-16454) -Compu-Vision Consulting · Remote4d ago
- .NET Lead (Application Development) (26-16441) -Compu-Vision Consulting · Remote4d ago