Back to Developers
mahlatse moloko

mahlatse moloko

Data Analyst

Johannesburg, South Africa 10+ yrs exp 90 ยท Outstanding

About

Detail-oriented Data Analyst with hands-on experience collecting, cleaning, and analysing data to support accurate reporting and business decision-making. Skilled in Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, formulas, charts), SQL, and Power BI, with practical experience building dashboards, visualisations, and weekly and monthly business reports. Comfortable validating data accuracy, maintaining data integrity, and documenting analysis processes for both technical and non-technical stakeholders. Strong analytical and problem-solving skills, with experience supporting cross-functional teams, working independently, and delivering reliable insights in fast-paced, deadline-driven environments.

Skills & Expertise (46)

Data Cleaning Advanced
8.5/10
8
Years Exp
Data organisation Advanced
8.5/10
8
Years Exp
SQL querying Advanced
8.5/10
8
Years Exp
Data Manipulation Advanced
8.5/10
8
Years Exp
Data collection Advanced
8.5/10
8
Years Exp
Data visualisation Advanced
8.5/10
8
Years Exp
Power BI Advanced
8.5/10
8
Years Exp
SQL Server Management Studio Advanced
8.0/10
8
Years Exp
ETL Processes Advanced
8.0/10
8
Years Exp
Statistical Analysis Advanced
8.0/10
8
Years Exp
Azure Data Factory Advanced
7.5/10
4
Years Exp
DAX Advanced
7.5/10
4
Years Exp
Azure Storage Qlik SSIS Analytical Thinking Logical Problem-solving Visual Studio Code Databricks Big Query Snowflake SAP BI BAS Communication Attention to Detail Problem-solving Stakeholder Engagement Data Validation Pivot Tables VLOOKUP XLOOKUP Formulas Charts Dashboard Development Trend Analysis Pattern Analysis Business Reporting Analytical Problem-Solving Data Accuracy Data Integrity Data Preparation Documentation stakeholder communication Presentation Cross-Functional Team Collaboration Independent Work

Work Experience

Data Analyst

Department of Home Affairs

Nov 2023 - Present

Collect, clean, and organise data from multiple sources, ensuring accuracy and consistency ahead of analysis and reporting. Analyse large and complex datasets to identify trends, patterns, anomalies, and business insights that support operational and strategic decision-making. Create reports, dashboards, and visualisations using SQL, Excel, and Power BI to communicate findings clearly to stakeholders. Assist in preparing weekly and monthly business reports and management presentations. Validate data accuracy and maintain data integrity across multiple reporting outputs and data sources. Write SQL queries to retrieve, manipulate, and reconcile data in support of reporting and analysis. Document analysis processes and present findings clearly to both technical and non-technical audiences. Collaborate with cross-functional teams and stakeholders to understand business requirements and deliver relevant, accurate, and timely analytical outputs. Identify manual reporting inefficiencies and contribute to improved reporting workflows and data processes. Analyse patterns and trends related to risk, operational performance, and case activity to support action planning and decision-making.

ICT System Controller

Department of Provincial Treasury

Aug 2015 - Oct 2023

Supported financial and administrative systems, including SAP BI (Finance), PERSAL, and BAS, across Gauteng Provincial Government departments. Conducted data preprocessing, cleaning, transformation, normalisation, standardisation, and visualisation to improve reporting quality and data usability. Designed, built, and deployed BI solutions and reporting tools to improve monitoring, analysis, and decision-making. Gathered business and user requirements and translated them into functional documentation and reporting solutions. Provided user training and guidance on data processes and system workflows, and developed standard templates to improve data accuracy and consistency. Investigated the causes of recurring data and system issues and made recommendations for solutions. Conducted user acceptance testing and validation of reports and system changes to ensure accuracy and functionality. Documented business processes and maintained systems and reporting documentation. Monitored compliance with data governance policies, procedures, and quality standards.

Education

Bachelor of Science Honours in Computer Science - University of South Africa

- ยท Afghanistan

Advanced Diploma in Information Resources Management - University of South Africa

- 2022 ยท Afghanistan

National Diploma in Financial Information Systems - Tshwane University of Technology

- 2011 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 15/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 90/100

Profile Overview

Member sinceJul 2026

Availability Details

Visa Status

Need Sponsorship

Relocation

Depends on Offer