← All Work
Home Services

KIN Home

Operations data scattered across 3 disconnected systems.

The Problem

KIN Home's operations data lived across a CRM, accounting software, and a field service platform. No single view of the business existed. Leadership was making decisions from gut feel and Excel exports.

Data was stale, inconsistent, and siloed. There was no way to see pipeline + revenue + ops together — you had to open three different tools and reconcile manually.

What I Built

  • →Unified BigQuery data warehouse connecting 3 source systems
  • →Automated ETL pipeline running daily with data quality checks
  • →DOMO executive dashboard surfacing the 8 metrics that drive the business
  • →WAR (Work Acceptance Rate) metric — invented and implemented end to end

The Outcome

  • ✓Single source of truth for the first time in company history
  • ✓Leadership dashboard available every morning without manual work
  • ✓New metric (WAR) now used in weekly ops reviews

Tech Stack

PythonBigQueryDOMOGCPREST APIs

Working on something similar?

Book a free 30-min data audit and see what's possible.

Book a free 30-min data audit →