Financial Analyst I (Capital Budget Services)

Requisition ID: 20074 


Company

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 
Reporting to the Manager of Capital Budgets, the Financial Analyst 1 plays a leadership role in the delivery of Corporate Financial Planning & Analysis (FP&A) functions within Capital processes.

 

More specifically, this role is responsible for a variety of duties including, but not limited to, coordinating, analyzing and monitoring the City’s annual Capital budget, developing and refining budget policies and strategies, making recommendations to improve processes and systems related to capital budgeting, working with large amounts of data and using logic to produce our various monthly and quarterly reporting packages, analyzing quarterly and monthly reporting results from departments and providing feedback and recommendations, monitoring and analyzing departmental expenditures, implementing approved budgetary changes and analyzing complex budgetary information, and provision of project management or assistance with FP&A initiatives. This position also involves assisting departments in resolving financial issues and providing consultation on corporate initiatives with budgetary impacts.

 

Specific Duties & Responsibilities

Budgeting, Reporting and Forecasting:

  • Play a leadership role in budget processes and timelines
  • Develop and maintain all necessary financial models
  • Consolidate departmental submissions, review and make recommendations as well as report results
  • Work with departmental FP&A and operational staff to conduct comprehensive reviews of budgets and forecasts to identify funding needs and opportunities for budgeting improvement
  • Preparation of Council reports and presentations to Senior Managers, City Manager, City Leadership Team, and Council
  • Conduct financial, cash flow and economic impact studies of expenditure programs, and report on findings
  • Analyze budgets, performance indicators, business plans and on-going financial results
  • Manage relationships with departments and external organizations if applicable
  • Make recommendations to prioritize capital projects and manage overall capital spend
  • Make capital funding recommendations

 

Concurrences e.g., Council Reports and Shopping Carts/Procurement:

  • Validate standing authority and policies as they relate to the Council report and Shopping Carts
  • Review Council reports for operational and strategic alignment with City objectives
  • Validate financial implications and funding sources
  • Provide concurrence on report and recommendation for approval of shopping cart

 

Process improvement Projects:

  • Identify existing areas in the budgeting, forecasting, reporting and Council report concurrences that will benefit from process and/or policy improvements within FP&A, the Financial Services Group, and the City as a whole
  • Identify new areas where strategic or transformational processes can be implemented
  • Lead project implementation, managing direct and indirect project team members
  • Work with external parties, where required
  • Provide supporting role in projects, where applicable
  • Develop new tools, processes and deliverables as required or recommend improvements to existing tools, processes and deliverables
  • Track and report on project progress to senior management
  • Develop end-user documentation and training material, where required
  • Post implementation review and follow-up
  • Ad-hoc support on departmental deliverables, where required
  • Other duties/responsibilities as assigned

 

Qualifications

Education and Experience:

  • An undergraduate degree and a professional accounting designation or MBA
  • Minimum 4-5 years with extensive experience in budgeting, forecasting, reporting, and accounting preferably within a large organization
  • Advanced financial systems experience, preferably with SAP (PS, IM, CO modules) as well as Business Intelligence (BI) reporting environments
  • Good working knowledge of generally accepted accounting principles as they relate to local government including PSAB
  • Extensive experience delivering strategic, transformational and general process improvements, including all aspects of project delivery, from identification to implementation and hand-off
  • Project management experience
  • Experience with presentations to senior management
  • Formal report writing experience

 

 Knowledge, Skills and Abilities:

  • Superior and Advanced level Excel skills (e.g. ability to work with large amounts of data/create pivot tables, ad hoc reports, etc. in a timely manner)
  • Strong systems experience (ability to work with large financial systems, generate reports, analyze data, etc.)
  • Experience with financial modules of SAP including Project Systems and Investment Management (PS, IM) preferred
  • Superior verbal communication, written communication, and business analysis skills
  • Excellent interpersonal skills, and ability to work with minimal supervision; a self-starter
  • Demonstrated ability to work independently and as a member of a team
  • Excellent analytical and technical skills, as well as robust knowledge of budgeting concepts and principles
  • Strong business acumen and capability to link finance to business operations
  • Extensive knowledge of computer and enterprise systems and solutions
  • Ability to represent and serve the City at all levels, as well as interact with customers and clients outside the organization
  • Excellent organizational and project management skills, with ability to play a leadership role in multiple tasks with competing priorities
  • Problem-solving and issue resolution skills in a complex business environment
  • Ability to maintain professionalism, objectivity, confidentiality, tact and diplomacy

 

Business Unit/Department: Finance, Risk & Business Plan (1150) 

Affiliation: Exempt 

Employment Type: Regular Full Time 

Position Start Date: September, 2020 

 

Application Close: August 9, 2020

At the City of Vancouver, we are committed to recruiting a diverse workforce that represents the community we so proudly serve. We encourage applicants from diverse backgrounds, including Indigenous applicants, all genders, nationalities and persons with disabilities. 

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.