Financial Analyst Python Freelance Jobs in Colorado

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 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: 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.