Job Description

The Data Engineering team is responsible for maintenance and modernization of the tools, platforms, pipelines, and solutions that support the data integration, data governance, data analytics and reporting initiatives at the organization. Currently the team is actively supporting the organization's cloud first strategy for cloud enabled product delivery with our Azure Data Lake landscape, IBM InfoSphere and Cognos platforms, IBM Cloud Pak for Data, SAS Enterprise Guide and SAS Viya, Oracle Exadata and Oracle Database Service for Azure OCI. Manage, maintain and optimize ITC environments including data, information and software tools. Design, develop and implement Enterprise Warehouse (such as EIW and EDW) and internal Data De-Identification components based on abstract user requirements; create complex computer programs to extract/manipulate data using Enterprise Warehouses, its datamarts, Data Stage ETL and other data sources in response to data requests from users including validating data to ensure accuracy, quality and relationships to other data entities and presenting data in appropriate format. Provide technical and business advice and expertise on Enterprise Warehouses and Data De-Identification design and Data Warehouse and Data De-Identification Framework development best practices. Lead and/or participate in ITC system development projects, track milestones and ensure timely completion. Major Duties & Responsibilities

• Analyze abstract user requirements and create computer programs using advanced programming skills in response to internal and external requests for data using Enterprise Warehouses, their related datamarts, and other data sources including for de-identification purposes. This includes understanding the abstract business needs and translating needs into specific data elements by identifying, selecting, extracting and manipulating the appropriate data, validating data to ensure accuracy, quality and relationships to other data entities and selecting the appropriate format to present data, perform data sensitivity analysis.

• Manage and maintain the IBM InfoSphere Information Suite application by monitoring performance to ensure functionality, integrity and security of the environments. Identify and troubleshoot problems as they arise which may involve interacting with other areas within IT for resolution. Ensure business interface to Information Analyzer and Information Governance Catalogue is available at all times and identify and resolve any issues as they arise. Ensure the Microservices and Business Workflow Automation services and servers are available and optimized for performance and functionality. Remediate issues related to the application using administrator access and application admin consoles.

• Oversee and/or provide on-call support for ITC operations and testing teams (e.g. monthly update of datamarts, related systems and Business Intelligence (BI) deliverables, testing environments) to ensure the delivery of timely, accurate, reliable and protected data to WSIB business users. This includes maintaining appropriate documentation of system and processes, reviewing and analyzing ITC operations to identify any potential problems, their impacts and associated risks, and providing recommendations to management to improve the efficiency and reliability of the ITC operations.

• Optimize the performance of Enterprise Warehouse systems (such as ReportNet packages, Extract Transform and Load (ETL) programs, queries) and Data Stage ETL based De-Identification Framework by identifying inefficiencies with the systems and processes, collaborating with Database Administrator (DBA) and other BTS technical staff to develop solutions to improve system performance, making recommendations to management and implementing approved changes to the design and maintenance of the Enterprise Warehouse and Data De-Identification systems and related tools.

• Manage and maintain the BI and/or ETL environments by monitoring their performance to ensure functionality, integrity and security of the environments and compliance with BTS information security and change management processes. Identify and troubleshoot problems as they arise which may involve interacting with other areas within ITC for resolution. Forecast computer system resource requirements, such as CPU (central processing unit), memory, disk space and recommending changes to the design, maintenance of the Enterprise Warehouses, its applications and tools.

• Design and build Enterprise Warehouse and Data De-Identification components based on user requirements and by applying appropriate system development methodology. This includes gathering and analyzing user requirements, analyzing data systems, data modeling, designing ETL and/or BI programs, testing programs by developing test criteria, reviewing test results; maintaining metadata consistency.

• Contribute to the development and implementation of the architectural strategy for Enterprise Warehouse and Data De-Identification systems by providing technical and business advice and expertise on Data Warehouse and De-Identification Framework development best practices. Collaborate with the Architects to evaluate and select data warehouse and data de-identification tools (e.g. BI, ETL) by developing and testing the evaluation criteria, and making recommendation on selection to requesting parties.

• Lead and/or participate in ITC system development projects varying in scope and complexity by establishing/developing project plans, monitoring progress and providing technical and business expertise during the various project phases (e.g. planning, designing, testing and implementation) to ensure timely project completion within the allocated budget. Assist ITC staff with the design, development, enhancement and maintenance of the ITC application systems.

• Perform other related duties as assigned or required.

Job Requirements Education

• University completion at undergraduate level with a specialty focus in Science, Technology, Engineering or Mathematics.

Experience

• Seven years prior experience in information management.

This position is currently eligible for an education equivalency. Additional years of experience will be considered in place of levels of education on a 2:1 basis. For every level of education not completed, an additional 2 years of experience will be considered as equivalent, in addition to the minimum prior years of experience as set out in the job requirements. Education Levels

• High school completion (Plus 17 Years of Experience)
• High school completion plus additional specialized courses or certificate program of up to one year (Plus 15 Years of Expereince)
• College diploma program of over one year and up to two years (Plus 13 Years of Experience)
• College diploma program of over two years and up to three years (Plus 11 Years of Experience)
• University completion at undergraduate level (Plus 9 Years of Experience)
• University completion at the undergraduate level with a specialty focus and/or designation or certification (Plus 7 Years of Experience)

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 WSIBs 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.