Summary
Overview
Work History
Education
Skills
Certification
Interests
Core Data Engineering Responsibilities
Personal Information
Professional Endorsements
Accomplishments
Timeline
Generic
Thulasizwe Motsoene

Thulasizwe Motsoene

Senior Data Engineer
Rhodesfield

Summary

A seasoned Senior BI Consultant and Data Engineer with deep expertise in building data solutions using Power BI, SSIS, SSRS, C#, Python, and T-SQL. Skilled in designing end-to-end data pipelines and visual analytics in both on-premises and cloud environments such as Snowflake and Azure. Adept at transforming raw data into business-ready insights, I bring 15+ years of experience delivering scalable, governed, and high-performing BI systems across telecoms, banking, and public sector clients.

Overview

10
10
years of professional experience
2007
2007
years of post-secondary education
4
4
Certifications
3
3
Languages

Work History

Senior BI Consultant

SMD
Johannesburg
09.2024 - Current
  • Led Joint Application Development (JAD) sessions with cross-functional teams to gather and define business requirements, ensuring clarity and alignment with system design.
  • Produced detailed BI functional and technical specifications using standardized templates, incorporating best practices to ensure maintainable and scalable solutions.
  • Aligned user needs with best practice BI architectures, validating solutions against requirement documents and ensuring complete traceability across the BI lifecycle.
  • Designed and developed robust ETL processes using a combination of tools including SSIS for high-performance data extraction and transformation from sources like Oracle, flat files, Data Lakes, and Mainframe (e.g., DB2) systems.
  • Custom ETL packages in C#, utilizing ADO.NET, File IO, and other .NET libraries to build tailored data loaders and transformation engines where out-of-the-box tools were insufficient.
  • Snowflake SQL scripts, Streams, and Tasks for cloud-native ELT, supporting incremental loads and data warehousing logic.
  • Maintained and optimized ETL jobs to load data into data marts and enterprise data warehouses for reporting and analytics.
  • Developed ETL frameworks capable of sourcing from Linux-based systems, automating ingestion with shell scripts and secure FTP processes.
  • Built Power BI datasets, dashboards, and paginated reports (SSRS) to serve stakeholders with real-time and historical reporting needs.
  • Developed business applications using Microsoft PowerApps, creating intuitive, mobile-friendly forms for data entry and approval workflows.
  • Automated business processes using Power Automate (formerly Microsoft Flow) to handle tasks such as automated data collection and approval routing, integration with SharePoint, Outlook, and SQL Server, and triggered ETL processes or notifications based on business logic.
  • Evaluated the impact of all BI system changes, ensuring compatibility across dependent systems and verifying business rules through comprehensive unit and UAT testing.
  • Partnered with business users to conduct User Acceptance Testing (UAT) and peer reviews, validating all outputs against expected results.
  • Ensured that all datasets and reports were built on clean, validated, and auditable data, enabling accurate strategic decision-making.
  • Created self-service BI solutions for users using Power BI, supporting drill-down, slicer-based filtering, and mobile reporting needs.
  • Delivered second-line support for BI tools, including SSIS, SSRS, Power BI, PowerApps, and Snowflake, resolving issues within SLA timelines.
  • Used Splunk to monitor ETL job performance and log analysis across Linux-based systems and application services.
  • Administered database and BI platform security (roles, permissions, access control) across SQL Server, Oracle, Power BI, and Snowflake.
  • Maintained complete system documentation, including ERDs, data dictionaries, technical designs, test scripts, and system integration documentation to support governance and knowledge transfer.

Senior BI Consultant

Cell C
Johannesburg
01.2024 - 08.2024
  • SSIS (Exporting .xml files from third-party applications and performing ETL process to import the files in the MSSQL Database). SSIS Development.
  • Dashboard creation using SSRS, Report builder and PowerBI for the entire credit risk department.
  • Develop Power BI Dashboards for Credit Risk and Market Risk. For Alerting purposes.
  • Translate business needs to technical specifications.
  • Collaborate with teams to integrate systems.
  • Query and execute formulas to prepare data in a suitable format for visualization.
  • Experience in creating dashboards, volume reports, operating summaries, and presentations and graphs.
  • Expert in publishing reports to app.powerbi.com and setting up the necessary connection details and scheduling.
  • Excellent knowledge connecting Microsoft Power BI Desktop to various data sources.
  • Develop Recon Engine tool and File monitoring tool using VB.Net.
  • Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
  • Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
  • Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
  • Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
  • Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
  • Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
  • Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
  • Coordinated with front-end for implementing logic in stored procedures and functions.
  • Supporting initiatives to improve reporting quality.
  • Working with stakeholders at all levels as defined by the individuals project.
  • Improving the quality of the products and services delivered by IT.
  • Assisting with integration and acceptance testing.
  • Supporting the development of training and implementation material.
  • Providing support during and post implementation.
  • Acting as a “translator” between the business and IT.
  • Developing project plans and providing project management assistance.

