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.

Data Analytics Section maintains data integrity and interoperability linked to internal and external information sharing. It is intended for this Section to become a Centre where fusion of technology and resources ensures the effective flow of information, intelligence production, operational tasking and measurement. DAS is comprised of the following teams Data Analytics Unit and Intelligence and Information Management Unit.

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.

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

Interpersonal skills to conduct interviews, read program and procedural manuals, review existing data management processes. Ability to work in a team environment.

Ability to explain how various technical issues and requirements (e.g., nature of storage requirements, hardware/software capabilities or limitations) impact on database design and eventual capabilities, to non-technical clients and end users. Ability to explain and ensure client's understanding of database management and maintenance procedures and requirements (e.g., controlling user access, security measures).

Oral communication skills to conduct interviews with clients and gather information on data flow and data management requirements.

Ability to explain and discuss technical recommendations and requirements with clients, users, project team and other technical staff.

Writing skills to prepare reports on data requirements, write documentation for design and development of database, develop operating procedures, develop training resources, instructions, and manuals for end user.

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.

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

**Application Instruction**: Resume / cover letter must be received no later than 11:59 pm on the closing date. Submit quoting WIN ID # (if applicable) and file # 23-266 showing how your qualifications, training and experience relate to the position to: S/Sgt. Lisa Kinnear.

Only those applicants selected for interview will be contacted.

**Additional Information**:
**Address**:

- 1 Permanent - Full Time, 777 Memorial Ave, Orillia, Central Region

**Compensation Group**:

- Ontario Provincial Police Association Civilians- Understa