Senior Technical Lead at HCLTech in Ahmedabad, Gujarat, IN

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