ETL Developer (SME)

Posted 10 Hours Ago
Be an Early Applicant
Chantilly, VA, USA
In-Office
165K-185K Annually
Expert/Leader
Information Technology • Professional Services • Cybersecurity • Defense
The Role
Designs and maintains scalable ETL pipelines, data integration frameworks, databases, and business intelligence solutions. Develops Python automation, database scripts, stored procedures, and performance optimizations. Applies DevSecOps, CI/CD, containerization, cloud integration, and search indexing across multi-enclave environments. Serves as an ETL and data integration subject matter expert, providing technical leadership and collaborating with data architecture, DevOps, and infrastructure teams.
Summary Generated by Built In

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 ResponsibilitiesData 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.
QualificationsEducation
  • 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]

Skills Required

  • Bachelor's degree
  • Minimum 10 years of relevant experience
  • Advanced Python proficiency
  • Ability to develop complex database scripts, stored procedures, triggers, and views
  • Knowledge of ETL pipelines and data mappings
  • Knowledge of database performance tuning
  • Knowledge of DevSecOps practices, including automation, version control, testing frameworks, and CI/CD workflows
  • Technical experience supporting modern data pipeline architectures
  • Experience with containerized environments and cloud platforms
  • Experience with search indexing technologies
  • Ability to collaborate across data architecture, DevOps, and infrastructure teams supporting multi-enclave applications
  • Active Top Secret security clearance
  • Ability to obtain a CI polygraph
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Vienna, VA
200 Employees
Year Founded: 2011

What We Do

The Amatriot Group is a talent solutions firm providing technology expertise to the federal and commercial sectors. With over a decade of experience delivering mission-critical support to the intelligence, defense, and national security sectors, the company specializes in delivering cutting-edge technology solutions by securing top-tier talent to bridge workforce gaps in the most complex and secure environments.

Similar Jobs

Accenture Federal Services Logo Accenture Federal Services

ETL Developer - SME

Artificial Intelligence • Information Technology • Consulting • Cybersecurity
In-Office
Chantilly, VA, USA
17634 Employees
106K-221K Annually

Hilton Logo Hilton

Manager Compensation & Performance Technology

Events • Food • Travel • Hospitality • Hotels & Resorts
Hybrid
3 Locations
500000 Employees
90K-130K Annually

Samsara Logo Samsara

Senior Manager, Consulting Services

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
119K-213K Annually

CDW Logo CDW

Senior AI Software Consulting Engineer

Artificial Intelligence • Cloud • Information Technology • Consulting • Cybersecurity • Infrastructure as a Service (IaaS)
Remote or Hybrid
US
15100 Employees
107K-150K Annually

Similar Companies Hiring

Cravath, Swaine & Moore LLP Thumbnail
Legal Tech • Other • Professional Services
New York, NY
1200 Employees
VCA Animal Hospitals Thumbnail
Pet • Professional Services
Los Angeles, CA
35000 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account