Patrick Dunn
Ecommerce Data Analyst @Ocado Retail
Signup · Get unlimited contacts
WORK HISTORY
Ecommerce Data Analyst @Ocado Retail
Hatfield, GB
Centralised and maintained Supplier Funded Media (SFM) reports using Google Looker and BigQuery SQL to provide a live, accurate feed of campaign data across key performance metrics.* Developed and implemented a Google Apps Script-based inventory control system, delivering real-time stock monitoring and optimization that improved operational efficiency and reduced campaign failure by 18%.* Leveraged Python and Google Looker to produce both single-use and ongoing data visualisations to track campaign performance and support strategic decision-making.* Revamped the \'star reviewer\' process after identifying a need for bespoke targeting. This included designing a novel RFQ (Recency, Frequency, Quality) segmentation model using SQL (BigQuery) where the Quality score was ethically engineered to reward review utility and depth, not sentiment, resulting in an over 40% uplift in product reviews per campaign and a cost reduction of over £10 per review for suppliers.* Automated SFM reporting workflows using Make and Monday.com, enabling streamlined updates on site readiness, media asset status, and editing stages for timely stakeholder reporting.* Trained staff members on BigQuery basics and best practices for data handling, fostering a data-driven culture within the team.
EDUCATION
The University of Salford
Popular Music and Recording
freeCodeCamp
Javascript Fundamentals
ABOUT PATRICK DUNN
Currently serving as an Ecommerce Data Analyst at Ocado Retail, contributing to a data-driven culture within the SFM team. Focused on supply chain alignment for gifting campaigns and process automation through tools like Google Apps Script and Make.com. Recent initiatives include streamlining reporting workflows and enhancing workplace engagement. Northcoders Software Engineering Bootcamp graduate with hands-on experience in full-stack development, including React.js and API creation. Passionate about leveraging data, technology, and process improvement to drive operational efficiency and achieve business goals.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.