Data Modeler & Data Engineer (Guidewire)Exavalu Solutions India Pvt Ltd • California, Maryland, United States
Data Modeler & Data Engineer (Guidewire)
Exavalu Solutions India Pvt Ltd
- California, Maryland, United States
- California, Maryland, United States
Über
Overview :
Role : Snowflake Data Modeler with Guidewire
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
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.
Collaborate with Data Engineering teams to design and implement ELT/ETL pipelines.
Support Medallion Architecture (Bronze, Silver, Gold layers) within modern data lakehouse environments.
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 Property & Casualty (P&C) Insurance domain knowledge.
Understanding of insurance business processes including policy administration, claims management, underwriting, and billing.
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.
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.