Bi & Reporting Analyst

Johannesburg, GP, ZA, South Africa

Job Description

You 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.



Main 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.

Minimum requirements

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

Nice to Have

Familiarity with dbt, Delta Lake, or Databricks

CI/CD workflows for Power BI using tools like Azure DevOps or GitHub Actions

Exposure to high-volume transactional domains such as insurance

Experience with cloud data platforms (e.g., Azure SQL, AWS RDS, or Google BigQuery)

Basic understanding of Docker or containerised deployments

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD1554743
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Johannesburg, GP, ZA, South Africa
  • Education
    Not mentioned