Senior BI Consultant

SBV Services
Johannesburg
09.2020 - 12.2023
  • Designed, developed, and maintained interactive Power BI dashboards and paginated reports to provide strategic insights across operations, finance, and HR divisions.
  • Collaborated with stakeholders to gather business requirements and translated them into effective BI solutions, enhancing data-driven decision-making processes.
  • Optimized complex T-SQL queries and views to streamline data extraction from SQL Server and Snowflake data warehouses.
  • Implemented Power BI Row-Level Security (RLS) and workspace governance to ensure secure and controlled data access.
  • Automated data refresh cycles and integrated scheduled email subscriptions for executive-level reporting.
  • Led the transition from legacy Excel-based reports to modern, centralized Power BI dashboards, improving report turnaround time by over 50%.
  • Performed data quality checks, validation, and reconciliation to ensure accuracy and integrity of reporting metrics.
  • Provided end-user training and documentation for business units to promote self-service BI adoption across the organization.
  • Participated in the full BI development lifecycle, including requirement analysis, data modeling, visualization design, deployment, and support.
  • Mentored junior analysts and served as the SME (Subject Matter Expert) for Power BI within the BI team.

Principal Consultant

Keyrus
Durban
11.2019 - 08.2020
  • Acted as a BI Consultant deployed at client sites (Selpal and Nedbank), delivering tailored analytics and reporting solutions in fast-paced environments.
  • Designed and developed complex Power BI dashboards to visualize operational KPIs, financial data, and customer behavior trends.
  • Engaged with cross-functional stakeholders to understand data needs and translated them into robust BI models and reporting solutions.
  • Integrated data from multiple sources including SQL Server, APIs, and flat files, ensuring a unified and reliable reporting layer.
  • Developed and optimized SQL scripts, stored procedures, and views to support data models used in Power BI reports.
  • Delivered end-to-end Power BI solutions including DAX measures, data transformations using Power Query (M), and dashboard publication to the Power BI Service.
  • Collaborated with data engineers to implement ETL pipelines and maintain data warehouse structures aligned with business goals.
  • Provided training, documentation, and technical support to business users, enabling self-service analytics and improved data literacy.
  • Supported data governance and compliance efforts by implementing data security practices and managing access through Power BI workspace roles.
  • Ensured consistent delivery of high-quality analytics projects on time and within scope, aligning with Keyrus’s consulting standards.

Senior BI Developer

Standard Bank
Johannesburg
02.2018 - 10.2019
  • Maintaining the ROA 16 Feeds infrastructure for Adaptiv (Credit Risk CIB).
  • Create ETL processes which then the results feed into Adaptiv to manage the banks exposure.
  • Work with Roa(rest of africa calypso feeds) currently we have 16 feeds.
  • Manage the Run the bank calypso feeds.
  • SSIS (Exporting .xml files from third-party applications and performing ETL process to import the files in the MSSQL Database). SSIS Development.
  • Dashboard creation using SSRS, Report builder and PowerBI for the entire credit risk department.
  • Develop Recon Engine tool and File monitoring tool using VB.Net.
  • Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
  • Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
  • Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
  • Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
  • Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
  • Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
  • Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
  • Coordinated with front-end for implementing logic in stored procedures and functions.
  • Consolidating data from various banking systems such as Calypso, Adaptiv, BankMaster, T24 and Finnacle.
  • Creating Data models for Calypso, BankMaster, T24 and Finnacle which are then fed into Adaptiv so that the bank can monitor its exposures.
  • Creating Frameworks for Business Intelligence on how the raw data is consumed and depicted in the Adaptiv System.
  • Supporting initiatives to improve reporting quality.
  • Working with stakeholders at all levels as defined by the individuals project.
  • Improving the quality of the products and services delivered by IT.
  • Assisting with integration and acceptance testing.
  • Supporting the development of training and implementation material.
  • Providing support during and post implementation.
  • Acting as a “translator” between the business and IT.

