Senior Data Migration Engineer
- $155k – $175k
- |Quantico
- |8 years of exp
- |Full Time
In office
Not Available
About the job
Zachary Piper Solutions is seeking a Senior Data Migration Engineer to support large-scale data migration, integration, and modernization initiatives for a mission-critical federal program in Quantico, VA. The Senior Data Migration Engineer will design and optimize ETL/ELT pipelines, lead complex data transformation and validation efforts, and support the migration of structured and unstructured datasets from legacy systems to modern cloud environments. This individual will collaborate with Cloud Engineering, DevSecOps, QA, and Data Engineering teams to ensure secure, accurate, and efficient data migrations. This position will be onsite in Quantico, VA and requires an active Top Secret clearance!Responsibilities of the Senior Data Migration Engineer:Design, develop, and optimize ETL/ELT pipelines supporting large-scale data migration and integration initiativesLead data extraction, transformation, cleansing, and loading activities across structured and unstructured datasetsDevelop data mapping frameworks, transformation logic, and migration strategies for legacy-to-cloud environmentsSupport high-volume data migrations, ensuring data accuracy, completeness, integrity, and performanceImplement automated data validation, reconciliation, anomaly detection, and error remediation processesOptimize data pipelines for scalability, reliability, throughput, and repeatabilityCollaborate with Cloud Engineering, DevSecOps, QA, and Data Engineering teams to support migration readiness and integration testingTroubleshoot complex data migration issues, identify root causes, and implement corrective actionsSupport cloud migration activities, legacy system decommissioning, and data integration initiativesParticipate in Agile development activities, including sprint planning, backlog refinement, and technical design reviewsMentor mid-level engineers and contribute to data migration best practices and technical standardsDevelop and maintain data mapping specifications, data dictionaries, migration procedures, and technical documentationIdentify migration risks, recommend mitigation strategies, and ensure compliance with federal data security and governance requirementsQualifications for the Senior Data Migration Engineer:Active Top Secret clearanceBachelor's degree in Computer Science, Information Technology, Data Engineering, or a related discipline8+ years of hands-on experience in data migration, ETL/ELT development, or large-scale data engineeringStrong experience designing, developing, and maintaining complex ETL/ELT pipelinesExpertise in structured and unstructured data extraction, transformation, cleansing, and validationExperience developing data mapping specifications, transformation logic, and data integration workflowsExperience supporting large-scale data migrations involving high-volume datasets and multiple source systemsStrong understanding of data quality, data integrity, reconciliation, and automated validation processesFamiliarity with cloud-based data migration environments, preferably AWSExperience with data pipeline automation, performance optimization, and troubleshootingStrong analytical, problem-solving, technical documentation, and communication skillsCompensation for the Senior Data Migration Engineer includes:Salary: $155,000 - $175,000Comprehensive Benefits Package including Medical, Dental, Vision, 401(k), PTO, and Paid HolidaysKeywords: Senior Data Migration Engineer, Data Migration Engineer, Data Engineer, Senior Data Engineer, ETL Developer, ETL Engineer, Data Integration Engineer, Data Migration, ETL, ELT, ETL Pipelines, ELT Pipelines, Data Extraction, Data Transformation, Data Loading, Data Cleansing, Data Validation, Data Reconciliation, Data Mapping, Data Integration, Data Quality, Data Integrity, Data Governance, Structured Data, Unstructured Data, Big Data, Petabyte Scale Data Migration, Legacy System Migration, Cloud Migration, AWS, Amazon Web Services, Cloud Data Engineering, AWS Glue, AWS DMS, Data Pipelines, Pipeline Automation, Python, SQL, PySpark, Apache Spark, Distributed Computing, Data Warehousing, Data Lake, Data Modernization, Data Architecture, DevSecOps, CI/CD, Agile, Scrum, Automated Testing, Performance Optimization, Federal IT, Top Secret Clearance, Active Top Secret, Huntsville AL, Alabama, Onsite Jobs, Federal Data Engineering
