Data and Business Analyst - Ottawa, Canada - City of Ottawa

City of Ottawa

Verified Company

Ottawa, Canada

1 week ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Requisition ID: 7346

Department:
Transit Services Department

Service:
Safety, Regulatory, Training & Develoopment Service

Branch:
Regulatory & Compliance, Quality Control & Assurance Branch

Employment Type: 1 Full-time Permanent

Work Hours: 35.00 /hours per week

Affiliation:
ATU 1760

Salary Information:
$65, $92, rates of pay)

Location: 1500 St.
Laurent

City:
Ottawa, ON

Job Category:
Transportation

Application Close: 27/03/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.

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

COMPETENCIES, SKILLS AND ABILITIES:

Strong analytical skills and research techniques
Able to work independently, with minimum supervision, and collaboratively with all staff
Possess organizational skills and flexibility to plan, organize and prioritize own work and to deal effectively with multiple demands, conflicting priorities, pressures and deadlines
Able to interpret/analyze/evaluate large volumes of data, to make decisions and formulate recommendations
Possess computer literacy in MS Office Suite in a Windows environment, including use of the intra/Internet
Possess computer literacy with data visualization software such as Microsoft Power BI, Tableau, etc.
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.
Attentive to detail and able to interpret/analyze/evaluate large volumes or quality of data, to make decisions and formulate recommendations
Possess analytical and problemsolving skills, to analyze issues and problems and develop realistic and innovative solutions
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
Ability to interpret and question veracity of data
Possess consultative, collaboration and facilitation skills to build strong working relationships with internal and external stakeholders
Possess effective written, verbal and interpersonal communication skills
Thorough and attentive to detail
Passion for analytics and commitment to staying current with new technologies and innovative approaches and enabling their use solve business problems

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 requi