Junior Excel Data Specialist

apartmentMarvel Placement Consultants placeJohannesburg calendar_month 

Minimum Requirements:

  • A diploma or degree in Data Analytics, Business Administration, Finance, or a related field is preferred but not essentialpractical skills and a strong work ethic are highly valued.
  • Previous experience (minimum 2 years) in a data-centric, reporting, or Excel-intensive role, ideally within logistics, operations, or finance, will be advantageous.
  • Knowledge in Microsoft Navision or a similar ERP system.
  • Proven proficiency in Microsoft Excel, including advanced functions such as
  • PivotTables,
  • VLOOKUP
  • SUMIFS
  • INDEX-MATCH, and data validation techniques.

Roles and Responsibilities:

  • Consolidate and capture operational data from departments such as Transport, Wages, and Customer Portals into structured Excel reports.
  • Cleanse, validate, and maintain large datasets to ensure reporting accuracy and consistency across systems.
  • Develop and maintain dynamic, error-free Excel reports using advanced functions such as PivotTables, VLOOKUP, SUMIFS, INDEX-MATCH, and conditional formatting.
  • Extract and analyse data from Microsoft Dynamics Navision, integrating it seamlessly into reporting models.
  • Collaborate with internal stakeholders to identify, collect, and rectify missing or inconsistent data, supporting improved data quality practices.
  • Assist in the creation of performance dashboards and visual reporting tools, where applicable, to support operational insights and decision-making.
  • Ensure reports are delivered accurately and on time, maintaining high standards under pressure and tight deadlines.
Closing Date:

Submissions for this vacancy will close on 14 April 2025, however you will still have the opportunity to submit your CV for this position till 06 May 2025.

Please Note:
Thank you for submitting your CV to Marvel Placement Consultants. We value your submission, and we try our utmost best to get back to each applicant. However, should your application be successful, we will be in contact with you. Should you not hear from us within two weeks of application, please consider your application as unsuccessful.

We are however recruitment specialists and will keep your details on our database for possible future opportunities.

PoPI Act:

Please note that Marvel Placement Consultants adhere to the POPI Act (Act No. 4 of 2013: Protection of Personal Information Act, 2013). Section 9 of PoPI states that "Personal Information may only be processed if, given the purpose for which it is processed, it is adequate, relevant and not excessive".

local_fire_departmentUrgent

2 x Junior Technicians

apartmentCompany People Motor Industry Recruitment SpecialistsplaceJohannesburg
2 x Junior Technicians - Qualified or not qualified for a car hire company R12000.00 / Kempton Park Our client is looking for 2 junior tecchnicians, they don't have to be qualified as long as they have workshop experience....
apartmentProfessional Career ServicesplaceJohannesburg
Employer Description Our clients with Game reserves in multiple provinces across South Africa are seeking Junior to Senior Level Field Guides/Game Rangers to join their teams! Job Description You will be responsible for:  •  Hosting and guiding...
check_circleNew offer

Junior Draughtsman

apartmentHominum Management SolutionsplaceJohannesburg
Job Vacancy: Junior Draughtsman - Fusion Are you a talented and motivated Junior Draughtsman with 2 to 3 years of experience in engineering? Do you possess strong skills in CAD and have experience in 2D and 3D drafting? If so, we have an exciting...