- Design and develop Logical Physical Data Models for Data Warehouse Data Mart layers in Snowflake

- Create and maintain SourcetoTarget 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 indepth data analysis and profiling including JSON payload understanding and complex domain structures

- Ensure conformance to dimensional modeling 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 handson experience in Data modeling 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 SCD1SCD2SCD3 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 JSONXML 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

Qualifying Questions :

- 1 Do you have data modeling experience for building Insurance Data warehouse

- 2 Do you have experience on Data Profiling

- 3 Do you have experience working Erwin tool

- 4 Do you have experience in designing models for Snowflake data warehouse