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, NumPy, Matplotlib) to clean, analyse, and visualise data to identify performance trends and opportunities. - Develop and maintain dashboards and reports in tools like Google Looker 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. - Assist in running 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. - Python for data analysis: You have practical experience using Python for data manipulation and analysis. - 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 - Familiarity with Google Analytics (GA4), Google Search Console, BigQuery or Botify. - Experience with data visualisation tools (e.g., Looker Studio, Tableau, Power BI). - Experience working with APIs - Experience working with large websites (1m+ pages) - An interest in digital marketing, particularly 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 - Cervical and Prostate screening - 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