You'll be the person who knows why a customer reached a product page and didn't buy, and why they came back for a second order or never did. You'll build one trusted source of numbers from GA4, BigQuery, Search Console and Odoo, and turn it into clear recommendations that marketing, product and operations can act on the same week.
Experience: 2-5 years in data analysis, ideally in e-commerce or a digital product
What you will do
- Build and evolve dashboards for sales, marketing and operations so every team sees its numbers under the same definitions, without manual work.
- Write SQL on GA4 data exported to BigQuery and join it with Odoo order data, so we can see the full customer journey from first visit to delivery.
- Analyse the conversion funnel across the app and website, pinpoint where people drop off, and propose experiments to reduce it.
- Measure retention, repeat purchase and customer lifetime value to learn which segments and products build long-term relationships.
- Track organic search performance in Search Console with the content team to see which health guides bring valuable traffic and which need a refresh.
- Design measurement for campaigns and A/B tests and read the results honestly, including when the answer is inconclusive.
- Audit tracking and data quality regularly with the tech team, documenting events and metrics so the numbers stay trustworthy.
- Tell the story behind the numbers in short write-ups and clear presentations that end with a recommendation and an owner.
What we need
- 2-5 years of hands-on data analysis experience, or equivalent experience you can demonstrate with real work
- Strong SQL, including joins, window functions and CTEs; BigQuery experience preferred
- Hands-on GA4 experience (events, reports, explorations) and working knowledge of Search Console
- Dashboard building in a tool such as Looker Studio, Power BI or Tableau
- Ability to present analysis in plain language to non-technical audiences in Arabic and English
Nice to have
- Previous experience in e-commerce or a mobile app, or with WooCommerce
- Python or R for analysis and automation
- Grounding in statistics for designing and reading A/B tests
- Using AI tools to draft queries or summarise findings, while checking their accuracy
Your first 90 days
- By day 30You understand the core data sources (GA4, BigQuery, Search Console and Odoo) and have documented the definitions of key metrics, including where they disagree.
- By day 60You've shipped a weekly commercial performance dashboard that marketing and leadership rely on, and presented your first conversion-funnel analysis with at least two actionable recommendations.
- By day 90You've analysed customer retention by cohort and tracked the measured impact of at least one recommendation after it went live.
Where this can lead
- Senior Analyst owning a full domain such as retention or pricing
- Leading an analytics or BI team
- Specialising in analytics engineering or data science
Know someone who fits this role?
Make a referral link with your name and send it. Anyone who applies from it is recorded as coming from you.
About Beseha
Beseha is building a healthier Egypt: pharmacist-reviewed products, reliable health information, and a service that respects people. We look for different people to grow with us and grow that impact. Read our mission