Data/ETL Engineer (Journeyman) at Careers Decisionpointcorp, Chicago, IL
Data/ETL Engineer (Journeyman) at Careers Decisionpointcorp in Chicago, IL. Full-time. Est. up to $160k. Apply with swipeandhired.
Data/ETL Engineer (Journeyman)
ID
2026-4315
Job Locations
US-IL-Chicago
Category
Information Technology
Type
Regular Full-Time
Overview
DecisionPoint seeks a Journeyman Data/ETL Engineer to develop and maintain extract, transform, and load workflows supporting the USMEPCOM ENLIST program.
This position will sustain SQL Server Integration Services (SSIS), build approved integrations, and implement raw, standardized, and curated data layers. The engineer will use SQL and Python to transform data, support API integrations, perform reconciliation checks, manage schema changes, maintain lineage, and troubleshoot pipeline issues.
The Data/ETL Engineer will work with senior engineers, database administrators, data governance personnel, BI developers, AI/ML teams, and testers to deliver accurate, traceable, and maintainable data for mission analysis 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
The Journeyman Data/ETL Engineer will:
- 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 escalate complex issues to senior engineers.
- Correct assigned defects and support regression testing, reconciliation, and release validation.
- <span d