Rotational Finance Internship: Data Analytics & Insights

SmartRecruiters, Inc.; Denver (CO); On-site; USD 52,000 - 54,000; Full time

Job summary

AIR Communities in Denver, CO is offering a 10‑week Rotational Analyst Internship beginning June 2027 for rising seniors pursuing a bachelor’s degree in accounting, finance, real estate, economics, STEM or business. The program provides exposure to Debt Capital Markets, FP&A, Insights, Investments, Asset Management, and Operations Finance.

Participants will work on data analysis, dashboards, budgeting, forecasting, and cross‑team projects in an in‑office setting in Denver or Chicago, with a

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

• Analyze large datasets to uncover actionable insights related to asset performance.
• 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

Excel

Power BI

Tableau

SQL

Python

R

PowerPoint

MS Word

Education

Bachelor's degree (pursuing)

Tools

RealPage

Oracle PBCS

Job description

AIR Communities in Denver, CO is offering a 10‑week Rotational Analyst Internship beginning June 2027 for rising seniors pursuing a bachelor’s degree in accounting, finance, real estate, economics, STEM or business. The program provides exposure to Debt Capital Markets, FP&A, Insights, Investments, Asset Management, and Operations Finance.

Participants will work on data analysis, dashboards, budgeting, forecasting, and cross‑team projects in an in‑office setting in Denver or Chicago, with a