Business Intelligence Analyst

Prime South Africa; Gauteng; On-site; ZAR 400 000 - 600 000; Full time

Job summary

An established data analytics firm in South Africa seeks a BI & Reporting Analyst to transform data into actionable insights. Candidates should possess strong SQL skills, Power BI expertise, and be proficient in Python. Responsibilities include designing dashboards, developing data models, and automating reporting processes. The ideal candidate will collaborate with cross-functional teams to enhance decision-making through sophisticated data visualisation and clear documentation.

Qualifications

• Bachelor's Degree or equivalent experience in relevant fields.
• Extensive knowledge of SQL for data modelling and query optimisation.
• Expertise in creating interactive dashboards using Power BI.
• Proficient in Python, especially pandas for data manipulation.
• Experience with Git and basic command-line tools.

Responsibilities

• Design intuitive Power BI dashboards for various departments.
• Develop reusable data models and DAX measures.
• Write efficient SQL queries to extract data.
• Automate ETL processes and data quality checks using Python.
• Document datasets and SQL logic for clarity.

Skills

Strong SQL skills

Power BI expertise

Python proficiency

Comfortable with Git

Experience across Windows and Linux

Education

Bachelor's Degree in Mathematics, Statistics, Computer Science, Engineering, Biology, or equivalent experience

Tools

Power BI

SQL

Python

Git

Job description

TheBI & Reporting Analystwill be part of the Data Science & Analytics team, supporting departments across the business by transforming raw data into meaningful insights.

You will play a hands‑on role in building SQL data models, designing user‑friendly dashboards in Power BI, and automating data workflows to ensure timely, accurate, and actionable reporting.

This position is based at our Bryanston office and reports to the Head of Data Science & Analytics.

Qualifications & Technical Skills

A Bachelor's Degree in Mathematics, Statistics, Computer Science, Engineering, Biology, or equivalent experience

Strong SQL skills — including data modelling, query optimisation, and advanced joins / window functions

Power BI expertise — from semantic model design to interactive dashboard creation (Desktop & Service)

Python proficiency — especially using pandas for data manipulation and SQL integration

Comfortable with Git (GitHub, GitLab, or Azure Repos) and basic command‑line tools

Experience working across Windows and Linux environments

Key Responsibilities

Business Intelligence & Analytics

Design clear and intuitive Power BI dashboards for teams across sales, operations, and executive leadership.

Develop reusable data models and DAX measures to enable self‑service insights and scalable reporting.

Translate business questions into data‑driven visual stories that support better decision‑making.

Data Engineering & SQL

Write clean, efficient SQL queries to extract and prepare data from multiple sources.

Optimise stored procedures, views, and data transformations for clarity and performance.

Build and maintain lightweight, reproducible data pipelines using Python and / or Databricks.

Automation & Workflow Optimisation

Develop scripts to automate ETL, reporting refreshes, or data quality checks using Python (pandas, SQLAlchemy, or PySpark).

Use Git for version control and deploy code using basic CI / CD pipelines when needed.

Documentation & Quality Assurance

Document dashboards, datasets, and SQL logic for transparency and maintainability.

Write tests to validate critical SQL queries or Python code and reduce the risk of data errors.

Collaboration

Work closely with senior data scientists, analysts, and business owners to clarify requirements and deliver value quickly.

Proactively identify and raise data quality issues — and suggest practical solutions rather than short‑term fixes.