What are the responsibilities and job description for the Property Management Analyst position at Friendly Franchisees Corp?
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–2 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
Salary : $18 - $22