Description

You will lead data architecture and extraction workflows between Guidewire Cloud Platform and Snowflake.

This role is on-site.

Responsibilities

• Extract data from Guidewire Cloud Platform via the CDA path for KCC, PolicyCenter, and BillingCenter into Snowflake Rawzone.
• Design and implement new schemas in the Rawzone and integrate them into the Trusted Zone or Vault layer.
• Develop schema mappings and transformations to convert raw data into structured formats for analysis.
• Populate Datahub using Extract, Organize, and Replicate (EOR) processes for PC, BC, and KCC data.
• Manage and optimize the Enterprise Data Warehouse (EDW) and Operational Data Store (ODS) extraction layers.

Required Skills

• 5+ years of experience in data architecture or related roles.
• Hands-on experience with Data Vault modeling techniques.
• Proficiency with Snowflake and Guidewire ecosystems.
• Experience extracting data from Guidewire Cloud Platform (GWCP) using Change Data Capture (CDA).
• Technical expertise with PolicyCenter (PC), BillingCenter (BC), and Kemper Claims Center (KCC).
• Experience working with General Ledger, Commission, and Financial Data Marts.
• Ability to design and implement complex schema mappings and transformations.
• Knowledge of loading Enterprise Data Warehouse (EDW) Loss data using Snowflake Rawzone or read replicas.

Key Skills

Education

Any Gradute