Data Analyst (Retail Media)

PEP; Parow; On-site; ZAR 420,000 - 640,000; Full time

Job summary

PEP seeks a Data Analyst: Retail Media to turn customer, campaign and loyalty data into actionable insights that drive audience planning and supplier reporting. Based in Parow, Western Cape, you will work with BigQuery, Looker Studio and Google Workspace to deliver dashboards, reports and analytic outputs that influence campaign decisions and business growth.

You will be part of a growing capability, collaborating across teams and stakeholders to identify opportunities, validate data quality and

Qualifications

• 3-5 years’ experience in data analytics or a related data-driven role.
• Experience building reports and dashboards with descriptive analysis.
• Experience analyzing customer, campaign, loyalty and product data.

Responsibilities

• Analyse customer, campaign, loyalty and Retail Media data.
• Deliver insight packs and dashboards to guide decision making.
• Support audience profiling and segmentation.
• Create reusable data assets and perform QA checks.
• Support measurement outputs and supplier reporting.

Skills

Analytical thinking

Commercial acumen

Clear communication

Problem-solving

Ownership

Education

Bachelor's degree in Business Analytics, Data Science, Computer Science, or related field

Tools

BigQuery

Looker Studio

Excel / Google Sheets

POPIA knowledge

Job description

We are looking for a Data Analyst: Retail Media to join one of the most exciting new growth areas in PEP.

PEP Media is where customer data, supplier partnerships, campaign performance and commercial opportunity come together. This role will help turn PEP’s customer, retail and campaign data into powerful insights that support audience planning, supplier reporting, campaign measurement and better business decisions.

This is a great opportunity for a curious, commercially minded analyst who wants to help build something new, not just report on what happened, but help shape how PEP Media grows at PEP.

Why Join Us?

• Be part of a brand-new and fast-growing Retail Media capability at PEP.
• Work with customer, campaign, loyalty, product and supplier data in a modern analytics environment.
• Help suppliers and internal teams understand what works, what customers respond to, and where the next opportunity lies.
• Work with tools such as BigQuery, Vertex AI, Looker Semantic and Google Workspace.
• Join a team where your insights can directly influence campaign planning, audience targeting and supplier conversations.

KEY RESPONSIBILITIES

• Analyse customer, campaign, loyalty, product, supplier and Retail Media data.
• Deliver insight packs, reports and recommendations that answer real business questions.
• Support customer profiling, audience sizing and descriptive segmentation.
• Build and maintain trusted reports, dashboards and reusable data assets.
• Perform data validation, reconciliation and QA checks to ensure outputs are accurate and reliable.
• Support campaign planning, supplier reporting, performance tracking and measurement outputs.
• Provide data extracts and analysis to support the Measurement & Performance Analyst.
• Translate business questions into clear, practical and easy-to-understand insights.
• Identify trends, opportunities and risks from customer and campaign data.

ROLE REQUIREMENTS

Education and Experience:

• Business degree with Analytical/Commercial subjects (e.g., Computer Sc., Maths, Eng.)
• 3-5 years’ experience in data analytics or a related data-driven role.
• Experience developing reports, dashboards and descriptive analysis.
• Experience working with customer, campaign, loyalty, product, supplier or Retail Media data.
• Experience translating business questions into analytical outputs and recommendations.

Technical Skills:

• BigQuery SQL.
• Advanced Excel / Google Workspace.
• Data visualisation tools such as Looker Studio.
• Data extraction, transformation and analytical table creation.
• Data cleaning, enrichment, validation and reconciliation.
• Customer, campaign, loyalty, product and supplier data analysis.
• Descriptive analytics, audience profiling and segmentation.
• Knowledge and understanding of POPIA.

Soft Skills:

• Strong analytical thinking and problem-solving ability.
• Commercially curious and able to spot opportunities in data.
• Clear communicator who can explain insights in simple business language.
• High attention to detail and commitment to quality.
• Proactive, self-motivated and able to take ownership.
• Comfortable working across business and technical teams.
• Ability to manage competing priorities.
• Collaborative, supportive and approachable.
• Ability to challenge assumptions using evidence.