
Lydia Mulligan
Data Analyst
Salary / Daily rate
London, UK
Freelance, open to permanent contract
Skills
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.
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
Microsoft Power BI Data Analyst
Issued: Jan 2025
Google Data Analytics
Issued: Apr 2024
Leadership Transitions Course
Issued: Aug 2021