Data Modeler & Data Engineer with Guidewire with P&C Insurance

Job Role: Data Modeler & Data Engineer with Guidewire with P&C Insurance

Location: USA/Canada- Remote

Exp. Start date: 4^th week of June

Year of Experience: 12+ Years

Job Description

We are seeking an experienced Snowflake Data Architect / Senior Data Modeler with deep expertise in Snowflake data Modeling, Guidewire data structures, and Property & Casualty (P&C) Insurance domain knowledge. The ideal candidate will be responsible for designing scalable enterprise data models, optimizing Snowflake architecture, and collaborating with cross-functional teams to build modern cloud-based data platforms. This role requires strong experience in dimensional data Modeling, AWS cloud services, ELT/ETL architecture, and enterprise data governance practices. 

Key Responsibilities

Data Architecture & Modeling

• Design and develop conceptual, logical, and physical data models for enterprise data platforms.
• Create and maintain dimensional data models including Star Schema and Snowflake Schema designs.
• Translate business requirements into scalable and optimized Snowflake data structures.
• Design data models supporting reporting, analytics, and operational use cases.
• Ensure consistency, scalability, and maintainability of enterprise data assets.

Snowflake Data Engineering & Optimization

• Design Snowflake-ready schemas and optimize physical data structures.
• Implement clustering keys, partitioning strategies, and materialized views to improve query performance.
• Optimize Snowflake compute and storage utilization while controlling operational costs.
• Support performance tuning and query optimization initiatives.
• Leverage strong understanding of Guidewire data models including PolicyCenter, ClaimCenter, and BillingCenter.
• Analyse and model insurance data across policy, claims, billing, underwriting, and customer domains.
• Collaborate with business stakeholders to align data solutions with P&C insurance processes and requirements.
• Support enterprise-wide insurance data transformation initiatives.
• Collaborate with Data Engineering teams to design and implement ELT/ETL pipelines.
• Support Medallion Architecture (Bronze, Silver, Gold layers) within modern data lakehouse environments.
• Design data ingestion frameworks leveraging AWS services.
• Ensure seamless integration between Guidewire platforms and enterprise data ecosystems.

Governance & Security

• Implement enterprise data governance standards and best practices.
• Enforce data quality, lineage, metadata management, and compliance policies.
• Design and maintain role-based access controls (RBAC) within Snowflake.
• Ensure adherence to security, regulatory, and compliance requirements.

Required Qualifications

Technical Skills

• 8+ years of experience in Data Architecture, Data Modeling, or Data Engineering.
• Strong expertise in Snowflake Data Modeling:
• Conceptual Data Modeling
• Logical Data Modeling
• Physical Data Modeling
• Dimensional Modeling
• Star and Snowflake Schemas
• Advanced SQL development and performance tuning experience.
• Strong programming experience with:
• Python
• PySpark
• Hands-on experience with:
• Snowflake
• AWS S3
• AWS Glue
• AWS Lambda
• Experience designing and supporting ELT/ETL pipelines.
• Knowledge of Medallion Architecture and modern data lakehouse concepts.

Domain Expertise

• Strong Guidewire Data Model experience.
• Strong Property & Casualty (P&C) Insurance domain knowledge.
• Understanding of insurance business processes including policy administration, claims management, underwriting, and billing.

Preferred Qualifications

• Experience with Guidewire Cloud implementations.
• Knowledge of Data Vault Modeling methodologies.
• Experience with data cataloging and metadata management tools.
• Familiarity with CI/CD and DevOps practices for data platforms.
• Experience working within large enterprise insurance environments.