Onsite Senior Data Migration Engineer – Top Secret

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

Benefits offered by this job

Comprehensive Benefits Package

Job summary

Zachary Piper Solutions in Huntsville, AL is seeking a Senior Data Migration Engineer to design and optimize ETL/ELT pipelines, leading data transformation and migration initiatives for a federal program. Onsite role requiring active Top Secret clearance, collaboration with Cloud Engineering, DevSecOps, QA, and Data Engineering teams.

You will oversee migration of structured and unstructured data to cloud environments, ensure data accuracy, and contribute to data governance and security

Qualifications

• Active Top Secret clearance.
• Bachelor’s degree in Computer Science, Information Technology, Data Engineering, or related field.
• 8+ years of hands-on data migration, ETL/ELT development, or large-scale data engineering.
• Strong experience designing, developing, and maintaining complex ETL/ELT pipelines.
• Expertise in structured and unstructured data extraction, transformation, cleansing, and validation.
• Experience creating data mapping specifications and data integration workflows.
• Experience supporting large-scale data migrations across multiple source systems.
• Knowledge of data quality, data integrity, reconciliation, and automated validation.
• Familiarity with cloud-based data migration environments, preferably AWS.
• Experience with data pipeline automation, performance optimization, and troubleshooting.
• Strong analytical, problem-solving, documentation, and communication skills.

Responsibilities

• Design, develop, and optimize ETL/ELT pipelines supporting large-scale data migration and integration initiatives.
• Lead data extraction, transformation, cleansing, and loading activities across structured and unstructured datasets.
• Develop data mapping frameworks, transformation logic, and migration strategies for legacy-to-cloud environments.
• Support high-volume data migrations, ensuring data accuracy, completeness, integrity, and performance.
• Implement automated data validation, reconciliation, anomaly detection, and error remediation processes.
• Optimize data pipelines for scalability, reliability, throughput, and repeatability.
• Collaborate with Cloud Engineering, DevSecOps, QA, and Data Engineering teams to support migration readiness and integration testing.
• Troubleshoot complex data migration issues, identify root causes, and implement corrective actions.
• Support cloud migration activities, legacy system decommissioning, and data integration initiatives.
• Participate in Agile development activities, including sprint planning, backlog refinement, and technical design reviews.
• Mentor mid-level engineers and contribute to data migration best practices and technical standards.
• Develop and maintain data mapping specifications, data dictionaries, migration procedures, and technical documentation.
• Identify migration risks, recommend mitigation strategies, and ensure compliance with federal data security and governance requirements.

Skills

ETL/ELT development

Data migration

Data modeling

Data quality

Cloud experience

Agile/Scrum

Education

Bachelor's degree in Computer Science, Information Technology, Data Engineering, or related

Tools

AWS

AWS Glue

AWS DMS

Python

SQL

PySpark

Apache Spark

Job description

Zachary Piper Solutions in Huntsville, AL is seeking a Senior Data Migration Engineer to design and optimize ETL/ELT pipelines, leading data transformation and migration initiatives for a federal program. Onsite role requiring active Top Secret clearance, collaboration with Cloud Engineering, DevSecOps, QA, and Data Engineering teams.

You will oversee migration of structured and unstructured data to cloud environments, ensure data accuracy, and contribute to data governance and security