Guidewire Specialist

HCLTech is looking for a highly talented and self- motivated Guidewire Specialist to join it in advancing the technological world through innovation and creativity. Job Title: Guidewire Specialist - Data Modelling, Databricks, Guidewire - Billing Center, Guidewire Claim center, Guidewire Policy center, Migrations Req ID: 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) Guidewire PolicyCenter, ClaimCenter & Billing Center Data Mapping & Data Modeling Insurance Data Integration & Migration Data Quality, Reconciliation & Lineage SQL, Databricks & Analytics Enablement Pay and Benefits Pay Range Minimum: $ Per year Pay Range Maximum: $ 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 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. HCLTech