The Asset Management team at Essex is looking to enhance asset value by maximizing property cashflows and investment returns, and this role will focus on financial reporting, data analysis, and strategic initiatives to drive the team's success.
Requirements
- Proficiency with Microsoft Office applications.
- Expertise in using spreadsheet programs, including Microsoft Excel, and presentation programs, including PowerPoint.
- Advanced Excel modeling skills, including financial projections and scenario analysis.
- 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.
- Strong financial literacy with the ability to interpret and analyze income statements, balance sheets, and other financial documents.
- Proficient in creating and analyzing complex data sets, formulas, and PivotTables for data reporting and insights.
Responsibilities
- 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.
- Advanced Excel modeling skills, including financial projections and scenario analysis.
Other
- Bachelor's degree from four-year college or university in real estate, finance, accounting, economics, statistics, and/or data analytics required.
- Minimum of 6 years of experience in real estate, data analytics/business intelligence, investment management, or financial planning & analysis is required.
- Excellent communication and interpersonal skills, with the ability to effectively communicate complex data concepts to both technical and non-technical audiences.
- Ability to work Monday through Friday, with in-person work requirements consistent with the hybrid policy located at Essex's corporate office in Irvine.
- Ability to sit or stand for extended periods, with minimal physical effort in the day-to-day tasks.
