Job Description
We are looking for a Senior Data Modeler to join a General Insurance Firm. The role is to design and manage enterprise data models for a Databricks-based Lakehouse platform. The role will focus on Data Vault 2.0, dimensional modelling, data governance and building scalable models for reporting, analytics, AI/ML and regulatory requirements.
n

nCompany: General Insurance Firm
nPosition: Data Modeler
nReporting To: Chief Data Architect
nExperience: 8+ years
nLocation: Navi Mumbai
n

nKey Responsibilities:
n
- n
- Design conceptual, logical and physical data models across business domains.n
- Build Data Vault 2.0 structures including Hubs, Links, Satellites, PIT and Bridge tables.n
- Develop dimensional models and semantic models for reporting and analytics.n
- Design data models across Policy, Claims, Customer, Finance, Sales, Premium, Commission and Regulatory domains.n
- Define modelling patterns across Bronze, Silver and Gold layers in Databricks Lakehouse.n
- Work with Data Architects and Engineers to ensure scalable and high-performance models.n




- Drive data governance, metadata, lineage, data dictionaries and modelling standards.n
- Translate business requirements and reporting needs into structured data models.n
- Conduct design reviews and mentor junior data modelling teams.n

n

nKey Skills:
n
- n
- Data Vault 2.0 & Enterprise Data Modelling.n
- Databricks Lakehouse, Delta Lake & Unity Catalog.n
- Dimensional Modelling & Data Warehousing.n
- Advanced SQL & Data Analysis.n
- Data Governance, Metadata & Lineage.n
- ETL/ELT and Spark/PySpark fundamentals.n
- Data Modelling tools such as ERwin, SQLDBM, ER Studio or equivalent.n

n

nCandidate Profile:
n
- n
- 8+ years of experience in Data Modelling, Data Architecture, Data Engineering or Enterprise Data Management.n
- Solid hands-on experience in Data Vault 2.0 and dimensional modelling.n
- Experience with cloud-based data platforms, preferably Databricks Lake

📌 Data Modeler (Thane)
🏢 First Quadrants
📍 Thane