Data Modeler - Azure Databricks (Medallion Architecture)
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Rackspace Technology is a leading provider of expertise and managed services across all the major public and private cloud technologies. We’ve evolved Fanatical Support to encompass the entire customer journey — providing Fanatical Experience from first consultation to daily operations.
Key Skills for This Role
Full Job Posting
Overview
Rackspace Technology is a leading provider of expertise and managed services across all the major public and private cloud technologies.
We’ve evolved Fanatical Support to encompass the entire customer journey — providing Fanatical Experience™ from first consultation to daily operations.
Our passionate experts combine the power of proactive, always-on service and expertise with best-in-class tools and automation to deliver technology when and how our customers need it.
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.
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.
- Define transformation logic across layers (Bronze → Silver → Gold).
- Incorporate Delta Lake best practices (partitioning, performance, scalability).
Advanced Modelling Techniques
.
• 3rd Normal Form (3NF)
- Star Schema
- Snowflake Schema
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
- 5+ 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).
- We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses.
- These tools assist our recruitment team but do not replace human judgment.
- Final hiring decisions are ultimately made by humans.
- If you would like more information about how your data is processed, please contact us.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Rackspace Technology
Data Modeler (Azure Databricks)
Dubai, UAE
*\\ Only formal applications submitted with a CV will be considered. Direct messages and/or InMails will not be reviewed \*** Rackspace Technology is a leading provider of expertise and managed services across all the ma
Data Modeler
Dubai, UAE
Rackspace Technology is a leading provider of expertise and managed services across all the major public and private cloud technologies. We’ve evolved Fanatical Support to encompass the entire customer journey — providin