Data Engineer

Datonomy Solutions; Cape Town; On-site; ZAR 700 000 - 900 000; Full time

Job summary

A technology solutions company in Cape Town is seeking a Data Engineer with retail experience for a 12-month onsite contract. Responsibilities include designing ETL/ELT pipelines, developing data models, and mentoring junior members. The ideal candidate has over 5 years of relevant experience and advanced SQL skills. This role offers a unique opportunity to work in a dynamic environment.

Qualifications

• 5+ years experience with data pipeline design and development.
• Solid hands-on experience in designing and building dashboards.
• Experience conducting unit, integration and regression testing.

Responsibilities

• Design, implement and maintain robust ETL/ELT data pipelines.
• Develop and maintain scalable data models for analytics & reporting.
• Collaborate with teams to translate business requirements into data solutions.

Skills

Data pipeline design and development

Advanced SQL knowledge

Creating dashboards in Pyramid Analytics or PowerBI

Data governance and compliance

Education

Relevant 3-year IT or related qualification

Tools

SQL Server

MySQL

PostgreSQL

Pyramid Analytics

PowerBI

Azure Data Factory

dbt

Job description

Overview

We are seeking a Data Engineer, with retail experience to join our team based in Cape Town. Initial 12-month contract, onsite.

Responsibilities

• Design, implement and maintain robust ETL / ELT data pipelines that constitute the data platform, enabling effective use of data across the organization.
• Develop and maintain scalable data models to support analytics & reporting.
• Continuous enhancements of data models and data warehouse to support analytics & reporting.
• Collaborate with cross-functional teams to translate business requirements into robust data solutions meeting customer expectations.
• Mentor junior members through training and guidance.
• Implement data quality, validation, and data monitoring mechanisms.
• Enforce data governance, security, and compliance best practices.

Qualifications and Experience

• Must have a relevant 3-year IT or related qualification.
• 5+ years experience with Data pipeline design and development experience.
• Advanced SQL knowledge and working with RDBMS such as SQL Server, MySQL and PostgreSQL.
• Solid hands-on experience in designing and building dashboards in Pyramid Analytics or PowerBI.
• Advantageous - Experience in SQL Reporting Services (SSRS), Analysis Services (SSAS) as well as Integration Services (SSIS).
• Advantageous Experience in dbt, Azure Data Factory and cloud platforms.
• Experience conducting unit, integration and regression testing.