Remote Data ETL Engineer | SSIS, SQL & Python

DecisionPoint | Cortek; Oregon; Hybrid; USD 120,000 - 150,000; Full time

Job summary

DecisionPoint Corporation seeks a Journeyman Data/ETL Engineer to develop and maintain SSIS workflows and data pipelines for the USMEPCOM ENLIST program. You will transform data with SQL and Python, support API integrations, and maintain data lineage and documentation.

In this remote role, you will collaborate with senior engineers, DBAs, governance teams, BI developers, and AI/ML groups to ensure accurate, traceable data for mission analysis and reporting. A Secret clearance is required.

Qualifications

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

Responsibilities

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

Skills

SQL

Python

ETL

Data mapping

APIs

Data governance

Troubleshooting

Documentation

Cross-team coordination

Communication

Education

Bachelor's degree

Equivalent experience

Tools

SSIS

SQL Server

CI/CD

Git

Job description

DecisionPoint Corporation seeks a Journeyman Data/ETL Engineer to develop and maintain SSIS workflows and data pipelines for the USMEPCOM ENLIST program. You will transform data with SQL and Python, support API integrations, and maintain data lineage and documentation.

In this remote role, you will collaborate with senior engineers, DBAs, governance teams, BI developers, and AI/ML groups to ensure accurate, traceable data for mission analysis and reporting. A Secret clearance is required.