Snowflake-DBT
Share
Job Location:
Monthly Salary:
Posted on:
8 hours ago
Vacancies:
1 Vacancy
Job Summary
A Snowflake dbt Data Engineer or Developer is responsible for building and maintaining the transformation layer of a modern data stack. This role bridges the gap between raw data storage in Snowflake and actionable insights for business users by leveraging dbt (Data Build Tool) to write modular version-controlled SQL transformations.
Snowflake
Core Responsibilities
- Data Transformation Pipelines: Design and implement end-to-end ELT (Extract Load Transform) pipelines within Snowflake using dbt.
- Data Modeling: Build scalable data models using frameworks like Star Schema Snowflake Schema or Medallion Architecture (staging intermediate and mart layers).
- Performance Optimization: Tune Snowflake performance through warehouse sizing clustering and materialization strategies.
- Quality & Testing: Implement automated data quality tests (e.g. uniqueness non-null referential integrity) and generate documentation using dbt docs.
- DevOps & CI/CD: Manage code versioning via Git and automate deployments using CI/CD pipelines (e.g. GitHub Actions Azure DevOps).
- Orchestration: Schedule and monitor data workflows using tools like Airflow Dagster
