Business Intelligence Analyst Midrand

Job Overview

The role is responsible for analysing and interpreting data related to the organization's performance in order to inform strategic decision-making.

The incumbent will work collaboratively with the Sales Director and other business stakeholders to ensure that there are effective sales reports as and when required.

Duties & Responsibilities

1. Annually assist the Sales Director and the Sales Managers (Incl. medical devices) to create product-based sales targets for the sales team for the following year.
2. Quarterly adjustments as per Financial Forecast results.
3. In collaboration with Sales Director and Sales Managers (Incl. medical devices) maintain customer (territory) and product portfolio mapping by sales representative.
4. Convert data received from Wholesalers monthly and send to Global SAP BI team to maintain the Wholesaler Cube.
5. Update mapping for the WS and Sales Cube as and when necessary, e.g. new customers, new products, attribute 3 changes.
6. Calculate sales team incentives Monthly / Quarterly / Annually.
7. Continuous improvement of the various worksheets – Territory / Product / Rep / Region mapping tables.
8. Provide the sales team with weekly updates – Sales vs Target YTD / MTD and 12-month unit sales trend.
9. Assist the Sales Director / Sales Managers (Incl. medical devices) with adhoc reporting requests from time to time, e.g. Cycle Meetings and Sales Conference, Forecasting meetings.
10. Collaborate with Sales Director / medical Devices BUM to build a monthly sale report.
11. Continuous improvement of various reports e.g. formats, content.
12. Compile Waste Management reports for participating customers.
13. Back up for Market Intelligence manager in budgeting, forecasting and MTS processes.

Desired Experience & Qualification

REQUIRED EDUCATION

Tertiary Education: Bachelor's degree in business, Finance, or a related field.

SKILLS AND EXPERIENCE REQUIRED

1. Strong proficiency in BI tools such as Power BI, or similar platforms.
2. Advanced Excel and PowerPoint skills.
3. Experience in preparing and analysing sales force data (CRM), evaluating performance against targets.
4. Solid understanding of financial systems and reporting processes.
5. Ability to communicate complex data insights in a clear and concise manner.
6. Detail-oriented with a strong analytical mindset.
7. Collaborative team player with good interpersonal skills.
8. Familiarity with relevant databases and data extraction techniques.

Package & Remuneration

TBA