Business Intelligence Specialist

Business Intelligence Specialist

Location: Stellenbosch, Western Cape
Salary: R720k per annum

About the Role:
Reporting to the CEO, the role requires the individual to structure and analyse data for the purpose of producing reports and to develop and implement suitable BI solutions, in collaboration with internal stakeholders.

5+ years working experience in the field of business intelligence and business analysis
Knowledge in the technical aspects of business intelligence, including data modelling and data management
Intermediate to advanced expertise in the Microsoft BI solutions offerings
Formal university qualification, relevant technical qualification, BI or SQL qualifications will be an advantage
Understanding of the financial services field is an advantage
Knowledge of semantic models / layers
Knowledge of designing frameworks and data structures for reporting and analysis
Proficient in the use of query and reporting analysis tools
VBA, Python or equivalent coding skills
Power BI skills
Excel skills (Up to date with latest developments)
M-Query (Power Query)
Power Pivot
Power Automate
SSIS (SQL Server integration services)
SSAS (SQL Server analysis services)
Knowledge of best practice and reporting database architecture
SQL server administration skills (SSMS – SQL Server management services)

Standardise data collection and interpretation within the Group
Make recommendations towards application analysis and data modelling designs
Generate reports and provide Management with recommendation on data analysis findings
Create and maintain reporting and data structures to various Business Units
Collaborate with Management and Business Unit heads on BI needs and solutions
Collaborate with internal stakeholders for continuous improvement and automation initiatives
Identify opportunities to improve processes and strategies to optimise business and financial performance
Create an internal awareness culture by providing guidance and direction on the use of data reporting, the application of BI systems and data collection processes
Provide guidance to employees at all levels on how to make optimal use of data