Hiring.Camp

Financial Planning & Analysis Intern - Summer 2027

Macfound

·

3 weeks ago

Salary
$22+
Location
Chicago Office, United States of America
Workplace
Hybrid
Type
Internship
Department
Finance
Seniority
Internship
Source
Workday

Description

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

Compensation: Paid Internship (Hourly rates will start at $22.00/hour)


About the Foundation

The John D. and Catherine T. MacArthur Foundation is one of the nation’s largest independent foundations. The Foundation supports creative people, effective institutions, and influential networks building a more just, verdant, and peaceful world. MacArthur invests in solving some of the world’s most pressing social challenges, including advancing global climate solutions, promoting local justice reform in the U.S., revitalizing local news, expanding who creates, uses, and benefits from artificial intelligence, and strengthening the well-being of Native communities. In addition to the MacArthur Fellows Program and the global 100&Change competition, the Foundation continues its historic commitments to the role of journalism in a responsive democracy as well as the vitality of our headquarters city, Chicago. The Foundation also maintains offices in Nigeria and India.


About the Internship:

The Financial Planning & Analysis intern will support the FP&A function and provide project support in the areas of financial reporting, analytics, operations, and other special projects. This position will work with the FP&A team and report to the Senior Financial Analyst, FP&A.


The intern will assist the team with the annual budget development cycle and monthly forecast process, as well as data analysis and trend analysis related to the Foundation spend. The intern will gain skills and experience in private foundation financial operations, reporting and analysis.

 

About the Internship:

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. 

 

Application Process: 

The application deadline is MONDAY, NOVEMBER 30, 2026 AT 11:59 PM CST. Applicants should submit a cover letter and resume. As a requirement, students “must be returning back to school” to be eligible. Students meeting the minimum requirements should apply through the MacArthur Foundation website (www.macfound.org/jobs). 


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.

 

Work Environment and Reasonable Accommodations

The work environment is an office setting.  Requests for reasonable accommodations will be considered to enable a person with disabilities to perform the job.  Reasonable accommodations are also available during the interview process.

 

The John D. and Catherine T. MacArthur Foundation is an equal opportunity employer and does not discriminate on the basis of race, color, religion, national origin, sex, age, disability, pregnancy, marital status, sexual orientation, gender identity, veteran status, or any other characteristic protected by applicable federal, state or local laws.

Skills

Excel

Similar Jobs

30

Financial Planning

Rbc·Canada +1

1mo ago

Senior Financial Planning & Analysis Partner II

The Nielsen Company·New York City, New York·Hybrid

Today

Financial Planning & Analysis Director

Depository Trust Company·Jersey City, New Jersey·Hybrid

Today

Program Manager Iii Logistics Budgeting And Financial Planning Cloud Customer Logistics

Accounts

Manager, Financial Planning & Analysis

Charlesriverassociates·Boston, Massachusetts·Hybrid

Today

Senior Financial Planning Analyst

Alliance Defending Freedom·Dallas, Texas

Today

Head of U.S. Financial Planning and Business Partnership

Ascot Underwriting Holdings Limited·Iselin, New Jersey·Hybrid

Today

Financial Planning & Analysis Director

BioMADE·Minneapolis, Minnesota·Hybrid

Today

Manager - Enterprise Financial Planning

Air New Zealand·Auckland, New Zealand·Onsite

1d ago

Financial Planning & Analysis Manager

Filinvest Development Corp·Quezon City, National Capital Region

1d ago

Manager, Financial Planning & Analysis

Entegris·US

1d ago

Sr. Financial Planning Analyst (Financial Reporting and Projects) - CPA preferred

Lennox·Richardson, Texas

1d ago

Region Director, Financial Planning & Analysis

Ardent Health·Brentwood, Tennessee

1d ago

Senior Associate, Financial Planning & Analysis

Gordonbrothers·London, England·Hybrid

1d ago

Financial Planning Analyst Intern - Store Operations —Summer 2027

Burlington·00000 - Burlington Corporate Office, US·Hybrid

1d ago

Financial Planning and Analysis Manager

Cooley·Chicago, Illinois +9

1d ago

PREMIER Financial Planning & Analysis Internship

Firstpremier·US·Onsite

1d ago

Financial Planning and Analytics Senior Manager

Roberthalf·Atlanta, Georgia +5·Hybrid

1d ago

Planning Director, Estate & Financial Planning Services

Sunlife·Montréal, Quebec +2·Remote

1d ago

Planning Director, Estate & Financial Planning Services

Sunlife·Montréal, Quebec +2·Remote

1d ago

Director of Financial Planning & Reporting- Finance- Full Time

SolutionHealth is an integrated health·Manchester, England

1d ago

Head of Financial Planning & Analysis

Netboxlabs·US Remote·Remote

1d ago

Financial Planning and Analytics Senior Manager

ProtivitiNA·Atlanta, Georgia +5·Hybrid

1d ago

Director, Financial Planning & Business Support

BC Assessment·Victoria, British Columbia·Hybrid

1d ago

Financial Planning & Strategic Projects Lead

Aptiv·MAR CS, HT Morocco - MFG

1d ago

Financial Planning & Analysis Representa

Accenture·Mumbai, Maharashtra·Remote

1d ago

FINANCIAL PLANNING & PERFORMANCE ASSOCIATE I

Bbva·UBICACION SSCC BBVA PERU

1d ago

Head of Financial Planning & Analysis

Rbs·Edinburgh, Scotland +1·Hybrid

1d ago

CFO Financial Planning and Analysis Manager - AVP

Db·Philippines·Hybrid

1d ago

CFO Financial Planning and Analysis Manager - AVP

Db·Philippines·Hybrid

1d ago