Data Architect

Rmbwestport; Johannesburg; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A financial services firm in Johannesburg seeks a Data Warehouse Engineer to design and develop ETL processes, enhance data analytics solutions, and mentor junior team members. This role requires strong SQL and Power BI skills, along with substantial experience in the BI development life cycle. A relevant IT degree and Microsoft certifications are preferred.

Qualifications

• 6+ years in IT with 4+ years in Data Analytics/BI or related.
• In-depth knowledge of relational databases and data warehouse design.
• Ability to develop BI solutions independently.

Responsibilities

• Design and develop ETL and data integration processes.
• Create reporting, visualization, and dashboard processes.
• Mentor junior team members and oversee quality of BI solutions.

Skills

Analytical skills

Troubleshooting skills

Data analytics tools

ETL processes

SQL proficiency

Visualization skills

Education

3/4 year IT qualification in Software Development

Microsoft certification in Data Space

Tools

SQL Server

Power BI

Azure Data Factory

SSIS

SSAS

Job description

Data Warehouse Engineer

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 SQL Server DBMS, T-SQL (ANSI), PostgreSQL, Python, and tools in the Microsoft BI stack.

Is this job a match or a miss?

Full Stack Data Warehouse Developer

Posted today

Job Description

Introduction

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.

Requirements

• 3/4 year IT qualification in Software Development
• Relevant Microsoft certification in the Data Space
• Experience in the full BI development life cycle.
• 6+ years in IT with 4+ years in Data Analytics/BI or related.
• Experience managing Data Projects.
• Experience with SSIS and SSAS, SQL Server; Power BI required.
• Development experience with relational database structures, multi-dimensional database, and data warehouse design architecture.
• Knowledge of Insurance Systems is a plus.

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 with drill-down capability.
• Develop BI solutions using SQL, ETL scripting using ADF/Synapse Pipelines, BI tools, and reporting tools on the Microsoft BI Stack.
• Integrate with diverse source systems (In-House, Vendor-based, On-prem and Cloud-based, Office 365).
• Collaborate with DevOps on testing of database changes and application updates.
• Maintain data model schema, hierarchy within data warehouse, and reporting systems.
• Apply database tuning techniques to improve performance.
• Mentor junior and intermediate team members; coordinate team efforts to achieve business objectives.
• Ensure business continuity documentation through Azure DevOps; enforce database security standards.
• Review code implementations and oversee quality of BI solutions by junior team members.
• Drive adoption of innovative technology in the Data space through leadership teams.
• Must have experience developing BI solutions in large or midsize companies and be able to manage multiple tasks.
• Experience with Power BI to analyze data and report conclusions.

Is this job a match or a miss?

MMH251006-9 – Full Stack Data Warehouse Developer

Posted today

Job Description

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 BI solutions and ensure standards are met by junior team members.

Requirements

• 3/4 year IT qualification in Software Development
• Microsoft certification in the Data Space
• Experience in the full BI development life cycle.
• 6+ years in IT with 4+ years in Data Analytics/BI or related.
• Azure Data Factory/Synapse Pipelines Experience; SSIS/SSAS, SQL Server; Power BI
• Development experience with relational database structures, multi-dimensional database, and data warehouse design.
• Experience with reporting and BI solutions; able to work independently.

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 with drill-down capability.
• Develop BI solutions using SQL, ETL scripting using ADF/Synapse Pipelines, BI tools, and reporting tools on the Microsoft BI Stack.
• Integrate with diverse source systems (In-House, Vendor-based, On-prem and Cloud-based, Office 365).
• Collaborate with DevOps on testing of database changes and application updates.
• Maintain data model schema, hierarchy within data warehouse, and reporting systems.
• Apply database tuning techniques to improve performance.
• Mentor junior and intermediate team members; coordinate team efforts to achieve business objectives.
• Ensure business continuity documentation through Azure DevOps; enforce database security standards.
• Review code implementations and oversee quality of BI solutions by junior team members.
• Must have experience developing BI solutions in large or midsize companies; Power BI experience required.

Note: This refined description removes unrelated boilerplate and consolidates key responsibilities and qualifications into clearly labeled sections using only allowed HTML tags.