ETL/Data Migration Engineer

Be Challenged and Make a Difference    In a world of technology, people make the difference. We believe if we invest in great people, then great things will happen. At AnaVation, we provide unmatched value to our customers and employees through innovative solutions and an engaging culture. 

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.