Jobs → Engineering → dbt Engineer

About the Role We are looking for a dbt Engineer to join our team. This role focuses on building and maintaining data transformation pipelines using dbt. Key Responsibilities • Design and implement dbt models, snapshots, seeds, tests, macros, and incremental models • Develop complex SQL queries for data transformation and analysis • Optimize dbt transformations and SQL queries for performance • Integrate dbt with orchestration tools like Airflow or Dagster • Implement CI/CD pipelines for data pipelines Requirements • 7+ years of experience in Data Engineering, Analytics Engineering, or Data Warehousing • Strong hands-on experience with dbt Core / dbt Cloud • Expertise in dbt models, snapshots, seeds, tests, macros, Jinja, and incremental models • Advanced SQL skills, including complex joins, CTEs, window functions, query optimization, and performance tuning • Strong experience with at least one cloud data warehouse: Snowflake, Databricks, BigQuery, or Amazon Redshift • Hands-on experience with dimensional data modeling, Star Schema, Snowflake Schema, SCD Type 1 & 2, and ELT architecture • Experience with Python scripting for data processing, automation, and pipeline development • Knowledge of data quality testing, custom validations, data lineage, documentation, and data integrity • Experience with Git, GitHub/GitLab, CI/CD pipelines, automated testing, and deployment workflows • Experience integrating dbt with Airflow, Dagster, or equivalent orchestration tools • Strong experience optimizing dbt transformations, SQL queries, and large-scale datasets Nice to Have • Experience implementing CI/CD using GitHub Actions, GitLab CI, or Azure DevOps • Knowledge of cloud warehouse resource optimization and scalable data pipeline architecture • Strong troubleshooting, analytical, and communication skills • Ability to work independently and collaborate with distributed teams