Description

You will lead the data architecture and extraction processes from the Guidewire Cloud Platform into Snowflake.

Responsibilities

• Extract data from the Guidewire Cloud Platform (GWCP) via the CDA path for KCC, Policy Center, and Billing Center into the Raw zone.
• Design and implement new schemas in the Raw zone and integrate them into the Trusted Zone or Vault Layer.
• Design schema mappings and transformations to convert raw data into structured formats for analysis.
• Use EOR (Extract, Organize, and Replicate) to populate PC, BC, and KCC data into the Data Hub.
• Optimize data extraction processes, EDW loading, and Datahub ODS/extraction layers for performance and scalability.
• Monitor and validate data integration processes to ensure accuracy, consistency, and integrity across the refined zone.

Required Skills

• 10+ years of experience in data architecture or engineering.
• Hands-on experience with Guidewire Cloud Platform (GWCP).
• Proficiency with Snowflake.
• Expertise in Guidewire BillingCenter, PolicyCenter, and Kemper Claims Center (KCC).
• Deep understanding of Data Vault modeling techniques.
• Experience working with General Ledger, Commission, and Financial Data Marts.
• Proven ability to manage data extraction using the CDA path and EOR methods.
• Experience loading Enterprise Data Warehouse (EDW) environments.

Key Skills

Education

Any Gradute