Data Modeler & Data Engineer (Guidewire)

This is a remote position.

Role: Snowflake Data Modeler with Guidewire

Location: USA/Canada (Remote)

Experience: 12+ years

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

Requirements

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

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

Benefits