Data Migration Engineer

Zachary Piper Solutions is seeking a Data Migration Engineer who will lead high complexity extract, transform, and load (ETL) operations supporting a major federal modernization program. This role is responsible for architecting, operating, validating, and optimizing data migration pipelines that move high volume, multi-source datasets from legacy environments into modern cloud platforms. The engineer serves as a senior technical contributor within the Migration Workstream, ensuring data quality, performance, and reliability throughout large scale migration cycles.

This is a full time position that is fully onsite in Huntsville, Alabama.

ETL Pipeline Architecture & Execution

• 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.
• Data Migration Operations
• 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.
• Data Quality, Validation & Governance
• Perform detailed data quality checks, completeness assessments, and validation of migrated data.
• Lead root cause analysis for data defects and support corrective actions across the migration workflow.
• Document recurring issues, improve detection processes, and help define quality benchmarks.
• Cross Functional Technical Collaboration
• Partner with Cloud Engineers, Data Engineers, Dev Sec Ops  teams, DBAs, QA/Test Engineers, and Product Owners.
• Ensure ETL pipelines integrate seamlessly with cloud architectures, data models, monitoring tools, and downstream systems.
• Participate in sprint ceremonies, technical reviews, and migration planning activities.
• Documentation & Reporting
• 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.

• Must have 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.

• Experience supporting federal modernization programs including DOJ, FBI, or Intelligence Community.
• Experience operating ETL pipelines within AWS or other cloud environments.
• Familiarity with Dev Sec Ops  workflows, CI/CD pipelines, and distributed compute tools.
• Advanced scripting or automation expertise (Python, Bash, Power Shell, etc.).

• Salary Range: $135,000 - $175,000 depending on experience
• Full Benefits: Medical, Dental, Vision, 401K, PTO, Sick Leave if Required by Law

This job opens for applications on 9/29/2026. Applications for this position will be accepted for at least 30 days from the posting date.

#LI-CB1

#LI-ONSITE

#/CD, Data Integration, Big Data, Structured Data, Unstructured Data, Data Transformation, Root Cause Analysis, Performance Optimization, Data Architecture, Enterprise Migration, Cloud Platforms, Database Migration, Data Operations, Migration Engineering, High-Volume Data Processing, Petabyte Scale Data Migration.