Senior BI Analyst - Power BI & Automation

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

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.