PURPOSE:
Business Intelligence (BI) Team to deliver business insight from data analytics to guide strategy, tactics & execution. Effective candidates need the experience and skillsets to drive forwards a newly created BI team. Finding insight in data is half the story, validating the findings and delivering value is the goal of the BI Team

to turn data into information, information into insight and insight into business decisions that will improve the Customers’ businesses and reduce costs.

APPLICANTS:
We are looking for highly intelligent, self-motivated, hardworking and conscientious applicants to help build the BI Team. Applicants must exhibit an assertive attitude, with expectations of self-learning and occasionally working out of regular hours to meet deadlines. Integrity is a pre-requisite as data is the IP of the company, valuable as well as open to POPI scrutiny.


Responsibilities:

The role of BI is not to do work for people but wherever possible to empower them to do better work for themselves
Managing the projects, workload and delivery of the BI Team
Responsible for the BI strategic road map
Attending management meetings to gain full insight of the role
Managing the business data requirements - getting the right data and answers to make key decisions in a timely manner
Analysing internal and external data, profiling data, deriving conclusions and further actions
Automating current reporting
Generating new methods of visualising data (dashboards)
ROI, P&L and cost benefit analysis

Business skills:

Understanding business requirements - gaining deeper business insight to really understand the changing market environment
Speaking to the business, listening to issues, interpreting requirements
Prioritising internal clients + solutions
Ensuring buy in and continued use
Project management of chosen solutions
Presenting data in a business context rather than from an IT perspective
Quantifying results and delivering conclusions
Packaging and automating solutions so the same question can be asked again as needed

Technical Skills:

Sufficient understanding and technical skills to lead and manage their Team
Identifying, cleansing, and preparing relevant data from a vast sea of frequently irrelevant data
Joining data from multiple input sources and channels
Developing complex methodologies to process data based on business criteria
Validating and sense checking your work as erroneous data will discredit all your hard work

PostgreSQL:

At least 6 months commercial experience with SQL databases and executing queries
Preferably proficient with SEQUEL
QLIKVIEW

Database experience:

Some experience with commercial SQL databases (not just academic)
DB management and maintenance
Connection strings
Data quality and integrity

Excel Skills:

Advanced level - Excel competency
Commercial use of excel to produce reports, graphs and perform data analytics
Defining tables and ranges, reference formulas and conditional formulas, formatting dates and times, array formulas (CSE), pivot tables and sub totals, including commercial use to produce reports, graphs, and perform data analytics
MS VBA not necessary but welcome