Data Analyst

Ottawa Police Service; Ottawa; On-site; CAD 93,000 - 110,000; Full time

Job summary

A municipal police service in Ontario is seeking a Data Analyst for a casual position. The role involves providing analytical support to enhance the organization’s data strategy and involves complex analysis and research. Candidates should have a degree in a related field and experience in data analysis. This position offers a competitive salary range of $93,080.26 – $109,607.68 annually.

Qualifications

• Successful completion of a four-year degree in Applied Statistics, Data Science, or related discipline.
• Minimum three years’ experience in data analysis and modeling.

Responsibilities

• Support the development of the data strategy including data collection and analysis framework.
• Provide recommendations to enhance systems of data collection.
• Facilitate meetings to define analytical opportunities.

Skills

Data analysis

Statistical modeling

Data visualization

Project management

Fluency in English

Education

Four-year degree in applied statistics or related field

Tools

SPSS

R

Power BI

PostgreSQL

Job description

Competition Number: 19723
Applications will be accepted until 2359 hrs on 25/11/2025.

Posting Details

This posting is for one (1) casual position. All civilian competitions include the possibility of extension and/or additional temporary or permanent positions.
Salary: $93,080.26 – $109,607.68 annually (2025 rates).
All applications must be received on time through the online application system. Applicants are required to upload their cover letter and resume in addition to the candidate profile. The cover letter should clearly outline your qualifications for this position.

Job Information

• Directorate: Strategy & Communications
• Section: Business Performance
• Pay Group: Seven (7) – Under Review
• Job Code: 10141261
• Work Location: Central – 19 Fairmont Avenue
• Supervisor’s Title: Manager Business Performance
• Effective Date: October 1, 2022

Overall Purpose

Reporting to the Manager of Business Performance, the Data Analyst is responsible for providing support and analytic advice to Senior Leadership including supporting projects that will enhance the use of data, involving complex analysis and research. The Analyst supports the development of the organization’s data strategy, proactively identifies analytical opportunities, leverages advanced analytical techniques to conduct business analysis and provides analytical leadership throughout the organization.

Major Responsibilities

• Support the development of the organization’s data strategy, including the data collection and analysis framework.
• Provide recommendations to develop or enhance systems of data collection; determine validity and limitations of data; establish standards and guidelines for data collection, modeling, and analysis.
• Facilitate meetings with internal and external clients to define analytical opportunities and recommend solutions.
• Leverage advanced analytical techniques to conduct business analysis, identify meaningful insights, and produce reports to support equity and human rights analyses for senior management and the community.
• Measure effectiveness of initiatives and programs; identify trends, emerging issues, and implications; build baselines against which future metrics can be measured.
• Apply a user‑centred development approach to build reports and dashboards employing best practices.
• Present reports, results of analyses, and recommend data collection and analytic strategies to advance equity in the workplace and in the community.
• Expand community access to open data to increase transparency and foster innovation.
• Liaise with related statistical agencies to ensure adherence with data analysis standards and benchmark results.
• Establish collaborative working relationships with stakeholders/partners and act as a change agent to build a continuous improvement culture.
• Represent the unit on committees, task forces, working groups, and meetings as assigned.
• Provide supervision, guidance, and mentoring to analysts and others on equity, inclusion, and human rights data collection and analysis.
• Remain current with legislative changes and emerging good practices related to data equity or social identity data collection or analysis.
• Research innovative practices related to data collection, statistical analysis, and data visualization.

Statement of Required Qualifications

Education

• Successful completion of a four (4) year degree in Applied Statistics, Data Science, Social Sciences, Criminology, or a related discipline with a focus on equity, human rights, or social justice.
• Experience and formal training combined may substitute for stipulated education requirements.

Experience

• Minimum three (3) years’ experience in data analysis, statistical and predictive modeling, applying a wide range of analytical techniques, exploratory data analysis or data mining processes including framework development and large‑scale project implementation.
• Presenting data and insights to non‑technical audiences using graphical representations and data visualizations.
• Developing KPIs and reports from concept, development, deployment, and reporting, to metric ownership.
• Operational research and program evaluation experience, including forecasting trends, identifying emerging issues, and applying critical thinking skills.
• Project management experience demonstrating the ability to foresee challenges, risks, and opportunities concerning socio‑demographic data collection in a policing context; leading and organizing projects and troubleshooting creatively.
• Experience with statistical and research software (SPSS or R) and data visualization tools (PowerBI).

Language

• English – fluency in oral, reading, and writing.

Certifications and Licences

None applicable.

In‑service Training

• Occupational Health & Safety
• Respectful Workplace
• Harassment & Violence in the Workplace
• Accessibility for Ontarians with Disabilities Act (AODA)
• Equity, Diversity & Inclusion (EDI)

Job Knowledge

• General knowledge of the organization’s mission, vision, and values.
• Strong knowledge of data and statistical methods, tools, and operationalizing analytic models.
• Advanced knowledge, skills, and proficiency in virtual platforms, MS Office Suite, and databases, including the use of virtual platforms for conducting meetings and/or presentations.
• Relational data models and complex queries to transform data using PostgreSQL, Microsoft SQL, Microsoft Power BI, SQL Server BI, and Python.
• High level of initiative and self‑directed problem solving and critical thinking, with strong attention to detail.
• Strong political acuity to make recommendations to senior leadership, build consensus among stakeholders, and resolve conflict.

OPS Competencies

• Communication – Level 3
• Leadership – Level 1
• Teamwork – Level 2
• Planning & Organizing – Level 2
• Adaptability – Level 2
• Resource & Fiscal Management – Level 2
• Service Orientation – Level 2
• Organizational & Environmental Awareness – Level 1
• Network & Relationship Building – Level 3
• Strategic Thinking – Level 1
• Problem Solving – Level 3

Hours of Work

Monday to Friday day shift schedule.

Effort and Working Conditions

• Works independently and as a team under general direction of the Manager, Business Performance.
• Work performed in accordance with all relevant statutes and regulations.
• Subject to periods of prolonged sitting, visual and mental concentration, intense concentration when analyzing metrics, and use of integrated databases.
• Utilizes advanced analytical skills to research, plan, and resolve technological problems associated with capturing data and using integrated computerized databases.
• Organizes own assignments to ensure tasks are completed in a timely manner while performing daily activities.
• Closely collaborates business lines to coordinate and monitor efficient capturing of data for research, analysis, surveys, academic partnerships, data governance, and business intelligence.

Desired Qualifications

• Experience working on projects in a large health or public safety organization is preferred.
• Experience with law enforcement/policing/criminal justice system.
• Experience with geospatial analysis using the ArcGIS platform, including web‑based development tools such as ESRI ArcGIS Online and ESRI ArcGIS Enterprise.

Additional Competition Information

We thank all candidates for their interest; only those selected to continue in the selection process will be contacted.
Once the closing date has passed, the job posting will no longer be available.
Additional information about our hiring process can be found on the recruiting website.
For questions, contact [e-mail].