Data/ETL Engineer – Journeyman

🕒 Ontem

🌽 Illinois – Remoto

🌽 Illinois – Remote

⏰ Tempo Integral

🟡 Pleno

🟠 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

• 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 • 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

🎯 Requisitos

• Active Secret clearance or higher • Minimum of 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 • Relevant data engineering certification is preferred • Experience supporting federal or Department of Defense data environments is preferred • Experience with data warehouses, analytical datasets, BI platforms, or AI-ready data is preferred • Experience implementing incremental loads, checkpoints, retries, and failed-record handling is preferred • Familiarity with metadata management, data governance, common identifiers, and authoritative sources is preferred • Experience developing automated data-quality and regression checks is preferred • Familiarity with version control, CI/CD, deployment automation, and rollback processes is preferred • Familiarity with secure API authentication, service accounts, secrets management, and audit logging is preferred • Strong troubleshooting, documentation, communication, and cross-team coordination skills are preferred

🏖️ Benefícios

• Regular full-time employment • Opportunity to work remotely • Chicago-area candidates preferred • Opportunity to support a USMEPCOM ENLIST government contract program • 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