Senior Data/ETL Engineer - SSIS & Pipelines (Remote)

DecisionPoint Corporation; United States; Remote; USD 120.000 - 180.000; Vollzeit

Zusammenfassung

DecisionPoint Corporation seeks a Senior Data/ETL Engineer to sustain SSIS pipelines, develop data integrations, and maintain reliable data flows for USMEPCOM ENLIST. The role involves implementing raw, standardized, and curated data layers using SQL, Python, APIs, and incremental loading techniques, with emphasis on data lineage, reconciliation, and governance.

Remote work is available, preference for Chicago-area candidates.

Qualifikationen

• Active Secret clearance or higher is required.
• Eight years of relevant professional experience.
• Experience maintaining and supporting SSIS.
• Strong SQL and Python skills.
• Experience building or supporting API integrations.
• Experience implementing incremental data loads.
• Experience reconciling data and managing schema changes.

Aufgaben

• Sustain, troubleshoot, and optimize SSIS packages, configurations, schedules, and dependencies.
• Develop and maintain approved data integrations between source systems, databases, APIs, and analytics environments.
• Write SQL queries, stored procedures, transformations, and reconciliation routines.
• Develop Python scripts for data ingestion, processing, validation, orchestration, and automation.
• Implement raw, standardized, and curated data layers with documented transformation rules.
• Build and maintain incremental loads with checkpoints and tracking.

Kenntnisse

Active Secret clearance

SSIS

SQL

Python

API integrations

Incremental data loads

Data reconciliation

Data lineage

Troubleshooting pipelines

Raw/standardized/curated data layers

Ausbildung

Bachelor’s degree in computer science, information systems, or a related field

Equivalent experience

Tools

SSIS

SQL Server

Python

APIs

CI/CD tools

Git

Jobbeschreibung

DecisionPoint Corporation seeks a Senior Data/ETL Engineer to sustain SSIS pipelines, develop data integrations, and maintain reliable data flows for USMEPCOM ENLIST. The role involves implementing raw, standardized, and curated data layers using SQL, Python, APIs, and incremental loading techniques, with emphasis on data lineage, reconciliation, and governance.

Remote work is available, preference for Chicago-area candidates.