Lead Data – ETL Engineer

Vaga não está no LinkedIn

🕒 Ontem

🌽 Illinois – Remoto

🌽 Illinois – Remote

⏰ Tempo Integral

🟠 Sênior

📊 Engenheiro de Analytics

🦅 Patrocina Visto H1B

Esta empresa já patrocinou vistos H1B no passado.

👻 Score fantasma 25%

O que significa: a chance de ninguém estar realmente contratando para esta vaga.Como ler: 60% ou mais significa que achamos que é uma vaga fantasma. Pontuações mais baixas preocupam menos.Como pontuamos: tempo em aberto, republicações, vagas abertas vs tamanho do time, rapidez para fechar vagas, e se o salário está divulgado.Observação: é uma estimativa de dados públicos, não um julgamento da empresa. Vagas reais podem ter pontuação alta, então use como uma dica, não como um fato.

Candidatar-se

Encontrar Vagas Remotas Similares

DecisionPoint Corporation

SiteLinkedInTodas as Vagas

51 - 200 funcionários

Fundada em 2011

🎖️ Defesa

💼 Consultoria

📦 Logística

Defense • Consulting • Logistics

A DecisionPoint Corporation é uma Pequena Empresa de Propriedade de Veteranos com Deficiência em Serviço, especializada em modernização de TI e transformação digital para agências governamentais. Eles oferecem serviços abrangentes, incluindo cibersegurança, TI para saúde e soluções de automação inteligente, visando melhorar a eficiência e a eficácia operacional, ao mesmo tempo em que garantem uma migração segura para a nuvem. Sua abordagem de Centros de Excelência impulsiona o sucesso da missão, abordando os desafios mais urgentes enfrentados por entidades governamentais por meio de tecnologia inovadora e suporte especializado.

Descrição

• 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

🎯 Requisitos

• 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

🏖️ Benefícios

• 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

📊 Verifique sua pontuação de currículo para esta vaga

Melhore suas chances de conseguir uma entrevista verificando sua pontuação de currículo antes de se candidatar.

Enviar Currículo