Engagement 01 · Trovo.ai · approximately 2020–2021
When platform economics become business risk.
Trovo operated a multi-partner data cooperative. Its AWS Glue-heavy processing model worked technically, but its economics had become unsustainable as the company continued onboarding partners.
Historical cloud expenditure was approaching approximately US$1 million annually. Sorting, aggregation, and grouping workloads were consuming enough Glue capacity that infrastructure cost threatened the viability of the business.
Brandon investigated alternatives and formed the view that Snowflake could perform the analytical and transformation work more economically. Instead of asking the company to accept a wholesale migration on theory, he selected a representative production workload and built a proof of concept.
The measured result established technical feasibility and the economic case. That production evidence secured support for a broader migration, which Brandon then led.
Established outcomes
A more sustainable data platform.
- approximately US$900,000
- in annual infrastructure savings
- 100+
- Snowflake databases administered across approximately 40 partners
- approximately 15 PB
- in the broader governed multi-partner data estate
- Hours
- for partner onboarding that had previously taken weeks or months
Platform & governance
Migration was only part of the work.
The resulting platform combined Amazon S3, Amazon SNS, Snowpipe, Snowflake, Kubernetes/EKS, Terraform, and custom AWS automation. S3 events flowed through SNS into ingestion or processing pipelines. Snowpipe supported continuous ingestion, while one-off EKS workloads handled specialized processing without keeping every form of compute permanently active.
Brandon also administered the Snowflake environment: creating and sizing virtual warehouses against business service-level objectives, tuning workloads before adding compute, applying auto-suspend where appropriate, and monitoring spend and long-running queries.
Least-privilege roles and grants, access conventions, and database and object naming standards established clearer governance. The naming and organization model preserved the relationship between information and its contributing partner instead of allowing provenance to disappear into an undifferentiated data lake.
Infrastructure was managed with Terraform and checked routinely for drift. The approximately 12-account AWS estate used AWS Organizations, identity-provider-based SSO, MFA, least-privilege controls, and Teleport-based access.