I design and build end-to-end analytics platforms — from raw data pipelines and GCP/AWS data lake architectures through dimensional models, ML, and interactive dashboards. 12+ years across Snowflake, dbt, BigQuery, AWS S3/Glue/Athena, Airflow, Apache Spark, and modern BI stacks. Based in South Africa.
Featured Work
Selected live builds showing working analytics platforms, dashboards, data products, and decision systems.
Snowflake · dbt · Python ML · Data Warehouse
Snowflake and dbt data warehouse for South Africa's parcel pickup network, with PostgreSQL/Parquet ingestion, Snowflake RAW/STAGING/MARTS layers, dbt models, Snowpark-style automation, and 15 Python ML models for return-risk, forecasting, segmentation, and customer value analytics.
Dimensional Modelling · Snowflake · SCD Type 2
Star-schema data warehouse for an employee wellbeing platform. Models corporate counselling sessions, medication sales, and patient experience across 16 tables — with SCD Type 2 history for employee and consent records.
Business Intelligence · CCPB Analytics
Multi-dimensional business intelligence platform for consumer channel and price-by-brand analytics. Covers revenue, trade spend ROI, product health scoring, and a full SKU master — all self-contained HTML dashboards.
GCP · GA4 · GTM · Medallion Architecture · dbt · Airflow · Apache Beam
End-to-end Google Cloud marketing analytics platform: GA4 implementation with GTM datalayer architecture, consent mode quality validation, and a 7-query BigQuery SQL library — feeding into a production medallion pipeline ingesting GA4, Google Ads, Campaign Manager 360, DV360, and YouTube via BigQuery Data Transfer Service. Cloud Dataflow (Apache Beam) validates and quarantines, dbt stages and models, Apache Airflow orchestrates the daily DAG to a cross-channel Gold fact table.
Ecommerce · Web Data · Marketing Analytics · ML
Interactive ecommerce intelligence report for a South African online marketplace. Combines a real 1,000-product catalogue, a million-order behavioural dataset, four years of demand trends, marketing performance, customer lifecycle analytics, recommendation signals, fraud and safety views, plus PDF and Excel deliverables.
Snowflake · dbt · Snowpark ML · Fintech
End-to-end Snowflake fintech data warehouse for African remittance analytics. Bronze→Silver→Gold medallion with dbt (14 models, 28 tests), Snowpark ML (Gradient Boosting + Random Forest with Model Registry), and an interactive Leaflet map — modelling 17 SA-Africa corridors across R78B annual volume.
Databricks Azure · Delta Lake · MLflow · Debt Counselling
Full-stack Databricks Azure data warehouse modelling the South African debt counselling lifecycle (NCA/NCR compliant). 26 PySpark notebooks across 5 medallion layers, Kimball star schema with SHA-256 surrogate keys, ADF orchestration, and 5 ML models across lead conversion, payment default, product recommendation, credit forecast, and client churn.
Azure Databricks · Medallion Architecture · ML · Power BI · Energy
Full-stack Azure Databricks data engineering and ML platform built on 3M+ rows of synthetic SCADA telemetry from 19 African IPP power plants across 7 nations. Bronze→Silver→Gold medallion with ADF orchestration, Azure SQL DW (27 tables, 111 Power BI DAX measures), 9 ML models in MLflow, and an interactive web portfolio — Leaflet.js plant map, Chart.js analytics dashboard, and a complete project ebook.
GA4 · BigQuery · Machine Learning · Ecommerce
ML-powered GA4 ecommerce analytics dashboard with real sklearn models: purchase propensity (AUC 0.73), LTV prediction (R² 0.81), and churn risk (AUC 0.78). Includes a production BigQuery SQL library, GTM container export, consent mode validation, and a GA4 analytics operations ebook.
GA4 · GTM · BigQuery · Consent Mode
Digital analytics implementation covering ecommerce event design, GTM instrumentation, Consent Mode v2, BigQuery-style event analysis, reporting documentation, and a live GitHub Pages case page.
Business Analysis · Systems Analysis · Data Modelling
Business and systems analysis case study: legacy Microsoft Access database audit, business process mapping across the plant variety IP lifecycle, requirements elicitation, and a PostgreSQL migration design. Covers 8 subject areas — licensing, royalty contracts, block management, pathology testing, and import/export permits — with a full ERD and target schema. Synthetic data throughout.
Databricks · Azure Databricks · ADLS Gen2 · ADF · MLflow
Standalone Databricks engine for the Pargo pipeline, developed in Databricks notebooks and deployed through Azure Databricks patterns: ADLS Gen2 landing storage, Azure Data Factory orchestration, Bronze/Silver/Gold Delta notebooks, PySpark cleansing, XGBoost scoring, MLflow tracking, and Databricks Workflow deployment.
Banking · Risk · Data Warehouse · ML
Banking analytics platform covering customer, account, transaction, branch, and risk intelligence. The build presents executive KPIs, portfolio movement, fraud and credit signals, and a structured banking data model for operational decision-making.
Logistics · Fleet · Inventory · ML
Fleet and stock analytics platform for hire operations. Tracks availability, utilisation, maintenance pressure, depot stock movement, customer demand, and predictive signals for operational planning.
FMCG · Product Catalogue · Data Quality
FMCG product analytics platform built around catalogue quality, product families, pack formats, pricing signals, and trusted reporting views. Designed to turn messy product records into a clean commercial intelligence layer.
Oil & Gas · Distribution · Data Warehouse
Oil and gas analytics platform for fuel distribution, branch performance, stock position, margin tracking, and operational control. Built as a live executive dashboard with a practical warehouse-style reporting model.
Property · Market Analytics · Risk
South African property analytics platform for rental yield, vacancy, affordability, regional demand, and investment risk. Built as a live market intelligence product with dashboard views and decision metrics.
Retail · Wellness · Sales Analytics
Retail analytics platform for wellness product performance, branch sales, category health, basket behaviour, and replenishment signals. Built as a live operational dashboard for store and commercial decisions.
FinTech · Lending · Risk · ML
Fintech lending analytics platform for loan book performance, repayment behaviour, risk segmentation, and growth metrics. The live build presents lending KPIs, portfolio quality, and risk indicators in a polished decision dashboard.
Claims · Trust Operations · Intelligence
Claims intelligence platform focused on claimant flow, eligibility signals, trust operations, and payment readiness. Built as a calm operational dashboard for monitoring case progress and evidence completeness.
Accommodation · Booking · Revenue Analytics
Booking analytics platform for accommodation demand, regional performance, occupancy, revenue, and channel behaviour. Built as a live dashboard product for commercial and operational visibility.
Full Stack · WhatsApp API · FastAPI · Supabase
WhatsApp-native artisan marketplace platform for South Africa, built around job intake, AI classification, supplier matching, FastAPI services, Supabase persistence, REST APIs, and a B2B operational dashboard.
Microsoft Fabric · OneLake · Power BI · ML
Microsoft Fabric ecommerce analytics delivery package with OneLake lakehouse design, Power BI semantic layer, DAX measures, reconciliation checks, governance notes, and ML scoring artifacts for product and transaction analytics.
Background
I'm a Data Engineer, Data Architect, and Analytics Specialist based in South Africa, with 12+ years spanning the full analytics stack — from raw ingestion and cloud pipeline architecture through dimensional modelling, machine learning, and executive-ready dashboards.
My work focuses on building production-grade data platforms that serve real business decisions. I enjoy turning messy, high-volume datasets into clean, trusted, and insightful products — whether that's a Snowflake star schema, a GCP medallion pipeline, a Databricks lakehouse, or a trained ensemble ML model.
I design data architecture from scratch: source-to-target flows, Bronze/Silver/Gold layers, dimensional marts, SCD Type 2 history, data-quality quarantine patterns, orchestration, and BI-ready semantic layers.
Cloud-native experience includes BigQuery, Databricks, Delta Lake, Cloud Dataflow (Apache Beam), Apache Airflow, dbt, Apache Spark / PySpark, AWS Lambda, Amazon S3, AWS Glue, Lake Formation, Athena, and QuickSight — alongside Snowflake, SQL Server, PostgreSQL, Microsoft Fabric, Power BI, and Tableau from enterprise BI roles.
Currently open to Data Engineering, Data Architecture, Analytics Engineering, and Senior BI roles — locally and internationally.
Design architecture from scratch — source mapping, medallion/lakehouse patterns, warehouse layers, SCD2 dimensions, data quality gates, and migration roadmaps
Snowflake & BigQuery DWH design, Databricks/Delta pipelines, AWS S3 data lakes, AWS Glue ETL/catalogue, Athena reporting datasets, dbt transformations, Airflow DAGs, Cloud Dataflow (Apache Beam), Spark/PySpark, Apache NiFi, dimensional modelling (star schema, SCD Type 2)
Classification, regression, clustering, forecasting — XGBoost, LightGBM, scikit-learn, MLflow tracking, model validation, and explainability
Power BI, Tableau, SSAS Tabular, DAX, Excel pivot analytics, Chart.js dashboards, executive KPI reporting, and semantic-layer design
GA4 implementation, BigQuery event analysis, GTM datalayer architecture, consent mode quality
Technical Stack
Built over years of hands-on project work across the full data lifecycle.
Get in Touch
Whether you're looking for a data engineer, analytics specialist, or BI consultant — I'd love to hear about your project.