Business Intelligence And Sales Analyst Tba

Isource-Comm; Gauteng; On-site; ZAR 30 000 - 70 000; Full time

Job summary

An established industry player is seeking a data analyst to drive strategic decision-making through insightful data analysis. This role involves collaborating with the Sales Director and stakeholders to create effective sales reports and manage sales targets. The ideal candidate will leverage strong proficiency in BI tools and advanced Excel skills to interpret data and communicate insights clearly. If you are detail-oriented with a strong analytical mindset and enjoy working in a collaborative environment, this opportunity is perfect for you.

Qualifications

• Bachelor's degree in Business, Finance, or related field required.
• Strong proficiency in BI tools and advanced Excel skills.

Responsibilities

• Assist Sales Director in creating product-based sales targets annually.
• Calculate sales team incentives and provide weekly updates on sales vs targets.

Skills

Power BI

Advanced Excel

Sales Force Data Analysis

Financial Reporting

Data Communication

Analytical Mindset

Interpersonal Skills

Data Extraction Techniques

Education

Bachelor's degree in Business

Bachelor's degree in Finance

Tools

Power BI

Excel

PowerPoint

Job description

Job Description

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 (including medical devices) to create product-based sales targets for the sales team for the following year.
2. Make quarterly adjustments as per Financial Forecast results.
3. In collaboration with the Sales Director and Sales Managers (including medical devices), maintain customer (territory) and product portfolio mapping by sales representative.
4. Convert data received from Wholesalers monthly and send to the Global SAP BI team to maintain the Wholesaler Cube.
5. Update mapping for the WS and Sales Cube as necessary, e.g., new customers, new products, attribute changes.
6. Calculate sales team incentives monthly, quarterly, and annually.
7. Continuously improve 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 (including medical devices) with ad hoc reporting requests, e.g., cycle meetings and sales conferences, forecasting meetings.
10. Collaborate with the Sales Director / Medical Devices BUM to build a monthly sales report.
11. Continuously improve various reports, e.g., formats and content.
12. Prepare Waste Management reports for participating customers.
13. Back up the Market Intelligence manager in budgeting, forecasting, and MTS processes.

Desired Experience & Qualifications

Required Education: Bachelor's degree in Business, Finance, or a related field.

Skills and Experience:

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

Package & Remuneration

TBA