AI & Data · RP-AI-0002

Mohamed Fouad

MidAnalytics Engineer

Analytics engineer building reliable Python/SQL pipelines and self-serve Dash and Looker Studio dashboards

  • Identity verified
  • Remote Pro Ai team member · under contract
Add to squadAll team profilesAI & Data · Game Development

Availability on request

  • 4yearsprofessional experience
  • MidSeniority level
  • PythonPrimary stack
  • PhoenixBased in · United States · GMT−7

Mohamed Fouad

Profile summary

Analytics and data engineer with 4 years of experience in Python and SQL, building production ETL/ELT pipelines that ingest REST APIs and JavaScript-heavy websites, then clean, deduplicate, validate and load data into SQL databases, Google Sheets and BI layers on unattended schedules. Designs for reliability with incremental upserts, CDC patterns, idempotent re-runs, retries with backoff and cross-system record matching. Currently analyses large geospatial datasets at Nearmap and ships Dash/Plotly dashboards that replace ad-hoc reporting with self-serve views.

  • Languages

    • ArabicNative
    • EnglishProfessional working proficiency

  • Sectors

    • Media
    • Healthcare

Mohamed Fouad

Experience

Most recent role first, with outcomes as stated in the CV.

  1. Data Analyst

    Nearmap

    – PresentCairo, Egypt (Remote)

    • Replaces recurring ad-hoc reporting requests with self-serve Dash and Plotly dashboards exposing project and delivery metrics to stakeholders.
    • Cuts manual preparation time on recurring analyses by automating data-quality and reporting workflows in Python.
    • Identifies coverage trends, anomalies and data-quality patterns through statistical and exploratory analysis of large geospatial datasets in Python and SQL.
    • Partners with engineering teams to improve upstream data quality and align the metric definitions used across reporting.
    • Turns analysis into decision-first written recommendations for non-technical stakeholders.

  2. Freelance Data Analyst & Python Developer

    Upwork

    – PresentRemote

    • Recovered 37,000+ high-resolution images for a news publisher from approximately 118,000 web-archive index records after its S3 image storage became unreachable, using async Python (asyncio, aiohttp) with Wayback, Common Crawl and search-engine caches.
    • Automated weekly per-representative sales reporting by connecting a Pipedrive CRM to SQL Server and Excel via REST API and pyodbc, replacing manual exports.
    • Delivered end-to-end ETL pipelines from REST APIs and web sources into SQL databases, Google Sheets and BI tools, with deduplication and fuzzy cross-system record matching on unattended schedules.
    • Built FitData Pipeline, unifying the Renpho and Trainerize APIs into a single Looker Studio reporting layer and resolving client-name mismatches with fuzzy matching.
    • Built resilient scrapers (Selenium, Playwright, BeautifulSoup, Scrapy) for JavaScript-heavy and login-gated sites, plus FastAPI, Django and Flask services, QGIS geospatial deliverables and scikit-learn models for pricing, classification and segmentation.

Mohamed Fouad

4 projects

Selected projects

Shipped titles and products, with the role played on each.

  • Web Archive Image Recovery Pipeline

    Sole developer

    Recovery pipeline that queried approximately 118,000 index records, validated and deduplicated every file and ran concurrency-capped async downloads, recovering 37,000+ images; later open-sourced as a generic CLI.

    • Python
    • aiohttp
    • asyncio
    • Pillow
    • Wayback CDX API
    • Common Crawl

  • FitData Pipeline

    Sole developer

    Health-tracking ETL engine merging three daily sources with source precedence, cross-platform identity resolution and sanity-range validation into one Looker Studio reporting table.

    • Python
    • REST APIs
    • Google Sheets API
    • Looker Studio

  • Shadow-DOM Booking Availability Scraper

    Sole developer

    Playwright scraper that pierces shadow roots of a JavaScript booking widget and merges availability incrementally into a de-duplicated CSV with retries and run diagnostics.

    • Python
    • Playwright

  • Search Interest vs Social Engagement

    Analyst

    Time-series study combining Google Trends with social-engagement data, using rolling correlations and OLS regressions with a time-trend control and residual diagnostics.

    • Python
    • Pandas
    • statsmodels
    • Seaborn

Mohamed Fouad

8 core skills

Skills

Core skills first, then the full toolkit by theme.

Core skills

  • Python
  • SQL
  • ETL/ELT Pipelines
  • Apache Spark / PySpark
  • Change Data Capture (CDC)
  • Dash & Plotly
  • Looker Studio
  • Data Quality & Validation

  • Data engineering

    • ETL/ELT design
    • Incremental loads & upserts (MERGE)
    • CDC
    • Idempotent re-runs
    • Entity resolution / fuzzy matching
    • REST API ingestion
    • Apache Spark / PySpark
    • asyncio / aiohttp (concurrent ingestion)

  • Databases

    • PostgreSQL
    • MySQL
    • SQL Server
    • SQLite
    • Query-plan analysis & indexing

  • Analytics & BI

    • Dash
    • Plotly
    • Looker Studio
    • Power BI
    • statsmodels
    • Pandas
    • NumPy
    • Seaborn
    • Microsoft Excel

  • Scraping & automation

    • Playwright
    • Selenium
    • BeautifulSoup
    • Scrapy
    • PyMuPDF
    • Tesseract OCR

  • APIs, ML & tooling

    • FastAPI
    • Django REST Framework
    • Flask
    • scikit-learn
    • Docker
    • Git
    • GitHub
    • Google Sheets & Drive APIs
    • QGIS
    • pyproj

Mohamed Fouad

Education

Degrees, certifications and awards on record.

  • Bachelor of ScienceAssiut University · 2018

Mohamed Fouad

Usually works with

Roles this profile is usually paired with in a squad.

Build this squad

AI & Data

Bring this profile into your squad

Add the role and level to the Squad Builder; availability is confirmed with your quote.

Add to squadAll team profiles

Availability on request