Business Analytics Intern (Summer 2026)

Lincoln Avenue Communities•Santa Monica, CA

4h•$25•Onsite

About The Position

Welcome to Lincoln Avenue Communities (LAC)—a leading, mission-driven real estate private equity firm dedicated to strengthening communities through the development and preservation of affordable housing. As a vertically integrated developer, investor, and long-term operator, we deliver sustainable, high-quality homes to lower- and moderate-income individuals, seniors, and families across 32 states. Our growing portfolio—more than 180+ properties and 30,000+ homes—reflects our commitment to long-term impact, operational excellence, and resident well-being. LAC is proud to be recognized as an industry leader, recently ranked No. 1 on Affordable Housing Finance’s 2025 AHF 50 list of top developers. Our approach combines strategic investment, thoughtful design, and community partnerships to deliver housing solutions that foster stability, opportunity, and resilience. About Our Summer Internship Program Our internship program goes beyond the ordinary. Here, you won’t just be a participant but an integral part of our innovative projects, learning and growing in an environment that fosters creativity and independence. If you share our vision of raising the standards in affordable housing, we invite you to embark on this journey with us. Let’s build a future where your ideas matter, your skills are honed, and your impact is real. This 10-week paid Summer Internship Program has been developed for students to gain practical training and hands-on experience that will help them meet their educational goals and prepare them for their professional careers in real estate. When creating our Program, we carefully assessed what made an internship experience meaningful. Our goal is to provide you with a dynamic and engaging learning experience, and the opportunity to develop while having dedicated support around you. Important Reminders: Our 10-week program begins June 1, 2026, and ends August 7, 2026. We encourage students who are graduating in May/June 2027 to apply. This is a full-time role based in our Santa Monica office. What You’ll Do This internship provides hands-on experience supporting the Asset Management team by helping build and scale analytics that drive portfolio performance, operational efficiency, and strategic decision-making. You’ll work closely with Asset Management, IT, and Analytics partners to assist in supporting foundational data models and translating complex datasets into actionable business insights. Over the course of the internship, you’ll contribute to the development of our analytics ecosystem while gaining exposure to real estate asset management, data warehousing, and business intelligence tools.

Requirements

Metric Development & KPI Design: Ability to define, calculate, and document business metrics consistently
Exploratory Data Analysis (EDA): Experience analyzing datasets to identify trends, anomalies, and insights
Data Storytelling: Ability to synthesize findings into clear narratives that support business decisions
Data Visualization Tools: Familiarity with Power BI, Tableau, or similar BI platforms for building dashboards and reports
Excel Advanced Skills: Proficiency with pivot tables, VLOOKUP, formulas, and data manipulation
SQL Proficiency: Strong ability to write complex queries, joins, aggregations, and subqueries (MySQL, PostgreSQL, SQL Server, or Azure SQL)
Database Fundamentals: Understanding of relational database design, normalization, indexing, and query optimization
Python or R: Experience using Python (pandas, numpy) or R for data manipulation and scripting
Proactive, curious, and eager to learn modern data analytics and engineering practices
Strong analytical thinking with attention to detail in data validation and documentation
Excellent communication skills, ability to translate technical concepts for business audiences
Collaborative mindset and ability to work cross-functionally with IT, Finance, and Operations teams

Responsibilities

Support the Asset Management team by developing analytics that track asset performance, operating trends, and key financial and operational metrics
Assist in building standardized metrics and reporting views used for portfolio monitoring and decision-making
Partner with analytics manager and other asset management stakeholders to understand reporting needs and translate them into clear analytical outputs
Help document definitions, assumptions, and logic behind key metrics to ensure consistency and transparency
Build and enhance reports in Power BI to deliver actionable insights to Asset Management and leadership teams
Design intuitive, executive-ready reporting that clearly communicate trends, risks, and opportunities
Iterate on reports based on stakeholder feedback and evolving business needs
Extract, clean, and transform data from structured and semi-structured sources (property management systems, APIs, Excel, CSV files)
Identify data quality issues and assist with validation, reconciliation, and ongoing data accuracy checks
Develop reusable data cleaning and transformation logic using SQL and/or Python
Document data sources, transformation logic, and data quality rules to support long-term scalability
Assist with building and maintaining ETL/ELT pipelines that feed the analytics data warehouse
Support the design and organization of analytical data models optimized for reporting and business analysis
Help with basic database optimization, performance checks, and query validation
Gain exposure to data warehouse design concepts as the platform is built out and scaled