Data Modeler – Guidewire & P&C Insurance
Vishal D.RemoteMIDPosted 2h ago
GuidewireP&C InsuranceData ModelingSQLSTTMODSData WarehouseLakehouseDatabricks
About the Role
We are seeking a Data Modeler with expertise in Guidewire and P&C Insurance to design enterprise data models that support modernization, reporting, and analytics.
Key Responsibilities
• Develop conceptual, logical, and physical data models across Policy, Claims, Billing, Party/Customer, Agency, and Product domains
• Understand Guidewire PolicyCenter, BillingCenter, and ClaimCenter entities, relationships, and integration points
• Translate Guidewire source structures into business-driven enterprise models
• Define entity grain, business keys, relationships, reference data, and historical/SCD requirements
• Develop source-to-target mappings, data dictionaries, lineage, and documented modeling assumptions
• Integrate data across Policy, Billing, and Claims to support Finance, Actuarial, Underwriting, and downstream analytics
• Partner with business SMEs, Guidewire teams, data architects, and engineering teams to validate and implement models
Requirements
• 10+ years in data modeling/data architecture with strong P&C insurance experience
• Hands-on experience with Guidewire PolicyCenter, BillingCenter, and/or ClaimCenter
• Strong knowledge of P&C Commercial Lines, including Policy, Coverage, Premium, Billing, Claims, Agency, and Underwriting concepts
• Expertise in enterprise, relational, and dimensional data modeling
• Strong SQL, data analysis, STTM, and data-quality/reconciliation skills
• Experience with ODS, Data Warehouse, or Lakehouse architectures
• Guidewire CDA and Databricks experience is a plus