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 adhoc 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 utilize 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, decisions trees and feature engineering
Knowledge and Skills
Data design
Problem solving
Business Knowledge
Statistical and Data modelling