2+ Guidewire Jobs in Mumbai | Guidewire Job openings in Mumbai

We're looking for a Senior Data Modeler to lead the design and evolution of our enterprise data warehouse, with a primary focus on transforming Guidewire (PolicyCenter, BillingCenter, ClaimCenter) and other insurance source system data into well-architected, analytics-ready models on Google BigQuery. This is a hands-on, high-autonomy role for someone who can own modeling decisions end-to-end — from source system analysis through to production-grade dimensional or Data Vault structures — with minimal oversight.

You'll work across multiple insurance lines of business (Property, Casualty, Financial Lines, Specialty) and partner closely with engineering, BI, and business stakeholders to ensure the data model is technically sound and supports reporting, actuarial, and analytics use cases.

Responsibilities:

• Design and own enterprise-scale data models across multiple insurance domains.
• Translate complex Guidewire schemas (PolicyCenter, BillingCenter, ClaimCenter) into governed warehouse structures.
• Apply appropriate modeling techniques including:
• Dimensional Modeling (Star/Snowflake)
• 3NF/Normalized Modeling
• Data Vault 2.0 (Hubs, Links, Satellites)
• Hybrid and Denormalized Models
• Model effective-dated and slowly changing insurance data, including policy versioning, endorsements, premium earning, and claims history.
• Design conformed dimensions and fact tables supporting Premium, Claims, and Billing reporting.
• Optimize BigQuery performance through partitioning, clustering, materialized views, query tuning, and cost-efficient schema design.
• Create and maintain ERDs, source-to-target mappings, data dictionaries, and lineage documentation.
• Collaborate with Data Engineers to ensure physical implementation aligns with logical models.
• Establish modeling standards and mentor team members through hands-on leadership.
• Independently drive solutions from ambiguous business requirements.
• Communicate modeling decisions and trade-offs to both technical and business stakeholders.

Required Skills & Experience:

• 7+ years of enterprise-scale Data Modeling experience.
• Strong Insurance domain expertise, preferably with Guidewire:
• PolicyCenter
• BillingCenter
• ClaimCenter
• Experience with alternative insurance platforms such as Duck Creek or Sapiens is also valuable.
• Deep expertise in:
• Dimensional Modeling (Kimball)
• 3NF Data Modeling
• Data Vault 2.0
• Denormalized Data Warehousing
• Strong BigQuery knowledge:
• Partitioning & Clustering
• Query Performance Optimization
• Cost-Aware Schema Design
• Expertise in modeling effective-dated and temporal data.
• Excellent communication and stakeholder management skills.
• Proven ability to lead through hands-on technical contributions.
• Ability to work independently with minimal supervision.

Nice to Have:

• Insurance premium calculations and reconciliation:
• Earned / Unearned / Written Premium
• GWP Reconciliation
• Premium Earning Schedules
• Knowledge of Guidewire data model patterns:
• Effective Dating
• FixedID / BranchID
• CDA / ODS Layers
• Experience with Data Vault automation tools.
• Exposure to Snowflake or Redshift.
• Experience mentoring Data Modelers and Data Engineers.

What Success Looks Like:

• Well-documented, scalable enterprise data models.
• Cost-efficient, high-performance modeling decisions.
• Improved modeling maturity across the team.
• Strong stakeholder confidence in the data architecture and design decisions.

Guidewire developer-PAN India

Role : Guidewire developer

Location : Pan India

Years of experience : 3 - 15 years

Roles and Responsibilities :

• Candidate having at least 3+ years of experience as guidewire developer
• Candidate having experience in Policy center(PC) or Claim center(CC)
• Experience in configuration or integration
• Candidate having Specialist certificate of guidewire

Regards

Sundaravalli