Lead Data – ETL Engineer

Job not on LinkedIn

🔥 11 minutes ago

🌽 Illinois – Remote

🌽 Illinois – Remote

⏰ Full Time

🟠 Senior

📊 Analytics Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 25%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

DecisionPoint Corporation

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2011

🎖️ Defense

💼 Consulting

📦 Logistics

Defense • Consulting • Logistics

DecisionPoint Corporation is a Service Disabled Veteran Owned Small Business specializing in IT modernization and digital transformation for government agencies. They provide comprehensive services including cybersecurity, health IT, and intelligent automation solutions, aimed at improving operational efficiency and effectiveness while ensuring secure cloud migration. Their Centers of Excellence approach drives mission success by addressing the most pressing challenges faced by government entities through innovative technology and expert support.

📋 Description

• 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

• 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

• 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