Intermediate Analytics Engineer (SQL, Python) - Johannesburg - up to R950k per annum

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.

The Reference Number for this position is NG61333which is a Permanent, Hybrid position based in Cape Town offering a cost to company of up to R950k per annumnegotiable on experience and ability. Contact Nokuthula at Apply Now or call her on Apply Now 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!