A company specialising in information technology services while offering strategic consulting to leading-edge technologies and enabling experiences that transform organisations for success while shaping a better society has an opening for an Intermediate BI Developer. Join a pioneering business that's 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. 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 or call her on to discuss this and other opportunities. Do you have a friend who is a developer or technology specialist? We pay cash for successful referrals! #J-18808-Ljbffr