Top Secret Data Migration Engineer — ETL & Cloud

Orchard LLC; Huntsville (AL); On-site; USD 95,000 - 125,000; Full time

Job summary

Orchard LLC in Huntsville, AL (Mid) is seeking a Data Migration Engineer to support ETL pipelines and data movement for a large-scale federal modernization program. The role requires US citizenship and an active Top Secret clearance, with collaboration across data, DevSecOps, QA, and cloud teams.

Responsibilities include data extraction, transformation, cleansing, validation, and detailed data mapping from legacy systems to target schemas.

Qualifications

• Bachelor's degree and 4+ years of experience in data migration, ETL, or data engineering workloads.
• Experience with structured/unstructured data, mapping, transformation, cleansing, and validation.
• Familiarity with ETL tools, scripting languages, or pipeline automation methods.

Responsibilities

• Data Migration & ETL Execution: support development and operation of ETL workflows for large-scale data migration efforts.
• Execute data extraction, transformation, cleansing, normalization, and validation tasks.
• Conduct detailed data mapping from legacy systems to target schemas and environments.
• Operate within migration pipelines and support automation improvements.
• Data Quality & Validation: perform data integrity checks and error resolution.
• Support QA activities for migrated datasets to ensure accuracy and fidelity.
• Document data issues, anomalies, and corrective measures.
• Collaborate with Senior Data Migration Engineers, Data Engineers, DevSecOps, QA, and cloud architects.
• Validate source/target environments and test pipeline functionality for migration readiness.
• Participate in technical reviews, test cycles, and data validation checkpoints.
• Maintain documentation of migration steps, ETL processes, schemas, and pipeline behaviors.
• Contribute to migration reporting and status summaries.
• Identify risks, blockers, and dependency issues impacting throughput.

Skills

Analytical skills

Attention to detail

Fast-paced environments

Education

Bachelor's degree

Tools

ETL tools

Scripting languages

Pipeline automation

Job description

Orchard LLC in Huntsville, AL (Mid) is seeking a Data Migration Engineer to support ETL pipelines and data movement for a large-scale federal modernization program. The role requires US citizenship and an active Top Secret clearance, with collaboration across data, DevSecOps, QA, and cloud teams.

Responsibilities include data extraction, transformation, cleansing, validation, and detailed data mapping from legacy systems to target schemas.