Business Intelligence Team Leader (CPT/JHB) at Santam Insurance

The role

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

What will you do?

• We are looking for a hands-on Business Intelligence Team Leader to lead and grow the delivery of scalable, well-governed Power BI reporting solutions at Santam Client Solutions. You will be responsible for ensuring the successful migration of manual Excel reports to dynamic Power BI dashboards, with a strong focus on reusability, accuracy, and stability.
• You’ll manage a small, junior BI team and work across business and IT to ensure timely, validated, and well-documented reporting assets that support decision-making. This role requires a strong mix of technical Power BI expertise, data modeling skills, and delivery management

What will make you successful in this role?

KEY RESPONSIBILITIES:

• Own the end-to-end Power BI development lifecycle, from Jira ticket to dashboard delivery and post deployment support.
• Review and validate junior team members’ work to ensure data accuracy, reliability, and consistency.
• Refactor and migrate legacy Excel reports into scalable Power BI solutions using dataflows and standardised models.
• Set up and enforce technical documentation standards, refresh schedules, and report governance processes.
• Build reusable dataflows and ensure a single source of truth across reports.
• Manage the team’s Jira board and support queue, ensuring consistent prioritization and timely delivery.
• Collaborate with Central IT to improve data access, data quality, and pipeline reliability.
• Work directly with business leaders to understand reporting needs and deliver practical, insight-driven dashboards.
• Act as the bridge between Business Analyst (BA) teams and the BI team to ensure clear understanding of requirements, strong technical solutioning , documentation, and alignment to business needs.
• Drive the adoption and optimisation of Powerbi and other modern BI technologies to enhance delivery efficiency and innovation.
• Maintain a central library of standardised calculations and ensure consistency across all reporting assets.
• Coaching and mentoring of junior BI staff

WHAT YOU NEED TO SUCCEED:

Technical Must-Haves

• 5+ years of hands-on experience in Power BI development in enterprise environments
• Strong proficiency in DAX, M/Power Query, and Power BI Dataflows
• Solid SQL skills and understanding of relational data models
• Comfortable working in Power BI Premium Capacity environments
• Experience working with Jira/DevOps tools for tracking and delivery
• Exposure to Microsoft Fabric F64 and Power Automate (advantageous)

Leadership & Delivery

• Experience mentoring or leading junior BI developers
• Able to manage delivery pipelines, set standards, and enforce good practices
• Strong communication and collaboration skills across business and IT
• Comfortable with data wrangling from different data environments

PERSONAL FIT

• You enjoy rolling up your sleeves to build, debug, and coach
• You thrive in messy environments where you bring order and structure
• You’re driven by getting things done, not just planning them
• You balance technical detail with business understanding
• You’re adaptable and can work through data gaps and tech debt

Qualifications and Experience

• Bachelor’s degree in computer science, Information Systems, or related
• 5+ years BI development, 2+ years in a leadership/oversight role

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