Data WarehouseBI & Data Pipeline · In production

Data Warehouse — the BI backbone

Every channel in one place — real-time P&L, attribution, and AI drafting.

RoleArchitect & BuilderIntegrations, P&L, attribution
Sources5+ channelsAds · Shopify · Medusa · PostHog · Pinterest
StackExpress · React · LLMGoogle APIs · Drizzle/Neon

The context

Decisions were scattered across five dashboards that never agreed. There was no single, trustworthy view of what made money.

The Data Warehouse is the backbone the other systems read from. It integrates Google Ads, Shopify, Medusa, PostHog and Pinterest, computes real-time P&L and attribution, watches tag health, and drafts outbound email with an LLM. It is the source of truth that lets agents and humans reason about the business from the same numbers.

What I built
Data PipelineReal-time P&LAttributionTag HealthAI DraftingMulti-source Integration
Stack
ExpressReactLLMGoogle APIsPostHogShopifyMedusaDrizzleNeon

The pipeline

one source of truth
  Ads · Shopify · Medusa · PostHog · Pinterest
     │      │       │        │         │
     └──────┴───────┴────────┴─────────┘
                    ▼
        ┌─────────────────────────────┐
        │     Data Warehouse            │
        │  real-time P&L · attribution   │
        │  tag health · AI drafting   │
        └─────────────────────────────┘
                    │  read by
                    ▼
        agents · Ads-OS · the dashboards
5+
Channels unified into one trustworthy view.
Realtime
P&L and attribution, not next-day exports.
Backbone
The source of truth the other systems read.