FP&A Intern

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:   

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

A core focus of this internship will be contributing to an AI-Driven Monthly Management Reporting Automation Initiative. You will:

• 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.
• Examples of tasks:
  • 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).

Safety:

• Follows safety and security procedures and determines appropriate action.  Reports potentially unsafe conditions and uses materials and equipment properly.

Qualifications:

• 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.
• Previous internship or relevant experience in finance/accounting is a plus but not required.

Anticipated base salary range:  $18/hr - $20/hr.

The final agreed upon compensation is based on individual education, qualifications, experience, and work location.

Physical requirements and environment:

The work environment and physical demands characteristics are representative of those the employee encounters while performing the essential functions of this job.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Rarely: Climbing, crouching, kneeling, pulling/pushing/lifting between 5-15lbs., and stooping are required. 

Occasionally: Carrying 5-15lbs., gripping, handling, pinching, and walking are required.

Frequently: Standing is required.

Constantly: Reading, grasping, hearing, reaching, vision, repetitive motion, and sitting is required.

Rarely exposed to extreme cold, heat, and humidity, and wet climates, in the working environment.

Occasionally exposed to noise and hazards in the work environment.

We maintain a drug-free workplace.  Candidates will be required to pass a pre-employment background investigation and drug test as a condition of employment.

RES is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.

#LI-Hybrid