Data/ETL Engineer (Senior)

DecisionPoint Corporation; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

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.

Qualifications

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

Responsibilities

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

Skills

Active Secret clearance

SSIS

SQL

Python

API integrations

Incremental data loads

Data reconciliation

Data lineage

Troubleshooting pipelines

Raw/standardized/curated data layers

Education

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

Equivalent experience

Tools

SSIS

SQL Server

Python

APIs

CI/CD tools

Git

Job description

OverviewDecisionPoint seeks a Senior Data/ETL Engineer to sustain SQL Server Integration Services (SSIS), develop approved integrations, and maintain reliable data pipelines supporting the USMEPCOM ENLIST program.

This position will implement raw, standardized, and curated data layers using SQL, Python, APIs, and incremental loading techniques. The engineer will reconcile data, manage schema changes, maintain lineage, and troubleshoot complex pipeline failures to support accurate and timely mission analysis, AI capabilities, and reporting.

The Senior Data/ETL Engineer will work with the Lead Data/ETL Engineer, database administrators, data governance personnel, AI/ML engineers, BI developers, testers, and Government stakeholders to maintain secure, traceable, and supportable data integrations.

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

Note: By applying to this position, you acknowledge and consent to having your resume included in an active competitive government contract bid.

Duties & Responsibilities

The Senior Data/ETL Engineer will:

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

Required Qualifications

The following must-have qualifications are drawn from the supplied position 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.

Preferred Qualifications

• Relevant data engineering or cloud platform certification.
• Experience supporting federal or Department of Defense data environments.
• Experience with enterprise data warehouses, analytical datasets, BI platforms, or AI-ready data.
• Experience modernizing SSIS packages or migrating integrations to approved cloud services.
• Familiarity with data governance, metadata repositories, common identifiers, and authoritative sources.
• Experience developing automated reconciliation tests, data-quality checks, and pipeline regression tests.
• Experience with CI/CD, version control, automated deployment, and rollback processes.
• Familiarity with secure service accounts, secrets management, encryption, and audit logging.
• Strong troubleshooting, documentation, communication, and cross-team coordination skills.

Equal Employment Opportunity Policy

EEO and Affinity Policy: the company is an Equal Employment Opportunity and Affinity Action employer. It is the policy of the company 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, the company 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.

Authorization to Share Resume and Personal Information

Authorization to Share Resume and Personal Information: By expressing your interest and submitting your resume for this position, you authorize the company to share your resume, as well as personal information included on the resume, with its subsidiaries, affiliates and teaming partners for the purpose of considering you for this position and other available positions requiring comparable skills, education and experience. Should the company or its affiliates and teaming partners wish to initiate pre-employment discussions, you will be asked to complete an employment application and related employment documents.