Junior Data Analyst

RMG Recruitment (Pty) Ltd; Gqeberha; On-site; ZAR 200 000 - 300 000; Full time

Job summary

A leading company is looking for a Junior Data Analyst in Port Elizabeth. The role involves cleaning, transforming, analyzing, and visualizing data, with a strong emphasis on Excel skills. Ideal candidates will be proficient in creating pivot tables, using VLOOKUP, and generating reports to support data-driven decisions.

Qualifications

• Experience with data cleaning and transformation.
• Proficiency in creating pivot tables and reports.

Responsibilities

• Clean, transform, analyze, and visualize data.
• Generate reports using Excel functionalities.

Skills

Excel

Data Analysis

Data Visualization

Job description

Junior Data Analyst required in Port Elizabeth.

We are seeking a Junior Data Analyst to clean, transform, analyze, and visualize data. The role involves tasks such as creating pivot tables, formatting data, and generating reports using Excel functionalities.

Key Excel Skills Required:

• Creating and analyzing Pivot Tables
• Using VLOOKUP and HLOOKUP for data lookup
• Applying SUMIF and AVERAGEIF for conditional calculations
• Performing complex lookups with INDEX MATCH
• Using Conditional Formatting to highlight data
• Implementing Data Validation to ensure data accuracy
• Creating Charts and Graphs for data visualization