U

Business Analyst at University of Cape Town

University of Cape Town
Full-time
On-site
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