Data Engineer (dbt, Snowflake, Power BI, ADF)

Quick Facts

• Role: Data Engineer (dbt, Snowflake, Power BI, ADF)

Description

Build and own the analytics layer that turns raw data into trusted star-schema models in Snowflake, using dbt and powering Power BI reporting. Own end-to-end data flows from Azure Data Factory through dbt and a Data Vault layer to the star schemas that serve reporting. The role is ~70% hands-on development plus code review, coaching, and platform improvements.

Responsibilities

• Design and build star-schema data models in Snowflake with dbt (fact, dimension, bridge, aggregate tables)

• Own end-to-end data flow: Azure Data Factory intake → dbt and Data Vault layer → Snowflake star schemas powering Power BI

• Write, tune, and automate complex SQL and large Snowflake workloads

• Create dbt tests, documentation, and reusable modeling patterns to maintain data quality

• Automate builds and infrastructure with GitHub Actions and Terraform

• Review code and coach backend developers and data engineers

• Set data modeling standards and guide architecture decisions

• Propose improvements and bring new ideas to the platform

• Support API components that feed data into the platform

• Partner with product owners, architects, and business teams to translate performance questions into data models

Requirements

• 8+ years in data engineering or data warehousing, including 4+ years hands-on with dbt and Snowflake

• Expert, hands-on dbt experience: built models, written tests, and deployed to production

• Expert Snowflake experience: architecture, performance tuning, and SQL optimization

• Proven ability to design and build enterprise-scale star-schema (dimensional) models

• Hands-on experience automating SQL workloads and data processes

• Track record of solving data problems end-to-end and leading technical design decisions

• Hands-on experience with GitHub for version control and team development

Benefits

• Ownership of analytics modeling and end-to-end data flows

• Opportunity to coach engineers and shape platform standards and architecture