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 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 / 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.

Subject Matter Expert – Analytics And Business Intelligence position available in Tshwane, Pretoria. This job position was posted by . The job has been posted on 2025-02-13 in the It Computing Software category