Enterprise Data Platform for a $500M General Contractor
Unified CMiC, HCSS, and Samsara into a single automated data platform with real-time dashboards.
The Challenge
A $500M general contractor was making decisions based on data spread across three disconnected systems:
- CMiC held all financial data — AR/AP, job costing, contracts, change orders — but reporting required manual exports and Excel manipulation
- HCSS HeavyJob tracked field labor hours and equipment usage, but reconciling against CMiC budgets required days of manual cross-referencing
- Samsara provided real-time GPS and telematics for 100+ pieces of heavy equipment, but fleet cost data lived in spreadsheets updated weekly
The CFO described it plainly: "We're a $500M company making daily financial decisions on weekly data."
The Solution
Lumbridge built an automated data platform connecting all three source systems into a centralized Azure data lake using a medallion architecture designed for construction data.
Source Systems Data Lake Dashboards
(Azure, Client-Owned)
CMiC (200+ endpoints) ──▶ Bronze (raw JSON/XML)
│
HCSS HeavyJob ─────────▶ Silver (cleaned) ───▶ Power BI Embedded
│
Samsara (GPS) ──────────▶ Gold (business-ready)Bronze Layer: Raw data ingested nightly. CMiC via REST API (200+ endpoints cataloged), HCSS via API, Samsara via webhook. Every record timestamped and versioned.
Silver Layer: Cleaned, typed, and standardized. Job numbers normalized across systems. Equipment IDs cross-referenced between Samsara and CMiC.
Gold Layer: Business-ready datasets combining data across systems — fleet cost-per-hour, earned hours, daily cash position.
Pre-Built Dashboards
Cash Position
CMiC AR/AP + bank feeds, reconciled daily. 13-week forecast, collections aging.
Earned Hours
CMiC budgets vs. HCSS actuals by job and cost code. Real-time variance tracking.
Fleet Reconciliation
Samsara GPS hours + CMiC equipment rates. Utilization, cost per hour, idle time.
Overhead Expenses
Actual vs. budget by department with trend analysis. No more month-end surprises.
The Results
- CFO has daily cash visibility without asking anyone to run a report
- Project managers see earned hours variance in real time, enabling mid-job corrections
- Fleet manager identifies underutilized equipment by comparing GPS run-time to billed hours
- Month-end close accelerated because reconciliation data is pre-built and validated daily