Data Architect

Alexforbes; Gauteng; On-site; ZAR 800 000 - 1 000 000; Full time

Job summary

A leading risk solutions provider in South Africa is looking for a Full Stack Data Warehouse Developer. In this role, you will design and implement Data Warehousing solutions while ensuring data quality and managing projects. You must have extensive experience in ETL processes, Power BI, SQL, and be adept in leading junior team members. This position offers a chance to work in a dynamic environment focused on innovation and improvement.

Qualifications

• 6+ years experience in the IT field, with 4+ core experience in Data Analytics/Business Intelligence.
• Experience managing Data Projects.
• Must develop business intelligence solutions in large or mid-size companies.

Responsibilities

• Design and develop ETL, data integration, and performance tuning.
• Ensure quality and standards are met by junior team members.
• Integrate with diverse source systems.

Skills

ETL

Data Analytics

Business Intelligence

SQL

Power BI

Education

3/4 year IT qualification in Software Development

Relevant Microsoft certification in the Data Space

Tools

Azure Data Factory

SSIS

SQL Server

Job description

Full Stack Data Warehouse Developer

Posted today

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.

As an applicant, please verify the legitimacy of this job advert on our company career page.

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.

Requirements

• 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, SSAS, SQL Server.
• Power BI required.

Duties & Responsibilities

• Participate in 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 day‑to‑day database development/administrative tasks including queries, views and other database schema objects.
• Maintain data model schema, hierarchy within data warehouse, and reporting systems.
• Apply database tuning techniques to improve 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 members.
• 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.
• Utilise junior members in achieving large-scale project developments and implementations in consultation with the lead developer.
• Must develop business intelligence solutions in large or mid-size companies.
• Must manage multiple tasks simultaneously and react to problems quickly.
• Must translate concepts and directions into practical solutions.
• Must have experience in reporting and business intelligence solutions.
• Must have development experience with relational database structures, multi-dimensional database, and data warehouse design architecture.
• Experience with mobile deployment of business intelligence desired.
• Must have experience with SQL.
• Must develop, maintain, review and explain data models.
• Must have excellent verbal and written communication skills.
• Must be a team player.
• Understanding of the financial services industry desired, especially Insurance.
• Development experience with Microsoft BI stack (SSIS, SSRS, SSAS, Data Management).
• Experience with dashboard design and delivery.
• Must be able to work independently.
• Experience using Power BI to analyze data and report conclusions.

Data Warehouse Engineer

Posted 109 days ago

Job Description

Permanent.

About our client: Our client offers financial service solutions helping their clients achieve their dreams. With an emphasis on culture fit, they boast a dedicated team of over 600 employees, many with over a decade of tenure. They have built their culture on a feeling of togetherness, trust and respect and are always looking to support employees' continuous learning. Using Agile, they provide diverse services with a focus on research, innovation and improvement.

What you will be doing: Design, develop and modify database structures, relationships, data flows, and data interfaces within the data warehouse. Analyse, create and modify data structures to adapt to business needs and add enhanced functionality. Develop and modify ETL processes to load data from various sources into the data warehouse. Use programming languages, software development methods, and best practices to develop new data warehouse structures and reports and modify existing ones. Unit test and debug code. Participate in requirements gathering, analysis, technical design, testing, documentation and project planning. Consult with clients to gather information about needs, objectives and requirements. Identify and propose technical solutions to client requests and system problems. Follow department standards and create written documentation and diagrams as required. Thorough understanding of data warehouse architecture, data structures and fundamental design principles. Ability to work independently with general supervision, which may include providing guidance and support to entry-level professionals or support staff. Contribute to the development of data warehouses for clients in the Insurance, Lending and Employee Benefits sectors. Responsible for software development, production support, and providing expertise in Data Warehouse and Reporting Applications.

What our client is looking for: A relevant tertiary degree would be ideal (Computer Science, IT, Data Science, Information Systems, etc.). Strong interest in analytical / dimensional modelling and data analytics tools. Insurance knowledge is a plus. In-depth knowledge of business intelligence tools including data warehousing and ETL (Extraction, Transformation, and Load). Yellowfin knowledge is beneficial. Knowledge and understanding of the software development life cycle. Knowledge and experience in relational databases, SQL, PostgreSQL. Experience in database design and modelling for data warehouse and business intelligence applications, including relational database structures and normal forms. Analytical and troubleshooting skills for complex technical issues and tasks. Ability to present and explain complex technical topics, problems and alternative solutions to others. Experience estimating solution development and delivering solutions within those estimations. Knowledge of insurance systems. Experience with or knowledge of most of the following software, languages and tools, or similar products would be preferred: SQL Server DBMS, T‑SQL (ANSI), PostgreSQL, Python.

Job ID: J

For a more comprehensive list of opportunities that we have on offer, do visit our website‑

Part of our other content such as email alerts, popular roles and career advice is excluded as it is not core job information.