Summer Finance Rotational Analyst (Data & Analytics)

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

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.