Lead Data/ETL Engineer

DecisionPoint | Cortek

United States

Remote

USD 140,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

DecisionPoint is seeking a Lead Data/ETL Engineer to provide technical leadership and hands‑on engineering for data ingestion, transformation, integration, and delivery under the USMEPCOM ENLIST program. This SME‑level role will optimize SSIS, implement API integrations, and build robust data layers while establishing reconciliation and lineage practices.

The position is remote, with Chicago‑area candidates preferred, and requires active security clearance.

Qualifications

  • Active Secret clearance or higher.
  • Minimum of 12 years of relevant professional experience.
  • Bachelor's degree in computer science, information systems, or a related field, or a permitted equivalent.
  • Experience maintaining and optimizing SSIS.
  • Strong SQL skills.
  • Experience with Python and data engineering automation.
  • Experience implementing and supporting API integrations.
  • Experience developing incremental data loads.
  • Experience documenting and maintaining data lineage.
  • Experience troubleshooting complex data pipelines.
  • Ability to build raw, standardized, and curated data layers.
  • Ability to manage reconciliation, retries, schema changes, identifier mappings, and failed-record handling.
  • Ability to implement change-data capture where appropriate.
  • CompTIA Security+ CE or another approved IAT Level II certification when applicable to assigned duties.

Responsibilities

  • Lead the design, implementation, maintenance, and optimization of enterprise data integration and ETL pipelines.
  • Maintain and optimize SSIS packages, configurations, schedules, dependencies, and execution processes.
  • Develop SQL queries, stored procedures, transformations, and reconciliation logic.
  • Use Python or another approved automation language to support ingestion, orchestration, validation, monitoring, and recovery.
  • Implement approved API integrations, including authentication, pagination, rate-limit handling, retries, and error processing.
  • Design incremental loading strategies and implement change-data capture where appropriate and approved.
  • Build and maintain raw, standardized, and curated data layers with documented transformation rules.
  • Establish source-to-target mappings, common identifier mappings, and consistent handling of reference data.
  • Implement reconciliation checks to verify record counts, totals, completeness, and transformation accuracy.
  • Develop restartable processing, controlled retries, checkpoints, and recovery procedures.
  • Implement failed-record handling, quarantine processes, error logging, and controlled reprocessing.
  • Assess and manage schema changes and their effects on pipelines, datasets, analytical models, and reports.
  • Maintain data lineage, transformation documentation, interface specifications, and pipeline dependencies.
  • Monitor pipeline execution, throughput, freshness, resource utilization, and operational failures.
  • Troubleshoot complex issues involving source systems, APIs, SSIS packages, SQL logic, data quality, and downstream integrations.
  • Optimize pipeline performance while maintaining data integrity, traceability, and approved security controls.
  • Coordinate with governance personnel on definitions, ownership, authoritative sources, metadata, and approved data uses.
  • Work with independent testing personnel to support reconciliation, regression testing, defect resolution, and release validation.
  • Coordinate pipeline changes with database, application, AI/ML, warehouse, and BI teams.
  • Maintain version-controlled code, deployment instructions, rollback procedures, and operational runbooks.
  • Review technical designs and code, guide engineering practices, and provide knowledge transfer to other engineers.
  • Communicate pipeline health, risks, dependencies, corrective actions, and improvement recommendations to technical leads and Government stakeholders.

Skills

Lead data pipelines
Problem solving
Mentoring/knowledge transfer

Education

Bachelor's degree in CS/IS or related field

Tools

SSIS
SQL
Python
APIs
Incremental loads
Data lineage
Change-data capture

Job description

Overview

DecisionPoint seeks a Lead Data/ETL Engineer to provide technical leadership and hands‑on engineering for data ingestion, transformation, integration, and delivery under the USMEPCOM ENLIST program.

This SME‑level position will maintain and optimize SQL Server Integration Services (SSIS), implement approved API integrations and incremental loading approaches, and build raw, standardized, and curated data layers. The engineer will establish reliable processes for reconciliation, retries, schema changes, identifier mappings, lineage, and failed‑record handling.

The Lead Data/ETL Engineer will collaborate with database administrators, architects, governance personnel, AI/ML engineers, BI developers, testers, and Government stakeholders to deliver accurate, traceable, and maintainable data pipelines supporting mission analysis, AI capabilities, and reporting.

This position is remote, with Chicago‑area candidates preferred.

Note: By applying to this position, you acknowledge and consent to having your resume included in an active competitive government contract bid.

