HR Systems & Reporting Analyst Full-time Job

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.

Vancouver, a bustling west coast seaport in British Columbia, is among Canadas densest, most ethnically diverse cities. A popular filming location, its surrounded by mountains, and also has thriving art, theatre and music scenes. Vancouver Art Gallery is known for its works by regional artists, while the Museum of Anthropology houses preeminent First Nations collections.