Business Analyst / BI Manager

University of Fort Hare; Somerset West; On-site; ZAR 600,000 - 800,000; Full time

Job summary

A respected educational institution in Somerset West is looking for a Business Analyst / BI Manager to develop and maintain BI solutions. The role involves translating business needs into technical specifications, designing analytics solutions, and improving existing systems. Candidates should have over 5 years of relevant experience and a degree in Information Systems. Proficiency in BI tools like Microsoft Power BI and strong SQL skills are essential.

Qualifications

• Minimum 5 years in a similar environment.
• Proven experience as a BI Developer or similar role.

Responsibilities

• Design, develop and maintain BI and analytics solutions.
• Translate business needs into clear technical specifications.
• Build and deploy end to end BI solutions.

Skills

BI Developer experience

Understanding of data warehouse architecture

Proficiency in Microsoft Power BI

Strong SQL development skills

Analytical thinking

Problem-solving abilities

Education

Relevant degree in Information Systems

Tools

Microsoft Power BI

Qliksense

Job description

Overview

An established fruit marketing concern based in Somerset West is seeking to employ a Business Analyst / BI Manager to join their team. The main purpose of the position is to gather and channel information from their various systems throughout primary agriculture, production, cooling and marketing divisions into a centralised information system with reports that allow management to effectively manage efficiencies and make informed decisions.

Responsibilities

• Design, develop and maintain BI and analytics solutions that deliver actionable insights
• Translate business needs into clear technical specifications
• Build and deploy end to end BI solutions (ETL, modelling, dashboards)
• Collaborate with teams to integrate systems
• Evaluate and improve existing BI systems
• Develop and execute SQL queries and scripts for data extraction and analysis
• Create and maintain clear, data visualizations and dashboards
• Produce and maintain accurate technical documentation

Personal/Other Skills

• Proven experience as a BI Developer or similar role
• Strong Industry experience is preferred
• Solid understanding of data warehouse architecture
• Proficiency in BI tools such as Microsoft Power BI, Qliksense
• Strong SQL (MS-SQL and MySQL) development skills
• Strong analytical thinking and problem-solving abilities

Education/Experience

• Minimum 5 years in a similar environment
• Relevant degree in information Systems or related field