Senior Data Warehouse Developer

Pbt Group; Gauteng; On-site; ZAR 600 000 - 800 000; Full time

Job summary

A prominent data solutions company in Gauteng seeks an experienced Senior Data Warehouse Developer. The ideal candidate will design and maintain data warehouse solutions utilizing SQL and ETL methodologies. Responsibilities include developing Power BI dashboards and collaborating with various teams. Candidates should have at least 5 years' experience and a relevant degree.

Qualifications

• 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).
• Cloud certification is advantageous.

Responsibilities

• Design, develop, and maintain robust data warehouse solutions.
• Develop and optimize ETL/ELT processes.
• Build interactive Power BI dashboards aligned with business requirements.
• Engage with stakeholders to clarify data needs.

Skills

SQL

ETL / ELT development

Data modeling

Power BI

Data replication tools

Cloud data platforms

Education

Bachelor's degree in Computer Science or related field

Tools

MS SQL Server

SSIS

Azure Data Factory

Informatica

Talend

Git

Job description

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

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.