Data Modeler

Description:

Role: Design and deliver logical & physical data models in Azure Databricks (Delta Lake) following Medallion Architecture (Bronze → Silver → Gold), enabling Data Engineers to start development with clear, build-ready schemas.

Key Requirements:

• 5+ years in Data Modelling, 1+ year as dedicated Data Modeler.
• Strong SQL & hands-on Azure Databricks / Delta Lake experience.
• Expertise in 3NF, Star/Snowflake Schema, Data Vault, Slowly Changing Dimensions, conformed dimensions.
• Experience in Lakehouse/Data Warehouse projects.

Responsibilities:

• Develop conceptual, logical, physical data models.
• Define schemas, entities, keys, relationships, and provide DDL-ready SQL.
• Implement Medallion Architecture layers & transformation logic.
• Maintain ER diagrams, data dictionary, mapping documents, and enforce modeling best practices.