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
