HR Data Analyst - Ottawa, Canada - The Ottawa Hospital

The Ottawa Hospital

Verified Company

Ottawa, Canada

1 week ago

Posted by:

Sophia Lee

beBee Recruiter

Description

About The Ottawa Hospital:

Inspired by research and driven by compassionThe Ottawa Hospital (TOH) is one of Canada's largest learning and research multicampus 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 healthcare 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.
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 detailoriented 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.

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