Modern BI and marketing analytics platform
Migrated legacy reporting from Looker Studio to Omni, rebuilt marketing ingestion, and put governed KPIs on Snowflake.
- Snowflake
- Omni BI
- AWS
- Meta Ads
12
BI tools evaluated before Omni was selected
problem
Legacy dashboards depended on Looker Studio and a third-party connector stack. Marketing teams needed trusted numbers, faster reporting, and a BI tool they could grow into.
build
Ran requirements discovery, evaluated 12 BI tools, chose Omni, built custom AWS connectors for marketing APIs, ingested data into Snowflake, reverse engineered dashboards, and modelled clean KPI layers.
impact
Delivered governed self-serve reporting for ROAS, CPA, CTR, LTV, attribution, and other KPIs, with infrastructure managed through Terraform and CI checks in GitHub Actions.
stack -- Snowflake / Omni BI / Looker Studio / AWS / Terraform / SQL / Python / Node.js / GitHub Actions / CodeRabbit / TikTok Ads API / Meta Ads API / AppsFlyer API / Google Ads API