Business Intelligence Developer - CPT

Sanlam Limited; Cape Town; On-site; ZAR 500 000 - 700 000; Full time

Job summary

A leading insurance company in Cape Town is seeking a Business Intelligence Developer to support business users and develop scalable Power BI reports. The ideal candidate will have over 2 years of Power BI experience, strong skills in Power Query and DAX, and a Bachelor’s degree in a relevant field. Join a collaborative team focused on transforming data insights into impactful business decisions.

Qualifications

• 2+ years’ experience with Power BI development.
• Strong SQL skills and understanding of relational databases.
• Familiarity with Power BI governance standards.

Responsibilities

• Assist business users with ad-hoc data queries and reporting needs.
• Design and develop Power BI dashboards based on business requirements.
• Build dataflows and ensure data accuracy and consistency.

Skills

Power BI development

Power Query (M)

DAX

SQL

Agile tools (Jira/DevOps)

Education

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

Tools

Power BI Service

Power BI Premium Capacity

Microsoft Fabric

Power Automate

Job description

This career opportunity is available at Santam Client Solutions for theBusiness Intelligence Developerwho 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
• Client focus
• Flexibility and adaptability
• Cultivates innovation
• Strategic decision making
• Analytical thinking
• 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.