Back to search (Gauteng > Johannesburg > Jobs > IT & Tech Jobs > Find Software & Web Developer Jobs> ad 1347960078)
Unfortunately, another Gumtree user is in the process of purchasing this item. Check back later in case they've changed their mind, or click the button below to browse more Pay & Ship listings.
Junior Data Analyst / Excel Administrator (Contract)
Reason for Reporting
ABOUT THE ROLE
We are looking for a hands-on, detail-oriented individual with strong Excel skills to support day-to-day data analysis and reporting. This is an operational role, ideal for someone who enjoys working with structured datasets, validating information, and producing accurate reports. This role is best suited to a junior-to-intermediate candidate who is confident in Excel and comfortable working with large volumes of data.
KEY RESPONSIBILITIES
· Analyse and validate datasets for accuracy, completeness, and consistency
· Identify discrepancies, trends, and data quality issues
· Match, reconcile, and compare data across multiple Excel files
· Prepare regular and ad-hoc reports using Excel
· Maintain clean, structured, and auditable spreadsheets
· Support internal teams with data analysis and reporting tasks
REQUIRED SKILLS & EXPERIENCE
· 2+ years’ experience in a data, admin, reporting,
· Strong Microsoft Excel skills (essential)
· Experience working with large and detailed datasets
· High attention to detail and strong analytical ability
EXCEL SKILLS (ESSENTIAL)
· VLOOKUP, XLOOKUP, INDEX & MATCH for data matching and reconciliation
· Pivot Tables and Pivot Charts for data analysis and reporting
· IF, nested IF, SUMIF, COUNTIF, AVERAGEIF formulas
· Data cleaning techniques (remove duplicates, text-to-columns, data validation)
· Conditional formatting to highlight errors, exceptions, and trends
· Sorting, filtering, and structuring large datasets
· Creating clear, well-formatted Excel reports for stakeholders
· Basic error checking and audit-style validation within spreadsheets
IDEAL CANDIDATE
· Methodical, organised, and process-driven
· Comfortable with repetitive, detail-focused work
· Able to work independently and meet deadlines
· Good written and verbal communication skills
· Not a senior or management-level candidate
REMUNERATION
Market-related remuneration, aligned to a junior/intermediate contract role and dependent on experience.
Read More
