Data Modeler

First Quadrants; Mumbai; On-site; INR 2,400,000 - 4,200,000; Full time

Job summary

General Insurance Firm is seeking a Senior Data Modeler to design and manage enterprise data models for a Databricks Lakehouse platform with Data Vault 2.0 and dimensional modelling as core methods.

You will architect models across Policy, Claims, Customer, Finance and Regulatory domains, drive governance, metadata and data dictionaries, and mentor junior modelling teams while collaborating with data engineers and architects on scalable, high-performance solutions.

Qualifications

• Must have 8+ years of experience in Data Modelling, Data Architecture, Data Engineering or Enterprise Data Management.
• Strong hands-on experience in Data Vault 2.0 and dimensional modelling.
• Experience with cloud-based data platforms, preferably Databricks Lakehouse.

Responsibilities

• Design conceptual, logical and physical data models across business domains.
• Build Data Vault 2.0 structures including Hubs, Links, Satellites, PIT and Bridge tables.
• Develop dimensional models and semantic models for reporting and analytics.

Skills

Databricks Lakehouse

Delta Lake

Unity Catalog

Dimensional Modelling

Data Warehousing

Advanced SQL

Data Analysis

ETL/ELT

Spark/PySpark

ERwin

SQLDBM

ER Studio

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.

Company: General Insurance Firm

Position: Data Modeler

Reporting To: Chief Data Architect

Experience: 8+ years

Key Responsibilities:

• Design conceptual, logical and physical data models across business domains.
• Build Data Vault 2.0 structures including Hubs, Links, Satellites, PIT and Bridge tables.
• Develop dimensional models and semantic models for reporting and analytics.
• Design data models across Policy, Claims, Customer, Finance, Sales, Premium, Commission and Regulatory domains.
• Define modelling patterns across Bronze, Silver and Gold layers in Databricks Lakehouse.
• Work with Data Architects and Engineers to ensure scalable and high-performance models.
• Drive data governance, metadata, lineage, data dictionaries and modelling standards.
• Translate business requirements and reporting needs into structured data models.
• Conduct design reviews and mentor junior data modelling teams.

Key Skills:

• Databricks Lakehouse, Delta Lake & Unity Catalog.
• Dimensional Modelling & Data Warehousing.
• Advanced SQL & Data Analysis.
• ETL/ELT and Spark/PySpark fundamentals.
• Data Modelling tools such as ERwin, SQLDBM, ER Studio or equivalent.

Candidate Profile:

• 8+ years of experience in Data Modelling, Data Architecture, Data Engineering or Enterprise Data Management.
• Strong hands-on experience in Data Vault 2.0 and dimensional modelling.
• Experience with cloud-based data platforms, preferably Databricks Lakehouse.
• Strong stakeholder management and communication skills.
• Insurance domain experience across Policy, Claims, Customer, Finance or Regulatory Reporting would be preferred.