Transit Data Analyst: Dashboards, GIS & ETL

Edmonton

Edmonton

On-site

CAD 60,000 - 75,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

City of Edmonton’s Edmonton Transit Service is hiring a Transit Data Analyst to turn complex transit data into actionable insights. You will build ETL workflows, develop self-serve dashboards, and perform spatial analyses to support route planning and service improvements.

You will collaborate with cross-functional teams, maintain data integrity, and contribute to City reporting and open data initiatives. This role combines analytics with public impact in Edmonton.

Qualifications

  • Bachelor’s degree in Data Analytics, Computer Science, Statistics, Transportation/Urban Planning, Engineering, or a related quantitative discipline
  • 2+ years of practical experience in data analytics with SQL, Python, and visualization/reporting tools

Responsibilities

  • Maintain, optimize, and support automated ETL workflows using SQL and Python
  • Design and maintain interactive dashboards in Tableau to track KPIs like ridership and schedule adherence
  • Perform spatial analysis using GIS tools to support route planning and scheduling
  • Provide analytical support for service planning and generate data products for reports and submissions
  • Collaborate with cross-functional partners to translate operational challenges into technical solutions

Skills

SQL
Python
Tableau
GIS

Education

Bachelor’s degree in Data Analytics or related field

Tools

Tableau
ArcGIS
FME
Cloud data warehouse

Job description

City of Edmonton’s Edmonton Transit Service is hiring a Transit Data Analyst to turn complex transit data into actionable insights. You will build ETL workflows, develop self-serve dashboards, and perform spatial analyses to support route planning and service improvements.

You will collaborate with cross-functional teams, maintain data integrity, and contribute to City reporting and open data initiatives. This role combines analytics with public impact in Edmonton.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Transit Data Analyst (MA I)
Transit Data Analyst (MA I)

Edmonton • Edmonton

On-site
CAD 60,000 - 75,000
Data Insights Analyst — Dashboards, SQL & ETL
Data Insights Analyst — Dashboards, SQL & ETL

Triunity Software • Edmonton

On-site
CAD 55,000 - 85,000
Bonus based on performance
Health insurance
Training & development
Data Analyst
Data Analyst

City of Edmonton • Edmonton

Hybrid
CAD 86,000 - 107,000
On-Demand Transit Data Analyst
On-Demand Transit Data Analyst

RideCo Inc. • Southwestern Ontario

Hybrid
CAD 80,000 - 90,000
Performance-based bonus
Stock options
Flex-time work schedules
+3
Operations Analyst (Methods Analyst I)
Operations Analyst (Methods Analyst I)

City of Edmonton • Edmonton

On-site
CAD 60,000 - 75,000
Hybrid Data Scientist - Transit Analytics
Hybrid Data Scientist - Transit Analytics

TTC (Toronto Transit Commission) • Toronto

Hybrid
CAD 116,000 - 145,000
Defined pension plan
Health, dental, vision
Professional development opportunities
+1
Hybrid GIS Lead for Emergency Response & Modern Mapping
Hybrid GIS Lead for Emergency Response & Modern Mapping

Edmonton • Edmonton

Hybrid
CAD 107,000 - 136,000
Hybrid work arrangement
Data Analyst - FTT
Data Analyst - FTT

TransLink • British Columbia

Hybrid
CAD 92,000 - 110,000
Extended Health
Transit Pass
Public Service Pension Plan
+2
Strategic BI Analyst — Data Strategy & Dashboards
Strategic BI Analyst — Data Strategy & Dashboards

Pathlion • Edmonton

Remote
CAD 65,000 - 90,000
Transit Revenue Contract Coordinator Driving, warehouse and logistics : City of Edmonton · Edmonton · $38.01–$47.56 an hour Open until filled
Transit Revenue Contract Coordinator Driving, warehouse and logistics : City of Edmonton · Edmonton · $38.01–$47.56 an hour Open until filled

Alberta • Edmonton

On-site
CAD 52,000 - 66,000