Business Intelligence Analyst (Rosebank) (Gauteng)

Duties & Responsibilities

JOB PURPOSE

Developing, maintaining and continuously improving Company 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 Company 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.

MINIMUM REQUIREMENTS

EDUCATION: Ideal

 Degree in Computer Science, Finance, Data Analytics,

Information Systems, Statistics, Business Intelligence or

Commerce (Analytics) (NQF 7)

EDUCATION: Essential

 National Diploma or Degree (NQF 6) in a related field

 Microsoft Power BI certification (advantageous)

WORK EXPERIENCE: Ideal

 3–5 years’ Business Intelligence experience

 Retail, Fuel or QSR experience

 Power BI development, SQL, data & financial modelling

 Reporting automation experience

WORK EXPERIENCE: Essential

 Advanced Excel

 Power BI and dashboard development

 SQL knowledge and ETL processes

 Business reporting

AGILITY

Data Modelling & Analysis; Dashboard Development; Reporting

Automation; Data Quality & Governance; Business Understanding;

Stakeholder Support; Innovation & Continuous Improvement

REPORTING

No allocation of employees. No supervision.

Direct reporting line is to the  Data & Business Intelligence Lead

Incumbent liaises with Cross-functional teams (Operations, Finance, Business

Development, Site Operations), Exco and the Board.

PERSONAL ATTRIBUTES

What level of problem solving is required Intermediate to Advanced

What level of decision making is required

Intermediate – works independently on reporting and data

solutions within agreed priorities set by the Data & Business

Intelligence Lead

Working conditions

 Pressure (Medium to High) – daily, weekly and month-end

reporting deadlines

 Extended hours as and when required

KNOWLEDGE, SKILLS, AND ABILITIES

COMPETENCIES

 Strong analytical ability

 Data interpretation

 Business understanding

 Financial awareness

 Process improvement

 Innovation mindset

 Systems thinking

 Excellent communication

TECHNICAL SKILLS

 Advanced Excel, Power Query and Power Pivot

 Power BI

 SQL

 Data modelling and data warehousing concepts

 ETL processes

 Microsoft Office and Business Intelligence

platforms

 Sage 300 (advantageous)

 API integrations (advantageous)

 AI tools and automation platforms (e.g. Microsoft

Copilot, Power Automate)

SOFT SKILLS

 Problem Solving

 Planning

 Attention to Detail

 Time Management

 Stakeholder Management

 Project Coordination

 Adaptability

 Continuous Improvement

 Presentation Skills

PERSONAL ATTRIBUTES

 Curious

 Innovative

 Professional

 Ethical

 Team player

 Self-driven

 Deadline-driven

 Customer and stakeholder focused

 Resilient

PERFORMANCE INDICATOR WEIGHTING DUTIES AND RESPONSIBILITIES

Business Intelligence Development

30% Weight

 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

25% Weight

 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

20% Weight

 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 AIenabled

reporting solutions, supporting PEG’s digital

transformation initiatives

 Measured by: manual reporting hours saved, number of

processes automated, and improvement in reporting turnaround

time

Data Quality & Governance

15% Weight

 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

10% Weight

 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

 Office based

Desired Experience & Qualification

Degree in Computer Science, Finance, Data Analytics, Information Systems, Statistics, Busines Intelligence or Commeece (Analytics) (NQF 7)

ESSENTIAL

National Diploma or Degree (NQF 6) in a related field.

Microsoft Power BI certification (advantageous)

3 - 5 years Business intelligence experience

Retail, fuel or QSR experience

Power BI Development, SQL, data & financial modelling

Reporting automation experience.

SEE ABOVE FOR MORE INFORMATION.

Package & Remuneration

Market related.

TBA.