Transit Data Analyst (MA I)

Edmonton

Edmonton

On-site

CAD 60,000 - 75,000

Full time

2 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

Are you passionate about using data to enhance public transit and connect communities? Edmonton Transit Service (ETS) is looking for a collaborative, detail-oriented Transit Data Analyst to join our team. In this role, you will help turn complex operational, spatial, and ridership information into intuitive tools and clear visual insights. Working alongside supportive peers and branch leaders, your work will directly inform service planning and operational decisions across our transit network. If you enjoy problem-solving with modern data tools and want to make a meaningful difference for Edmontonians, we welcome your application!

The Transit Data Analyst plays a key role within the ETS Transit Data Analytics Team by supporting data pipelines, automated reporting workflows, and interactive visualization tools. In this role, you will use modern database systems, scripting languages, and statistical analysis to transform multi-source transit data into reliable, actionable products. You will help maintain high data integrity, create self-serve reporting dashboards for internal teams, and provide analytical support for service planning initiatives. Working with directional guidance, you will collaborate with cross-functional partners to translate operational challenges into technical solutions. Your contributions will directly support evidence-based decisions, helping create an efficient, reliable, and accessible transit network for our community.

What will you do?
  • Maintain, optimize, and support automated ETL workflows by writing SQL and Python scripts to clean and integrate multi-source operational data across relational databases and cloud environments
  • Perform routine data audits to ensure data integrity, identify discrepancies, and apply established corrective workflows
  • Design and maintain interactive, self-serve dashboards and visual reports in Tableau (and other BI tools) to track ridership, schedule adherence, and other operational KPIs
  • Integrate geographic datasets and perform spatial analysis using GIS tools to support transit route planning and scheduling functions
  • Perform descriptive, diagnostic, and statistical benchmarking analyses to track transit performance, evaluate ridership trends, and measure the effectiveness of service adjustments in support of operational improvements
  • Support foundational data preparation, exploratory analysis, and prototyping to assist senior team members in developing statistical and predictive models
  • Work with central development teams to assist in testing and transitioning operational data workflows into production environments
  • Prepare data products, map visualizations, and research summaries for inclusion in City Council reports, executive briefings, and standardized external submissions (including government reporting, industry benchmarks, and public open data feeds)
  • Collaborate with internal business units to clarify operational reporting needs and guide staff on using self-serve dashboards and data tools
Qualifications
  • Bachelor’s degree in Data Analytics, Computer Science, Statistics, Transportation/Urban Planning, Engineering, or a related quantitative discipline
  • Minimum of two (2) years of practical experience in data analytics, with hands-on experience writing complex queries (SQL) on relational databases, developing automation scripts (Python), and turning raw datasets into structured products using visualization, mapping, and reporting tools
Assets
  • Demonstrated experience with public transit operational datasets (e.g., General Transit Feed Specification (GTFS), Automatic Passenger Counter (APC), or Automated Vehicle Location (AVL) data)
  • Experience working with cloud-based data environments or modern data warehouse architectures
  • Coursework or certification in GIS analysis, data engineering, or business intelligence platforms
Skills required for success
  • Strong knowledge of SQL for database extraction and joins, paired with Python scripting skills for workflow automation and data manipulation
  • Proficiency in creating interactive visual reports in Tableau, along with foundational spatial analysis skills using ESRI ArcGIS or FME
  • Applied understanding of descriptive statistics, diagnostic analysis, and performance metrics to evaluate operational trends
  • Strong technical troubleshooting abilities to identify pipeline issues, resolve script bugs, and validate data integrity
  • Effective communication skills to translate complex data outputs and performance metrics into clear, actionable summaries for diverse audiences
  • Strong organizational skills to manage daily project tasks independently while collaborating effectively and proactively seeking direction from senior analysts or supervisors on complex analytical challenges
  • Alignment to our Cultural Commitments and Leadership Competencies https://bit.ly/4brRrXm
  • Embracing a culture of equity, diversity, reconciliation and inclusion

The City of Edmonton values applicants with a diverse range of skills, experiences and competencies, and encourages you to apply. We strive to provide reasonable access and accommodations throughout the recruitment process. To request an accommodation, please contact employment@edmonton.ca. Learn more about our benefits https://bit.ly/COEbenefits

Up to 1 permanent full-time position

Hours of Work: 33.75 hours per week

Salary Range: $43.573 - $54.439 (hourly) $76,764.730 - $95,907.910 (Annually)

Edmonton rests in the heart of Treaty Six territory in Alberta and the homelands of the Metis Nation

Classification Title: Methods Analyst I

Posting Date: Nov 20, 2026

Closing Date: Dec 04, 2026 11:59:00 PM (ABT)

Number of Openings (up to): 1 - Permanent Full-time

Union: CSU 52

Department: City Operations

Work Location(s): 15th Floor Edmonton Tower, 10111 104 Avenue Edmonton T5J 0J4

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Operations Analyst (Methods Analyst I)
Operations Analyst (Methods Analyst I)

City of Edmonton • Edmonton

On-site
CAD 60,000 - 75,000
Application & Infrastructure Analyst I
Application & Infrastructure Analyst I

Edmonton • Edmonton

On-site
CAD 64,000 - 80,000
Strategic Planning Analyst (Animal Care and Park Rangers)
Strategic Planning Analyst (Animal Care and Park Rangers)

Culture Alberta • Edmonton

Hybrid
CAD 86,000 - 107,000
Data Analyst
Data Analyst

City of Edmonton • Edmonton

Hybrid
CAD 86,000 - 107,000
IT Analyst - Business Analyst
IT Analyst - Business Analyst

Culture Alberta • Edmonton

On-site
CAD 107,000 - 136,000
Work from home option (subject to sup 
Work from home option (subject to SUP)
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
Transit Data Analyst: Dashboards, GIS & ETL
Transit Data Analyst: Dashboards, GIS & ETL

Edmonton • Edmonton

On-site
CAD 60,000 - 75,000
Application & Infrastructure Analyst I - Quality Assurance Analyst
Application & Infrastructure Analyst I - Quality Assurance Analyst

Edmonton • Edmonton

On-site
CAD 67,000 - 85,000
Lead, Geospatial Platform Operations
Lead, Geospatial Platform Operations

City of Edmonton • Edmonton

On-site
CAD 104,000 - 133,000
Manager, Service Experience
Manager, Service Experience

Edmonton • Edmonton

Hybrid
CAD 124,000 - 155,000
Hybrid work arrangement
Municipal benefits