Description du poste
**Job Number**
==============
: 56470
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 n