Senior Data Migration Engineer - Onsite in Quantico | TS

Zachary Piper, LLC; Virginia; On-site; USD 155,000 - 175,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401(k)

PTO

Paid Holidays

Job summary

Zachary Piper Solutions is seeking a Senior Data Migration Engineer to support large-scale data migration, integration, and modernization for a federal program in Quantico, VA. The role will design and optimize ETL/ELT pipelines and lead complex data transformations, collaborating with Cloud Eng, DevSecOps, QA, and Data Eng teams.

Onsite in Quantico with an active Top Secret clearance is required. The engineer will mentor mid-level staff, develop data mapping specifications and documentation,

Qualifications

• Active Top Secret clearance is required.
• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or related.
• 8+ years of hands‑on data migration/ETL development experience.
• Strong in designing and maintaining complex ETL/ELT pipelines.
• Experience with structured and unstructured data extraction, transformation, and validation.
• Cloud data migration exposure, preferably AWS.
• Experience with data mapping specifications, transformation logic, and data integration workflows.
• Data quality, reconciliation, and automated validation understanding.

Responsibilities

• Design, develop, and optimize ETL/ELT pipelines for large-scale migrations.
• Lead extraction, transformation, cleansing, and loading across datasets.
• Develop data mapping frameworks and migration strategies for legacy-to-cloud.
• Support high-volume migrations ensuring data accuracy and performance.
• Implement automated data validation, reconciliation, and anomaly detection.
• Optimize pipelines for scalability, reliability, throughput, and repeatability.
• Collaborate with Cloud Eng, DevSecOps, QA, and Data Eng teams.
• Troubleshoot migration issues and root-cause analysis.
• Support cloud migration and decommissioning initiatives.
• Participate in Agile sprint planning and design reviews.
• Mentor mid-level engineers and define best practices.
• Maintain data dictionaries, mappings, and migration procedures.
• Identify risks and ensure federal data security & governance.

Skills

Top Secret clearance

ETL/ELT

Data migration

AWS

Python

SQL

PySpark

Apache Spark

Agile/Scrum

Data integration

Education

Bachelor's degree in Computer Science or related

Tools

AWS Glue

AWS DMS

Apache Spark

Job description

Zachary Piper Solutions is seeking a Senior Data Migration Engineer to support large-scale data migration, integration, and modernization for a federal program in Quantico, VA. The role will design and optimize ETL/ELT pipelines and lead complex data transformations, collaborating with Cloud Eng, DevSecOps, QA, and Data Eng teams.

Onsite in Quantico with an active Top Secret clearance is required. The engineer will mentor mid-level staff, develop data mapping specifications and documentation,