Lead Data Modeler (Insurance Domain) Overview

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