Business Intelligence Analyst

Position: Business Intelligence Analyst

Department: BI & Analytics

Location: Cape Town

Reporting to: BI & Analytics Manager

Purpose of the Role:

The BI Business Analyst should be able to analyse and synthesise large amounts of data, accurately project sales trends, identify sales opportunities, and provide practical guidance to optimise sales strategies to increase market share. Collect and examine data and use the information gathered to create coherent, intelligent reports.

KEY RESPONSIBILITIES

Business Performance:

1. Conduct thorough analyses of sales data and market trends to create insightful reports on brand and customer performance.
2. Perform comprehensive quantitative and qualitative analyses to produce detailed brand performance reports.
3. Work closely with sales and trade marketing teams to optimize and assess campaign effectiveness, using data to inform brand strategy and enhance customer engagement.
4. Collaborate with sales and trade marketing teams to develop and execute data-driven campaigns, measuring their impact on brand performance and market share.
5. Utilize tools such as Excel and Power BI to design and implement insightful BI reports, dashboards, and data narratives.
6. Develop and present feedback decks for brand sales reviews, focusing on the effectiveness of Trade Marketing and Key Account activities, along with any brand metrics agreed upon in brand planning sessions.
7. Partner with the sales team to provide data analysis that supports the refinement of customer engagement strategies.
8. Build strong, trust-based relationships with brand partners and customers through consistent sales reviews aligned with brand plans.
9. Manage and master data efficiently.
10. Scope and analyse business system requirements.
11. Incorporate system and enterprise architecture design into requirements analysis and solution design.
12. Present scoping and analysis findings in solution design and decision-making meetings.
13. Engage with process owners and end-users to define processes, business rules, and user experience requirements.
14. Define system-to-system integration processes and specifications.
15. Drive agile solution delivery through interaction with the team and business users.
16. Maintain, improve and deliver accurate, high quality information on our platforms.
17. Monitor data for accuracy and completeness.
18. Data analysis.
19. System maintenance (SQL / Power BI/ Other).

Leadership:

1. Manage own personal development through your PDP (Personal Development Plan). Request training and feedback on performance and strive to improve based on these interventions.
2. Adhere to the company's values.
3. Take personal responsibility for all issues facing the department, work as a team and mentor/coach new employees as required.
4. Communicate with your line manager regularly and make recommendations on improving efficiencies in the department.

COMPETENCIES:

1. Strong admin and organisational skills.
2. Strong analytical skills.
3. Self-motivation; good energy levels and ability to work independently and with cross-functional teams.
4. Attention to detail and desire for accuracy.
5. Advanced problem-solving and analysis skills.
6. Strong work ethic and willingness to take initiative.
7. Critical thinking, attention to detail, good listening and debating skills, excellent verbal and written command of the English language, good time management.

REQUIREMENTS/QUALIFICATIONS:

1. High level of computer competency and literacy, including Microsoft Office programs (MS Word and Excel).
2. Basic understanding of database/SQL queries and views.
3. Working knowledge of Power BI or Cognos Analytics would be advantageous.
4. Bachelor’s Degree or equivalent.
5. 1 to 3 Years working knowledge in Business Intelligence.

Job: BI & Analytics

Primary Location: Cape Town