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 process
• - Flexible working with fully remote and hybrid working options - early bird or night owl? No problem - our flexible working policy helps you work the hours that suits you best
• - 33 days annual leave per year, pro rata. You decide which public holidays to recognise. After 2 years of employment, your annual leave entitlement will accrue year on year up to 38 days annual leave
• - An additional day of annual leave, a Me Day, to take time for yourself
• - Charity day to volunteer and support a registered charity of your choice
• - Westfield Health (including Health Club discount and Westfield Rewards discount and cashback)
• - Learning and Development opportunities, with opportunities for internal mobility across various departments / areas of the business
• - 4 x annual salary death in service life assurance
• - Enhanced pension after long service
• - Enhanced parental and adoption leave after long service