Jobs → Data & Analytics → Data Modeler

About the Role We are seeking a Data Modeler with expertise in Guidewire and P&C Insurance to join our team. This role involves designing enterprise data models to 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.