AnaVation
AnaVation

ETL Engineer SME

TLDR

Deliver engineering tasks to advanced analytic applications across classified environments, developing sophisticated data pipelines and ETL processes for diverse data sources.

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.  Required Qualifications:

Minimum 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)
  • 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)
  • Work Environment

  • 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
  • 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.

    AnaVation tackles the toughest technical problems in data collection and processing for the U.S. Federal Intelligence Community. By leveraging advanced software and systems engineering, we empower our clients with critical insights and operational advantages. Our focus on groundbreaking research sets us apart in the industry.

    Founded
    Founded 2013
    Employees
    51-200 employees
    Industry
    Professional Services
    View company profile
    Report this job
    Apply for this job