Makaepea Modjadji
Data Engineer
Cape Town,WC
Summary
Data Engineer with 5+ years of experience transforming complex enterprise data into actionable insights. Strong expertise in data reporting and visualisation, SQL, data modelling, and ETL development within large-scale data warehouse and migration environments.
Experienced in designing dashboards, developing performance reports, and enabling data-driven decision-making through high-quality, governed data. Proven ability to translate business requirements into scalable BI solutions, ensure data accuracy, and support organisational performance through analytical insights and committed to delivering impactful BI solutions
Overview
5
5
years of professional experience
3
3
Certifications
Work History
Data Engineer
Sanlam
01.2023 - Current
- Analyse large, complex datasets to identify trends, patterns, and actionable insights supporting business decision-making.
- Develop SAP Business Objects dashboards to analyse sales performance indicators and generate insights that support upsell and cross-sell opportunities.
- Develop and optimise ETL pipelines using WhereScape, SAP HANA and SQL (Hive/Impala) to support reporting and analytics.
- Build and maintain data models aligned to Data Vault 2.0 for scalable and consistent reporting.
- Perform data validation, reconciliation and quality checks to ensure accuracy and reliability of outputs.
- Investigate and resolve data issues including duplicates, transformation errors and reference data gaps.
- Collaborate with stakeholders to gather requirements and translate them into BI and reporting solutions.
- Lead a sub-team within a migration programme, driving delivery, mentoring team members, and improving processes.
Sanlam Data Academy Trainee
Sanlam
01.2022 - 12.2022
- Applied design thinking principles in a team project to identify process inefficiencies and implement solutions, reducing information processing time by over 50%
- Contributed to a legacy system migration initiative by standardising and consolidating business requirements to ensure consistency and alignment across business stakeholders.
- Developed and maintained ETL workflows using SSIS for data integration and transformation
Data Management Intern
Institute of Health Programs and Systems
01.2021 - 08.2021
- Designed and implemented data collection and reporting frameworks supporting COVID-19 operational monitoring.
- Delivered daily statistical dashboards and reports to enable timely provincial decision-making.
- Performed trend analysis to enhance data quality, reporting accuracy and insight generation using Microsoft Excel and R.
Education
Bachelor of Science - Econometrics
University of Free State
Bloemfontein, South Africa04-2021
Matric -
Harry Oppenheimer Agricultural High School
12-2014
Skills
Business Intelligence and Data Analysis
Dashboard development and Data Visualization
SQL (Hive, Impala, SAP Hana)
Data Modelling
ETL Development
Data quality management and validation
Data governance and compliance
Requirements gathering and stakeholder engagement
Certification
Sanlam Junior Management Program
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
English
Advanced (C1)
Timeline
Sanlam Junior Management Program
12-2024
Design Thinking
05-2023
Modeling Data Warehouse with Data Vault 2.0
02-2023
Data Engineer
Sanlam
01.2023 - Current
Sanlam Data Academy Trainee
Sanlam
01.2022 - 12.2022
Data Management Intern
Institute of Health Programs and Systems
01.2021 - 08.2021
Bachelor of Science - Econometrics
University of Free State
Matric -
Harry Oppenheimer Agricultural High School