Data and BI Support Analyst

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.

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.

Think-Cell