Job Overview As a Data Modeler, you will design and deliver implementation‑ready logical and physical data models within Azure Databricks (Delta Lake) following Medallion Architecture (Bronze, Silver, Gold). The role ensures Data Engineers can immediately begin development with clear schema definitions, SQL structures, and zero ambiguity.
Key Responsibilities - Data Modelling & Design
- Develop Conceptual, Logical, and Physical Data Models.
- Define schemas, entities, attributes, relationships, keys, constraints, and data types.
- Provide DDL‑ready SQL definitions for implementation.
- Clearly define fact table grain and dimensional structures.
- Azure Databricks – Medallion Modelling
- Design structured models across:
- Bronze Layer – Raw ingestion, schema control.
- Silver Layer – Cleansed, conformed, standardized data.
- Gold Layer – Business‑ready dimensional models...