FP&A Intern: Hybrid Chicago, Data-Driven & Impactful

Cognitioworld; Chicago (IL); Hybrid; USD 25,000 - 36,000; Part time

Benefits offered by this job

Hybrid work in Chicago

Housing assistance possible

Job summary

Cognitioworld in Chicago offers a hybrid FP&A internship for a junior undergraduate student. You will support financial reporting, analytics, and budgeting, while gaining hands-on experience with KPIs, dashboards, and scenario planning tools.

The role emphasizes data analysis, large datasets, and effective communication of findings to leadership. Strong Excel skills and familiarity with Power BI are highly valued, with housing assistance discussed during interviews.

Qualifications

• Currently enrolled as a junior undergraduate student.
• Pursuing Finance, Accounting, or Data Analytics as major preferred.
• Strong Excel skills with pivot tables and formulas; Power Query/macros ideal.
• Experience with PowerBI or other data visualization software is a plus.
• Detail-oriented with comfort handling large datasets.
• Strong analytical and writing skills.

Responsibilities

• Support FP&A with financial reporting, analytics, and operations.
• Assist with annual budget development and monthly forecasts.
• Analyze data and trends related to Foundation spending.
• Develop KPI dashboards and financial scorecards for leadership.
• Build automated interactive financial models and scenario planning tools.
• Assist in automating month-end close reporting tools and variance analysis.
• Leverage AI software to enhance FP&A processes using Microsoft products.
• Summarize variance analyses and findings for cost centers.

Skills

Advanced Excel (Pivot Tables)

Power Query / Macros

PowerBI / Data Visualization

Data analysis

Presentation & writing

Education

Junior undergraduate student in Finance/Accounting/Data Analytics

Tools

PowerBI

Power Query

Excel

Macros

Job description

Cognitioworld in Chicago offers a hybrid FP&A internship for a junior undergraduate student. You will support financial reporting, analytics, and budgeting, while gaining hands-on experience with KPIs, dashboards, and scenario planning tools.

The role emphasizes data analysis, large datasets, and effective communication of findings to leadership. Strong Excel skills and familiarity with Power BI are highly valued, with housing assistance discussed during interviews.