Junior Data Analyst / Administrator

SUMMARY:
-

POSITION INFO:

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.