2027 Summer Finance Internship

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

Company Description

AIR Communitiesis a Blackstone Portfolio Company headquartered in Denver, CO. We are one of the country's largest owners and operators of multifamily housing, managing high-quality properties in most major markets.At AIR,we value integrity, respect, collaboration, customer focus, and performance.These values are brought to life by our teammates, who are ultimately responsible for our success.When you join our team, you'll work alongside the most dedicated professionals in the industry andopen the door to unlimited career opportunities.

Where You Will Work

This opportunity is physically located in either our Denver, CO headquarters or our Chicago, IL office. This will be a fully in-office, 5-day a week, position in either of our offices.

This role is intended for Rising Seniors with an expected graduation date of Spring 2028.

Job Description

What You Will Do

Our summer internship helps provide insight into life as an AIR Analyst in our Rotational (Medley) Analyst Program and was created to develop and invest in our future talent. The purpose of the Rotational Analyst Program is to provide team members who are early in their careers with a deep, holistic understanding of AIR’s business and the multifamily investment and operations space. During the Program, Analysts gain exposure to a range of teams including, but not limited to, Debt Capital Markets, FP&A, Insights, Investments, Asset Management, and Operations Finance.

Please note that throughout the 10-week internship, you will sit on one of the teams listed above rotations start for those who return as Full-Time Analysts! Our 2027 summer internship program will begin June 2027 and last through August 2027.

A Snapshot Of What You May Do

• 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.

Qualifications

• Must be a rising senior pursuing a bachelor’s degree during the time of 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

Additional Information

What We Offer

We know that if we take care of our team, everything else will fall into place. We aren’t perfect, but we will try to set very clear expectations, always let you know where you stand, and do everything in our power to kickstart your career.

The compensation for this role is $38.46 per hour.

What You Need To Know

Application Deadline: 10/12/2026.

We will be conducting interviews throughout the month of November, with the goal of filling our class in early December. Applications submitted after this date may still be considered on a rolling basis until the position/program is filled. We encourage all interested candidates to apply as early as possible. If a final decision has not been made by the initial deadline, subsequent applications will be reviewed as they are received.

Candidates extended an offer will be required to undergo pre-employment screening that includes checking references, a four-panel drug screening that excludes marijuana testing, employment verification & criminal background check.

AIR values diversity and provides equal employment opportunities to all employees and applicants for employment. AIR prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.