Financial Analyst / Utilities Consultant

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

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

Preferred Qualifications: 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)Qualities We Look For: SOLVERSAt 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 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

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.

Application Deadline: This position is open on an ongoing basis. Applications will be accepted and reviewed on a rolling basis until the position is filled. 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.