Lincoln Avenue Communities-logo
Lincoln Avenue Communities
ยท
April 19, 2025
Apply Now
This job has closed.

Information Technology (Data Analytics) Internship (Summer 2025)

Santa Monica, CA
Internship
Hybrid
Intern
Lincoln Avenue Capital Management engages in property management and real estate services. The Data Analytics Internship offers an excellent opportunity for aspiring IT professionals to gain hands-on experience by transforming raw data into meaningful insights that drive business decisions.

Responsibilities

  • 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.

Qualification

Required

  • Analytical, Detail-oriented, And Eager To Learn.
  • 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

  • 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.

Benefits

Lincoln Avenue Capital Management engages in property management and real estate services.
Glassdoor
Founded in 2016
Santa Monica, California, USA
51-200 employees
https://www.lincolnavenue.com/
Discover Full DA Internship List