Financial Analyst / Utilities Consultant

NewGen Strategies & Solutions; Lakewood (CO); Hybrid; USD 68,000 - 75,000; Full time

Benefits offered by this job

401(k) match

Medical and dental insurance

Paid vacations and holidays

Paid maternity and paternity leave

Flexible work schedules

Ongoing training

Office snacks

Job summary

NewGen Strategies & Solutions in Lakewood, CO is seeking a Financial Analyst / Consultant to support its Energy Practice. You will build financial models, analyze large datasets, and create clear dashboards to help utilities and clients forecast costs and plan investments.

You’ll work with energy industry experts to develop insights, present results, and contribute to rate and fee decisions across projects nationwide. This associate role offers growth with a strong collaborative culture.

Qualifications

• Undergraduate degree or higher in Finance, Economics, Accounting, Business Administration, Data Analytics, Math, or another quantitative field.
• 1–3 years of experience in a finance- or data-related role.
• Strong working knowledge of Microsoft Excel.
• Familiarity with core financial concepts (inflation, depreciation, discount rates, operating costs, capital planning, debt metrics).
• Basic knowledge of Microsoft Word and PowerPoint.

Responsibilities

• Develop financial models in Microsoft Excel to forecast costs, revenues, and performance indicators.
• Analyze large data sets including financial, demographic, customer, and service/billing data.
• Create clear, user-friendly data visualizations, dashboards, and charts.
• Communicate results through written reports and PowerPoint presentations.
• Conduct quantitative and qualitative research (benchmarking rates, fees, service levels, cost drivers).
• Build subject matter expertise in energy services and markets.
• Collaborate with colleagues across NewGen’s Energy, Water, and Solid Waste practices.

Skills

Excel

Word

PowerPoint

Education

Quantitative degree (Finance, Economics, Accounting, Business Admin, Data Analytics, Math)

Tools

VBA

Power Query

Power Pivot

Power BI

Python

R

SQL

ArcGIS

Job description

Energy Financial Analyst / Utilities Consultant

Lakewood, CO

NewGen Strategies & Solutions is a management consulting firm with offices nationwide. We specialize in three core practices—Energy, Water, and Solid Waste—providing strategic insight and practical solutions to help our clients achieve their goals.

Our vision is to be the consulting company that makes a difference for our clients, our employees, and our communities. Guided by our core values—make an impact, foster innovation, expect quality, cultivate community, and be a trusted advisor—we are committed to excellence in everything we do.

At NewGen, our employees are our greatest asset, and every team member, at every level, has a voice.

The Role

The Financial Analyst / Consultant role in the Energy Practice is an associate-level position with opportunity for advancement. We’re looking for SOLVERS—people who approach challenges with curiosity and enjoy solving complex problems. In this role, you’ll work directly with industry experts to build your skills while supporting energy clients across the country.

Our work is meaningful, challenging, and impactful—helping communities understand the true cost of service, plan for long-term investments, and make informed, transparent rate and fee decisions.

Key Responsibilities

• Develop financial models in Microsoft Excel to help energy utilities and organizations forecast costs, revenues, and performance indicators
• Analyze large data sets, including financial, demographic, customer, and service/billing data
• Create clear, user-friendly data visualizations, dashboards, and charts
• Communicate results through written reports and PowerPoint presentations
• Conduct quantitative and qualitative research (e.g., benchmarking rates, fees, service levels, and cost drivers)
• Build subject matter expertise in energy services and markets
• Collaborate with colleagues across NewGen’s Energy, Water, and Solid Waste practices

Required Qualifications

• Undergraduate degree or higher in Finance, Economics, Accounting, Business Administration, Data Analytics, Math, or another quantitative field
• 1 to 3 years of experience in a finance- or data-related role
• Strong working knowledge of Microsoft Excel
• Familiarity with core financial concepts (e.g., inflation, depreciation, discount rates, operating costs, capital planning, debt metrics/coverage concepts)
• Basic knowledge of Microsoft Word and PowerPoint

Preferred Qualifications

• Experience with advanced Excel features (VBA, Power Query, Power Pivot, Power BI)
• Experience inenergy, utilities, or local government
• Knowledge of programming languages for data analysis (Python, R, SQL)
• Experience with GIS or spatial analysis tools (e.g., ArcGIS)

Qualities We Look For: SOLVERS

• Structured — organized, methodical, and grounded in sound reasoning
• Ownership-driven — takes initiative and accountability for outcomes
• Logical — applies evidence-based thinking to problem solving
• Versatile — adapts quickly to changing needs and priorities
• Elevating — collaborates and positively influences those around them
• Resourceful — finds creative solutions, even with limited information
• Passion for and proficiency in Microsoft Excel (you will spend most of your day in spreadsheets)
• Exceptional attention to detail
• Strong written and verbal communication skills
• Ability to manage multiple priorities and deadlines
• Comfort working with large, complex, and sometimes messy data sets

What We Offer

• Base compensation of $68,000 – $75,000, depending on experience and qualifications
• Annual bonus of 8%, contingent on individual and company performance
• 401(k) plan with matching contributions
• Medical and dental insurance
• Paid vacations and holidays
• Paid maternity and paternity leave
• Meaningful opportunities for career growth and advancement
• Flexible work schedules (while being mindful of client deadlines)
• Ongoing training and professional development
• Office snacks and occasional team lunches / activities

Additional Information

Location:

Lakewood, CO. In-person role, with the opportunity for two days of work from home.

Employee Type:

Full-time, exempt. Some overtime and travel may be required.

Applicants must be legally authorized to work in the United States and not require current or future visa sponsorship. NewGen is an equal opportunity employer and complies with all applicable federal, state, and local employment laws.