People & Culture Specialist, People Analytics at WorkSafeBC — NeverHard

Overview Are you a data analyst with HR expertise or a human resources practitioner with a knack for data? These roles provide an excellent opportunity to build on your analytical and problem-solving skills in an active, large organization. You'll be part of a central team that provides reporting and analysis on all areas of HR using identified data sets, including understanding the business questions of clients, identifying the right data to answer those questions, and analyzing that data to provide insight. We have two opportunities for People & Culture Specialists within our People Analytics team, one for 7 months and another for 18 months. One position focuses primarily on providing advisory services, consulting with business clients and presenting insights and analyses on various topics, while the other is primarily technical, focused on developing and maintaining queries, datasets, and Power BI solutions. However, both positions require both an advisory and a technical mindset and will work cross-functionally. How you'll make a difference: You'll build and empower teams that serve workers and employers across B.C.. Where you'll work At WorkSafeBC, we offer a hybrid work model that combines working remotely, and in our offices based on the operational needs of the position. What you'll do With direction from the Manager of People Analytics, you will work with clients to understand their needs and provide complex reporting and analysis on an ongoing and ad-hoc basis The advisory-focused position will primarily: Explore and retrieve data by writing SQL queries and using various other system-specific tools, including PeopleSoft Query and Oracle Transactional Business Intelligence (OTBI) Work directly with our internal P&C teams and business clients to provide them with insights and analyses that address their business questions in a way that impactfully communicates the story of what is happening Identify, develop, define, document, and manage distribution of metrics, measures, and KPIs via annual and quarterly reports for all areas of People & Culture As our analytics practice matures in the future, collaborate with the technical team in the development of predictive analytics and statistical models The technical-focused position will primarily: Construct data models and develop reports and dashboards in Microsoft Power BI Explore and retrieve data by writing SQL queries and using various other system-specific tools, including PeopleSoft Query and Oracle Transactional Business Intelligence (OTBI) Partner with our information & technology team to ensure new data sets 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 solutions as well as source system tables and fields As our analytics practice matures in the future, collaborate with the advisory team in the development of predictive analytics and statistical models As required, the advisory-focused position will take on technical duties, while the technical-focused position will take on advisory duties. Consistently models the appropriate level of organizational behaviours expected of all WorkSafeBC employees: responsive, respectful, fair, collaborative, accountable, and forward thinking. Is this a good fit for you? We're looking for someone who can: Collaboratively with groups and other departments Maintain strong interpersonal skills in a team environment Demonstrate strong analytical and problem-solving skills Take initiative Demonstrate excellent written and verbal communication skills You also possess strong capabilities in: 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: Y ou 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 cust omer-service or ientation founded on understanding the business needs and pressures of our clients, and the ability to proactively identify needs and take action to resolve issues. Your background and experience A degree or a diploma in human resources, data science, computer science, business technology management, information systems, business analytics, or a related discipline At least 5 years of experience in a human resources role, including at least 3 years of experience in a data analytics role, preferably in the public sector or a large unionized setting 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.) Exposure to an HRIS system (PeopleSoft/Oracle preferred) and knowledge of HR metrics and reporting principles Experience with Microsoft SQL Server Management Studio (SSMS) or a similar SQL development environment is required for both positions Good working knowledge of relational database concepts and best practices, along with intermediate skills in Power BI or a similar business intelligence tool, is an asset for the advisory position and a requirement for the technical position CPHR designation (or working towards completion) is an asset We'll consider equivalent combinations of education and experience. Important to know Before we can finalize any offer of employment, you must: Consent to a criminal record check Confirm you're legally entitled to work in Canada WorkSafeBC's COVID-19 Employee Mandatory Vaccine Policy is suspended effective January 9, 2023; however, we reserve the right to re-implement it in response to changes in the public health landscape, including public health orders. We are committed to the protection, health, and safety of our employees and our Communicable Disease Prevention Program and related protocols remain in effect. Who we are At WorkSafeBC, we promote safe and healthy workplaces across British Columbia. We partner with workers and employers to save lives and prevent injury, disease, and disability. When work-related injuries or diseases occur, we provide compensation and support injured workers in their recovery, rehabilitation, and safe return to work. We're honoured to serve the 2.49 million workers and 263,000 registered employers in our province. What's it like to work at WorkSafeBC? It's challenging, stimulating, and rewarding. Our positions offer diversity and opportunities for professional growth. Every day, the work we do impacts people and changes lives. What we do is important, and so are the people we do it for. Our ability to make a difference relies on building a team with a rich variety of skills, knowledge, backgrounds, abilities, and experiences that reflect the diversity of the people we serve. We are committed to fostering a welcoming, inclusive, and supportive work culture where everyone can contribute as their best, authentic self. Learn more: Discover who we are . Our benefits As a member of our team, you'll have access to services and benefits that help you get the most out of work - and life. Along with a competitive salary, your total compensation package includes: 7 month opportunity: Extra 4% of your salary in lieu of benefits and 4% in lieu of vacation 18 month opportunity: 4 weeks of vacation Extensive health care and dental benefits Sick leave Learn more: Find out what we offer . Salary $95,241- $115,717 /annually Want to apply? Applications are welcomed immediately; however, must be received no later than 4:30 p.m. PST on the closing date. Please note that we will be starting assessments prior to the closing date. We encourage all qualified applicants to apply . If you require an accommodation in the assessment process, please email Recruitment Testing Accommodation (SM) when you submit your application.