Job Description
Collaborate with stakeholders to gather requirements and define key performance indicators.
Develop robust data models and ETL/ELT pipelines to ingest, transform, and store data.
Design and maintain canonical and semantic data models aligned to business and integration needs.
Ensure data quality and accuracy through validation checks and reconciliations.
Monitor and optimise the performance of our data environment for efficiency and scalability. Works in partnership with Business representatives (e.g. Product Owner, Business Owner) ensuring alignment and value to the customer
Aligns personal values to the company's culture and values.
Takes responsibility for personal development and career pathing.
Subscribes to the company's code of ethics.
Behaves in a manner that enhances the reputation and brand of the department and the company.
Qualifications
Minimum Requirements
Education
BSc in Computer Science, Electronic Engineering, or BCom in Business Information Systems (BIS).
A high-quality Technikon Diploma will also be considered.
A Master's degree is an advantage.
Experience
4 - 6 years' experience in a large organisation (financial services preferred).
Competencies
Technical Competencies:
Core
Strong foundation in data warehousing concepts and ETL/ELT processes.
Query Performance Optimisation, indexing, using rowstore and columnstore databases
Experience using NoSQL platforms like MongoDB, DocumentDB etc.
Hands-on experience with Snowflake, DBT, Airflow.
Proficiency in SQL and Python.
Advantageous:
Knowledge of data virtualisation; experience with Denodo will be a strong advantage.
Experience working with Amazon Q / Kiro