The Role
Design, build, and optimize cross-domain ETL pipelines and data platforms for classified intelligence applications. Architect large relational databases, manage Elasticsearch/OpenSearch clusters, implement CI/CD and IaC, and mentor teams while ensuring secure, low-latency, high-availability data delivery across Unclassified, Secret, and Top Secret environments.
Summary Generated by Built In
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 a highly skilled Senior-level ETL Engineer to join our team deliver engineering tasks to advanced analytic applications across classified environments. You will develop sophisticated data pipelines and ETL processes for desktop and web-based analytic software, facilitate the bulk analysis of relational information, and enable applications that deliver data from diverse data sources. This position offers hybrid flexibility, but candidates must be local to the DMV area. Onsite requirements are subject to change based on customer needs.
Key Responsibilities
- 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
Required Qualifications:
- 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)
- 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)
- Primary location: Chantilly, VA
- May require occasional travel for Program Increment planning sessions
- Must be a U.S. citizen and able to pass a background check and polygraph examination
- May require flexible scheduling to support critical operations
Minimum Qualifications:
Advanced proficiency with:
Work Environment
Preferred Qualifications:
- Containerization and orchestration technologies (Docker, Kubernetes)
- GraphQL: schema design, API development, and query optimization
- DevSecOps practices and tools in classified environments
- Experience with RabbitMQ and Redis
- Knowledge of IC specific data formats, schemas and transfer protocols
- Prior work integrating intelligence data across multiple enclaves
- Cloud certification
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.
Skills Required
- 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)
- U.S. Citizenship
- Able to pass background check and polygraph examination
- Experience with Agile methodologies
- Understanding of data warehousing and business intelligence concepts
- Data analysis, query, aggregation, and visualization techniques
- ETL processes and data transformation experience
- 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 orchestration
- Advanced proficiency with Elasticsearch or Opensearch (design, scaling, query optimization, cluster management)
- Experience with data pipeline technologies (Apache NiFi, Cribl)
- Cross-domain ETL solutions for secure data transfer between classification levels
- Experience with cloud platforms used in IC (AWS GovCloud, SC2S, C2S)
- Design and tuning of large relational databases and data workflows
- Implement CI/CD pipelines, monitoring/alerting, and infrastructure-as-code practices
- Provide technical leadership and mentorship; participate in Agile PI/ART activities
- Local to the DMV area / primary location Chantilly, VA (onsite as required)
- Experience designing strategies for enterprise database systems and security standards
- Experience constructing/optimizing large-scale data workflows for cost efficiency, low latency, high availability
- Familiarity with handling multi-classification (Unclassified, Secret, Top Secret) data/enclaves
- Preferred: Containerization and orchestration (Docker, Kubernetes)
- Preferred: GraphQL schema design, API development, and query optimization
- Preferred: DevSecOps practices and tools in classified environments
- Preferred: Experience with RabbitMQ and Redis
- Preferred: Knowledge of IC-specific data formats, schemas, and transfer protocols
- Preferred: Prior work integrating intelligence data across multiple enclaves
- Preferred: Cloud certification
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
AnaVation is a trusted partner that delivers high-value, cost-effective solutions to solve our customers’ most complex technical and analytical problems. AnaVation believes that the future of securing, collecting, processing, and analyzing cyber data will require the development of advanced ANAlytical technologies derived via the innoVATION of current and future technologies. AnaVation believes in the “Idea of the Possible” — that it is possible for our experts, partnering with our customers in the right environment, to create innovative technical solutions that expand our customers’ capabilities. We want to do two things for our customers. We want to resolve existing challenges and we want to prepare them for the future. Our technical expertise and innovative engineering culture enable us to do those things.
