Rotational Finance & Analytics Intern

AIR Communities; Denver (CO); On-site; USD 51,000 - 54,000; Full time

Job summary

AIR Communities in Denver, CO is offering a 10-week Rotational Analyst Internship, designed for rising seniors, with campus-ready teams across Debt Capital Markets, FP&A, Insights, Investments, Asset Management and Operations Finance. The program starts June 2027 and runs through August 2027, with in-office rotations in Denver or Chicago.

Interns gain hands-on experience, build dashboards with Power BI, analyze datasets, support budgeting and forecasting, and contribute to strategic initiatives

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 (Power BI, Tableau) and/or analytical coding language (SQL, Python, R) is a plus.
• Ability to work in Chicago or Denver in a full-time capacity for 10 weeks, beginning in June 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

Data analysis

Cross-functional collaboration

Attention to detail

Analytical thinking

Problem solving

Data visualization

Education

Rising senior

Bachelor’s degree in progress in accounting/finance/real estate/economics/STEM/business

Tools

Power BI

Tableau

SQL

Python

R

Excel

Word

PowerPoint

Job description

AIR Communities in Denver, CO is offering a 10-week Rotational Analyst Internship, designed for rising seniors, with campus-ready teams across Debt Capital Markets, FP&A, Insights, Investments, Asset Management and Operations Finance. The program starts June 2027 and runs through August 2027, with in-office rotations in Denver or Chicago.

Interns gain hands-on experience, build dashboards with Power BI, analyze datasets, support budgeting and forecasting, and contribute to strategic initiatives