AFC Data Analyst
Atkins Realis Group
10–12 years of experience
Job DescriptionOverview
We are seeking an experienced AFC Data Analyst to support data-driven decision-making within public transportation systems. The ideal candidate will have deep expertise in analyzing fare collection data, passenger behavior, revenue performance, and system efficiency, with a strong understanding of transportation operations.
Your role
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.
About you
Education
Experience
Technical Skills
Strong proficiency in:
SQL (advanced level).
Python or R for data analysis.
Data visualization tools (Power BI, Tableau).
Experience with:
Big data platforms (e.g., Hadoop, Spark) is a plus.
GIS tools (ArcGIS/QGIS) for spatial analysis.
ETL tools and data warehousing concepts.
Domain Knowledge
Soft Skills
Preferred Qualifications
Rewards & benefits
Explore the rewards and benefits that help you thrive at every stage of your life and your career.
This includes: