Data Analyst

The role

Data Analyst

If you are a solution minded and innovative individual who is passionate about data and insurance, then this rare and exciting opportunity within the Santam Client Solutions Analytics & Reporting space is for you.

The purpose of the role is to join a small group of data pioneers to wrangle data, enhance business reporting and build models to enhance decision‑making and profitability. This is a unique opportunity to work in a dynamic environment and collaborate across analytics teams, while having the freedom to create the data assets that you will model on; with technical data work, reporting and modelling being the core responsibilities of the role.

• Data wrangling
• Building data flows from multiple sources in SAS and creating data assets in Hadoop
• Dashboard and Report creation
• Data extracts for ad‑hoc business requests
• Trend analysis and reporting from extracted data
• Assist stakeholders by doing manual extracts from existing dashboards and SQL sources where required
• Look for opportunities to improve existing reports and dashboards
• Collaborate with multiple analytics teams to ensure efficient delivery
• Work closely with actuarial and pricing teams on collaborative insights and modelling projects
• Work with the underwriting team to come up with unique insights that drive underwriting rules and decisions
• Do web scraping and data acquisition from novel data sources for insights and analysis

• Degree in Actuarial Science/Econometrics/Statistics/Computer Science/Data Science or related field.
• 2-3 years of work experience, preferably in the insurance industry
• Advanced SQL skills, including data processing, query optimisation, ability to utilise different SQL dialects (MsSQL, Hadoop SQL, Sybase)
• Experience in R, Python (essential) and SAS (preferred) – SAS and Python are used in the role
• Experience with Power Bi (essential) and Qlik/Qlik Sense (preferred)
• Advanced Excel skills (Power query, VBA, complex formulas)
• Hands‑on understanding of insurance concepts and accounting data
• Hands‑on experience with web scraping, API development and data science application development will be beneficial
• Previous practical experience within insurance pricing, underwriting and claims environments will be beneficial
• Understanding and working experience with machine learning and statistical modelling, especially GLMs, decision trees and feature engineering

Data design

Problem solving

Business Knowledge

Statistical and Data modelling