Analytics Engineer II: Build Scalable Data Models

Capitec Ltd; Stellenbosch; On-site; ZAR 700,000 - 1,000,000; Full time

Job summary

Capitec Ltd is seeking an Analytics Engineer to design and maintain production data models and pipelines, turning raw data into trusted datasets for analytics across the business.

The role requires advanced SQL, Python for data transformation, and experience with cloud data platforms and orchestration tools like Airflow or Prefect. Collaboration with engineering and analytics teams is essential.

Qualifications

• Bachelor's degree in analytics/data/technical field.
• Honours degree in analytics/data/technical or engineering preferred.
• 5+ years in analytics engineering or related data role.

Responsibilities

• Design, build and maintain production data models.
• Develop scalable data transformations with validation, testing and QC.
• Create semantic layers and aggregation logic for reporting/analysis.
• Maintain and troubleshoot live data models; improve performance.
• Lead design decisions and coach junior engineers.

Skills

SQL

Python

Airflow

Prefect

Data modelling

Data governance

CI/CD

Testing

Stakeholder management

Education

Bachelor's degree in analytics/data/technical or related

Honours degree in analytics/data/technical or engineering

Tools

Airflow

Prefect

Job description

Capitec Ltd is seeking an Analytics Engineer to design and maintain production data models and pipelines, turning raw data into trusted datasets for analytics across the business.

The role requires advanced SQL, Python for data transformation, and experience with cloud data platforms and orchestration tools like Airflow or Prefect. Collaboration with engineering and analytics teams is essential.