4417 ETL Engineer

OVERVIEW:

We are seeking a highly skilled Senior-level ETL Engineer to join our team delivering 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.

GENERAL DUTIES:

• 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
• 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)
• May require occasional travel for Program Increment planning sessions
• May require flexible scheduling to support critical operations

DESIRED 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

CLEARANCE:

• Active Top Secret clearance minimum