Senior Data Migration Engineer — Petabyte-Scale Cloud ETL

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

Benefits offered by this job

Medical benefits (Full) and Dental

Vision benefits

401K

Paid time off

Sick leave

Job summary

Zachary Piper Solutions is seeking a Data Migration Engineer to lead high-complexity ETL/ELT operations for a major federal modernization program. The role designs, builds, and optimizes data migration pipelines moving multi-source datasets into modern cloud platforms, with emphasis on data quality and reliability.

This full-time, onsite position in Huntsville, Alabama partners with Cloud Engineers, Data Engineers, and DevSecOps teams to ensure successful migrations, performance, and validation

Qualifications

• Active Top Secret security clearance
• Bachelor's degree and 8+ years of experience in ETL development, data engineering, or enterprise-scale migration operations
• Strong experience with ETL tools, scripting languages, automation frameworks, and high-volume data pipelines
• Hands-on experience with legacy system extraction, cloud ingestion, and multi-format data transformation
• Proven troubleshooting skills, including pipeline diagnostics and root-cause analysis
• Ability to operate in fast-paced, multi-team environments supporting mission-critical delivery

Responsibilities

• Design, develop, optimize, and maintain scalable ETL/ELT pipelines supporting petabyte-scale data migration
• Build extraction and transformation logic for structured and unstructured datasets
• Engineer automated workflows for performance, throughput, error handling, and resiliency
• Align pipeline architecture with cloud landing zone requirements and modernization standards
• Lead operational execution of ETL tasks during migration cycles, ensuring correct sequencing and validation
• Troubleshoot pipeline failures, resolve data anomalies, and coordinate with engineering teams to stabilize operations
• Conduct readiness testing and verify integration points between legacy systems and cloud targets
• Create and maintain ETL documentation including data maps, flow diagrams, transformation logic, SOPs, and error logs
• Provide pipeline performance updates, migration status reports, and data quality metrics to leadership
• Support development of reusable processes and technical artifacts supporting repeatable migration operations

Skills

ETL development

Data engineering

Troubleshooting

Cloud ingestion

Fast-paced environments

Cross-functional collaboration

Education

Bachelor's degree

Tools

Python

PowerShell

Bash

SQL

CI/CD tooling

Job description

Zachary Piper Solutions is seeking a Data Migration Engineer to lead high-complexity ETL/ELT operations for a major federal modernization program. The role designs, builds, and optimizes data migration pipelines moving multi-source datasets into modern cloud platforms, with emphasis on data quality and reliability.

This full-time, onsite position in Huntsville, Alabama partners with Cloud Engineers, Data Engineers, and DevSecOps teams to ensure successful migrations, performance, and validation