Data Analyst - 8 Months - Remote - Octopus by RTG

Location: Cairo, Cairo Governorate, Egypt

Workplace: remote

Description

About Octopus by RTG

Octopus by RTG is the tech hiring and outsourcing arm of Robusta Technology Group, dedicated to connecting exceptional tech talent with top-tier organizations across the MENA, GCC, Europe, the US, and Canada. We specialize in building strong, long-term partnerships between skilled professionals and innovative companies. Our mission is to empower growth, innovation, and excellence by matching the right talent with the right opportunities.

About the Role

We are currently expanding our team and seeking a detail-oriented and commercially driven Data Analyst. This role sits at the intersection of data, CRM, and marketing, with a strong focus on transforming data into actionable insights that drive consumer engagement, personalization, and business growth.

You will collaborate closely with cross-functional teams including media, CRM, content, and brand, enabling data-driven decision-making and supporting ongoing digital transformation initiatives.

Key Responsibilities

1. Data Analysis & Insights

• Analyze large datasets across CRM, media, and digital platforms to uncover actionable insights
• Develop dashboards and reports to track key KPIs (acquisition, engagement, retention, conversion)
• Translate complex data into clear, business-friendly insights for stakeholders

2. CRM & Consumer Analytics

• Support segmentation strategies (e.g., lifecycle, behavioral, RFM models)
• Analyze consumer journeys across channels such as WhatsApp, email, and web
• Identify opportunities for personalization and next-best-action strategies

3. Campaign Measurement & Optimization

• Measure performance of CRM and digital marketing campaigns
• Conduct A/B testing and provide data-driven recommendations for optimization
• Collaborate with media teams to assess campaign effectiveness and ROI

4. Data Management & Integration

• Work closely with data engineering and tech teams to ensure data accuracy and consistency
• Support integration of multiple data sources (CDPs, CRM platforms, media platforms)
• Ensure proper data governance and compliance with privacy regulations

5. Stakeholder Collaboration

• Partner with internal teams and stakeholders to support business objectives
• Present insights and recommendations in a clear and compelling manner
• Contribute to strategic initiatives such as loyalty programs and digital transformation projects

Background & Experience

• 5–8 years of experience in data analytics, preferably within FMCG, retail, or digital marketing environments
• Experience in an agency or consulting environment is a plus
• Strong understanding of consumer behavior, CRM, and marketing analytics
• Exposure to MENA markets is an advantage

Requirements

Qualifications

• Bachelor’s degree in Data Science, Statistics, Mathematics, Economics, Engineering, or a related field
• Master’s degree is a plus
• Strong analytical thinking and problem-solving skills
• Ability to communicate complex insights to non-technical stakeholders

Technical Skills & Tools

Core Tools

• Strong proficiency in SQL (data querying and manipulation)
• Advanced Excel / Google Sheets skills (pivot tables, data modeling)

Visualization & BI

• Experience with Power BI, Tableau, or Looker Studio

Programming

• Basic to intermediate knowledge of Python or R

Marketing & CRM Platforms (Nice to Have)

• Experience with platforms such as Salesforce Marketing Cloud, Adobe Campaign, or Braze
• Familiarity with CDPs (e.g., Segment, Tealium)

Media & Analytics

• Experience with Google Analytics (GA4), Meta Ads Manager, and Google Ads
• Understanding of attribution models and campaign tracking

Key Competencies

• Strong business acumen with a data-driven mindset
• High attention to detail and ability to manage multiple data sources
• Excellent communication and storytelling skills

• Proactive, collaborative, and solution-oriented approach