Business Intelligence Officer: Data Science at RCL Foods

Closing Date:2020/08/26
Reference Number:RCL200812-1

Job Description    

• At RCL FOODS we see & do things differently, we think bigger, work smarter and as a team collectively work towards achieving our ambition; more food to more people, more often!”
• An exciting opportunity exists for a Junior Data Analyst to join our Logistics Division at our Cape Peninsula site.
• The successful incumbent will be responsible for assisting and providing support in the ongoing advancement of a suite of business reporting that will provide insight, stimulate further discussion and assist in decision making. We are looking for someone who has a passion for systems and working with large data sets; a team player who wants to be part of fast paced and results driven team.

Minimum Requirements    

• B.Com Degree and/or a ND in Sales Management
• 3-5 years sales systems / analysis experience
• Experience in BI reporting platforms will be advantageous
• Programming skills in Python, R or similar language will be advantageous
• Experience in Retail Portal systems will be advantageous

Duties & Responsibilities    
1. Sales and Returns Performance Reporting

• Ensure data is accurately and regularly captured onto the relevant information systems to facilitate access to reliable data and reporting for trend analysis and decision making
• Manage the daily and weekly update of the sales system
• Manage the re-run process regularly to ensure that the system is up to date
• Run and distribute sales performance information cubes
• Update and distribute daily/ weekly sales tracker reports
• Create, analyse and distribute monthly returns reports to Principals and internal recipients
• Share with and report relevant data and information to Management teams to enable reliable business decision-making
• Assist Management in compiling Principal cycle presentations and reviews
• Compile Principal and Buyer Business reviews for use by Management
• Ensure that ad hoc requests are adhered to within a 48-hour timeframe

2. Principal Back-End Budgeting

• Calculate and maintain Principal targets by Principal/ Region/ Store/ SKU
• Ensure target files are accurately uploaded to internal reporting systems
• Liaise with IT and external consultants to resolve discrepancies

3. Risk Control

• Ensure strict confidentiality at all times
• Ensure data security when sending data files to recipients
• Assist with managing users and user roles related to server and/ or team site access
• Assist with maintaining SAP purchase order release tables and submitting workflows to amend authorisations when needed

4. New Business Support/ Business Change Initiatives

• Provide support for the development of the preliminary business case to support investment
• Report and provide recommendations regarding new business and/ or change initiatives
• Drive reporting and post implementation reviews to the business

5. Master Data Management: Customers and Material

• Market Segments: Assist Master Data team in maintaining market segments in SAP by sense-checking information and enforcing process when a market segment query occurs
• Customer Master Data: Ensure all customers ranked in terms of ABCD volume and that relevant customers are allocated to call cycles. Maintain merchandising attributes and ensure updates are uploaded timeously to the SAP system.
• Material Master Data: Maintain merchandising attributes and ensure updates are uploaded timeously to the SAP system.
• Maintain updated Store Universe information for use by Management
• Investigate discrepancies that may arise between the different touch points
• Partnering with IT and other internal groups to address data quality, master data management as well as data governance

6. Master Data Management: Sales Force Hierarchy

• Update and maintain call cycle data for upload to the CRM system
• Maintain CRM system including data cleansing, record maintenance, and data linkages to other source systems
• Ensure timely and accurate data correlation between CRM and other internal systems
• Work cross-functionally to identify ongoing business enablement needs
• Investigate discrepancies that may arise between the different touch points
• Reporting on staff and stores not allocated to call cycles
• Call cycle frequency and duration reports
• Pack out rate calculation and reporting on deviations
• Conducting call cycle workshops if/ when needed by the business
• Support salesforce initiatives by Management

7. Information and Data Management

• Work with Management to prioritise business and information needs
• Data cleansing and processing large amounts of raw data
• Data mining using available tools, such as Pivot Tables
• Solving business problems by mapping and tracing data
• Generating reports from single or multiple systems
• Assist with evaluating of internal systems for efficiencies, problems and inaccuracies
• Supporting initiatives for data integrity and normalisation
• Training end users on new reports and dashboards

8. Administration

• Oversee filing and safeguarding of records within area of responsibility.
• Compile ad hoc spreadsheets when required.
• Ensure that data captured on management systems is backed up.

9. Team Coordination