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 maintenanceTransformations: Creating and managing SQL stored proceduresTroubleshooting: Investigating and resolving SQL bugsData Design: Designing and building SQL datasets for reportingData Handling: Loading and verifying SQL monthly source dataData Analysis: Manipulating and analysing dataReporting: Running month-end packs in TableauDaily Reporting: Managing daily SQL data and Tableau reportsReport Development: Developing and automating new BI reportsQualifications & 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 technologiesHadoop components including HDFS, Hive, Spark, Oozie and ImpalaStreaming based data pipelines (e.g.
Kafka or Nifi)Object-oriented/object functional scripting languages: Python, Java, Scala or relatedSQL 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