Duties & Responsibilities
  • Lead the design, implementation, maintenance, and optimization of enterprise data integration and ETL pipelines.
  • Maintain and optimize SSIS packages, configurations, schedules, dependencies, and execution processes.
  • Develop SQL queries, stored procedures, transformations, and reconciliation logic.
  • Use Python or another approved automation language to support ingestion, orchestration, validation, monitoring, and recovery.
  • Implement approved API integrations, including authentication, pagination, rate-limit handling, retries, and error processing.
  • Design incremental loading strategies and implement change-data capture where appropriate and approved.
  • Build and maintain raw, standardized, and curated data layers with documented transformation rules.
  • Establish source-to-target mappings, common identifier mappings, and consistent handling of reference data.
  • Implement reconciliation checks to verify record counts, totals, completeness, and transformation accuracy.
  • Develop restartable processing, controlled retries, checkpoints, and recovery procedures.
  • Implement failed-record handling, quarantine processes, error logging, and controlled reprocessing.
  • Assess and manage schema changes and their effects on pipelines, datasets, analytical models, and reports.
  • Maintain data lineage, transformation documentation, interface specifications, and pipeline dependencies.
  • Monitor pipeline execution, throughput, freshness, resource utilization, and operational failures.
  • Troubleshoot complex issues involving source systems, APIs, SSIS packages, SQL logic, data quality, and downstream integrations.
  • Optimize pipeline performance while maintaining data integrity, traceability, and approved security controls.
  • Coordinate with governance personnel on definitions, ownership, authoritative sources, metadata, and approved data uses.
  • Work with independent testing personnel to support reconciliation, regression testing, defect resolution, and release validation.
  • Coordinate pipeline changes with database, application, AI/ML, warehouse, and BI teams.
  • Maintain version-controlled code, deployment instructions, rollback procedures, and operational runbooks.
  • Review technical designs and code, guide engineering practices, and provide knowledge transfer to other engineers.
  • Communicate pipeline health, risks, dependencies, corrective actions, and improvement recommendations to technical leads and Government stakeholders.
Qualifications
Required Qualifications
  • Active Secret clearance or higher.
  • Minimum of 12 years of relevant professional experience.
  • Bachelor's degree in computer science, information systems, or a related field, or a permitted equivalent.
  • Experience maintaining and optimizing SQL Server Integration Services (SSIS).
  • Strong SQL skills.
  • Experience with Python and data engineering automation.
  • Experience implementing and supporting API integrations.
  • Experience developing incremental data loads.
  • Experience documenting and maintaining data lineage.
  • Experience troubleshooting complex data pipelines.
  • Ability to build raw, standardized, and curated data layers.
  • Ability to manage reconciliation, retries, schema changes, identifier mappings, and failed-record handling.
  • Ability to implement change-data capture where appropriate.
  • CompTIA Security+ CE or another approved IAT Level II certification when applicable to assigned duties.
Preferred Qualifications
  • Relevant data engineering or cloud platform certification.
  • Experience supporting federal or Department of Defense data environments.
  • Experience modernizing legacy SSIS integrations or transitioning pipelines to approved cloud platforms.
  • Experience with enterprise data
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data/ETL Engineer
Lead Data/ETL Engineer

DecisionPoint Corporation • United States

Remote
USD 140,000 - 180,000
Remote Lead Data & ETL Engineer (SSIS, API, Python)
Remote Lead Data & ETL Engineer (SSIS, API, Python)

DecisionPoint | Cortek • United States

Remote
USD 140,000 - 180,000
Data/ETL Engineer (Journeyman)
Data/ETL Engineer (Journeyman)

DecisionPoint Corporation • United States

Remote
USD 110,000 - 150,000
Data Analysis Task Lead
Data Analysis Task Lead

DecisionPoint | Cortek • United States

Remote
USD 120,000 - 180,000
Senior Data & ETL Architect - SSIS & API Pipelines (Remote)
Senior Data & ETL Architect - SSIS & API Pipelines (Remote)

DecisionPoint Corporation • United States

Remote
USD 140,000 - 180,000
Data and BI Developer (Senior)
Data and BI Developer (Senior)

DecisionPoint | Cortek • United States

Remote
USD 120,000 - 180,000
Data Engineer
Data Engineer

Pitech Solutions, Inc. • Huntsville (AL)

On-site
USD 85,000 - 130,000
DATA ENGINEER
DATA ENGINEER

BeyondSOF • Washington

On-site
USD 140,000 - 190,000
Data Engineer
Data Engineer

IQ Sig • Alexandria (VA)

On-site
USD 120,000 - 180,000
Health, Dental, Vision
401k w/ match
Gym Membership discounts
+2
ME00559-Data Engineer
ME00559-Data Engineer

Momentum Engineering • Washington

On-site
USD 120,000 - 160,000
11 paid holidays
Minimum of 3 weeks PTO
Company sponsored group medical plan
+4