Data Analyst (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 6 months in duration.

Salary Grade:  207        From:  $63,146.61  

Job Summary :

Assist in the design and development of customized operational and management reports including Dashboards and Scorecards using various programming languages and BI Tools. Assist management with briefing and presentation materials on a regular or ad hoc basis. Provide technical support on CBIA produced BI/data products as well as assist in the extraction, transfer and load processes of data using multi-platform programs. Execute on data requests from internal and external clients, and assist other Analysts in the preparation and deliver of Branch information products and services. Conduct various business analytic functions including documenting business requirements, participating in various branch projects and initiatives including the co-ordination and tracking of project deliverables.

Major Duties & Responsibilities

1. Refresh and maintain 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. . This includes executing routine data requests by writing/editing programs/queries from multiple data sources, updating data sets, validating data, and assisting with data analysis.

2. Build queries and/or write programs to extract and compile data using software tools and programing languages such as: Power BI, DAX, M, SAS, R, SQL, Python and Cognos, to merge, analyze, and transform data from various sources in order to conduct business and statistical analysis.

3. Assist in the development and production of ad hoc and regular BI products on claims and cost utilization, employer and worker profiling, in response to requests from internal business areas. This includes consulting with business analysts to select the most appropriate data source, writing and/or documenting programs/queries from multiple data sources, and assisting in the building and enhancing reports; providing basic explanations of data findings, analysis and statistical methodologies and measurements.

4. Document data and report requirements including source-to-target mapping to ensure data integrity and quality. This includes consolidating and documenting meta data for business values; gathering and documenting business rules and definitions for data attributes in WSIB Enterprise data sources. Ensure data and information are valid and reasonable before releasing to the business.

5. In collaboration with analysts and the business, document business and technical requirements and participate in technical and business testing of data sources and BI and analytics products.

6. Ensure data quality and integrity of BI and analytics products by matching or comparing data to appropriate data sources, validating accuracy, identifying, analyzing and assisting in the investigation root causes to data issues or problems.

7. Assist in the maintenance and improvement of internal processes including the creation of process maps, user guides, as well as identify and implement solutions to increase automation and increase efficiencies.

8. Develop and maintain comprehensive end user documentation and reference materials/guides for BI and analytics products.

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

10. Participate in key Branch projects, forums and working groups varying in scope and complexity including the writing of requirements, contributing to work plans and progress reports.

11. Perform other related duties as assigned or required.

Job Requirements

Education

• High school completion plus additional specialized courses or certificate program up to one year in business statistics, computer science, business/data analytics, data science, business decision support, big data.

Experience

• Eight months 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.

The WSIB is committed to being accessible and inclusive, and following barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require accommodation through any stage of the recruitment process, please let us know when we contact you and we will work with you to meet your needs.

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.