Emerging Travel Group

Data Analyst (Loyalty & Retention)

Emerging Travel Group Egypt

Travel Arrangements · 1,001-5,000 employees

15 h ago
Remote data-analyst Mid (2-5 yrs) Full-time Egypt
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

You will analyze loyalty and retention mechanics to drive bookings and optimize program costs. Additionally, you will segment partners, conduct experiments, and build financial models to inform strategic decisions for the Retention, Commercial, and Finance teams.

What they look for

SQL Data analysis A/B testing Tableau Financial modeling Python Experiment design Segmentation Retention analysis dbt Airflow PostgreSQL Vertica Trino Agentic coding tools

Requirements

The role requires 2-4 years of experience as a data, marketing, or product analyst with strong SQL and A/B testing skills. Candidates must be proficient in BI tools, comfortable with large datasets, and capable of clear communication with non-technical stakeholders.

Benefits

Flexible schedules Remote work opportunity Structured onboarding Personal development plan Internal training and lectures Soft skills development Leadership training Partial compensation for external training and conferences Corporate English school Corporate prices on hotels and travel services MyTime Day Off

Full description

We’re looking for a Data Analyst to work on our loyalty and retention mechanics. You’ll tell the team whether a mechanic actually drives more bookings, what it costs, and how to tune it.

The work goes well beyond reporting. You’ll segment partners by behavior, run and read experiments, build financial models for new program features, and turn your findings into rules that the Retention, Commercial and Finance teams act on.

  • 2-4 years as a data or marketing/product analyst, ideally in e-commerce, travel, fintech or a marketplace.
  • Explains findings clearly to non-technical people and turns ambiguous questions into a structured plan.
  • English level B2+ (written and spoken).
  • Strong SQL: window functions, CTEs, query optimization. Experience with Vertica, Trino, PostgreSQL or similar.
  • Solid A/B testing: experiment design, power and significance, choosing the unit of randomization, calculating and interpreting results.
  • Experience with a BI tool: we use Tableau (Looker or Power BI experience is fine too).
  • Can work with large, messy data where business logic hides in free-text fields and edge cases.
  • Hands-on experience with Claude Code or similar agentic coding tools (Cursor, Copilot, etc.): writing effective prompts, working with agents, and maintaining project context files (such as CLAUDE.md) so results are repeatable.
  • Comfort building financial or scenario models in spreadsheets, with clear assumptions and adjustable parameters.
  • Proactive approach: you spot inefficiencies in reporting and analysis workflows and fix them yourself (automation, reusable queries, templates), rather than waiting to be asked.

Nice to have

  • Hands-on experience with loyalty, CRM, rewards or affiliate program analytics: points economics, liability, redemption and breakage.
  • Experience with segmentation and cohort or retention analysis.
  • Python for analysis (pandas, scipy, seaborn).
  • Experience with dbt and Airflow.
  • Methods beyond classic A/B tests (causal inference, diff-in-diff).
  • Flexible schedules and opportunity to work remotely.
  • Ambitious and supportive team who love what they do, appreciate each other, and grow together.
  • A structured onboarding, a personal development plan, and regular internal lectures and demos from the team.
  • Internal programs for adaptation and training, development of soft skills, and leadership abilities.
  • Partial compensation for participating in external training and conferences.
  • Corporate English school: Group and individual lessons, speaking clubs with colleagues from all over the world.
  • Corporate prices on hotels and travel services.
  • MyTime Day Off - an extra non-working day without loss of compensation.

Similar roles