Data Migration Engineer – Senior

Huntsville AL or Quantico VA

US Citizenship Required. Must have an Active Top Secret Clearance Required

@Orchard is seeking a Senior Data Migration Engineer to lead complex data extraction transformation validation and migration activities within a major federal modernization program. The engineer will support petabytescale data transition efforts ensuring accuracy completeness security and performance in moving structured and unstructured datasets from legacy environments to modern cloudbased architectures. This senior role provides technical leadership develops advanced migration strategies mentors midlevel engineers and ensures alignment with architecture security and mission requirements. This is a fantastic opportunity to contribute to a high-impact National Security mission while getting hands-on experience with cutting-edge technology.

Responsibilities:

Advanced Data Migration & ETL Leadership:

• Lead development enhancement and optimization of ETL/ELT pipelines for largescale multisource data migration.
• Perform complex data extraction transformation governance and cleansing activities supporting highvolume data flows.
• Design data mapping frameworks and transformation logic for legacytocloud migration.
• Guide automation improvements to increase pipeline throughput resiliency and repeatability.

Data Quality Validation & Issue Resolution:

• Conduct advanced data integrity analysis completeness checks anomaly detection and error remediation.
• Support and lead quality verification for incoming and migrated datasets.
• Collaborate with QA/test engineering teams to embed automated validation within pipeline operations.

Technical Collaboration & Integration:

• Coordinate with Cloud Engineers DevSecOps teams Data Engineers Product Owners and Scrum Masters to ensure alignment across technical workstreams.
• Support readiness testing for migration events legacy system retirements and cloud landing zone configuration.
• Participate in technical design reviews sprint planning backlog refinement and integration checkpoints.

Migration Strategy & Leadership:

• Provide guidance to midlevel engineers on data migration methods ETL tools best practices and troubleshooting.
• Develop and refine reusable templates mapping documents and procedural artifacts.
• Proactively identify risks impacting migration success and propose mitigation strategies.

Documentation Reporting & Compliance:

• Create detailed migration documentation including mapping specifications data dictionaries flow diagrams and SOPs.
• Contribute to migration status reporting dashboard updates and operational metrics.
• Ensure alignment with federal data governance security and handling requirements.

Required Qualifications:

• Must have Active Top Secret Security Clearance.
• U.S. Citizenship.
• Bachelors degree and 8 years of handson experience in data migration ETL development or largescale data engineering.
• Expertise in structured/unstructured data transformation cleansing and validation.
• Experience designing and operating advanced ETL/ELT pipelines.
• Familiarity with cloud migration (AWS preferred) bigdata tooling and automation.
• Strong problemsolving skills and ability to support complex highvolume migration operations.

Preferred Qualifications:

• Experience with petabytescale data migrations or multisystem consolidation.
• Background supporting DOJ FBI IC or nationalsecurity modernization programs.
• Experience with DevSecOps pipelines CI/CD workflows or automated testing frameworks.
• Advanced knowledge of scripting languages distributed compute tools or cloudnative ETL services.

Established in 2010 @Orchard LLC has an exceptional reputation providing staffing solutions to time-sensitive talent scarcity issues to deliver better talent management ROI. Our specialty lies in the critical area of program talent acquisition and resource management not in one narrow skillset but across many areas of technical and functional delivery. To learn more about our other exciting opportunities visit our Jobs Page at .