Senior Systems Analysis Specialist

Don't miss out on this great opportunity to join the Business Intelligence and Business Analytics (BIBA) Solution Unit of the Corporate I&IT Solutions and Integration Management Branch (CSIMB).

You will be part of BIBA team leading implementation of on-going modernization of the On-line Analytical Processing (OLAP) solution offerings and the related infrastructure that supports the Ontario's Ministry of Health and Ministry of Long-Term Care critical program business needs. CSIM Branch is part of the Health Services I&IT Cluster (HSC).

What can I expect to do in this role?

As a Senior Systems Analysis Specialist, you will contribute to multiple on-going modernization initiatives such as cloud adoption for OLAP solutions and delivery by enhancing existing ‘Data as a Service' (DaaS) provided by the unit to ministry clients. In this role, you will:

• lead implementation of technology modernization roadmap developed for the Business Intelligence and Business Analytics (BI&BA) environment
• provide specialized technical expertise in the overall analysis, design, development, testing, implementation, support, and maintenance of systems supporting OLAP solutions
• support and configure specialized OLAP software either on-premise or on cloud, providing expertise, and ensuring expected behavior and performance
• undertake development of automated data pipelines integrating heterogeneous cloud and on-premise data sources and operations
• provide leadership in operations management of deployed OLAP solutions including troubleshooting

How do I qualify?

Technical Skills:

You will have:
• knowledge and experience with On-line Analytical Processing (OLAP) solutions such as IBM Cloud Pak for Data (CP4D), Apache Spark and others
• data management domain knowledge such as data quality, master data management, data virtualization, data de-identification, and others
• knowledge and experience with SQL and NoSQL databases
• experience with programming languages such as SQL/PLSQL, Python and Windows/Unix shell scripting
• data engineering abilities related to ETL/ELT/creating data pipes
• experience in working with hybrid On-premise / Cloud solutions, dealing with data stored On-prem and Cloud.
• experience participating in feasibility studies, requirement definition analysis, design, prototyping, testing, and maintenance of business-critical multi-tiered OLAP solutions
• demonstrated experience in the end-to-end systems development life cycle (SDLC) for OLAP solutions using waterfall or agile methodologies
• experience with client application migration (On-Prem/Cloud) and post migration support

Project and Service Management Skills:

• You have demonstrated knowledge of project management including experience in coordination, project planning, timelines, scope, budget and status reporting.
• You have technical leadership skills in operations management to support clients and staff post- implementation of new and modified application systems covering incident and change management processes.

Analytical and Problem-Solving Skills:

• You have proven analytical, problem-solving and reasoning skills to assess, identify and coordinate problems, and develop recommendations and approaches regarding business, technical, privacy and security concerns, and implement approved strategies.

Communication, Interpersonal and Presentation Skills:

• You have demonstrated communication, interpersonal and presentation skills to support technical and non-technical clients and staff by providing status updates and establishing effective working relationships with internal and external stakeholders.

OPS Commitment to diversity, inclusion, accessibility, and anti-racism:

We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.

We invite all interested individuals to apply and encourage applications from people with disabilities, Indigenous, Black, and racialized individuals, as well as people from a diversity of ethnic and cultural origins, sexual orientations, gender identities and expressions.

Visit the OPS Anti-Racism Policy and the  OPS Diversity and Inclusion Blueprint pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.

We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's Human Rights Code. Refer to the application instructions below if you require a disability-related accommodation.

Please be advised that the results of this competition may be used to form an eligibility list of qualified candidates to potentially fill future vacancies represented by the Ontario Public Service Employees Union (OPSEU). In accordance with the Collective Agreement, eligibility lists are shared with OPSEU representatives. By applying to this competition, you are providing consent that your name may be shared with OPSEU representatives.

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 Tuesday, November 30, 2021 11:59 pm EST. Late applications will not be accepted.

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