Research and Data Analyst (MAII) (ID: 55859)

City of Edmonton; Edmonton; On-site; CAD 91,000 - 115,000; Full time

Benefits offered by this job

Open data initiatives

Job summary

The City of Edmonton is seeking a Data Analytics Specialist to guide strategic decisions for the Edmonton Transit Service. You will lead data engineering, automation, and predictive modeling to transform operational data into insights for leadership and operations.

You will work with cross‑functional teams to deliver robust data products, dashboards, and reports, supporting grant programs, benchmarking, and executive decision‑making while upholding data quality and open data initiatives.

Qualifications

• Bachelor's degree in Computer Science, Applied Statistics, OR Management Information Systems
• Minimum of four (4) years of directly related experience in advanced analytics, machine learning, statistical analysis, and data visualization

Responsibilities

• Lead end-to-end ETL processes from raw data to actionable insights
• Write SQL and Python scripts to build automated data pipelines and predictive models
• Design interactive dashboards and reports using Tableau and other tools
• Analyze transit data to identify trends and optimize operations
• Develop predictive and behavioral models using supervised/unsupervised learning
• Collaborate with IT to productionize analytical models
• Prepare data briefs and support for Council/exec reports
• Ensure data quality across systems and support open data initiatives

Job description

Closing Date: Aug 27, 2026 11:59:00 PM (MDT)

Driven by data and passionate about shaping the future of public transit? Edmonton Transit Service (ETS) is seeking a skilled and innovative Data Analytics Specialist to help guide strategic decisions across our transit network! In this role, you will lead complex analytical projects, build robust data pipelines, and craft dynamic dashboards that directly inform leadership and operational strategies. You will work closely with collaborators across the organization to uncover actionable insights, streamline processes, and drive continuous improvement. If you thrive on converting complex, large-scale datasets into smart operational solutions, this is your opportunity to make a tangible impact on our city's public transit system.

The Data Analytics Specialist performs advanced professional analytics to support transit planning, ridership, and operational efficiency across ETS. This position leads data engineering, automation, and predictive modeling efforts to convert raw operational data into actionable insights for branch leadership. Responsible for developing custom ETL workflows, machine learning models, and interactive visualization tools, the role directly supports data-driven decision-making and strategic planning. Additionally, this role manages key analytical reporting for grant programs, industry benchmarking, and corporate decision-making. Operating with a high degree of independence, the specialist addresses complex operational challenges where established solutions may not yet exist.

What will you do?

• Lead the end-to-end Extract, Transform, and Load (ETL) processes from raw data to actionable business insights
• Write custom scripts in SQL and Python to build automated data pipelines and predictive models
• Design and build interactive dashboards and reports using Tableau and other visualization tools to track operational KPIs
• Analyze complex transit data—including ridership, on-time performance, and schedule adherence—to identify operational trends and recommend efficiency improvements
• Develop predictive, statistical, and behavioral models using supervised and unsupervised machine learning techniques
• Collaborate with IT teams to transition prototype analytical models into production-level solutions
• Prepare data products, briefings, and technical research support for Council reports and executive presentations
• Ensure data integrity and quality standards across multiple transit data systems while advancing open data initiatives

Qualifications:

• University Degree in Computer Science, Applied Statistics, Operations Research/Management Science, or Management Information Systems
• Minimum of four (4) years of directly related experience in advanced analytics, machine learning, statistical analysis, and data visualization

Assets:

• Master’s Degree in a related quantitative or technical field
• Experience in data warehouse management, cloud data services, machine learning, and process automation
• Hands‑on experience with Geographical Information Systems (GIS) tools like ESRI ArcGIS or FME for spatial data analysis

Skills required for success:

• Advanced proficiency in relational databases (Oracle, MS SQL Server) and cloud data platforms (e.g., BigQuery, Snowflake, Databricks)
• Strong technical skills in Python, SQL, KNIME, R, Tableau, and Google Applications
• Proven capability to improve workflows, automate manual processes, and build self‑serve analytics tools
• Strong project management skills with the ability to balance competing priorities under tight deadlines
• Excellent written and verbal communication skills, including the ability to translate complex data into clear insights for leadership
• Strong critical thinking, problem‑solving, and consensus‑building capabilities
• 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 [e-mail]. 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: $51.611 - $65.218 (hourly) $90,925.680 - $114,897.810 (Annually)

Recruitment Consultant: AG/SO

Edmonton rests in the heart of Treaty Six territory in Alberta and the homelands of the Métis Nation