Programme & Reporting Analyst
CurrentResponsibilities- Developing and maintaining a suite of commercial and procurement dashboards in Tableau, adjusting visualisations to support the changing needs of the business.- Extracting, blending and cleaning data from multiple data sources to report on KPIs for the Department for Transport.- Managing the production of a monthly department report, collating commentary provided by stakeholders and challenging any irregularities. - Providing regular weekly and monthly reports, along with one-off reports when required.- Providing ad hoc support to other departments to analyse their data or give technical assistance. Key achievements- Designed and built a cohesive series of interactive dashboards using Tableau, to allow senior management to interrogate commercial information, review flagged items, and monitor KPIs.- Restructured 4 million lines of data to rapidly produce scope documents for 750 key assets.- Worked with senior figures within the National College of High Speed Rail to set up their company-wide KPI reports, ensuring they fit with their corporate identity and had a robust update process.