Pilot Energy Accelerates Energy Purchasing Decisions with a Cloud-Native Analytics Platform on AWS

Industry: Energy

THE CHALLENGE

Scaling Expert Energy Advisory Without Operational Risk

Pilot Energy’s advisory business relied on deep domain expertise to model energy consumption, evaluate supplier offers, and simulate purchasing strategies for large commercial and public-sector customers. As the firm grew, its core advisory workflow became increasingly constrained by a legacy process.

Generating a complex purchasing recommendation for a single customer could take up to four hours, limiting throughput and slowing decision-making in fast-moving energy markets.

Key challenges included:

  • Single Point of Failure: Critical logic lived in a single spreadsheet understood by only one senior advisor.
  • Slow Turnaround: Long analysis cycles reduced the number of clients advisors could support.
  • Operational Risk: anual data entry and complex formulas increased the risk of costly errors.
  • Growth Constraints: The workflow did not scale to additional advisors or higher client volume.

The Hidden Pain Points

  • Key-Person Dependency: If the primary advisor was unavailable or the spreadsheet became corrupted, Pilot Energy’s ability to deliver recommendations was at risk.
  • Error Sensitivity: A single mis-keyed value or incorrect formula could lead to inaccurate pricing scenarios and erode customer trust.
  • Limited Scalability: The manual workflow prevented concurrent work and capped the firm’s advisory capacity.

ZetaMinusOne’s Solution

ZetaMinusOne (ZMO) partnered with Pilot Energy to design and implement Power Up, a modern, cloud-native energy analytics platform built on AWS. The goal was to codify Pilot Energy’s intellectual property into a secure, automated application that any advisor could use, without sacrificing accuracy or flexibility.

The solution translates years of spreadsheet logic into a resilient, API-driven platform that supports concurrent usage, rapid scenario analysis, and future AI-driven enhancements.

Core Features of the Solution

1. Modern Web-Based Advisor Interface
A Next.js front end provides advisors with an intuitive interface to upload consumption data, define purchasing strategies, and run complex scenarios without manual spreadsheets.

2. Cloud-Native Compute Without Server Management
A containerized C#/.NET 8 backend runs on Amazon ECS with AWS Fargate, eliminating the need to manage EC2 instances, operating systems, or cluster capacity.

3. Elastic, Cost-Efficient Data Storage
Amazon Aurora Serverless v2 (PostgreSQL-compatible) automatically scales database capacity based on demand, aligning infrastructure cost with Pilot Energy’s 9-to-5 usage pattern.

4. Asynchronous Analytics Processing
Long-running or compute-intensive calculations are decoupled from the user interface using Amazon SQS and AWS Lambda, keeping the application responsive during peak usage.

Key Technical Features

Scalable Application Architecture

User traffic flows through an Application Load Balancer (ALB) into a containerized backend running on ECS with Fargate, enabling seamless scaling as advisor usage increases.

Serverless Database with Usage-Based Scaling

Aurora Serverless v2 automatically scales up during business hours and down during evenings and weekends, minimizing total cost of ownership while maintaining enterprise-grade reliability.

Decoupled Background Processing

Heavy analytics workloads are queued in Amazon SQS and processed asynchronously with AWS Lambda, preventing bottlenecks and ensuring consistent user experience.

Secure, Observable, and Automated Operations

The platform uses Amazon S3 for logs and backups, Amazon ECR for container images, and AWS Secrets Manager for secure credential management. Amazon CloudWatch, integrated with Arctic Wolf, provides monitoring and observability, while Terraform and GitHub Actions enable infrastructure-as-code and CI/CD across environments.

THE IMPACT

Faster Decisions, Lower Risk, and a Scalable Advisory Platform

The Power Up platform fundamentally transformed Pilot Energy’s advisory operations—dramatically improving efficiency, eliminating key-person risk, and enabling sustainable growth without increasing operational overhead.

Results at a Glance

95–98% reduction in recommendation time, from ~4 hours to
5–10 minutes per analysis.
Concurrent advisor usage enabled, allowing all five advisors to
work simultaneously without interference.
~$125–$130 monthly AWS cost, effectively offset by recovered senior advisor time.
Future-ready architecture, enabling upcoming AI-driven simulations
and optimization features.

Explore Our Full Suite of Technology Consulting Services

Custom App Development

Turn your team’s vision into reality with custom applications built to address your specific business needs. We build scalable, high-performance apps that deliver exceptional user experiences.

App
Modernization

Modernize your existing applications to maintain a competitive edge. ZMO transforms outdated, legacy apps with modern new technology, improving performance, user experience, and security.

Strategy & Change Management

Navigate the complexities of business transformation with our strategic guidance, assisting you in planning and implementing changes that drive sustainable business growth.

Modern Data Platform Enablement

Unlock the power of your data with modern platforms that support advanced analytics, AI, and real-time decision-making. Our solutions ensure that your emerging technologies won’t disrupt your tech ecosystem, but will drive business value.

Fractional
CTO

Get the leadership and technical expertise of an experienced CTO without the full-time cost. ZMO’s fractional CTO service delivers strategic IT advice and guidance.

Artificial Intelligence Platform

Leverage the power of generative AI and machine learning to transform your business. ZMO’s AI platforms enable smarter decision-making, automate time-consuming tasks, and drive intentional innovation.

Recruiting as a Service

Build a best-in-class tech team with our technology recruiting services. Leveraging our experience, we’ll assist you in finding, attracting, and retaining top technical talent.

Ready to Transform Your Business?

Contact us today to learn how ZetaMinusOne can help transform your business processes and deliver lasting impact.

Get in Touch