Summer Finance Rotational Analyst (Data & Analytics)

AIR Communities

Denver (CO)

On-site

USD 44,000 - 62,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

AIR Communities in Denver/Chicago is offering a 10-week Rotational Analyst Program for rising seniors. You will gain exposure to Debt Capital Markets, FP&A, Insights, Investments, Asset Management, and Operations Finance, with rotations starting for those who return as Full-Time Analysts.

During the program, you will conduct data analyses, build dashboards, support budgeting and forecasting, and collaborate across teams to drive portfolio optimization.

Qualifications

  • Must be a rising senior pursuing a bachelor’s degree during the internship program.
  • Pursuing a degree in accounting, finance, real estate, economics, STEM or business.
  • Advanced knowledge of MS Excel; working knowledge of MS Word and PowerPoint.
  • Excellent analytical and problem-solving skills; must love numbers!
  • Excellent organizational skills and attention to detail, as well as ability to prioritize and multi-task in a fast-paced environment
  • Experience with data visualization tools (e.g. Power BI, Tableau, etc.) and/or analytical coding language (e.g. SQL, Python, R, etc.) is a plus
  • A commitment to doing things differently and making the world a little bit better
  • A naturally collaborative nature and ambition without ego
  • Ability to work in Chicago or Denver in a full-time capacity for 10 weeks, beginning in June of 2027

Responsibilities

  • Conduct in-depth analysis of large, complex datasets to uncover actionable insights related to asset performance, market dynamics, and resident behavior.
  • Collaborate with cross-functional teams—including Finance, Asset Management, and Capital Finance —to support strategic initiatives and drive portfolio optimization.
  • Build and enhance dashboards, reports, and presentations that translate data into compelling narratives for internal stakeholders.
  • Assist in financial planning and analysis activities, including budget variance reviews, forecasting, and mid-year reforecasting processes.
  • Contribute to process improvement efforts through documentation, training support, and testing of new systems and tools.
  • Leverage advanced business intelligence platforms (e.g., Power BI, RealPage, Oracle PBCS) to support data visualization and performance reporting.
  • Audit and validate key operational datasets to ensure data integrity and usability across business functions.
  • Participate in high-impact, ad hoc projects that inform executive decision-making and shape business strategy.

Skills

MS Excel
Data visualization
Analytical thinking
Problem solving

Education

Bachelor’s degree (rising senior)
Accounting, Finance, Real Estate, Economics, STEM or Business

Tools

Power BI
Tableau
SQL
Python
R

Job description

AIR Communities in Denver/Chicago is offering a 10-week Rotational Analyst Program for rising seniors. You will gain exposure to Debt Capital Markets, FP&A, Insights, Investments, Asset Management, and Operations Finance, with rotations starting for those who return as Full-Time Analysts.

During the program, you will conduct data analyses, build dashboards, support budgeting and forecasting, and collaborate across teams to drive portfolio optimization.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Rotational Analyst—Finance & Analytics Program
Rotational Analyst—Finance & Analytics Program

The Federal Home Loan Bank of Chicago • Chicago (IL)

On-site
USD 56,000 - 84,000
401k and Pension
Medical, dental and vision insurance
Lifestyle Spending Account
+2
Finance & Analytics Summer Analyst — Rotational Program
Finance & Analytics Summer Analyst — Rotational Program

JP Morgan Chase • Chicago (IL)

On-site
USD 34,000 - 48,000
Finance Rotational Analyst: AI-Enabled Analytics
Finance Rotational Analyst: AI-Enabled Analytics

ICU Medical • Lake Forest (IL)

Hybrid
USD 58,000 - 72,000
401(k) match
Tuition Reimbursement
Paid Time Off
+1
Global Finance Rotations Analyst (Early Career)
Global Finance Rotations Analyst (Early Career)

ADM • Decatur (IL)

On-site
USD 48,000 - 73,000
Paid time off
Tuition assistance
LinkedIn Learning access
+1
Finance Analyst Rotational Program - Launch Your Career
Finance Analyst Rotational Program - Launch Your Career

RELX International • Miamisburg (OH)

On-site
USD 49,000 - 82,000
Finance Development Program - Rotational Associate
Finance Development Program - Rotational Associate

UL Solutions • Northbrook (IL)

On-site
USD 60,000 - 74,000
Sign-on bonus
Housing relocation assistance
Health, dental, vision
+2
Finance Rotational Analyst: Jumpstart in FP&A, AR, AP
Finance Rotational Analyst: Jumpstart in FP&A, AR, AP

Idi-Distributor • Chanhassen (MN)

On-site
USD 55,000 - 75,000
Wealth Management Summer Analyst (Rotational)
Wealth Management Summer Analyst (Rotational)

NFP • Chicago (IL)

On-site
USD 28,000 - 30,000
Wealthspire Internship Program
Finance Rotational Specialist: Analytics & Plant Ops
Finance Rotational Specialist: Analytics & Plant Ops

Solstice Advanced Materials • Morris Plains (NJ)

On-site
USD 67,000 - 83,000
Medical Insurance
Dental Insurance
Vision Insurance
+5
Finance Leadership Rotational Program — 2-Year Track
Finance Leadership Rotational Program — 2-Year Track

Paramount • New York (NY)

On-site
USD 72,000 - 88,000
Mentorship program
AI training
Capstone project
+2