Hr Systems & Reporting Analyst

Requisition ID: 40562

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 cities and is working towards being the greenest city in the world. 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, decolonization, 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 HR Systems and Reporting Analyst works as a member of the HR Systems and Analystics team. Interfacing with key business leaders from client departments, this role enables the City to leverage HR data and metrics supporting strategic and operational decisions. The HR Systems and Reporting Analyst also supports HR transformation by driving accountability, improving transparency and increasing efficiency.

This role partners closely with other Corporate Support teams to foster a culture of data driven decision making across the city by working with client departments to increase HR data literacy, enable data exploration, and disseminate business intelligence tools and processes amongst end users.

The HR Systems and Reporting Analyst provides key labour relations support by providing reporting related to the operational impacts of collective agreements as well as creating ad hoc reports and financial models for collective bargaining.

This role also provides HR systems support and system administration as required.

Specific Duties and Responsibilities

• Reporting and Analytics:
  • Responsible for creating, distributing, analyzing, optimizing and automating reports on a scheduled basis or Ad hoc as needed
  • Designs, develops and maintains dashboards with a variety of data visualization tools using interaction design best practices
  • Assists client departments in identifying opportunities for HR metrics for Workforce Planning, JEDI (justice, equity, decolonization and inclusion) and other key HR related processes and priorities.
  • Leads business analysis for department specific and city-wide data visualization using UX Design principles including creating and maintaining end user personas and prototyping
  • Supports the bargaining process and Labour Relations requests through reporting and data analysis including financial modelling
  • Proposes and validates high value datasets and governance guidelines for enablement through the City's Enterprise Data Enablement process, building and deploying automated dashboards and reporting processes using business intelligence tools while leading the associated projects.
  • Works with client departments to foster data literacy and user adoption of self-serve business intelligence tools and processes though co-ordinating testing and end user support and training.
  • Works with client departments to uncover and remediate data quality issues.
  • Performs Seniority calculations and other union related reporting
  • Creates and updates Privacy Impact Assessments related to new data initiatives
• Systems support and maintenance:
  • Reviews and responds to Help Calls related to HR systems, including in-house applications and SAP SuccessFactors.
  • Supports HR Systems Administration as required

Qualifications

Education and Experience:

• Bachelor's degree in Human Resources, Statistics, Business Analytics, Information Technology or a related discipline and 5 years of data analysis and visualization or an equivalent combination of education, training, and experience
• Experience supporting and administering HR Management Systems such as SAP SuccessFactors
• Experience supporting and facilitating multi-stakeholder initiatives and engagements at all levels
  

Knowledge, Skills and Abilities:

• Knowledge of SAP applications and their reporting capabilities including Payroll, CATS, HCM, SuccessFactors
• Knowledge of HR metrics and the ability to make strategic reporting recommendations to support data driven business decisions
• Knowledge of HR related business operations and processes
• Advanced MS Excel skills
• Knowledge of SAP Business Warehouse or Enterprise Data Warehousing solutions is an asset
• Ability to create dashboards by mastering Business Intelligence tools such as SAP Analysis for Excel, Power BI, Lumira Discovery or SAP Analytics Cloud
• Ability to extract and analyse large data sets
• Ability to perform complex financial modeling related to time entry and payroll
• Ability to establish and maintain effective working relationships with internal and external contacts at all levels
• Ability to quickly master and stay on top of new technologies
• Business analysis skills and experience including the ability to formulate, evaluate, assess, and as appropriate, document and implement system design requirements, standards, best practices and tools
• Proven project management and negotiation skills, capable of managing multiple tasks.
• Good problem solving and conflict resolution skills to resolve business issues from an analytical perspective
• Payroll or Accounting knowledge is an asset
• Demonstrated ability to work under pressure, manage multiple priorities and respond to requests in a timely manner.
• Ability to communicate effectively both orally and in writing and present complex concepts to both technical and non-technical audiences
• Enhanced Reliability Check required

Where operationally appropriate and subject to change, the City of Vancouver has a Flexible Work Program. This program allows staff to work remotely 1 - 4 days a 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: Human Resources (1020)

Affiliation: Exempt

Employment Type: Regular Full Time

Position Start Date: March 2024

Salary Information: Pay Grade RNG-070: $80,458 to $100,573 per annum

Application Close: February 28, 2024

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.

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.