Looking for a job

Ziad Ali

@ziadali2

Entry-level data analyst doing freelance e-commerce analysis, with a published SQL and Tableau funnel study that traced 77% visitor drop-off.

Egypt

Message

What I'm looking for

I'm seeking an entry-level Data Analyst role where clear definitions and defensible numbers matter.

As a freelance Data Analyst, I analyse traffic, purchase funnels, product performance, and paid campaigns for local Egyptian clothing brands and dropshipping stores. My work helps owners distinguish engaged shoppers from traffic that doesn't convert and identify where to focus next.

I built a published purchase funnel analysis using BigQuery SQL and Tableau, tracing 1.8M events to find where an online store loses 77% of its visitors. I also audited my segmentation logic, found a labelling bug behind a reported iOS-versus-Android gap, and corrected the false finding.

Before moving into commercial analytics, I applied quantitative research methods during my psychology degree and as an Undergraduate Research Assistant at Cognitive Sciences and Brain Research Centre, BUE. That work included regression, structural equation modelling, network analysis, and psychometric scale validation.

My experience also includes administering standardised assessments as a psychologist and clinical psychology intern, and building a research workspace at Arab Contextual Human Science Research Lab, Coventry University. I’m seeking an entry-level Data Analyst role where clear definitions and defensible numbers matter.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

Freelance

Apr 2026 - Present (6 months)

Analysed website traffic, purchase funnels, and sales performance for e-commerce clients, including local Egyptian clothing brands and dropshipping stores. Built an end-to-end purchase funnel analysis of 1.8M events using SQL and Tableau, identifying where an online store loses 77% of its visitors.

SQL BigQuery Tableau Google Analytics Data Analysis Funnel Analysis E commerce analytics Data Visualization

Research Intern

Arab Contextual Human Science Research Lab, Coventry Univers

Nov 2025 - Apr 2026 (5 months)

Built and maintained the lab's Notion workspace and Google Drive file architecture, standardising how research materials are stored, named and retrieved across the team.

Notion Google Drive File Management Research Administration

Psychologist

El Rakhawy Hospital for Mental Health and Addiction Treatmen

Dec 2025 - Mar 2026 (3 months)

Administered and scored standardised psychometric instruments and maintained consistent assessment records across an active caseload to track change over time.

Psychometrics Psychological Assessment Data Recording Case Management

Clinical Psychology Intern

Dr. Gamal Mady Abou Elazayem Hospitals

Sep 2024 - Dec 2024 (3 months)

Administered and interpreted standardised psychological tests and structured clinical interviews, synthesising scores and interview data into case formulations reviewed in supervision.

Psychological Testing Clinical Interviewing Case Formulation Psychometrics

Undergraduate Research Assistant

Cognitive Sciences and Brain Research Centre, BUE

Sep 2023 - Aug 2024 (11 months)

Collected and analysed empirical research data, refined statistical analysis protocols, conducted literature reviews, drafted methodology sections, and contributed to grant-aligned funding proposals.

Research Data Analysis Statistical Analysis literature review Grant writing

Education

Degrees, certifications, and relevant coursework

Google

Professional Certificate, Data Analytics

Completed the Google Data Analytics Professional Certificate, covering the full analysis workflow from data cleaning and SQL to visualization and reporting.

London South Bank University

Bachelor of Arts (Hons), Basic and Applied Psychology

2021 - 2025

Grade: First Class Honours

Completed a dual degree program with the British University in Egypt, earning a BA (Hons) in Basic and Applied Psychology with First Class Honours.

British University in Egypt

Bachelor of Arts (Hons), Basic and Applied Psychology

2021 - 2025

Grade: First Class Honours

Earned a BA (Hons) in Basic and Applied Psychology with First Class Honours, achieving a 4.0 GPA and ranking 3rd in class. Thesis focused on network analysis of predictors of Internet Gaming Disorder severity in adults.