Data Specialist - FTR

Metro Vancouver Transit Police; Vancouver; Hybrid; CAD 82,000 - 124,000; Full time

Job summary

Metro Vancouver Transit Police is looking for a Data Analyst responsible for gathering and analyzing data to inform business decisions. The role involves creating reports, collaborating with various departments, and ensuring effective data management. Candidates should have a relevant degree and experience with data analysis tools.

Benefits

Extended Health

Dental

Transit Pass

Public Service Pension Plan

Access to gym facilities

Flexible benefits package

Qualifications

• 5 years of experience in data analysis and management.
• Proficiency in data analysis tools such as SQL, Excel, and Tableau.
• Strong analytical skills and excellent communication abilities.

Responsibilities

• Gathers, processes, and analyzes data for reporting purposes.
• Creates dashboards and visualizations to communicate insights.
• Collaborates with stakeholders to identify data needs and objectives.

Skills

Data Analysis

Statistical Analysis

Data Visualization

Problem Solving

Communication

Education

Bachelor’s degree in Data Science, Statistics, Mathematics, or Computer Science

Tools

SQL

PostgreSQL

Excel

Tableau

Power BI

Python

R

Job description

Marketing Statement

Metro Vancouver Transit Police ("Transit Police") is the leader in regional public transit policing, operating across 22 communities. It provides policing services to all modes of transit: Bus, SeaBus, SkyTrain, and West Coast Express. In partnership with cross-regional partners, Transit Police prevents crime and provides coordinated police services to transit users throughout the region. It also seeks to have a workforce that is responsive to and reflective of the many diverse communities is serves.

Responsibilities

PRIMARY PURPOSE

Responsible for gathering, processing, and analyzing data to provide actionable insights that help guide business decisions. Works with various departments to identify key metrics, improve processes and manage data, and contribute to the company’s overall data-driven strategy. The role designs and develops standard and ad-hoc reports including departmental scorecards/dashboards and executive presentations. This role also engages with various business stakeholders, collaborating with them to understand the business needs and objectives.

Key Accountabilities

Collects, organizes, and cleans data from various internal and external sources by identifying opportunities to automate data collection, cleaning and reporting processes for greater efficiency.

Provides consultative guidance to internal stakeholders and assists with identifying and scoping incoming analytics requests to working through analysis and proposing appropriate solutions.

Supports data management and database maintenance by ensuring data is stored securely and efficiently, making it accessible for future analysis. Writes and runs queries (using tools like SQL and PostgreSQL) to extract and manipulate data from databases for analysis.

Analyzes and processes large datasets to identify trends, patterns, and actionable insights using statistical tools and software (e.g., Excel, SQL, PostgreSQL, Python, R)

Creates reports, dashboards, executive presentations and visualizations to communicate findings effectively using visualization tools such as but not limited to Tableau and Power BI.

Collaborates with cross-functional teams to understand business needs and objectives of every department. Provides Business Leadership with insights, forecasts and analysis based on the data

Develops and maintains databases and data systems to ensure data accuracy and accessibility.

Performs data validation and quality checks to ensure data integrity by maintaining existing policies and creating standards, processes and controls over how data elements are setup, used, revised and maintained across the organization.

Presents data findings to stakeholders in a clear, understandable manner in support of planning and provides recommendations for business decisions based on data analysis and reports.

Keeps up with the latest trends, tools, and technologies in data analytics to continuously improve analysis techniques and outcomes. Maintains awareness of best practices, including processes and business intelligence tools, and finds opportunities for improvement of existing functionality. Liaises with technical stakeholders to support reporting tool enhancements and reporting solutions.

Performs complex various data analysis and reporting in support of labour relations strategies, including union related metrics such as overtime trends, pay and scheduling to inform collective bargaining and executive decision-making.

Qualifications

Education & Experience:

The competencies for this position would typically be acquired through a bachelor’s degree in data science, Statistics, Mathematics, Computer Science, or a related field plus 5 years of experience in an environment where logical/physical data modeling, data analysis techniques, data management and business analysis skills have been demonstrated.

Other Requirements

• Proficiency in data analysis tools such as Excel, SQL, PostgreSQL and data visualization platforms such as Tableau, PowerBI.
• Solid experience with statistical analysis and data processing software (Python, R, etc.).
• Strong analytical skills and the ability to work with large datasets.
• Excellent communication skills, with the ability to explain technical data to non-technical stakeholders.
• Strong problem-solving abilities with great attention to detail.
• Experience with machine learning algorithms or advanced statistical modeling.
• Advanced knowledge of data warehousing and business intelligence concepts.
• Experience with data visualization best practices and design principles.
• Proven ability to work independently and manage multiple projects simultaneously.
  
  

Other Information

Recruitment Process: An applicant will be required to demonstrate their suitability for this position by meeting the minimum level of qualifications and experience in order to be invited into the selection process. A standard interview format will be used including general, scenario and behavioural descriptive interview questions.

Work Schedule

37.5 hours per week.

Work Designation

Hybrid

This position offers the flexibility of working both on-site and home after the successful completion of the probationary period.

Rate of Pay

Grade: 06

Salary: $82,400 to $123,600 per annum

The Total Compensation Package includes Extended Health, Dental, Transit Pass, and enrollment in the Public Service Pension Plan. Enjoy a variety of health and wellness programs, including access to gym facilities. We offer a flexible benefits package with the option to elect additional vacation days.

Conditions of Employment

Applicant will be required to possess or have the ability to obtain and maintain enhanced security clearance.

How to Apply

Please click the 'Apply' button at the top right corner of the page or go to http://www.translink.ca/careers to apply for this position and view instructions on the process.

INSTRUCTIONS: Please save your (1) cover letter, and your (2) resume as one pdf document prior to uploading your application on-line.

Closing Date: July 16, 2025

Please note that only those short listed will be contacted.

Having trouble applying? Please view the System Requirements & FAQ's by going to http://www.translink.ca/careers.

Equal Employment Opportunity

Transit Police are committed to employment equity