Senior Data/ETL Engineer

Job not on LinkedIn

🔥 33 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

• Sustain, troubleshoot, and optimize SSIS packages, configurations, schedules, and dependencies • Develop and maintain approved integrations between source systems, databases, APIs, analytical environments, and reporting platforms • Write SQL queries, stored procedures, transformations, and reconciliation routines • Develop Python scripts for data ingestion, processing, validation, orchestration, and operational automation • Implement raw, standardized, and curated data layers with documented transformation rules • Build and maintain incremental loads, including checkpoints and tracking of previously processed data • Implement API authentication, pagination, retry handling, logging, and error processing • Reconcile source and target data using record counts, totals, completeness checks, and business rules • Manage schema changes and assess their effects on pipelines, datasets, integrations, and reporting outputs • Maintain source-to-target mappings, identifier mappings, metadata, and data lineage • Implement controls for duplicate, missing, invalid, or failed records and support controlled reprocessing • Monitor pipeline execution, data freshness, processing performance, and operational errors • Investigate complex failures involving SSIS, SQL, APIs, source data, transformations, and downstream dependencies • Implement approved corrections and validate successful processing and reconciliation • Coordinate changes with database, application, governance, AI/ML, BI, and testing teams • Support automated regression testing, data-quality checks, defect resolution, and release validation • Maintain version-controlled code, deployment instructions, rollback procedures, and operational runbooks • Provide technical status, troubleshooting findings, risks, and improvement recommendations to the technical lead and Government stakeholders

🎯 Requirements

• Active Secret clearance or higher • Minimum of eight years of relevant professional experience • Bachelor’s degree in computer science, information systems, or a related field, or a permitted equivalent • Experience maintaining and supporting SQL Server Integration Services (SSIS) • Strong SQL and Python skills • Experience building or supporting API integrations • Experience implementing incremental data loads • Experience performing data reconciliation and managing schema changes • Experience documenting and maintaining data lineage • Experience troubleshooting complex 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 or cloud platform certification preferred • Experience supporting federal or Department of Defense data environments preferred • Experience with enterprise data warehouses, analytical datasets, BI platforms, or AI-ready data preferred • Experience modernizing SSIS packages or migrating integrations to approved cloud services preferred • Familiarity with data governance, metadata repositories, common identifiers, and authoritative sources preferred • Experience developing automated reconciliation tests, data-quality checks, and pipeline regression tests preferred • Familiarity with CI/CD, version control, automated deployment, and rollback processes preferred • Familiarity with secure service accounts, secrets management, encryption, and audit logging preferred • Strong troubleshooting, documentation, communication, and cross-team coordination skills preferred

🏖️ Benefits

• Remote work arrangement • Opportunity to support mission analysis, AI capabilities, and reporting for the USMEPCOM ENLIST program