Rotational Finance Analytics Internship

SmartRecruiters, Inc.; Colorado; On-site; USD 45,000 - 61,000; Full time

Job summary

AIR Communities in Denver, CO or Chicago, IL offers a 10-week Rotational Analyst Program designed for rising seniors pursuing a bachelor’s degree. The internship exposes you to Debt Capital Markets, FP&A, Insights, Investments, Asset Management and Operations Finance, with rotations starting for full-time analysts.

During the program you will work on data analysis, dashboards, and forecasting, gaining hands-on experience across finance and real estate operations.

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

Analytical thinking

Attention to detail

Organizational skills

Data visualization

SQL

Team collaboration

Education

Bachelor's degree

Tools

Power BI

Tableau

RealPage

Oracle PBCS

Job description

AIR Communities in Denver, CO or Chicago, IL offers a 10-week Rotational Analyst Program designed for rising seniors pursuing a bachelor’s degree. The internship exposes you to Debt Capital Markets, FP&A, Insights, Investments, Asset Management and Operations Finance, with rotations starting for full-time analysts.

During the program you will work on data analysis, dashboards, and forecasting, gaining hands-on experience across finance and real estate operations.