Business Intelligence Analyst Midrand

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

Job summary

A leading company in data analysis is looking for a Data Analyst to drive insights for sales performance improvement. This role involves supporting sales teams with reports, projections, and analyses to inform strategic decision-making, requiring strong BI tool proficiency and analytical skills. The ideal candidate will have a Bachelor's degree and excel in collaborating with various stakeholders to enhance the sales reporting process.

Qualifications

• Bachelor's degree in Business, Finance, or a related field.
• Strong proficiency in BI tools such as Power BI.
• Solid understanding of financial systems and reporting processes.

Responsibilities

• Assist in creating product-based sales targets with Sales Director.
• Maintain customer and product portfolio mapping.
• Provide weekly updates on sales vs. target.

Skills

Proficiency in BI tools

Advanced Excel skills

PowerPoint skills

Data analysis

Detail-oriented

Analytical mindset

Interpersonal skills

Education

Bachelor's degree in Business, Finance, or related field

Tools

Power BI

Job description

Job Overview

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

The incumbent will work collaboratively with the Sales Director and other business stakeholders to ensure the timely creation of effective sales reports.

Duties & Responsibilities

1. Annually assist the Sales Director and Sales Managers (including medical devices) in creating product-based sales targets for the upcoming year.
2. Make quarterly adjustments based on financial forecast results.
3. Maintain customer (territory) and product portfolio mapping by sales representative in collaboration with the Sales Director and Sales Managers (including medical devices).
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. target YTD/MTD and 12-month unit sales trends.
9. Assist the Sales Director and Sales Managers (including medical devices) with ad hoc reporting requests, e.g., during cycle meetings and sales conferences.
10. Collaborate with the Sales Director and medical Devices BUM to build a monthly sales report.
11. Continuously improve various reports in format and content.
12. Back up the Market Intelligence Manager in budgeting, forecasting, and MTS processes.

Desired Experience & Qualification

• Educational background: 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 analyzing sales force data (CRM), evaluating performance against targets, solid understanding of financial systems and reporting processes, ability to communicate complex data insights clearly, detail-oriented with a strong analytical mindset, collaborative team player, good interpersonal skills, familiarity with relevant databases and data extraction techniques.

Package & Remuneration

TBA