Data Modeler – Azure Databricks (Medallion Architecture) - RAXJP00002194 - Dubai

AMroute LLC; Dubai; On-site; AED 147,000 - 165,000; Full time

Job summary

AMroute LLC is looking for a Data Modeller in Dubai for a 12-month contract. The ideal candidate will have over 8 years of hands-on data modelling experience, strong SQL skills, and proven expertise in Azure Databricks and Delta Lake environments. Responsibilities include designing logical and physical data models and ensuring alignment with best practices. Candidates must also have a deep understanding of Medallion Architecture and experience with data modelling tools like ERwin or PowerDesigner.

Qualifications

• 8+ years of hands-on Data Modelling experience.
• Strong SQL (DDL, partitioning, performance concepts).
• Proven experience in Azure Databricks and Delta Lake environments.

Responsibilities

• Design and deliver logical and physical data models.
• Define schemas, entities, attributes, and data types.
• Incorporate Delta Lake best practices.

Skills

Data Modelling

SQL

Azure Databricks

Medallion Architecture

Tools

ERwin

PowerDesigner

Job description

Position: 1 Duration: 12 months Location: Dubai Address: 3, Al Rigga road Al Muraqqabat, Deira, Dubai Level 7 Working Hours/Time Zone: 8 hrs/day, UAE time (following the UAE labour law) Onsite/Remote: Onsite

Interview process: All profiles will go through an online test. Only candidates who clear the test will proceed to two rounds of interviews – 1) Internal Technical discussion, 2) Client Technical discussion.

Bill Rate: USD 20-22/hr – this rate is the only accepted rate.

Top 3 requirements: Strictly follow the JD shared; worked as a data modeller (must have more than 8+ experience as data modeller); clear understanding of data modelling concepts; experience implementing data modelling in Lakehouse projects.

Role Purpose

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
  • Bronze Layer – Raw ingestion, schema control
  • Silver Layer – Cleansed, conformed, standardized data
  • Gold Layer – Business‑ready dimensional models
• Define transformation logic across layers (Bronze > Silver > Gold)
• Incorporate Delta Lake best practices (partitioning, performance, scalability)
• Advanced Modelling Techniques
  • Strong hands‑on expertise in 3rd Normal Form (3NF), Star Schema, Snowflake Schema, Data Vault (Hubs, Links, Satellites)

Must Clearly Define

• Fact grain
• Surrogate key strategy
• Slowly Changing Dimensions (Type 1 & 2)
• Conformed dimensions
• Aggregation strategy
• Engineering & Governance Alignment
• 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

Required Skills & Experience

• 8+ 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)