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)
Similar Profiles
Rachel PereiraRachel Pereira
Intermediate Quality Assurance Analyst at RedPanda SoftwareIntermediate Quality Assurance Analyst at RedPanda Software
Bhargav KirneBhargav Kirne
Software Developer at Qvantel software solutions ltd & Nexus Software Limited & Melvault software solutions Pvt LtdSoftware Developer at Qvantel software solutions ltd & Nexus Software Limited & Melvault software solutions Pvt Ltd
Shobha EswaraShobha Eswara
Payroll Specialist at Open Text Software (formerly Autonomy Software)Payroll Specialist at Open Text Software (formerly Autonomy Software)
Christian BandaChristian Banda
Barista at Cafe RiteveBarista at Cafe Riteve
Candice RedheadCandice Redhead
Manager at Foxtini TattoosManager at Foxtini Tattoos