FP&A Intern

RES•Denver, CO

1d•$18 - $20•Hybrid

About The Position

We are committed to building a workplace where everyone feels heard and respected, and extending our culture of care so that every individual can reach their full potential. We want you to have a sense of belonging and feel valued for your contributions and the perspectives you bring. Summary: We are seeking a motivated and detail-oriented FP&A Intern to join our finance team. This internship offers hands-on experience in financial planning, analysis, and strategic decision support within a dynamic renewable energy environment. You will work closely with experienced FP&A professionals to support budgeting, forecasting, performance reporting, and key business initiatives. Ideal for finance, accounting, economics, or business students seeking practical exposure to corporate finance.

Requirements

Currently pursuing a Bachelor's or Master's degree in Finance, Accounting, Economics, Business Administration, or a related field is required. (Junior/Senior standing preferred).
Strong academic record with coursework in financial accounting, managerial accounting, or corporate finance.
Advanced proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, INDEX-MATCH, data tables, charts); experience with financial modeling is a plus.
Familiarity with financial statements (income statement, balance sheet, cash flow) and basic accounting principles.
Excellent analytical, problem-solving, and attention-to-detail skills.
Strong communication skills — able to present findings clearly to non-finance stakeholders.
Self-motivated, proactive, and eager to learn in a fast-paced environment.
Candidates will be required to pass a pre-employment background investigation and drug test as a condition of employment.

Nice To Haves

Previous internship or relevant experience in finance/accounting is a plus but not required.

Responsibilities

Assist in the preparation and maintenance of monthly financial forecasts and annual budgets by gathering data from cross-functional teams and updating financial models.
Perform variance analysis — compare actual results to budget/forecast, investigate key drivers of variances, and help prepare summary explanations for management review.
Support the creation of monthly management reporting packages, including dashboards, KPI tracking, and trend analysis using Excel and other tools.
Help maintain and improve financial models (e.g. headcount planning, expense tracking).
Collaborate cross-functionally to collect accurate financial inputs and resolve data discrepancies.
Participate in special projects to enhance FP&A processes and deliverables.
Review the current monthly management reporting workflow, including data pulls from ERP/accounting systems, variance calculations, narrative commentary, chart creation, and package assembly in Excel (and potentially Power BI or similar tools).
Use AI-powered Excel add-ins such as Claude in Excel (Anthropic's native sidebar integration for workbook-aware analysis, formula generation, multi-sheet editing, and transparent changes) and/or Microsoft Copilot in Excel to prototype automations.
Automate data cleaning and reconciliation (e.g., standardize formats, flag anomalies, reconcile actuals vs. budget/forecast with minimal manual intervention).
Accelerate variance analysis by prompting the AI to identify top drivers of key variances, generate initial explanatory narratives, and suggest visualizations.
Build or enhance dynamic reporting templates — auto-generate pivot tables, charts, conditional formatting, and executive summaries based on refreshed data inputs.
Conduct sensitivity or scenario testing (e.g., "What-if" impacts on margins or cash flow) faster through AI-assisted modeling.
Document time savings, error reductions, and quality improvements (e.g., before/after comparisons of reporting cycle time or manual touchpoints).
Prepare a concise presentation deck or memo summarizing the implemented automations, key learnings, recommended best practices for ongoing use, and potential scaling opportunities (e.g., integrating connectors for external data sources where available).
Follows safety and security procedures and determines appropriate action.
Reports potentially unsafe conditions and uses materials and equipment properly.