FP&A Summer Intern - Business Intelligence
About The Position
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.
Requirements
- Currently pursuing or recently completed a bachelor’s or advanced degree in Data Analytics, Data Science, Computer Science, or a related field.
- 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.
- 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.
Nice To Haves
- Preference for candidates graduating by Spring 2025.
- Experience with at least one of the following technologies: Python, R, Microsoft Power Platform, or Azure.
- Experience with BI dashboarding tools such as Tableau, Power BI, Incorta, Looker, or similar.
- Familiarity with database modeling and/or best practices for database management.
Responsibilities
- 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.
Benefits
- Competitive salary
- Comprehensive health benefits
- Life, long and short-term disability insurance
- 401(k) with company match
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Intern
