Business Intelligence Analyst - Rosebank

SUMMARY:

Role Purpose

Business Intelligence Development

• Design, develop and maintain Power BI dashboards and reporting solutions.
• Develop and maintain data models, datasets and reporting structures.
• Enhance existing dashboards by improving standardisation, visualisation, usability and performance.
• Develop reporting solutions that support business intelligence requirements across multiple departments.
• Promote and support self-service reporting capabilities throughout the organisation.
• Ensure dashboards and reporting tools provide accurate, relevant and accessible business information.

Reporting & Data Management

• Produce, validate and maintain daily, weekly and monthly operational and financial reports.
• Prepare standardised reporting packs for management, executive and Board-level reporting.
• Perform data imports, transformations and consolidations.
• Maintain reporting templates, schedules and reporting documentation.
• Investigate and resolve reporting discrepancies, ensuring data accuracy and consistency.
• Ensure all reporting requirements and deadlines are met.

Reporting Automation & Digital Innovation

• Identify and automate manual reporting processes to improve efficiency and reduce administrative effort.
• Develop and implement automated reporting workflows and data integration processes.
• Utilise Power Automate and other relevant technologies to streamline recurring reporting activities.
• Investigate and implement emerging Business Intelligence technologies and AI-enabled reporting solutions.
• Identify opportunities to improve reporting turnaround times, data accessibility and business intelligence capabilities.
• Contribute to the organisation's broader digital transformation and Business Intelligence strategy.

Data Quality & Governance

• Maintain and monitor master data integrity across relevant business systems.
• Perform reconciliations between source systems and reporting datasets.
• Identify data anomalies, investigate discrepancies and implement corrective actions.
• Maintain data documentation, reporting standards and governance procedures.
• Ensure reporting processes are consistent, reliable and aligned with business requirements.

Business Support & Stakeholder Collaboration

• Support reporting and analytical requirements across Operations, Finance, Business Development and Site Operations.
• Provide reporting support to the Executive Committee and Board.
• Assist stakeholders with dashboard usage, data interpretation and reporting queries.
• Provide user training and promote the effective adoption of Business Intelligence tools.
• Work collaboratively with cross-functional teams to understand business requirements and develop appropriate reporting solutions.
• Communicate analytical findings and business insights effectively to both technical and non-technical stakeholders.

POSITION INFO:
Role Requirements Qualifications National Diploma or Degree (NQF Level 6 or higher) in Computer Science, Finance, Data Analytics, Information Systems, Statistics, Business Intelligence, Commerce or a related field. A Degree at NQF Level 7 in a relevant discipline will be advantageous. Microsoft Power BI certification will be advantageous. Experience Minimum of 3-5 years' Business Intelligence or relevant data analytics experience will be advantageous. Proven experience developing and maintaining Power BI dashboards and reporting solutions. Strong practical experience with SQL, data modelling and ETL processes. Experience producing and maintaining operational and financial business reports. Experience with reporting automation and improving manual reporting processes. Retail, fuel, convenience retail or Quick Service Restaurant (QSR) industry experience will be advantageous. Experience working with financial data and supporting management or executive reporting will be beneficial. Technical Requirements Advanced Microsoft Excel skills, including Power Query and Power Pivot. Strong Power BI development and dashboard visualisation capabilities. Working knowledge of SQL and database querying. Understanding of data modelling, data warehousing concepts and ETL processes. Proficiency in Microsoft Office and Business Intelligence platforms. Knowledge of Sage 300 will be advantageous. Experience with API integrations will be advantageous. Exposure to AI tools and automation platforms, particularly Microsoft Copilot and Power Automate, will be beneficial. Key Competencies Strong analytical and data interpretation skills. Excellent problem-solving and critical-thinking abilities. Strong business and financial understanding. High attention to detail and commitment to data accuracy. Ability to identify process improvements and develop innovative reporting solutions. Excellent planning, organisation and time-management skills. Strong stakeholder management and communication abilities. Effective presentation skills and the ability to explain complex data in a clear and practical manner. Project coordination and the ability to manage multiple reporting requirements. Adaptability and resilience in a deadline-driven environment. Self-driven, curious and committed to continuous improvement. Professionalism, integrity and the ability to maintain strict confidentiality. A collaborative, customer-focused and solutions-oriented approach. Working Conditions Office-based position at Head Office. Must be able to work under pressure and meet daily, weekly and month-end reporting deadlines. May be required to work extended hours when necessary. Must be comfortable engaging with stakeholders across multiple departments, including senior management and the Board. Should you not receive a response within 10 working days, please consider your application unsuccessful.