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
-
Solid 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 an
📌 Lead Data Modeler (Delhi)
🏢 Neev
📍 Delhi