Business Intelligence (BI) Analyst - Power BI & Excel
Executive Placements · Johannesburg, Gauteng
Stop applying one at a time.
JobAlertsZA auto-applies to South African jobs like this one for you, overnight. Upload your CV once — we do the applying.
Start free — we apply for you →• Connect, consolidate and clean branch data from Excel, Microsoft Teams and SharePoint. • Develop and maintain Power BI dashboards for production, warranty and quality, sales, gross profit, work in progress and group performance. • Use Power Query, data modelling and DAX to automate reporting and refreshes. • Standardise reporting definitions and data capture across branches; identify missing, inconsistent or inaccurate information. • Analyse trends, highlight performance differences, bottlenecks and unusual results, and provide reliable information for management decisions. • Work with branch, workshop, production, sales and finance teams to understand operational information and reporting needs. • Maintain reporting processes and explain calculations and findings clearly to management. Essential: • Microsoft Power BI • Advanced Microsoft Excel • Power Query • Data modelling and DAX • Microsoft Teams / SharePoint data integration
Advantageous: SQL and Power Automate. Must understand data validation, automated refreshes and how to explain and verify calculations. AI tools may support development, but the candidate must independently understand and validate their work. Python is not required. • Approximately five years’ practical BI, Power BI or data analysis experience preferred. • Experience building dashboards and consolidating multiple data sources. • Experience in automotive, manufacturing, engineering, logistics, fleet or a similar operational environment is advantageous. • Able to work with operational and financial data and engage directly with production or branch managers. • Must be able to demonstrate practical Power BI capability through a work example or assessment.