SEO Data Engineer
- Built Python and SQL ETL pipelines loading Google Search Console and GA4 data into PostgreSQL for 25 client sites, around 40M rows, replacing manual exports and cutting weekly reporting from 12 hours to 1.
- Modelled traffic with dbt and Looker Studio, flagging 1,800 pages with falling click-through rates; rewrites of the top 300 lifted organic clicks 18% over three months.
- Added automated data-quality tests — freshness, row counts, schema — with GitHub Actions alerts, taking broken client reports from about four a month to none.