Data and BI Support Analyst

PTY; South Africa; On-site; ZAR 420,000 - 660,000; Full time

Job summary

Red Ember Recruitment (PTY) Ltd invites applications for a Data & BI Support Analyst to back the BI function in Gauteng. The role emphasizes transforming multi-source data into reliable insights, building data pipelines, and creating Power BI reports.

Office-based position requiring collaboration with stakeholders to translate business needs into analytics outputs. The ideal candidate holds a data analytics or related degree and has 2–4 years of BI/reporting experience, with SQL, Power BI, and

Qualifications

• 2–4 years in a Data Analyst role supporting BI/reporting.
• Tertiary qualification in data analytics, information systems, statistics, CS or related field.

Responsibilities

• Design, build, and maintain data pipelines (ETL) from SQL databases, Excel/CSV and other sources.
• Develop, publish, and iterate dashboards and reports in Power BI (data modelling, DAX, Power Query).
• Write performant SQL for data extraction, validation, and KPI calculations.
• Assist with implementing data quality checks in reporting.
• Apply best practices in validating data before distributing analyses to stakeholders.
• Collaborate with the BI Manager and stakeholders to translate requirements into dashboards and insights.

Skills

Analytical storytelling

AI tool proficiency

Python exposure

Data governance awareness

Education

Degree/Diploma in Data Analytics, Information Systems, Statistics, Computer Science or related field

Grade 12

Tools

Power BI

SQL

Excel

Job description

Red Ember Recruitment (PTY) Ltd | Permanent

Data and BI Support Analyst

Modderfontein, South Africa | Posted on 26/02/2026

Red Ember Recruitment is seeking, on behalf of our client, a Data & BI Support Analyst to support the Business Intelligence function. The role is office-based in Gauteng.

The Data & BI Support Analyst will work closely with the BI Manager to transform raw, multi-source data into reliable, timely, and actionable insights. The role involves designing and maintaining data pipelines, developing and supporting Power BI dashboards and reports, writing performant SQL, assisting with data quality checks, and collaborating with stakeholders to translate business requirements into analytical outputs. The position blends strong data fundamentals with modern AI-assisted analysis to accelerate insight generation, reporting delivery, and decision support.

Responsibilities

• Design, build, and maintain data pipelines (ETL) from SQL databases, Excel/CSV and other sources.
• Develop, publish, and iterate dashboards and reports in Power BI (data modelling, DAX, Power Query).
• Write performant SQL for data extraction, validation, and KPI calculations.
• Assist with implementing data quality checks in reporting.
• Apply sound best practices in validating data before distributing any analytical data for internal or external consumption by stakeholders.
• Collaborate with the BI Manager and stakeholders to translate requirements into data artefacts, dashboards, and insights.

Requirements

• Grade 12.
• Tertiary qualification (Degree/Diploma in Data Analytics, Information Systems, Statistics, Computer Science or related field).
• 2–4 years in a Data Analyst role supporting BI/reporting, ideally in operations or service environments.

Skills & Knowledge

• SQL (intermediate to advanced): joins, aggregations, etc.
• Power BI: data modelling, DAX, Power Query; dashboard UX and performance optimisation.
• Excel (advanced): Pivot Tables, Power Query, data cleaning techniques.
• Analytical storytelling: turning data into clear narratives and recommendations.
• Awareness of data governance and privacy (e.g., POPIA).
• Exposure to Python or suitable alternatives to enable report automation.

Desireable

• AI tool proficiency: Copilot/ChatGPT or similar for insight generation; prompt engineering best practices and result validation.