Lead Data – ETL Engineer

DecisionPoint Corporation

. Lead the design, implementation, maintenance, and optimization of enterprise data integration and ETL pipelines .

Posted 10/28/2026full-timeRemote • Illinois • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and optimizing enterprise data integration and ETL pipelines, with strong capabilities in SQL, Python, and API integrations. Proficient in maintaining data lineage, implementing change-data capture, and troubleshooting complex data issues.

Highest-signal resume keywords

SQL Server Integration Services (SSIS)SQL DevelopmentPython AutomationAPI IntegrationData Lineage Documentation

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL Pipeline DesignSQL QueriesStored ProceduresIncremental Data LoadsChange-Data CaptureData TransformationReconciliation LogicError HandlingSchema ManagementData Quality Troubleshooting

Soft Skills

CommunicationCollaborationProblem-SolvingKnowledge Transfer

Tools & Technologies

SSISSQL ServerPythonAPI Management

Certifications & Qualifications

Active Secret ClearanceCompTIA Security+ CE

Industry Keywords

Data IntegrationData EngineeringData QualityMetadata ManagementOperational Monitoring

Tech Stack

Tools & technologies

ETLPythonSQLSSIS

About the role

Key responsibilities & impact

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 for ingestion, orchestration, validation, monitoring, and recovery
Implement API integrations, including authentication, pagination, rate-limit handling, retries, and error processing
Design incremental loading strategies and implement change-data capture where appropriate
Build and maintain raw, standardized, and curated data layers with documented transformation rules
Establish source-to-target mappings, common identifier mappings, and reference-data handling
Implement reconciliation checks for 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 impacts 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
Support reconciliation, regression testing, defect resolution, and release validation with independent testing personnel
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

Requirements

What you’ll need

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

Benefits

Comp & perks

Regular full-time employment
Opportunity to provide technical leadership and hands-on engineering on a USMEPCOM ENLIST government program
Knowledge transfer and technical mentoring opportunities
Equal employment opportunity and affirmative action protections