The key skills

Main tools : Python · Pandas · SQLite · Excel · Google Sheets

• Build automated pipelines to collect, clean, and analyze SEO data from multiple sources (Google Search Console, SEMrush, SERP API).

• Use Python scripts to transform raw data into structured insights.

• Automate report generation with charts, filters, and conditional formatting.

Impact : faster reporting, better accuracy, and a consistent view of performance across all websites.

Main tools : Google Search Console · SEMrush · SERP API · WordPress 

• Track and analyze SEO KPIs (clicks, impressions, CTR, position).

• Perform keyword benchmarking and competitor monitoring.

• Identify “quick wins,” long-term opportunities, and ranking gaps.

• Optimize WordPress pages (HTML, CSS, PHP) for structure, speed, and accessibility.

Impact : improved keyword visibility, technical stability, and organic growth. 

Main tools : SQLite · MySQL · SQL · MongoDB 

• Design and maintain databases for SEO and performance tracking.

• Store and organize large data sets to support year-over-year comparisons.

• Ensure data integrity, consistency, and reusability for predictive models.

Impact : centralized, reliable, and easily exploitable SEO data architecture. 

Main tools : Excel · Google Sheets · Power BI · Python (Matplotlib) 

• Create dashboards for SEO and performance tracking with automated updates.

• Develop KPI visualizations that clearly communicate insights to non-technical stakeholders.

• Standardize reporting templates for the entire group.

Impact : improve readability and strategic decision-making through clear, visual storytelling. 

Main tools : HTML · CSS · PHP · Docker · GitLab · Linux 

• Modify and customize WordPress themes for UX and SEO compliance.

• Use Docker and GitLab CI/CD to automate testing and deployment environments.

• Basic system administration and environment management under Linux.

Impact : seamless collaboration between SEO, content, and technical teams.