Business Intelligence And Sales Analyst Tba

Isource-Comm; Gauteng; On-site; ZAR 300,000 - 450,000; Full time

Job summary

A leading company in Gauteng seeks a Data Analyst to analyze and interpret performance data to drive strategic decisions. Responsibilities include creating sales targets, reporting performance metrics, and utilizing BI tools to inform sales strategies. Ideal candidates will possess strong analytical skills and a Bachelor's degree in business or finance.

Qualifications

• Bachelor's degree in business, finance, or related field required.
• Strong analytical mindset and attention to detail.
• Experience with Power BI or similar platforms essential.

Responsibilities

• Assist Sales Director in creating annual sales targets.
• Provide weekly updates on sales vs. targets.
• Collaborate with teams for ad hoc reporting and analysis.

Skills

Strong proficiency in BI tools

Advanced Excel skills

PowerPoint skills

Experience in sales force data analysis

Understanding of financial systems

Ability to communicate data insights

Detail-oriented with analytical mindset

Collaborative team player

Familiarity with databases

Education

Bachelor's degree in business or finance

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. Collaborate with the Sales Director and Sales Managers (including medical devices) to maintain customer (territory) and product portfolio mapping by sales representative.
4. Convert data received from wholesalers monthly and send it 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 worksheets related to territory, product, rep, and region mapping tables.
8. Provide weekly updates to the sales team on sales vs. targets YTD/MTD and 12-month unit sales trend.
9. Assist the Sales Director and Sales Managers with adhoc reporting requests, including cycle meetings, sales conferences, and forecasting meetings.
10. Collaborate with the Sales Director and medical Devices BUM to build a monthly sales report.
11. Continuously improve various reports in terms of format and content.
12. Compile 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.