Data Analyst

About the role

We are looking for a Data Analyst to join Santam Specialist Solutions in Illovo Sandton. The role focuses on delivering reliable business information and actionable insights to support underwriting, pricing, claims and portfolio management decisions.

Key responsibilities

• Produce and analyse portfolio reports covering premiums, claims, loss ratios, rate movements and other performance indicators.
• Develop and maintain reliable datasets for reporting, pricing and modelling, including regular data validation and quality testing.
• Create and maintain management information, dashboards and self‑service BI solutions using consistent definitions and approved data sources.
• Prepare and validate data for pricing, segmentation, forecasting and predictive modelling, and support rate and rule testing.
• Collaborate with underwriting, actuarial, claims, reinsurance, finance and technology teams to deliver data solutions and automate reporting processes.
• Participate in AI and automation initiatives, contributing to responsible governance, performance monitoring and ethical standards.

Required profile

• Bachelor’s degree in Mathematics, Statistics, Actuarial Science, Data Science, Computer Science, Economics or a related quantitative discipline.
• At least two years of experience in data analysis, business intelligence, actuarial analysis or pricing analytics.
• Proven experience extracting, reconciling and analysing data from multiple sources and developing reports or dashboards for business users.
• Experience in short‑term, commercial or casualty insurance and exposure to underwriting, pricing, claims or reinsurance data.
• Familiarity with policy administration systems and data warehouses.

Required skills

• Advanced Excel, including data validation, reconciliation and analytical modelling.
• SQL for data extraction, transformation and analysis.
• Power BI or a comparable business intelligence and visualisation tool.
• Strong data management and data quality practices.
• Working knowledge of relational databases and data‑warehouse concepts.
• Understanding of the AI solution lifecycle and responsible AI principles.
• Experience with AI‑enabled analytical or automation tools.