Sql analyst Jobs in Richmond, BC

Requisition ID: 47428

Organization

Vancouver is consistently ranked as one of the world’s most liveable and environmentally sustainable cities. Recognized among BC’s Top Employers and Canada’s Greenest Employers, the City of Vancouver is seeking colleagues who can help advance our core commitments to exceptional public service, sustainability, equity, and an outstanding quality of life for all residents.

With a strong commitment to being a City of Reconciliation, we invite you to join our dedicated team and become part of an innovative, inclusive, and engaging workplace. A career with the City of Vancouver and within the broader public service, offers meaningful work where you play a key role in ensuring equitable access to services, upholding ethical governance, and supporting the needs of citizens with integrity and dedication.

Main Purpose and Function
The Financial Analyst II is an integral member of the Financial Planning & Analysis team and reports to the Associate Director FP&A – Parks & Recreation. The role supports financial planning, budgeting, forecasting, reporting, and strategic decision-making for Parks & Recreation and the Parks Board. Working closely with operational leaders and finance teams, the position provides financial analysis, business case development, performance measurement, and budget management support for annual operating and capital budgets. Through advanced analytics and actionable insights, the role identifies risks, opportunities, and efficiencies, evaluates funding strategies, and supports informed decision-making to help Parks & Recreation achieve its strategic objectives while maximizing service delivery and value for money.

Specific Duties / Responsibilities

Financial Planning and Analysis

• Supports development, implementation, and monitoring of annual operating and capital budgets and multi-year capital plans aligned with City priorities.

• Provides financial advice and analysis to leadership for decision-making and resource allocation.

• Prepares long-term financial forecasts, quarterly projections, and variance analyses, including market-driven revenues and expenditures.

• Assists in developing funding strategies and financial plans for capital projects, service delivery initiatives, and organizational priorities.

• Works with operational leaders to identify budget pressures, risks, and opportunities and recommends actions.

Modeling and Decision Support

• Develops financial models, business cases, cost-benefit analyses, and scenario forecasts to support strategic initiatives and capital investments.

• Evaluates financial implications of projects, contracts, Council/Board reports, policies, and major decisions.

• Analyzes financial and operational data to identify trends, risks, opportunities, and efficiencies and provides recommendations.

• Partners with business leaders to provide financial insight and decision-support analysis.

Performance Reporting and Business Partnership

• Monitors budget performance and ensures compliance with financial controls, policies, procedures, and reporting standards.

• Partners with Business Units, City Finance, and stakeholders to provide financial advice and support strategic initiatives.

• Identifies opportunities for efficiencies, cost savings, and process improvements to support long-term planning.

Minimum Position Requirements

Education and Experience

• Degree in Public Administration, Business Administration, Economics, or Finance plus a professional accounting designation.

• Commitment to ongoing professional development and skill maintenance.

• Extensive experience in budgeting, finance, and administration in a large multi-union organization, preferably public sector.

• Experience with ERP systems (e.g., SAP) and integrated financial software.

• Experience in cost accounting, cost distribution modeling, and business process analysis.

• Knowledge of PSAB and public sector accounting standards.

• Experience preparing financial statements, reports, statistics, and complex spreadsheets accurately.

• Experience developing operating and capital budgets and improving business processes.

• Experience writing reports for Council or Board-level audiences.

Knowledge, Skills and Abilities

• Strong understanding of municipal finance, budgeting, and accounting practices.

• Knowledge of public administration and business practices across government and private sector environments.

• Strong computer and enterprise systems knowledge, especially SAP.

• Advanced skills in Microsoft Office and data analysis tools.

• Excellent verbal, written, and presentation skills.

• Ability to work independently and within cross-functional teams in a matrix environment.

• Strong organizational skills with ability to manage competing priorities.

• Strong analytical, research, and problem-solving skills.

• Ability to provide objective, balanced, and sound business advice.

Business Unit/Department: Finance & Supply Chain Mgmt

Affiliation: Exempt

Employment Type: Regular Full Time

Salary Information: Pay Grade 91: $117,909 to $147,377 per annum

Application Close: October 12, 2026

At the City of Vancouver, we are committed to recruiting a diverse workforce that represents the community we so proudly serve. Indigenous peoples, people of colour, 2SLGBTQ+ persons including all genders and persons with disabilities are encouraged to apply. Accommodations will be provided upon request during the selection process. Learn more about our commitment to diversity and inclusion.

The City of Vancouver acknowledges that it is situated on the unceded traditional territories of the xʷməθkʷəy̓əm (Musqueam Indian Band), Sḵwx̱wú7mesh Úxwumixw (Squamish Nation), and səlilwətaɬ (Tsleil-Waututh Nation).More about unceded traditional territories

Before you click Apply now

Once you start your application you can save your work and leave the applications page, however please remember to submit your profile to the specific job requisition before the posting closing date.

In addition to uploading your cover letter and resume, part of the application process may include answering application questions related to the preferred requirements of the role which may take approx. 5-10 minutes. Cover letters should express interest and highlight additional information relevant to the position and resumes should include a summary of skills and experience related to the position.