Technical Specialist
United States
Apply now
Job Description
Technical Specialist
Chicago, Illinois

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 hypercare 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

  1. Guidewire Cloud Data Access (CDA)
  2. Guidewire PolicyCenter, ClaimCenter & BillingCenter
  3. Data Mapping & Data Modeling
  4. Insurance Data Integration & Migration
  5. Data Quality, Reconciliation & Lineage

SQL, Databricks & Analytics Enablement

Other Requirements
Maximum Salary (US):  184000
Minimum Salary (US):  105000
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026 totaled $14.8 billion. 

 

Compensation and Benefits

A candidate’s pay within the range will depend on their 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.