Data Analyst/Sales Coordinator – PlatteKloof, Cape Town
START IMMEDIATELY! (+/- 6 MONTH CONTRACT)
Our client, a Global FMCG concern is currently in search of an innovative, well-organized and meticulous Data Analyst/Sales Co-ordinator Intern to join their Sales Team.
Main Purpose of the Role:
You willsupport the sales function and the organisation in making data driven decisions. The Data Analyst will be responsible for retrieving, compiling and analysing sales and market data, as well as, providing valuable feedback and actionable insights to guide the organisations promotional and sales activities.
Key Duties and Responsibilities:
- Responsible for the compiling and updating of the company sales / KPI dashboard including the gathering of data from retailers, portals, data suppliers and Partners.
- Collect, analyse, evaluate and report on sales data for the organisation on an adhoc, monthly, quarterly, and annual basis to identify sales patterns and areas of opportunity.
- Regularly prepare reports and presentations for the Sales Team which include market performance, Partner, Customer and Consumer data, as well as, competitor research data all with the aim of driving volume, improving weighted / numeric distribution, reducing out-of-stocks and closing gaps.
- Calculating promotional & trade spend return-on-investment (ROI).
- Support the administrative requests and flow of detail between Bel and its Partners in the Region while fostering collaboration internally within the BU
- Compile and distribute sales and review meeting minutes for the Region
- Own the in-market sales component and compile the information as provided from the Partners manipulating it to support forecasting, order generation and stock expiry risk
- Logging and tracking of the GTN transactions as the invoices / billings are provided and, or, call for these from Partners against activities
- Formulate and consolidate store related information for distribution and feedback against in-store activities, trials, incentives or drives
- NPD volume and distribution tracking and the surrounding related communication flow as required
- Supporting with the administration processes and task related to the effective, efficient and professional management of our ESSA Partners
- Retrieve and manage information, as well as, the compilation, flow, distribution and tracking of the below mentioned reports, from our Partners in ESSA, on a monthly / weekly basis:
- Service Levels / Order Fill-rate
- Returns
- Out-of-stocks
- Promotional activity
- In-market price survey’s
- Weighted and Numeric Distribution data
Qualification and Experience Required:
- Minimum 3-year Bachelor’s Degree in Business Science/Information Systems/Data Science degree, majoring in Statistics
- 1 year of Data Analytics/ Sales Coordination experience in FMCG, Food Industry preferred
- Must be able to work under pressure
- The ability to work independently and within a Team environment.
- Strong MS Excel skills (incl. using pivot tables) are essential!
- Excellent Computer literacy, including data handling software.
- Report-writing skills.
