Intermediate Analytics Engineer (Cape Town)

We are seeking an Intermediate Analytics Engineer to design, build, and optimize scalable analytics data models and pipelines. In this role, you will play a key part in enabling high-quality business intelligence by developing robust data foundations that support reporting, analytics, and decision-making across the organisation.

You will work closely with data analysts, engineers, and business stakeholders to deliver reliable, well-structured, and well-documented data solutions.

Responsibilities:

• Design and implement relational, dimensional, and domain-specific semantic data models, applying strong data normalization principles.
• Develop, maintain, and optimize analytics pipelines using dbt, SQLMesh, or similar modern transformation tools.
• Implement and monitor data quality frameworks using tools such as dbt tests and SodaCL to ensure trusted datasets.
• Build and maintain dashboards and reports using Power BI and Excel.
• Collaborate with cross-functional teams to gather requirements and translate them into scalable data solutions.
• Maintain comprehensive documentation of data models, pipelines, and data processes.
• Use Git and Azure DevOps or GitHub for version control, code reviews, and CI/CD workflows.
• Apply knowledge of modern data architecture concepts, including open table formats (Delta Lake, Apache Hudi, Apache Iceberg), lakehouse architectures, and data sharing frameworks (e.g., Delta Sharing, Redshift Data Sharing).
• Contribute to the adoption and evolution of data mesh principles within the organisation.

Qualifications and experience:

• Bachelor’s degree in computer science, information systems, data science, or a related field.
• Proven experience in analytics engineering, data engineering, or data analytics roles.
• Strong proficiency in SQL, Python, and data modelling principles.
• Hands-on experience with dbt, SQLMesh, or similar transformation frameworks.
• Familiarity with Git and CI/CD pipelines.
• Understanding of open table formats and modern lakehouse architectures.
• Strong analytical thinking, problem-solving, and communication skills.
• Certification in analytics engineering, data engineering, or cloud platforms (Azure, AWS, GCP).
• Experience working with cloud data platforms such as Azure Synapse, AWS Redshift, or Google BigQuery.
• Knowledge of software engineering best practices and agile delivery environments.