Lead Data Modeler (Insurance Domain) Overview

Neev; Mumbai; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Neev is seeking a Lead Data Modeler for the Insurance domain, focusing on Snowflake-based data warehousing and DBT pipelines. The role requires 12+ years of hands-on experience in data modelling within insurance and strong SQL skills.

Responsibilities include designing logical/physical data models, implementing SCDs, and collaborating with data engineers to optimize Snowflake performance and Power BI reporting. PAN India location; fast-paced program.

Qualifications

• ,

Responsibilities

• Design and develop Logical and Physical Data Models for Data Warehouse/Data Mart layers in Snowflake
• Create and maintain Source to Target Mapping documents for policy, claims and financial domains
• Define data entities, attributes and relationships based on business requirements and analytical needs
• Validate transformation logic for downstream consumption in DBT pipelines and Power BI models
• Conduct data analysis and profiling including JSON payload understanding and complex domain structures
• Ensure conformance to dimensional modelling, normalization and denormalization practices
• Collaborate with Data Engineers to optimize structures supporting DBT pipelines and Snowflake performance

Skills

Data modelling

Analytics

SQL

Tools

Snowflake

dbt

Power BI

ERwin Data Modeler

Job description

• Domain: Insurance (Workers Compensation, Commercial Multi-Peril, Excess & Surplus, Excess Casualty, Casualty)
• Core Technologies: Snowflake, dbt, Power BI, ERwin Data Modeler, SQL

Lead Data Modeler (Insurance Domain)

Overview

• Experience Required: 12+ Years
• Location: PAN India
• Domain: Insurance (Workers Compensation, Commercial Multi-Peril, Excess & Surplus, Excess Casualty, Casualty)
• Core Technologies: Snowflake, dbt, Power BI, ERwin Data Modeler, SQL

Job Description

• Design and develop Logical Physical Data Models for Data Warehouse Data Mart layers in Snowflake
• Create and maintain Source to Target Mapping STM documents ensure accurate data mapping for policy claims and financial domains
• Define data 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
• Conduct in-depth data analysis and profiling including JSON payload understanding and complex domain structures
• Ensure conformance to dimensional modelling normalization denormalization practices
• Collaborate closely with Data Engineers to design optimized structures supporting DBT pipelines and Snowflake performance considerations

Technical Primary Skills

• 12 years of extensive Hands-on experience in Data modelling with Insurance domain background
• Experience working in Data warehousing environment
• Experience in translating business requirements into logical and physical data model
• Design and implement effective data models in Snowflake optimizing for analytical and operational reporting needs
• Ability to perform data analysis on source data to come up with relevant models
• Experience in developing SCD1/SCD2/SCD3 Dimension Data models and data warehouse
• Strong experience working with Erwin Data Modeler for conceptual logical and physical models
• Strong in Snowflake data warehousing concepts staging curated layers marts
• Strong SQL skills with the ability to validate transformations and model outputs
• Knowledge of handling JSON/XML structures schema interpretation and source payload analysis
• Strong understanding of data integration issues validation and cleaning familiarity with complex data and structures
• Experience working with agile methodology

Secondary Skills

• Insurance Domain Expertise in LOB like Workers Compensation WC Commercial Multi-Peril CMP Excess Surplus ES Excess Casualty XS Casualty

Soft Skills

• Strong analytical thinking and ability to interpret complex business logic
• Proactive communication and documentation skills
• Ability to work in fast paced multi-LOB data programs

Skills: excess,snowflake,dbt,data,data models,insurance