What are the responsibilities and job description for the Property Management Analyst position at friendlyfranchiseescorporation?
Property Management Analyst
Location: La Palma, CA
Employment Type: Full-Time
Industry: Real Estate / Property Management
About the Role
We are seeking a detail-oriented and data-driven Property Management Analyst to support our property operations, financial performance, and asset optimization efforts. The ideal candidate combines strong analytical skills with hands-on experience in SQL and data visualization to turn raw property data into actionable insights for leadership and operations teams.
Key Responsibilities
- Data Analysis & Reporting
- Collect, clean, and analyze property performance data across multiple portfolios.
- Develop and maintain SQL queries, stored procedures, and scripts to extract and manipulate data from property management systems (e.g., Yardi, MRI, RealPage, Entrata).
- Build dashboards and reports to track occupancy, rent collections, expenses, and capital expenditures.
- Automate recurring reports and improve data workflows for operational efficiency.
- Financial Performance & Forecasting
- Support budgeting, forecasting, and variance analysis for managed assets.
- Analyze trends in rent rolls, leasing activity, and operating costs to identify opportunities for revenue growth and expense optimization.
- Partner with property managers, leasing teams, and accounting to ensure data integrity and accurate reporting.
- Operational Insights
- Evaluate KPIs such as NOI, occupancy rate, lease expirations, and delinquency to provide data-backed recommendations.
- Conduct market and portfolio benchmarking using internal and external data sources.
- Support acquisition and disposition analysis with property-level financial models.
- System & Process Optimization
- Serve as the internal expert for data extraction, reporting, and visualization tools.
- Collaborate with IT and operations teams to enhance data systems and integration processes.
- Ensure data accuracy, consistency, and security across property databases.
Qualifications
- Education: Bachelor’s degree in Finance, Real Estate, Data Analytics, Business, Economics, or related field.
- Experience: 0–5 years of experience in property management, real estate analytics, or asset management.
- Technical Skills:
- Proficiency in SQL (writing queries, joins, CTEs, and stored procedures).
- Experience with Excel, Power BI, or Tableau.
- Familiarity with property management software (Yardi, RealPage, MRI, etc.).
- Strong understanding of financial statements, KPIs, and real estate metrics.
- Soft Skills:
- Analytical mindset with high attention to detail.
- Strong communication and presentation skills.
- Ability to work cross-functionally with operations, accounting, and leadership teams.
Preferred
- Experience in multi-family, commercial, or mixed-use property portfolios.
- Knowledge of ETL tools, data warehousing, or scripting languages (Python/R) is a plus.
Compensation & Benefits
- Competitive salary based on experience
- Performance-based bonus eligibility
- Comprehensive health, dental, and vision coverage
- 401(k)
- Opportunities for career growth within the real estate and property management sector