Senior ETL Developer: dbt & Data Warehouse Expert

Onyx Government Services,LLC; Fairfax (VA); Hybrid; USD 130,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

Disability insurance

Life insurance

Job summary

Onyx Government Services, LLC, headquartered in Fairfax, VA, seeks a Sr ETL Developer with strong dbt and SQL skills to design, develop, and maintain scalable data pipelines for DoD/IC analytics.

The role requires expert ETL/ELT capabilities, PL/SQL, SSIS, and experience with Oracle and PostgreSQL. CI/CD, Git, and Jira in an Agile setting are essential assets, with a potential for cloud integration.

Qualifications

• Bachelor’s degree with 7 years of database/ETL development or data processing and analytics experience.
• Strong hands-on dbt experience including models, tests, snapshots, macros, seeds, and documentation.
• Hands-on SQL/PL/SQL skills and experience with data warehousing concepts.
• Experience with SSIS and Oracle and PostgreSQL databases.

Responsibilities

• Design and develop ETL/ELT data pipelines and transformation workflows.
• Build and maintain dbt models, sources, tests, snapshots, and documentation.
• Convert PL/SQL procedures into SSIS packages and optimize SQL queries.
• Troubleshoot ETL solutions and ensure data quality across data warehouses.
• Collaborate with team and clients in an Agile environment using Jira.

Skills

dbt

SQL

PL/SQL

Git

CI/CD

Jira

Agile

Tableau

Python

Airflow

AWS

Azure

GCP

Oracle

PostgreSQL

Data warehousing

SSIS

Education

Bachelor's degree

Tools

Git

Tableau

Jira

Job description

Onyx Government Services, LLC, headquartered in Fairfax, VA, seeks a Sr ETL Developer with strong dbt and SQL skills to design, develop, and maintain scalable data pipelines for DoD/IC analytics.

The role requires expert ETL/ELT capabilities, PL/SQL, SSIS, and experience with Oracle and PostgreSQL. CI/CD, Git, and Jira in an Agile setting are essential assets, with a potential for cloud integration.