Business Intelligence Developer - CPT

Sanlam; Cape Town; On-site; ZAR 450 000 - 600 000; Full time

Job summary

A leading insurance company is seeking a Business Intelligence Developer in Cape Town. You will support business stakeholders, design and build Power BI reporting solutions, and help transition from Excel-based reporting to Power BI. The ideal candidate has over 2 years of experience in Power BI development and strong SQL skills. This role emphasizes collaboration and innovation in a diverse workplace.

Benefits

Diversity and inclusion initiatives

Career development opportunities

Employee benefits

Qualifications

• 2+ years’ experience with Power BI development.
• Strong SQL skills and understanding of relational databases.
• 2+ years of BI or analytics experience in a business-facing environment.

Responsibilities

• Assist with ad-hoc data questions.
• Design and develop Power BI dashboards based on business needs.
• Build dataflows and transform data.

Skills

Power BI development

Power Query (M)

DAX

SQL

Power BI Service

Dataflows

Education

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

Tools

Jira

Power Automate

Job description

The role

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

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.

What will make you successful in this role?

KEY RESPONSIBILITIES

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)

Business Support

• 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

WHAT YOU NEED TO SUCCEED

Technical Must‑Haves

• 2+ years’ experience with Power BI development
• Strong Power Query (M) and DAX skills
• 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

Qualification and Experience

• Bachelor's degree in Information Systems, Stats, Commerce, or related field (preferred)

• 2+ years of BI or analytics experience in a business‑facing environment

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

Who are you

Santam is the market leader in the general insurance industry in Southern Africa. We are a large, diversified, expanding and transforming company and whilst based in South Africa, we are rapidly moving into a number of emerging markets, both in Africa and Asia.

Our success is rooted in our passion for our clients and everything we do is centered on our delivery of Insurance Good and Proper. We’re about people. People drive our business so it follows that we want to recruit the best people possible whether they work for us permanently or for a short time as temporary employees.

At Santam we are committed to transformation and embracing diversity. This commitment is what drives us to achieve a diverse workplace with employment equity as a key goal to create an inclusive workforce, representative of the demographics of our society. In achieving our employment equity goals we give preference to applicants from the designated groups in alignment with the Divisions Employment Equity targets.