Data Migration Engineer Sr. - 175384

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

Job summary

Zachary Piper Solutions seeks a Data Migration Engineer Senior to lead complex ETL/ELT pipelines and data migration initiatives for federal modernization projects. The role focuses on secure cloud readiness, data mapping, validation, and cross-team collaboration in Huntsville, AL.

The position demands 8+ years in data migration/ETL, a Bachelor’s degree, and an Active Top Secret Clearance, with strong experience in AWS and large-scale data environments.

Qualifications

• 8+ years hands-on data migration, ETL/ELT development, data integration, or large-scale data engineering with a Bachelor's degree.
• Advanced ETL/ELT pipelines design for structured and unstructured datasets.
• Experience with data mapping, transformation, cleansing, validation, data quality, and troubleshooting in high-volume migrations.
• Cloud-based data migration, automation, scripting, and big data technologies; AWS experience preferred.
• Active Top Secret Security Clearance required.

Responsibilities

• Lead design, development, and optimization of ETL/ELT pipelines for large-scale data migration to modern cloud environments.
• Develop complex data mappings, transformations, cleansing, and validation to ensure data quality and performance.
• Collaborate with cloud, DevSecOps, data engineering, QA, and product teams for migration readiness and testing.
• Provide technical guidance to mid-level engineers and improve migration automation and pipeline performance.
• Maintain migration specifications, data mappings, and technical documentation per federal governance and security requirements.

Skills

ETL/ELT design

Data migration

Data integration

Data quality

Cloud experience (AWS)

Python/SQL scripting

Education

Bachelor's degree

Tools

SQL

Python

AWS

Job description

Zachary Piper Solutions is seeking a Data Migration Engineer Senior to support a company focused on federal modernization, cloud transformation, and mission-critical technology initiatives. This position is on-site in Huntsville, AL.

The Data Migration Engineer Senior will lead complex data extraction, transformation, validation, and migration efforts supporting the transition of high-volume datasets from legacy systems into secure cloud environments. This is an opportunity to play a key technical role in modernizing critical government systems while leading advanced ETL/ELT, data quality, and migration initiatives supporting high-impact national missions.

Responsibilities for the Data Migration Engineer Senior include:

• Lead the design, development, and optimization of ETL/ELT pipelines supporting large-scale migration of structured and unstructured data from legacy systems into modern cloud environments
• Develop complex data mapping, transformation, cleansing, and validation processes while identifying and resolving data integrity, quality, and performance issues
• Collaborate with cloud, DevSecOps, data engineering, QA, and product teams to coordinate migration readiness, integration testing, and legacy system transition activities
• Provide technical guidance to mid-level engineers while improving migration automation, reusable processes, troubleshooting procedures, and overall pipeline performance
• Develop and maintain migration specifications, data mappings, technical documentation, operational metrics, and procedures in accordance with federal data governance and security requirements

Required Qualifications for the Data Migration Engineer Senior include:

• 8+ years of hands-on experience in data migration, ETL/ELT development, data integration, or large-scale data engineering, with a Bachelor’s degree required
• Advanced experience designing, developing, and operating ETL/ELT pipelines for complex structured and unstructured datasets
• Strong experience with data mapping, transformation, cleansing, validation, data quality, and troubleshooting within high-volume migration environments
• Experience with cloud-based data migration, automation, scripting, and/or big data technologies, with AWS experience preferred
• Must have an Active Top Secret Security Clearance

Preferred Qualifications for the Data Migration Engineer Senior include:

• Experience supporting petabyte-scale migrations, enterprise data modernization, or multi-system consolidation initiatives
• Experience supporting DOJ, FBI, Intelligence Community, or other national security programs
• Familiarity with DevSecOps environments, CI/CD pipelines, automated testing, and cloud-native data services
• Advanced experience with scripting languages, distributed data processing technologies, or cloud-native ETL tools

Compensation for the Data Migration Engineer Senior includes:

Salary Range: Competitive salary depending on experience

Full Benefits Package: PTO, Paid Holidays, Medical, Dental, Vision, 401K, Tuition Reimbursement, Sick Leave as Required by Law

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

#LI-MR1

#LI-ONSITE

Keywords: Senior Data Migration Engineer, Data Migration Engineer, Senior Data Engineer, Data Engineer, Senior ETL Engineer, ETL Engineer, ETL Developer, Senior Data Integration Engineer, Data Integration Engineer, Data Conversion Engineer, Database Engineer, Data Migration, ETL, ELT, Extract Transform Load, Extract Load Transform, Data Integration, Data Conversion, Data Mapping, Data Transformation, Data Cleansing, Data Validation, Data Quality, Data Integrity, Data Governance, Structured Data, Unstructured Data, Big Data, Large Scale Data Migration, Enterprise Data Migration, Multi-System Migration, Data Consolidation, Data Pipelines, ETL Pipelines, ELT Pipelines, Pipeline Automation, Data Processing, Data Extraction, Data Loading, SQL, Python, Scripting, AWS, Amazon Web Services, Cloud Data Migration, Cloud Migration, Cloud Engineering, Cloud Modernization, Legacy System Migration, Legacy Systems, DevSecOps, CI/CD, Automated Testing, Application Modernization, Federal Technology, Top Secret Clearance, Active Top Secret, TS Clearance, Federal Clearance Jobs, Cleared Data Engineer, Cleared Data Migration Engineer, Huntsville AL Jobs, Huntsville Technology Jobs, Senior Data Engineer Huntsville, Data Migration Engineer Huntsville