Intermediate BI Developer – Johannesburg – R450k to R650k per annum

A company specialising in information technology services while offering strategic consulting to leading- edge technologies and enable experiences that transform organisations for success while shaping a better society have an opening for an Intermediate BI Developer. Join a pioneering business thats renowned for technical innovations that make a difference to our clients, communities and society and be part of a workplace where you can grow, belong and thrive. Responsibilities: End to end data acquisition and data management (Event/Streaming based data pipelines, ETL, Data Lake, Data warehousing and dimensional data modelling). Import the data into the corporate data lake/ data warehouse. Querying: Managing SSIS packages and maintenance Transformations: Creating and managing SQL stored procedures Troubleshooting: Investigating and resolving SQL bugs Data Design: Designing and building SQL datasets for reporting Data Handling: Loading and verifying SQL monthly source data Data Analysis: Manipulating and analysing data Reporting: Running month-end packs in Tableau Daily Reporting: Managing daily SQL data and Tableau reports Report Development: Developing and automating new BI reports Qualifications & Experience: IT Related Degree/ Diploma / Microsoft Certification / Cloud Certification. Min 5 years experience in BI (SSIS, SSRS). Min 5 years experience in Data Warehousing (Kimbal Methodology) (SSIS). Insurance industry knowledge required. Database technologies SQL Server 2012 or later (Database, table, view and stored procedure creation, SQL query, SQL Security). Exposure to any cloud technologies Hadoop components including HDFS, Hive, Spark, Oozie and Impala Streaming based data pipelines (e.g. Kafka or Nifi) Object-oriented/object functional scripting languages: Python, Java, Scala or related SQL Architectural experience preferable. Working knowledge of C# / VB.Net / VBA advantageous. The Reference Number for this position is NG59713 which is a Permanent Hybrid position based in Johannesburg offering a cost to company of R450k R650k per annum negotiable on experience and ability. Contact Nokuthula at

Location: Johannesburg, ZA

Posted Date: 9/27/2024