Skip to the content of the web site.

HR Reporting Analyst

Date: March 15, 2016
Reports to (Job Title): Assistant HR Director, Operations
Jobs Reporting (Job Titles): None
Department: Human Resources


Main Campus


35 hr/wk

Primary Purpose


The HR Reporting Analyst, is responsible for the preparation of timely and accurate reports to meet the needs of the HR department, broader campus community and external agencies as needed with respect to HR data.  In addition, the incumbent is accountable for producing and supporting the audit and compliance function to ensure data integrity and quality within HR systems.

Key Accountabilities:


Design and execute reporting requirements

  • Develop report specifications and design standard reports, including related documentation to support HR initiatives and day to day needs;
  • Consult with stakeholders to ensure reports meet or exceed requirements and are aligned with standard reporting practices with a focus on simplification;
  • Analyze existing data sources and develop optimal reporting methods for streamlined reporting;
  • Identify and develop new reporting methods and tools that will lead to improvement in efficiency and effectiveness;
  • Ensures reports and analyses are validated with the highest level of accuracy;
  • Perform complex data manipulation and aggregation of data from multiple HR data sources;
  • Provide key data and reports to external governing bodies including Statistics Canada and other Government agencies and partners as required;
  • Support HR’s relationship with Institutional Analysis and Planning (IAP department) and continue to assess ways to streamline and consolidate employee information;
  • Design complex queries and tools to support forecasting and situational analyses for enhanced decision making for the HR leadership team;
  • Act as the subject matter expert on all key HR reporting systems.


Assist with developing and maintaining HR data and reporting standards;

  • Ensure compliance with HR Data Privacy and Protection Guidelines;
  • Automate and streamline reports where possible, for distribution on an ongoing basis;
  • Maintain appropriate report documentation and a library of accessible reports for easy reference;
  • Promote consistent use of HR and employee data.


Support HR technology projects and HRMS implementations/updates

  • Provide data expertise and support with system implementations, interface design and table set-up;
  • Acting as a subject matter expert, lead the creation and execution of data and reporting requirements for technology projects;
  • Manage ad hoc report requests related to projects and project related data.


Manage data integrity and quality initiatives

  • Identifies opportunities to reduce duplication and errors and to ensure consistency in data across all data entry points within HR;
  • Audit and assess employee and payroll information on a regular basis to ensure integrity and accuracy of information;
  • Identify and ensure the resolution of data quality issues, such as uniqueness, integrity, accuracy, consistency, and completeness in a cost-effective and timely fashion;
  • Develop data quality assessment and cleansing specifications;
  • Assist in defining and producing data quality dashboards;
  • Devise, coordinate, and conduct data-cleansing initiatives for the purpose of purging and eliminating corrupt or redundant information from HR systems and tools;
  • Identifies causes of poor data quality, implements solutions and communicates findings to HR leadership and stakeholders.

Position Requirements


Undergraduate degree or equivalent experience required with additional training or professional development in research/data methodology (quantitative and qualitative) and data analysis/reporting techniques.


A minimum of 3-5 years’ progressive experience in data management and reporting related to human resources, data quality, and auditing preferably in an academic environment and/or HR environment. Core competences will include strong consultative skills with a customer mindset, advanced analytical, problem solving and organizational skills, excellent verbal and written communication skills, advanced reporting and problem solving skills.

This role requires the ability to work with a variety of systems and software tools to extract data and format the data into management reports.  A strong knowledge of reporting software and tools is required along with the ability to translate data requirements into usable reports.  The ability to interpret, analyze, and summarize data into meaningful insight is required.


A continuous improvement mindset and an exceptional customer service focus are critical for success along with exceptionally strong detail and problem solving skills.


MS Word Excel PowerPoint Other
Proficient (track changes, compare and merge files, table management, footnotes, technical documentation) Advanced (macros, pivot tables, v/h look-ups, scenarios, if and sum if statements) Proficient (creation of multi-level lists, charts, images, creation of master slides and dynamic presentations) HRMS Systems – relational databases preferably PeopleSoft >3 years. Reporting writing – tools such as Cognos/Impromptu, crystal reports, SQL, access >5 years

Nature and Scope

Interpersonal Skills:

Internally: Communicates and consults with employees in all groups and at all levels to support all data cleansing, reporting and auditing needs.  Strong interpersonal, consulting and data gathering skills are required.

Level of Responsibility:

This position is responsible for all data cleansing, HR transactional reporting and auditing under the direction of the Assistant HR Director, Operations.

Decision-Making Authority:

Independently sources and analyzes HR internal and external data sets and defines and creates reports within a defined framework under the direction of the Assistant HR Director, Operations based on the needs of HR and the campus community as a whole. 

Physical and Sensory Demands:

Regular periods of prolonged concentration involved in data organization, review, verification and analysis, typically involving large data sets. 

Working Environment:

Minimal exposure to disagreeable conditions, typical of a position exposed to deadline pressures and accountability.