About The Ottawa Hospital

Inspired by research and driven by compassion!

The Ottawa Hospital (TOH) is one of Canada’s largest learning and research multi-campus hospitals. With more than 1,100 beds and approximately 12,000 staff members, we deliver specialized care to the Eastern Ontario region.

From the compassion of our people to the relentless pursuit of new discoveries, The Ottawa Hospital never stops seeking solutions to the most complex health-care challenges while continually engaging with the community to support our vision for better patient care.

Working together with its research institute, the University of Ottawa, and other partners, the hospital is continually gaining national and international recognition for high-quality patient care, teaching and research, while striving to meet the needs of the culturally diverse community we serve.

Position Information

The Ottawa Hospital’s Human Resources team has an exciting opportunity for an experienced HR Data Analyst with strong analytical skills and experience in developing reports and queries within Human Capital Management systems. The primary responsibilities for the role will include the following:

Write and develop reports in response to various ad hoc and legislated reporting requests, providing information that is accurate and presented in a format that is suitable for the respective audience.
Support Human Resources as the technical liaison and internal subject matter expert on HR data/information as well as the various HR systems that house HR information (HRIS, Excel, MS Access Databases, etc.). Where applicable, provide support with interpretation of data.
Develop and maintain complex MS Excel tools to support HR business requirements for calculations/conversions/etc.
Using strong analytical and communication skills, work with our clients in HR to ensure that any request for data meets the functional business requirements of the business.
Work with our technology team to troubleshoot system issues and test any subsequent solutions.
Ensure data integrity and reliability of our HR systems by developing, maintaining and monitoring audit reports.

Basic Requirements

Community college diploma or university degree in Business Administration, Human Resources, Accounting, Computer/Data Science or equivalent work experience with reporting and analysis;
Three (3) or more years of relevant experience working with data, developing reports, and querying databases using SQL based tools;
Demonstrated ability to present complex ideas in simple terms;
Adept at interpreting requirements, developing reports and presenting findings;
Experience with SQL and relational databases;
Hands on experience with MS Teams, SharePoint and Power BI;
Knowledge and experience using advanced MS Excel tools and techniques such as advanced formulas, Vlookups, Pivot Tables, etc.;
Able to perform effectively in a detail-oriented environment, requiring a high degree of personal organization;
The ability to work independently with minimum supervision.

Preferred Qualifications

Experience working in an HR/Payroll operational role;
Experience with PeopleSoft HCM;
Experience with MS Power Apps and MS Flow.

What you can expect from us

The Ottawa Hospital is committed to providing a healthy, safe, and inclusive work environment for everyone. We are driven by our purpose to provide each patient with the world-class care, exceptional service and compassion we would want for our loved ones.

We offer an attractive and equitable compensation package including a comprehensive benefits package, a Defined Benefit Pension (DBP) plan, and insurance protection. We also offer discounts from choice providers on a variety of products and services.

The Ottawa Hospital provides various Health and Wellness resources as well as opportunities for personal and professional development opportunities from our in-house Learning and Leadership Development team to help align your goals with your career objectives.

Interested? Apply today!

If you are passionate about what you do, motivated by improving the health of the community, excited by leading-edge medical technology, and as committed to excellence, quality and patient safety as we are, we would like to hear from you. Please submit an on-line application for the position you are interested in. We thank all those who apply but only those selected for further consideration will be contacted.

The Ottawa Hospital is an equal opportunity employer. Upon request, accommodations due to a disability are available throughout the recruitment process.