CRM Data Analyst

VML; Cape Town; Hybrid; ZAR 200,000 - 300,000; Full time

Job summary

A leading marketing firm is looking for a CRM Analyst to enhance client understanding through data analysis and evaluate marketing activities. The ideal candidate will have over 2 years of experience in a marketing role with strong skills in SQL and data visualization tools. The position offers a hybrid work environment and a collaborative culture focusing on respect and equal opportunities.

Qualifications

• 2+ years working in a marketing environment as an analyst.
• Experience with data visualization tools is mandatory.
• Ability to translate business needs into analytical methods.

Responsibilities

• Design and deliver analyses to improve customer experience.
• Deliver measurement projects and dashboard reporting.
• Present findings and recommendations to clients.

Skills

SQL proficiency

Data visualization tools (Power BI, Tableau)

Python

Microsoft Word

Microsoft Excel

Microsoft PowerPoint

Numeracy skills

Attention to detail

Communication skills

Job description

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.