Data Modeler - Large Commercial Insurance

Job Summary We are seeking an experienced Data Modeler with 12+ years of experience and strong expertise in the Commercial Insurance domain, particularly Claims. The ideal candidate will have extensive experience designing logical and physical data models for Snowflake data warehouses and data marts, translating complex business requirements into scalable data models, and working closely with business and technical stakeholders.

Key Responsibilities Design and develop logical and physical data models for data warehouse and data mart layers in Snowflake. Translate business requirements into logical and physical data models. Perform source data analysis to identify data relationships, structures, definitions, and modeling requirements. Develop and maintain SCD1, SCD2, and SCD3 dimensional data models. Define data entities, attributes, relationships, and business definitions based on business requirements and analytical needs.

Map source data structures to target data models and schemas while ensuring data consistency, integrity, and quality. Develop conceptual, logical, and physical data models using Erwin Data Modeler. Design and maintain Snowflake data warehouse structures across staging, curated, and data mart layers. Develop and optimize SQL queries to validate transformations and model outputs. Collaborate with business users, architects, analysts, developers, and subject matter experts to understand and clarify requirements.

Identify data issues, assess the impact of system changes, and recommend effective solutions. Ensure accuracy and consistency of data models, relationships, naming conventions, and data definitions. Support data governance, data lineage, data quality, and metadata management initiatives. Contribute to enterprise data modeling standards and best practices. Required Qualifications 12+ years of experience in data modeling or related data engineering disciplines. Strong Commercial Insurance domain experience, including Claims.

Experience with Insurance domains such as Underwriting, Policy Administration, Claims, and Reinsurance. Strong experience designing logical and physical data models for Snowflake data warehouses and data marts. Experience translating business requirements into logical and physical data models. Strong experience with Snowflake data warehousing concepts, including staging, curated, and data mart layers. Strong SQL skills for data analysis, transformation validation, and model validation. Strong experience with Erwin Data Modeler for conceptual, logical, and physical data modeling.

Experience developing SCD1, SCD2, SCD3, dimensional data models, and data warehouse structures. Experience mapping source data structures to target models and schemas. Strong understanding of data entities, attributes, relationships, data integrity, and data quality. Strong analytical, problem-solving, and communication skills. Ability to collaborate effectively with business SMEs, architects, analysts, developers, project teams, and leadership. Strong attention to detail and ability to maintain accurate data definitions and modeling standards.

Preferred Qualifications Experience with Data Vault modeling. Experience with Master Data Management (MDM). Experience with metadata management and canonical data models. Knowledge of data governance, data lineage, and data quality frameworks. Experience with AWS, Azure, or other cloud platforms. Experience supporting enterprise data modernization initiatives. Mandatory Skills Snowflake Snowflake Administration Commercial Insurance Domain Claims Domain Education: Bachelors Degree