Guidewire Specialist

HCL Technologies Limited; Chicago (IL); On-site; USD 105,000 - 184,000; Full time

Benefits offered by this job

Medical Insurance

Dental & Vision

401(k) retirement plan

Paid time off

10 paid holidays per year

Job summary

HCLTech in Chicago, IL seeks a Guidewire Specialist to enable seamless integration of Guidewire Cloud Data Access data into the Databricks Lakehouse platform. You will analyze Guidewire Policy, Claims, and Billing data models, define mappings, and ensure data quality, lineage, and SSOT governance across bronze and silver layers.

Collaborate with business stakeholders, data architects, and engineering teams to onboard Guidewire data, support migration initiatives, and provide expertise for

Qualifications

• Experience with Guidewire Cloud Data Access; data modeling and mapping across insurance domains.
• Ability to define source-to-target mappings, data quality controls, and lineage.
• Proficiency in SQL and Databricks for data analytics and ingestion pipelines.
• Familiarity with SSOT concepts and data governance in large data estates.

Responsibilities

• Analyze Guidewire CDA data structures across Policy, Claims, Billing, Payments and Customer domains.
• Define source-to-target mappings and transformation rules, reconcile data, and ensure data quality controls.
• Collaborate with Databricks engineers to build ingestion pipelines and validate data movement into the Lakehouse.
• Support canonical data model development and harmonization with legacy systems.

Skills

Guidewire CDA

Data Mapping

Data Modeling

Insurance Data

SQL & Databricks

Job description

HCLTech is looking for a highly talented and self- motivated Guidewire Specialist to join it in advancing the technological world through innovation and creativity.

Position Type: Full-time

Location: Chicago, IL

Onsite

Job Summary

Guidewire Specialist responsible for enabling seamless integration of Guidewire Cloud Data Access (CDA) data into the modernized Databricks Lakehouse platform. The role focuses on analyzing Guidewire Policy, Claims, and Billing data models, defining source-to-target mappings, supporting canonical data model creation, and ensuring accurate data extraction, reconciliation, and governance. Work closely with business stakeholders, data architects, and engineering teams to onboard Guidewire data into bronze and silver layers while maintaining data quality, lineage, and compliance standards. Support migration initiatives, reporting requirements, operational analytics, and establishment of a trusted Single Source of Truth (SSOT) environment.

Key Responsibilities

Analyze Guidewire CDA data structures and identify business-critical entities across Policy, Claims, Billing, Payments, and Customer domains. Define source-to-target mappings, transformation rules, reconciliation logic, and data quality controls. Collaborate with Databricks engineers to build ingestion pipelines and validate data movement from Guidewire into the Lakehouse. Support canonical data model development and harmonization with legacy systems. Perform data profiling, impact assessments, and gap analysis. Assist in SIT, UAT, production cutover, and hyper care activities. Provide subject matter expertise for Guidewire reporting, operational processes, governance, lineage, audit requirements, and modernization initiatives across the insurance data estate.

Skill Requirements

Top 6 Skillsets

• Guidewire Cloud Data Access (CDA)
• Data Mapping & Data Modeling
• Insurance Data Integration & Migration
• SQL, Databricks & Analytics Enablement

Pay and Benefits

Pay Range Minimum: $ 105000 Per year

Pay Range Maximum: $ 184000 Per year

HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to [e-mail] for investigation.

Compensation and Benefits:

A candidate's pay within the range will depend on their work location, skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies.

In addition, this role is eligible for the following benefits subject to company policies:

• medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance
• employee assistance program
• 401(k) retirement plan
• 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year)
• and 10 paid holidays per year.