Data Modeler
Core
Design and deliver implementation-ready logical and physical data models within Azure Databricks (Delta Lake) following Medallion Architecture to enable Data Engineers to begin development immediately.
Role type
Senior Data Modeler
Builds
Bronze, Silver, and Gold layer data models for enterprise data warehouses and modern data platforms
Domain
Cloud data engineering, Azure Databricks, Delta Lake
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Data modelling (Conceptual, Logical, Physical), SQL (DDL, partitioning), Medallion Architecture, 3rd Normal Form, Star Schema, Snowflake Schema, Data Vault, Fact grain definition, Surrogate key strategy, Slowly Changing Dimensions, Conformed dimensions, Aggregation strategy, ER diagramming, Data dictionary creation
Preferred skills
Enterprise Data Warehouse project experience, Modern Data Platform experience
Technologies
Azure Databricks, Delta Lake, ERwin, ER Studio, PowerDesigner, Lucidchart
Responsibilities
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; Design structured models across Bronze, Silver, and Gold layers; Define transformation logic across layers; Incorporate Delta Lake best practices (partitioning, performance, scalability); Ensure models are build-ready for Data Engineering teams; Review implementation alignment with design; Maintain ER diagrams, data dictionary, mapping documents; Enforce enterprise naming standards and modelling best practices
Seniority
Senior, hands-on IC