Data Engineer (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:  214        From:  $101,331.63  

Job Summary :

•       The data engineers will design, build, integrate data from various sources and are the managers of big data within WSIB. 
•       Will write complex queries to ensure data is easily accessible, runs efficiently and optimizes the performance of the WSIB's information management system.
•       The data engineer will enable and support the design and architecture of big data warehouses and data sets
•       Will build and maintain ETL on big data sets on MS Azure platform, utilizing Azure Data Factory, Synapse and delta lake technologies and concepts.

Major Duties & Responsibilities

1.   Lead back-end development to define and build data pipelines

• Design, build, and integrate data from various sources and are the managers of big data within WSIB 
• Integrate data from a variety of sources (both structured and unstructured data), assuring that they adhere to data quality and accessibility standards
• Responsible for defining the data model and building data hierarchy structures that will serve as the basis for business intelligence and analytics products and solutions
• Write complex queries to ensure data is easily accessible, runs efficiently and optimizes the performance of the WSIB's system wide information management systems
• Enable and support the design and architecture of system wide information management systems

2.   Design and build high quality information products and solutions, customized to client requirements

• Use a variety of programming languages (Java, SAS, Angular 2+, etc) in order to create user-friendly products and services in order to create comprehensive and detailed products to facilitate engagement with various stakeholders 
• Run ETL on big data sets and support the creation of big data warehouses that are used by the analysts and data scientist, by using their extensive experience with data wrangling and data cleansing techniques
• Use modern methods to enhance the end user experience  for analytical information products
• Recommend solutions to team members and senior management on how to best consolidate and retrieve data
• Where possible, build automation using Maven and NPM (node package manage)

3.   Lead front-end requirements and development of information and analytics projects

• Develop and deliver front-end visualization solutions that allow end users to interpret datasets in an easy-to-understand way
• Lead and/or perform front-end application development and maintenance, adhering to best practices and methodologies
• Provide application support and enhancements to existing CBIA applications

4.   Ensure all information and analytics projects adhere to WSIB standards and processes

• Manage data verification, leverage new data collection processes, and collaboration with subject matter experts to select the relevant sources of information
• Follow proper protocol when dealing with confidential data sets, and monitor the establishment of analytical data sets that combine various data sources with needed transformation to serve various analytical purposes
• Ensure data and analysis are methodologically sound and meet commonly accepted standards

5.   Work independently on complex technical projects

• Build high quality mockups and design  prototypes to influence and assist senior management in enterprise-wide product design decisions
• Effectively manage multiple projects and tasks at one time

6.   Collaborate efficiently with various internal and external stakeholders and experts

• Work closely with other developers, user experience analysts, project managers, business analysts and senior management to design and implement products and tools based on the business requirements defined by internal and external clients
• Develop and maintain effective communication linkages, working relationships and collaborations with various business areas across the organization to identify needs and discuss and resolve issues.  

7.   Act as an expert in special technology projects and assignments

• Provide technical expertise and recommendations to management in the assessing software applications or tools in support of systems implementations and operations
• Provide a lead technical role during upgrades, modifications and defect/fixes on CBIA developed applications, and clearly communicate anticipated issues and mitigation strategies to stakeholder.
• Provide specialized technical advice, recommendations and information to internal and externals clients on proposed change requests and provide recommendations of alternative technical or functional application solutions
• Explore, investigate and leverage new technologies to explore solutions for legacy reporting issues and traditional, technologically-deprived challenges.
• Comprehensive understanding of software lifecycle including development, testing, release management and production monitoring

8.   Other duties, as required

Job Requirements

Education

• University degree at the undergraduate level with a specialty focus in mathematics, statistics, computer science, business, engineering, information management or science.

Experience

• Five years prior experience in SQL Server, DB2, Oracle and related programming languages, business intelligence tools and data visualization software.

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.