Senior ETL & Data Migration Architect

Zachary Piper Solutions; Huntsville (AL); Hybrid; USD 165,000 - 185,000; Full time

Job summary

Zachary Piper Solutions is seeking a Senior ETL & Data Migration Engineer to support large-scale federal modernization, cloud transformation, and enterprise data migration initiatives. This on-site role is in Huntsville, AL, and focuses on designing and optimizing enterprise ETL pipelines to migrate high-volume datasets from legacy systems into modern cloud platforms.

You will lead extraction, transformation, validation, and migration activities, collaborate with Cloud Engineers, Data

Qualifications

• 8+ years of experience in ETL development, data engineering, data integration, or enterprise-scale migration operations.
• Strong experience with ETL tools, automation frameworks, scripting languages, and high-volume data pipelines.
• Bachelor's degree in Computer Science, Information Systems, Engineering, or related technical discipline.
• Active Top Secret Security Clearance and U.S. Citizenship required.

Responsibilities

• Design, develop, optimize, and maintain scalable ETL/ELT pipelines supporting large-scale data migration efforts.
• Lead data extraction, transformation, validation, and migration activities across structured and unstructured data sources.
• Troubleshoot pipeline failures, perform root cause analysis, and implement performance and reliability improvements.
• Collaborate with Cloud Engineers, Data Engineers, DevSecOps teams, DBAs, and QA teams to support migration readiness and integration efforts.
• Create and maintain technical documentation, migration reports, data maps, SOPs, and data quality metrics.

Skills

ETL development

Data engineering

Data integration

Scripting languages

High-volume data pipelines

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or related technical discipline

Tools

ETL tools

Automation frameworks

Python

Bash

PowerShell

SQL

Job description

Zachary Piper Solutions is seeking a Senior ETL & Data Migration Engineer to support large-scale federal modernization, cloud transformation, and enterprise data migration initiatives. This on-site role is in Huntsville, AL, and focuses on designing and optimizing enterprise ETL pipelines to migrate high-volume datasets from legacy systems into modern cloud platforms.

You will lead extraction, transformation, validation, and migration activities, collaborate with Cloud Engineers, Data