Business Intelligence Analyst

Prime South Africa; Randburg; On-site; ZAR 450 000 - 600 000; Full time

Job summary

A prominent analytics company in Randburg seeks an experienced BI & Reporting Analyst to transform raw data into actionable insights. You will design dashboards, optimize SQL queries, and automate data workflows using Python. The ideal candidate holds a relevant Bachelor’s degree and possesses strong SQL and Power BI skills. This role supports various departments by enhancing data-driven decision-making and requires collaboration with senior staff for optimal results.

Qualifications

• Bachelor’s Degree or equivalent experience in a relevant field.
• Strong SQL skills for data modelling and query optimisation.
• Expertise in Power BI for dashboard creation.

Responsibilities

• Design intuitive Power BI dashboards for various teams.
• Write clean SQL queries for data extraction and preparation.
• Develop scripts for automating reporting and data quality checks.

Skills

SQL skills

Power BI expertise

Python proficiency

Git knowledge

Data analysis

Education

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

Tools

Power BI

Databricks

SQLAlchemy

Job description

The BI & Reporting Analyst will 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.