Data Analyst at Astellas Pharmaceuticals (2025-09 – Present)
Automation of HR ticketing system analytics and AI assistant roll out.
- Developed automated ETL pipelines to consolidate disparate systems data
- Automated reporting requirements and created dashboards in Power BI and Qlik Sense
- Extracted and transformed datasets using Databricks to conduct deep-dive investigations
- Produced training datasets and analysed outputs/effectiveness of new AI assistant
- Updated governance documentation and standardised data dictionaries and taxonomies to ensure AI guardrails
Data Migration Analyst at Certitude (2025-01 – 2025-06)
Charity payroll and HR system data migration project.
- Collaborated with stakeholders to define data migration requirements and validation criteria
- Mapping data between legacy and new systems
- Identifying and resolving data inconsistencies, gaps, and quality issues pre and post migration
- Producing data flow diagrams and mapping documentation
- User acceptance testing (UAT)
- Report and dashboard creation using Power BI
HR Reporting Analyst at DCMS (2024-08 – 2024-11)
Central government HR reporting and dashboard project, pay modelling and business planning.
- Full audit of the HR reporting suite to determine areas of improvement
- Creation of data flow diagrams and data mapping documentation
- Reduced manual processing and refreshing of data in Google sheets using BigQuery
- Developed dashboards in Excel and Power BI, utilising Power Query and DAX
- Produced detailed pay forecasting tools, as well as monthly, quarterly, and ad hoc HR reports
Data Analyst at Marine Management Organisation (2023-10 – 2024-03)
Large scale government digitisation and IT improvement project.
- Conducted multi-project requirement gathering whilst engaging with senior stakeholders
- Created dashboards using Excel and Power BI, providing actionable insights for decision-makers
- Mapped data processes using Mural to ensure data accuracy and consistency
- Responsible for wireframing web pages and application forms in Balsamiq
- Performed in-depth web analysis using Google Analytics
HR Reporting Analyst at DCMS (2022-11 – 2023-10)
Government data and dashboard migration project.
- Gathered comprehensive data reporting requirements to meet the needs of diverse stakeholders
- Developed dashboards in Looker Data Studio, enhancing data visualisation and reporting capabilities
- Produced detailed pay forecasting tools, as well as monthly, quarterly, and ad hoc HR reports
- Mapped complex data processes to streamline operations
Data Analyst at BEIS (2021-11 – 2022-03)
Government industrial decarbonisation project - reporting on new and existing data to better understand industry clusters, emission types and methods for reduction.
- Conducted research into available industry data sources to identify relevant information for analysis
- Created SQL scripts for data quality, cleansing and migration
- Established master data records in SQL Server to maintain data consistency and accuracy
- Developed detailed dashboards using Power BI and R Shiny
MI Reporting Analyst at DEFRA (2020-08 – 2021-10)
Brexit IT programme – Reporting on uptake, usage, and functionality of new import/export website.
- Identified data reporting requirements and KPIs through extensive stakeholder collaboration
- Created comprehensive reports and dashboards using Excel, Power BI, and Tableau
- Utilised Python, Excel, and SQL to perform complex analyses, data mapping and migration
Consultant Geospatial Data Analyst at ARUP (2020-01 – 2020-07)
Continuation of previous contract.
- Identified data requirements and KPIs through detailed stakeholder engagement
- Planned and implemented asset data capture and storage methods to ensure data integrity
- Produced detailed dashboards using Tableau and Excel for management information
- Conducted ETL and data cleansing for geospatial data layers, ensuring high-quality data
- Produced documentation and training material for future project roll out
Data Analyst at DEFRA (2019-04 – 2019-11)
Central government HR Brexit staff contingency planning.
- Created several tools for the onboarding and offboarding of staff, using Excel VBA
- Developed dashboards for MI/BI - Excel, Python, Power BI
- Designed databases and carried out data migration
- Liaised with multiple departments in creating the processes for collation and cleansing of data
Consultant Geospatial Data Analyst at ARUP (2018-12 – 2019-04)
Creation of a test/trial project to identify and locate assets on the UK rail network.
- Liaised with client/stakeholders to identify data requirements and KPIs
- Planned and implemented capture methods and storage for data
- Executed geospatial analysis using ArcGIS to map infrastructure assets
Program Developer & Analyst at Network Rail (2012-07 – 2018-12)
High profile asset data projects. A complete overhaul of legacy databases and decision support tools.
- Utilised SQL, Python and Excel for data interrogation and identify areas for improvement
- Designed data capture methods in collaboration with engineers to enhance data accuracy
- Database administration (DBA) for a range of safety critical support tools and databases
- Carried out data mapping and data migration from legacy systems to newly implemented databases
Performance, Quality & IT Analyst / Data Analyst / Data Administrator / Systems Administrator / Sales Coordinator at Various (2001-01 – 2012-07)
Early Professional Experience
- Performance, Quality & IT Analyst, Catch22
- Systems Administrator, North Herts College
