Responsibilities:
Translate business requirements and Supply Chain use cases into conceptual, logical, and physical data models.
Design Databricks schemas optimized for Medallion Architecture and distributed processing settings.
Develop dimensional models, star schemas, conformed dimensions, and analytical data structures.
Design and govern Data Vault 2.0 or alternative analytical modeling patterns where appropriate.
Define canonical keys, entity grain, conformed dimensions, and business definitions across Supply Chain domains.
Design scalable Delta Lake physical structures that optimize storage, performance, and cost.
Drive partitioning, clustering, distribution, and optimization strategies for enterprise analytics workloads.
Define and govern SCD Type 1 and Type 2 methodologies across Silver and Gold layers.
Establish reusable modeling patterns and collaborate with engineers on reusable SCD framework implementation.
Design semantic models, views, and governed consumption layers supporting enterprise BI platforms.
Define data lineage, ownership, refresh strategies, and semantic documentation standards.
Ensure alignment with Unity Catalog governance and enterprise standards.
Serve as the semantic authority across Supply Chain entities and analytical products.




Enforce enterprise data modeling, naming, governance, and architectural standards.
Mentor engineers and analysts on best practices related to grain, conformance, versioning, and model design.

Must-Have Skills:
Advanced conceptual, logical, and physical data modeling experience.
Robust Databricks data modeling expertise.
Experience designing star schemas, fact and dimension tables, Data Vault 2.0 solutions, and other enterprise analytical data structures.
Expertise defining canonical keys, entity grain, and conformed dimensions.
Deep knowledge of Delta Lake physical design including clustering, partitioning, bloom filters, identity columns, and time-travel strategies.
Experience optimizing distributed processing and query performance.
Strong expertise with SCD Type 1 and Type 2 design strategies.
Experience designing reusable Silver and Gold data assets.
Experience creating semantic layers for BI and analytics consumption.
Solid understanding of Unity Catalog and enterprise governance models.
Experience documenting business definitions, lineage, ownership, and consumption models.
Proven leadership experience establishing data standards and governance practices.

📌 Senior Data Modeler Bengaluru (India)
🏢 Everforth Apex Systems
📍 India