Back


Job Detail

Data Analyst

City of Ottawa

Ottawa, Ontario

Data Analyst

City of Ottawa

Ottawa, Ontario
 
Salary: $80,325.70 - $97,739.46  annually (2025 rates of pay)
 

 

 

Requisition ID: 21455  
Department: Planning, Development & Building Dept.  
Service: Transportation Planning Service  
Branch: Transportation Policy & Networks Branch 
Employment Type: 1 Full-time Permanent -  
Work Hours: 35.00 hours per week
Affiliation: CIPP 
Salary Information: $80,325.70 - $97,739.46  annually (2025 rates of pay)
Location: City Hall,110 Laurier Avenue West  
City: Ottawa, ON 
Job Category: Planning and Infrastructure 
Application Close: 13/04/2026

JOB SUMMARY


The Transportation Policy and Networks Branch leads projects and initiatives to advance transportation data collection, analysis, and modelling in the National Capital Region; and also provides overall management and secretariat support for the regional transportation systems planning committee, the “TRANS Committee”. The TRANS Committee includes the City of Ottawa, la Ville de Gatineau, OC Transpo (City of Ottawa), la Société de transport de l’Outaouais, Ontario Ministry of Transportation, le Ministère des Transports et de la Mobilité durable du Québec, and the National Capital Commission. 

In the Data Analyst role, you conduct transportation data analysis and develop analytical solutions to improve our understanding of regional transportation network performance and to plan future services and infrastructure. This includes data integration, analytics, and visualizations of transportation datasets, developing technical reports, and preparing presentations for internal and external clients. 

You also assist with maintaining and updating the TRANS regional travel demand model; applying the regional travel demand model to assess the transportation impacts of various land use, infrastructure, and policy scenarios; and assist with multi-agency transportation data collection and modelling initiatives.

You work with staff from all TRANS partner agencies to analyze transportation and land use datasets; conduct research; develop communication products; support project management; and assist with other TRANS Committee activities as required. French language skills would be an asset in this role but are not required.

EDUCATION AND EXPERIENCE


Completion of 4 year university degree in Statistics, Economics, Mathematics, Computer Science, Data Science, Business Intelligence, Business Administration, Civil Engineering, Urban Planning or a related field

Minimum of 3 years of experience in the field of data and analytics

KNOWLEDGE

  • General knowledge of corporate technology systems and databases, business intelligence and data visualization tools
  • Data systems and statistical data collection
  • Survey techniques and methodologies
  • Database management and data handling procedures (data integrity, statistics)
  • Data management software such as Microsoft ACCESS
  • Advanced skills in Microsoft EXCEL
  • Microsoft Office software (Word, PowerPoint and Outlook)
  • Records management systems
  • 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 
  • 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       
  • 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 to applicants during all parts of the hiring process, upon request. 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 Employee Service Centre at 613-580-2424 extension 12211 or via email at esc-cse@ottawa.ca

We are committed to hiring military and Veteran spouses and encourage you to identify your connection with the MSEN when reaching out to us or applying to any of our open roles.

Have questions or want to learn more about us? We would love to hear from you!

ESC-CSE@ottawa.ca

 

Whenever possible, reach out to a named contact rather than a general inbox  - it helps ensure a quicker, more personalized response. If you hit a bounce-back, let us know at

employment.Emploi@cfmws.com

About City of Ottawa

The City of Ottawa: A place to grow your career.  

We are proud to be an employer of choice, attracting talented individuals who reflect the community we serve. As an award-winning employer in the National Capital region and one of Canada’s best diversity employers, we foster a respectful and inclusive culture where every employee can feel a sense of belonging. 

Your career can flourish across more than 110 diverse business lines all while enjoying the stability of a single employer. We champion continuous learning, value work-life balance and support every stage of your career journey. We are committed to investing in our people through competitive compensation, an employer-matched defined benefit pension plan and a suite of benefits that support both personal and professional well-being.  

Join the City of Ottawa to experience making a meaningful difference and improving the quality of life in our community!