Senior Data Warehouse Developer

Centurion, GP, ZA, South Africa

Job Description

Employment Type




Contract

Experience




5 to 25 years

Salary




Negotiable

Job Published




08 October 2025

Job Reference No.




1192094358


===================


PBT Group is seeking an experienced

Senior Data Warehouse Developer

to join our team. This role plays a key part in designing, developing, and maintaining enterprise-level data warehouse solutions -- ensuring

data integrity, accessibility, and performance

across large-scale financial systems.


The ideal candidate will have a strong technical foundation in

SQL, ETL/ELT development

, and

data modeling

, with proven experience delivering reliable and scalable data warehouse solutions. The role also involves translating complex datasets into actionable insights through effective visualization and reporting tools such as

Power BI

.

Key Responsibilities



Data Warehouse Development



Design, develop, and maintain robust

data warehouse solutions

. Develop and optimize

ETL/ELT processes

to ensure efficient data extraction, transformation, and loading. Configure real-time

data replication

from source systems using tools such as Stelo SQDR or Qlik Replicate. Perform

data quality checks

, validations, and reconciliation to maintain accuracy and integrity. Convert

legacy Excel reports

into Power BI dashboards and reports. Implement data governance, security, and compliance best practices. Develop and document technical solutions that are

scalable, maintainable, and reusable

.

Reporting and Analytics



Build interactive

Power BI dashboards and reports

aligned with business requirements. Translate technical data into

clear, actionable insights

for both technical and non-technical stakeholders. Ensure accurate data attribution and validation for reporting and cost analysis. Perform

data analysis and visualization

to support business decision-making.

Collaboration and Support



Engage with

business analysts, data scientists, and technical stakeholders

to clarify data needs and design solutions. Participate in operational support and troubleshooting of existing data warehouse components. Provide mentorship and technical guidance to junior developers. Collaborate across teams to drive data-driven initiatives and process improvements.

Skills and Competencies



Technical Expertise



Strong proficiency in

MS SQL Server (2022)

and

T-SQL

. Experience with

ETL tools

(SSIS, Azure Data Factory, Informatica, Talend). Solid understanding of

data warehouse methodologies

(Kimball, Inmon). Intermediate to advanced experience with

Power BI

for data visualization. Exposure to

data replication tools

(e.g., Stelo SQDR, Qlik Replicate). Data transformation, modeling, and integration experience. Knowledge of

cloud data platforms

(Azure Synapse, AWS Redshift, BigQuery) advantageous.

Soft Skills



Excellent

analytical thinking

and

problem-solving

abilities. Strong

communication skills

, both written and verbal. High attention to detail with a commitment to quality and accuracy. Effective

time management

and prioritization under tight deadlines. Collaborative team player with a

proactive, solutions-driven mindset

.

In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent*

If you have not received any feedback after 2 weeks, please consider you application as unsuccessful.*

Qualifications and Experience



Bachelor's degree in

Computer Science, Information Systems, Mathematics, Economics

, or related field.

5+ years' experience

as a Data Warehouse Developer or similar role. Proven experience in

data modeling (star/snowflake schemas)

. Experience with

data visualization tools

(Power BI, Tableau, QlikView). Familiarity with

version control systems

(Git).

Cloud certification

(Azure, AWS, GCP) is advantageous. Experience with

Python or PowerShell scripting

beneficial. Exposure to

big data technologies

(Spark, Hadoop) advantageous.

Behavioural Competencies



Examining and interpreting information critically Generating insights and innovative ideas Producing high-quality, accurate deliverables Articulating complex data clearly Collaborative and adaptive team approach Strong accountability and ownership mindset

Skills


==========


Data WarehousingSQLSSISPower BIExtract Transform Load (ETL)Data Modeling

Industries


==============


InsuranceFinancial Services

Beware of fraud agents! do not pay money to get a job

MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD1550800
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Centurion, GP, ZA, South Africa
  • Education
    Not mentioned