Overview

　　CommonSpirit Health was formed by the alignment of Catholic Health Initiatives (CHI) and Dignity Health. With more than 700 care sites across the U.S. from clinics and hospitals to home-based care and virtual care services CommonSpirit is accessible to nearly one out of every four U.S. residents. Our world needs compassion like never before. Our communities need caring and our families need protection. With our combined resources CommonSpirit is committed to building healthy communities advocating for those who are poor and vulnerable and innovating how and where healing can happen both inside our hospitals and out in the community.

　　Responsibilities

　　The Real Estate Lease Analyst is responsible for independently managing the integrity of real estate portfolio data for a complex portfolio and providing related direct support to the Corporate Real Estate team. This includes all the responsibilities listed in the Accountabilities Sections below.

　　The Real Estate Lease Analysis performs his/her duties by adhering to the highest standards of ethical and moral conduct acts in the best interest of Common Spirit and fully supports Common Spirit’s Mission Philosophy and core values of Collaboration Dignity Excellence Justice and Stewardship.

　　Scope of Accountabilities:

　　Update the Common Spirit Owned and Leased Property Database as new facilities are acquired sold or leased.

　　Prepares lease abstracts and edits them for accuracy and also has the ability to manage a 3 rd party abstractor to ensure a high level of quality.

　　Track payables and receivables associated with the leases in the portfolio and prepares the appropriate supporting documentation and rent reports for approvals.

　　Prepare invoices for subtenants reconciles subtenant accounts reviews incoming invoices for errors/accuracy with lease document and ensures correct coding.

　　Prepares and distributes critical date reports maintains lease management system for tracking important dates and tasks.

　　Performs annual operating expense reconciliations monitors audit windows and audit requirements contained in the lease documents.

　　Conduct financial analysis as needed including AR/AP rent rolls and budgets in accordance with required accounting principles such as ASC842 and GAAP.

　　Support tax team with parcel research and tax payment histories as needed.

　　Manage and research of vendor payments including the preparation of documentation to obtain purchase orders (PO) obtain approval of invoices and submit for payment tracks payments against POs when required.

　　Manage the Tenant Improvement Reimbursement process assuring all owed reimbursement from landlords are collected as required.

　　Correspondence with hospital administration and Foundation clients landlords brokers and associated real estate service providers regarding the provision of real estate facilities and services.

　　Preparation of FMV documentation preparing NPV worksheets submittal to legal for document preparation and legal approval

　　Manage the lease execution process including lease distribution to all related individuals; assure insurance requirements are met obtaining W9 information from landlords

　　Coordinate meetings and provide administrative support for Managers of Corporate Real Estate Services including assisting in preparation of Power Point presentations Webex telephone support and the submission of Lease Services Request to Legal

　　Analyze property financial statements rent rolls operation expenses and proposed proforma’s

　　Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.

　　Prepare adhoc reports from Common Spirit Lease Real Estate Database

　　Additional Scope of Support Accountabilities:

　　Independent collection of real estate transactional data in supporting RE managers with the lease joint ventures acquisitions/disposition transactions

　　Manage the acquisition of information from brokers appraisers title officers legal and associated tasks in preparation for real estate transactions

　　Assist in preparing analysis and reports for real estate transactions including but not limited to:

　　o Due diligence for new acquisitions and sales

　　o Joint ventures and mergers

　　o Request for Proposals (RFPs) for MOB developments and associated projects

　　o NPV analysis

　　o LOI preparation

　　o Common Spirit leases and real estate transaction processes

　　o Tenant signage

　　o Maintaining legal log

　　Assist in the preparation of RFP respondent comparison and analysis spreadsheets for developer selection process

　　Gather and evaluate economic demographic and other associated real estate market data

　　Prepare periodic power point presentations for hospital and corporate senior management projects

　　Experience

　　5 years working in the Real Estate Services field

　　Experience in Database Management

　　Experience in facilitating project related meetings presentations and updates

　　Experience with relational databases and other tools to compile and interprets quantitative data & MS office applications

　　Management reporting capabilities to meet organization goals and objectives

　　Experience with providing visible sponsorship and guidance of major change initiative

　　Experience in completing commercial real estate transactions

　　Experience in financial modeling and analysis

　　Qualifications

　　Minimum Requirements

　　5 years working in the Real Estate Services field

　　Experience in Database Management

　　Experience in facilitating project related meetings presentations and updates

　　Experience with relational databases and other tools to compile and interprets quantitative data & MS office applications

　　Management reporting capabilities to meet organization goals and objectives

　　Experience with providing visible sponsorship and guidance of major change initiative

　　Experience in completing commercial real estate transactions

　　Experience in financial modeling and analysis

　　Education

　　Bachelor’s degree in Real Estate Management Economics Business Administration and/or equivalent experience requiredSpecial Knowledge Skills Abilities

　　Demonstrated advanced working knowledge in MS Office applications with a concentration on Excel

　　Excellent writing and editing skills

　　Database management

　　Working knowledge of real estate terms & processes

　　Working knowledge of real estate software

　　Ability to multi-task & work in a team environment

　　Working knowledge of real estate transactions terms processes and financial analysis

　　Good problem-solver. Sorts through issues and conducts comparative analysis of multiple solutions

　　Understands key process issues and makes sure process improvements happen

　　Real estate financial & proforma analysis

　　Makes effective decisions with limited time and information

　　Real estate market evaluation knowledge

　　Vendor Coordination (PPN)

　　Project scheduling and management

　　Excellent people skills including and displays self-confidence

　　Travel

　　Some travel requiredPay Range

　　$32.17 - $46.65 /hour

　　We are an equal opportunity/affirmative action employer.