Data Modeler & Data Engineer with Guidewire

Summary: The role of Data Modeler & Data Engineer with Guidewire involves designing and developing data models for enterprise data platforms, specifically utilizing Snowflake. The position requires collaboration with business stakeholders to align data solutions with insurance processes and mandates a strong understanding of Guidewire data models. The role is remote and is expected to last for over 12 months.

Key Responsibilities:

• 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.
• 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.
• 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.

Key Skills:

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

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: Other