Data And Business Analyst

Requisition ID: 8720 

Department: Transit Services Dept. 

Service: Safety, Regulatory, Trng & Dev Service 

Branch: Reg & Compl, Qual Cntrl & Assur Branch

Employment Type: 1 Full-time Permanent  

Work Hours: 35.00 /hours per week

Affiliation: ATU 1760 

Salary Information: $65,279.76 - $92,588.86  annually (2023 rates of pay)

Location: Transit Service, 1500 St.Laurent  

City: Ottawa, ON

Job Category: Transportation 

Application Close: 23/06/2023

Job Summary

The mandate of the Safety, Regulatory, Training and Development (SRTD) Service is to provide training and development, safety, regulatory compliance, and quality and continuous improvement of bus, para transit and rail services.

You are responsible for developing and implementing data analytics in addition to measurement strategies to facilitate data driven planning and decision making in the Safety, Regulatory, Training & Development service area, aligned with the department’s strategic priorities. As part of the Regulatory Compliance, Quality Control & Assurance team, you are responsible for all safety/security data including mining, creation, compilation, data visualization, monitoring, and integrity. You are responsible for conducting assessments, providing analysis and advice to the Management Team on standards, efficiencies, best practices, quality processes and continuous improvement matters related to safety and security data. You act as a technical lead for data and analytics including data governance and data management practices.

You define, measure, and identify opportunities for improvements, provide analytical guidance and advice on best practices, quality processes and continuous improvement matters. You develop processes for ongoing tracking and reporting key performance metrics to the Management Team. You serve as a subject matter expert for reliability and quality process analysis.

Education And Experience

4-year University degree in Statistics, Economics, Mathematics, Computer Science, Data Science, Business Administration or a related field.

Minimum 4 years of experience working in data and/or quantitative analysis including data collection, predictive modelling, statistical analysis, data mining, data visualization, and performance measurement. Experience drafting reports and providing recommendations to management.

Experience working in a transit services organization is an asset.

KNOWLEDGE

Knowledge of data governance and data management practices

• Knowledge of survey and analysis techniques
• General knowledge of corporate technology systems and databases, business intelligence and data visualization tools
• Understanding of developing data analytic models and frameworks
• Knowledge of statistical analysis, statistical methods related to quality tracking and reporting, interpretation, methods, tools and predictive modeling
• Knowledge of concepts of monitoring, evaluating, and reporting
• Knowledge of the transit industry
• Understanding of emerging research methodology and technology
• Knowledge of database principles and structure
• Understanding of related software and information systems (i.e. database management tools, SAP, project management, etc.)
• Knowledge of data systems and statistical data collection
• Knowledge of applicable health and safety legislation, including the rights and duties of workers

Competencies, Skills And Abilities

Strong analytical skills and research techniques

• Possess organizational skills and flexibility to plan, organize and prioritize own work and to deal effectively with multiple demands, conflicting priorities, pressures and deadlines
• Passion for analytics and commitment to staying current with new technologies and innovative approaches and enabling their use solve business problems
• Possess effective written, verbal and interpersonal communication skills
• Possess computer literacy in MS Office Suite in a Windows environment, including use of the intra/Internet
• Possess computer literacy with relational data models and creating complex queries to transform data using for example Microsoft SQL, Microsoft Power BI, SQL Server BI, or Python.
• Possess the ability to have mental and visual concentration, remain attentive to detail and able to interpret/analyze/evaluate large volumes or quality of data by external sources
• Possess computer literacy with data visualization software such as Microsoft Power BI, Tableau, etc.
• Possess analytical and problem-solving skills, to analyze issues and problems and develop realistic and innovative solutions
• Ability to interpret and question veracity of data
• Possess consultative, collaboration and facilitation skills to build strong working relationships with internal and external stakeholders
• Able to interpret/analyze/evaluate large volumes of data, to make decisions and formulate recommendations
• Able to perform numerical, service and statistical analysis, and work with statistical analysis software and other advanced computer applications or software used in the section
• Thorough and attentive to detail
• Able to work independently, with minimum supervision, and collaboratively with all staff
• Attentive to detail and able to interpret/analyze/evaluate large volumes or quality of data, to make decisions and formulate recommendations

What You Need To Know

• Please save a copy of the job poster. Once the closing date has passed, it will no longer be available.
• Experience and formal training combined with demonstrated performance and ability may substitute for stipulated academic requirements.

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 (email: [email protected]) at 613-580-2424, extension 47411 HR Service Centre at 613-580-2424, extension 47411.