Data Migration Engineer - 175465

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

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401K plan

PTO

Job summary

Zachary Piper Solutions is seeking a Data Migration Engineer to lead complex ETL/ELT operations for a federal modernization program. The role focuses on architecting, operating, validating, and optimizing data migration pipelines moving large, multi-source datasets into modern cloud platforms.

This onsite Huntsville position requires senior expertise in data quality, governance, and performance. You will collaborate with Cloud Engineers, Data Engineers, DevSecOps, DBAs, QA, and Product Owners to

Qualifications

• Active Top Secret Clearance is required.
• Bachelor’s degree and 8+ years of ETL/data migration experience.
• Experience with high-volume data pipelines, cloud ingestion, and legacy-to-cloud migration.

Responsibilities

• Design, develop, optimize, and maintain scalable ETL/ELT pipelines for petabyte-scale data migration.
• Lead operational execution of ETL tasks during migration cycles and validate results.
• Troubleshoot pipeline failures, resolve data anomalies, and coordinate with engineers to stabilize operations.
• Ensure data quality, validation, and governance across migration workflows.
• Collaborate with Cloud, Data, DevSecOps, DBAs, QA, and Product teams for integrated pipelines.
• Create and maintain data maps, flow diagrams, SOPs, and error logs; report migration status to leadership.

Skills

Active Top Secret Clearance

ETL pipelines

AWS

Python

CI/CD

Data Quality

Data Governance

Education

Bachelor’s degree or higher in a related field

Tools

AWS

Job description

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.

Primary Responsibilities:

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, DevSecOps 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.

Required Qualifications:

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

Preferred Qualifications:

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

Compensation to include:

• 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

Keywords: Data Migration, ETL, ELT, Data Engineering, AWS, Cloud Migration, Data Pipelines, SQL, Python, Bash, PowerShell, Automation, Data Quality, Data Validation, Data Governance, Legacy Systems, Federal Modernization, FBI, DOJ, Intelligence Community, Cloud Engineering, DevSecOps, CI/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.