Asset Management Data Analyst (Associate Level)

Description

• Decisions made with thorough knowledge of procedures and company policies to achieve set results and deadlines. Responsible for setting own project deadlines.
• Gather data to analyze, identify trends, patterns, and anomalies, and interpret the findings.
• 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 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.
• Create, standardize, and maintain documentation for data models, reports, and dashboards, including instructions, sources, definitions, and controls.

Requirements

• 6+ 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.
• 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.
• 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.
• Ability to comprehend, analyze, and interpret documents. Ability to solve problems involving several options in situations. Requires intermediate analytical and quantitative skills.
• 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.
• Experience with Power BI, Power Query, DAX, data modeling, and understanding relational dataflows and databases.
• 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.
• Proficiency with Microsoft Office applications. Expertise in using spreadsheet programs, including Microsoft Excel, and presentation programs, including PowerPoint, required.
• Bachelor's degree from four-year college or university in real estate, finance, accounting, economics, statistics, and/or data analytics required.
• 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.
• 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.
• Requires the ability to sit or stand for extended periods. Minimal physical effort in the day-to-day tasks.
• Excellent communication and interpersonal skills, with the ability to effectively communicate complex data concepts to both technical and non-technical audiences.

Benefits

Training + Development

Interview process

Visa Sponsorship

Security clearance