Business Intelligence Officer

Vector Logistics Limited; Midrand; On-site; ZAR 400 000 - 500 000; Full time

Job summary

A logistics company is seeking a Business Intelligence Officer to enhance reporting systems and provide data-driven insights. The ideal candidate will have 3-5 years of sales systems experience and a National Diploma in Sales Management. Responsibilities include managing data accuracy and providing analytical support for management decision-making. This role requires strong attention to detail and the ability to work under pressure. Join a dynamic team that values innovation and integrity.

Qualifications

• 3-5 years sales systems or analysis experience required.
• Strong understanding of data management and reporting.
• Ability to work under pressure and meet deadlines.

Responsibilities

• Support the advancement of business reporting systems.
• Ensure accurate data capture for decision making.
• Manage sales system updates and reports.

Skills

Sales systems analysis

Data analysis

Attention to detail

Education

National Diploma in Sales Management

Matric

Job description

Business Intelligence Officer

Overview

We are a Supply Chain and Sales & Merchandising partner adding value to your business through a fully integrated, temperature-controlled network in Southern Africa.

But we are also more than that. We are people serving people. While we boast the best in tech and infrastructure, our people are our greatest resource. With our skilled, curious, can-do people at the forefront, our assets become your assets, our service your solutions.

Vector’s vehicle fleet includes a food industry first in ‘multi-temperature’ vehicles enabling the company to service business across frozen, chilled and ambient temperature zones on a single delivery.

Job Purpose

To assist and provide support in the ongoing advancement of a suite of business reporting that will provide insight, stimulate further discussion and assist in decision making.

Key Responsibilities

• Sales and Returns PerformanceReporting

• 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, analyze 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.
• Ensure that ad hoc requests are adhered to within agreed SLA.
• Compile Depth of Distribution reports within agreed SLAs.

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.

Risk Control

• Ensure strict confidentiality at all times.
• Ensure data security when sending data files to recipients.
• Assist with managing Security Groups/users and user roles related to server and/ or PBI Workspace and/ or team site access.
• Assist external stakeholders with onboarding to PBI Workspaces – navigation and training.

New Business Support/ BusinessChange Initiatives

• Provide support and testing for the development of the preliminary business case to support investment.
• Report and provide recommendations regarding new business and/ or change initiatives ensuring current reporting continuously aligns to the business needs and requirements.
• Drive reporting to the business.

Master Data Management: Customersand 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.
• Master Data Management: Sales ForceHierarchy.
• Update and maintain call cycle data for upload to the Salesforce system.
• Maintain Salesforce system with call cycle integrity including data cleansing, record maintenance, and data linkages to other source systems.
• Work cross-functionally to identify ongoing business enablement needs.
• Investigate discrepancies that may arise between the different touch points.
• Update of HR Org Data on a monthly basis to ensure Master Data accuracy.
• Ensure Customer Hierarchies is updated monthly.
• Reporting on staff and stores not allocated to call cycles.
• Reporting on Redundant Positions/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.

Month End Reporting

• Update/refresh and distribute client rebates to internal and external stakeholders.
• Update/refresh month end Service Level reports and Returns Reports and distribute to Principals and Internal Sales Teams.
• Monthly refresh and distribution of the principal excel files.

Information and Data Management

• Work with Management to prioritize 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 normalization.
• Training end users on new reports and dashboards.

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.

Team Coordination

• Take ownership and accountability for tasks and activities and demonstrate effective self-management in terms of planning, prioritizing and self-development.
• Follow through to ensure that quality and productivity standards of work are consistently and accurately maintained.
• Inform relevant parties in the event of tasks or deadlines not met, the potential risks thereof and provide appropriate resolution.
• Support and drive the business core values.
• Manage colleagues and clients’ expectations and communicate appropriately.
• Demonstrate willingness to help others and “go the extra mile” to meet team targets and objectives.
• Champion training and development of self and others through utilizing available training opportunities or contributing to the development of new training solutions in collaboration with national training specialists.
• Participate in and drive regular performance appraisals and ensure that own targets and goals are clear and achievable.
• Update/refresh and distribute Shoprite rebates to internal and external stakeholders
• Update/refresh month end Service Level reports and Returns Reports and distribute to Principals and Internal Sales Teams.
• Monthly refresh and distribution of the principal excel files.
• Maintain a basic appreciation and awareness of employee relations climate and ensure corrective action is taken where required in line with relevant legislation and company policy.

Key Relationships

Internal

• Senior Management teams across Vector Trade Marketing.
• Vector Master Data Department.
• Vector IT Department.
• Regional Sales Managers.
• District Sales and Merchandising Managers.
• District Sales and Merchandising Agents.

External

• External Service Providers.
• Principals.
• Decision Making.

Qualifications, Skills and Experience Required for the Job

Qualifications and Experience

• 3-5 years sales systems / analysis experience.
• Matric.
• A National Diploma in Sales Management preferably studying towards a BCom.

Skills and Competencies

Behavior Standards

• Be brilliant at the basics.
• Face the brutal facts.
• Smash the silos.
• Lead with integrity, respect and energy.
• Be curious and challenge change.
• Take accountability for results and people.

Attributes

• Initiative and assertive.
• Tolerant of stress and pressure.
• Creative.
• Proactive.
• Attention to detail.
• Deadline driven.
• Able to interact at all levels of the organization.
• Able to plan ahead and manage time.
• Able to prioritize.
• Able to create a positive team environment.

Vector Logistics supports the principles of Employment Equity and is committed to building a diverse and inclusive workplace. Preference will be given to candidates from designated groups in line with our Employment Equity Plan. If you have not heard from us within 3 to 4 weeks after submitting your application, please consider your application unsuccessful on this occasion. We truly appreciate your interest in joining the Vector team and encourage you to stay connected for future opportunities that may align with your skills and career journey.

We look forward to hearing from you!