IT SME - Data Migration

Orchard LLC; Huntsville (AL); On-site; USD 140,000 - 170,000; Full time

Job summary

Orchard LLC seeks a Senior Data Migration IT Subject Matter Expert to lead end-to-end migration of highly sensitive datasets from multiple legacy environments into a unified, secure data platform in Huntsville, AL or Quantico, VA. Must have Active Top Secret clearance and US citizenship.

You will architect ETL pipelines, oversee data ingestion, ensure metadata preservation and secure handling across cloud-enabled environments, and collaborate with stakeholders to ensure accuracy, accessibility,

Qualifications

• Active Top Secret clearance required.
• U.S. citizenship required due to government contract.
• Bachelor's degree in Computer Science, Data Engineering or related field.
• 9+ years of data migration, data engineering and enterprise DB experience.

Responsibilities

• Lead full lifecycle migration of sensitive mission data from multiple legacy systems into a modern data platform.
• Ensure migration of data, metadata, and markings while preserving historical integrity.
• Oversee transfer of structured, unstructured and multi-format data into cloud-aligned environments.
• Validate accessibility, searchability and rendering in UI, APIs and analytics components.
• Architect and refine ETL pipelines, data ingestion, transformation logic and metadata handling.
• Evaluate databases to support high-volume mission data with lineage and security requirements.
• Lead risk identification, mitigation and QA for data integrity, security and performance.
• Collaborate with system owners and stakeholders to ensure readiness and mission alignment.
• Provide technical oversight and validation for Transition In, Technical Approach, RTM and CVM deliverables.
• Demonstrate success through results from large-scale enterprise migration projects.

Skills

Data migration

Data engineering

ETL pipelines

Enterprise DB engineering

Data lineage

Metadata propagation

Secure data handling

Cloud analytics

Education

Bachelor's degree

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.