Senior Data Migration Architect - ETL & Cloud

ZP Group; Huntsville (AL); On-site; USD 135,000 - 180,000; Full time

Job summary

Zachary Piper Solutions is seeking a Data Migration Engineer to lead high-complexity ETL operations for a major federal modernization program. The role focuses on architecting, operating, validating, and optimizing data migration pipelines from legacy environments into modern cloud platforms, ensuring data quality, performance, and reliability.

The position is full-time and fully onsite in Huntsville, Alabama, requiring active security clearance and strong collaboration with Cloud and Data teams

Qualifications

• Bachelor’s degree and 8+ years of experience in ETL development or data migration.
• Active Top Secret clearance required.
• Experience with high-volume data pipelines and legacy system extraction.

Responsibilities

• Design, develop, optimize, and maintain scalable ETL/ELT pipelines supporting petabyte scale data migration.
• Lead operational execution of ETL tasks during migration cycles, ensuring correct sequencing and validation.
• Perform detailed data quality checks and validation of migrated data; lead root cause analysis for data defects.
• Collaborate with Cloud Engineers, Data Engineers, DevSecOps, DBAs, QA/Test Engineers, and Product Owners.

Skills

ETL pipelines

Data engineering

Cloud data migration

Automation scripting

SQL

Education

Bachelor’s degree

Tools

AWS

Python

Bash

PowerShell

SQL

Job description

Zachary Piper Solutions is seeking a Data Migration Engineer to lead high-complexity ETL operations for a major federal modernization program. The role focuses on architecting, operating, validating, and optimizing data migration pipelines from legacy environments into modern cloud platforms, ensuring data quality, performance, and reliability.

The position is full-time and fully onsite in Huntsville, Alabama, requiring active security clearance and strong collaboration with Cloud and Data teams