Business Intelligence Developer

Job Purpose

This career opportunity is available at Santam Client Solutions for the

We're looking for a

This career opportunity is available at Santam Client Solutions for the Business Intelligence Developer who will be based in either Cape Town or Johannesburg

We're looking for a BI Analyst–Developer who thrives at the intersection of business and data. This is a dual-role position where you will support business stakeholders day-to-day and also design and build scalable Power BI reporting solutions that drive insight and decision-making.

You’ll be embedded into specific business areas (e.g., sales, servicing, retetions) on a rotating basis to:

• Assist with ad-hoc data questions
• Troubleshoot report issues
• Translate business requirements into clear BI solutions
• Build and maintain Power BI reports and dataflows

You’ll work as part of a growing BI team that is transforming a legacy Excel-based reporting setup into a scalable, governed Power BI environment.

• Serve as the first point of contact for business users in your assigned department
• Answer ad-hoc data queries, support decision-makers, and guide users on interpreting reports
• Work closely with stakeholders to clarify reporting requirements
• Proactively identify reporting gaps or improvement opportunities understand needs and translate into reporting solutions
• Facilitate monthly reporting processes that rely on data (commissions, management reporting and monthly analysis)

• Design and develop Power BI dashboards and reports based on business needs
• Build dataflows and transform data using Power Query (M) and DAX
• Ensure data is accurate, consistent, and follows BI governance standards
• Help migrate existing Excel-based reports into automated, scalable Power BI assets
• Participate in peer reviews and team-based development work

• 3+ years’ experience with Power BI development
• Strong Power Query (M) and DAX skills
• Strong SQL skills and an understanding of relational databases, data warehouses and data architecture.
• Exposure to data high level data engineering and data modelling
• Strong SQL skills and understanding of relational databases
• Experience working with Power BI Service and Dataflows
• Familiarity with Power BI Premium Capacity
• Exposure to Agile tools like Jira/Dev Ops for managing tasks (advantageous)
• Bonus:
  Exposure to Microsoft Fabric or Power Automate
• Demonstrates an inclination toward data science, with an interest in applying statistical or predictive techniques to business problems.

• Bachelor's degree in Information Systems, Stats, Commerce, or related field (preferred)
• 3+ years of BI or analytics experience in a business-facing environment
• Advantageous:
  Short-term insurance experience

• Drives results
• Deciding and initiating action
• Leading and supervising
• Collaborates
• Client focus
• Flexibility and adaptability
• Cultivates innovation
• Strategic decision making
• Analytical thinking
• Influencing/ gaining commitment
• Business acumen
• Coaching and development

We’re all about building strong, lasting relationships with our employees. We know that you have hopes for your future – your career, your personal development and of achieving great things. We pride ourselves in helping our employees to realise their worth. Through its five business clusters – Sanlam Fintech, Sanlam Life and Savings, Sanlam Investment Group, Sanlam Allianz, Santam, as well as MiWay and the Group Office – the group provides many opportunities for growth and development.

The shortlisting process will only start once the application due date has been reached. The time taken to complete this process will depend on how far you progress and the availability of managers.

Santam is the market leader in the general insurance industry in Southern Africa. As a large, diversified, and expanding company, we are committed to transformation and growth. While our headquarters are in South Africa, we are rapidly extending our presence into emerging markets across Africa and Asia.

With a client…