Time since we first saw it
Day 1
Early. Similar jobs usually come down between day 5 and day 43.
From 16,008 similar postings that came down. Coming down is not always a hire.
Location not stated
Actively hiring, first seen by us 1 day agoHours of Work: 33.75 hours per week Salary Range: $43.573 - $54.439 (hourly) $76,764.730 - $95,907.910 (Annually) Recruitment Consultant: AG/SORead the full posting
Maintain and optimize automated ETL workflows using SQL and Python
Run routine data audits and fix discrepancies using established workflows
Design and maintain self-serve Tableau dashboards tracking ridership and schedule adherence
Integrate geographic datasets and perform GIS spatial analysis for route planning
Benchmark transit performance and evaluate ridership trends and service changes
Maintain, optimize, and support automated ETL workflows by writing SQL and Python scripts
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
- Collaborate with internal business units to clarify operational reporting needs and guide staff on using self-serve dashboards and data tools - 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
Actively hiringFirst seen by us 1 day ago, still listed, and not a repost of an earlier posting.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Day 1
Early. Similar jobs usually come down between day 5 and day 43.
From 16,008 similar postings that came down. Coming down is not always a hire.
2 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Hiring recordAdd your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
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
- 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:
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
- 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
- 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
Complete your application on edmonton.taleo.net. The employer’s form will show what is required.
Already applied? Track this application
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?
Assets:
Skills required for success:
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)
Recruitment Consultant: AG/SO
Edmonton rests in the heart of Treaty Six territory in Alberta and the homelands of the Metis Nation
Connect with us!
New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
Hours of Work: 33.75 hours per week Salary Range: $43.573 - $54.439 (hourly) $76,764.730 - $95,907.910 (Annually) Recruitment Consultant: AG/SO
Location not supplied.
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.