2027 Summer Finance Internship

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

• Compensation: USD 38.46 - USD 38.46 - hourly

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

What you have:

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:The initial deadline for applications is10/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-paneldrug screening thatexcludes 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.