Business Intelligence Developer

Santam Insurance; South Africa; On-site; ZAR 600,000 - 900,000; Full time

Job summary

Santam Client Solutions is hiring a BI Analyst–Developer to design and build scalable Power BI reporting solutions that drive insight and decision-making. You will be embedded in various business areas, tackling ad-hoc queries and transforming requirements into high-quality BI assets.

The role emphasizes migrating legacy Excel reporting to a governed Power BI environment, with exposure to Power Query, DAX, SQL, and data modelling.

Qualifications

• 3+ years of BI analytics experience in a business-facing environment.
• Bachelor's degree in Information Systems, Stats, Commerce, or related field preferred.
• Experience in short-term insurance is advantageous.

Responsibilities

• Design and build scalable Power BI reporting solutions that drive insight and decision-making.
• Translate business requirements into clear BI solutions.
• Build and maintain Power BI reports and dataflows.
• Assist with ad-hoc data questions and troubleshoot report issues.
• Migrate Excel-based reports into automated Power BI assets.

Skills

Power BI development

Power Query (M)

DAX

SQL

Relational databases

Data modelling

Power BI Service & Dataflows

Microsoft Fabric / Power Automate

Jira/DevOps

Data science inclination

Education

Bachelor's degree in Information Systems, Stats, Commerce, or related field

Tools

Power BI

Power Query

DAX

SQL

Data modelling tools

Job description

Stay safe online.Now more than ever it’s important to be cybersafe. See Santam’s tips to help you stay safe online. Learn more.

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

What will you do?

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.

Key Resposibilities?

Business Support

• 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

Technical Must-Haves

• 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/DevOps 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.

QUALIFICATIONS

• 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

PERSONAL ATTRIBUTES

• 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

Build a successful career with us

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.

Turnaround time

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.

Our commitment to transformation

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 base of over 1 million policyholders, Santam serves individuals, commercial enterprises, specialist business owners, and institutions—including 80 of the Top 100 companies listed on the JSE. Our commitment to Insurance, Good and Proper goes beyond just providing cover—we offer peace of mind, ensuring our clients can focus on living in the moment, not worrying about the unexpected. Because at Santam, we believe the freedom to seize every day is worth protecting.

Our commitment to diversity, inclusion, and belonging. As an equal opportunity employer, we encourage applications from candidates of all backgrounds, including persons with disabilities. We are dedicated to neuro-inclusivity and fostering a workplace where everyone can thrive.

Onboarding

You made it. Here we ensure we receive all your documents to get you onto our payroll system.

Advertise

Step 1

Our vacancies are advertised between 3-5 days depending on the market availability of the skills required.

Onboarding

Step 2

Could take a couple of days depending on the volume and the screening process, which various according to the complexity of the role.

Advertise

Step 3

Long listed candidates are sent to the hiring manager to review and consider for the next stage of the selection process.

Telephonic screening

Step 4

Candidates may be contacted for a short screening interview to get to know them better and to ask any clarity seeking questions.

Your interview

Step 5

We use a competency interview model. Interview dates will be confirmed via e-mail. During the interview you will be introduced to the panel and the process will be explained. Remain calm and sell yourself. This is our opportunity to match your skills to the job. You only get one shot!

Assessment

Step 6

Should we like what you bring to the table, depending on the job you are being considered for, you may be invited to complete a psychometric assessment. Further employment checks are conducted the ensure the validity of your credentials.

Step 7

Prior to an offer being made, there may be a second interview to meet with the Head of Department. Should there be a need for any further interviews, be sure to bring the same charm that got you through your first interview.

Onboarding

Step 8

You made it. Here we ensure we receive all your documents to get you onto our payroll system.

TIPS & TRICKS

Getting ready for your interview

There is not just one way to be successful at Santam, nor is there one way to interview with us. Interviewing is a two-way process - it helps us learn about you, and it helps you learn about us, our people, and what you could do here.

Santam has been officially recognised by the Top Employers Institute as a Top Employer 2025 for excellence in people practices. This is the ninth consecutive year that we have achieved this accolade.