Business Analyst at University of Cape Town

Role Overview

• The Business Analyst will support operational, clinical, and strategic decision-making by transforming complex healthcare and operational data into clear, reliable, and actionable insights. The role focuses on data analysis, data quality, report writing, and the development of interactive Power BI dashboards for a diverse range of stakeholders.

Qualifications:

• A degree, diploma, or equivalent qualification, combined with significant relevant professional experience in Business Analytics, Information Systems, Health Informatics, Data Science, or a related field
• Power BI certification (e.g. Microsoft PL-300 or equivalent)
• Formal training or certification in SQL, data modelling, or data visualisation

Required Skills:

• Data & Analytics Tools
• Power BI (Power Query, DAX, data modelling, dashboard development)
• Advanced Excel (formulas, PivotTables, Power Pivot, Power Query)
• SQL for data extraction, validation, and analysis
• R or Python for data cleaning, transformation, and analysis (e.g. tidyverse, pandas)

Core Competencies

• Data analysis, cleaning, transformation, and structuring
• Strong report writing and insight generation skills
• Ability to translate business needs into clear analytical outputs and documentation
• High attention to detail with a strong focus on data quality
• Strong analytical and problem-solving skills
• Excellent communication skills across technical and non-technical stakeholders

Experience:

• Proven experience in a Business Analyst, Data Analyst, or similar analytics-focused role
• Demonstrated experience analysing complex datasets and producing actionable insights
• Experience delivering reporting solutions in multi-stakeholder environments
• Experience producing management, operational, and performance reports
• Experience working with structured data from relational databases
• Experience in healthcare or regulated environments (highly desirable)

Key Responsibilities:

• Develop high-quality written analytical, operational, and management reports
• Clean, validate, and structure data from multiple sources to ensure accuracy and integrity
• Design, develop, and maintain Power BI dashboards, reports, and data models
• Translate complex datasets into clear visual dashboards and structured written outputs
• Build and optimise data models and semantic layers for reporting and analytics
• Support automation of data refreshes and reporting processes
• Engage with stakeholders to gather, analyse, and document business and reporting requirements, translating priority decision needs into clear analytical specifications, data definitions, and reporting outputs
• Analyse healthcare and operational data to identify trends, risks, and performance insight
• Document business requirements, data definitions, reporting logic, and reporting standards
• Ensure reporting complies with healthcare data governance, privacy, and regulatory requirements
• Troubleshoot data quality and reporting issues and continuously improve reporting solutions

Closing Date 6 February 2026