Remote Data/ETL Engineer — SSIS, Python & Pipelines

DecisionPoint Corporation

United States

Remote

USD 110,000 - 150,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 seeks a Journeyman Data/ETL Engineer to develop and maintain ETL workflows using SSIS, SQL, and Python. You will build and support data layers, mappings, and reconciliations for mission-critical analytics and reporting. Remote work is available with Chicago-area candidates preferred.

Required clearance and 6+ years of experience, plus a CS/IS degree or equivalent. Collaboration across governance, BI, AI/ML, and testing teams is essential for data quality and lineage.

Qualifications

  • Active Secret clearance or higher.
  • Six years of relevant professional experience.
  • Bachelor's degree in computer science, information systems, or a related field, or a permitted equivalent.
  • Experience developing and maintaining ETL workflows.
  • Experience supporting SQL Server Integration Services (SSIS).
  • Strong SQL skills, including experience developing SQL transformations.
  • Experience with Python and API integrations.
  • Experience developing and maintaining data mappings.
  • Experience building and executing reconciliation checks.
  • Experience maintaining pipeline documentation and data lineage.
  • Ability to support schema management and troubleshoot data pipelines.
  • Ability to implement raw, standardized, and curated data layers.
  • CompTIA Security+ CE or another approved IAT Level II certification when applicable to assigned duties.

Responsibilities

  • Develop, maintain, and troubleshoot ETL workflows using SSIS and approved integration tools.
  • Implement approved integrations between source systems, APIs, databases, and analytical or reporting environments.
  • Write and maintain SQL transformations, queries, and supporting database routines.
  • Use Python to automate data processing, validation, integration, and routine pipeline activities.
  • Implement raw, standardized, and curated data layers using approved designs and transformation rules.
  • Develop and maintain source-to-target mappings, field mappings, and identifier mappings.
  • Build reconciliation checks to verify record counts, totals, completeness, and transformation accuracy.
  • Support incremental loading, processing checkpoints, retries, and controlled reprocessing.
  • Implement approved schema changes and identify effects on dependent workflows and datasets.
  • Maintain data lineage, pipeline documentation, configuration records, and operating instructions.
  • Monitor scheduled processing, execution results, data freshness, and pipeline errors.
  • Investigate failures involving source data, SQL logic, SSIS packages, APIs, and downstream dependencies.
  • Document troubleshooting findings and elevate complex issues to senior engineers.
  • Correct assigned defects and support regression testing, reconciliation, and release validation.
  • Maintain version-controlled code and support approved deployment and rollback procedures.
  • Coordinate with governance, database, BI, AI/ML, and testing teams on data definitions, dependencies, and quality issues.
  • Update runbooks and technical documentation following pipeline changes and operational findings.

Skills

SSIS
SQL
Python
API integrations
Data mappings
Data lineage
Reconciliation checks
Troubleshooting

Education

Bachelor's degree in computer science or related field
Permitted equivalent

Tools

SSIS
SQL Server
Python

Job description

DecisionPoint Corporation seeks a Journeyman Data/ETL Engineer to develop and maintain ETL workflows using SSIS, SQL, and Python. You will build and support data layers, mappings, and reconciliations for mission-critical analytics and reporting. Remote work is available with Chicago-area candidates preferred.

Required clearance and 6+ years of experience, plus a CS/IS degree or equivalent. Collaboration across governance, BI, AI/ML, and testing teams is essential for data quality and lineage.

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
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/ETL Engineer (Journeyman)
Data/ETL Engineer (Journeyman)

DecisionPoint Corporation • United States

Remote
USD 110,000 - 150,000
Remote Data Engineer: Scalable ETL & Python Pipelines
Remote Data Engineer: Scalable ETL & Python Pipelines

Crossing Hurdles • United States

Remote
USD 41,328 - 123,984
Remote Data Engineer — ETL, Data Warehousing, Pipelines
Remote Data Engineer — ETL, Data Warehousing, Pipelines

ITD Technology Co. • San Jose (CA)

Remote
USD 120,000 - 160,000
Medical benefits
401k plan
Paid holidays
Remote Data Engineer — Python, PySpark & Snowflake Pipelines
Remote Data Engineer — Python, PySpark & Snowflake Pipelines

TMS, LLC • United States

Remote
USD 120,000 - 160,000
Remote work permitted
ETL Data Engineer with TS/SCI Clearance & Secure Pipelines
ETL Data Engineer with TS/SCI Clearance & Secure Pipelines

Quantum Technologies. LLC • Reston (VA)

On-site
USD 110,000 - 150,000
Remote Data Engineer — AWS Pipelines & Analytics
Remote Data Engineer — AWS Pipelines & Analytics

International Consulting Associates, Inc • Arlington (VA)

Remote
USD 110,000 - 160,000
Health Insurance
401(k) plan
Remote work (US)
Data Engineer: AWS Cloud Data Pipelines
Data Engineer: AWS Cloud Data Pipelines

Kda Consulting • Chantilly (VA)

On-site
USD 90,000 - 120,000
Data Engineer
Data Engineer

Robotics Technologies • Chicago (IL)

On-site
USD 90,000 - 110,000