Location: Chantilly, VA
Security Clearance: Active TS or higher [Required] Must be able to obtain CI Polygraph
Job Type: Full-Time
Target Salary Range*: $165,000 - $185,000
*This represents the potential salary range for this position depending on education level, years of experience and/or certifications in addition to other position specific requirements which may impact salary
Position Overview
The ETL Developer | SME designs, develops, and maintains scalable data integration frameworks and business intelligence solutions that enable cyber professionals to analyze case data and advance investigations. This role architects and optimizes extract, transform, and load pipelines, improves database performance, and applies DevSecOps practices to support accurate, reliable, and efficient data processing.
The ETL Developer | SME collaborates with data architects, DevOps teams, and infrastructure specialists to support applications across multi-enclave environments while advancing enterprise data warehousing, modern data pipeline architectures, containerized platforms, cloud integration, and search indexing capabilities.
Key Responsibilities
Data Integration and ETL Development
- Design, develop, and maintain scalable data integration frameworks and business intelligence solutions.
- Architect ETL pipelines and data mappings to extract, transform, and load complex datasets.
- Develop and optimize data integration workflows supporting enterprise analytics and investigative use cases.
- Integrate modern data pipeline architectures and search indexing technologies.
- Support enterprise data warehousing and cross-functional system integration.
Database Development and Performance
- Develop complex database scripts, stored procedures, triggers, and views.
- Optimize database queries and processing workflows.
- Conduct performance tuning to improve data accuracy, processing efficiency, and system reliability.
- Support reliable and scalable database operations across integrated data environments.
Python Development and Automation
- Apply advanced Python proficiency to data integration and application development.
- Develop reusable scripts and automation supporting ETL and data processing activities.
- Use Python to improve processing efficiency, integration workflows, and application capabilities.
DevSecOps and CI/CD
- Implement DevSecOps practices supporting data integration and application development.
- Apply automation, version control, testing frameworks, and CI/CD workflows.
- Support repeatable and reliable deployment of data pipelines and associated application components.
- Collaborate with DevOps teams to integrate data engineering activities into enterprise delivery workflows.
Application and Infrastructure Integration
- Collaborate with data architects, DevOps teams, and infrastructure specialists.
- Support and maintain applications deployed across multi-enclave environments.
- Integrate containerized environments and cloud platforms into data pipeline and application architectures.
- Support interoperability across data, application, and infrastructure components.
Technical Leadership and Collaboration
- Serve as a subject matter expert for ETL development, data integration, and database processing.
- Provide technical guidance on data pipeline architecture, performance, automation, and integration.
- Collaborate across data architecture, DevOps, and infrastructure teams supporting enterprise applications.
- Contribute to standards and best practices for enterprise data integration and warehousing.
Qualifications
Education
• Bachelor’s degree. [Required]
Experience
• Minimum 10 years of relevant experience. [Required]
Skills
- Advanced Python proficiency. [Required]
- Ability to develop complex database scripts, stored procedures, triggers, and views. [Required]
- Knowledge of ETL pipelines and data mappings. [Required]
- Knowledge of database performance tuning. [Required]
- Knowledge of DevSecOps practices, including automation, version control, testing frameworks, and CI/CD workflows. [Required]
- Technical experience supporting modern data pipeline architectures. [Required]
- Experience with containerized environments and cloud platforms. [Required]
- Experience with search indexing technologies. [Required]
- Ability to collaborate across data architecture, DevOps, and infrastructure teams supporting multi-enclave applications. [Required]