Senior Data Modeler – Databricks Lakehouse

Location:
Trivandrum / Pune

Experience:
10–15 Years

Employment Type:
Full time

Work Mode:
Hybrid

Domain Preference:
Insurance / Financial Services

Contract 2 Hire

About the Rol

eWe are looking for a highly experienced
Senior Data Modele
r to lead enterprise-scale data modelling initiatives for a Databricks-based Lakehouse platform. The ideal candidate will possess deep expertise in
Data Vault 2.0, dimensional modelling, Delta Lake, Unity Catalog, and enterprise data governanc
e

.This role will be responsible for designing scalable, governed, and audit-ready data models that support regulatory reporting, analytics, AI/ML, management reporting, and self-service BI across the organization

.Key Responsibilitie

sEnterprise Data Modellin
- gDesign conceptual, logical, and physical data models across enterprise business domains
- .Develop and maintain Data Vault 2.0 structures including Hubs, Links, Satellites, PIT, and Bridge tables
- .Create dimensional models, star schemas, snowflake schemas,



and semantic consumption layers
- .Build canonical data models for Customer, Policy, Claims, Finance, Premium, Commission, and Sales domains
- .Lead source-to-target mapping workshops and convert business requirements into governed data structures

.Databricks Lakehouse Architectur
- eDefine modelling standards for Bronze, Silver, and Gold layers
- .Design Delta Lake optimized data structures for analytical and reporting workloads
- .Collaborate with architects and engineers to ensure scalable and performant implementations
- .Drive model optimization strategies including partitioning, clustering, normalization, and denormalization

.Governance & Metadata Managemen
- tEstablish enterprise data modelling standards and naming conventions
- .Support Unity Catalog governance and data organization strategies
- .Maintain data dictionaries, business glossaries, metadata repositories, and lineage documentation
- .Ensure models comply wi

📌 Data Modeler (Pune Division)
🏢 Dreampath Services
📍 Pune Division