Back to search

SQL/SSIS Lead (Data Engineer)

Owns the data layer of the SAMII data warehouse modernization, designing and building SSIS packages, T-SQL, and data-quality rules for ETL processes.

  • Remote, United States
  • Contract
  • Remote
  • Posted Nov 11, 2026
INDUSTRYSoftware & InternetData & Analytics

Responsibilities

  • Analyse SAMII DW sources and document data lineage
  • Design and build SSIS packages and T-SQL for extract, transform and load
  • Write source-to-target mappings and data-quality rules
  • Build reconciliation and balancing controls
  • Tune SQL and load performance; support batch schedules and restart/recovery
  • Own unit and system testing of data components
  • Support SIT, UAT and parallel runs; fix data defects

Requirements

  • Experience in a public sector ERP

Nice to have: State or local government data warehouse experience, CGI Advantage / SAMII, Accounting or payroll data domain knowledge, Azure Data Factory, Synapse

Skills

SQLT-SQLDB2 SQLSSISAzure DevOpsC#COBOLJCLbatch processingSSISAzure DevOpsAzure Data FactorySynapse

More jobs nearby

Full description

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

SQL/SSIS Lead (Data Engineer) at Compu-Vision Consulting Inc. | Referso Jobs