Experience: 10–15 Years
Location: Trivandrum / Pune
Work Mode: Hybrid – 4 Days WFO per Month
Job Summary
We are looking for a highly experienced Senior Data Modeler with strong expertise in enterprise data modeling and Databricks Lakehouse architecture. The ideal candidate should have strong experience in dimensional modeling, metadata management, data governance, and insurance data domains.
Key Responsibilities
- Design and maintain Conceptual, Logical, Physical, and Business Data Models.
- Develop dimensional models using Star and Snowflake Schemas.
- Define enterprise data warehouse and data lakehouse models.
- Create and maintain Source-to-Target Mapping (STTM) documentation.
- Design scalable data models for Azure Databricks and Delta Lake environments.
- Work with Unity Catalog, ADLS, and Databricks for data management.
- Define data standards, metadata, relationships, and business rules.
- Collaborate with data engineers, architects, business stakeholders, and governance teams.
- Ensure data models align with enterprise data governance and quality standards.
Mandatory Skills
- Dimensional Modeling
- Star & Snowflake Schema
- Enterprise Data Modeling
- Data Warehouse / Lakehouse
- Conceptual, Logical, Physical & Business Data Models
- Source-to-Target Mapping (STTM)
- Azure Databricks
- Unity Catalog
- Delta Lake
- ADLS
- Advanced SQL
- Metadata Management
- Data Governance
Domain Experience
Commercial Insurance / Property & Casualty (P&C) Insurance
Pay: ₹50,000.00 - ₹80,000.00 per month
Benefits:
Work Location: In person