12+ years of experience in Data Architecture, Data Modeling, or Data Engineering
Strong expertise in Snowflake Data Modeling
Strong Guidewire Data Model experience
Knowledge of Medallion Architecture and modern data lakehouse concepts
Requirements:
Design and develop conceptual, logical, and physical data models for enterprise data platforms
Translate business requirements into scalable and optimized Snowflake data structures
Collaborate with business stakeholders to align data solutions with PC insurance processes and requirements
Implement enterprise data governance standards and best practices
Job description
This is a remote position.
Role: Snowflake Data Modeler with Guidewire
Location: USA/Canada (Remote)
Experience: 12+ years
Job Description
We are seeking an experiencedSnowflake 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.
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.
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.
Requirements
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.
Understanding of insurance business processes including policy administration, claims management, underwriting, and billing.
Benefits
Exavalu also promotes flexibility, adapting to the needs of employees, customers, and the business. It might be part-time work, working outside normal 9-5 business hours or working remotely. We also offer a welcome back program to help individuals return to the mainstream after a prolonged absence due to health or family reasons.
At Exavalu, we are committed to building a diverse and inclusive workforce. We welcome applications for employment from all qualified candidates, regardless of race, colour, gender, national or ethnic origin, age, disability, religion, sexual orientation, gender identity or any other status protected by applicable law. We nurture a culture that embraces all individuals and promotes diverse perspectives, where you can make an impact and grow your career.
