Enterprise Data Platform for a Multi-State Operation
Unified three core systems into a single automated data platform with real-time dashboards.
The Challenge
A multi-state enterprise was making decisions based on data spread across three disconnected systems:
- The finance/ERP system held all financial data, AR/AP, job costing, contracts, change orders, but reporting required manual exports and Excel manipulation
- The field operations system tracked labor hours and asset usage, but reconciling against budgets required days of manual cross-referencing
- The telematics platform provided real-time GPS and usage data for 100+ assets, but cost data lived in spreadsheets updated weekly
The CFO described it plainly: "We're 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 multi-system operations data.
Source Systems Data Lake Dashboards
(Azure, Client-Owned)
ERP (200+ endpoints) ───▶ Bronze (raw JSON/XML)
│
Field Operations ──────▶ Silver (cleaned) ───▶ Power BI Embedded
│
Telematics (GPS) ───────▶ Gold (business-ready)Bronze Layer: Raw data ingested nightly. ERP via REST API (200+ endpoints cataloged), field operations via API, telematics via webhook. Every record timestamped and versioned.
Silver Layer: Cleaned, typed, and standardized. Job numbers normalized across systems. Asset IDs cross-referenced between the telematics and ERP systems.
Gold Layer: Business-ready datasets combining data across systems, asset cost-per-hour, earned hours, daily cash position.
Pre-Built Dashboards
Cash Position
ERP AR/AP + bank feeds, reconciled daily. 13-week forecast, collections aging.
Earned Hours
ERP budgets vs. field actuals by job and cost code. Real-time variance tracking.
Asset Reconciliation
Telematics GPS hours + ERP asset 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
- Operations leads identify underutilized assets by comparing GPS run-time to billed hours
- Month-end close accelerated because reconciliation data is pre-built and validated daily