Senior Data/ETL Engineer

DecisionPoint Corporation

. Sustain, troubleshoot, and optimize SSIS packages, configurations, schedules, and dependencies .

Posted 10/28/2026full-timeRemote • Illinois • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL and Python for data integration, transformation, and reconciliation, with a strong focus on maintaining data quality and pipeline performance. Proficient in managing SSIS packages and implementing data governance practices within federal or Department of Defense environments.

Highest-signal resume keywords

SQL Server Integration Services (SSIS)SQL Query DevelopmentPython ScriptingAPI IntegrationData Reconciliation

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQL Query DevelopmentPython ScriptingSSIS Package MaintenanceData TransformationIncremental Data LoadsData Lineage DocumentationSchema Change ManagementAutomated Regression TestingData Quality ChecksPipeline Troubleshooting

Soft Skills

TroubleshootingDocumentationCommunicationCross-Team Coordination

Tools & Technologies

APIsData WarehousesBI PlatformsCloud ServicesCI/CD ToolsVersion Control Systems

Certifications & Qualifications

Active Secret ClearanceCompTIA Security+ CEData Engineering CertificationCloud Platform Certification

Industry Keywords

Federal Data EnvironmentsDepartment of DefenseData GovernanceMetadata RepositoriesAuthoritative Sources

Tech Stack

Tools & technologies

CloudPythonSQLSSIS

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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
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 modernizing SSIS packages or migrating integrations to approved cloud services preferred
Familiarity with data governance, metadata repositories, common identifiers, and authoritative sources preferred
Experience 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

Comp & perks

Remote work arrangement
Opportunity to support mission analysis, AI capabilities, and reporting for the USMEPCOM ENLIST program