Key Responsibilities:
• Design and develop logical and physical data models to support P&C insurance business processes incrementally.
• Work with Business Analysts to define and document data mapping rules from source systems such as Guidewire and legacy systems.
• Optimize physical data models for performance and scalability on the Snowflake platform.
• Ensure the models meet business requirements, technical standards, and data governance guidelines.
Other Responsibilities:
• Collaborate with developers to ensure data integration processes align with the data models.
• Maintain version-controlled documentation for models, mappings, and transformations.
• Provide ongoing support and troubleshooting related to model implementation and evolution.
• Participate in data quality reviews, model validation, and performance tuning efforts.
• Support cross-functional teams with data model training and interpretation.
Required Experience and Skills:
• Proven experience working on data models in the P&C Insurance domain.
• Hands-on experience with data modeling tools (e.g., Erwin).
• Strong understanding of relational and dimensional modeling concepts.
• Proficient in SQL and data validation techniques.
• Excellent analytical, communication, and collaboration skills.
Nice to Have:
• Experience with Snowflake platform and Guidewire and Legacy (Mainframe) systems.
• Familiarity with ETL processes, metadata management, and data governance practices."
We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.