HR Reporting

1. 3-5 years HR, reporting and analytics, payroll, and HRIS experience.

2. 3-5 years experience in HR Oracle Systems preferably the reporting modules of PeopleSoft, Cloud and Taleo. SQL experience is preferred.

3. 3-5 years Reporting experience in a complex union and non-union environment. Experience in HR operations (compensation, recruitment, pension, benefits, etc.).

4. Undergraduate Degree (Business, Accounting, Human Resources, Computer Science, Statistics, or other relevant).

5. Requires scope and depth of knowledge and experience in all aspects of Human Resources.

6. Broad understanding of HR business fundamentals\: employment legislations, recruitment, compensation, labour relations, payroll, pension and benefits.

7. Advanced capabilities in human resource and reporting related software such as PeopleSoft and/or Oracle Cloud. 8. Advanced capabilities creating, managing, and delivering reporting solutions (OBI, BI Publisher, etc.).

9. Experience creating queries from Oracle Business Intelligence and PeopleSoft Query Manager.

10. Experience with using Crystal Reports and a strong understanding of reading/writing SQL.

11. Advanced capabilities in Excel such as Formulas, Pivot and Power Pivot Tables and other MS office applications.

12. Strong technical and analytic skills to develop data extraction queries, report preparation and data investigation.

13. Ability to interpret information needs to support organizational needs.

14. Strong understanding of HR Systems & Processes in large, complex organizations.

15. Experience with variety of HR systems including applicant tracking, payroll/timekeeping, security and business intelligence tools.

16. Strong research and analytical skills.

17. Exceptional customer service skills.

18. Excellent organizational, time management and prioritization skills.

19. Strong interpersonal skills, with the ability to work collaboratively in a high performance environment.

Monday- Friday with flexibility to support operational requirements.

This position is eligible for hybrid remote work. This position is temporary until September 2027. 

Hamilton Health Sciences fosters a culture of patient and staff safety, whereby all employees are guided by our Mission, Vision, Values, and Values Based Code of Conduct. Hamilton Health Sciences is a teaching hospital and all staff and physicians are expected to support students and other learners.

To be considered for this opportunity applicants must apply during the posting period. All internal and external applicants may ONLY apply via the Careers website.

Hamilton Health Sciences is an equal opportunity employer and we will accommodate any needs under the Canadian Charter of Rights and Freedom, Accessibility for Ontarians with Disabilities Act and the Ontario Human Rights Code. Hiring processes will be modified to remove barriers to accommodate those with disabilities, if requested. Should any applicant require accommodation through the application processes, please contact HR Operations at , Ext for assistance. If the applicant requires a specific accommodation because of a disability during an interview, the applicant will need to advise the hiring manager when scheduling the interview and the appropriate accommodations can be made.

This competition is open to all qualified applicants, however, qualified internal applicants will be considered first. Past performance will be considered as part of the selection process. If you are a previous employee of Hamilton Health Sciences, please note\: the circumstances around an employee's exit will be considered prior to an offer of employment. Proficiency in both Official Languages, French and English, is considered an asset.

If this position is temporary, selection for this position will be as per the outlined Collective Agreements:

Article 30 (k), CUPE Collective Agreement

Article 10.7 (d), ONA Collective Agreement

Article b) (ii), OPSEU 273 Collective Agreement

Article 14.04, OPSEU 209 Collective Agreement

Article 2.07 and Article 13, PIPSC RT Collective Agreement

The Human Resources Analyst – Reporting, works with clients and partners on various key initiatives such as completing human resources surveys, reporting on various HR metrics, completing analysis on employee data and preparing costing in support of bargaining with unions. The Human Resources Analyst - Reporting will also provide support for the HR/Payroll systems by performing employee data audits, identifying & resolving data issues, building reports, and participating in analysis, system testing, and validation. The HR Reporting team supports the bi - weekly payroll process, including audits, reporting, and data integrity. The majority of reporting will be out of the following HR data sources\: HCM Cloud Oracle Business Intelligence, Taleo Oracle Business Intelligence and PeopleSoft Query Manager.

• Supports key stakeholders in generating reports, completing surveys, and preparing analysis on employee data across the organization.

• Designs and/or customizes reports to support reporting requirements and decision-making tools for various stakeholders as requested.

• Performs data manipulation and aggregation of data from multiple HR data sources (PeopleSoft, Oracle HCM Cloud, Taleo) to provide a holistic view.

• Facilitates end-user understanding of system reporting capabilities, available data, and any report/analysis produced.

• Provides costing and analysis support during preparation for and execution of collective bargaining on approximately five separate collective agreements.

• Utilizes dashboards as appropriate to answer relevant business questions and communicates reporting data in a concise and user friendly format.

• Performs audits on data pulled out of various HR systems (PeopleSoft, Oracle HCM Cloud, Taleo) to ensure quality data and information is used for reporting.

• Leverage system and process expertise in analyzing and troubleshooting issues in order to find a resolution and determine root cause.

• Participates in the analysis, testing, validation and implementation of new software installations and upgrades.

• Supports the Compensation and Benefits team with implementing annual rate increases and retroactive payment validation

• Assists in the annual member data collection process for the Healthcare of Ontario Pension Plan

Hamilton Health Sciences (HHS) is an academic health sciences centre, a family of seven hospitals, a cancer centre and an urgent care centre, serving more than 2.3 million residents of Hamilton and south central Ontario. Advancing healthcare through academics and research is enabled through HHS' affiliations with McMaster University and Mohawk College. What makes HHS exceptional is the remarkable people who work at our hospitals and commit themselves to providing the best care for all. HHS employs approximately 13,000 people who share our values of respect, caring, innovation and accountability. HHS staff, physicians and volunteers are proud to work at HHS and of their contribution to the excellent care received by patients and families in one of Ontario's largest and most complex health systems. Human Resources (HR) Support Services is made up of a team of HR professionals and innovators who contribute to the achievement of Hamilton Health Sciences' (HHS) operational and strategic priorities. HR Support Services is organized by streams (HR Payroll, HR Reporting, Compensation & Benefits, and HR & Payroll Solutions) to provide a wide range of HR services and programs for the HHS community. The HR Support Services model and overall vision emphasizes a client focus, collaboration, integrity, and continuous improvement.