Data Modeller + DWH (Snowflake | Erwin | Insurance Domain) | Pan India

Job Summary

Value Innovation Labs is hiring a senior Data Modeller with strong data warehousing and Snowflake experience for a leading enterprise client. You will design the logical and physical data models behind the warehouse and data mart layers, with a focus on insurance policy, claims and financial data.

Roles & Responsibilities

- Design and develop logical and physical data models for data warehouse and data mart layers in Snowflake

- Create and maintain Source to Target Mapping (STM) documents, ensuring accurate mapping for policy, claims and financial domains

- Define entities, attributes and relationships based on business requirements, data sources and analytical needs

- Validate transformation logic for downstream consumption layers used by DBT pipelines and Power BI models

- Run in-depth data analysis and profiling, including JSON payload understanding and complex domain structures

- Ensure conformance to dimensional modelling, normalization and denormalization practices

- Work closely with Data Engineers to design optimized structures that support DBT pipelines and Snowflake performance

Technical Skills

- Around 12 years of hands-on data modelling experience with an insurance domain background

- Experience in data warehousing environments

- Strong experience with Erwin Data Modeler for conceptual, logical and physical models

- Experience building SCD1 / SCD2 / SCD3 dimension models and data warehouses

- Strong in Snowflake warehousing concepts: staging, curated layers and marts

- Strong SQL skills to validate transformations and model outputs

- Knowledge of JSON/XML handling, schema interpretation and source payload analysis

- Understanding of data integration issues, validation and cleansing

- Experience working in Agile

Good to Have

- Insurance LOB expertise: Workers Compensation (WC), Commercial Multi-Peril (CMP), Excess & Surplus (E&S), Excess Casualty (XS Casualty)

Soft Skills

- Strong analytical thinking and ability to interpret complex business logic

- Proactive communication and documentation skills

- Comfortable in fast-paced, multi-LOB data programs

Why Apply

- Permanent role on Value Innovation Labs payroll with a marquee enterprise client

- Hybrid work mode; openings across Mumbai, Pune, Bengaluru, Chennai, Hyderabad, Delhi NCR and Kolkata

- Hands-on ownership of enterprise data models in a multi-LOB insurance program

- Immediate to 30 days notice preferred (up to 60 days considered for strong profiles)