ETL Software Engineer

About the role

We are seeking a talented and motivated ETL Engineer to design, build, and optimize high‑performance data pipelines and ETL processes that power a web‑based search and analytics application. The role involves extracting, transforming, and loading data from various sources—including relational databases and file formats—developing data adapters in Python, and fine‑tuning workflows for speed and scale. This position is hybrid, with one to three days per week on‑site in Chantilly, VA, and requires a Top Secret clearance with SCI eligibility and the ability to pass a CI polygraph.

Responsibilities

• Design, build, and optimize high‑performance data pipelines and ETL processes.
• Extract, transform, and load data from relational databases and diverse file formats.
• Develop data adapters and ETL components using Python.
• Fine‑tune workflows for speed, scalability, and reliability.
• Perform SQL query optimization and work with Oracle, PostgreSQL, MySQL, or MSSQL databases.
• Integrate and maintain Elasticsearch or OpenSearch indexes.
• Use version control (Git) and collaborative coding practices.
• Write and maintain Bash scripts and other automation tools.
• Containerize applications with Docker and operate in Linux environments.
• Participate in Agile Scrum ceremonies and contribute to sprint planning.

Requirements

• Active Top Secret clearance and SCI eligibility with the ability to pass a CI polygraph.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent experience).
• 5+ years of data engineering experience, including building ETL/ELT pipelines.
• Proficiency in SQL query optimization.
• Experience with relational databases such as Oracle, PostgreSQL, MySQL, or MSSQL.
• Strong programming skills in Python, Java, or C#; 3+ years of Python development focused on ETL.
• Experience with Elasticsearch or OpenSearch.
• Familiarity with version control systems (e.g., Git) and collaborative coding practices.
• Experience working in an Agile Scrum environment.
• Proficiency with scripting languages (e.g., Bash).
• Experience with containerization technologies (e.g., Docker).
• Experience working in Linux environments.

Preferred Qualifications

• Knowledge of data quality, validation, and monitoring frameworks.
• Experience with data governance, metadata management, and data lineage best practices.
• Strong understanding of data transformation, cleansing, and normalization concepts.
• Experience with data warehousing, big data frameworks, and API‑based data integration from enterprise source systems.
• Excellent problem‑solving skills and attention to detail.

Benefits

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

Schedule

Hybrid work arrangement: one to three days per week on‑site in Chantilly, VA.

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 U.S.–owned company headquartered in Chantilly, Virginia, delivering groundbreaking research with advanced software and systems engineering to provide an information advantage for our customers. Our environment offers complex challenges, a top‑notch work setting, and a world‑class collaborative team.