Position: Business Intelligence Specialist
Location: Stellenbosch, Western Cape (office based)
Contract Type: Permanent
Level: Professional
Appointment Date: ASAP
Remuneration: R40 000,00 - 60 000, 00 CTC

Role Description

Our client requires the services of a Business Intelligence Specialist. 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 within the Group of Companies.

Job Specification
• 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


Minimum Requirements
• 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
Job Required Knowledge & Skills
• 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
• Intermediate VBA, Python or equivalent coding skills
• Advanced Power BI skills
• Advanced Excel skills (Up to date with latest developments)
• Intermediate M-Query (Power Query)
• Beginner Power Pivot
• Intermediate T-SQL
• Beginner/Intermediate Power Automate
• Intermediate SSIS (SQL Server integration services)
• Intermediate SSAS (SQL Server analysis services)
• Intermediate/Advanced DAX
• Intermediate knowledge of best practice and reporting database architecture
• Beginner/Intermediate SQL server administration skills (SSMS – SQL Server management services)

Specific Professional Competencies
• Strong business acumen and the understanding of consumer behaviour, trends, etc.
• Analytical thinking
• Attention to detail
• Adhering to principles and values
• Planning and organizing
• Decision making and initiating action
• Formulating and editing
• Networking skills
• Delivering results and meeting customer expectations
• Adapting and responding to change
• Learning and researching
• Working with people

Please take note that initial correspondence will be via email
Correspondence will be entered into with short-listed candidates
If you have not received a reply within 3 weeks please consider your application unsuccessful