Data Modeler & Data Engineer with Guidewire

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.