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