Sr. ETL & Data Migration Engineer

Zachary Piper Solutions; Huntsville (AL); On-site; USD 140,000 - 150,000; Full time

Benefits offered by this job

PTO

Paid Holidays

Medical

Dental

Vision

401k

Tuition Reimbursement

Sick Leave

Job summary

Zachary Piper Solutions is seeking a Senior ETL & Data Migration Engineer to join a federal IT consulting organization supporting an FBI modernization program in Huntsville, Alabama. This 100% onsite role focuses on moving high-volume legacy datasets into a secure AWS cloud environment and developing reliable migration pipelines for mission-critical data.

Responsibilities include designing and optimizing ETL/ELT pipelines, automating workflows, troubleshooting migrations, and ensuring data

Qualifications

• Bachelor’s degree and 8+ years of hands‑on experience in ETL development, data migration, or large-scale data engineering.
• Experience designing and operating advanced ETL/ELT pipelines using data integration tools, scripting languages, and automation frameworks.
• Expertise in structured and unstructured data transformation, cleansing, mapping, and validation.
• Experience extracting data from legacy systems, supporting cloud ingestion, and working with big data tools; AWS experience preferred.
• Federal modernization, petabyte‑scale migration, Python, Bash, PowerShell, and DevSecOps/CI/CD experience preferred.
• Must have an active Top Secret security clearance.

Responsibilities

• Design, build, and optimize scalable ETL/ELT pipelines to migrate structured and unstructured datasets from legacy systems into cloud environments.
• Automate extraction, transformation, and ingestion workflows with effective sequencing, error handling, recovery, and performance monitoring.
• Execute migration cycles, troubleshoot pipeline failures, and resolve data anomalies in collaboration with engineering teams.
• Validate migrated data for accuracy and completeness, investigate defects, and implement repeatable data quality checks.
• Partner with Cloud, DevSecOps, DBA, and QA teams while maintaining data mappings, transformation documentation, operational procedures, and migration status reports.

Skills

ETL development

Data migration

Large-scale data engineering

Python

Bash

PowerShell

DevSecOps/CICD

Top Secret clearance

Education

Bachelor’s degree

Tools

AWS

SQL

Job description

Zachary Piper Solutions is seeking a Senior ETL & Data Migration Engineer to join a federal IT consulting organization supporting an FBI modernization program in Huntsville, Alabama. This 100% onsite role focuses on moving high-volume legacy datasets into a secure AWS cloud environment. The Senior ETL & Data Migration Engineer will develop reliable migration pipelines and help modernize critical systems used to store, manage, and analyze mission-sensitive data.

Responsibilities of the Senior ETL & Data Migration Engineer Include:

• Design, build, and optimize scalable ETL/ELT pipelines to migrate structured and unstructured datasets from legacy systems into cloud environments.
• Automate extraction, transformation, and ingestion workflows with effective sequencing, error handling, recovery, and performance monitoring.
• Execute migration cycles, troubleshoot pipeline failures, and resolve data anomalies in collaboration with engineering teams.
• Validate migrated data for accuracy and completeness, investigate defects, and implement repeatable data quality checks.
• Partner with Cloud, DevSecOps, DBA, and QA teams while maintaining data mappings, transformation documentation, operational procedures, and migration status reports.

Qualifications for the Senior ETL & Data Migration Engineer Include:

• Bachelor’s degree and 8+ years of hands‑on experience in ETL development, data migration, or large-scale data engineering.
• Strong experience designing and operating advanced ETL/ELT pipelines using data integration tools, scripting languages, and automation frameworks.
• Expertise in structured and unstructured data transformation, cleansing, mapping, and validation.
• Experience extracting data from legacy systems, supporting cloud ingestion, and working with big data tools; AWS experience preferred.
• Proven pipeline diagnostics and root cause analysis skills. Federal modernization, petabyte‑scale migration, Python, Bash, PowerShell, and DevSecOps/CI/CD experience preferred.
• Must have an active Top Secret security clearance.

Compensation and Benefits for the Senior ETL & Data Migration Engineer Include:

• Salary Range: $140,000–$150,000 annually, depending on experience.
• Comprehensive Benefits: PTO, Paid Holidays, Medical, Dental, Vision, 401k, Tuition Reimbursement, and Sick Leave as Required by Law.

This job opens for applications October 19, 2026. Applications for this job will be accepted for at least 30 days from the posting date.

Keywords: senior ETL engineer, senior ETL data migration engineer, ETL data migration engineer, senior data migration engineer, data migration engineer, ETL developer, senior data engineer, data engineering, data integration engineer, data pipeline engineer, ETL, ELT, extract transform load, extract load transform, data migration, legacy modernization, cloud migration, cloud ingestion, AWS, Amazon Web Services, structured data, unstructured data, data transformation, data cleansing, data validation, data quality, data integrity, data mapping, high-volume data, petabyte‑scale migration, big data, distributed computing, pipeline development, pipeline optimization, pipeline automation, Python, SQL, Bash, PowerShell, DevSecOps, CI/CD, root cause analysis, federal modernization, FBI modernization, active clearance, security clearance, onsite, Huntsville, AL, Alabama

#LI-MR1 #LI-ONSITE