Data Analyst - CPT

Sanlam Limited; Cape Town; On-site; ZAR 400,000 - 600,000; Full time

Job summary

A leading financial services provider is seeking a Data Analyst in Cape Town. Your role will involve maintaining Power BI models, managing data assets, and generating actionable insights through reports. Ideal candidates will possess a Bachelor's degree and 4-6 years of relevant experience, particularly within the insurance sector. Proficiency in SQL and strong analytical skills are essential. This permanent position is based at the Head Office.

Qualifications

• 4-6 years of experience in a data analyst or BI analyst role.
• DAMA Certified Data Management Professional Practice (CDMP) recommended.
• Experience with data integration and management across multiple sources.
• Understanding of data modelling and visualization best practices.
• Experience in the insurance industry is recommended.

Responsibilities

• Maintain and enhance existing Power BI models used in operational reporting.
• Develop and maintain internal data assets for customer experience function.
• Create and maintain business reports that guide decision-making.
• Provide analytical support for strategic initiatives.

Skills

Advanced coding skills in SQL

Advanced coding skills in Java

Advanced coding skills in R

Advanced coding skills in Python

Strong modelling skills

Good report writing and presentation skills

Strong ability to translate data into insights

Commercial and business acumen

Analytical thinking

Client focus

Education

Bachelor’s degree in Data Science, Statistics, Computer Science

Tools

SQL

Power BI

Job description

A Data Analyst position is available within Santam Re & International. This is a permanent opportunity based in Head Office in Cape Town.

What will you do?

To support and enhance the business intelligence capabilities within the organization by maintaining and developing Power BI models, managing internal data assets, and delivering actionable insights through dashboards and reports. The role will also contribute analytical expertise to strategic projects across the group

What will make you successful in this role?

• Maintain and enhance existing Power BI models used in operational reporting.
• Ensure data accuracy, performance optimization, and usability of BI solutions.
• Data Management & Integration
  • Develop and maintain internal data assets to support modelling initiatives within the customer experience function.
  • Integrate and manage internal data sources to ensure consistency and reliability.
  • Collaborate with data engineering and IT teams to ensure smooth data flows and governance.
• Design, build, and maintain dashboards that track key performance indicators (KPIs).
• Ensure dashboards are intuitive, insightful, and aligned with business objectives.
• Reporting & Insight Generation
  • Create and maintain business reports that guide decision-making and drive action.
  • Translate complex data into clear, actionable insights for stakeholders.
• Strategic Project Participation
  • Provide analytical support for strategic initiatives across the group.
  • Work collaboratively with cross-functional teams to deliver data-driven solutions

Qualifications and Experience

• Bachelor’s degree in Data Science, Statistics, Computer Science, or related field.
• 4-6 years of experience in a data analyst or BI analyst role.
• DAMA Certified Data Management Professional Practice (CDMP), preferably practitioner level, would be highly recommended
• Experience with data integration and management across multiple sources.
• Strong understanding of data modelling and visualization best practices and maintenance of key performance indicators.
• Proficiency in SQL and Power BI essential.
• Experience in a similar role in the insurance industry is recommended

Skills

• Advanced coding skills in one or more of the following: SQL, Java, R, Python, etc.
• Strong modelling skills including experience in performing statistical investigations and building pricing / predictive / machine learning models
• Experience working with client administration systems and data warehousing
• Self-starter, problem solver and finisher
• Good report writing and presentation skills
• Strong ability to translate data into meaningful insights
• Commercial and business acumen
• Ability to engage with people from all parts of the organisation
• Analytical thinking
• Problem solving
• Planning and organising skills
• Ability to work independently and in a team.
• Client focus
• Drives results
• Flexibility and adaptability
• Relating and networking
• Data base management - manipulation and automation