SEO Specialist | SQL + AI + Data
"Extracting and structuring data with SQL, using AI to deepen the analysis, and then visualising it in dashboards to identify real SEO opportunities."
About Me
I am a Technical SEO Specialist based in Limpopo, South Africa, with a unique combination of SEO expertise and SQL data engineering skills. While most SEO candidates check pages manually, I build automated data pipelines that find issues across thousands of URLs in seconds.
My approach combines Screaming Frog crawl data with MySQL queries, Google Search Console analysis, AI-assisted strategy, and Looker Studio dashboards — giving clients a complete, data-driven picture of their organic search performance.
I have applied this workflow to real South African websites, uncovering issues that manual audits miss entirely — including WWW vs non-WWW canonical mismatches, WordPress system file crawl waste, and internal linking structural problems.
Portfolio
Every project below was completed on live South African websites using professional tools and documented in portfolio-grade reports.
Complete technical SEO audit of mtgfunerals.co.za — a funeral services business in Venda, Limpopo. Found 15 issues including missing schema, 404 pages, weak title tags, and local SEO gaps.
Core Web Vitals analysis across 7 South African websites spanning 6 industries. Identified industry-specific CWV failure patterns across LCP, CLS, INP and TTFB metrics.
Full keyword research and clustering for funeral services in Venda and Limpopo. 9 keyword clusters mapped to dedicated pages, cannibalization risks identified, and 4 new pages recommended. Delivered as a professional Excel workbook with 5 sheets.
Implemented LocalBusiness and FAQPage JSON-LD schema on a live WordPress site. Diagnosed and fixed an invalid schema type error. Validated with Google Rich Results Test — 4 valid items confirmed.
Built a reusable SQL audit pipeline — Screaming Frog crawl data imported into MySQL, 8 automated queries finding SEO issues across 105 URLs. Three issues found by SQL only, invisible to manual review. Published on GitHub.
SQL queries on Google Search Console export data — branded vs non-branded traffic split, CTR opportunity quantification, page performance analysis, and keyword gap identification across 46 keywords.
8 reusable AI prompts for SEO work tested on real SA websites using Claude AI and ChatGPT. Covers meta descriptions, title tags, audit interpretation, schema generation, and GEO optimisation with Claude vs ChatGPT comparison.
Researched 5 keywords on Perplexity AI and Google AI Overviews. Mapped citation patterns by intent type. Discovered MTG Funerals ranked #1 on Perplexity for 'burial plans Limpopo' — beating national brands.
Built a live Looker Studio dashboard with 6 components — scorecards, keyword tables, CTR opportunity charts, page performance, position distribution, and branded vs non-branded pie chart with custom REGEXP_MATCH formula.
The Workflow
A complete, modern SEO workflow combining data engineering, artificial intelligence, generative engine optimisation, and business intelligence.
Certifications
Industry certifications combined with hands-on project experience.
Get In Touch
Looking for SEO Specialist, Technical SEO, or SEO Data Analyst roles in South Africa — remote or Limpopo based.