Design dashboards and undertake troubleshooting (28 KPI Dashboard)
Design, Update and Testing of OLAP tier to drive UI and Analytics tools
Development of SQL Extract, Transform and Load Stored
Develop and implement Procedures and Views.
Establish an Enterprise Data Warehouse in support of the IJS BI KPI Dashboard solution as specified in the Information Exchange Agreement (IEA).
Development and maintenance of IJS BI KPI Dashboard solution, (Reporting Services) Scorecard information as well as (Reporting Services) Map information for the IJS Transversal BI Dashboard presentation.
Development of IJS BI measures for JCPS Cluster additional reports including report maintenance and provision of reports and information for other JCPS meetings
Perform Business data analysis and technical fault resolution with departments.
Perform BI Data Import QA for staging system.
Perform BI OLAP Cube Architecture and business requirements alignment.
Perform Dashboard Usability design.
Undertake Pivot table analysis for BI analytics
Perform Project Management / reporting risk management of BI Team.
Design and implement Architectures for Event Driven analysis data warehouse.

Minimum Qualifications
Appropriate Degree or Equivalent in Computer Science, or Information Technology, or Informatics, or Engineering, or Information Systems, or Commerce or other relevant qualification at NQF7

Minimum Experience
10+ years’ experience leading business intelligence department / units
10+ years’ experience development and implementation of solutions using OLAP technologies
8+ years leading architecting, designing and developing large scale data warehouses
8+ years’ experience in development of GIS systems
6+ years’ experience as a business/systems analyst in the building of reporting cubes and dashboards
6+ Experience in data modelling, both logical and physical models
6+ years in ETL design.
6+ years in relevant development languages, including SQL, MDX, DAX

Added Advantage
Development experience using Microsoft PowerBI would be an advantage.