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 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. Nice to have - 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