Analytics Engineer — Data Pipelines & Modeling

Capitec; Stellenbosch; On-site; ZAR 500,000 - 650,000; Full time

Job summary

Capitec is looking for an experienced analytics engineer to design and maintain production-ready data models that transform raw data into usable datasets. The ideal candidate will have at least 5 years of experience in analytics engineering, with strong SQL and Python skills. You will work closely with teams to ensure quality and governance in data processes. The role offers the opportunity to influence design decisions and mentor junior engineers while working in a collaborative environment.

Qualifications

• 5+ years' experience in analytics engineering or a closely related data role.
• Proven experience in production data models and pipelines.
• Strong data modelling capability for business‑ready datasets.
• Advanced SQL skills and experience using Python for data transformation.
• Experience with cloud data platforms and workflow orchestration tools.
• Solid understanding of data quality, governance, and documentation.
• Experience influencing technical decisions with stakeholders.

Responsibilities

• Design and maintain production‑ready data models from raw data.
• Develop scalable data transformations with validation and testing.
• Create semantic layers and logic for reporting and analysis.
• Maintain and troubleshoot live data models, improving performance.
• Influence design decisions balancing quality and sustainability.
• Guide less experienced engineers through reviews and coaching.

Skills

Analytical Skills

Communication Skills

Planning, organising and coordination skills

Problem solving skills

Reporting Skills

Education

Bachelor's Degree in Analytical/Data/Technical or Other

Tools

Airflow

Prefect

Python

Job description

Capitec is looking for an experienced analytics engineer to design and maintain production-ready data models that transform raw data into usable datasets. The ideal candidate will have at least 5 years of experience in analytics engineering, with strong SQL and Python skills. You will work closely with teams to ensure quality and governance in data processes. The role offers the opportunity to influence design decisions and mentor junior engineers while working in a collaborative environment.