Financial Analyst​/Utilities Consultant

Overview

Energy Financial Analyst / Utilities Consultant
Lakewood, CO

New Gen 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 New Gen, our employees are our greatest asset, and every team member, at every level, has a voice.

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.

• 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 New Gen’s Energy, Water, and Solid Waste practices

• 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 Power Point

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

At New Gen, SOLVERS are people who thrive on complexity and collaboration. A SOLVER is:

• 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

• 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

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. New Gen is an equal opportunity employer and complies with all applicable federal, state, and local employment laws.