ETL Developer | SME

The Amatriot Group; Chantilly (VA); On-site; USD 145,000 - 190,000; Full time

Job summary

The Amatriot Group seeks an ETL Developer (SME) to design, develop, and maintain scalable data integration frameworks and BI solutions for cyber investigations. You will build ETL pipelines, optimize databases, and apply DevSecOps to ensure accurate data processing across multi-enclave environments.

Qualifications include a bachelor’s degree and 10+ years of experience; advanced Python and SQL scripting are essential.

Qualifications

• Bachelor’s degree is required.
• Minimum of 10 years of experience in ETL, Python, and data integration.
• Experience across multi-enclave environments and cloud platforms.
• Proficient in DevSecOps practices and CI/CD.

Responsibilities

• Design, develop, and maintain scalable ETL pipelines and BI solutions.
• Develop complex database scripts, procedures, and views; optimize performance.
• Apply Python proficiency to data integration and app development.
• Collaborate with data, DevOps, and infrastructure teams across environments.

Skills

Python

Database scripting

ETL pipelines

CI/CD workflows

DevSecOps

Data warehousing

Education

Bachelor’s degree

Job description

Location: Chantilly, VA

Security Clearance: Active TS or higher [Required]

Job Type: Full-Time

Target Salary Range*: $145,000 - $190,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 builds efficient extract, transform, and load (ETL) pipelines, optimizes database performance, and applies DevSecOps practices to support accurate, reliable data processing. The developer collaborates with data architects, DevOps teams, and infrastructure specialists to support applications across multi-enclave environments and advance enterprise data warehousing practices.

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.
• Integrate modern data pipeline architectures and search indexing technologies to support enterprise data warehousing and cross-functional system integration.

Database Development and Performance

• Write complex database scripts, stored procedures, triggers, and views.
• Conduct performance tuning to ensure data accuracy, processing efficiency, and system reliability.

Python Development and DevSecOps

• Apply advanced Python proficiency to data integration and application development.
• Implement DevSecOps practices, including automation, version control, testing frameworks, and CI/CD workflows.

Application Support and Infrastructure Integration

• Collaborate with data architects, DevOps teams, and infrastructure specialists to support and maintain applications deployed across multi-enclave environments.
• Integrate containerized environments and cloud platforms into data pipeline and application architectures.

Qualifications

Education

• Bachelor’s degree required.

Experience

• Minimum of 10 years of experience.

Skills

• Advanced Python proficiency.
• Ability to develop complex database scripts, stored procedures, triggers, and views.
• Knowledge of ETL pipelines, data mappings, and database performance tuning.
• Knowledge of DevSecOps practices, including automation, version control, testing frameworks, and CI/CD workflows.
• Technical capabilities supporting modern data pipeline architectures, containerized environments, cloud platforms, and search indexing technologies.
• Ability to collaborate across data architecture, DevOps, and infrastructure teams supporting multi-enclave applications.