Jobs → Data & Analytics → Data Modeler – Guidewire & P&C Insurance

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

Similar projects

Business System Analyst
Ashu Kapoor · Java, PMP, ProjectManager
Databricks Data Engineer
Surya Badde · Databricks, PySpark, Python
Data Engineer
Himanshu Mishra · Python, SQL, ETL
Early · 0 applied1 of 4,903 projects

Apply with AI cover letter

AI writes a personalized application in 19 seconds. Just upload your resume.

No credit card · First application free
© 2026 Freelanly · Terms · Privacy