All projects
Solution2019–2023MANTL

Streaming warehouse + embedded analytics product

AWS-to-GCP migration, realtime Postgres-to-BigQuery streaming, and an embedded Looker product sold to banks.

Problem

A multi-tenant fintech needed a real data product, not a warehouse nobody opened. The company also had to leave AWS for GCP without stalling shipping.

Approach

Migrate clouds without stalling shipping, then stream transactional Postgres into BigQuery and ship an embedded Looker offering as a real data product.

Architecture

Bank data product

Postgres OLTP streamed to BigQuery, modeled in dbt, embedded Looker sold to banks.

Drag nodes to explore the flow

Solution highlights

Cloud migration

AWS to GCP with Terraform for IAM, networking, compute, Glue, and S3 — CI/CD so product and data teams kept shipping.

Realtime replication

Transactional Postgres streamed into BigQuery.

Embedded analytics product

A Looker embedded offering sold to bank and credit union clients.

BigQueryLookerTerraformAWS→GCP