Senior Technical Lead
United States
Apply now
Job Description
Senior Technical Lead
Chicago, Illinois

Job Summary

Data Analyst with experience in Crop Insurance Data Modernization, specializing in Policy, Claims, Billing, APH Yield, Acreage, Premium, Subsidy, and Indemnity data domains. Skilled in data profiling, reconciliation, source-to-target mapping validation, business rule analysis, and data quality management across Guidewire and legacy insurance platforms. Proficient in SQL, Power BI, Python, Tableau, and advanced Excel, with expertise in transforming complex crop insurance data into trusted, audit-ready data products, regulatory reports, and actionable business insights. Experienced in supporting data migration, SIT/UAT testing, KPI validation, data governance, and Single Source of Truth (SSOT) initiatives through close collaboration with business SMEs, data engineers, and reporting teams.

Key Responsibilities

Analyze and interpret crop insurance policy, claims, billing, acreage, APH yield, premium, subsidy, and indemnity data from Guidewire and legacy CIMax systems. Define and validate source-to-target mappings, business rules, and canonical data models for Policy and Claims domains. Perform data profiling, reconciliation, variance analysis, and data quality validation to establish a trusted Single Source of Truth (SSOT). Collaborate with business SMEs, Guidewire teams, data engineers, and reporting teams to validate KPIs, regulatory reports, and dashboards. Support SIT/UAT activities, audit-ready reporting, lineage tracking, data governance, and RMA compliance while ensuring accuracy, consistency, and traceability across modernized data platforms.
 

Skill Requirements

SQL (Joins, CTEs, Stored Procedures, Query Optimization)
Microsoft Excel (Advanced Formulas, Pivot Tables, Power Query)
Power BI (DAX, Data Modeling, Dashboard Development)
Python (Pandas, NumPy, Matplotlib)
Databricks
Snowflake
Data Warehousing Concepts
ETL Processes

Other Requirements
Maximum Salary (US):  148000
Minimum Salary (US):  100000
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.