ETL/Data Migration Engineer (Senior)

Description of Task to be Performed:

AnaVation is seeking an experienced ETL/Data Migration Engineer (Senior) to join our growing Huntsville, Alabama-based work program. The selected candidate will lead high complexity extract, transform, and load (ETL) operations supporting a major federal modernization program. This role is responsible for architecting, operating, validating, and optimizing data migration pipelines that move high volume, multi-source datasets from legacy environments into modern cloud platforms. The engineer serves as a senior technical contributor within the Migration Workstream, ensuring data quality, performance, and reliability throughout large scale migration cycles.

Specific duties and responsibilities include:

ETL Pipeline Architecture & Execution

• Design, develop, optimize, and maintain scalable ETL/ELT pipelines supporting petabyte scale data migration.
• Build extraction and transformation logic for structured and unstructured datasets.
• Engineer automated workflows for performance, throughput, error handling, and resiliency.
• Align pipeline architecture with cloud landing zone requirements and modernization standards.

Data Migration Operations

• Lead operational execution of ETL tasks during migration cycles, ensuring correct sequencing and validation.
• Troubleshoot pipeline failures, resolve data anomalies, and coordinate with engineering teams to stabilize operations.
• Conduct readiness testing and verify integration points between legacy systems and cloud targets.

Data Quality, Validation & Governance

• Perform detailed data quality checks, completeness assessments, and validation of migrated data.
• Lead root cause analysis for data defects and support corrective actions across the migration workflow.
• Document recurring issues, improve detection processes, and help define quality benchmarks.

Cross Functional Technical Collaboration

• Partner with Cloud Engineers, Data Engineers, DevSecOps teams, DBAs, QA/Test Engineers, and Product Owners.
• Ensure ETL pipelines integrate seamlessly with cloud architectures, data models, monitoring tools, and downstream systems.
• Participate in sprint ceremonies, technical reviews, and migration planning activities.

Documentation & Reporting

• Create/maintain ETL documentation including data maps, flow diagrams, transformation logic, SOPs, and error logs.
• Provide pipeline performance updates, migration status reports, and data quality metrics to leadership.
• Support development of reusable processes and technical artifacts supporting repeatable migration operations.

This position requires an active Top Secret (TS) clearance and the ability to obtain SCI accesses with a CI polygraph.

This position is on-site with our customer in Huntsville, Alabama, and cannot be supported remotely.

Required Qualifications:

• Bachelor’s degree and 8+ years of experience in ETL development, data engineering, or enterprise scale migration operations.
• Strong experience with ETL tools, scripting languages, automation frameworks, and high volume data pipelines.
• Hands on experience with legacy system extraction, cloud ingestion, and multi format data transformation.
• Proven troubleshooting skills, including pipeline diagnostics and root cause analysis.
• Ability to operate in fast paced, multi team environments supporting mission critical delivery.
• Must be able to work full-time on-site at our customer location in Huntsville, Alabama.
• Active Top Secret (TS) clearance with eligibility for Sensitive Compartmented Information (SCI) and the ability to obtain a CI polygraph.

Preferred Qualifications:

• Experience supporting federal modernization programs, especially in national-security environments.
• Experience operating ETL pipelines within AWS or other cloud environments.
• Familiarity with DevSecOps workflows, CI/CD pipelines, and distributed compute tools.
• Advanced scripting or automation expertise (Python, Bash, PowerShell, etc.).
• Experience supporting petabyte scale data migrations or multi system consolidation.