Senior Data Insight Analyst - SQL

Do you have a love of reading and a background in data analysis with a commercial mindset? This company sources over 500,000 used books a week with the mission of stopping them going to landfill, and giving someone else the opportunity to read them at a lower price point than a brand spanking new version. They’re looking to add two Data Insight Analysts to their existing data team of 4, with further plans to grow in the near future. They see this team as the heartbeat of their business – presently they turn over £13 million from their website with the aim to hit £50 million by mid-2027.

It’s focused on two distinct but related brands; the first is a B2C retail brand which sells books and the second a re-commerce brand, which recycles used books and allows consumers to redeem them for cash or vouchers. It’s worth emphasising that this is what you’d describe as a ‘Commercial Data Insights Analyst’ role. You’ll be personalising the experience on their website so it’s useful and relevant to all users who visit – think creating a smooth customer journey by creating recommendation engines to upsell and cross sell products.

Collaborating with their data and tech teams to manage the pipeline of data across their eCommerce properties using tags and scripts from GTM/GA4 into their Big Query data warehouse. Combine this with other streams of data from their MarTech stack (ETL) to produce insight and initiatives that they can leverage to produce better and richer experiences for their customers through segmentation and personalisation. Understand the channels of customer acquisition and help calculate the ROI/attribution of each channel to desired outcomes. Experience in working with data coming from Google Analytics, Google Ads, Google shopping, Meta, Bing etc.

Create data driven dashboards which help to track the impact of activities so that teams can use these tools in a “self-service” data led capacity. Ideally you’ll have a background in eCommerce as well as having a commercial mindset, which is a massive bonus. A strong track record of working with GTM/GA4 to set up event tagging is appreciated, with you ideally also being familiar with the auditing process to verify the efficacy of the data being captured. Naturally you’ll be comfortable working with SQL and ideally BigQuery (though a similar data warehousing technology is fine) with PowerBI experience being a big bonus, though by no means essential.

Bonus points if you’ve worked with any of the following:

• Experienced in the extraction and manipulation of large data sets.
• Advanced Excel skills, as well as macro and VBA knowledge.
• Python experience.

They do like to get together in the office Tuesday to Thursday so you’ll need to be comfortable doing this.