Summary
Overview
Work History
Education
Skills
Core Competencies
Certification
Timeline
Generic

Sigcino Ntshangase

Data & Business Intelligence Specialist
Cape Town,WC

Summary

Results-driven Data & Analytics Specialist with over 2 years of experience in data analysis, business intelligence, and data warehouse management. Proficient in SQL, Power BI, and AWS, with a strong track record of aiding in robust ETL processes design, developing performance dashboards, and delivering high-impact insights that support strategic business decisions.

Demonstrated ability to collaborate effectively with stakeholders and cross-functional teams to ensure data accuracy, streamline reporting, and enhance operational efficiency.

Committed to data quality and continuous improvement, with a strong passion for learning and leveraging technology to drive business growth.

Overview

2026
2026
years of professional experience
2033
2033
years of post-secondary education
3
3
Certifications

Work History

QA Data Analyst

RedPanda Software
01.2025 - Current
  • Developed monitoring reports for newly built Data Warehouse (Consumer, Replayer, Recovery Tools) to detect processing failures, transaction spikes, and latency issues, improving data flow visibility and reliability.
  • Built advanced SQL queries drawing from multiple data sources to support reporting, analytics, and ad hoc investigations across retail operations.
  • Conducted rigorous testing of client-facing reports, validating SQL logic and outputs against source tables and the enterprise data warehouse to ensure accuracy and consistency.
  • Designed and maintained a performance dashboard to track and visualize data warehouse performance metrics and system health.
  • Resolved complex SQL exceptions, including handling incorrect CLOB data in the data warehouse, ensuring seamless data integration and access.
  • Performed end-to-end analysis of the Flash reporting system, mapping report codes to source systems and verifying data accuracy.
  • Created logic to identify undelivered invoiced items, helping to trace missing items back to specific branches for resolution.
  • Supported retail operations across 900+ branches, providing data solutions to improve reporting accuracy and operational decision-making.
  • Debugged and corrected logic errors in stored procedures responsible for generating branch-level reports.
  • Led investigations into data inconsistencies, identifying root causes and implementing corrective actions.
  • Accountable for ensuring data quality and integrity across all reporting and analysis processes.
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Integrated multiple sources of data into cohesive datasets using ETL processes, improving overall analytic capabilities.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Generated ad-hoc reports to evaluate specific business requirements.
  • Generated standard and custom reports to provide insights into business performance.

Data Platform Support Analyst

Montego Pet Nutrition
12.2023 - 08.2024
  • Conducted regular data quality audits, identifying inconsistencies and implementing corrective actions to ensure data accuracy and reliability.
  • Optimized database performance by monitoring system health and applying tuning recommendations, enhancing efficiency.
  • Developed detailed documentation on database architecture, streamlining future upgrades and simplifying maintenance tasks.
  • Ensured data integrity and consistency across systems through effective data synchronization techniques.
  • Assisted in the development of internal tools to streamline workflows, improving overall team productivity and operational efficiency.
  • Delivered high-quality documentation including technical specifications, user guides, troubleshooting procedures, and best practices for solution utilization.
  • Managed incoming data analytics requests, efficiently distributing results to stakeholders to support decision-making.
  • Collaborated on ETL processes, ensuring data integrity and verifying pipeline stability.
  • Supported ad hoc data requests from end-users, delivering accurate datasets in a timely manner.
  • Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks and addressing them before they impacted operations.
  • Resolved production issues quickly, minimizing downtime and ensuring high levels of user satisfaction.
  • Created an end-to-end pipeline solution on Azure using Synapse Analytics to transfer data from a SharePoint site to a Data Lake table, ensuring seamless data flow and storage optimization.

Intern: Data and Analytics

