Senior Specialist, Information Management

---

** This is a unionized position and salary is non-negotiable ($84,992.05)**

** 24/7 on-call on a rotational basis is required for this job **

---

About the job

Job Summary:

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

---

What you bring to the team

Job Requirements

1. Education (Level and Specialty / Discipline):
• University completion at undergraduate level with a speciality focus in Computer Science.

2. Experience (Years of Related Experience and Type of Experience):
• Total of 9 years' experience
• 6 years prior experience in information management.
• 3 years' experience on the job to reach full working level.

---

Additional information:

---

Language requirements and assessment:
All external Ontario Public Service (OPS) job ads are posted in English and French. Check the "position(s) language" section at the top of each job ad for the language requirements. For all roles, candidates are assessed in English, the business language of the OPS. If the position is bilingual (English/French), you'll also need to pass a French-language proficiency test.

Exigences en matière de langue et évaluation:
Toutes les offres d'emploi externes de la fonction publique de l'Ontario (FPO) sont affichées en français et en anglais. Consultez la section « Langue du ou des postes » en haut de chaque offre d'emploi pour connaître les exigences linguistiques. Pour tous les postes, les candidats sont évalués en anglais, la langue d'affaires de la FPO. Si le poste est bilingue (anglais/français), vous devrez également passer un test de compétences linguistiques en français.

All external applicants (including former employees of the Ontario Public Service) applying to a competition in a ministry or Commission public body must disclose (either in the cover letter or resume) previous employment with the Ontario Public Service. Disclosure must include positions held, dates of employment and any active restrictions as applicable from being rehired by the Ontario Public Service. Active restrictions can include time and/or ministry-specific restrictions currently in force, and may preclude a former employee from being offered a position with the Ontario Public Service for a specific time period (e.g. one year), or from being offered a position with a specific ministry (either for a pre-determined time period or indefinitely). The circumstances around an employee's exit will be considered prior to an offer of employment.

Information collection notice

We are collecting your personal information to assess how well you meet the qualifications for employment with the Ontario Public Service, and for related recruitment purposes. The collection of personal information is necessary to the proper administration of OPS Careers, which is an authorized common service in accordance with s. 6 of the Ministry of Government Services Act, R.S.O. 1990, c. M.25.

Please do not include any more personal information than is needed for your application (for example, do not include your photograph or social insurance number).

If you have any questions about how your information is collected, used, shared or saved, please contact us.