Our priority is the health and wellness of employees and the people of Ontario. As such, this position may involve working from home for all or part of the duration of this position. The WSIB model mixes working from home, office and field. When it is safe to do so, this position may be asked to work in an office.
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, along with a comprehensive benefit package and defined benefit pension plan.
About the job
Temporary Opportunity up to November 2022
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.
Provide technical support and expertise in maintaining the IBM Information Server suite and components like Information Analyzer, Information Governance Catalog, Business Provide technical support and expertise in maintaining IBM Information Server suite and components like: Information Analyzer, Information Governance Catalog, Business Automation Workflow and drawing data lineage from ETL jobs and other disparate sources including Mainframe Cobol copy books.
What you bring to the team
Major Responsibilities:
1. 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.
2. 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.
3. 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.
4. 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 BTS 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.
5. 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.
6. 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.
7. 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.
8. Perform other related duties as assigned or required.
Job Requirements:
Education:
• University completion at undergraduate level with a specialty focus in Computer Science.
Experience:
Six years prior experience in information management.
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.
Application Instructions:
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 on the WSIB Careers Site - https://www.wsib.ca/en/careers by March 16, 2022.