LTM
Senior Data Modeler – Snowflake / Insurance Domain
Job Description – Senior Data Modeler – Snowflake / Insurance Domain Location: Flexible – Pan India Years of Experience: 12+ Years Any Project-Specific Prerequisite Skills Insurance Domain, Data Modelling, Snowflake, Erwin Data Modeler, Data Warehousing, SQL, DBT, SCD1/SCD2/SCD3 Detailed JD Responsibilities * Design and develop Logical and Physical Data Models for Data Warehouse and Data Mart layers in Snowflake. * Create and maintain Source-to-Target Mapping (STM) documents and 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, and 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 an Insurance domain background. * Experience working in a Data Warehousing environment. * Experience translating business requirements into Logical and Physical Data Models. * Experience designing and implementing effective data models in Snowflake, optimizing for analytical and operational reporting needs. * Ability to perform data analysis on source data and develop relevant data models. * Experience developing SCD1, SCD2, and SCD3 dimension data models and data warehouses. * Strong experience working with Erwin Data Modeler for conceptual, logical, and physical models. * Strong knowledge of Snowflake data warehousing concepts, including staging, curated layers, and 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 data cleansing, with familiarity in handling complex data and structures. * Experience working with Agile methodology.
The role
What you'll do
- Design and develop Logical and Physical Data Models for Snowflake Data Warehouse and Data Mart layers.
- Translate business requirements into conceptual, logical, and physical data models.
- Design dimensional data models, including SCD Type 1, Type 2, and Type 3 dimensions.
- Analyze and interpret JSON/XML payloads, schemas, and complex source data structures.
- Collaborate with Data Engineers, Business Analysts, BI Developers, and other stakeholders to deliver scalable data solutions.
- Design data structures aligned with Snowflake performance, scalability, and analytical reporting requirements.
- Use Erwin Data Modeler to create and maintain conceptual, logical, and physical data models.
You bring
Requirements
- 12+ years of hands-on experience in Data Modelling, preferably with strong Insurance domain experience
- Hands-on experience with Snowflake Data Modelling and Snowflake Data Warehouse
- Strong expertise in Logical, Physical, and Conceptual Data Modelling
- Hands-on experience with Erwin Data Modeler
- Experience in developing SCD Type 1, Type 2, and Type 3 dimensional models
- Insurance domain experience is mandatory, preferably across Policy, Claims, and Financial data
Skills