-
With direction from the manager of People Analytics, work with clients to identify reporting needs and provide needed analysis and reporting on an ongoing and ad hoc basis
-
Use Microsoft Power BI to connect to our data warehouse and prepare reports and dashboards to answer client's business questions
-
Use PeopleSoft Query to download required data sets and prepare reports using Power BI and/or Excel
-
Partner with our information technology team to ensure new datasets are brought into the cloud data warehouse and new views and tables are built to enable effective and accurate analysis
-
Maintain security access roles and technical documentation for all Power BI reports
-
As our analytics practice matures in the future, collaborate with the advisory team in the development of predictive analytics and statistical models
-
As required, this position will also take on advisory duties, which includes, but is not limited to:
-
Identifying, developing, defining, and managing distribution of metrics, measures, and KPIs via annual and quarterly reports for all areas of People \& Culture
-
Providing insights and analyses for business client questions, in a way that visually communicates the story of what is happening
-
Work collaboratively with groups and other departments
-
Maintain strong interpersonal skills in a team environment
-
Demonstrate analytical and problem-solving skills
-
Take initiative
-
Demonstrate excellent written and verbal communication skills
-
Results management: You are well-equipped to set goals and objectives, devise plans for achievement of goals, monitor progress, solve problems, and make effective decisions.
-
Creative thinking: You can see new possibilities, find connections between disparate ideas, and reframe thinking about an issue; you are innovative and can use new ideas or perspectives to solve difficult problems.
-
Customer service focus: You have a strong customer-service orientation founded on understanding the business needs and pressures of our clients, and the ability to proactively identify needs and take action to resolve issues.
-
A degree or a diploma in human resources, data science, computer science, business technology management, information systems, business analytics,, or a related discipline
-
Proficient in MS Office suite including Excel, Word, Office, PowerPoint and Teams
-
Intermediate skills in Excel (filtering, pivot tables, formulas including SUM, SUMIF, AVERAGE, VLOOKUP, IF, INDEX MATCH, etc.)
-
Experience in a human resources role or a data analytics role, preferably in the public sector or a large, unionized setting
-
Exposure to an HRIS system (PeopleSoft/Oracle preferred) and knowledge of HR metrics and reporting principles
-
Good working knowledge of relational database concepts and best practices is required.
-
Experience with Microsoft Power BI or similar data visualization and reporting software is required
-
Experience with Microsoft SQL Server Management Studio (SSMS) or similar SQL development environment is required
-
Experience in SSRS, Microsoft Power Apps and Power Automate, SPSS, Python, and R are all assets
-
CPHR designation (or working towards completion) is an asset
-
Consent to a criminal record check
-
Confirm you're legally entitled to work in Canada
