Database Analyst

About Us:
The Ontario Provincial Police (OPP) is one of North America's largest deployed police services with more than 5,800 uniformed officers, 2,400 civilian employees and 830 Auxiliary officers. We provide essential services that ensure the safety and security of the people of the Province of Ontario. The OPP is a division of the Ministry of the Solicitor General, the largest operational ministry in the province with a presence in every community across Ontario. We are the largest police service in Ontario and the second largest in Canada.

The Communications and Technology Services Bureau (CTSB) is comprised of more than 1,000 dedicated uniform and civilian professionals who possess a wide variety of backgrounds, expertise, and technical skills. The challenge of meeting the needs of a provincial police service with over 9,000 uniform civilian members in a province as vast as Ontario is significant. Despite this, CTSB members have risen to the occasion and will continue to surpass expectations in meeting the needs of a diverse, geographically deployed OPP workforce.

The OPP Values promote always doing the right things for the right reasons, by:

- Serving with PRIDE, PROFESSIONALISM and HONOUR.
- Interacting with RESPECT, COMPASSION and FAIRNESS.
- Leading with INTEGRITY, HONESTY and COURAGE.

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

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 "How to apply" section if you require a disability-related accommodation.

**What can I expect to do in this role?**: To design, develop, implement and maintain databases, and provide advice on data management and systems development procedures and techniques to clients.

**How do I qualify?**:
**Mandatory**:

- Ability to pass an OPP background/ security investigation.

**Knowledge, Skills and Abilities**:

- Knowledge of data modelling and database development methodology and techniques, programming languages, and data storage and retrieval techniques to: analyze client data flow and management requirements in relation to program services and operations; recommend database structure and data management standards and procedures; design, implement and test database systems.
- Knowledge of systems development methods and practices in order to prepare documentation on development and design specifications, develop and recommend data management procedures (e.g. user access, data security), and write manuals and guidelines for users.
- Excellent oral and written communication skills as well as strong interpersonal skills.
- Analytical and problem-solving skills to analyze client information and data management requirements, and to develop database and recommend related data management standards and procedures.
- Analytical and evaluative skills to develop and recommend data management procedures, e.g. controlling user access, security control measures; and to develop and deliver training and technical support to users during testing, implementation and ongoing use of databases and systems.
- Ability to determine parameters and scope of review/analysis of client operations and data management requirements in preparation for feasibility studies; determine and recommend data management strategy; to client and recommend related policies, standards and procedures for operation and administration (e.g. levels of user access, security measures, data manipulation and storage capabilities); identify opportunities for data sharing and integration across projects/programs; determine testing and implementation plans.

**Additional Information**: Ensure that you read the job description to make sure you understand this job. Even if you don't meet every requirement in this job description, we still encourage you to apply.

At this time, all employees working in congregate living settings are required to provide proof they are fully vaccinated, meaning they are fully vaccinated as defined by the Ministry of Health (refer to: COVID-19 Fully Vaccinated Status in Ontario), including 14 calendar days have passed since receiving their final dose of the COVID-19 vaccine.

Employees who do not provide proof of full vaccination will be deemed ‘not vaccinated' under the Employer's policy and will be required to attend a vaccine education program, as determined by the Employer. Employees who are not vaccinated under the policy with a valid medical exemption will not be required to atte