Clickatell
02.2023 - 12.2023
  • Developed and optimized in-application SQL queries to extract and analyze data from multiple sources, improving reporting efficiency.
  • Collaborated with system architects and design analysts to gather and refine business requirements, driving project design and implementation.
  • Led requirements gathering and project design, ensuring alignment with business objectives and overseeing successful project delivery.
  • Applied advanced problem-solving techniques to identify and resolve operational issues, optimizing business processes.
  • Analyzed large datasets (including chat, backlog, and operations data) to provide actionable insights for customer service improvements.
  • Created and presented customized reports with data visualizations to enhance stakeholder decision-making.
  • Developed and updated SQL scripts to automate data extraction, enhancing reporting accuracy and efficiency.
  • Documented analysis results and provided performance feedback, contributing to continuous improvement.
  • Collaborated with senior Data Engineers on ETL processes, ensuring data integrity and pipeline stability.
  • Cleaned and processed data to ensure proper handling and quality for analysis.
  • Diagnosed and resolved data pipeline issues, ensuring continuous data flow and integrity.
  • Collaborated with seniors on configuring ETL pipelines for data ingestion into data lakes, optimizing data transfer and processing efficiency.
  • Developed and maintained comprehensive documentation for data processes, APIs, and data sharing protocols.
  • Collaborated with seniors on implementing secure data export pipelines via SFTP and AWS S3, improving external data exchange.
  • Collaborated with business intelligence teams to create interactive dashboards and visualizations for enhanced data insights.
  • Designed a SharePoint landing page for easy access to data resources, improving usability and team productivity.

Online Shopping Assistant

Mr D Food
11.2021 - 01.2023
  • Delivered exceptional customer service by resolving inquiries efficiently, achieving a 98% satisfaction rate.
  • Improved daily operations through proactive problem-solving and effective coordination.
  • Ensured accurate order processing and timely resolution of discrepancies to maintain operational efficiency.

Administrative Aide

Mbangomuni Cleaning Services
7 2019 - 11.2020
  • Streamlined document organization by implementing an efficient record filing system, enhancing accessibility.
  • Managed incoming communications, including calls and mail, ensuring timely delivery to appropriate recipients.
  • Edited and maintained company documents to improve accuracy, readability, and alignment with organizational goals.

Mentor

Silene PSO
10.2018 - 09.2019
  • Guided first-year students in adjusting to university life, offering support on academic and personal challenges.
  • Conducted group sessions to teach organizational, time management, and study skills, fostering academic success.
  • Encouraged wellness and career exploration through workshops and individual mentoring.

Education

Bachelor of Science - Biology, Psychology & BioInformatics

University of Stellenbosch
02.2018 - 12.2022

Certificate - Data Analysis

University of Cape Town
04.2022 - 06.2022

MicroMasters® Data, Economics, Design of Policy

Massachusetts Institute of Technology (MITx)

Skills

Programming: SQL (PostgreSQL, MySQL, T-SQL, Sybase IQ) , Python programming, R programming

Core Competencies

  • ETL Pipeline Development & Data Integration
  • Business Intelligence & Dashboard Design
  • Data Analysis & Statistical Modeling
  • SQL (PostgreSQL, MySQL, T-SQL)
  • Python & PySpark Programming (Microsoft Fabric)
  • Cloud Technologies (AWS S3, Redshift, Athena, Azure, Blob storage)
  • Data Visualization (Power BI, Tableau)
  • Stakeholder Engagement & Requirements Gathering

Certification

Business Intelligence Analyst – SQL, Python & Tableau (Udemy)

Timeline

Apache Superset for Data Engineers, Udemy

04-2025

QA Data Analyst

RedPanda Software
01.2025 - Current

Business Intelligence Analyst – SQL, Python & Tableau (Udemy)

10-2024

DP 900: Microsoft Certified, Azure Data Fundamentals

06-2024

Data Platform Support Analyst

Montego Pet Nutrition
12.2023 - 08.2024

Intern: Data and Analytics

Clickatell
02.2023 - 12.2023

Certificate - Data Analysis

University of Cape Town
04.2022 - 06.2022

Online Shopping Assistant

Mr D Food
11.2021 - 01.2023

Mentor

Silene PSO
10.2018 - 09.2019

Bachelor of Science - Biology, Psychology & BioInformatics

University of Stellenbosch
02.2018 - 12.2022

Administrative Aide

Mbangomuni Cleaning Services
7 2019 - 11.2020

MicroMasters® Data, Economics, Design of Policy

Massachusetts Institute of Technology (MITx)
Sigcino NtshangaseData & Business Intelligence Specialist