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

What can I expect to do in this role?

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.

How do I qualify?

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.

Collection of Information

Your personal information is being collected and will be used to determine your qualifications for employment with the Ontario Public Service, and for recruitment modernization initiatives. OPS Careers is an authorized common service in accordance with s. 6 of the Ministry of Government Services Act, R.S.O. 1990, c. M.25 and this collection of personal information is necessary to the proper administration of OPS Careers.

Please do not provide more personal information than what is asked of you. For example, do not include your social insurance number, photograph, or banking information, etc. with your application. We strongly encourage you not to provide us with information beyond that which is requested in the job posting.

If you have any questions about the collection, use, disclosure, or retention of your personal information, please contact us.

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.

Remember: The deadline to apply is Friday, June 16, 2017 11:59 pm EDT. Late applications will not be accepted.

We thank you for your interest. Only those selected for further screening or an interview will be contacted.