Business Intelligence Developer

BKB Ltd; Oos-Kaap; On-site; ZAR 300 000 - 400 000; Full time

Job summary

A forward-thinking company in South Africa is seeking a BI Analyst to support business intelligence functions. The candidate will work closely with the IT team and Business to analyze data, ensuring its integrity and accessibility for decision-making. The role requires a Bachelor's degree or diploma in Business Administration, Information Systems, or Data Analytics, along with experience in Microsoft Business Intelligence tools and SQL. A competitive salary package is offered, including medical aid and retirement benefits.

Benefits

Medical aid

Retirement benefits

Above-average leave

Qualifications

• Experience writing SQL Queries (minimum of 2 years).
• Exceptional organizational skills and attention to detail.
• Strong knowledge of data structures and analysis.

Responsibilities

• Review report data to ensure integrity of data.
• Test data to identify and understand anomalies.
• Creation of Visual Reports using Power BI and ZAP.
• Develop, maintain, publish, and schedule Power BI reports.
• Integrate Power BI reports with various data sources.

Skills

Organizational skills

Data analysis

SQL Queries

Microsoft Business Intelligence stack

Microsoft Power Platform

Data warehousing

Microsoft Office Suite

Education

Bachelor's degree/diploma in Business Administration, Information Systems, Data Analytics

Tools

Power BI

SQL Server

SSAS

SSIS

SSRS

SharePoint

ERP application – SYSPRO

Job description

Here at BKB, we want to do things differently. We have to, because the world is changing, and we want to keep up. Our people, no matter their position, are the ones to do this. We are looking for forward thinkers who want to make a difference.

The incumbent will fulfil the role of support in the business intelligence functions of BKB. The role will require a person who is eager to learn and gain work experience. They will work closely with the IT team and Business to assist in turning data into critical information and knowledge that can be used to make sound business decisions. The incumbent will build an understanding of the business at a level of detail that enables them to identify and address critical issues. Provide data that is accurate, congruent, and reliable, and ensure the information is readily available to users for direct consumption.

BI Analysts educate and train clients to use data as an analytical tool, displaying the information in new forms and content for the purpose of analysis and option exploration.

We offer a competitive Total Cost To Company (TCTC) Salary which includes, medical aid, retirement benefits and above average leave.

Job Requirements

• Bachelor’s degree/diploma majoring in Business Administration, Information Systems, Data Analytics
• Exceptional organizational skills and attention to detail are required
• Experience with Microsoft Business Intelligence stack including, SQL Server, SSAS, SSIS, and SSRS
• Experience with Microsoft Power Platform and SharePoint
• Experience with and knowledge of data warehousing
• Strong knowledge of data structures, analysis
• Experience writing SQL Queries (minimum of 2 years)
• Excellent working knowledge of Microsoft Windows OS and Microsoft Office Professional application suite (Word, Excel, PowerPoint, Access, Visio)
• Knowledge of ERP application – SYSPRO – beneficial

Job Functions

• Review report data to ensure integrity of data
• Test data to identify and understand anomalies
• Creation of Visual Reports using Power BI and ZAP
• Develop, maintain, publish, and schedule Power BI reports and dashboards to meet business requirements.
• Create and maintain documentation for data models, reports, and dashboards.
• Integrate Power BI reports with various data sources including SQL Server, Excel, Azure, SharePoint and cloud services
• Collaborate with business users to gather requirements for Power BI reports and dashboards.
• Provide training and support to business users on Power BI usage and apply best practices.
• Work with IT and data teams to ensure data governance and security policies are adhered to.