Data Analyst

Santam Insurance; Sandton; On-site; ZAR 420,000 - 660,000; Full time

Job summary

Santam Insurance is seeking a Data Analyst for the Illovo Sandton office. You will produce reliable business information through data collation, validation and analysis to support underwriting, pricing, claims and portfolio decisions.

Key responsibilities include portfolio analytics, data management, BI reporting and modelling support. The role emphasises data quality, stakeholder engagement and governance of AI-enabled solutions.

Qualifications

• Bachelor's degree in Mathematics, Statistics, Data Science, CS or related quantitative field.
• Two years’ relevant data analysis or BI experience.
• Experience extracting, reconciling and analysing data from multiple sources.
• Experience developing reports or dashboards for business users.
• Experience in short-term/ commercial insurance data is a plus.
• Exposure to underwriting/pricing/claims data.
• Experience with policy admin systems and data warehouses.

Responsibilities

• Produce portfolio reports covering premiums, claims, loss ratios and rate movements.
• Identify trends, data anomalies and underwriting opportunities.
• Translate analytics into actionable recommendations for risk, pricing and product reviews.
• Monitor exposure and concentration risks and data quality.
• Develop reliable datasets for reporting and modelling and maintain data definitions.

Skills

Advanced Excel

SQL

Power BI

Data quality

Data interpretation

Stakeholder communication

Analytical thinking

Education

Bachelor's degree in a quantitative field

Tools

Power BI

SQL

Data warehouses

Python/R (Adv)

Job description

Stay safe online. Now more than ever it's important to be cybersafe. See Santam's tips to help you stay safe online. Learn more.

We have an exciting opportunity for a Data Analyst within Santam Specialist Solutions based in Illovo Sandton.

What will make you successful in this role?

To produce reliable business information and actionable insights through the collation, validation and analysis of data, enabling informed underwriting, pricing, claims and portfolio management decisions within the CAHTMAEB business cluster.

Key responsibilities:

Portfolio Analytics and Underwriting Insights:

• Produce and analyse portfolio reports covering premiums, claims, loss ratios, rate movements and other relevant performance indicators.
• Identify emerging trends, underwriting opportunities, claims latency, risk concentrations and data anomalies.
• Translate analytical findings into clear recommendations that support risk selection, pricing, underwriting actions and product reviews.
• Monitor exposure accumulations, concentration risks and applicable limit breaches.

Data Management and Quality:

• Develop and maintain reliable datasets for reporting, pricing and modelling.
• Perform regular data validation, reconciliation and quality testing.
• Identify root causes of data quality issues and work with relevant stakeholders to implement sustainable corrective actions.
• Maintain data definitions, business rules, process documentation and appropriate audit trails.

Reporting and Business Intelligence:

• Produce accurate and timely management information, portfolio reports and dashboards.
• Develop and maintain self-service reports and business intelligence solutions.
• Ensure that reports use consistent definitions, approved data sources and appropriate controls.
• Present complex findings clearly to technical and non-technical stakeholders.

Pricing, Modelling and Technical Support:

• Prepare and validate data for pricing, segmentation, forecasting and predictive modelling.
• Support the testing, implementation and monitoring of rates, underwriting rules and analytical models.
• Assist with system changes, data migrations, rate updates and user acceptance testing.
• Support exposure analysis and reinsurance treaty renewals, regulatory and governance reporting.

Process Improvement and Stakeholder Engagement:

• Work with underwriting, actuarial, claims, reinsurance, finance and technology teams to deliver practical data solutions.
• Automate repeatable data and reporting processes to reduce manual effort and operational risk.
• Respond to ad hoc analytical requests and data enquiries.
• Promote data standards and support users in adopting reports, dashboards and analytical tools.
• Participate in approved AI and automation initiatives, including testing, implementation and monitoring.
• Contribute to the development, deployment and responsible governance of data and AI solutions that improve decision making, operational efficiency and customer outcomes.
• Work with business and technology stakeholders to identify and prioritise AI use cases that support Santam's strategic objectives, competitive advantage and long-term business performance.
• Support the ongoing monitoring of AI solutions for performance, data quality, explainability, fairness and compliance with approved governance, risk and ethical standards.

Qualifications & Experience

• Bachelor’s degree in Mathematics, Statistics, Actuarial Science, Data Science, Computer Science, Economics or another relevant quantitative discipline
• At least two years’ relevant experience in data analysis, business intelligence, actuarial analysis, pricing analytics or a similar analytical role
• Experience extracting, reconciling and analysing data from multiple sources
• Experience developing reports or dashboards for business users
• Experience in short-term insurance, commercial insurance or casualty insurance
• Exposure to underwriting, pricing, claims, exposure management or reinsurance data
• Experience working with policy administration systems and data warehouses

Skills

• Advanced Excel, including data validation, reconciliation and analytical modelling
• Proficiency in SQL for data extraction, transformation and analysis
• Experience using a business intelligence and visualisation tool, preferably Power BI
• Strong data management and data quality skills
• Experience working with relational databases, data warehouses or similar analytical data environments
• Ability to translate business requirements into clear analytical outputs
• Understanding of the AI solution lifecycle, including use case identification, data preparation, testing, deployment, performance monitoring and governance.
• Ability to evaluate AI generated outputs critically and translate them into reliable, explainable and actionable business insights.
• Awareness of responsible AI principles, including data privacy, security, fairness, transparency, human oversight and model risk.
• Experience using AI enabled analytical, automation or productivity tools in a controlled business environment.
• Experience contributing to or driving the development, implementation and ongoing monitoring of machine learning, generative AI or other advanced analytical solutions.

Advantageous:

• Experience with Python, R or another analytical programming language
• Knowledge of statistical modelling, forecasting, segmentation or machine learning
• Familiarity with insurance policy, claims, pricing and exposure data
• Business and stakeholder focus
• Results orientation
• Analytical thinking
• Innovation and continuous improvement
• Effective communication
• Planning and organisation
• Relationship building
• Data extraction, manipulation and reconciliation
• Database and data-warehouse concepts
• Business intelligence and visualisation
• Statistical analysis and modelling
• Reporting automation
• Systems integration and user acceptance testing

Getting ready for your interview

There is not just one way to be successful at Santam, nor is there one way to interview with us. Interviewing is a two-way process - it helps us learn about you, and it helps you learn about us, our people, and what you could do here.

Santam has been officially recognised by the Top Employers Institute as a Top Employer 2025 for excellence in people practices. This is the ninth consecutive year that we have achieved this accolade.