Budget Analyst I

**Requisition ID**:42220

**Organization**

Located on the traditional, ancestral and unceded lands of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh) Peoples, Vancouver has a commitment to becoming a City of Reconciliation. Vancouver consistently ranks as one of the world’s most liveable and environmentally sustainable cities. Named among Canada's Top 100 Employers, BC's Top Employers, and Canada's Greenest Employers, the City of Vancouver seeks colleagues who can help shape and embody our core commitments to sustainability, reconciliation, equity and outstanding quality of life for all residents.

Consider joining our committed team of staff and being part of an innovative, inclusive and rewarding workplace.

**Main Purpose and Function**
The Lease Administration and Portfolio Analyst provides cross-organizational services to key Real Estate Services and Financial Services personnel by managing portfolio lease information, providing budget analysis for properties, and undertaking financial reconciliations of operating costs and property taxes for contracts to ensure optimal use of leased and owned assets. This role will undertake work of considerable complexity including interpretation of legal contract terms and obligations, the management of lease abstracts for all agreements and amendments, and ensuring contract details and critical dates are actively maintained within the department’s real estate database. This position will also prepare financial statements specific to operating cost reconciliations, building income/expense statements and forecasts, and related financial documents for properties including development and sale RFPs. This position contributes to the management, administration and analysis of a diverse and intricate portfolio of commercial, industrial and residential real estate assets.

**Specific Duties/Responsibilities**
- Interprets legal contract terms and obligations.
- Prepares lease abstracts for all agreements and amendments.
- Manages and maintains contract details and critical dates within City databases (SAP, VanDocs), including rental billing and physical file set-up.
- Acts as the point-person or “bridge” between Real Estate Services and Financial Services staff, responsible for ensuring all lease terms and obligations are verified for each department’s requirements.
- Performs audits of contract data to ensure integrity of database programs.
- Prepares land use documentation including leases, amendments and license agreements.
- Manages the department’s reconciliation process, preparing annual operating cost reconciliations for commercial tenants to improve cost recoveries at the building level, and to ensure accuracy and lease compliance
- Recommends, documents and implements operating budget procedures for properties to facilitate consistent and efficient cost collection, including development of analytical methods to review and ensure compliance.
- Prepares property operating budgets for City-owned assets including rent, cash flow and income/expense statements; analyzes past estimates to provide variance rationale and recommends corrective action.
- Analyzes and validates operating budgets and financial statements for additional rent associated with third-party leased space, and provides recommendations to management on payments and budgetary estimates.
- Prepares site specific operating cost forecasts; identifies and analyzes trends and patterns for follow up.
- Provides analytical support on moderate to complex property and portfolio-wide financial issues for Real Estate Services and Financial Services staff.
- Develops and prepares spreadsheets and PowerPoint presentations for Council Reports.
- Prepares, develops and creates marketing material for properties that will be leased or sold and post to various real estate platforms.
- Creates and updates lease plans for all properties in the portfolio.
- Reviews and follows up on rental arrears.
- Reviews existing procedures and makes recommendations for changes in documentation processes to increase efficiencies.
- Supports strategic projects as required.
- Perform other duties/responsibilities as assigned.

**Qualification Requirements**
Education and Experience:

- Diploma or Bachelors degree in related field such as Urban Land Economics or Accounting, or fours years training in a recognized accounting program. Considerable experience in real estate, legal or accounting, or an equivalent combination of training and experience.

Knowledge, Skills and Abilities:

- Considerable knowledge of the City’s policy and procedures regarding leases, dispositions and acquisitions.
- Considerable knowledge of the information required to prepare properties for lease and disposition.
- Considerable knowledge of financial statements and municipal accounting practices, functions and procedures as they relate to work performed.
- Strong technical and analytical skills i