IT SME - Data Migration

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

Job summary

Orchard LLC is seeking a Senior Data Migration IT Subject Matter Expert to lead end-to-end migration of sensitive datasets to a secure, modern data platform. The role requires active Top Secret clearance and US citizenship, with work spanning Huntsville, AL and Quantico, VA.

You will architect, oversee, and validate migration of diverse data forms, ensuring accuracy, accessibility, and secure handling across cloud-enabled environments supporting long-term missions.

Qualifications

• Active Top Secret clearance required.
• US Citizenship required due to government contract.
• Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field.
• 9+ years of experience in data migration, data engineering, and enterprise database engineering.
• Experience executing large-scale, multi-system data migration projects with complex metadata and sensitive data controls.
• Expertise designing and operating ETL pipelines, ingestion frameworks, transformation logic, and metadata handling.
• Deep knowledge of data lineage, metadata propagation, marking preservation, and secure data handling workflows.

Responsibilities

• Lead the full lifecycle migration of sensitive mission data from multiple legacy systems into a modern data platform.
• Ensure migration of data, metadata, and user-applied markings while preserving integrity.
• Oversee transfer of structured, unstructured, audio, text, and multi-format data into cloud-aligned environments.
• Validate accessibility, searchability, and rendering of migrated data via UI, APIs, and analytics.
• Architect and refine ETL pipelines, ingestion workflows, transformation logic, and metadata handling standards.
• Engineer and evaluate databases to support high-volume mission data, complex metadata, and lineage tracking.
• Lead risk identification, mitigation, and QA related to data integrity, security, and performance.
• Collaborate with system owners, stakeholders, and cross-functional teams for readiness and alignment.
• Provide technical oversight and validation for Transition In, Technical Approach, RTM, and CVM deliverables.
• Demonstrate successful execution of large-scale enterprise migration projects.

Skills

Data migration

Data engineering

Enterprise database engineering

ETL pipelines

Metadata handling

Security/compliance

Education

Bachelor's degree in Computer Science / Data Engineering / Information Systems

Job description

Data Migration SME Huntsville, AL or Quantico, VA US Citizenship Required. Must have an Active Top Secret Clearance Required @Orchard is seeking a Senior Data Migration IT Subject Matter Expert to lead the end to end migration of highly sensitive, mission critical datasets as part of a national priority modernization initiative in Huntsville, AL. This senior expert will architect, oversee, and validate all technical aspects of migrating large scale, multi format data, including ELSUR/FISA holdings, from multiple legacy environments into a unified, secure, modern data platform.This is an awesome opportunity to play a central part in ensuring accuracy, integrity, accessibility, and secure handling of historical mission data, and to lead strategies that modernize legacy systems, preserve high value information, and guarantee seamless interoperability within new cloud enabled environments supporting long term mission success.

Responsibilities

• Lead the full lifecycle migration of sensitive mission data-including ELSUR/FISA-from multiple legacy systems and storage solutions into a consolidated, modern data platform.
• Ensure the successful migration of all data, metadata, and user applied markings, preserving historical integrity and operational relevance.
• Oversee the accurate, secure, and seamless transfer of structured, unstructured, audio, text, and multi format datasets into new cloud aligned environments.
• Validate accessibility, searchability, and correct rendering of migrated data in the new system's UI, APIs, and analytic components.
• Architect and refine ETL pipelines, data ingestion workflows, transformation logic, and metadata handling standards.
• Engineer and evaluate database systems that support high volume mission data, complex metadata structures, lineage tracking, and compliance requirements.
• Lead risk identification, mitigation, and quality assurance related to data integrity, security, and migration performance.
• Collaborate with system owners, mission stakeholders, and cross functional engineering teams to ensure operational readiness and mission alignment.
• Provide technical oversight, documentation, and validation required for Transition In, Technical Approach, RTM, and CVM deliverables.
• Demonstrate, through work products and results, expertise developed from successful execution of large scale, enterprise migration projects.

Requirements

• Active Top Secret clearance.
• Due to the nature of this government contract, US Citizenship is required.
• Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related technical field.
• 9+ years of professional experience in data migration, data engineering, and enterprise database engineering.
• Demonstrated experience executing large scale, multi system data migration projects, ideally involving complex metadata, markings, and sensitive data controls.
• Expertise designing and operating ETL pipelines, ingestion frameworks, transformation logic, and multi tier data architectures.
• Deep knowledge of data lineage, metadata propagation, marking preservation, and secure data handling workflows.

Desired Qualifications

• Experience migrating sensitive, multi format datasets in high security operational environments.
• Familiarity with cloud based analytics platforms and managed database services.
• Background in modernizing or refactoring legacy mission systems.

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 www.atOrchard.com.