JobHabor
Menu

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

Compu-Vision Consulting · Remote

Strong hiring record · median 31 days open

100100

Hiring signal

Actively hiring

Open 4 days · Never reposted · Checked today · How we score

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

Did you apply?

SQL/SSIS Lead (Data Engineer) (26-16417) - at Compu-Vision Consulting. We’ll keep it in your applied jobs, so you can see it later and be warned before applying to the same employer twice.

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

Similar roles