The Amatriot Group

ETL Developer (SME)

The Amatriot Group  •  $165k - $185k/yr  •  Chantilly, VA (Onsite)  •  4 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

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]
The Amatriot Group

About The Amatriot Group

The Amatriot Group (formerly Government Tactical Solutions) is a talent solutions firm built on almost 15 years of experience delivering mission-critical support to the intelligence, defense, and national security sectors of the federal government. With a proven track record in the defense and intelligence communities, Amatriot brings the expertise and agility needed to rapidly fill gaps and provide customizable solutions to the most complex, secure environments. Our speed-to-market approach ensures vacancies are filled both quickly and accurately. Amatriot specializes in delivering cutting-edge technology solutions by securing top-tier talent to bridge workforce gaps.

Industry
IT & Software
Company Size
51-200 employees
Headquarters
Vienna, Virginia
Year Founded
2011
Social Media