Guidewire Data Architect or Lead - Orange Park, FL Onsite)

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6 Month(s)
No Travel Required

Skills

Data Architect
ETL
Snowflake
Guidewire
Data Modeling
GWCP
DataHub

Job Details

Role Name: Guidewire Data Architect/ Tech Lead
Location: Orange Park,FL (Onsite)

Duration: 6-12 Months

Job Summary:

We are seeking a highly experienced Data Architect/Technical Lead with strong expertise in Guidewire Cloud Platform (GWCP) to drive data extraction, transformation, and integration efforts across enterprise data zones. The ideal candidate will have hands-on experience with Change Data Capture (CDA), Snowflake, DataHub, and Enterprise Data Warehousing (EDW) in complex cloud-native environments.

Key Responsibilities:

1. Data Extraction & Ingestion

  • Extract data from GWCP (KCC, PC, BC) to Rawzone using CDA path.
  • Leverage EOR (Extract-Only Region) to populate PolicyCenter, BillingCenter, and Claims data to DataHub.
  • Ensure efficient, accurate, and low-latency data extraction processes.

2. Schema Design & Data Modeling

  • Design new schemas in Snowflake Rawzone to accommodate GWCP data.
  • Map and transform schemas to ensure data integrity, consistency, and usability.
  • Integrate Rawzone schemas into the Trusted Zone/Vault layer.

3. Data Transformation & Processing

  • Develop optimized transformation pipelines from raw to trusted and refined zones.
  • Minimize changes to existing Refined Zone, while maintaining compatibility and data quality.
  • Implement data validation and reconciliation mechanisms.

4. Data Loading & Integration

  • Load data into KSG EDW leveraging new schemas or GWCP Read Replicas.
  • Validate, reconcile, and ensure completeness of data loading processes.
  • Identify and implement enhancements to EDW and DataHub ODS/extraction layers.

5. Performance Optimization & Monitoring

  • Continuously monitor data pipelines, EDW, and DataHub environments.
  • Optimize for scalability, efficiency, and performance across zones.
  • Enforce data governance and security best practices.

Must-Have Skills & Experience:

  • 10+ years of experience in data architecture or engineering roles.
  • Proven expertise with Guidewire Cloud Platform (GWCP) Claims, Policy, and Billing modules.
  • Strong understanding of Change Data Capture (CDC/CDA) methodologies.
  • Experience with Snowflake, DataHub, EDW, and ODS concepts.
  • Hands-on skills in data modeling, schema design, ETL/ELT pipelines, and data reconciliation.
  • Familiarity with cloud-native architectures and data platform components.

Preferred Qualifications:

  • Prior experience with Kemper Insurance or similar enterprise Guidewire implementations.
  • Experience in Azure/AWS/Google Cloud Platform-based data ecosystems.
  • Strong communication and leadership skills to coordinate across business and engineering teams.


Best Regards,

Chetna

-D

-Fax

Truth Lies in Heart

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.