ETL Engineer – SME

AnaVation LLC

Senior ETL Engineer designing and implementing complex data pipelines for advanced analytic applications. Working in classified environments to support cyber investigative capabilities with a top-notch team.

Posted 6/9/2026full-timeChantilly • Virginia • 🇺🇸 United StatesSeniorLeadWebsite

Tech Stack

Tools & technologies

ApacheAWSCloudElasticSearchETLMySQLPostgresPythonSQLTypeScript

About the role

Key responsibilities & impact

Design and implement complex data pipelines and ETL processes to support cyber investigative capabilities across multi-classification domains
Architect and develop ETL workflows for highly sensitive data in classified environments
Support IC Data Services requirements by integrating various intelligence data sources and systems
Develop and maintain data analytics solutions for desktop and web-based visual analytic applications
Establish applications that produce manageable, actionable intelligence from streams of structured and semi-structured data
Design strategies for enterprise database systems and set standards for operations, programming, and security
Construct and optimize large relational databases across multi-enclave environments (Unclassified, Secret, and Top Secret)
Tune performance of large-scale data workflows, ensuring cost efficiency, low latency, and high availability
Design and manage Elasticsearch/Opensearch clusters for fast search, indexing, and retrieval of large-scale datasets
Integrate new systems with existing warehouse structures and refine system performance and functionality
Implement CI/CD pipelines for data systems, automate monitoring/alerting, and enforce infrastructure-as-code practices
Provide technical leadership and mentorship to other team members
Participate in Program Increments (PIs) and Agile Release Train (ART) activities

Requirements

What you’ll need

Bachelor's degree in Computer Science, Data Science, Engineering, or related field
Minimum of 10 years of experience in data engineering or related field
Active Top Secret (TS) clearance with eligibility for Sensitive Compartmented Information (SCI)
US Citizenship is required.
Experience with Agile methodologies
Understanding of data warehousing and business intelligence concept
Data analysis, query, aggregation, and visualization techniques
ETL processes and data transformation
SQL and database technologies (MySQL, PostgreSQL, Microsoft SQL)
Software development fundamentals
Data management and big data technologies
Version control systems (Git)
Advanced proficiency with Python for data processing, automation and ETL workflow orchestration
Elasticsearch or Opensearch (design, scaling, query optimization, cluster management)
Data pipeline technologies (Apache Nifi, Cribl)
Cross-domain ETL solutions for secure data transfer between classification levels
Cloud platforms (AWS GovCloud, SC2S, C2S)

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data engineeringETL processesdata analysisSQLPythondata managementbig data technologiesdata pipeline technologiesElasticsearchcloud platforms

Soft Skills

technical leadershipmentorshipcommunicationcollaborationproblem-solving

Certifications

Bachelor's degree in Computer ScienceTop Secret (TS) clearanceeligibility for Sensitive Compartmented Information (SCI)