Responsibilities

• Use SQL to query and extract large datasets from our data warehouse, including web traffic, rankings, and crawl data.
• Utilise Python (using libraries like Pandas/Polars, NumPy, Matplotlib) to clean, analyse, and visualise data to identify performance trends and opportunities.
• Own the design and maintenance of dashboards and reports in tools like Google Data Studio or Tableau to monitor key SEO metrics.
• Analyse SERP (Search Engine Results Page) landscapes, competitor performance, and other forms of search data to inform content and technical SEO strategy.
• Collaborate with the wider teams to provide data-driven recommendations.
• Design and run SEO tests and other experiments, analysing the results to prove the effectiveness of our SEO initiatives.
• Communicate complex findings in a clear and concise manner to both technical and non-technical stakeholders.

Requirements

• SQL: You are comfortable writing queries to join, filter, and aggregate data from multiple tables.
• Demonstrable SEO experience: a strong track record in SEO, with a solid grasp of technical SEO, on-page/content, ranking factors, and how search engines crawl and index at scale.
• Analytical tooling: working knowledge of GA4, Google Search Console, and at least one enterprise crawler or SEO platform (e.g. Botify, Sitebulb, Ahrefs, Semrush).Python for data analysis: You have practical experience using Python for data manipulation and analysis.
• Data visualisation: experience building reporting in tools like Google Data Studio, Tableau, or Power BI.
• A strong analytical and problem-solving mindset: You can break down complex questions, form a hypothesis, and use data to find the answer.
• Clear communication skills: You can articulate your findings and the story behind the data.
• A proactive attitude and a desire to learn and develop new skills.

Preferred

• Experience working with APIs to extract and combine data from multiple SEO and analytics sources.
• Experience with BigQuery or another cloud data warehouse.
• Experience working with large websites (1m+ pages)
• A broader interest in digital marketing beyond SEO

Benefits

• A friendly, welcoming and supportive culture. We believe work should be fun and always put people before the process
• Diversity, inclusion and belonging - our Employee Network Program includes working groups for LGBTQ+, People of Colour, Disabilities (visible and invisible), Women in Tech and Working Parents.
• From day 1 - Westfield Health, 33 annual leave days per year (pro-rata) inclusive bank holidays, a "Me" day each year, a charity day each year and Twinkl subscriptions
• Quarterly company awards programme
• Seasonal events
• Referral scheme
• Company sick pay after 3 months of service
• After probation - cycle-to-work scheme
• Long-term service reward - Life insurance, enhanced pension contribution, enhanced maternity pay, enhanced adoption pay and enhanced paternity pay, long service award, long service annual leave