LEASE ANALYST

---

Job description

OverviewCommonSpirit 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.ResponsibilitiesJob Summary: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. Mission:Duty to Support the Mission, Philosophy, and ValuesThe 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 3rd 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 approvalManage the lease execution process, including lease distribution to all related individuals; assure insurance requirements are met, obtaining W9 information from landlordsCoordinate 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 LegalAnalyze property financial statements, rent rolls, operation expenses and proposed proforma'sMaintains 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 transactionsManage the acquisition of information from brokers, appraisers, title officers, legal and associated tasks in preparation for real estate transactionsAssist in preparing analysis and reports for real estate transactions including, but not limited to:o Due diligence for new acquisitions and saleso Joint ventures and mergerso Request for Proposals (RFPs) for MOB developments and associated projectso NPV analysiso LOI preparationo Common Spirit leases and real estate transaction processeso Tenant signageo Maintaining legal logAssist in the preparation of RFP respondent comparison and analysis spreadsheets for developer selection processGather and evaluate economic, demographic and other associated real estate market dataPrepare periodic power point presentations for hospital and corporate senior management projectsExperience 5 years working in the Real Estate Services fieldExperience in Database ManagementExperience in facilitating project related meetings, presentations and updatesExperience with relational databases and other tools to compile and interprets quantitative data & MS office applications Management reporting capabilities to meet organization goals and objectivesExperience with providing visible sponsorship and guidance of major change initiativeExperience in completing commercial real estate transactionsExperience in financial modeling and analysisBenefits Include: Benefits include Medical, Dental, Vision, Paid Time Off, Holidays, Retirement Program, Disability Plans, Tuition Reimbursement, Adoption Assistance, Employee Assistance Program (EAP), Discount Programs, Life Insurance Plans, Worker Compensation, Voluntary Benefits. Compensation Range: $25.25 to $32.82 hourly rates, annualized. Position is eligible for incentive pay based on company performance. Remote work allowedQualificationsMinimum Requirements5 years working in the Real Estate Services fieldExperience in Database ManagementExperience in facilitating project related meetings, presentations and updatesExperience with relational databases and other tools to compile and interprets quantitative data & MS office applications Management reporting capabilities to meet organization goals and objectivesExperience with providing visible sponsorship and guidance of major change initiativeExperience in completing commercial real estate transactionsExperience in financial modeling and analysis EducationBachelor's degree in Real Estate Management, Economics, Business Administration and/or equivalent experience requiredSpecial Knowledge, Skills, AbilitiesDemonstrated 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 informationReal estate market evaluation knowledge Vendor Coordination (PPN) Project scheduling and management Excellent people skills including and displays self-confidence TravelSome travel required