Junior Data & Systems Analyst — Dashboards + Automation

People Dimension; Centurion; On-site; ZAR 223,000 - 335,000; Full time

Job summary

People Dimension is seeking a data analytics professional to report, analyse, and interpret datasets to support strategic decision-making and operational efficiency across the organisation. You will maintain data quality, build Power BI and Excel reports, and communicate insights to management.

The role requires 3–5 years in analytics, strong SQL, Power BI, Excel (pivot, VLOOKUP), and attention to detail. Salary between ZAR 20,000 and ZAR 30,000 per month, depending on qualification and

Qualifications

• 3-5 years’ experience in a data analytics or reporting role
• Advanced proficiency in SQL, Power BI, and strong proficiency in Microsoft Excel (pivot tables, VLOOKUP) and Word
• Experience in data cleaning, validation, analysis, and visualization
• Ability to translate complex data into actionable insights
• Strong communication and interpersonal skills
• High attention to detail, accuracy, and problem-solving ability
• Ability to manage multiple priorities under tight deadlines
• Commitment to data integrity and confidentiality
• Self-motivated and collaborative team player
• Willingness to work overtime when required

Responsibilities

• Clean, validate, and organize datasets
• Identify trends and anomalies
• Document data transformation processes
• Reconcile data across systems
• Implement data quality improvements
• Ensure regular updates and backups
• Identify business risks and opportunities through data
• Recommend system/process enhancements
• Automate reporting workflows
• Standardize data sets and reporting formats
• Contribute to BI and analytics strategy
• Draft system specifications for new developments
• Support testing and deployment cycles
• Maintain training materials
• Verify product migrations and enhancements
• Update system documentation
• Collaborate with IT and development teams
• Ensure reporting logic accuracy
• Prepare monthly performance dashboards
• Design Power BI and Excel reports
• Communicate insights to management
• Maintain project tracking tools
• Define reporting requirements with stakeholders

Skills

Data analysis

Attention to detail

Communication skills

Team collaboration

Multitasking

Tools

SQL

Power BI

Excel

Word

Job description

People Dimension is seeking a data analytics professional to report, analyse, and interpret datasets to support strategic decision-making and operational efficiency across the organisation. You will maintain data quality, build Power BI and Excel reports, and communicate insights to management.

The role requires 3–5 years in analytics, strong SQL, Power BI, Excel (pivot, VLOOKUP), and attention to detail. Salary between ZAR 20,000 and ZAR 30,000 per month, depending on qualification and