Sap-payroll/hcm Systems Analyst

Job Req ID :1183 Department :Human Resources and Citizen Service SystemsSAP-Payroll/HCM Systems Analyst

Job Number :1183 Job Type : Temporary Full-Time

• Temp Contract Length : 15 months

• Location : 150 Frederick St - Regional Admin Headquarters

• Job Category : Human Resources

• Number of Positions :1

• Department : Human Resources and Citizen Service Systems

• Division : Human Resources and Citizen Service

• Hours of Work : 35

• Union : Management/Management Support

• Grade : Management/Management Support Grade 06

• Salary Range : $48.05 - $60.06 per hour Our Story :

• Committed to fostering opportunities for current and future generations, the Region of Waterloo is an inclusive, thriving and sustainable region of connected rural and urban communities with global reach. Our mission is to serve, engage and inspire, by delivering quality services to a diverse population of 630,000+, while creating a healthy, collaborative environment of learning, respect and innovation.- This is a place where employees are valued and recognized for their talents and contributions to our success. Our employees take pride in making a difference in people's lives through the work that we do. We are looking for people like you to help make it happen.The Role Duties/Responsibilities

• Develops technical and implementation concepts for the implementation of in-house developments in SAP Payroll based on ABAP HR.

• Designs and implements SAP Payroll/HCM regular upgrades and optimization projects. Establishes testing strategy, work plan, test templates, and test scripts.

• Works on loading, extracting, developing, and creating reports, enhancements, and interfaces using ABAP HR and related technologies.

• Loads current/historical data for employee master data, time data, benefits data, dependent data, payroll data, and tax data infotypes from legacy systems (Oracle-based).

• Works extensively on extracting payroll data from clusters/infotypes.

• Administers and supports all versions and instances of SAP Payroll/HCM.

• Maintains communications with SAP to stay current on the latest upgrades and changes.

• Supports large-scale projects from a data requirements perspective.

• Creates and implements processes the business can use for mass data updates.

• Gathers business requirements when new master payroll cluster data fields are required and communicates requirements with ITS and other business stakeholders.

• Implements service requests in compliance with change management processes.

• Works extensively on extracting payroll data from clusters.

• Develops, maintains, and supports data conversions / mappings / developments of HCM objects using ABAP HR for data migration and integration tasks.

• Ensures the security of HR data.

• Plans, develops, and implements project communication plans to support initiatives. Analyzes resource requirements (e.g., software tools, programming, outsourcing, IT physical/ financial resources), and consults with Manager as needed.

• Designs, develops and deploys business analytics HR dashboards using business intelligence interactive data visualization software. Creates roles, provides access to the dashboard, and reports to the senior leadership team to assist with strategic business decisions. Connects different data sources, including importing data and transforming data for business intelligence. Completes complex data analysis and delivers presentations to the corporate leadership team and senior leadership team.

• Develops complex database queries, views, procedures, and functions for robust, customized, standard, and ad-hoc reports to support problems and situations. Enhances and edits standard reports. Maintains and validates database views and objects to increase the performance of reports and queries. Develops and maintains strategy for creating reporting standards and templates and organizing reports to avoid duplication and ensure data consistency. Maintains security and access settings for enterprise-level reporting.

• Designs quality assurance reports and performs analysis to collaborate on developing quality data standards. Assists in developing solutions to automate processes. Plans and organizes activities and tasks of project teams. Acts as systems contact with ITS and Finance on related matters. Conducts and participates in HR/ITS projects as required.

• Additional Duties/Responsibilities

• Assists in administering the time and attendance management systems (WFC-UKG / WFS), including configuring access profiles. Develops customized reports. Assists in supporting and troubleshooting the interface between SAP-HCM/Payroll and WFC-UKG / WFS.

• Designs, plans, and develops procedures and processes to identify and collect key departmental data, create benchmarking reports, and graphs. Consults HR management to review and discuss reports, and designs, prepares, and provides benchmarking information to external organizations (e.g., Municipal Benchmar