Full Stack Data Warehouse Developer

Guardrisk; Gauteng; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A leading insurance company in Gauteng is seeking a Data Analyst to design and develop ETL solutions and manage business intelligence projects. The ideal candidate will have over 6 years of IT experience, focusing on data analytics and business intelligence. This role includes mentoring junior team members and ensuring the quality of BI solutions. A Microsoft certification and experience with Azure Data Factory are required. The position offers a dynamic environment in the insurance industry.

Qualifications

• 6+ years experience in the IT Field with 4+ core experience in Data Analytics.
• Prior experience developing BI solutions in large or midsize companies.
• Excellent communication skills.

Responsibilities

• Design and develop ETL and data integration solutions.
• Participate in the analysis and design of reporting systems.
• Mentor Junior and Intermediate team members.

Skills

Data Analytics

Business Intelligence

SQL

Azure Data Factory

Power BI

DevOps Practices

Data Modeling

Education

3 / 4 year IT qualification in Software Development

Microsoft certification in the Data Space

Tools

SQL Server

SSIS

SSAS

Job description

IntroductionGuardrisk 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.

Duties & 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).
• 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.
• Apply database tuning techniques to improve the performance of current solutions.
• Assist lead developer in coordinating 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.

Requirements & Qualifications

• 3 / 4 year IT qualification in Software Development
• Relevant Microsoft certification in the Data Space
• 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
• Azure Data Factory / Synapse Pipelines experience essential
• Experience with SSIS and SSAS, SQL Server
• Power BI required
• Prior experience developing business intelligence solutions in large or midsize companies
• Ability to manage multiple tasks simultaneously and react to problems quickly
• Ability to translate concepts and directions into practical solutions
• Experience in reporting and business intelligence solutions
• Development experience with relational database structures, multi‑dimensional database, and data warehouse design architecture
• Experience with mobile deployment of business intelligence desired
• Experience with SQL
• Ability to develop, maintain, review and explain data models
• Excellent verbal and written communication skills
• Team player
• Understanding of the financial services industry desired, especially Insurance
• Development experience with Microsoft BI stack (Incl SSIS, SSRS, SSAS, Data Management)
• Experience with dashboard design and delivery
• Ability to work independently
• Experience using Power BI to analyze data and report conclusions