What are the responsibilities and job description for the Information Technology (Data Analytics) Internship (Summer 2025) position at Lincoln Avenue Communities?
About Lincoln Avenue Communities
Welcome to Lincoln Avenue Communities (LAC)! 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 28 states. With a portfolio encompassing 150 properties and 20,000 units, we are committed to creating lasting impacts on the lives of our residents and the communities we serve.
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 2, 2025, and ends August 8, 2025.
- This a full-time role based in our Santa Monica HQ (at least 4 days in the office).
- This is an hourly paid position that is full-time (40hrs a week).
Responsibilities:
As a Data Analytics Intern, you’ll play a key role in supporting our team by transforming raw data into meaningful insights that drive business decisions. Your work will involve:
- Collecting and consolidating data from various sources, including databases, APIs, and Excel files.
- Cleaning, preprocessing, and organizing data to ensure quality and accuracy.
- Building reports, dashboards, and visualizations using tools like RealPage, Power BI, and Excel.
- Communicating findings clearly and concisely to stakeholders to support strategic initiatives.
- Applying statistical methods to analyze trends and uncover data-driven insights.
- Identifying and tracking key metrics to support business performance and improvement.
- Conducting trend analysis and exploring predictive modeling techniques.
- Leveraging tools such as SQL, Python, R, and Excel for analysis and reporting.
- Assisting in data management and maintenance across databases and internal systems.
Preferred Skills & Qualifications:
We’re looking for someone who is analytical, detail-oriented, and eager to learn. Experience or familiarity with the following will be considered a plus:
- SQL: Ability to query relational databases (e.g., MySQL, PostgreSQL, SQL Server).
- Data Cleaning: Comfort with data preprocessing, formatting, and validation techniques.
- Excel: Proficiency with advanced Excel functions, including pivot tables, formulas, and macros.
- KPI Analysis: Ability to calculate, track, and interpret key performance indicators.
