Business Intelligence Specialist

Business Intelligence Specialist

Location: Stellenbosch, Western Cape

Contract Type: Permanent

Level: Mid-Management

Appointment Date: Immediately or as soon as available

Remuneration: R 40 000, 00 – R60 000, 00

Application Instruction:

CV and a professional cover photograph AND (head and shoulders)

Role Description:

Our client requires the services of a Business Intelligence Specialist. The role requires the individual to retrieve and review data for the purpose of producing reports, to develop and implement suitable BI solutions, in collaboration with internal stakeholders within the Group of Companies.

Main Responsibilities

• Standardise data collection and interpretation within the company 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

• Formal Business Intelligence and SQL qualification
• 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 solution offerings

Job Required Knowledge & Skills

• Understanding of the financial services field is advantageous
• 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

When submitting your application, please ensure to include the following:

• Resume
• Qualifications
• Salary expectations
• Notice period