Data Modeler

Working Hours/Time Zone: 8 hrs/day, UAE time (following the UAE labour law)Onsite/Remote: OnsiteInterview process: All profiles will go through online test, only the candidates who cleared the test will go through the 2 rounds of interview – 1- Internal Technical discussion, 2- Client Technical discussion.Top 3 requirements: Strictly follow the JD shared, Worked as a data modeller (must have - more than 1yr experience as data modeller), clear understanding on the data modelling concepts, has experience on implementing the data modelling in Lakehouse projects.Job DescriptionRole PurposeDesign 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 ResponsibilitiesDevelop 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:Gold Layer – Business‑ready dimensional models.Snowflake SchemaMust clearly define:Slowly Changing Dimensions (Type 1 & 2)Conformed dimensionsEngineering & Governance AlignmentEnsure models are build‑ready for Data Engineering teams.Review implementation alignment with design.Enforce enterprise naming standards and modelling best practices.Required Skills & Experience5+ years of hands‑on Data Modelling experience.Strong SQL (DDL, partitioning, performance concepts).Proven experience in Azure Databricks and Delta Lake environments.Deep understanding of Medallion Architecture.Experience in enterprise Data Warehouse or Modern Data Platform projects.Proficiency with data modelling tools (ERwin, ER Studio, PowerDesigner, Lucidchart, or similar).#J-18808-Ljbffr