BI Consultant

Sambe Consulting
Johannesburg
07.2015 - 01.2018
  • Developing Reports using Micro strategy.
  • Analytical Documentation Weekly Ops Presentations and Change Management.
  • SSIS (Exporting .xml files from third-party applications and performing ETL process to import the files in the MSSQL Database). SSIS Development.
  • Dashboard creation using SSRS, Report builder and Power BI.
  • Creating stored procedures is Microsoft Management Studio and Creating Cubes, Dimensions, Hierarchies and KPIs using SSDT.
  • Creating and Configuring Windows 7 Hyper-V Images and also using VMware for Linux Images.
  • Creating Ad-Hoc reports using Microsoft Excel Power Pivot (SSAS), Power view (Maps), SSRS and Geoflow.
  • Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
  • Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
  • Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users.
  • Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
  • Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
  • Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
  • Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.

Education

National Diploma - Information Communication Technology (Development Software)

Tshwane University of Technology
Pretoria
01.2005 - 01.2008

Matric with Exemption -

Tlakula High School
Kwa-Thema
12.2004

Skills

Power BI, Power Automate, PowerApps

SSRS, SSIS and SSAS

  • Snowflake

  • C#/NET

  • VBNET

  • Python

  • SQL Server

  • SharePoint

  • Azure

Certification

Microsoft Certified: Power BI Data Analyst Associate, 04/01/23

Interests

Basketball
Movies
Collecting Basketball Jerseys

Core Data Engineering Responsibilities

  • Develop, schedule, and monitor ETL pipelines using SQL Server Integration Services (SSIS) and Python
  • Design and maintain data models and stored procedures using T-SQL and Snowflake SQL, including developing and optimizing Snowflake stored procedures
  • Build paginated and interactive reports using SSRS and Power BI
  • Design and implement Power BI Row-Level Security (RLS) to control user access to data
  • Create and maintain PowerApps applications to streamline business processes and enhance user interaction
  • Use C# to develop custom data loaders, APIs, and integration utilities
  • Transform and clean datasets from sources such as APIs, flat files, databases, and cloud lakes
  • Deploy solutions to production with error handling, logging, and audit control frameworks
  • Design dashboards and semantic models using Power BI Service and Power BI Desktop
  • Collaborate with stakeholders for requirement gathering, solution design, and user acceptance testing (UAT)
  • Implement version control and CI/CD pipelines using Git and Azure DevOps
  • Apply data security, data quality checks, and governance principles across all data and analytics projects

Personal Information

  • Ethnicity: Black
  • Gender: Male
  • Nationality: South African
  • Driving License: Code C1

Professional Endorsements

  • Mr. K Chipeta, Executive Director, Kukaya Business Solutions, Thulasizwe consistently demonstrated technical expertise and business acumen in delivering BI solutions. His attention to detail and ability to integrate diverse data systems made him a trusted advisor.
  • Miss NZ Mbata, Program Manager, LAWtrust, Thulasizwe led several data automation initiatives with outstanding results. He combined leadership, deep system knowledge, and delivery excellence.
  • Mr. Dirk Coetzee, Specialist, Dept. of Home Affairs, His dashboards and ETL pipelines gave our department real-time insight-revolutionizing how we operate at a national scale.
  • Miss Kali Papatheodosiou, Head CIB Credit Risk, Standard Bank, Thulasizwe's Power BI dashboards significantly improved our credit risk monitoring. His ability to turn business needs into action is unmatched.

Accomplishments

    I assisted Orlando Pirates FC with doing Match Analysis using data from Match Platforms such as StatsBomb and Impact and Created PowerBI dashboards to track player movement during the match

Timeline

Senior BI Consultant

SMD
09.2024 - Current

Senior BI Consultant

Cell C
01.2024 - 08.2024

Senior BI Consultant

SBV Services
09.2020 - 12.2023

Principal Consultant

Keyrus
11.2019 - 08.2020

Senior BI Developer

Standard Bank
02.2018 - 10.2019

BI Consultant

Sambe Consulting
07.2015 - 01.2018

National Diploma - Information Communication Technology (Development Software)

Tshwane University of Technology
01.2005 - 01.2008

Matric with Exemption -

Tlakula High School

Similar Profiles

CREATE PROFILE
Thulasizwe MotsoeneSenior Data Engineer