Senior ETL Engineer & SME - TS Cleared

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

Job summary

Amatriot Group, LLC is seeking an ETL Developer (SME) in Chantilly, VA to design, develop, and maintain scalable data integration frameworks and BI solutions that enable cyber investigations.

The role builds ETL pipelines, optimizes database performance, and applies DevSecOps practices across multi-enclave environments, collaborating with data architects, DevOps, and infrastructure teams.

Qualifications

• Minimum 10 years of experience in data engineering or related field.
• Strong Python proficiency and experience with ETL pipelines.
• Knowledge of DevSecOps practices, automation, version control, testing frameworks, and CI/CD workflows.
• Experience with data warehousing concepts, data mappings, and database performance tuning.

Responsibilities

• Design, develop, and maintain scalable ETL pipelines and BI solutions.
• Architect ETL pipelines and data mappings to extract, transform, and load complex datasets.
• Write complex database scripts, stored procedures, triggers, and views; tune performance.
• Apply advanced Python proficiency to data integration and application development; implement CI/CD practices.
• Collaborate with data architects, DevOps teams, and infrastructure specialists across multi-enclave environments.

Skills

Advanced Python

ETL pipelines

Data integration

SQL scripting

DevSecOps

CI/CD workflows

Cloud platforms

Containerization

Job description

Amatriot Group, LLC is seeking an ETL Developer (SME) in Chantilly, VA to design, develop, and maintain scalable data integration frameworks and BI solutions that enable cyber investigations.

The role builds ETL pipelines, optimizes database performance, and applies DevSecOps practices across multi-enclave environments, collaborating with data architects, DevOps, and infrastructure teams.