Integration and Training Specialist at RCL Foods

Job Description    
RCL FOODS is on the hunt for an analytical individual who is brilliant at the basics, to join our Foods Division as an Integration and Training Specialist to support the RWS Customer Teams. This role is based in Westville and reports to the Insights Integration Manager.

The purpose of the role is to assist in projects and initiatives that deliver advanced capabilities, techniques, tools and infrastructure that automate and simplify the extraction of meaningful insights from the various big data sources at our disposal (internal and external) for use by the customer teams.

• Ensure advancement of reporting tools available to continually improve the information needs of the customer teams for them to do their jobs effectively & efficiently.
• To assist in providing or developing Business Intelligence tools that drive effective strategy formulation for the customer teams and delivers the capabilities to track/quantify the impact of implementation.
• To collaborate with IT; Customer Teams; Logistics and Commercial teams to innovate and implement technological advancements to deliver these objectives.
• To provide training & support to Customer front end teams on all platforms/tools/reports that have been developed to simplify the extraction of meaningful insights from the various big data sources at our disposal.
• Gathering of trends, data & utilising other resources available to support the Customer teams in mining the data and delivering actionable Insights.

Minimum Requirements    

• Matric with Maths.
• B.Com qualification in Finance/Economics/Statistics.
• 2 years' experience in a Data role such as Market Research or Analyst function.
• Must have Advanced experience in Power BI and Excel and must be computer literate.

Duties & Responsibilities    

• Document and develop understanding of all existing systems, tools, and reports (internal or provided by external service providers) used by RCL FOODS to derive actionable insights from the data.
• Develop infrastructure and capabilities to assist Customer front end by automating and simplifying the extraction and analysis of data that provides insights including but are not limited to penetration levels; rate of sale levels; promotional sell out success; market share information and trends; in store ‘brilliant basics’ compliance; etc.
• Implement and simplify appropriate business processes to increase organisational effectiveness and efficiency.
• Engage with multiple stakeholders and provide training & support on the tools and infrastructure which can extract actionable data insights.
• Be the custodian of all data sources and if necessary, the liaison with external data/analysis providers to RCL FOODS.
• Drive efficient working relationship with the other customer Teams namely, Trade, Customer Outlet Operations, Channel teams and Marketing to ensure an effective foundation of data for their strategy formulation.
• Where necessary and in conjunction with IT, Sales Team representatives and Commercial, engage with external consultants/service providers in order to understand, evaluate and potentially trial available tools/resources in the market which will advance the Business Intelligence and Insights ambitions referred to above;
• Provide Platforms/Tools/Reports that automate and enhance the capabilities of the Customer team as part of their Customer Insights and Portfolio Analysis reporting.
• Provide tools that enhance existing profitability analysis to include a view on trade margins and trends as well as market share and category performance.
• Test and reconcile the various data sources, mapping, and hierarchies to deliver accurate and consistent information and insights.
• Build infrastructure that allows the advancement of business SIA’s including: The optimisation of promotional sell out. Ad hoc spend commercial analysis. Price accuracy and compliance.

Info Gathering, Analysis, Research & Insights (Customer & Consumer):

• Utilise internal and external data sources, to build robust actionable insights. Using both quantitative and qualitative processes and leading analytics development.
• Build a research library/hub through potential cloud solution (across retail and food partners) to allow accessibility to multi stakeholders.
• Understand what relevant research/data sources exist across the business units that can be used to develop the category strategies & new business opportunities.
• Recommendation for new sources of information – either through informational portal service providers or purchase white papers.
• Identify gaps in data/research and develop plans to close the gaps. Build justifications to secure business unit support & budget where necessary.
• Analyse & interpret key data to derive actionable insights

Location: Westville

Closing Date: 10th, March 2022