Client stories

Named roles only — logos withheld where NDAs require. These are review and consulting engagements, not product subscriptions.

“We booked the ETL review two weeks before a FSCA reporting freeze. Terra Pipeline flagged that our SCD2 effective dates used server local time instead of Africa/Johannesburg. Fixing that alone justified the spend.”

— Thabo R., head of analytics, short-term insurer

“The handover audit was uncomfortable — our runbook still mentioned a job we retired in 2023. Better to learn that on paper than at 2 a.m.”

— Erin V., platform lead, logistics co-op

“Design session was useful, though I wish we had invited the DBA earlier. Jaco’s notes on index strategy came late for our sprint plan — still valuable for the next phase.”

— Pieter S., product owner, agritech startup

Case note: provincial health aggregates

ETL code review · seven jobs · 2025

A Eastern Cape health NGO exported weekly clinic aggregates from three legacy MySQL instances into Postgres. Incremental loads used MAX(updated_at) without tie-breakers, dropping rows that shared timestamps.

Our review documented the predicate, proposed a composite cursor, and pointed to two tests that would have caught regressions. The client implemented changes before flu season reporting; they have since booked a lighter retest pass.

Case note: e-commerce returns pipeline

Pipeline design session + follow-on review

A Cape Town retailer planned a returns fact table fed from Shopify and an in-house WMS. The design session settled grain at return line, not order, which avoided double-counting partial refunds.

The later review caught an orphaned staging table still referenced in Airflow — removed before go-live.