Data Engineer at Datonomy Solutions

About the position

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

Key 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.

Desired Skills:

• Data
• Engineer
• ETL