Advanced Excel Specialist for a Leading Mining Company
LOCATION: Kempton Park
SALARY AND BENEFITS: R20000 – R25 000 CTC p/m
DESCRIPTION / SYNOPSIS:
Our Client is a leading Company in the Mining sector, and is seeking an experienced Sales Analyst to join their Sales team based in Kempton Park. As a Sales Analyst, you will play a crucial role in optimizing the sales process. Reporting to the Sales Director, you will utilize your advanced Excel skills (Vlookups, Pivot Tables, Charts, IF formulas) to streamline sales reporting, track performance metrics, and enhance overall efficiency. This position is ideal for someone with a keen eye for detail, excellent problem-solving skills, and experience in the mining, steel, or equipment industries.
MINIMUM REQUIREMENTS:
Diploma, degree or relevant post-matric qualification
Advanced Excel skills essential (Vlookups, Pivot Tables, Charts, IF formulas)
Proficiency in ERP systems beneficial
Strong sales administration experience
Experience in the mining, steel, or equipment industries is highly desirable
High attention to detail and accuracy
Excellent problem-solving skills
Strong communication and active listening skills
Ability to multi-task and work in a fast-paced environment
Empathy, trust, and relationship-building skills
Strong interpersonal skills and team player
Exceptional time-management and organizational skills
RESPONSIBILITIES:
Generate and manage general sales reports as required
Perform general sales administration tasks
Create and manage quotes on ERP systems and Excel
Collaborate with Directors on special pricing
Oversee and manage customer activities on online systems
Manage customer portfolio and target trackers for sales representatives
Track monthly sales targets and incentives
Maintain a tracker for new business opportunities
Generate open orders and backorder reports
Compile lost sales reports
Monitor team progress, identify shortcomings, and propose improvements
Prepare monthly stock valuation reports
Manage obsolete stock reports and incentives for selling obsolete stock
Oversee customer portals and emails related to RFQs, tenders, and purchase orders
Update daily sales vs. targets for the Sales Director
Prepare overall group sales reports for monthly sales management meetings
Prepare individual sales by rep reports for monthly POD target overview
Handle other high-level reporting as needed
Create quotations and follow up on expediting steel stock orders and opportunities for the Sales Director.
SOFT SKILLS/ADDITIONAL INFO:
Ability to work independently and as part of a team
Strong analytical and critical thinking skills
High level of professionalism and dedication to customer satisfaction
Ability to adapt to changing priorities and handle multiple tasks simultaneously
Do you see yourself as the successful Sales Analyst at this leading Company? Apply Now. Don't delay.
Should you meet the above minimum requirements, please submit your CV and a copy of your ID and Qualifications to ******. Please quote the TITLE of this vacancy in the subject line of your email as a reference. Our consultants will assess your suitability for the vacancy. Should you not receive a response within 2 weeks please consider your application unsuccessful.
#J-18808-Ljbffr
