ETL/Data Migration Engineer (Senior)

Lever, Inc.; Huntsville (AL); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Disability insurance

Vision insurance

401k match

Job summary

AnaVation is seeking an experienced Senior ETL/Data Migration Engineer to join our Huntsville, Alabama-based program. You will architect, operate, validate, and optimize high-volume ETL pipelines moving data from legacy environments to cloud platforms.

You will lead cross-functional efforts with Cloud Engineers, DevSecOps, DBAs, and QA, ensuring data quality and reliability across migrations for a federal modernization program.

Qualifications

• Bachelor’s degree and 8+ years of ETL, data engineering, or migration experience.
• Strong experience with ETL tools, scripting languages, automation frameworks, and high-volume pipelines.
• Hands-on experience with legacy system extraction, cloud ingestion, and multi-format data transformation.
• Must work full-time on-site in Huntsville, AL with TS clearance.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines for petabyte-scale data migration.
• Lead operational ETL tasks, ensure correct sequencing and data validation during cycles.
• Perform data quality checks, validation, and root-cause analysis for defects.
• Collaborate with Cloud Engineers, Data Engineers, DevSecOps, DBAs, QA, and Product Owners.
• Create and maintain ETL documentation, data maps, and SOPs.

Skills

ETL development

Data engineering

Migration operations

Scripting languages

Cloud ingestion

Troubleshooting

Team collaboration

Education

Bachelor’s degree

Tools

ETL tools

AWS

Job description

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 legacyenvironments into modern cloud platforms. The engineer serves as a senior technical contributor within the MigrationWorkstream, 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 migrationoperations.
• 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 abilityto 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.

Benefits

• Generous cost sharing for medical insurance for the employee and dependents
• 100% company paid dental insurance for employees and dependents
• 100% company paid long-term and short-term disability insurance
• 100% company paid vision insurance for employees and dependents
• 401k plan with generous match and 100% immediate vesting
• Competitive Pay
• Generous paid leave and holiday package
• Tuition and training reimbursement
• Life and AD&D Insurance

About AnaVation

AnaVation is the leader in solving the most complex technical challenges for collection and processing in the U.S. Federal Intelligence Community. We are a US owned company headquartered in Chantilly, Virginia. We deliver groundbreaking research with advanced software and systems engineering that provides an information advantage to contribute to the mission and operational success of our customers. We offer complex challenges, a top-notch work environment, and a world-class, collaborative team.

If you want to grow your career and make a difference while doing it, AnaVation is the perfect fit for you!

AnaVation is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.