HR Consultant Workforce Reporting

**Job ID**: 48653

**Job Category**:Human Resources

**Division & Section**:People & Equity, Business Services, Systems & Insight

**Work Location**:Metro Hall, 55 John Street, Toronto, ON, M5V 3C6

**Job Type & Duration**:Full-time, Temporary (12 month)

**Salary**:$86,716.00-$112,255.00,TM2093 and Wage Grade 6

**Shift Information**: Monday to Friday, 35 hours per week

**Affiliation**: Non-Union

**Number of Positions Open**: 1

**Posting Period**: 23-Sept-2024 to 7-Oct-2024

As a Human Resources Consultant, Workforce Reporting, reporting to the Manager Business Transformation & Change Management, you will be part of a team of highly skilled professionals who provide a variety of workforce data consulting, reporting, and analysis services to clients in the People & Equity Division and across the City.

In addition to preparing reports, dashboards and presentations, you will be engaging, advising and guiding clients to help them understand complex HR matters and tell their stories with data. The team’s work is critical in helping the City make data-driven decisions to implement effective workforce strategies. This means that you play a pivotal role in helping the organization to drive its strategic HR objectives.

**Major Responsibilities**:

- Consults with clients to understand their data, reporting and analytics needs and to determine the best way to address them using available data and tools
- Recommends data and metrics that help to enhance the client's story or call to action, and helps to identify meaningful insights through analysis
- Leads the response to assigned data and analysis requests, managing scope, and ensuring the end-product addresses the client's needs
- Develops, programs and maintains databases using tools such as MS Access and MS Excel, and maintains familiarity with workforce datasets
- Ensures data integrity and manages data sets by cleansing and mapping data. Performs data transformation on data from various sources for own use and to be used by the team; ensures data integrity and usability including through cleansing processes
- Ensures the timely delivery of assigned data, reports and analysis to clients
- Exercises sound judgement in the handling of sensitive and confidential requests, information and data
- Collaborates with team members on approaches to respond to requests, to assist with
- prototyping or testing, and to deliver analysis or assigned projects
- Demonstrates a client focus, helping clients to understand workforce data, how metrics are calculated, and how information can be appropriately used
- Conducts research, engages in continuous learning and keeps informed on workforce trends, benchmarks, etc.

**Key Qualifications**:

- Experience consulting with and preparing information for stakeholders at all levels to understand and best respond to their business needs
- Considerable experience programming, designing and developing reports using tools such as Microsoft Access, Microsoft Excel and Tableau
- Considerable experience developing reporting tools and appropriate methodologies, that assist with analyzing and interpreting workforce data and providing meaningful insights
- Experience working in the HR domain or with HR Information Systems reporting, specifically with SAP or SAP SuccessFactors is an asset
- Excellent problem-solving skills to manage complex requests and provide alternate, innovative strategies in response to client workforce data needs.
- Strong oral and written communications skills.
- Ability to successfully plan, organize and manage work both in a team environment and independently, as required.
- Sound judgement and ability to handle matters of a confidential/sensitive nature; knowledge of and experience with the Municipal Freedom of Information and Protection of Privacy Act a strong asset
- Knowledge of accounting and/or costing methodology related to payroll, salary and benefits is an asset.

**Note To Current City of Toronto Employees**

**Equity, Diversity and Inclusion**

The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity.

**Accommodation