Senior Data Warehouse Developer

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

Job summary

An IT company providing software solutions in South Africa is looking for a Senior Data Warehouse Developer for their financial services client. The role involves designing scalable data warehouse solutions, developing ETL processes, and building Power BI dashboards. Candidates should have a degree in a relevant field, 5+ years of experience, and strong SQL skills. This position offers full-time employment and is based in Centurion, Gauteng.

Qualifications

• 5+ years' experience as a Data Warehouse Developer or related role.
• Strong SQL skills with experience in relational and non-relational databases.
• Experience with ETL / ELT tools.
• Solid understanding of data warehousing methodologies like Kimball and Inmon.
• Strong communication and analytical thinking skills.

Responsibilities

• Design, develop, and implement scalable data warehouse solutions.
• Develop, maintain, and optimize ETL / ELT processes.
• Build and enhance Power BI solutions.
• Provide operational support and troubleshoot errors.
• Promote data governance principles and quality standards.

Skills

SQL

Data Warehousing

ETL

Data Analysis

Power BI

Education

3-year degree in Mathematics, Economics, Computer Science, Information Management, or Statistics

Tools

SSIS

Azure Synapse

AWS Redshift

Data Factory

Informatica

Talend

Job description

Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.

We are looking for a Senior Data Warehouse Developer to join our financial services client based in Centurion.

What You Will Be Doing

Design, develop, and implement scalable data warehouse solutions.

Develop, maintain, and optimize ETL / ELT processes for efficient data extraction, transformation, and loading.

Build and enhance Power BI solutions from high-level technical and business requirements.

Perform quality assurance checks and ensure data accuracy and integrity.

Configure real-time data replication using tools such as Stelo SQDR.

Provide operational support, troubleshoot errors, and resolve data queries.

Work with technical stakeholders to identify data sources, understand metadata, and define solutions.

Promote data governance principles, data quality standards, and best practices.

Convert legacy Excel reports into Power BI dashboards.

Design professional reports, dashboards, and visualisations.

Test, debug, and reconcile data against source systems.

Communicate progress and present insights in easily understandable formats.

Identify opportunities for improvement and provide analytical observations.

Collaborate with business analysts, data scientists, and other stakeholders on data requirements.

Monitor and optimise data warehouse performance.

Implement data governance, security, and compliance standards.

Provide mentorship and guidance to junior team members.

What We Are Looking For

5+ years' experience as a Data Warehouse Developer or related role.

3-year degree in Mathematics, Economics, Computer Science, Information Management, or Statistics.

Strong SQL skills with experience in relational and non-relational databases.

Experience with ETL / ELT tools (SSIS, Data Factory, Informatica, Talend, etc.).

Solid understanding of data warehousing methodologies (Kimball, Inmon).

Experience with data modelling (dimensional modelling, star and snowflake schemas).

Experience with Power BI or similar visualisation tools.

Familiarity with cloud data platforms (Azure Synapse, AWS Redshift, Big Query) is advantageous.

Experience working with SQL Server and MS T-SQL.

Experience with data extraction, data analysis, data reconciliation, and data visualisation.

Exposure to data replication tools (Stelo SQDR, Qlik Replicate, etc.).

Knowledge of the software development lifecycle.

Strong communication, analytical thinking, report writing, problem-solving, and time-management skills.

Please note that if you do not hear from us within 3 weeks, consider your application unsuccessful.

Desired Skills

ETL

SQL

Power BI

data analysis

Data Warehousing

Location : Centurion, Gauteng, South Africa.

Employment type : Full-time.

Seniority level : Mid-Senior level.

Job function : Information Technology.

Industries : IT Services and IT Consulting.