About the Role
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.
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 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).
- 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.
Requirements
- 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.
- 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).
Skills
- Data Modelling
- Azure Databricks
- Delta Lake
- Medallion Architecture
- SQL
- ERwin
- ER Studio
- PowerDesigner
- Lucidchart
Experience Level
- 5+ years of hands-on Data Modelling experience
About the Company
- Rackspace Technology is a leading provider of expertise and managed services across all the major public and private cloud technologies.
- We are the multicloud solutions experts.
- We combine our expertise with the world’s leading technologies — across applications, data and security — to deliver end-to-end solutions.
- We have a proven record of advising customers based on their business challenges, designing solutions that scale, building and managing those solutions, and optimizing returns into the future.
- Named a best place to work, year after year according to Fortune, Forbes and Glassdoor, we attract and develop world-class talent.
- Join us on our mission to embrace technology, empower customers and deliver the future.
- We embrace the notion that unique perspectives fuel innovation and enable us to best serve our customers and communities around the globe.
Equal Opportunity
- We are committed to offering equal employment opportunity without regard to age, color, disability, gender reassignment or identity or expression, genetic information, marital or civil partner status, pregnancy or maternity status, military or veteran status, nationality, ethnic or national origin, race, religion or belief, sexual orientation, or any legally protected characteristic.
- If you have a disability or special need that requires accommodation, please let us know.
