Business Intelligence Analyst

SUMMARY:
-

POSITION INFO:
The Role: Developing, maintaining and continuously improving the operational and financial reporting environment through data modelling, dashboard development, reporting automation and business intelligence solutions. Reporting to the Data & Business Intelligence Lead, the incumbent ensures the accuracy, consistency and availability of business data while supporting operational, financial, executive and Board reporting across the network. Working closely with Operations, Finance and Business Development, the role contributes to building a scalable, automated reporting ecosystem that enables better business decisions, reduces manual reporting effort, strengthens data governance and supports the company's digital transformation strategy. KEY RESPONSIBILITIES: Business Intelligence Development: Design, develop and maintain Power BI dashboards and build new reporting solutions Develop data models and maintain reporting datasets Enhance existing dashboards: standardise reporting, improve visualisation and usability, and optimise report performance Support self-service reporting across the business Measured by: dashboards delivered against the agreed BI roadmap and timelines, dashboard usage / adoption, and report performance and user feedback Reporting & Data Management: Produce, validate and support daily, weekly and monthly operational and financial reports Prepare standard reporting packs and support Executive and Board reporting Perform data imports and transformations, and maintain reporting templates and reporting schedules Troubleshoot reporting issues and ensure reporting accuracy and consistency Measured by: reports and packs issued on schedule, accuracy with no material corrections after distribution, and reporting issues resolved within the agreed turnaround Automation & Digital Innovation: Automate manual reporting processes and reduce manual reporting effort Improve data integration and standardise recurring processes Develop Power Automate workflows where applicable Investigate and implement emerging BI technologies and AI-enabled reporting solutions, supporting company's digital transformation initiatives Measured by: manual reporting hours saved, number of processes automated, and improvement in reporting turnaround time Data Quality & Governance: Maintain and monitor master data integrity Perform reconciliations between source systems, identify anomalies and implement corrective actions Maintain documentation and reporting standards Measured by: reconciliations completed and variances resolved, data quality issues closed, and documentation kept current Business Support & Collaboration: Support reporting requirements for Operations, Finance, Business Development, Site Operations, the Executive Committee and the Board Assist users with dashboards and data interpretation Provide user training and promote adoption of BI tools and best practices Measured by: stakeholder requests resolved within the agreed turnaround, users trained, and stakeholder feedback QUALIFICATION AND EXPERIENCE REQUIRED: Degree in Computer Science, Finance, Data Analytics, Information Systems, Statistics, Business Intelligence or Commerce (Analytics) (NQF 7) National Diploma or Degree (NQF 6) in a related field (Essential) Microsoft Power BI certification (advantageous) 3–5 years’ Business Intelligence experience within Retail, Fuel or QSR experience TECHNICAL SKILLS: Power BI development, SQL, data & financial modelling Reporting automation experience Advanced Excel Power BI and dashboard development SQL knowledge and ETL processes Business reporting Data Modelling & Analysis; Dashboard Development; Reporting Automation; Data Quality & Governance; Business Understanding; Stakeholder Support; Innovation & Continuous Improvement Sage 300 (advantageous) API integrations AI tools and automation platforms (e.g. Microsoft Copilot, Power Automate)