Intelligence & Analytics Team

Focus on Energy • Scope, Priorities & Staffing for Quad V

Core Position: Our three-person team delivers an unusually broad scope of work. We are not requesting additional headcount. Instead, we recommend scaling cloud infrastructure and AI agent capacity so the current team can continue operating at high velocity while building the next generation of Focus on Energy systems.

The majority of our time is spent on future-facing development: porting legacy tools into a modern, cohesive custom stack and embedding intelligent assistants throughout our operations.

1. Team Overview

3 FTEs — A small, highly capable team that originated as back-end analytics and data engineering and has evolved into full-stack development, infrastructure, and intelligent systems.

We design, build, and operate internal tools, dashboards, identity systems, data pipelines, and infrastructure. We prioritize low-maintenance systems and rapid iteration so a small team can sustain a large and growing portfolio.

2. Portfolio Snapshot

25+
Active tools & applications
20+
Dashboards across QuickSight, Power BI & custom
3
Database platforms managed

3. Future Direction — Where We Spend Most of Our Time

We are actively moving away from a fragmented Retool-heavy environment toward a modern, custom-built stack. The majority of our current effort goes into two strategic themes:

One Cohesive Environment

We are consolidating the old “toolbox” of separate apps into a single, unified experience. Staff, utility partners, and implementers should log in once and immediately understand where they are, what they can access, and how to move between tools — without wondering “Is this the right app? Is this the right login?”

Outcome: One front door. Clear navigation. Consistent permissions. No more context-switching friction.

Assistants Everywhere

We are embedding intelligent agents as helpful sub-managers throughout our systems. These assistants handle the mundane, repetitive, and high-volume tracking that humans previously couldn’t sustain at scale — cost oversight, proactive monitoring, exception detection, and routine follow-up.

Goal: Agents that quietly keep things on track so people can focus on judgment, relationships, and program outcomes — not chasing data or status updates.

4. Work Categorization

We sorted every task and tool into three buckets based on impact and necessity.

Item Description
Night ShiftCore ETL pipelines that feed all reporting and dashboards
Core Contract & Implementer DashboardsQuad contract KPIs + per-implementer performance tracking
Utility QuickSight DashboardsFull suite of QuickSight dashboards and access management supporting utility partners’ data needs
Focus IDPSingle Sign-On / Identity platform (staff, utilities, customers — hundreds of thousands of records)
Control CenterPermissions, access management, and federated module used by all new apps
Communities of FocusContract deliverable — interactive map of Wisconsin communities
QuickSuite ManagerQuickSight administration & utility partner account management
api_v1Shared utility API — foundational service layer
ValidatorCritical address & data validation service used by implementers
qc_trollAutomated quality control checks on program data
Notifications APICentralized email notification service across applications
Item Description
Measure MaestroEnergy efficiency measure proposal workflow and approvals
focus-workspaceInternal ticketing + project management system (in active development — high potential to become core infrastructure)
Smarty Emailer / QuestsProactive alerting system that surfaces anomalies and required follow-ups
Item Description
Cost Effectiveness appStreamlit mTRC / cost-effectiveness analysis tool
outreach_mapAuto-updating outreach event map
CliffordSecurity & issue monitoring across applications
IRA Participation DashboardPublic-facing program participation visualization
R Shiny maps (various)Weatherization, Energy Advisor, Certificate of Completion, etc.
Data BodegaDashboard discovery and marketplace hub
The LibrarianCompliance chatbot with policies, procedures, and reference documents
COI AdminCertificate of Insurance tracking for subcontractors
EA Managed Account NavigatorSpecific implementer account management tool
Marketing Communications CalendarMarketing department workflow tool
Pigeon CampaignsInternal staff engagement / nurture campaign tool
Survey RoundupCustomer satisfaction survey ingestion, sentiment analysis, and routing
TA Performance NavigatorTrade Ally performance dashboard and comparison tool

5. How This Scope Would Be Staffed Elsewhere

In a traditional organization, the breadth of work we currently deliver would typically require 8–12 specialized FTEs across separate functions:

Our three-person team achieves this scope through deliberate low-maintenance design, heavy automation, and a focus on building systems that require minimal ongoing support.

6. Resource Recommendations (No Headcount Increase)

We are not asking to grow the team. We believe the current three people can continue delivering — and increase impact — if we scale the leverage tools that make a small team this productive.

Cloud Infrastructure
$4,000 / month

Projected to support growth beyond 25 applications. Covers current production (including large RDS databases), test + production environments for a growing portfolio, and headroom for data warehouse migration (BigQuery-style) to improve performance and scalability.

AI Agent Capacity
$800 / month

Claude Max + OpenAI + flexible buffer for the team. Enables the “Assistants Everywhere” vision and future-facing development without each person maintaining separate personal subscriptions.

These investments in infrastructure and agent capacity are significantly more cost-effective than adding headcount while directly supporting the two strategic themes above.