Subject Matter Expert - Analytics and Business Intelligence

Baraka IT Solutions (Pty) Ltd; Pretoria; On-site; ZAR 600 000 - 1 200 000; Full time

Job summary

An established industry player is seeking a seasoned Business Intelligence Leader to spearhead the development of advanced data analytics solutions. This role involves designing dashboards, establishing an Enterprise Data Warehouse, and leading a team in the implementation of OLAP technologies. With over a decade of experience in the field, you will drive the creation of comprehensive reporting systems and ensure alignment with business requirements. If you are passionate about data-driven decision-making and have a strong background in BI, this is an exciting opportunity to make a significant impact in a dynamic environment.

Qualifications

• 10+ years leading business intelligence units with OLAP technologies.
• 6+ years in data modelling and ETL design for large scale data warehouses.

Responsibilities

• Design and implement dashboards and BI solutions for data analysis.
• Develop ETL processes and maintain data warehouse architecture.

Skills

Business Intelligence Leadership

OLAP Technologies

Data Warehouse Architecture

SQL Development

ETL Design

Data Modelling

GIS Systems Development

Business Analysis

Education

Degree in Computer Science or IT

Equivalent NQF7 Qualification

Tools

Microsoft PowerBI

Job description

Design dashboards and undertake troubleshooting (28 KPI Dashboard).

Design, update, and test OLAP tier to drive UI and analytics tools.

Development of SQL Extract, Transform and Load (ETL) processes.

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, Information Technology, Informatics, Engineering, Information Systems, Commerce, or other relevant qualification at NQF7.

10+ years experience leading business intelligence units.

10+ years experience in development and implementation of solutions using OLAP technologies.

8+ years experience in 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 building reporting cubes and dashboards.

6+ years experience in data modelling, both logical and physical models.

6+ years experience in ETL design.

6+ years experience in relevant development languages, including SQL, MDX, DAX.

Added Advantage

Development experience using Microsoft PowerBI would be an advantage.