Lincoln Avenue Communities · 7 hours ago
Business Analytics Intern (Summer 2026)
Santa Monica, CA
Internship
Onsite
Intern
$25/hr - $25/hr
Start in 2026 SummerLincoln Avenue Communities is a leading, mission-driven real estate private equity firm dedicated to strengthening communities through affordable housing. The Business Analytics Intern will support the Asset Management team by developing analytics to drive portfolio performance and operational efficiency, while gaining hands-on experience in real estate asset management and data analytics tools.
Real EstateProperty ManagementService Industry
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
Qualification
Required
Ability to define, calculate, and document business metrics consistently
Experience analyzing datasets to identify trends, anomalies, and insights
Ability to synthesize findings into clear narratives that support business decisions
Familiarity with Power BI, Tableau, or similar BI platforms for building dashboards and reports
Proficiency with pivot tables, VLOOKUP, formulas, and data manipulation
Strong ability to write complex queries, joins, aggregations, and subqueries (MySQL, PostgreSQL, SQL Server, or Azure SQL)
Understanding of relational database design, normalization, indexing, and query optimization
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
Benefits
$4,000 living stipend for the summer
Company
Lincoln Avenue Communities
Lincoln Avenue Capital Management engages in property management and real estate services.
Founded in 2016
51-200 employees
H1B Sponsorship
Lincoln Avenue Communities has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (2)
2020 (1)
Funding
Current Stage
Growth StageTotal Funding
$96.32MKey Investors
Ohio Capital Corporation for HousingOCFC lendingSANTA FE COUNTY
2026-02-05Undisclosed· $51M
2026-02-05Debt Financing· $5M
2025-06-05Debt Financing· $40.32M
Leadership Team
Jeremy Bronfman
Chief Executive Officer
Thom Amdur
Senior Vice President, Policy & Impact
Recent News
The Journal Record
2025-11-19
Company data provided by crunchbase