Junior Data Analyst

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

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.