dbt MetricFlow and dbt Cloud specialist
Summary: The role of a dbt MetricFlow and dbt Cloud specialist involves designing and implementing a governed semantic layer for natural language querying across enterprise data sources in Snowflake. This hands-on position requires ownership of the entire implementation process, from architecture to production deployment, ensuring a fully tested and documented solution. The specialist will also be responsible for developing ingestion pipelines and managing the semantic layer within dbt Cloud. Strong technical skills in dbt, SQL, and data modeling are essential for success in this role.
Key Responsibilities:
- Design and develop dbt MetricFlow semantic models, including entities, dimensions, measures and business metrics.
- Build ingestion pipelines for multiple external data sources into Snowflake.
- Deploy and manage the semantic layer within dbt Cloud.
- Configure and support the Semantic Layer API.
- Implement role-based access control and integrate metadata management.
- Configure and integrate the dbt MCP Server with the deployed semantic layer.
- Develop a lightweight natural language query interface once the semantic layer has been validated.
- Review existing Power BI and Tableau dashboards and migrate business logic into the governed semantic layer.
- Produce clear technical documentation and handover materials.
Key Skills:
- Strong hands-on experience with dbt Core and dbt Cloud.
- Proven experience building dbt MetricFlow semantic models.
- Excellent SQL skills.
- Strong dimensional data modelling experience.
- Experience working with Snowflake data platforms.
- Experience deploying and managing the dbt Cloud Semantic Layer API.
- Front End development experience using React or a similar framework.
- Comfortable working with modern and evolving technologies.
Salary (Rate): £700/Day
City: undetermined
Country: United Kingdom
Working Arrangements: undetermined
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Detailed Description From Employer:
We are looking for an experienced dbt MetricFlow and dbt Cloud specialist to design and build a governed semantic layer that enables natural language querying across multiple enterprise data sources hosted in Snowflake.
This is a hands-on delivery role where you will own the semantic layer implementation from architecture through to production deployment, delivering a fully tested and documented solution ready for handover.
Key Responsibilities
- Design and develop dbt MetricFlow semantic models, including entities, dimensions, measures and business metrics.
- Build ingestion pipelines for multiple external data sources into Snowflake.
- Deploy and manage the semantic layer within dbt Cloud.
- Configure and support the Semantic Layer API.
- Implement role-based access control and integrate metadata management.
- Configure and integrate the dbt MCP Server with the deployed semantic layer.
- Develop a lightweight natural language query interface once the semantic layer has been validated.
- Review existing Power BI and Tableau dashboards and migrate business logic into the governed semantic layer.
- Produce clear technical documentation and handover materials.
Required Skills & Experience
- Strong hands-on experience with dbt Core and dbt Cloud.
- Proven experience building dbt MetricFlow semantic models.
- Excellent SQL skills.
- Strong dimensional data modelling experience.
- Experience working with Snowflake data platforms.
- Experience deploying and managing the dbt Cloud Semantic Layer API.
- Front End development experience using React or a similar framework.
- Comfortable working with modern and evolving technologies.
Desirable Experience
- Migrating Power BI DAX calculations or Tableau calculated fields into a semantic or metrics layer.
- Experience with Snowflake Cortex Analyst or Snowflake Semantic Views.
- Building data ingestion pipelines using REST or XML APIs.
- Experience with metadata management solutions.
- Experience within healthcare, pharmaceutical or life sciences data environments.
Similar Jobs
Apologies, there are currently no similar jobs available.