
Senior Analyst – Real Estate & Portfolio Management Analytics
- Orange County, CA
- $91,000-136,000 per year
- Permanent
- Full-time
- Gather data to analyze, identify trends, patterns, and anomalies, and interpret the findings.
- Create visualizations reflecting various KPIs and financial performance.
- Support the Asset Management team by providing property and portfolio level reporting and dashboards for strategic decision-making.
- Assist in establishing financial targets, collaborating with stakeholders cross-departmentally, and compiling comprehensive budgets and forecasts.
- Develop and maintain Power BI models by utilizing Power Query and DAX to transform raw data into a usable format, ensuring data accuracy, consistency, and performance within the data model.
- Create, standardize, and maintain documentation for data models, reports, and dashboards, including instructions, sources, definitions, and controls.
- Bachelor's degree from four-year college or university in real estate, finance, accounting, economics, statistics, and/or data analytics required.
- 3+ years of experience in real estate, data analytics/business intelligence, investment management, or financial planning & analysis is required. Experience in multifamily real estate is preferred.
- Strong financial literacy with the ability to interpret and analyze income statements, balance sheets, and other financial documents.
- Proficiency with Microsoft Office applications. Expertise in using spreadsheet programs, including Microsoft Excel, and presentation programs, including PowerPoint, required.
- Advanced Excel modeling skills, including financial projections and scenario analysis. Proficient in creating and analyzing complex data sets, formulas, and PivotTables for data reporting and insights.
- Experience with Power BI, Power Query, DAX, data modeling, and understanding relational dataflows and databases.
- Experience with capital expenditure (CapEx) systems, such as Yardi Voyager, preferred.
- Excellent communication and interpersonal skills, with the ability to effectively communicate complex data concepts to both technical and non-technical audiences.
- Operates in a fast-paced work setting. Requires the ability to multitask and adapt quickly to changing priorities. May involve tight deadlines and high-energy work situations.
- Work is primarily conducted in an office setting. Requires sitting at a desk or workstation for extended periods. Involves the use of standard office equipment such as computers, phones, and printers.
- Requires the ability to work Monday through Friday. The position includes in-person work requirements consistent with the hybrid policy located at Essex's corporate office in Irvine. The hybrid policy is subject to change at Essex’s sole discretion.
- Requires the ability to sit or stand for extended periods. Minimal physical effort in the day-to-day tasks.
- Excellent written and verbal communication skills. Strong organizational and analytical skills. Ability to provide efficient, timely, reliable and courteous service to customers. Ability to effectively present information.
- Ability to comprehend, analyze, and interpret documents. Ability to solve problems involving several options in situations. Requires intermediate analytical and quantitative skills.
- Decisions made with thorough knowledge of procedures and company policies to achieve set results and deadlines. Responsible for setting own project deadlines.