Data Analyst

Overview

Data Analysis & Reporting

• 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.

Transportation Insights

• 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.

Advanced Analytics

• 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.

System & Data Management

• Work with AFC system vendors and internal IT teams to manage data pipelines and integrations.
• Extract, transform, and load (ETL) large datasets from AFC systems and data warehouses.
• Ensure compliance with data governance and security standards.

Stakeholder Collaboration

• 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.

Education & Experience

• 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).

Technical Skills

• Strong proficiency in advanced-level SQL.
• Python or R for data analysis.
• Data visualization tools (Power BI, Tableau).
• Big data platforms (e.g., Hadoop, Spark) are a plus.
• GIS tools (ArcGIS/QGIS) for spatial analysis.
• ETL tools and data warehousing concepts.

Domain Knowledge & Soft Skills

• Strong understanding of public transportation operations, fare structures and ticketing systems, and 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.

Preferred Qualifications

• Experience in smart mobility or digital ticketing transformation projects.
• Knowledge of contactless EMV payment systems.
• Familiarity with real-time data analytics in transportation.
• Experience in large-scale metro, rail, or bus network environments.