dbt Semantic Model Architect/Engineer

Summary: The role of dbt Semantic Model Architect/Engineer involves leading a data transformation project by designing and implementing dbt MetricFlow semantic models and building data pipelines into Snowflake. The position requires expertise in deploying the dbt Cloud Semantic Layer and establishing a governed metrics layer for analytics. This fully remote position offers a competitive daily rate and has strong potential for contract extension. The ideal candidate will have a solid background in data modeling and integration with various tools and technologies.

Key Responsibilities:

• Design and build dbt MetricFlow Semantic Models (entities, dimensions, measures, and metrics)
• Develop ingestion pipelines from external APIs into Snowflake
• Deploy and manage the dbt Cloud Semantic Layer and Semantic Layer API
• Configure metadata, access control, and governance
• Build a lightweight natural language query interface
• Migrate business logic from Power BI and Tableau into a governed semantic layer

Key Skills:

• dbt Core & dbt Cloud
• dbt MetricFlow/Semantic Layer
• Snowflake
• Advanced SQL
• Dimensional Data Modelling
• REST/XML API Integration
• React (or similar Front End framework)

Salary (Rate): £700/day

City: London

Country: UK

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT