CRM Data Analyst

VML; Cape Town; Hybrid; ZAR 300 000 - 450 000; Full time

Job summary

A leading marketing agency in Cape Town is seeking a CRM Analyst to join their Data team. This role involves analyzing data to enhance understanding of clients' customers and marketing effectiveness. The ideal candidate will have experience in SQL and data visualization tools like Power BI or Tableau. Responsibilities include managing data projects, delivering presentations to clients, and collaborating with various teams to ensure data-driven decision-making. A hybrid work model is emphasized, supporting collaboration and flexibility.

Qualifications

• 2+ years working in a marketing environment as an analyst.
• Proficiency in SQL is mandatory.
• Experience with data visualization tools such as Power BI or Tableau is mandatory.
• Good written and verbal communication skills.
• High-level analytical skills for performance analysis.

Responsibilities

• Design, manage, and deliver end-to-end analyses to improve customer experience.
• Deliver measurement projects, including dashboard reporting.
• Manage data quality and consistency issues.
• Present insights and recommendations to clients.
• Collaborate with strategy and account teams on data-informed decisions.

Skills

Analytical skills

Communication skills

Attention to detail

SQL proficiency

Data visualization

Collaboration skills

Tools

SQL

Power BI

Tableau

Python

Salesforce

Job description

Who We Are:

At VML, we are a beacon of innovation and growth in an ever‑evolving world. Our heritage is built upon a century of combined expertise, where creativity meets technology, and diverse perspectives ignite inspiration. With the merger of VMLY&R and Wunderman Thompson, we have forged a new path as a growth partner that is part creative agency, part consultancy, and part technology powerhouse.

Our global family now encompasses over 30,000 employees across 150+ offices in 64 markets, each contributing to a culture that values connection, belonging, and the power of differences. Our expertise spans the entire customer journey, offering deep insights in communications, commerce, consultancy, CRM, CX, data, production, and technology. We deliver end‑to‑end solutions that result in revolutionary work.

OVERVIEW

We are looking for a CRM Analyst to work within the VML Data team. The Analyst will analyse data to deliver value through understanding our clients' customers and the performance of marketing activities.

Working closely with the wider analytics and data team you will be responsible for the development and delivery of measurement and insight projects across various marketing activities and contribute to answering business questions, ensuring that we are making best use of available data to deliver against the client vision.

On a day‑to‑day basis you will take ownership of analysis projects, delivering them to a high degree of accuracy and take a role in presenting results and insights to clients.

This is a technical role grounded in customer data, so you should be experienced in handling large customer data sets. Communication and interpersonal skills are important, both in collaborating with clients and colleagues across multiple disciplines.

ROLES & RESPONSIBILITIES

• Design, manage, and deliver end‑to‑end analyses aimed at helping Marketing to improve the experience of the customer.
• Deliver measurement and effectiveness projects, including dashboard reporting and deep dive evaluations to understand the impact marketing has on customer behaviour.
• Deliver customer projects (segmentation, modelling), using statistical techniques to develop a deep understanding of customers.
• Ensure that the most relevant methodologies are applied to measure and evaluate, proactively recommending better ways of working.
• Develop and provide written and verbal output on reports and presentations, supporting with recommendations on marketing strategy.
• Manage and resolve data issues involving quality and consistency of data.
• Be the clients trusted advisor on data and analytical methodology – make it easy for them to make business decisions based on data.
• Present to clients and attend client meetings.
• Be highly collaborative in integrating data work into agency deliverables, working with strategy and account teams to develop a culture of data‑informed decision‑making.
• Develop the skills and knowledge of colleagues, creating and sustaining a learning culture within the team.

SKILLS & EXPERIENCE

• 2+ years working in a marketing environment as an analyst.
• Proficiency in SQL is mandatory.
• Experience with data visualization tools such as Power BI or Tableau is mandatory.
• Python experience is very useful; willingness to learn if not already experienced.
• Familiarity with Salesforce is very useful but not essential.
• High level Microsoft Word, Excel and PPT skills.
• Attention to detail and a commitment to accuracy.
• Well‑developed numeracy skills.
• Able to translate business needs and requirements to analytical methods and outputs.
• Good written and verbal communication skills.
• High‑level analytical skills for performance analysis.
• Experience with reporting dashboard design and automation.
• Knowledge of advanced data analysis techniques.
• Experience with segmentation and modelling techniques (nice‑to‑have).

*Please note that our business is an equal opportunity employer and preference in appointment for the role will be in line with the EE strategy of our organisation*

#LI-HYBRID

#LI-EMEA

We believe the best work happens when we're together, fostering creativity, collaboration, and connection. That's why we've adopted a hybrid approach, with teams in the office an average of four days a week. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process.

WPP (VML) is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.

VML is a WPP Agency. For more information, please visit our website, and follow VML on our social channels via Instagram, LinkedIn, and X.

When you click "Submit Application", this will send any information you add below to VML. Before you do this, we think it's a good idea to read through our Recruitment Privacy Policy. California residents should read our California Recruitment Privacy Notice. This explains what we do with your personal data when you apply for a role with us, and, how you can update the information you have provided us with or how to remove it.