View All Jobs

Sign up

FP&A Summer Intern - Business Intelligence

YES Communities

Posted 2 months ago

Internship

Denver, Colorado

In Person

Smart Summary

Responsibilities

The intern will support financial planning and analysis by developing BI dashboards and optimizing reporting processes using large datasets. They will also validate data pipelines, perform data cleaning, and collaborate with cross-functional teams on key business initiatives.

Qualifications

We are seeking enthusiastic interns pursuing or recently completing a degree in Data Analytics, Data Science, or Computer Science. Candidates should be proficient in SQL and possess experience with BI dashboarding tools and Microsoft Excel. Strong analytical, problem-solving, and communication skills are essential for this role.

Job Description

.

2026 Summer Internship, FP&A – Business Intelligence
Denver, CO

Founded in 2008, YES Communities is a privately held Real Estate Investment Trust (REIT) in the manufactured housing industry.

We are seeking enthusiastic and driven interns to join our Financial Planning & Analysis (FP&A) team for Summer 2025, supporting key Business Intelligence (BI) initiatives across the company. As a BI intern, you will play a key role in supporting critical data and reporting initiatives while gaining hands-on experience in a dynamic and fast-paced environment.

Over the course of the internship, you will collaborate with our team to gain exposure to our award-winning operating platform and develop a comprehensive understanding of our data visualization tools, data warehouse framework, and other key areas of the business we support.

What You’ll Do

  • Work with large datasets to streamline and optimize reporting processes.
  • Develop and maintain BI dashboards in Incorta to visualize key metrics and support data-driven decision-making.
  • Validate and troubleshoot data pipelines to ensure data integrity and optimize performance.
  • Support data cleaning, merging, and quality control processes.
  • Document business processes, data workflows, and dataset structures.
  • Collaborate with cross-functional teams on company initiatives.
  • Use SQL to retrieve, structure, and analyze data for ad hoc reporting requests.

Qualifications

  • Currently pursuing or recently completed a bachelor’s or advanced degree in Data Analytics, Data Science, Computer Science, or a related field. Preference for candidates graduating by Spring 2025.
  • Ability to work full-time (40 hours per week) for a minimum of 10 weeks in our Denver office.
  • Availability to start by June 2025.
  • Proficiency in SQL, with the ability to write queries for data extraction, transformation, and analysis.
  • Proficiency in Microsoft Excel and experience with at least one of the following technologies: Python, R, Microsoft Power Platform, or Azure (preferred).
  • Experience with BI dashboarding tools such as Tableau, Power BI, Incorta, Looker, or similar (preferred).
  • Strong written and verbal communication skills, with exceptional attention to detail.
  • Excellent analytical and problem-solving skills, with the ability to interpret data and communicate insights.
  • Self-starter with a demonstrated passion for learning and applying new technologies.
  • Familiarity with database modeling and/or best practices for database management (preferred).

This internship opportunity may also serve as a pathway to a full-time position within YES Communities.

The YES Difference

Competitive salary | Comprehensive health benefits | Life, long and short-term disability insurance | 401(k) with company match

YES I can help * YES We are a team * YES We add value * YES We build community

YES Communities is an Equal Opportunity Employer

YES Communities

YES Communities, founded in 2008, owns and operates manufactured housing communities in many states. YES takes a new approach to manufactured home communities and works to build and maintain an environment in each community that reflects their positive YES attitude. YES’s unique operating model, personal approach and strong corporate culture has garnered it the Community Operator of the Year award by the Manufactured Housing Institute for the past ten years. At YES! Communities we look at Manufactured Housing Communities in a whole new way! Too many times in the past manufactured home communities had the reputation of saying NO! to home loans, leasing agreements and requests due to their stringent guidelines and rules. We want our residents to be part of a different type of community, where they are truly hearing YES! to creating a community that is all their own. 

 YES! Communities provides customers with affordable housing options, a community that is well-maintained, clean, and attractive, as well as an atmosphere that builds a true community around its residents. YES! Communities offers homes for any size of family or budget. We have high-quality factory-built homes ranging from single to multi-section, fitting every stage of life.
Runway Icon
Boost Your Interview Chances

With Runway

See Your Fit for This Role

1-5 min

Your Score

?

Top Applicants

90%

Your Job Search Advantage

Key Gaps & Next Steps:

Address these in your resume & Interview

Top Strengths For This Role

Highlight these in your cover letter & interview

Your Interview Guide

A Personalized Interview Strategy

Freshest Opportunities

Never Miss a Good Fit

Get notified when jobs mach your criteria