Enable job alerts via email!

Junior Data Analyst

RMG Recruitment (Pty) Ltd

Gqeberha

On-site

ZAR 200,000 - 300,000

Full time

Today
Be an early applicant

Job summary

A data recruitment agency is seeking a Junior Data Analyst in Port Elizabeth. The role requires proficiency in advanced Excel for cleaning, transforming, and visualizing data. Candidates should be skilled in pivot tables, VLOOKUP, and data validation. This position is ideal for those looking to start their data analysis career.

Qualifications

  • Experience with Excel functionalities required for data analysis.
  • Ability to clean and transform data for analytical purposes.

Responsibilities

  • Clean and transform data for analysis.
  • Analyze and visualize data using advanced Excel skills.

Skills

Pivot Tables
VLOOKUP
SUMIF
INDEX MATCH
Conditional Formatting
Data Validation
Charts and Graphs
Job description
Junior Data Analyst required in Port Elizabeth.

We are seeking a Junior Data Analyst to clean, transform, analyse, and visualize data—often involving advanced tasks like pivot tables, data formatting, and quotation using Excel functionalities.

Key Advanced Excel Skills:

  • Pivot Tables: Summarizing and analyzing data efficiently.
  • VLOOKUP and HLOOKUP: Looking up data from one table to another.
  • SUMIF and AVERAGEIF: Performing conditional calculations on data.
  • INDEX MATCH: Performing more complex lookups than VLOOKUP.
  • Conditional Formatting: Highlighting data based on specific criteria.
  • Data Validation: Ensuring data integrity and accuracy.
  • Charts and Graphs: Visualizing data to identify trends and insights.
Get your free, confidential resume review.
or drag and drop a PDF, DOC, DOCX, ODT, or PAGES file up to 5MB.