An enterprise analytics platform built from dozens of sources
Dozens of disconnected systems turned into one governed, self-service analytics platform.
Data sat in dozens of SaaS tools, databases, partner feeds, and spreadsheets. Reports took days to build and rarely agreed.
- Ingestion with Fivetran for SaaS sources and Airbyte for custom and long-tail feeds
- Raw data landed in Snowflake, secured with key-pair service accounts and role-based access
- dbt models in dbt Cloud: tested staging, intermediate, and mart layers with lineage
- A LookML semantic layer in Looker for governed, self-service metrics
- One source of truth with shared metric definitions
- Automated refreshes, with tests that catch issues before dashboards do
- Self-service exploration, and a foundation ready for AI