Business Intelligence Officer - Western Cape at RCL Foods

Minimum Requirements    

• Advanced Diploma / Diploma/ Degree in Programming / Computer Science/ Information Systems, Mathematics / Statistics.
• 3-5 years sales systems / data analysis experience
• Strong foundation in data manipulation and analysis using SQL
• Familiarity with data visualization tools such as PowerBI or Tableau
• Experience in Retail Portal systems will be advantageous
• Must be based / reside  in the Western Cape

Duties & Responsibilities    

• Business Performance Reporting
• Create, analyse and distribute weekly/ monthly Portal reports to internal and external stakeholders (where applicable)
• Site cover analysis
• Out of tills sales
• Gap analysis

Assist in analysing reports from the Business Intelligence team and report findings/ trends

• Monthly Returns Analysis
• Monthly Sales Analysis
• Risk stock in depots vs short dated stock vs expired stock uplifted from trade
• Stock on hand and Depth of Distribution reports
• Fleet related reports (fuel usage, accidents, fines and driver behaviour)
• Shelf health elements (OSA, stock rotation, shelf position, PI labels etc.)
• Ad hoc reports

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 72-hour timeframe dependent on the type of analysis required

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 BI platforms and/ or Portal access

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

Data Warehousing and Business Intelligence Platforms

• Acquire data from primary or secondary data sources and maintain databases/ data systems
• Interpret the raw data and identify any patterns in which to provide clarity to the non-technical audience.
• Investigate discrepancies that may arise between the different touch points/ systems
• Defining new data collection and analysis processes
• Execute database queries and conduct analyses
• Work cross-functionally to identify ongoing business enablement needs
• Assist in translating business needs to technical specifications
• Assist with the design and implementation of BI Platforms/ Dashboards that will assist in obtaining important business insights
• Evaluate and improve current BI Platforms/ Dashboards
• Maintain rich interactive visualisations 
• Integrating various reporting components from multiple data sources
• Assist with research on new technologies to help project future trends