Data Modeler & Data Engineer (Guidewire)
Please mention DailyRemote when applying
AI Summary
The candidate will design and develop data models for enterprise data platforms and optimize Snowflake architecture. They will collaborate with cross-functional teams to build modern cloud-based data platforms and support data transformation initiatives.
This is a remote position.
Role: Snowflake Data Modeler with Guidewire
Location: USA/Canada (Remote)
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.
- 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.
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.
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.
Automatically Apply to the Best Remote Jobs
Stop the endless job search. Our AI finds and applies to the best jobs for you.
