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 At NewGen, 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
Additional qualities include:
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.