Data Migration Engineer - Senior

Orchard LLC; Quantico (VA); On-site; USD 140,000 - 190,000; Full time

Job summary

Orchard LLC is seeking a Senior Data Migration Engineer to lead large-scale data migration projects for a federal modernization program. The role focuses on ETL/ELT pipeline design, data quality assurance, and cross-team collaboration with Cloud, DevSecOps, and product teams.

The candidate will mentor junior engineers, develop migration templates, and ensure compliance with federal governance and security requirements. On-site work at Quantico, VA or Huntsville, AL is expected.

Qualifications

• Must have Active Top Secret Security Clearance.
• U.S. Citizenship required.
• Bachelor's degree and 8+ years of hands-on experience in data migration, ETL development, or large-scale data engineering.

Responsibilities

• Lead development, enhancement, and optimization of ETL/ELT pipelines for large-scale data migration.
• Conduct data integrity analysis, validation, and cleansing; embed automated checks in pipelines.
• Coordinate with Cloud Engineers, DevSecOps, Data Engineers, Product Owners, and Scrum Masters.
• Provide guidance on migration methods, tools, and best practices; develop reusable templates and artifacts.
• Prepare detailed migration documentation, mappings, data dictionaries, and dashboards.

Skills

ETL/ELT pipelines

Data migration leadership

Data quality & validation

Cloud migration (AWS)

Technical leadership

Education

Bachelor's degree

Tools

AWS

CI/CD pipelines

DevSecOps

Job description

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 petabyte-scale data transition efforts, ensuring accuracy, completeness, security, and performance in moving structured and unstructured datasets from legacy environments to modern cloud-based architectures. This senior role provides technical leadership, develops advanced migration strategies, mentors mid-level 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 large-scale, multi-source data migration. Perform complex data extraction, transformation, governance, and cleansing activities supporting high-volume data flows. Design data mapping frameworks and transformation logic for legacy-to-cloud 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 mid-level 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.
• Bachelor's degree and 8+ years of hands-on experience in data migration, ETL development, or large-scale 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), big-data tooling, and automation.
• Strong problem-solving skills and ability to support complex, high-volume migration operations.

Preferred Qualifications

• Experience with petabyte-scale data migrations or multi-system consolidation.
• Background supporting DOJ, FBI, IC, or national-security modernization programs.
• Experience with DevSecOps pipelines, CI/CD workflows, or automated testing frameworks.
• Advanced knowledge of scripting languages, distributed compute tools, or cloud-native 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.