Business Intelligence Analyst

OttoBauthentic; Gauteng; On-site; ZAR 420,000 - 780,000; Full time

Job summary

Ottobauthentic in Gauteng is seeking a talented BI professional to design, develop and maintain the data-driven reporting environment. You will build Power BI dashboards, develop data models and automate reporting to support operations, finance and leadership.

You will collaborate with Operations, Finance and Business Development to deliver automated, governance-driven reporting, enhance performance, and enable executive decision-making in a digitally transforming network.

Qualifications

• 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)
• Power BI certification (advantageous)
• 3-5 years' Business Intelligence experience within Retail, Fuel or QSR experience

Responsibilities

• 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
• 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
• 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
• Maintain and monitor master data integrity
• Perform reconciliations between source systems, identify anomalies and implement corrective actions
• Maintain documentation and reporting standards
• 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

Skills

Data storytelling

Stakeholder collaboration

Problem solving

Self-service reporting

Education

Bachelor-level degree in a related field

NQF6 Diploma/Degree in related field

Tools

Power BI

SQL

Data modelling

Reporting automation

Advanced Excel

ETL processes

API integrations

AI tools

Sage 300

Job description

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)