Data Engineer - Microsoft BI & Data Warehouse Expert

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

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.