Built with datascienceportfol.io

Zuqhame Skosana

Data Specialist

Based in Pretoria, South Africa

About

I am a versatile professional skilled in BI analysis, development, SQL, and data Engineering. I translate complex data into actionable insights, design efficient databases, and ensure seamless data processes. My collaborative approach drives operational excellence and informed decision-making.

Skills

Projects

Experience

2022 - 2023

Data Engineer | Snowflake Specialist

Company: BMW In this role, I used Python to ingest data from various sources, primarily AWS S3 buckets, into the Snowflake data warehouse. I was responsible for cleaning and testing the data, as well as creating and maintaining dashboards to support the team. I documented processes, designed new strategies, and contributed to the knowledge base on Confluence. Additionally, I monitored the Snowflake environment and AWS to ensure smooth operations. I implemented SNS topics to trigger Lambda functions when new data was added to S3, ensuring the data was automatically ingested into the database. I also provided ongoing support to product and other teams using Snowflake and troubleshot software issues by identifying root causes and proposing effective solutions.

2021 -2022

SQL & BI Analyst

Company: Autoboys In this role, I created, edited, and maintained internal business dashboards and reports using Power BI, Tableau, and SSRS. I developed reports for external partners, such as insurance companies, using SSRS and Excel/VBA. I handled business tickets and requests, fixed reports, and provided BI solutions to meet business needs. I utilized Transact SQL, MySQL, and PostgreSQL for data extraction, and cleaned data using Pentaho Spoon and Alteryx/Trifacta. I created, edited, and maintained ETL processes, and used SSRS to build business reports. I also tested business reports and built and maintained dashboards that provided stakeholders with real-time insights into business operations.

2021

SQL & BI developer

Company : Growthpoint properties In this role, I managed projects using Redmine and built visualizations and reports using Power BI, DAX, and Excel. I followed an agile approach for project development and created APIs on the MRI property leasing platform. Additionally, I collaborated with the QA team to test business reports and dashboards.

2020

Junior Software Engineer

Company : Blanktech In this role, I built Android applications and websites, and used Trello to manage tasks and track project progress.

2019 - 2020

Computer Science Tutor

Company: University of Cape Town In this role, I helped students with learning and improving their skills in Python and Java programming languages.

2023 - 2023

Business Intelligence Consultant

Company: Dataflux In this role, I developed Business Intelligence (BI) solutions for external clients, delivering actionable insights and data-driven strategies. As a Power BI Developer, I was responsible for creating interactive and dynamic reports and dashboards to meet business requirements. I wrote and optimized stored procedures to manage, manipulate, and retrieve data efficiently for reporting and analysis.

2023 -

Senior Business Intelligence developer

Company: Momentum I am a Power BI Developer specializing in creating and automating complex paginated reports for business partners. I collaborate with Data Engineers and Data Scientists to design and implement data-driven solutions that improve business intelligence. I develop and maintain data pipelines to ensure seamless data flow and transformation for reporting and analytics. I enhance and optimize reporting tools, ensuring they are efficient, scalable, and meet evolving business needs. I leverage AWS cloud services for data storage, processing, and reporting solutions, ensuring high availability and scalability. I also ensure high-quality data visualization and reporting standards, delivering actionable insights to stakeholders.

2024

Analytics Mentor

Company: High Risers Assist mentees with any Data Analytics, ML, or AI related questions.

Education

2017 - 2020

BCom. Computer Science & Information Systems

● Did a double major, Computer Science, and Information Systems Courses: Computer Science (major), I.T Project Management, Systems Design and Development, Electronic Commerce, Systems Analysis, BPM & Enterprise Systems, Micro-economics, Macro-economics, Statistics, Financial Accounting, Business Accounting, Business Law, Mathematics, Marketing

2012 - 2016

High School

Did Information Technology, Physical Science, Mathematics, Life Sciences, overall grade mark: 80%+

2024 - 2025

Bcom. Hons Information Systems