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

• 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

• 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