Ben Martin

Senior Data Analyst with over 25 years' experience in automation, reporting, and data migration. Proven track record in streamlining complex data processes, developing robust ETL pipelines, and delivering actionable insights through Power BI, SQL, and Python. Adept at driving digital transformation, improving data governance, and leading stakeholder engagement for high-profile government and commercial programmes.

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

BSc (Hons) in Computer Science – University of Leicester

Postgraduate Diploma in SQL/Oracle – Institute of Commercial Management