Senior Technical Lead

About the role

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.

What you'll do

• 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

What you need

• SQL
• Python
• Power BI
• Power Query
• DAX
• Data modelling
• Any graduate

Good to have

• Pandas
• NumPy
• Data warehousing
• ETL
• Databricks
• Snowflake