DBT Developer Snowflake
Shaarpro · Los Angeles, CA · 1 wk ago
EngineeringFull-time
Key Responsibilities
- Design, build, and maintain modular dbt models across staging, intermediate, and marts layers that transform raw data into trusted, analytics-ready datasets.
- Develop and optimize dbt incremental models, snapshots, macros, seeds, sources, and reusable packages using dbt Core and/or dbt Cloud.
- Write and tune complex SQL transformations in Snowflake using joins, CTEs, window functions, aggregations, conditional logic, and performance optimization techniques.
- Optimize Snowflake workloads for query performance, clustering strategy, warehouse sizing, model materialization, processing time, and cost efficiency.
Requirements
- Proficiency in DBT and SQL
- Experience working with Snowflake
- Understanding of Snowflake Schema
Preferred Skills
- Experience with dbt Core and/or dbt Cloud
- Knowledge of data warehousing best practices
- Ability to work in a fast-paced environment and meet deadlines