Full Stack Data Warehouse Developer

Guardrisk; City of Johannesburg Metropolitan Municipality; On-site; ZAR 800,000 - 1,000,000; Full time

Job summary

A leading insurance provider in Johannesburg is seeking a seasoned IT professional to design and develop ETL and business intelligence solutions. The role demands extensive experience in data analytics, SQL, and Power BI. You will be responsible for integrating diverse source systems and mentoring junior team members. The ideal candidate should have over 6 years in IT, with a strong background in managing data projects and implementing innovative BI strategies. This is an excellent opportunity to contribute to high-impact projects in a dynamic environment.

Qualifications

• IT Qualification in Software Development.
• Relevant Microsoft certification in the Data Space.
• 6+ years of experience in IT with 4+ core experience in Data Analytics/Business Intelligence.
• Experience managing Data Projects.

Responsibilities

• Design and develop ETL, data integration, and BI solutions.
• Participate in analysis, design, and troubleshooting of reporting platforms.
• Implement reporting, visualization, and dashboard processes.
• Integrate with diverse source systems.
• Participate in testing database-related changes.
• Maintain data model schema and reporting systems.
• Mentor Junior and Intermediate team members.
• Ensure business continuity documentation through Azure DevOps.

Skills

Software Development

Data Analytics

Business Intelligence

SQL

Power BI

SSIS

SSAS

Data Warehousing

Database Administration

ETL Development

Education

IT Qualification in Software Development

Relevant Microsoft certification in the Data Space

Tools

Microsoft BI Stack

Azure DevOps

Job description

Guardrisk is the undisputed market leader in cell captive insurance and risk solutions. We are renowned for our innovative approach to cell captive structures and other alternative risk transfer solutions for our clients. Guardrisk offers clients custom designed cover and is registered in South Africa as an insurer for all statutory classes of non-life and life insurance business.

Role Purpose

You will be responsible for designing and developing ETL, data integration, data warehouse, performance tuning, Data Modelling and business intelligence reporting modules to deliver quality Business Intelligence solutions to the business while ensuring that quality and standards are realised and met by junior team members.

Responsibilities

Participate in the analysis, design, development, troubleshooting and support of the enterprise reporting and analytics platform.

Design, construct, test and implement reporting, visualization, and dashboard processes that present reporting at summary level with functionality to drill down into detail.

Develop BI solutions using SQL, ETL scripting using ADF/Synapse Pipelines, business intelligence tools, database programming and reporting tools on the Microsoft BI Stack.

Integrate with diverse source systems (including but not limited to: In-House, Vendor-based, On-prem and Cloud-based, and Office 365).

Work with DevOps team and participate in testing of all database-related changes and application updates.

Responsible for the day to day database development/administrative tasks which include the development of queries, views, and other database schema objects.

Maintain data model schema, hierarchy within data warehouse, and reporting systems.

Applying database tuning techniques to improve the performance of current solutions.

Assist lead developer in Coordinate team efforts to achieve business objectives (Strategic and operational).

Ensure business continuity documentation through Azure DevOps.

Enforce database security standards and ensure adherence by junior team.

Review code implementations by the Data team.

Oversee quality of BI solutions by junior team members.

Mentor Junior and Intermediate team members.

Drive implementation of innovative and latest technology implementations relating to the Data space through the Lead Developer and Enterprise Architecture team.

Utilize junior members in achieving large scale project developments and implementations in consultation with the lead developer.

Qualifications

IT Qualification in Software Development

Relevant Microsoft certification in the Data Space

Experience

Exposure to the full BI development life cycle.

6+ years’ experience in the IT Field with 4+ core experience in Data Analytics/Business Intelligence or related.

Experience managing Data Projects.

The successful candidate should have experience with SSIS and SSAS, SQL Server

Power BI required.

Should you not hear from us within 21 days, kindly consider your application unsuccessful.