Data Analyst, Road Safety
Requisition ID: 17078
Department: Public Works Dept.
Service: Traffic Services
Branch: Traffic, Safety & Mobility Branch
Employment Type: 1 Full-time Temporary - Until the end of the current year.
Work Hours: 35.00 hours per week
Affiliation: CIPP
Salary Information: $80,325.70 - $97,739.46 annually (2025 rates of pay)
Location: 100 Constellation, Nepean
City: Ottawa, ON
Job Category: Administrative and Support Services
Application Close: 24/04/2025
JOB SUMMARY
Road Safety and Traffic Investigations is responsible for coordinating and directing traffic investigations, collecting, analyzing and processing traffic field data, and developing procedures to enhance safety for drivers and pedestrians through the continuous review of evolving traffic and collision patterns and the timely revision of speed limits and upgraded traffic control devices. The unit manages the implementation, monitoring, assessment, refinement and development of installation criteria for traffic control devices and safety initiatives such as the Community Safety Zone Program and Adult Crossing Guard Program to maximize their effectiveness, and is responsible for the investigation of fatal collisions to determine the role of the road and its infrastructure in the cause or severity of those collisions.
Automated traffic enforcement technology, combined with other speed enforcement methods, education and awareness, can help reduce the number and severity of collisions on our roads. You use data to make recommendations on where automated traffic technology will be used. These criteria include, but are not restricted to, high-risk, high-frequency and high-collision locations.
- High-risk locations are those where the safety of citizens or police is at risk through conventional enforcement methods.
- High-frequency locations are those where data indicates motorists are ignoring or breaking traffic laws on an ongoing basis.
- High-collision locations are those where data indicates a greater frequency of collisions.
You conduct analysis and develop analytical solutions that enable evidence-based decision making, improve operational performance, and contribute to improved road safety outcomes identified in the City’s Strategic Road Safety Action Plan. This includes the development and analysis of key performance indicators, preparing complex technical reports or dashboards, data visualizations and presentations for internal and external clients.
EDUCATION AND EXPERIENCE
Completion of 4 year university degree in Statistics, Mathematics, Computer Science, Data Science, Geomatics or Geography with a concentration in Geographic Information systems, or a related field
Minimum of 3 years of experience in the field of data and analytics with an emphasis on public safety analysis and analytic solution development.
KNOWLEDGE
- Advanced knowledge of:
- Microsoft Office Software (Word, PowerPoint, Excel, Visio, and Outlook).
- Programming language and its use in geoprocessing or equivalent.
- Web technologies such as CSS, HTML, and HTTP.
- ESRI ArcGIS Pro and ArcGIS Server.
- Comprehensive understanding of spatial database structures.
- Data systems and statistical data collection
- Survey techniques and methodologies
- Database management and data handling procedures (data integrity, statistics)
- Programming languages including: Python, VB. NET, C#, Flex, Silverlight, JavaScript
- Advanced skills in data management software
- General knowledge of:
- The principles of the safe systems approach to road safety.
- The Highway Traffic Act and associated municipal road safety regulations.
- Knowledge of Municipal Freedom of Information and Protection of Privacy Act (MFIPPA).
- Knowledge of applicable health and safety legislation, including the rights and duties of workers
- Knowledge or experience with a centre of excellence approach to enabling an organization and customers to self-serve advanced analytics is highly desirable
COMPETENCIES, SKILLS AND ABILITIES
- Prepare and deliver technical summary reports
- Data handling and statistical analysis
- Analytical skills backed by proficiency in dealing with data, including geospatial data
- Skilled with data visualization tools such as Tableau, QlikView, or similar
- Plan, organize, and schedule work
- Work professionally with technical staff, consultants, and research partners
- Communicate effectively both verbally and in writing, with different stakeholders
- Ability to undertake projects and tasks with minimal supervision
- Ability to work in a team with technical staff
- Ability to manage multiple priorities in a fast-paced, ever changing environment.
- Strong initiative, judgment and reliability
- Highly motivated and conscientious
- Diplomacy, discretion and tact
- Works well in a team environment
- Desire and flexibility to expand their knowledge base to grow their skills in adjacent disciplines
WHAT YOU NEED TO KNOW
- Language Requirement: English oral, reading, writing
- Police Record Check: The successful candidate will be required to complete a Criminal Records and Judicial Matters Check with the Police Services detachment in their jurisdiction to the City of Ottawa’s satisfaction.; Police record checks completed by a third-party company will not be accepted.
- Experience and formal training combined with demonstrated performance and ability may substitute for stipulated academic requirements.
- Please save a copy of the job poster. Once the closing date has passed, it will no longer be available.
We wish to thank all applicants for their interest and effort in applying for this position. Only candidates selected for interviews will be contacted.
The City of Ottawa promotes the principles of diversity and inclusion and adheres to the tenets of the Canadian Human Rights Act and the Ontario Human Rights Code. We encourage applications from members of Indigenous, Black and other racialized communities, persons with disabilities, women and non-binary persons, persons of all ethnic origins, religions, sexual orientations, classes, gender identities and expressions.
Candidates are encouraged to self-identify as a member of one or more designated employment equity groups in the self-identification questionnaire.
The City of Ottawa provides accommodation during all parts of the hiring process, upon request, to applicants with disabilities. If contacted to proceed to the selection process, please advise us if you require any accommodation.
Accessible formats and communication supports are available upon request. Please contact the HR Service Centre at 613-580-2424, extension 47411.