Reporting & Data Analyst

Optimal Growth Technologies; Gauteng; On-site; ZAR 300,000 - 500,000; Full time

Job summary

A leading technology company is seeking a proactive Reporting & Data Analyst for a 12-month contract in Bryanston. The role focuses on supporting various departments by generating reports, consolidating data, and transforming insights into actionable business strategies. Ideal candidates will have extensive experience in Excel and Power BI, combined with strong analytical and communication skills.

Qualifications

• 3+ years' experience in data analyst or reporting analyst role.
• Strong skills in Microsoft Excel and Power BI.
• Basic SQL skills and understanding of data structures.

Responsibilities

• Engage with stakeholders to gather reporting needs.
• Create dashboards using internal systems and external vendors.
• Analyze data to identify trends and generate insights.

Skills

Microsoft Excel

Power BI

Data Analysis

Problem-Solving

Communication

Job description

Role title: Specialist - Reporting & Data Analyst

Location: Bryanston

Duration: 12 month contract

Role purpose:

• We are looking for a proactive and business-oriented Reporting & Data Analyst to support the reporting needs of various departments across the organisation.
• This role bridges the gap between business users and our internal systems by gathering reporting requirements, generating reports from multiple platforms, and consolidating data using tools like Excel and Power BI to deliver actionable insights.

Key accountabilities

• Requirement Gathering: Engage with business stakeholders to understand and document reporting needs.
• Report Development: Create dashboards and reports directly using internal systems or coordinate with external system vendors to fulfil reporting needs.
• Data Integration: Where reports require data from multiple sources (e.g., spreadsheets, system exports, APIs), consolidate and transform this data using Microsoft Excel, Power Query, or Power BI.
• Insight Generation: Analyse data to identify trends, anomalies, and opportunities for improvement; translate findings into clear business insights.
• Stakeholder Engagement: Provide ongoing support and training to end-users to ensure understanding and adoption of reporting tools.
• Data Quality & Governance: Ensure accuracy, consistency, and integrity of data used in reports and dashboards.

Core competencies, knowledge and experience

• 3+ years' experience in a data analyst, reporting analyst, or business intelligence role
• Strong skills in Microsoft Excel (formulas, pivot tables, Power Query)
• Proficiency in Power BI for report building and data visualisation
• Experience working with cross-functional teams and engaging non-technical stakeholders
• Familiarity with working with system vendors to coordinate report development (desirable)
• Strong problem-solving skills and attention to detail
• Excellent written and verbal communication skills

Must have technical/professional qualifications:

• Proficiency in Microsoft Excel (including Power Query)
• Proficiency in Power BI
• Basic SQL skills or understanding of data structures
• Experience working with data exports from ERP, CRM, or remote monitoring systems
• Experience working with or coordinating third-party vendors on report delivery

\