Assistant Skills Data Analyst

Role purpose

Key accountabilities

• Produce accurate, consistent training data to support informed decisions and regulatory compliance.
• Gather and document data requirements with OTSD, operational teams and senior management.
• Investigate data quality issues through validation, root-cause analysis and process improvement.
• Maintain and enhance databases and systems for training-performance tracking and reporting.
• Develop reports and dashboards that show training performance, competence and compliance.
• Track training KPIs, identify patterns and contribute insight to improve training and operational outcomes.
• Explain reports and data outputs to stakeholders and support effective use of information.
• Support IT and data teams with system improvements and identify opportunities to automate and simplify processes.
• Analyse complex datasets for trends, anomalies, risks and opportunities; translate business requirements into reports, data models and analytical outputs.

Knowledge and experience

• Understanding of data analysis principles, especially in safety-critical or operational contexts.
• Experience with data, reporting and business intelligence is relevant to the role.
• Advanced Excel skills, including formulas, lookups, data manipulation and pivot tables.
• Experience creating reports, dashboards or analytical outputs with Power BI or similar tools.
• Understanding of data governance, security, compliance, data quality and access control principles.
• Understanding of role-based access controls, including SharePoint membership, Power BI RBAC and Power App groups.
• Familiarity with TfL operational and training frameworks is desirable.
• Curiosity and a proactive approach to learning new systems, processes and technologies.

Tools and working approach

• The role uses Microsoft tools including Excel, Power BI, SharePoint and Power Platform applications.
• The successful candidate will investigate anomalies, solve problems and work with stakeholders to turn business challenges into practical data solutions.

Location and work arrangement

• The role is based at Palestra, Southwark, with a hybrid working arrangement.
• Regular travel across the network is required.

Employment and salary

• The contract is permanent.
• The salary is listed as £25,500–£35,500.