SAP Business Analyst

Requisition ID: 46265

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 primary purpose of this position is to collaborate with business stakeholders to define, design, implement, and support enterprise planning, budgeting, forecasting, and financial performance management solutions using SAP Analytics Cloud (SAC) Planning. This position serves as the functional lead for planning transformation initiatives, ensuring business requirements are translated into scalable and sustainable planning solutions that improve decision-making, forecasting accuracy, and operational efficiency.

The SAP SAC Planning Business Analyst leads planning and performance management projects through all phases of the solution lifecycle, including business process analysis, requirements gathering, solution design, model development, testing, deployment, training, and ongoing support. The role acts as a key liaison between Financial Planning and SAP teams to ensure planning solutions align with organizational objectives and industry best practices.

This position provides ongoing support for financial planning, operational planning, capital planning, workforce planning, and management reporting processes. The incumbent has access to highly confidential financial and operational information and provides recommendations that may impact budgeting decisions, resource allocation, workforce planning, operational performance, and strategic initiatives.

Specific Duties and Responsibilities

• Partner with Finance and Planning team stakeholders to understand planning and forecasting requirements.
  
• Analyze existing budgeting, forecasting, and planning processes and recommend process improvements and automation opportunities.
  
• Lead the design, configuration, and support of SAP Analytics Cloud Planning models, versions, dimensions, hierarchies, measures, and business rules.
  
• Design and implement driver-based planning, rolling forecasts, scenario planning, long-range planning, and what-if analysis solutions.
  
• Develop and maintain planning workflows, calendar processes, data actions, allocations, advanced formulas, and business process controls within SAC.
  
• Configure and support budgeting, forecasting, workforce planning, project planning, capital investment planning, and operational planning processes.
  
• Collaborate with business users to define planning assumptions, key drivers, allocation methodologies, and performance metrics.
  
• Support financial consolidation, planning, and reporting requirements through integration with SAP S/4HANA, SAP BW/4HANA, SAP Datasphere, and other enterprise systems.
  
• Design and maintain planning input forms, planning stories, dashboards, and management reporting solutions.
  
• Develop functional specifications and work with technical teams on data integration, security, and system enhancements.
  
• Facilitate planning workshops, requirements sessions, design reviews, testing activities, and user acceptance testing.
  
• Coordinate annual budget cycles, quarterly forecasts, and monthly planning activities from a systems perspective.
  
• Monitor planning model performance, data quality, and system integrity and implement continuous improvements.
  
• Provide production support, troubleshoot planning issues, and coordinate resolution with technical teams and vendors.
  
• Develop and maintain planning process documentation, configuration documentation, user guides, training materials, and governance standards.
  
• Deliver end-user training and provide ongoing coaching to planning stakeholders.
  
• Evaluate new SAC Planning functionality and recommend adoption of new capabilities where beneficial.
  
• Support organizational planning maturity initiatives and promote best practices in integrated business planning.

Qualifications

Education and Experience:

• Bachelor's degree in Business Administration, Accounting, Finance, Information Systems, Computer Science, or a related discipline.
• Minimum 5 years of experience implementing and supporting SAP Analytics Cloud Planning solutions.
• SAP Analytics Cloud Planning certification preferred.
  
• CPA, CMA, CFA, FP&A certification, or equivalent financial planning credentials are considered an asset.

Knowledge, Skills and Abilities:

• Experience in SAP (SAC) to support finance team with enterprise budgeting, forecasting, financial planning, and performance management initiatives.
  
• Strong experience designing and configuring SAC Planning models, versions, dimensions, hierarchies, and planning structures.
  
• Hands-on experience with:
  
  • Data Actions
    
  • Multi Actions
    
  • Advanced Formulas
    
  • Allocations
    
  • Business Calendars
    
  • Data Locking
    
  • Value Driver Trees
    
  • Currency Translation
    
  • Version Management
    
  • Predictive Forecasting
    
• Experience supporting annual budget, forecast, and strategic planning cycles.
  
• Experience implementing workforce planning, capital planning, project planning, or operational planning solutions.
  
• Experience integrating SAC Planning with SAP S/4HANA, SAP BW/4HANA, SAP Datasphere, SAP BPC, or SAP ECC.
  
• Strong understanding of financial planning processes including:
  
  • Operating Expense (OPEX) Planning
    
  • Capital Expense (CAPEX) Planning
    
  • Revenue Planning
    
  • Cost Center Planning
    
  • Project Forecasting
    
  • Workforce Planning

Technical Knowledge

• Advanced knowledge of SAP Analytics Cloud Planning architecture and best practices.
  
• Experience with SAC Data Actions, Advanced Formula scripting, Multi Actions, and Planning Process Design.
  
• Knowledge of SAP S/4HANA Finance, SAP Controlling (CO), Project Systems (PS), Investment Management (IM), and Profitability Analysis (CO-PA).
  
• Understanding of planning data models, dimensional modeling, master data management, and security design.
  
• Experience with SAP Datasphere, BW/4HANA, Embedded Analytics, and planning integrations.
  
• Knowledge of SAP Business Technology Platform (BTP) and planning-related innovations is desirable.

Where operationally appropriate and subject to change, the City of Vancouver has a Flexible Work Program. This program allows staff to work a hybrid work week from locations that are a daily commutable distance from their work at a City worksite. At this time this position is eligible to be part of the Flexible Work Program.

Business Unit/Department: IT, Digital Strategy & 311

Affiliation: Exempt

Employment Type: Regular Full Time

Position Start Date: August, 2026

Salary Information: Pay Grade RNG-080: $102,960 to $128,691 per annum

Application Close: July 1, 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.