Data Analyst

Responsibilities

• Analyze AFC transaction data (smart cards, mobile tickets, contactless payments) to identify trends in ridership, revenue, and passenger flow.
• Develop dashboards and reports tracking KPIs such as ridership, fare evasion, peak usage, and revenue leakage.
• Perform data validation and quality checks to ensure integrity of AFC datasets.
• Provide insights into passenger travel patterns, route performance, and network utilization.
• Support planning teams with demand forecasting and capacity planning.
• Analyze multimodal integration (bus, metro, tram) using AFC data.
• Build predictive models for ridership forecasting, fare optimization, and demand analysis.
• Apply statistical techniques and machine learning where applicable.
• Conduct scenario analysis to support policy or fare structure changes.
• Collaborate with operations, finance, and planning teams to translate data into actionable insights.
• Present findings and recommendations to senior stakeholders and leadership.
• Support audits and regulatory reporting requirements.

Requirements

• Bachelor’s degree in Data Science, Statistics, Computer Science, Transportation Engineering, or related field.
• Master’s degree preferred.
• 10+ years of experience in data analysis, ideally within public transportation or mobility sectors.
• Proven experience working with AFC systems (e.g., Cubic, Thales, Scheidt & Bachmann, etc.).
• Strong proficiency in SQL (advanced level), Python or R for data analysis, and data visualization tools (Power BI, Tableau).
• Experience with Big data platforms (e.g., Hadoop, Spark), GIS tools (ArcGIS/QGIS) for spatial analysis, ETL tools and data warehousing concepts.
• Strong understanding of public transportation operations, fare structures and ticketing systems, transit KPIs and performance metrics.
• Strong analytical and problem‑solving skills.
• Excellent communication and storytelling with data.
• Ability to work cross‑functionally in complex environments.