People Reporting and Analytics Specialist

This position supports the design and production of People Analytics solutions for all areas of the People Cluster in strategic support of the business. Through collaboration with a variety of stakeholders to develop and maintain People cluster reports and dashboards in both Power BI and Oracle that provide insights into both program delivery and enterprise employee reporting, producing meaningful reports, charts, metrics, dashboards and presentations using data from various People systems to provide insights to, leadership and the clients we serve. In addition, this role provides oversight around the employee data structures, definitions, employee data stewardship and supports over employee data integrity**Major Responsibilities**:

- 1. Partner with Divisions within each functional area and representatives across boundary systems, as required, to conduct in-depth analysis of People cluster information needs, gathering requirements and designing recommend analytics, metrics, identifying relationships, trends and issues for management awareness, decision making or action.- Build queries to extract, compile and analyze data using PeopleSoft, Excel, Access, Oracle HCM, PowerBI and Fabric (including Python).
- Perform statistical analysis and/or develop “what if” scenarios to analyze data to identify trends, monitor program value, create predictive forecasts, and measure results
- Determine the most appropriate method for conveying information, for example, reports, dashboards, scorecards, presentations
- Design and develop reports using Data visualization and data management tools
- Develop costing models based on current data, identifying key variables and assumptions
- Reviews and converts critical existing manual reports into newer more streamlined formats using PowerBI, or data visualization reporting tools.
- Supports centralized employee data reporting for standard quarterly, annual or organizational and legislative reports as well as the creation of Dashboard and Analytics in alignment with leadership priorities
- Identify new sources of data and methods to improve data mining
- Works with consultants and contractors during projects on various data integrity or report specific deliverables
- 2. Deliver regular People Cluster organizational data analysis and reporting. Developing and maintain comprehensive reports and dashboards to support effective operations, create awareness and to inform strategic decision-making.- Prepare daily, weekly, bi-weekly, quarterly and annual reports according to the People cluster Reporting Schedule
- Assess ad hoc requests and consult with requestors to determine context, data requirements, work effort and time required to ensure quality reporting that addresses the requestor’s business need. Identify any potentially contentious issues and escalate as required.
- Present relevant trends, identify issues and implications to the business leader and provide consulting, guidance and advice on interpreting and acting on data
- Aggregates People related data to produce standard, value-added People cluster analytical solutions for use by various People cluster teams, line managers and executives
- Creates and maintains standard procedural documentation related to reporting solutions and reporting from People systems for reference, training and support purposes.
- Develop and maintains data mapping specification tables to show how shared data elements from source systems map to boundary systems, identifying primary keys that connect the various databases. Define mapping for historical data during migration of system enhancements
- Recommend relevant People cluster metrics based on best practices to enable external comparison and internal benchmarking over time
- 3. Conduct research and participate in benchmarks surveys and studies to provide identify external comparators and perspective- Co-ordinate, lead or participate in benchmark surveys from external parties such as Conference Board of Canada and Corporate Leadership Council identifying appropriate comparators to benchmark WSIB metrics from a variety of sources including other organizations
- Research specific People cluster topics of interest for the purposes of identifying best practices and workforce trends by gathering, analyzing, summarizing and communicating
- Investigate possible methods of improving and/or automating the reporting process through query scheduling, use of Access and other tools
- Provides recommendations and technical leadership in the design, creation and enhancement of reporting / analysis solutions in keeping with the demands of strategic business support.
- Stay updated on industry trends, best practices, and emerging technologies in people analytics.
- 4. Guide overall organizational employee data management and maintain data mapping tables to show how data elements from source systems are translated or map to different metrics & systems.- Establishes a governance framework for the definition of