Data Modeler - Guidewire Platform

Description :

We are seeking an experienced Data Modeller with strong expertise in the insurance domain and hands-on experience working with Guidewire data structures (PolicyCenter, BillingCenter, ClaimCenter).

The ideal candidate will be responsible for designing conceptual, logical, and physical data models for enterprise data platforms, ensuring data integrity, consistency, and scalability across insurance systems.

Key Responsibilities :

- Design and develop conceptual, logical, and physical data models tailored for insurance applications and analytics use cases.

- Build data models for data warehouses, data marts, and analytical platforms (e.g., Azure, Snowflake, Databricks, etc., if applicable).

- Analyse and interpret Guidewire (PC/BC/CC) data structures to create optimized and business-aligned data models.

- Collaborate with data architects, data engineers, and business stakeholders to capture data requirements and convert them into scalable models.

- Ensure data models align with insurance processes, including policy, billing, claims, underwriting, and regulatory reporting.

- Define and maintain data standards, metadata, naming conventions, lineage, and documentation.

- Participate in data quality, profiling, and validation initiatives to ensure model accuracy.

- Optimize data structures for performance, integrity, and scalability in analytical and operational ecosystems.

- Support integration designs and mapping between Guidewire systems and downstream data platforms.

- Work with data governance and compliance teams to align models with organizational standards.

Required Skills & Qualifications :

- Mandatory: Strong, hands-on experience with Guidewire data structures (PolicyCenter, BillingCenter, ClaimCenter).

- Proven experience as a Data Modeller in insurance or financial services.

- Expertise in designing conceptual, logical, and physical data models for large-scale data systems.

- Strong understanding of insurance data domainspolicy, claims, billing, underwriting, rating, financials.

Proficiency with modelling tools such as :

- Erwin, ER/Studio, Lucidchart, Visio, or similar.

- Strong SQL skills for data profiling, validation, and schema design.

- Good understanding of data governance, data quality, master data concepts, and metadata management.

- Experience working with enterprise data platforms (e.g., Databricks, Snowflake, Azure Synapse, Oracle, SQL Server adjust as needed).

- Excellent communication skills to translate business needs into structured data designs.

- Ability to work closely with engineering, product, and business teams.