Senior Technical Lead
HCLTech
Senior Technical Lead
About this role
Job Summary
Data Analyst with experience in Crop Insurance and Agricultural Risk Management, skilled in claims analytics, premium and loss ratio analysis, underwriting support, regulatory reporting, and business intelligence. Proficient in SQL, Power BI, Python, and advanced Excel, with expertise in transforming complex agricultural and insurance data into actionable business insights and executive dashboards.
Key Responsibilities
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)DatabricksSnowflakeData Warehousing ConceptsETL Processes
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
Frequently Asked Questions
Is the salary disclosed for the Senior Technical Lead position at HCLTech?
The salary for this Senior Technical Lead role at HCLTech is not publicly listed. Click "Apply Now" to learn more about the compensation package on their official careers page.
Where is the Senior Technical Lead position at HCLTech located?
This Senior Technical Lead role at HCLTech is based in Ahmedabad, India. The position is listed as on-site or hybrid. Check the full job description or apply directly to confirm the work arrangement.
How do I apply for the Senior Technical Lead position at HCLTech?
Click the "Apply Now" button on this page. You will be redirected to HCLTech's official application portal hosted on successfactors where you can submit your application directly.
When was the Senior Technical Lead job at HCLTech posted?
This Senior Technical Lead position at HCLTech was posted on Sep 30, 2026. Apply as soon as possible — early applications are often reviewed first.
Senior Technical Lead
HCLTech
You'll be redirected to HCLTech's official application page on successfactors.