Experience
My professional experience has evolved from technical SEO and automation into analytics engineering and production data systems. Across these roles, I have built data pipelines, analytical models and infrastructure that support product and commercial decisions.
- Analytics engineering
- dbt in production, dimensional modelling, incremental models, and data-quality testing and validation.
- SQL and data modelling
- Advanced SQL, grain and cardinality design, and reusable analytical models.
- Warehouses
- BigQuery and Snowflake, with query optimisation, partitioning, clustering and cost management.
- Python and pipelines
- Python, Pandas, API integrations and Airflow, on AWS and Google Cloud.
- Outcomes
- BigQuery costs reduced by about 40% at Find.co. At Legend, a recommendation system that contributed to 190% organic traffic growth on one product and more than 200% on another.
Senior Analytics Engineer
Find.co
December 2024 to June 2026
Built and maintained production analytics infrastructure supporting product, SEO, growth and commercial decision-making across a multi-domain digital portfolio.
- Designed and maintained dbt models supporting more than 10,000 tracked entities across more than 10 domains, turning search, web analytics and third-party data into datasets used for daily decisions.
- Reduced BigQuery warehouse costs by about 40% by refactoring legacy SQL and dbt models and improving incremental processing.
- Built keyword and page-performance data models combining Google Search Console and web analytics data, used for cannibalisation detection, performance monitoring and finding opportunities.
- Built URL normalisation, canonicalisation and classification logic across more than 500,000 pages, giving consistent page identifiers across datasets.
- Integrated third-party data sources using Python and APIs, with rate limiting, monitoring and cost controls.
Technologies: SQL, dbt, BigQuery, Python, Airflow, Google Cloud
Senior Data Analyst / Analytics Engineer
Legend
June 2021 to December 2024
Worked across analytics engineering, data engineering, machine learning and SEO, with product, marketing and SEO teams, to build data-driven growth systems.
- Led development of a recommendation system using vector embeddings to identify and prioritise content opportunities, contributing to 190% organic traffic growth on one product and more than 200% on another.
- Designed analytics tables and reporting datasets in Snowflake for prioritisation, experimentation, competitor analysis and performance measurement.
- Built proof-of-concept data pipelines in Python and AWS, integrating DataForSEO, Ahrefs, Majestic, Google Trends and Google Search Console.
- Worked with data engineers and product managers to move those pipelines into production using Airflow and Snowflake, as monitored and repeatable workflows.
- Created dashboards and self-service analysis tools using Tableau, Snowsight and Streamlit.
- Automated large-scale data collection and content research using Python, Pandas, Playwright and BeautifulSoup.
Technologies: SQL, Snowflake, dbt, Python, Airflow, Tableau, AWS
Independent projects and freelance technical SEO
Independent
September 2020 to June 2021
Built independent projects alongside freelance technical SEO work.
Technical SEO Lead
DeepCrawl (now Lumar)
April 2019 to September 2020
Delivered data-driven technical SEO work for large e-commerce and enterprise websites, analysing complex web datasets and turning the findings into recommendations.
- Led technical SEO projects including site migrations, crawl diagnostics, indexation analysis and mobile parity audits.
- Built Python and Pandas workflows to automate large-scale data analysis and reporting.
- Worked with client and engineering teams to turn technical findings into prioritised recommendations.
Technologies: Python, Pandas
SEO and Data Consultant
Freelance
June 2010 to April 2019
Delivered SEO and data work for enterprise and agency clients, including large-scale taxonomy, migration and technical analysis programmes.