Senior Real Estate Analyst

At Mill Creek Residential We Are Committed To Building A Diverse, Equitable And Inclusive WorkplaceMill Creek Residential ("MCR") is seeking a qualified candidate for the Senior Real Estate Finance Analyst position to provide critical property investment valuation, planning, analysis and reporting support for MCR portfolio investments in assigned real estate markets. This position will report to the Director of Real Estate Finance and support other members of the Real Estate Finance Team. This position will have regular interactions with executive management, including responding to direct inquiries, communicating results, and providing perspective on property investment analyses. A proactive and adaptive attitude is required for this highly visible role. The role will provide an excellent foundation for professional growth across various functional areas within residential real estate development.Essential FunctionsManage detailed investment financial models (property cash flows, joint venture waterfall structures) for properties in assigned real estate markets to support critical and time sensitive planning, reporting and analysis needs of MCR.Support development pipeline efforts for prospective property investment, including pro forma model changes and managing modeling assumptions for multiple underwriting scenarios.Review and understand property investment closing documents.Review and understand quarterly and annual residential property investment appraisals and other valuation report types (debt, purchase price accounting) used for financial reporting purposes.Research sub-market, market and industry trends and patterns.Provide investment model insight and recommendations to key stakeholders.Prepare investor presentations and property operating performance and investment return metrics.Assist in the preparation of Valuation Committee memorandums.Special projects.All other duties as assigned.ExpectationsDetail oriented with strong organizational skills.Ability to analyze data and provide quantitative solutions.Ability to multi-task and manage a complex workload to meet reporting deadlines, and function in a fast-paced environment.Strong communication skills with the ability to effectively interact with senior leadership.Ability to multi-task and manage a complex workload to meet reporting deadlines, and function in a fast-paced environment.Required Experience And Minimum QualificationsBachelor's degree in finance, mathematics, accounting, or similar degree.Microsoft Office Suite, including advanced Excel-modeling skills.Minimum of 1-3 years of experience in real estate finance, investment analysis, or a related field, preferably in a multifamily development and/or acquisition business model.Knowledge of core real estate investment underwriting and valuation concepts.Experience modeling property cash flows and historical and projected GP-LP investor waterfall returns.Preferred QualificationsUnderstanding of and ability to analyze company financial statements.Programming experience, such as VBA/Macro-coding skills.Experience with the use of Vena Solutions.Certifications (Optional But Preferred):CFAChartered Financial Analyst (or aspiring candidate)Other relevant corporate finance and/or real estate professional certifications (e.g., CFI-FMVA, REFM).Mill Creek is an Equal Opportunity EmployerAre You Ready To Contribute To The Success Of Mill Creek Residential? If So, Apply Today And Become Part Of An Organization That Believes In Uncompromising Integrity, Celebrating Successes, Continuous Improvement, And Working Hard, Smart And Together