Lead Data/ETL Engineer

DecisionPoint | Cortek; Oregon; Hybrid; USD 140,000 - 190,000; Full time

Job summary

DecisionPoint is seeking a Lead Data/ETL Engineer to lead enterprise ETL pipelines, optimize SSIS, and implement API integrations for reliable data delivery. You will collaborate with DBAs, architects, governance, AI/ML engineers, BI developers, testers, and Government stakeholders to ensure accurate, traceable data pipelines supporting mission analysis and reporting.

This remote role prefers Chicago-area candidates and requires a Secret-level clearance plus 12+ years of experience in data

Qualifications

• Active Secret clearance or higher.
• 12+ years of relevant experience.
• Bachelor's degree or equivalent.
• Experience maintaining and optimizing SSIS.
• Strong SQL skills.
• Experience with Python and data engineering automation.
• Experience implementing API integrations.
• Experience developing incremental data loads.
• Experience documenting data lineage.
• Experience troubleshooting complex data pipelines.
• Ability to build raw, standardized, and curated data layers.
• Ability to manage reconciliation, retries, schema changes, and failed-record handling.
• Experience with change-data capture where appropriate.
• CompTIA Security+ CE or equivalent when applicable.

Responsibilities

• Lead the design, implementation, and optimization of enterprise ETL pipelines.
• Maintain and optimize SSIS packages, configurations, and schedules.
• Develop SQL queries, stored procedures, and transformations.
• Use Python to support ingestion, orchestration, validation, and recovery.
• Implement API integrations including authentication, pagination, and retries.
• Design incremental loading strategies and apply CDC where appropriate.
• Build raw, standardized, and curated data layers with clear transformation rules.
• Establish source-to-target mappings and data lineage.
• Implement reconciliation checks and error handling of failed records.
• Coordinate with governance, AI/ML, BI, and Government stakeholders.
• Maintain version-controlled code and deployment/runbooks.
• Review designs, mentor engineers, and communicate health and risks.

Skills

Strong SQL skills

Education

Bachelor's degree in CS or related field

Tools

SSIS

Python

API integrations

Data lineage

Change data capture

Job description

OverviewDecisionPoint seeks a Lead Data/ETL Engineer to provide technical leadership and hands-on engineering for data ingestion, transformation, integration, and delivery under the USMEPCOM ENLIST program. This SME-level position will maintain and optimize SQL Server Integration Services (SSIS), implement approved API integrations and incremental loading approaches, and build raw, standardized, and curated data layers. The engineer will establish reliable processes for reconciliation, retries, schema changes, identifier mappings, lineage, and failed-record handling. The Lead Data/ETL Engineer will collaborate with database administrators, architects, governance personnel, AI/ML engineers, BI developers, testers, and Government stakeholders to deliver accurate, traceable, and maintainable data pipelines supporting mission analysis, AI capabilities, and reporting.

This position is remote, with Chicago-area candidates preferred.

Duties & Responsibilities

The Lead Data/ETL Engineer will:

• 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 to support ingestion, orchestration, validation, monitoring, and recovery.
• Implement approved API integrations, including authentication, pagination, rate-limit handling, retries, and error processing.
• Design incremental loading strategies and implement change-data capture where appropriate and approved.
• Build and maintain raw, standardized, and curated data layers with documented transformation rules.
• Establish source-to-target mappings, common identifier mappings, and consistent handling of reference data.
• Implement reconciliation checks to verify 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 their effects 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.
• Work with independent testing personnel to support reconciliation, regression testing, defect resolution, and release validation.
• 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.

Qualifications

Required Qualifications

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

Preferred Qualifications

• Relevant data engineering or cloud platform certification.
• Experience supporting federal or Department of Defense data environments.
• Experience modernizing legacy SSIS integrations or transitioning pipelines to approved cloud platforms.
• Experience with enterprise data warehouses, analytical datasets, BI platforms, or AI-ready data.
• Familiarity with data catalogs, metadata management, data governance, and automated lineage tools.
• Experience developing automated data-quality checks, reconciliation frameworks, and pipeline regression tests.
• Experience integrating data engineering workflows with CI/CD, version control, and automated deployment.
• Experience implementing secure service accounts, secrets management, encryption, and pipeline audit logging.
• Strong technical mentoring, documentation, troubleshooting, and stakeholder communication skills.

Our Equal Employment Opportunity Policy

• * EEO and Aff … DecisionPoint Corporation is an Equal Employment Opportunity and Affirmative Action employer. It is the policy of DecisionPoint Corporation to provide equal employment opportunity in accordance with all applicable Equal Employment Opportunity/Affirmative Action laws, directives and regulations to all employees and qualified applicants without regard to race, ethnicity, color, religion, national origin, sex, age, disability status, pregnancy, sexual orientation, gender identity, genetic information, protected veteran status, or any other protected status under Federal, State or Local laws.
• * Pay Transparency Policy: In accordance with Presidential Executive Order 13665, DecisionPoint Corporation will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.