Junior Reporting Analyst

AtripleA recruitment & temps; Pretoria; On-site; ZAR 180,000 - 260,000; Full time

Job summary

AtripleA recruitment & temps in Pretoria seeks a Junior Reporting Analyst to support data collection, analysis and presentation of operational data. You will develop Power BI dashboards, improve Excel reporting and create executive presentations.

The role focuses on automating reports, analyzing KPI and service delivery data, and delivering timely packs to management. Strong Excel, Power BI and communication skills are essential.

Qualifications

• Matric (Grade 12) is essential.
• Diploma or Degree in Data Analytics, BI, IS, CS, Statistics, Industrial Engineering or Business Management preferred.
• 1-3 years' experience with Power BI and Microsoft Excel.
• Experience building dashboards and analysing business data.

Responsibilities

• Develop and maintain Power BI dashboards.
• Create automated Excel reports and dashboards.
• Analyse operational, financial and service delivery data.
• Identify trends, risks and opportunities.
• Produce weekly, monthly and executive reports.
• Build interactive Power BI dashboards using Power Query and DAX.
• Create professional PowerPoint presentations.
• Support reporting using SharePoint, Teams, Forms, Outlook and OneDrive.
• Assist with KPI, SLA and productivity reporting.
• Prepare meeting packs, reports and minutes.
• Identify opportunities to automate manual reporting processes.

Skills

Analytical thinking

Attention to detail

Problem-solving

Communication skills

Professional presentation skills

Time management

Self-motivated

Organized

Presentation skills

Education

Matric (Grade 12)

Diploma or Degree in Data Analytics, BI, IS, CS, Statistics, Industrial Eng or Business Management

Tools

Power BI

Microsoft Excel

Microsoft PowerPoint

Microsoft 365 (SharePoint, Teams, Outlook, Word, OneDrive)

SQL

Power Automate

Job description

Junior Reporting Analyst

Location: Pretoria

Purpose of the role

Support the Service Delivery Manager by collecting, analysing and presenting operational data through dashboards, reports and presentations. Develop Power BI dashboards, improve excel reporting, create executive presentations and provide data-driven insights.

Key Responsibilities

• Develop and maintain Power BI dashboards.
• Create automated Excel reports and dashboards.
• Analyse operational, financial and service delivery data.
• Identify trends, risks and opportunities.
• Produce weekly, monthly and executive reports.
• Build interactive Power BI dashboards using Power Query and DAX.
• Create professional PowerPoint presentations.
• Support reporting using SharePoint, Teams, Forms, Outlook, Word and OneDrive.
• Assist with KPI, SLA and productivity reporting.
• Prepare meeting packs, reports and minutes.
• Identify opportunities to automate manual reporting processes.

Qualifications & Experience

• Matric (Grade 12) - essential.
• Diploma or Degree in Data Analytics, Business Intelligence, Information Systems, Computer Science, Statistics, Industrial Engineering or Business Management.
• 1-3 years' experience with Power BI and Microsoft Excel.
• Experience building dashboards and analysing business data.

Technical Skills

• Advanced Microsoft Excel (Pivot Tables, Power Query, Power Pivot, XLOOKUP, INDEX/MATCH, Dynamic Arrays, Charts).
• Power BI (Dashboards, DAX, Power Query).
• Microsoft PowerPoint.
• Microsoft 365 (SharePoint, Teams, Outlook, Word, OneDrive).
• SQL (preferred).
• Power Automate (advantageous).

Soft Skills

• Analytical thinking
• Attention to detail
• Problem-solving
• Communication skills
• Professional presentation skills
• Time management
• Self-motivated
• Organized
• Presentation skills

Key Performance Indicators (KPIs')

• Report accuracy above 98%
• On-time report delivery
• Dashboard adoption by management.
• Reduction in manual reporting time.
• Improved data quality
• Process automation initiatives