Data Analyst - AFS Group
(2024-12)
Results-driven Senior Data Analyst with experience delivering high-quality, timely insights across multiple projects. Proven ability to translate complex data into actionable recommendations and impactful dashboards that support senior leadership in strategic, commercial decision-making.
- Designing an end-to-end data pipeline leveraging live AWS APIs, with data stored in cloud storage and consumed by Power BI dashboards and advanced Excel automated reporting. Building Power Automate workflows to orchestrate and automate the full ETL process.
- Collaborated closely with the COO and company owners to establish reporting priorities and define decision-critical metrics. Worked across Fleet, Finance, Workshop, and Operations teams to translate business requirements into actionable insights.
- Worked closely with the executive team to define KPIs for leadership and their respective stakeholders/managers across the organisation. Once KPIs were established, identified the key data sources and required fields to support them. Where data was not fully available via AWS, designed alternative data pipelines and cloud storage solutions to ensure completeness.
- Developed advanced DAX measures to clearly define KPIs and built intuitive, story-driven dashboards that enabled non-technical stakeholders to easily interpret insights.
- Currently utilising multiple programming languages, including R for weekly business reporting and Python for weekly driver bonus scorecards. Using QlikView to extract and integrate external data sources into internal systems. Leveraging Power BI, SharePoint, the Power Platform, and AWS APIs (including Amazon services) to source, manage, and analyse data.
- Involved in numerous projects focused on identifying business issues and opportunities for improvement. Developed high-level reports and dashboards for executives and leadership teams, providing actionable insights to support strategic decision-making, whether to capitalise on new opportunities or address areas requiring improvement.
- Worked independently as the lead Data Analyst, supporting the COO and owners, training non-technical teams, and fostering collaboration through forums focused on Power BI and data-driven storytelling.
Commercial Data Analyst - TRTL
(2024-01 - 2024-12)
Optimising advertising strategies and sales performance by leveraging data-driven insights. Analysing advertising data, identifying trends in sales data, and recommending improvements to trtls current business processes. Achieved greater return on advertising spend and enhancing overall business efficiency.
- Led the development of scalable data models and advanced SQL pipelines (CTEs, complex logic) to transform raw data into actionable commercial insights
- Owned Power BI reporting suite, delivering executive dashboards that improved reporting efficiency by 40% and enabled real-time tracking of revenue and KPIs
- Partnered with senior stakeholders and executive teams to translate complex analysis into clear, strategic recommendations
- Drove commercial decision-making through advanced analytics, including regression modelling, forecasting, and performance trend analysis
- Defined and optimised KPIs across marketing and sales, increasing performance visibility and driving measurable improvements in campaign ROI (15–30%)
- Delivered in-depth customer and sales analysis, uncovering segmentation and behavioural insights that increased conversion rates by 5–15%
- Improved data processes and workflows, increasing efficiency, data accuracy, and reporting reliability across the business.
Finance Data Analyst/Finance Business Partner - Bruichladdich Distillary
(2023-01 - 2024-01)
Providing easily accessible analysis and market insight within a quickly changing environment. Interacting with Microsofts Power BI to generate, operate, and maintain BI applications that serve to provide the company with actionable business insights.
- Produce and deliver presentations summarising monthly business performance for departmental and executive review.
- Providing analysis and insight to the Budget & MTP processes ensuring KPIs are respected within market inputs.
- Quarterly pricing audit and analysis with markets to inform pricing strategy.
- Collating and analyse data on promotional frequency and pricing impact with markets.
- Working and using Oracle Essbase database, MDX Statements (SQL), SAP BusinessObjects, SSIS, SSMS and DAX Studio.
- Developed Shopify integration via API enabling easy Shopify data export to build further interactive reports to analyse inventory, customers and orders.
Data Analyst/Power BI Developer - Robertson Group
(2021-07 - 2022-12)
Working with all stakeholders within the Robertson Facilities Management business and external customers to support the Robertson FM Digital Strategy of a data rich working environment.
- Scope, research and propose new methods of working using automation and reporting software
- Working and using (Advanced level), Power Query, Power BI, Crystal Reports, Power Automate (flow) and Power Apps.
- Working with Azure SQL, SSIS and SSMS, M365 Sharepoint Online (system administration).
- Working with works management system/ticketing system to help with Data Warehouse queries and IT queries.
- Extract, Transform and load (ETL) interrogating multiple data sources to give visually immersive and interactive insights.
Data Analyst/Sales Operation Analyst - McCurrach
(2018-07 - 2021-07)
Working with global brands such as PepsiCo, Nestle and Microsoft by helping them deliver their key sales and marketing strategies.
- Lead analysis of consumer insights and sales data, delivering presentations and reports while translating findings into actionable recommendations to support decision-making.
- Analyse data and use this analysis to create compelling evidence-based and actionable data stories to share with stakeholders to drive decisions.
- Led a project to improve the analyst handover process by setting up SharePoint and creating detailed step-by-step guidance for report preparation and insight documentation.
- Analysing data from Azure and in-house data warehouse/queries to identify data integration for PepsiCo and have confidence in the data.
