Data Modeler - Azure Databricks (Medallion Architecture)

Rackspace

↗

IT Services and IT Consulting 👥 5K-10K employees employees 📍 San Antonio, Texas

Job 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.

Key Responsibilities

• Develop Conceptual, Logical, and Physical Data Models for Azure Databricks (Delta Lake) following Medallion Architecture
• 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, Silver, and Gold Layers
• 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
• Maintain ER diagrams, data dictionary, mapping documents
• Enforce enterprise naming standards and modelling best practices

Required Qualifications

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