Marketing & Social Media Data Analyst

Senior Data Analyst - Marketing & Social Media

Location: Cairo, Egypt (North of Zamalek)

Work setup: Full-time, onsite

The opportunity

An international marketing agency, part of a larger global marketing group, is expanding its Cairo team. We are looking for a Senior Data Analyst who can turn campaign, audience and social media data into clear insights that strengthen strategy, creative decision-making and client reporting.

This role suits someone who combines strong analytical skills with an understanding of marketing and social media. You should be comfortable working with large datasets, building dashboards, identifying patterns and presenting recommendations in language that clients and non-technical teams can act on.

Key responsibilities

• Analyse marketing, campaign, website and social media performance across multiple channels and platforms.
• Build and maintain dashboards and recurring reports covering reach, engagement, audience growth, content performance, traffic, conversions and campaign effectiveness.
• Consolidate data from social platforms, media tools, web analytics and internal reporting sources.
• Identify trends, content learnings, audience behaviours and performance gaps, translating findings into practical recommendations.
• Develop measurement frameworks, KPIs and reporting templates aligned with campaign and business objectives.
• Partner with strategy, social, content, media, account management and creative teams to inform planning and optimisation.
• Conduct campaign, competitor, audience and category analyses to support strategic decision-making.
• Review data quality, investigate discrepancies and maintain accurate reporting processes.
• Present findings clearly to internal teams and client stakeholders through reports, presentations and performance reviews.
• Support test-and-learn initiatives by evaluating creative, platform, audience and campaign performance.
• Improve reporting efficiency through automation, reusable dashboards and standardised data processes.

What we're looking for

• Relevant experience in marketing analytics, digital analytics, social media analytics, business intelligence or a related field.
• Strong experience creating dashboards, reports and actionable performance insights.
• Practical knowledge of social media metrics and reporting across platforms such as Meta, TikTok, YouTube, LinkedIn, X and Snapchat.
• Experience with tools such as Excel or Google Sheets, Looker Studio, Power BI or Tableau; familiarity with GA4 and platform analytics is highly desirable.
• Ability to combine data from different sources and explain findings to non-technical stakeholders.
• Strong analytical thinking, attention to detail and confidence checking data accuracy.
• Experience in an agency, consumer-brand, beauty, luxury, lifestyle, FMCG or e-commerce environment is advantageous.
• Strong written and verbal communication skills in English; Arabic is highly desirable.
• Currently based in Egypt and able to work full-time onsite in Cairo.