Platform Overview

Built for Eastern US multifamily.
Every interval. Every building.

Sparko Pulse ingests 15-minute Green Button interval data from major Eastern US utilities, normalizes it across your portfolio, and surfaces the analytics you need to manage compliance, benchmark performance, and act on anomalies.

By the numbers
15min
Interval resolution
24mo
Historical backfill
ET
Eastern Time utility coverage
EGC §8.5
Compliance-ready reports
Data Ingestion

Green Button Connect-My-Data

Authorize once. Sparko automatically polls your utility's Green Button endpoint daily, ingests new ESPI Atom intervals, and stores everything as normalized kWh / therms / gallons in your portfolio database.

ESPI Green Button XML
Parses the full Atom feed — UsagePoint, MeterReading, IntervalBlock — and deduplicates overlapping backfills.
OAuth token rotation
Access tokens are AES-256-GCM encrypted at rest. The daily poll Lambda auto-refreshes on 401 and retries without manual intervention.
Water bill PDF upload
Municipal water bills get OCR'd and merged with electric/gas data for whole-building EUI calculations.
Analytics Engine

From intervals to insight

Every night, Sparko rolls 15-minute reads into monthly aggregates, computes building EUI, runs anomaly detection, and updates compliance readiness — all automatically.

EUI Benchmarking
kBtu/sqft/yr computed per building and portfolio-wide, stacked against CBECS national/regional medians and your own portfolio baseline.
Anomaly Detection
Statistical z-score over trailing 12 months flags usage spikes and drops by building and utility type. Configurable sensitivity per property.
Coverage Matrix
Trailing-12-month heatmap shows which building × month cells have data, which are missing, and which are N/A (pre-account). Drives EGC readiness score.
Peak Demand
Monthly kW peaks extracted from 15-min intervals. Demand-charge analysis add-on shows cost exposure at each utility's ratchet threshold.
Infrastructure

Production-grade from day one

→
AWS Lambda
Serverless compute for daily polling, anomaly detection, and monthly aggregation — EventBridge cron + S3 triggers. Zero idle cost.
→
Neon Postgres
Vercel-provisioned serverless Postgres. Schema under strict Drizzle migrations; 25 tables, multi-tenant RBAC.
→
Vercel Edge
Next.js App Router deployed to Vercel with Cloudflare DNS-only CNAME. TLS, CDN, and preview deployments included.
→
ENERGY STAR Portfolio Manager
REST API sync with EPA's wstest + live environments. Pushes meter data and property shares for EGC §8.5 compliance filings.
Security & Access

Multi-tenant. Role-scoped.

Every property and account access goes through RBAC enforced at the API layer. Sparko admins can impersonate users with full audit trail. Magic-link sign-in with domain allowlist — no passwords to manage.

RBAC (4 roles)
Magic-link auth
Google OAuth
Domain allowlist
AES-256-GCM token storage
Impersonation audit log
SOC 2 in progress
© 2026 SPARKO SYSTEMS, LLC · GRAND RAPIDS, MI
STATUS · OPERATIONALSOC 2 · IN PROGRESSv0.4.0