Data Engineer (Contract)

PBT Group; Cape Town; On-site; ZAR 600,000 - 900,000; Part time

Job summary

PBT Group is seeking an experienced Data Engineer to join our consulting team on a contract basis. You will design, develop, and maintain scalable data solutions that support BI, analytics, and reporting in a Microsoft-centric environment.

The role demands strong ETL/ELT skills, data warehousing expertise, and collaboration with multiple stakeholders. The ideal candidate has solid MS BI stack experience (SSIS/SSAS/SSRS, Power BI), advanced T-SQL, and proven enterprise data warehousing exposure.

Qualifications

• Advanced T-SQL programming and database optimisation.
• Experience with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Proven experience in Data Warehousing, dimensional modelling, and data quality governance.
• Exposure to cloud data platforms and AI-enabled analytics will be advantageous.

Responsibilities

• Design, develop, and maintain ETL/ELT processes and data integration solutions.
• Build and support enterprise data warehouses with dimensional modelling and data marts.
• Translate business requirements into scalable data solutions.
• Develop and optimise SQL queries, stored procedures, and database objects.
• Ensure data quality, governance, and performance across data platforms.
• Develop and maintain reporting capabilities using SSRS and Power BI.
• Collaborate with stakeholders, analysts, architects and project teams to deliver data solutions.
• Support data migration, integration, and modernisation initiatives.
• Participate in data architecture discussions and continuous improvement.

Skills

T-SQL

SSIS

SSAS

SSRS

Power BI

Data Warehousing

Dimensional Modelling

Star Schema

Snowflake Schema

Data Quality

Performance Tuning

CI/CD

Databricks

Microsoft Fabric

AI-enabled Analytics

Data Governance

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, Statistics

Tools

Databricks

Microsoft Fabric

CI/CD tooling

Job description

Be part of our team of Data Specialists and embark on a career of the future!

PBT Group is seeking an experienced and delivery-focused Data Engineer to join our consulting team on a contract basis. The successful candidate will have strong data engineering and data warehousing experience within a Microsoft-centric environment and will be responsible for designing, developing, and maintaining scalable data solutions that support business intelligence, analytics, and reporting requirements.

The ideal candidate will have a solid foundation in the traditional Microsoft BI stack (SSIS, SSAS, SSRS/Power BI), strong SQL development skills, and proven experience in enterprise data warehousing environments. Exposure to cloud-based data platforms and emerging AI-enabled data solutions will be highly advantageous.

Key Responsibilities

Design, develop, and maintain robust ETL/ELT processes and data integration solutions.

Build and support enterprise data warehouse solutions, including dimensional modelling and data marts.

Analyse business requirements and translate them into technical data solutions.

Develop, optimise, and troubleshoot SQL queries, stored procedures, and database objects.

Ensure data quality, integrity, governance, and performance across data platforms.

Develop and maintain reporting and analytics solutions using SSRS and/or Power BI.

Collaborate with business stakeholders, analysts, architects, and project teams to deliver data solutions.

Support data migration, integration, and modernisation initiatives.

Participate in data architecture discussions and contribute to continuous improvement initiatives.

Produce and maintain technical documentation and operational procedures.

Required Skills and Experience

Technical Skills

Advanced T-SQL programming and database optimisation skills.

Solid experience with:

SQL Server Integration Services (SSIS)

SQL Server Analysis Services (SSAS)

SQL Server Reporting Services (SSRS)

Power BI

Strong understanding of Data Warehousing principles and methodologies.

Experience in:

Star and Snowflake schema design

Data quality and reconciliation processes

Experience integrating data from multiple source systems.

Knowledge of performance tuning and optimisation practices.

Data Warehouse & Analytics Experience

Proven experience designing and supporting enterprise data warehouse solutions.

Strong understanding of data modelling concepts and best practices.

Experience supporting reporting, analytics, and business intelligence environments.

Ability to work with large and complex datasets.

Advantageous Skills

Experience with cloud data platforms such as:

Microsoft Fabric

Exposure to Databricks or modern data platform technologies.

Experience with DevOps practices and CI/CD pipelines.

Knowledge of data governance and data management frameworks.

Exposure to AI, Machine Learning, Generative AI, or AI-enabled analytics solutions.

Experience working in consulting or client-facing environments.

Qualifications

Relevant tertiary qualification in Computer Science, Information Systems, Engineering, Mathematics, Statistics, or a related field.

Microsoft certifications will be advantageous.

Personal Attributes

Strong analytical and problem-solving abilities.

Excellent communication and stakeholder engagement skills.

Self-managed and delivery-oriented.

Ability to work independently and within cross-functional teams.

Strong attention to detail and commitment to quality.

Adaptable and able to work across multiple client environments.

Why Join PBT Group?

PBT Group is a leading provider of data, analytics, and technology solutions. We partner with clients across a variety of industries to unlock value from their data and help them make informed business decisions. This role offers the opportunity to work on diverse projects, collaborate with experienced professionals, and contribute to innovative data initiatives.

Skills

Data Engineering Data Warehousing Dimensional Modelling Extract Transform Load (ETL) Power BI SQL SQL Server SSIS