Apply By: Monday, November 8, 2021 11:59 pm EST
Competition Status: Position Filled

Approximately 61 individuals applied for this opportunity.

We have completed the recruitment process and successfully hired the top candidate into the position.

To look for other job opportunities that match your skills and experience go to Job Search. You may also subscribe to our Job Alert service to receive emails when new jobs open up that match your determined search criteria.

Thank you for your interest in the Ontario Public Service.

Senior Database Analyst

Job ID:
170382
Organization:
Ministry of Northern Development, Mines, Natural Resources and Forestry
Division:
Land and Resources I&IT Cluster
City:
Dryden, Guelph, Peterborough, Sault Ste Marie, South Porcupine, Sudbury, Thunder Bay, Toronto
Position(s) language:
English
Job term:
1 Temporary up to 12 months with possible extension
Job code:
17160 - Systems Officer 5
Salary:
$1,483.40 - $1,916.28 Per week*
*Indicates the salary listed as per the OPSEU Collective Agreement.

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

About the job

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

What you bring to the team


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.

Additional information:

Apply by:
Monday, November 8, 2021 11:59 pm EST
Position details:
  • 1 English Temporary, duration up to 12 months, 40 St Clair Ave W, Toronto, Toronto Region or 70 Foster Dr, Sault Ste Marie, North Region or 300 Water St, Peterborough, East Region or 159 Cedar St, Sudbury, North Region or 1 Stone Rd W, Guelph, West Region or 95 Ghost Lake Rd, Dryden, North Region or Hwy 101 E, South Porcupine, North Region or 435 James St S, Thunder Bay, North Region
Compensation group:
Ontario Public Service Employees Union
Work hours:
Category:
Information Technology
Posted on:
Monday, October 25, 2021

Note:

  • E-NR-170382/21
    The information that you provide for the purpose of this competition and the results from this competition may be used to fill other positions. These positions may be of various tenures, including short-term assignments. Your information and the results from this competition will be retained for the purpose of filling vacancies in accordance with the applicable collective agreement or policy provisions.


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.


Strengthening Ontario, together