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 & 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. Position Details The reference number for this position is NG61333 which is a Permanent, Hybrid position based in Cape Town offering a cost to company of up to R950k per annum negotiable on experience and ability. #J-18808-Ljbffr