Financial Analyst II (Senior Financial Analyst - Asset Optimization & Development Strategy)

City of Vancouver

Financial Analyst II (Senior Financial Analyst - Asset Optimization & Development Strategy)

Requisition ID: 12175 

The City of Vancouver is striving to become the greenest city in the world, and a city powered entirely by renewable energy before 2050. We are proud to be one of BC's Top Employers, Canada's Best Diversity Employers, and one of Canada's Greenest Employers. With employees that have helped Vancouver consistently rank as one of the world's most livable cities, the City values a diverse workforce which represents the vibrant community we so proudly serve.
Consider joining our committed team of staff and being part of an innovative, inclusive and rewarding workplace.
Main Purpose & Function
The Senior Financial Analyst is an integral member to the Long-term Financial Strategy team and reports directly to the Senior Manager, Asset Optimization & Development Strategy.
The main functions of this role are:
  • Provide development analytics to optimize use of the City’s real estate assets to achieve corporate priorities in a sustainable way
  • Support development of a transformative business & financial strategy for the City’s real estate portfolio to ensure optimal outcomes, long-term sustainability and portfolio resilience
  • Support development of optimal business & operating models, strategic partnerships, business & financial strategies to implement the City’s Housing Vancouver Strategy and the Vancouver Affordable Housing Endowment Fund
  • Conduct complex business case analyses, valuation and cash modelling, formulate business and financial strategies, and influence high profile and high impact business decisions on priority Council initiatives
Specific Duties & Responsibilities
  • Perform quantitative & qualitative analyses on a variety of optimization initiatives and provide strategic insight as required
  • Extract insight from raw data to support strategic & portfolio accretive investment decisions
  • Interrogate all data & assumptions used in business cases, investment thesis & strategy formulation
  • Build, maintain, develop and project manage the implementation & deployment of portfolio models & integrated dashboards
  • Ensure all relevant KPI & benchmarking frameworks pertaining to the real estate portfolio are tactical & outcome focused
  • Communicate analytical insights & optimization opportunities effectively to senior management & peers
  • Collaborate with various City departments to ensure business model deployment for individual assets aligns with the asset optimization objectives & strategy frameworks
  • Other duties/responsibilities as assigned
Education and Experience:
  • A post-graduate degree in Finance or Economics, and/or a CA or CFA designation
  • Minimum 10 years’ progressive experience in real estate or asset management
  • Experience in deployment of SOTP, DCF & ABC methodologies; real estate acquisition & business case due diligence (pre-M&A) highly advantageous
Knowledge, Skills and Abilities:
  • Exceptional Excel skills (advanced aggregation modelling (SOTP, ABC), DATA Tables, Goal Seek, Pivot Tables, etc.)
  •  Superior analytical skills, a data driven mindset with excellent problem-solving skills
  • Advanced Dashboarding, Data Visualization & Data Extraction experience (SAP, VBA, Cliq Sense, Power BI, QlikView, Tableau etc.) highly advantageous
  • Impeccable track record of converting raw data into optimization strategies
  • Ability to identify issues, gather data and develop solutions
  • Ability to “connect the dots” and understand and apply broad corporate context in individual tasks
  • Critical thinking, ability to analyze complex situations and determine appropriate courses of action where there is little or no precedent
  • Strong sense of accountability, take considerable initiative in leading and completing assignments, and take ownership of challenges to the point of resolution
  • Ability to work independently with high degree of maturity, experience and sophistication
  • Embrace and encourage team work, collaboration and intellectual curiosity
  • Strong verbal and written communication skills, ability to effectively convey complicated analyses to senior management through reports and/or presentations

Business Unit/Department: Finance, Risk & Business Plan (1150) 
Affiliation: Exempt 
Employment Type: Regular Full Time 
Position Start Date: December 2018 
Application Close: November 29, 2018

We thank all applicants for their interest. However, only those selected for an interview will be contacted. Learn more about our commitment to diversity and inclusion

Apply here

Organization: City of Vancouver
Location: Vancouver, BC
Region: Lower Mainland
Professional Category(s): Financial Administration
Posted: November 9, 2018, 12:19 pm
Expires: November 29, 2018, 11:59 pm

Want new jobs like this sent to you?

Advanced Search

Show Advanced Search

Useful Links

Back to Top

About Us

We work tirelessly to promote local government career opportunities.

Tools & Resources

Canada's #1 Local Government job posting website.

Postings by Email

Receive email alerts, or sign up for our weekly e-bulletin.