DBT Developer + AWS | Scalable ELT & Data Modeling

OpenTalent; Pleasanton (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

OpenTalent is seeking a DBT Developer to design, build, and optimize scalable dbt models and ELT pipelines in Pleasanton, CA. You will develop staging and dimensional models using advanced SQL, and create reusable dbt macros with Jinja to standardize transformation logic.

Responsibilities include enhancing incremental dbt models for large datasets and implementing complex SQL transformations across enterprise data platforms.

Qualifications

• Design, develop, and maintain scalable dbt models and ELT pipelines for enterprise data platforms.
• Develop staging, intermediate, fact, and dimension models using dbt and advanced SQL.
• Build complex SQL transformations using CTEs, joins, window functions, aggregations, and subqueries.

Responsibilities

• Develop and optimize incremental dbt models for large-volume datasets.
• Create reusable dbt macros using Jinja to standardize transformation logic.

Skills

dbt

SQL

AWS

Jinja

ELT pipelines

Job description

OpenTalent is seeking a DBT Developer to design, build, and optimize scalable dbt models and ELT pipelines in Pleasanton, CA. You will develop staging and dimensional models using advanced SQL, and create reusable dbt macros with Jinja to standardize transformation logic.

Responsibilities include enhancing incremental dbt models for large datasets and implementing complex SQL transformations across enterprise data platforms.