Skill Profile
Data Modelling
"The observable action of structuring data into logical schemas and semantic layers that make it easier to query, understand, and maintain over time."
YOUR SKILLS
Problems This Skill Solves
- A data warehouse has hundreds of tables but no one can tell which one contains the authoritative version of a metric.
- An analyst writes the same revenue calculation five different ways in five different reports, producing five different numbers.
- A new tool is connected to the data platform but the team cannot understand the data without a semantic layer.
- A downstream dashboard breaks every time the raw data schema changes because there is no transformation layer between them.
Roles That Use This Skill
1 total · 1 industryThis skill is concentrated in one industry.
Technology / Business / Finance
"Data modelling is the same as database modelling"
Data modelling in an analytical context focuses on semantic layers and transformations for querying, not just storage schema design.
"Data modelling in dbt is mainly about organising SQL into reusable models — the value is code reuse and documentation."
Code reuse and documentation are outputs of good modelling, not the goal. The primary challenge is deciding how to represent business concepts — what constitutes a unique customer, how to handle slowly changing dimensions, where to draw the boundary between raw and curated data — in ways that remain correct as business definitions change. Those are design decisions that dbt facilitates but does not resolve.
Research & Outlook
As the modern data stack matures, analytical engineering — the discipline of modelling data for reliable, documented analysis — is becoming a distinct and valued profession.
See This Skill In Action
Watch a professional demonstrate Data Modelling in a real working environment — what it looks like, how it's applied, and why it matters.
Technical / Data
Data Modelling
Growth Path
How to Practise
- 1.Build a dbt project that transforms raw data into clean analytical models
- 2.Study Kimball's dimensional modelling methodology
- 3.Design a star schema for a business domain you know well
How to Prove
- ·dbt project in production serving analytical queries
- ·Data model documentation with clear definitions of business entities