Energy Analyst

Trio; Colorado; On-site; USD 70,000 - 95,000; Full time

Benefits offered by this job

Generous Paid Time Off

National Holiday Pay & Float Holidays

401(k) Employer Matching

Education tuition or certification Re-

Hybrid or remote work schedule

Job summary

Trio is seeking an Energy Analyst to support energy data analytics, invoice auditing, and operational insights for large commercial, industrial, and institutional clients. This role combines utility data management with bill validation to ensure accuracy and cost visibility.

You will collect and validate data, audit invoices, analyze consumption trends, and prepare client-facing insights with standard reports and dashboards.

Qualifications

• Bachelor’s degree in a relevant field.
• 0–5 years of professional business experience.
• Strong analytical skills and proficiency with Microsoft Office.
• Ability to perform data analysis in Excel.

Responsibilities

• Collect, validate, and maintain utility data across client accounts.
• Audit utility invoices for accuracy across rates, usage, and charges; identify discrepancies.
• Analyze consumption and cost drivers; develop standard and ad hoc reports and dashboards.
• Collaborate with cross-functional teams to improve auditing workflows and reporting processes.
• Support budgeting using historical data trends and validate accruals.

Skills

Analytical skills

Microsoft Office

Excel

PowerBI

Data analysis in Excel

Education

Bachelor’s degree in a relevant field

Tools

PowerBI

Microsoft Office Suite

Job description

Trio is a global energy and sustainability advisory company that helps large commercial, industrial, and institutional organizations navigate the energy landscape. Trio provides integrated strategy and implementation offerings across energy supply management, data management, energy optimization and electrification, clean energy, and sustainability to help the world’s largest organizations deliver on their strategic objectives and priorities.

Position Overview

We are seeking a detail-oriented Energy Analyst to support client engagements focused on energy data analytics, invoice auditing, and operational insights. This role combines large-scale utility data management with detailed bill validation to ensure accuracy, identify cost drivers, and improve visibility into energy spend.

Utility Data Management & Analysis

• Collect, validate, and maintain utility data across client accounts
• Track usage and cost trends across portfolios
• Ensure accuracy and completeness of datasets

Invoice Auditing & Bill Validation

• Audit utility invoices for accuracy across rates, usage, and charges
• Identify discrepancies, errors, and billing anomalies
• Validate billing data against historical patterns
• Support tracking and resolution of invoice issues

Consumption & Cost Analysis

• Analyze consumption and cost drivers across client portfolios
• Perform variance analysis across sites and billing periods
• Identify anomalies and unusual usage patterns
• Research utility rates to evaluate feasibility to switch tariffs
• Develop standard and ad hoc reports and dashboards
• Prepare clear client-facing insights and summaries
• Present analytical findings in a structured format
• Perform cost tracking and variance analysis
• Support budgeting using historical data trends
• Validate accruals and align financial datasets

Process Improvement & Collaboration

• Improve auditing workflows and reporting processes
• Collaborate with cross-functional teams
• Support automation and efficiency initiatives

Basic Qualifications

• Bachelor’s degree in relevant field
• 0–5 years of experience working in a regular professional business setting
• Strong analytical skills and proficiency with Microsoft Office (Excel, PowerPoint, Word, PowerBI), and ability to perform data analysis in Microsoft Excel

Preferred Skills

• Utility billing or invoice auditing experience
• Advanced Excel skills
• Familiarity with either the North American energy power or natural gas markets, or both

Core Competencies

• Strong attention to detail
• Consistent in being a positive influence in workplace
• Ability to manage multiple priorities
• Results-oriented project management and organizational skills

Success in This Role

• Provide exceptional customer service to internal and external stakeholders
• Deliver accurate and timely invoice validation
• Identify and resolve billing discrepancies
• Provide clear insight into energy spend and usage
• Enhance data quality and reporting processes

Benefits for Full-Time Employees

• Generous Paid Time Off (includes but not limited to Paid Parental Leave, Bereavement, Jury Duty, Sick, Vacation, etc.)
• National Holiday Pay & Float Holidays
• 401(k) Employer Matching
• Paid Parental Leave (Short term disability and 6 weeks of paid parental leave unless superseded by any state-specific benefits.)
• Employer 100% Paid Life Insurance Benefits
• Employer 100% Paid Short Term and Long-Term Disability
• Supplemental (Flexible Spending Accounts, Commuter Benefits, Cancer/Critical Care, Hospitalization, Accident)
• Education tuition or certification reimbursement program (from an accredited institution for college level and/or advance degree)
• Short Term Incentive (STI) Bonus Based on Performance Goals
• Hybrid or remote work schedule

Trio is committed to building a diverse and inclusive workplace. We are a proud Equal Opportunity Employer and will not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national original, age, disability, protected veteran status or any other protected status.

This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9.

Trio offers a competitive and comprehensive compensation and benefits package where you’ll be rewarded based on your performance and recognized for the value you bring to the business.

The listed salary range represents Trio’s good faith estimate for this position and represents the minimum and maximum for new hire salaries across all U.S. locations. An employee’s rate of pay within the range is determined based on the successful applicant’s education, experience, knowledge, skills, and abilities in addition to geographic location and demonstrated performance over time. In addition to those factors, we believe in the importance of pay equity and consider internal equity of our current team members as a part of any final offer. Please keep in mind that the range stated above is the full base salary range for the role. Hiring at the maximum of the range would not be typical in order to allow for future and continued salary growth.