Data Engineering Internship (Summer 2026)

AI overview

Gain hands-on experience in IT operations, focusing on data engineering projects including ETL processes, database optimization, and dashboard development in a collaborative environment.

About Lincoln Avenue Communities

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.

Our 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 is an excellent opportunity for an aspiring IT professional to gain hands-on corporate experience in a fast-paced, entrepreneurial environment.


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 offers hands-on experience supporting the IT Operations team, providing exposure to key IT strategy initiatives, technical skills, and an introduction to AI & analytics in a dynamic environment. This summer, you will:

Data Pipeline & Database Engineering

  • Build and maintain ETL/ELT data pipelines from multiple sources (Yardi, RealPage, Azure SQL, APIs) into our data warehouse
  • Design, optimize, and query relational databases using SQL Server and Azure SQL Database
  • Perform data quality checks, validation, and monitoring to ensure pipeline reliability
  • Assist with database performance tuning and optimization efforts


Data Cleaning & Transformation

  • Extract, clean, preprocess, and transform data from structured and semi-structured sources (databases, APIs, Excel, CSV)
  • Develop reusable data cleaning scripts using Python or SQL to ensure data accuracy and consistency
  • Document data lineage, transformation logic, and data quality rules


Application Development & Presentation Layer

  • Build user-facing dashboards and reports in Power BI to deliver actionable insights to business stakeholders 
  • Design intuitive data visualizations that translate complex datasets into clear, executive-ready presentations
  • Collaborate with business users to gather requirements and iterate on reporting solutions
  • Contribute to internal application development projects

Requirements

What We’re Looking For

Required Technical Skills

  • SQL Proficiency: Strong ability to write complex queries, joins, aggregations, and subqueries (MySQL, PostgreSQL, SQL Server, or Azure SQL)
  • Data Cleaning & Transformation: Hands-on experience preprocessing, cleaning, and structuring data for analysis
  • 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
  • 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


Preferred Skills

  • Experience with cloud data platforms (Azure Data Factory, Azure SQL, AWS, or GCP)
  • Exposure to ETL/ELT processes and data pipeline orchestration
  • Familiarity with version control (Git/GitHub) and collaborative development workflows
  • Knowledge of APIs and data integration patterns
  • Experience with Power Automate or workflow automation tools
  • Understanding of data modeling concepts (dimensional modeling, star schemas)


Professional Attributes

  • Proactive, curious, and eager to learn modern data 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

  • This is a non-exempt, hourly position paying $25.00 per hour, with eligibility for overtime.
  • Students residing outside of Los Angeles County are also eligible in receiving a $4,000 living stipend for the summer.

Headquartered in Santa Monica, CA, Lincoln Avenue Communities (LAC) is a real estate private equity firm that owns, develops and invests in low-income, subsidized housing communities nationwide. We are a dynamic and entrepreneurial real estate private equity firm that strengthens communities. As a developer, investor, and operator, we provide sustainable, high-quality homes for lower- and moderate-income individuals, seniors, and families across 25 states. With a portfolio encompassing 130+ properties and 20,000+ units, we are committed to creating lasting impacts on the lives of our residents and the communities we serve.LAC has built a team with deep experience in finance, investments, and affordable housing. Through our diversity of backgrounds and experience, we have a deep commitment to ensuring the delivery of quality, stable housing communities to its residents while providing financial and social returns for its investors. Our success to date and growth ambitions offer its employees a unique value proposition: "Start-up" mindset looking to innovate across its business. High-growth company with ambitious targets to become one of the major owners of subsidized housing in the country. LAC offers career growth and wealth creation opportunities for employees, both near- and long-term. Growing organization with a meritocratic structure based on team collaboration and accountability. We move at a fast pace and offer employees opportunities to showcase their knowledge and experience in ways that add value to the company. Fun, work hard/play hard culture: the company values results first and foremost and has a strong, supportive, collaborative culture. LAC is a double-bottom-line business where each employee can make a meaningful difference in residents' lives within our communities. LAC is actively seeking team members who have rigorous institutional experience and standards but a dynamic, entrepreneurial spirit as the firm positions itself for continued growth. For more information on LAC, please visit lincolnavenue.com.

View all jobs
Salary
$25 per hour
Ace your job interview

Understand the required skills and qualifications, anticipate the questions you may be asked, and study well-prepared answers using our sample responses.

Data Engineer Q&A's
Report this job
Apply for this job