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.