Security-Cleared Senior dbt ETL Engineer (Data Warehouse)

Onyx Government Services,LLC; Chantilly (VA); On-site; USD 125,000 - 145,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401(k) retirement plan

Paid time off (PTO)

Company-paid holidays

Short-term and long-term disability

Job summary

Onyx Government Services, LLC is seeking a Sr ETL Developer with strong dbt experience to design, develop, and maintain scalable data pipelines for Federal data management and Advanced Analytics projects.

The ideal candidate will have deep SQL/PLSQL skills, hands-on dbt expertise, and experience with modern data platforms. You will contribute to data warehousing efforts, create ETL/ELT processes, and ensure data quality across environments.

Qualifications

• Active BI or NACLC Public Trust security clearance.
• Bachelor’s degree with 7 years of database (ETL) development or data processing/analytical experience.
• Strong hands-on experience with dbt, including models, tests, snapshots, macros, seeds, and documentation.
• Experience with Git and source-control-based development.
• Familiarity with CI/CD processes and automated testing.
• Strong SQL and PL/SQL skills; expertise with data warehouse.

Responsibilities

• Design and develop ETL processes.
• Design, develop, and maintain reliable ETL/ELT data pipelines.
• Develop and maintain data transformation workflows using dbt.
• Write complex and optimized SQL queries for data extraction, transformation, and analysis.
• Build and maintain dbt models, sources, tests, snapshots, and documentation.
• Convert existing PL/SQL procedures into SSIS packages.
• Troubleshoot existing ETL solutions.
• Query Oracle databases for data analysis and data quality assurance.

Skills

dbt

SQL

PL/SQL

SSIS

Data warehousing

Git

CI/CD

Agile

Oracle

PostgreSQL

Data quality

Mentoring

Education

Bachelor’s degree

Tools

Tableau

Python

Airflow

Dagster

AWS

Azure

GCP

Job description

Onyx Government Services, LLC is seeking a Sr ETL Developer with strong dbt experience to design, develop, and maintain scalable data pipelines for Federal data management and Advanced Analytics projects.

The ideal candidate will have deep SQL/PLSQL skills, hands-on dbt expertise, and experience with modern data platforms. You will contribute to data warehousing efforts, create ETL/ELT processes, and ensure data quality across environments.