Data Engineer with 4+ years of commercial experience designing, building, and maintaining cloud-based data warehouse and analytics solutions. Strong proficiency in SQL for complex analytical queries, data transformations, and dimensional modeling. Experienced in building ingestion and transformation pipelines using DBT, Snowflake, SSIS, and cloud services on AWS and Azure. Hands-on experience with modern data lakehouse concepts, data observability using Metaplane, and delivering analytics-ready datasets for business intelligence tools.

Simphiwe Thusi

Data Engineer with 4+ years of commercial experience designing, building, and maintaining cloud-based data warehouse and analytics solutions. Strong proficiency in SQL for complex analytical queries, data transformations, and dimensional modeling. Experienced in building ingestion and transformation pipelines using DBT, Snowflake, SSIS, and cloud services on AWS and Azure. Hands-on experience with modern data lakehouse concepts, data observability using Metaplane, and delivering analytics-ready datasets for business intelligence tools.

Available to hire

Data Engineer with 4+ years of commercial experience designing, building, and maintaining cloud-based data warehouse and analytics solutions. Strong proficiency in SQL for complex analytical queries, data transformations, and dimensional modeling. Experienced in building ingestion and transformation pipelines using DBT, Snowflake, SSIS, and cloud services on AWS and Azure. Hands-on experience with modern data lakehouse concepts, data observability using Metaplane, and delivering analytics-ready datasets for business intelligence tools.

See more

Language

English
Fluent

Work Experience

Junior technical associate at Bitanium
January 2, 2020 - December 31, 2020
● Developed dashboards using Power BI, MicroStrategy, and ThoughtSpot. ● Queried and analyzed data using SQL for reporting and insights. ● Created base and derived views in Denodo. ● Gained exposure to Azure cloud technologies and modern data platforms
BI Consultant at Bitnium
January 2, 2021 - August 31, 2022
Clients/Projects Alex Forbes Project ● Analyzed and cleansed data from multiple enterprise sources for analytics dashboards. ● Developed virtualized data views using Denodo to support reporting and BI use cases. ● Participated in UAT and data validation for automated dashboards. Harmony Gold – Data Warehouse Modernization ● Built Denodo views integrating data from Oracle, SQL Server, and flat files. ● Designed and executed test plans to validate data accuracy and performance. ● Built and scheduled SSIS packages to support data ingestion workflows. Investec — Operational Support (Data Platforms) ● Monitored daily ODS batch processes and data workflows. ● Investigated failed jobs in Informatica and applied fixes to restore data loads. ● Monitored Control-M and messaging queues to ensure successful data integration. ● Executed SQL queries to support operational and troubleshooting
Data engineer at Mimecast
September 1, 2022 - Present
Designed and maintained cloud-based data warehouse models (facts and dimensions) in Snowflake using DBT, supporting analytics and large-scale reporting use cases. ● Developed and maintained data ingestion and transformation processes using SSIS, Boomi, and DBT, processing structured and semi-structured datasets. ● Contributed to on-prem to AWS cloud migration, aligning platforms with modern lakehouse-style architectures. ● Built and supported API-driven data ingestion from systems such as Jira, Salesforce, and NetSuite. ● Wrote and optimized complex SQL queries for analytical workloads and transformations. ● Implemented data observability and quality monitoring using Metaplane to proactively detect anomalies. ● Performed unit testing, validation, and deployment of data models into pre-production and production environments. ● Collaborated closely with analysts and engineers, contributing to code reviews and documentation in Confluence

Education

Advance Diploma (BTech) Computer Science at Tshwane University of Technology
January 2, 2021 - January 3, 2023
National Diploma Software development at Tshwane university of technology
January 2, 2016 - January 8, 2020

Qualifications

DBT fundamentals
March 4, 2025 - April 4, 2025
MSCA:SQL 2016 Database Development
January 30, 2026 - January 30, 2026

Industry Experience

Computers & Electronics, Agriculture & Mining, Financial Services

Hire a Database Developer

We have the best database developer experts on Twine. Hire a database developer in Pretoria today.