Business Analyst - CBA (Hybrid)

About the Workplace Safety and Insurance Board (WSIB)

We’re here to help. When an injury or illness happens on the job, we move quickly to provide wage-loss benefits, medical coverage and support to help people get back to work. Funded by businesses, we also provide no-fault collective liability insurance and access to industry-specific health and safety information. We are one of the largest insurance organizations in North America covering over five million people in more than 300,000 workplaces across Ontario. For more information, visit wsib.ca.

At the WSIB, you’ll have the opportunity to:

• explore many career paths and follow your passion
• continuously learn and grow professionally
• be recognized for the great work you do
• participate in programs that support your health and wellbeing

You’ll also receive a competitive salary and may be eligible to participate in our health and dental plan.

We are establishing our new head office in London and looking to grow our team in this region! Candidates located in this region will be given preference.

Our people have different ways of working and lifestyles. We’re committed to a mix of working in the office, in the field and from home. You have some flexibility in terms of where and how work gets done to help you balance your personal life and career goals.

This is a temporary opportunity up to 12 months in duration. 

Salary Grade:  212        From:  $86,051.06  To:  $103,855.00

Job Summary :

Conduct business and statistical analysis, assist with predictive modelling and support analytical and data governance policies, guidelines and procedures and measuring the overall utilization and effectiveness of various initiatives and programs. Produce various customized reports, data extracts or presentations on a regular or ad hoc basis. Provide technical support and advice to the business on database/data-mart/mainframe and in the developing, consolidating and reporting of data using multi-platform programs.

Major Duties & Responsibilities

1.   Build queries and/or write programs to extract and compile data using Power BI, SAS, R, and BI tools and Programing Languages, such as Cognos, TSO(JCL), Excel, SQL, JavaScript, Python, Access, to merge and analyze data from various sources (CDS, PDM, ODM, IMCAT, PSA, Data Hub etc) in order to conduct business and statistical analysis.

2.   Create, develop and produce comprehensive ad hoc and regular reports and data extractions on claims and cost utilization, employer and worker profiling, in response to data requests from internal business areas and external clients (such as MOL, MOH, employer groups). This includes selecting the most appropriate data source, executing data requests by creating data requirements, writing programs/queries from multiple data sources, building data sets, validating data, analyzing, designing, building and enhancing reports; providing basic explanations of data findings, analysis and statistical methodologies and measurements

3.   Conduct data profiling of existing data and source-to-target mapping, such as Quality Profile Report, in order to ensure data integrity and quality. This includes gathering, leveraging and documenting meta data for business values; defining, developing and documenting business rules and definitions for WSIB data attributes. Ensure data and information are valid and reasonable to the business it represents and is appropriate to meet the needs and requirements of the client by validating accuracy of data transferred from source systems to various reporting and analytic environments

4.   In collaboration with the business, define/develop business and technical requirements, conduct analysis and user acceptance testing for all change/enhancement logs related to various data repositories and marts

5.   Work collaboratively with the business and IT to maintain, enhance and support the utilization of existing and future data marts through the change request process managed through scheduled releases which include business and technical requirements, development, user acceptance testing, implementation and communication to users

6.   Ensure data quality and integrity of WSIB data by matching or comparing data to appropriate data sources, validating accuracy, identifying, analyzing and investigating root causes to data issues or problems

7.   Assist the Senior Business Analyst with client education and end user support by identifying training needs, participating in developing and delivering training/information sessions to increase client awareness and understanding of WSIB data and data extraction mining tools

8.   Develop and maintain comprehensive end user documentation and reference materials/guides in the meta data repository and ensure it is current and accurate including initiating appropriate updates of definitions

9.   Assist the Senior Business Analyst with predictive modeling by compiling data, ensuring data validity and accuracy in order to understand the overall performance of the business to support decision-making

10.  Develop and maintain effective working relationships with the business to discuss and resolve issues, understand current state and business processes, identify future needs and opportunities to fully support business data needs

11.  Participate in projects, forums and working groups varying in scope and complexity including the gathering and writing of requirements, developing work plans and completing progress reports

12.  Perform other related duties as assigned or required.

Job Requirements

Education

• University completion at undergraduate level with a specialty focus in mathematics, statistics, computer science, business, engineering or science.

Experience

• Two years prior experience in business analytics.

Our commitment to equity, diversity and inclusion

We respect and value the diversity of our people. We strive to create an environment where employees can be themselves and where our differences are celebrated.

We value and celebrate diversity and are committed to creating inclusive experiences for both our employees and prospective employees. We invite all interested individuals to apply. If you require accommodations in order to apply to this position please contact talentacquisitioncentre@wsib.on.ca.  If you are invited to participate in the interview or assessment process, you can advise our Recruiter of your accommodation needs at that time.  

Please visit our EDI Vision to learn more about what actions WSIB are taking to advance our commitment to equity, diversity and inclusion and to support all employees participating and contributing to their full potential

Disclosing conflicts of interest

As public servants, employees at the WSIB have a responsibility to act in an ethical way at all times to create a respectful workplace and maintain public trust. Job applicants are required to disclose any circumstance that could result in a real, potential or perceived conflict of interest. A conflict of interest is any situation where your private interests may impair or be perceived to impair the decisions you make in your official capacity. This may include: political activity, directorship, other outside employment and certain personal relationships (e.g. with current WSIB employees, customers and/or stakeholders). If you have any questions about conflict of interest obligations and/or how to make a disclosure, please contact the Talent Acquisition Centre at talentacquisitioncentre@wsib.on.ca.

Privacy information

We collect personal information from your resume, application, cover letter and references under the authority of the Workplace Safety and Insurance Act, 1997. The Talent Acquisition Centre and WSIB hiring parties will used this information to assess/validate your qualifications, determine if you meet the requirements of vacant positions and/or gather information relevant for recruitment purposes. If you have questions or concerns regarding the collection and use of your personal information, please contact the WSIB’s Privacy Office at privacy_office@wsib.on.ca. The Privacy Office cannot provide information about the status of your application.

As a precondition of employment, the WSIB requires that prospective candidates undergo a criminal records name check any time before or after they are hired.

To apply for this position, please submit your application by the closing date.