Analytics Engineer: Build Scalable Data Models & Pipelines

PBT Group; Cape Town; On-site; ZAR 540,000 - 900,000; Full time

Job summary

PBT Group is seeking an experienced Data Analytics Engineer to join our data engineering team in Cape Town. The role blends data engineering and analytics, focusing on scalable data models and robust data assets for reporting and decision making.

The ideal candidate has strong SQL, data modelling and analytics engineering experience, plus production-grade data solution development in modern data environments.

Qualifications

• Bachelor's or Honours degree in Data, Analytics, Computer Science, Engineering, Information Systems or related field.
• Proven experience in Analytics Engineering, Data Engineering or closely related role.
• Strong experience in SQL and data modelling.

Responsibilities

• Design, develop and maintain scalable data models, data marts and semantic layers.
• Develop robust SQL transformations, data pipelines and production-grade data assets.
• Apply dimensional modelling and data warehousing best practices.
• Implement data validation, testing and quality assurance frameworks.
• Optimise SQL queries, data models and workloads for performance and scalability.
• Develop and maintain reliable transformation code using version control, CI/CD and testing practices.
• Support and troubleshoot production data models and resolve data or performance issues.
• Collaborate with Data Engineers, Data Analysts, Data Architects and business stakeholders to translate analytical requirements into effective data solutions.
• Contribute to data standards, reusable modelling components and technical best practices.
• Participate in code reviews and provide guidance and mentorship to junior team members.
• Identify opportunities to improve data processes, automation and team productivity, including through modern tooling and AI-enabled approaches.

Skills

Advanced SQL

Data Modelling

Data Warehousing

ETL / ELT & Data Transformations

Data Quality & Testing

CI/CD & Version Control

Data Pipelines / Orchestration

Semantic Layer / Data Marts

Cloud Data Platforms

Education

Bachelor's or Honours in Data, Analytics, Computer Science, Engineering, Information Systems

Tools

Airflow

Prefect

dbt

Python

Power BI/Tableau

Job description

PBT Group is seeking an experienced Data Analytics Engineer to join our data engineering team in Cape Town. The role blends data engineering and analytics, focusing on scalable data models and robust data assets for reporting and decision making.

The ideal candidate has strong SQL, data modelling and analytics engineering experience, plus production-grade data solution development in modern data environments.