Lydia Mulligan

Data Analyst

Salary / Daily rate

London, UK

Freelance, open to permanent contract

Skills

PythonSQL QueriesPower BIRCData Analysis

About me

Intro

Experienced in building robust SQL databases, developing advanced Power BI dashboards, and delivering business intelligence solutions. Analytical and innovative problem solver with excellent communication and interpersonal skills and a passion for learning. Confident leader with background upholding high standards in high pressure settings.

Links

Work experience

Data Analyst

MX Construction

Jul 2025 - Present

1 year 4 months

Lead the transformation of legacy paper-based reporting into a structured, data-driven reporting environment aligned to operational and commercial objectives. – Designed, built and maintained advanced Power BI dashboards delivering KPIs across Health & Safety, quality assurance, and project management performance. – Engineered structured SQL databases to centralise asset, procurement and workforce data, improving data integrity and accessibility. – Developed data pipelines using Python, SQL and Excel to reduce manual reporting time by half. – Conducted sensitivity analysis on materials and supply chain data, supporting cost control and procurement decision-making for upcoming projects. – Built a competency framework for site operatives. – Designed and implemented data capture frameworks (surveys, checklists) to improve reporting quality and enable segmentation analysis. – Implemented preventive and detective data governance controls to ensure GDPR compliance across stored data. – Played a key role in achieving Construction Line Platinum Audit through implementing controlled data structures and clear documentation

Shift Manager

McDonalds Bath

Aug 2021 - Sep 2022

1 year 2 months

Promoted from crew member to Shift Manager 2022 Attained Employee of the month, Employee of the Quarter – Manage a team of 120 to produce high levels of customer satisfaction and achieve production targets set for the store. – Skilled in working under pressure and adapting to new situations and challenges quickly. – Established excellent work relationships and provided great customer service. – Optimised store performance by arranging crew on shift to reflect their strengths. – Financial responsibility of handling money floats and counting the safe each shift. – Health and Safety management during food production. – Organising and managing team training on service standards and food hygiene.


Education

University of York

Master of Science, Fusion Energy

2022 - 2023

11 months

– Completed several computational projects in Python. – Studied Statistical Methods in Data Analysis as a module.

University of Bath

Bachelor of Science, Physics with Astrophysics

2017 - 2020

2 years 11 months

Completed one-year computational research project: "A Hunt for Supermassive Black Holes in the Southern Hemisphere." – Gained experience at analysing and processing large data sets from sky surveys, SDSS and SkyMapper. – Gained proficiency in Python and TOPCAT. – Collaborated well with research partner and supervisor. – Independently researched into topics related to project. – Produced a Python code that creates a subset from SkyMapper of potential quasars and their redshifts using a confusion matrix. – Completed smaller coding projects in Python, C and Matlab over three years.

Portora Royal School

A level

2015 - 2017

1 year 11 months

– Further Mathematics B – Mathematics A* – Physics A


Licenses & certifications

Admin Certification Series

Issued: Jul 2025

Certified by Procore

Microsoft Power BI Data Analyst

Issued: Jan 2025

Certified by Coursera online

Google Data Analytics

Issued: Apr 2024

Certified by Coursera online

Leadership Transitions Course

Issued: Aug 2021

Certified by McDonald's University London

The best place to find your next move

© 2026. All Rights Reserved.