Business Intelligence Analyst

Media24; Wes-Kaap; On-site; ZAR 400 000 - 600 000; Full time

Job summary

A leading media company in South Africa is seeking a Business Intelligence Analyst to analyze sales trends and optimize strategies. You will collaborate closely with marketing teams, utilizing tools like Power BI to design reports and drive insights. A Bachelor's degree and 1-3 years of relevant experience are required for this role.

Qualifications

• High level of computer competency including Microsoft Office programs.
• Basic understanding of database/SQL queries.
• 1 to 3 years working knowledge in Business Intelligence.

Responsibilities

• Conduct thorough analyses of sales data and market trends.
• Utilise tools to design and implement insightful BI reports.
• Drive agile solution delivery through interaction with the team.

Skills

Analytical skills

Organisational skills

Attention to detail

Problem-solving skills

Education

Bachelor's Degree or equivalent

Tools

Power BI

SQL

Microsoft Excel

Job description

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

• Conduct thorough analyses of sales data and market trends to create insightful reports on brand and customer performance
• Perform comprehensive quantitative and qualitative analyses to produce detailed brand performance reports
• Work closely with sales and trade marketing teams to optimise and assess campaign effectiveness, using data to inform brand strategy and enhance customer engagement
• Collaborate with sales and trade marketing teams to develop and execute data‑driven campaigns, measuring their impact on brand performance and market share
• Utilise tools such as Excel and Power BI to design and implement insightful BI reports, dashboards, and data narratives
• 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
• Partner with the sales team to provide data analysis that supports the refinement of customer engagement strategies
• Build strong, trust‑based relationships with brand partners and customers through consistent sales reviews aligned with brand plans
• Manage and master data efficiently
• Scope and analyse business system requirements
• Incorporate system and enterprise architecture design into requirements analysis and solution design
• Present scoping and analysis findings in solution design and decision‑making meetings
• Engage with process owners and end‑users to define processes, business rules, and user experience requirements
• Define system‑to‑system integration processes and specifications
• Drive agile solution delivery through interaction with the team and business users
• Maintain, improve and deliver accurate, high quality information on our platforms
• Monitor data for accuracy and completeness
• Perform data analysis
• System maintenance (SQL / Power BI / Other)

Leadership

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

Competencies

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

Requirements / Qualifications

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

Job: BI & Analytics
Primary Location: Cape Town