Guidewire Architect

Enterprise Solutions Inc.; Orlando (FL); Remote; USD 114,000 - 162,000; Full time

Job summary

A leading company is seeking a Guidewire Data architecture / Technical Lead. This remote position involves overseeing data extraction from Guidewire, ensuring data integrity, and designing schemas to enhance data management processes. The ideal candidate will have significant experience with data integration and technical leadership, managing complex projects efficiently.

Qualifications

• Experience with Guidewire Cloud Platform (GWCP)
• Hands-on experience with Data Vault modeling techniques
• Proficiency in EOR (Extract, Organize, and Replicate)

Responsibilities

• Extract data using CDA path for KCC, PC, and BC
• Design and implement schemas in the Rawzone
• Monitor data integration processes for smooth operations

Skills

Data extraction

Data Integrity

Data Vault modeling

Integration

Schema Design

Job description

Direct message the job poster from Enterprise Solutions Inc.

Account Manager @ Enterprise Solutions Inc. | ADSP Credentials

Role: Guidewire Data architecture / Technical lead

Location: Remote

Overview

For this role, we are specifically looking for candidates with experience in downstream integration from Guidewire, particularly with the following capabilities:

• Extracting data from the Guidewire Cloud Platform via the CDA path for KCC, Policy Center (PC), and Billing Center (BC) into Snowflake.
• Proficiency in using EOR (Extract, Organize, and Replicate) to populate PC, BC, and KCC data into the Data Hub.
• Experience working with General Ledger, Commission, and Financial Data Marts.
• Hands-on experience with Data Vault modeling techniques.

Responsibilities:

Extract Data from GWCP to Rawzone through the CDA Path for KCC, PC, and BC

• Extract data from Guidewire Cloud Platform (GWCP) to the Rawzone using the Change Data Capture (CDA) path for key components such as KCC (Kemper Claims Center), PC (Policy Center), and BC (Billing Center).
• Ensure the extraction process is efficient and reliable, minimizing downtime and data loss.

Ensure Data is Sourced to New Schemas in Rawzone

• Design and implement new schemas in the Rawzone to accommodate the extracted data.
• Ensure that the data is accurately mapped to the new schemas, maintaining data integrity and consistency.

Integrate New Rawzone Schemas into the Trusted Zone/Vault Layer

• Integrate the new Rawzone schemas into the trusted zone or vault layer.
• Ensure that the data flows seamlessly from the Rawzone to the trusted zone, maintaining data quality and security.

Design and Implement Schema Mappings and Transformations

• Design schema mappings and transformations to convert raw data into a structured format suitable for analysis and reporting.
• Implement these mappings and transformations, ensuring they are optimized for performance and accuracy.

Implement Minimal Changes to the Refined Zone

• Make minimal changes to the refined zone to accommodate the new data structures.
• Ensure that the refined zone remains consistent and accurate, reflecting the latest data updates.

Ensure Data Consistency and Accuracy in the Refined Zone

• Monitor the refined zone to ensure data consistency and accuracy.
• Implement data validation and reconciliation processes to identify and resolve any discrepancies.

Leverage EOR to Populate PC, BC, and KCC Data to Datahub

• Use the Extract-Only Region (EOR) to populate PolicyCenter (PC), BillingCenter (BC), and Kemper Claims Center (KCC) data to Datahub.
• Ensure that the data is accurately and efficiently transferred to Datahub.

Monitor and Validate Data Integration Processes

• Continuously monitor data integration processes to ensure they are running smoothly.
• Validate the data integration to ensure that the data is accurate and complete.

Implement Any Required Changes to Datahub ODS and Extraction Layers

• Identify and implement any necessary changes to the Datahub Operational Data Store (ODS) and extraction layers.
• Ensure that these changes are optimized for performance and do not disrupt existing processes.

Ensure Data Extraction Processes are Optimized and Efficient

• Optimize data extraction processes to ensure they are efficient and scalable.
• Implement best practices for data extraction to minimize resource usage and maximize performance.

Load KSG EDW Loss Leveraging Either Snowflake Rawzone GWCP New Schemas or GWCP Read Replica

• Load KSG Enterprise Data Warehouse (EDW) Loss data using either the Snowflake Rawzone GWCP new schemas or the GWCP read replica.
• Ensure that the data loading process is accurate and efficient.

Validate and Reconcile Data Loading Processes

• Validate the data loading processes to ensure that the data is accurate and complete.
• Reconcile any discrepancies in the data to maintain data integrity.

Implement Any Required Changes to EDW

• Identify and implement any necessary changes to the Enterprise Data Warehouse (EDW).
• Ensure that these changes are optimized for performance and do not disrupt existing processes.

Ensure Data Integrity and Performance in the EDW Environment

• Monitor the EDW environment to ensure data integrity and performance.
• Implement best practices for data management and optimization to maintain a high-performing EDW environment.

Seniority level

• Seniority level

  Director

Employment type

• Employment type

  Contract

Job function

• Job function

  Business Development and Design

• Industries

  IT Services and IT Consulting, Insurance, and Business Consulting and Services

Referrals increase your chances of interviewing at Enterprise Solutions Inc. by 2x

Sign in to set job alerts for “Technical Lead” roles.

Senior Appian Consultant / Technical Lead

Florida, United States
$114,632.00
-
$161,159.00
8 months ago

Senior Software Engineer - Audio Processing & Networking Specialist

Florida, United States
$84,000.00
-
$135,000.00
2 weeks ago

Manager, Software Engineering (Card Platform)

Tampa, FL
$102,400.00
-
$147,200.00
1 week ago

Florida, United States
$119,283.00
-
$214,709.00
1 week ago

Florida, United States
$118,200.00
-
$191,290.00
2 weeks ago

Florida, United States
$119,283.00
-
$214,709.00
1 week ago

Florida, United States
$119,283.00
-
$214,709.00
1 week ago

Tampa, FL
$102,400.00
-
$147,200.00
1 week ago

Florida, United States
$120,000.00
-
$180,000.00
2 weeks ago

Senior Engineering Manager, Scientific Injection Molding Development and Training

St. Petersburg, FL
$135,700.00
-
$244,300.00
1 month ago

Software Engineering Manager (Backend SaaS)

Manager, Applications & Production Supp (Java) ($165K)

Senior Solutions Architect, Media and Entertainment

Florida, United States $138,200 - $239,000 4 days ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.