Intermediate Analytics Engineer

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.

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. Contact Nokuthula at e-merge.co.za or call her on 011 463 3633 to discuss this and other opportunities.

Are you ready for a change of scenery? E-Merge IT recruitment is a specialist niche recruitment agency. We offer our candidates options so that we can successfully place the right developers with the right companies in the right roles. Check out the e-Merge website www.e-merge.co.za for more great positions.

Do you have a friend who is a developer or technology specialist? We pay cash for successful referrals!

Posted on 15 May 10:53, Closing date 14 Jul