Data Analyst

Sanlam; Johannesburg; On-site; ZAR 300 000 - 400 000; Full time

Job summary

A leading insurance firm in Johannesburg is looking for a Data Analyst to enhance business reporting and build models for decision-making. The ideal candidate should have a degree in a related field and 2-3 years of experience, preferably in the insurance industry. Advanced SQL, Python, and PowerBi skills are essential. This role involves data wrangling, dashboard creation, and collaboration with analytics teams, providing a dynamic environment for innovation and problem-solving.

Qualifications

• 2-3 years of work experience, preferably in the insurance industry.
• Advanced SQL skills, including data processing and query optimisation.
• Experience in R and Python is essential.

Responsibilities

• Wrangle data and enhance business reporting.
• Build models that enhance decision-making and profitability.
• Collaborate with analytics teams for efficient data delivery.

Skills

Data wrangling

SQL

Python

R

PowerBi

Excel

Problem solving

Statistical and Data modelling

Education

Degree in Actuarial Science/Econometrics/Statistics/Computer Science/Data Science or related field

Tools

SAS

Hadoop

Qlik/QlikSense

Job description

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.

What will you do?

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.

What will make you successful in this 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

Qualification and Experience

• 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 PowerBi (essential) and Qlik/QlikSense (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

Knowledge and Skills

Data design

Problem solving

Business Knowledge

Statistical and Data modelling