LTM
Senior Data Modeler – Insurance Domain
Senior Data Modeler – Insurance Domain Experience: 12+ Years Domain: Insurance Work Environment: Data Warehousing / Snowflake / Analytics Job Summary We are looking for an experienced Senior Data Modeler with 12+ years of hands-on experience in data modeling and data warehousing, preferably within the Insurance domain. The ideal candidate will have strong expertise in designing logical and physical data models for Snowflake Data Warehouse/Data Mart layers, developing Source-to-Target Mapping documents, performing data analysis and profiling, and working closely with Data Engineering, DBT, and BI teams. Strong knowledge of Erwin Data Modeler, Snowflake, SQL, dimensional modeling, SCD methodologies, and JSON/XML data structures is required. Key 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 to ensure accurate mapping of data across policy, claims, and financial domains. Define data entities, attributes, relationships, keys, and business rules based on business requirements and source-system structures. Translate complex business requirements into scalable and optimized logical and physical data models. Validate transformation logic and data structures supporting downstream DBT pipelines and Power BI models. Perform detailed data analysis, data profiling, source-data assessment, and validation. Analyze and interpret complex JSON payloads, XML structures, schemas, and source-system data. Apply appropriate dimensional modeling, normalization, and denormalization techniques. Design and maintain SCD Type 1, Type 2, and Type 3 dimensional models. Collaborate closely with Data Engineers to develop optimized data structures supporting DBT pipelines and Snowflake performance. Ensure data models address analytical, reporting, operational, integration, and data-quality requirements. Identify data integration issues and support data validation, cleansing, and reconciliation activities. Review and validate SQL transformations, model outputs, and downstream data consumption. Maintain conceptual, logical, and physical data models using Erwin Data Modeler. Work closely with business analysts, architects, data engineers, BI developers, and other stakeholders. Participate in Agile ceremonies and contribute to continuous improvement of data modeling standards and practices. Prepare and maintain technical documentation, modeling standards, data dictionaries, and mapping specifications. Mandatory Technical Skills 12+ years of hands-on experience in Data Modeling Strong Insurance domain experience Strong experience in Data Warehousing Expertise in translating business requirements into Logical and Physical Data Models Hands-on experience designing data models in Snowflake Strong knowledge of Snowflake data warehouse architecture, including: Staging layers Curated layers Data Marts Strong SQL skills for data analysis, transformation validation, and reconciliation Strong experience with Erwin Data Modeler for conceptual, logical, and physical modeling Experience with SCD Type 1, Type 2, and Type 3 Strong understanding of dimensional modeling Knowledge of normalization and denormalization techniques Experience analyzing source data and developing appropriate data models Strong understanding of JSON/XML structures, schema interpretation, and source payload analysis Experience identifying and resolving data integration, validation, and data-quality issues Experience supporting DBT-based data transformation pipelines Understanding of data structures consumed by Power BI Experience working in Agile methodology Insurance Domain Expertise Strong knowledge of insurance data and business processes, preferably across one or more of the following Lines of Business: Workers Compensation (WC) Commercial Multi-Peril (CMP) Excess & Surplus (E&S) Excess Casualty (XS Casualty) Experience working with Policy, Claims, Financial,
The role
What you'll do
- 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 to ensure accurate mapping of data across policy, claims, and financial domains
- Define data entities, attributes, relationships, keys, and business rules based on business requirements and source-system structures
- Translate complex business requirements into scalable and optimized logical and physical data models
- Validate transformation logic and data structures supporting downstream DBT pipelines and Power BI models
- Perform detailed data analysis, data profiling, source-data assessment, and validation
- Analyze and interpret complex JSON payloads, XML structures, schemas, and source-system data
You bring
Requirements
- 12+ years of hands-on experience in Data Modeling
- Strong Insurance domain experience
- Strong experience in Data Warehousing
- Expertise in translating business requirements into Logical and Physical Data Models
- Hands-on experience designing data models in Snowflake
- Strong knowledge of Snowflake data warehouse architecture, including: Staging layers Curated layers Data Marts
- Strong SQL skills for data analysis, transformation validation, and reconciliation
- Strong experience with Erwin Data Modeler for conceptual, logical, and physical modeling
Skills