Senior Data & ETL Architect - SSIS & API Pipelines (Remote)

DecisionPoint Corporation

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 Corporation 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 remote role prefers Chicago‑area candidates and emphasizes reliable SSIS maintenance, API integrations, incremental loading, data lineage, and robust error handling.

The role collaborates with DBAs, architects, governance personnel, AI/ML engineers, BI teams, testers, and

Qualifications

  • Active Secret clearance or higher.
  • Minimum of 12 years of relevant professional experience.
  • 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.

Responsibilities

  • Lead 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.

Skills

SQL
Python
API integrations
Data pipelines
SSIS
Data lineage
Incremental loads
Troubleshooting
Security+ CE

Education

Bachelor's degree in computer science, information systems, or related field

Tools

SSIS
SQL Server

Job description

DecisionPoint Corporation 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 remote role prefers Chicago‑area candidates and emphasizes reliable SSIS maintenance, API integrations, incremental loading, data lineage, and robust error handling.

The role collaborates with DBAs, architects, governance personnel, AI/ML engineers, BI teams, testers, and

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data/ETL Engineer - SSIS & Pipelines (Remote)
Senior Data/ETL Engineer - SSIS & Pipelines (Remote)

DecisionPoint Corporation • United States

Remote
USD 120,000 - 180,000
Remote Data/ETL Engineer — SSIS, Python & Pipelines
Remote Data/ETL Engineer — SSIS, Python & Pipelines

DecisionPoint Corporation • United States

Remote
USD 110,000 - 150,000
Lead Data/ETL Engineer
Lead Data/ETL Engineer

DecisionPoint Corporation • 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
Senior Data & BI Developer - Remote with Power BI Focus
Senior Data & BI Developer - Remote with Power BI Focus

DecisionPoint Corporation • United States

Remote
USD 120,000 - 180,000
Remote Senior Secure API & Data Integration Lead
Remote Senior Secure API & Data Integration Lead

DecisionPoint Corporation • United States

Remote
USD 120,000 - 125,000
Data/ETL Engineer (Senior)
Data/ETL Engineer (Senior)

DecisionPoint Corporation • United States

Remote
USD 120,000 - 180,000
Remote Data & BI Documentation Specialist
Remote Data & BI Documentation Specialist

DecisionPoint Corporation • United States

Remote
USD 90,000 - 130,000
Remote: Senior Integration & API Test Automation Engineer
Remote: Senior Integration & API Test Automation Engineer

DecisionPoint Corporation • United States

Remote
USD 110,000 - 150,000
Senior Data Engineer: Data Pipelines & Integrations
Senior Data Engineer: Data Pipelines & Integrations

FI Consulting • Arlington (VA)

On-site
USD 150,000 - 200,000