Senior Data/ETL Engineer

This is a fully remote position, open to applicants in Illinois.

📋 Description

• Maintain, troubleshoot, and enhance SSIS packages, configurations, schedules, and dependencies.

• Create and uphold approved integrations among 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.

• Construct and manage incremental loads, including checkpoints and tracking of previously processed data.

• Execute API authentication, pagination, retry handling, logging, and error processing.

• Reconcile source and target data through record counts, totals, completeness checks, and business rules.

• Oversee schema changes and evaluate their impact on pipelines, datasets, integrations, and reporting outputs.

• Maintain source-to-target mappings, identifier mappings, metadata, and data lineage.

• Establish controls for duplicate, missing, invalid, or failed records and assist with 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 verify 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 updates, troubleshooting findings, risks, and improvement recommendations to the technical lead and Government stakeholders.

⛳️ Requirements

• Active Secret clearance or higher.

• A minimum of eight years of relevant professional experience.

• Bachelor’s degree in computer science, information systems, or a related field, or an accepted equivalent.

• Experience in maintaining and supporting SQL Server Integration Services (SSIS).

• Strong skills in SQL and Python.

• Experience in building or supporting API integrations.

• Experience in implementing incremental data loads.

• Experience in performing data reconciliation and managing schema changes.

• Experience in documenting and maintaining data lineage.

• Experience in troubleshooting complex data pipelines.

• Capability 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 in modernizing SSIS packages or migrating integrations to approved cloud services preferred.

• Familiarity with data governance, metadata repositories, common identifiers, and authoritative sources preferred.

• Experience in 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.