Open to opportunities

Sphiwe Motsoene

@sphiwemotsoene

Message

Senior Data Engineer with expertise in BI solutions and data analytics.

South Africa

Message

What I'm looking for

I am looking for a role that fosters innovation and collaboration, where I can leverage my data engineering skills to drive impactful business solutions.

I am a seasoned Senior BI Consultant and Data Engineer with over 15 years of experience in building robust data solutions. My expertise lies in utilizing tools like Power BI, SSIS, SSRS, C#, Python, and T-SQL to design end-to-end data pipelines and visual analytics. I have successfully delivered scalable and high-performing BI systems across various sectors, including telecoms, banking, and public services.

Throughout my career, I have led cross-functional teams in Joint Application Development (JAD) sessions to gather business requirements and ensure alignment with system design. My role has involved producing detailed BI specifications, developing ETL processes, and creating self-service BI solutions that empower users to make data-driven decisions. I am passionate about transforming raw data into actionable insights and have a proven track record of enhancing reporting quality and efficiency.

Experience

Work history, roles, and key accomplishments

Current

Senior BI Consultant

Current

SMD

Sep 2024 - Present (9 months)

Led Joint Application Development (JAD) sessions and produced detailed BI functional and technical specifications. Designed and developed robust ETL processes using SSIS, C#, and Snowflake SQL scripts, supporting incremental loads and data warehousing logic. Built Power BI datasets, dashboards, and paginated reports (SSRS) while automating business processes with Power Automate and developing appl

Power BI SSIS C#)Python T SQL Snowflake Microsoft PowerApps Power Automate Azure

Senior BI Consultant

Cell C

Jan 2024 - Present (1 year 5 months)

Developed Power BI Dashboards for Credit Risk and Market Risk, translating business needs into technical specifications. Created dashboards, volume reports, operating summaries, and presentations using SSRS, Report Builder, and Power BI. Developed Recon Engine and File Monitoring tools using VB.Net, and managed ETL processes with SSIS.

Power BI SSIS VB.NET SQL Server ETL Data Visualization T SQL

Senior BI Consultant

SBV Services

Sep 2020 - Present (4 years 9 months)

Designed, developed, and maintained interactive Power BI dashboards and paginated reports for strategic insights. Optimized complex T-SQL queries and views, implementing Power BI Row-Level Security (RLS) and workspace governance. Led the transition from legacy Excel-based reports to modern Power BI dashboards, improving report turnaround time by over 50%.

Power BI T SQL SQL Server Snowflake Data Warehousing ETL Data Quality Data Modeling

Principal Consultant

Keyrus

Nov 2019 - Present (5 years 7 months)

Acted as a BI Consultant, delivering tailored analytics and reporting solutions at client sites. Designed and developed complex Power BI dashboards to visualize operational KPIs, financial data, and customer behavior trends. Integrated data from multiple sources and optimized SQL scripts to support data models.

Power BI SQL Server APIs ETL Data Modeling DAX Power Query Data Governance Consulting

Senior BI Developer

Standard Bank

Feb 2018 - Present (7 years 4 months)

Maintained ROA 16 Feeds infrastructure for Adaptiv (Credit Risk CIB) and created ETL processes to feed results into Adaptiv. Developed Recon Engine and File Monitoring tools using VB.Net. Consolidated data from various banking systems and created data models for exposure monitoring.

SSIS Power BI VB.NET ETL SQL Server Data Modeling Credit Risk Data Consolidation

BI Consultant

Sambe Consulting

Jul 2015 - Present (9 years 11 months)

Developed reports using MicroStrategy and created stored procedures in Microsoft Management Studio. Built Cubes, Dimensions, Hierarchies, and KPIs using SSDT. Created Ad-Hoc reports using Microsoft Excel Power Pivot, Power View, SSRS, and Geoflow.

Microstrategy Microsoft SSRS SSIS SQL Server SSAS ETL Data Warehousing Power Pivot Data Visualization

Education

Degrees, certifications, and relevant coursework

Tlakula High School

Matric with Exemption, General Studies

Achieved Matric with Exemption, demonstrating strong academic performance across various subjects. Focused on core subjects including English, IsiZulu, Mathematics, Science, Biology, and Accounting.

Tshwane University of Technology

National Diploma, Information Communication Technology (Development Software)

Completed a National Diploma in Information Communication Technology with a focus on Development Software. Gained foundational knowledge and practical skills in software development.