Data Modeler, Data Engineer – Guidewire

Job not on LinkedIn

🕒 June 10

🏄 California – Remote

🏄 California – Remote

⏰ Full Time

🟠 Senior

🔴 Lead

🚰 Data Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Exavalu

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 2018

🤝 B2B

🏦 Banking

⚕️ Healthcare Insurance

B2B • Banking • Healthcare Insurance

Exavalu is a business advisory and technology consulting firm that partners with enterprises to deliver high-impact digital transformation. Run by former CIOs, CXOs, and consulting principals, Exavalu offers strategic advisory, core systems transformation, systems integration, data & analytics, innovation and privacy/compliance solutions across regulated sectors. The firm focuses on Insurance, Banking & Financial Services, and Healthcare & Life Sciences, providing industry-tailored technology implementations and program leadership using partners like Guidewire, Salesforce, MuleSoft, PegaSystems and AWS.

📋 Description

• 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. • Implement clustering keys, partitioning strategies, and materialized views to improve query performance. • Optimize Snowflake compute and storage utilization while controlling operational costs. • 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. • Design and implement ELT/ETL pipelines. • 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.

🎯 Requirements

• 12+ 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

• Exavalu 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. • Welcome back program to help individuals return to the mainstream after a prolonged absence due to health or family reasons. • Commitment to building a diverse and inclusive workforce.