Senior Database Analyst

Make the most of your expertise in data management techniques and technologies! Join the Land and Resources I&IT Cluster as a Senior Database Analyst.

About Us
The Land and Resources I&IT Cluster (LRC) is one of eight clusters in the OPS formed to provide groups of ministry partners with all their information technology needs. LRC partners with the Ministries of: Indigenous Affairs; Agriculture, Food and Rural Affairs; Environment, Conservation and Parks; Northern Development, Mines, Natural Resources and Forestry; and Energy.

LRC works with program areas in each of the ministries to understand their business needs and develop technology solutions that enable business transformation and digital public service goals and objectives. Technology solutions range from new business applications to office productivity tools, from information management expertise to telecommunications support.

The LRC works closely with other clusters and the Office of the Corporate Chief Information Officer (OCCIO) within the Ministry of Government and Consumer Services to enable shared technology solutions (development tools) and common infrastructure for the benefit of all ministries.

About the Branch
The Digital Solutions Branch collaborates with cluster partner ministries to co-design, deliver and support digital solutions, providing leadership in emerging technologies and innovative delivery techniques to enable modern government services.

Why work for the Ontario Public Service?
We are re-thinking how we deliver services through various initiatives, modernization initiatives and how we access and deliver critical services remotely. We are striving to enable a future-ready OPS workforce through a technology focused enterprise-wide strategies.

The Ontario Public Service (OPS) offers a competitive compensation package. We support career and leadership development, invest in learning opportunities, and recognize team and individual achievements, and support flexible work arrangements.

Want more Information?
Visit  Ministry of Northern Development, Mines, Natural Resources and Forestry  website for additional information about our ministry.

The current location for this position is at 40 St Clair Avenue West, Toronto. However, alternative work arrangements and locations will be considered at the following locations:

• 95 Ghost Lake Road, Dryden
• 1 Stone Road West, Guelph
• 300 Water Street, Peterborough
• 159 Cedar Street, Sudbury
• 70 Foster Drive, Sault Ste Marie
• Hwy 101 East, South Porcupine
• 435 James Street South, Thunder Bay

What can I expect to do in this role?

As a Senior Database Analyst (Advanced Analytics), you will:

• Provide leadership in the design, development and implementation of Advanced Analytics (Business Intelligence / Business Analytics) solutions
• Provide expert advice and guidance to stakeholders on the use of database management techniques and technologies
• Ensure solutions meet business needs of internal and external stakeholders and adhere to Cluster and enterprise policies and standards
• Provide advice and guidance on new Advanced Analytics developments, technologies, and opportunities

How do I qualify?

Technical Knowledge and Experience

• you have demonstrated knowledge and experience in implementing and administering Advanced Analytics tools (Cognos, PowerBi) and related emerging technologies
• you have demonstrated expert knowledge and experience in application development on a wide range of computer technologies
• you have proven technical leadership in planning, analysis, definition, design, development and implementation of Advanced Analytics solutions
• you have demonstrated knowledge and experience in data management and solutions delivery principles, methodologies like agile, troubleshooting techniques and scripting languages such as SQL
• you have demonstrated knowledge and experience in design and development of databases and data management structures, data storage and retrieval techniques, and optimizing database performance of Advanced Analytics solutions
• you have demonstrated knowledge and experience in implementing and administering data integration systems like Informatica

Analytical and Problem-Solving Skills

You have analytical and problem-solving skills to:
• develop project plans, data management structures and overall database design requirements and standards
• coordinate analysis and development of data management systems and to troubleshoot complicated problems

Communication Skills

You have demonstrated verbal and written communication skills to:
• interview diverse clients about program operations, decision-making processes, goals and objectives
• present findings and recommendations to senior management
• prepare systems documentation, manuals, business cases, and project reports
• draft database management policies and standards
• explain analyses/recommendations

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 Monday, November 8, 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.