Financial Planning & Analysis Intern - Summer 2027

John D. and Catherine T. MacArthur Foundation

Where
Chicago Office
Pay
$22 an hour
Type
Internship

Posted 21 days ago· Checked live at John D. and Catherine T. MacArthur Foundation 4 days ago

Stale: open 21 daysUp for more than two weeks. It may already be filled.

See how you score for this job

One sentence and your resume. We score it against what John D. and Catherine T. MacArthur Foundation asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on John D. and Catherine T. MacArthur Foundation's own hiring page 4 days ago.
What is the job?
Job Description NOTE: To ensure a fair and equitable recruitment process, our Foundation Staff and Board do not host preliminary conversations with applicants outside of our standard interview process.
What does it pay?
$22 an hour, as the posting states.
Our verdict
Stale. Up for more than two weeks. It may already be filled.

What the job is

Job Description

NOTE: To ensure a fair and equitable recruitment process, our Foundation Staff and Board do not host preliminary conversations with applicants outside of our standard interview process.

Position: Financial Planning & Analysis Intern - Summer 2027

Reports To: Senior Financial Analyst

Location: Chicago, IL (Hybrid)

Duration: June 8 - August 11, 2027

Responsibilities may include

  • Explore key performance indicators (KPIs), financial scorecards, dashboards and other visual representations to illustrate financial performance.
  • Assist with the build of automated interactive financial models and scenario-planning.
  • Assist with automation of month-end close reporting tools to help streamline reconciliation and variance analysis.
  • Leverage AI software to enhance FP&A processes with Microsoft products.
  • Analyze trends in expenses, headcount, or other key metrics and summarize findings for leadership.
  • Perform industry research on assigned finance-related grantmaking operations and report findings to FP&A team. Research may include grant payment processes, operational expense reporting, or multi-year payout reporting.
  • Assist with review of annual budget submissions and preparation of internal reports to summarize variance analyses and discussion items by cost center.
  • Assist with ad hoc analysis requests from department heads.
  • Other duties as assigned.

Qualifications

  • Currently enrolled in an undergraduate program in their junior year.
  • Major in Finance, Accounting or Data Analytics preferred.
  • Strong Excel skills (pivot tables, formulas, ideally Power Query or macros).
  • Experience with PowerBI or other data visualization software is a plus.
  • Detail-oriented, comfortable working with large datasets.
  • Intellectual curiosity: willing to ask "why" a number moved, not just report that it did.
  • Strong analytical and critical thinking skills.
  • Strong organizational and data management abilities.
  • Strong presentation and writing skills.

This internship is based in Chicago, Illinois. Our work environment is hybrid with designated in-office days and virtual days. Interns will be required to reside in the Chicagoland area for the duration of the program. Housing assistance for non-local students may be available and will be discussed during the interview process.

Similar open jobs

Finance and accounting jobs in Chicago (404)Jobs in Chicago (6804)