CRM Data Analyst

Wunderman Thompson; Johannesburg; Hybrid; ZAR 500,000 - 650,000; Full time

Job summary

A leading marketing agency in Johannesburg seeks a CRM Analyst to analyze customer data and deliver insights that improve marketing strategies. The role involves end-to-end analysis, data visualization, and working closely with clients and teams. Ideal candidates have proficiency in SQL and experience with tools like Power BI or Tableau. A hybrid work approach is available.

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.
• Attention to detail and a commitment to accuracy.
• Good written and verbal communication skills.

Responsibilities

• Design, manage, and deliver end-to-end analyses.
• Deliver measurement and effectiveness projects.
• Ensure relevant methodologies for data evaluation.
• Develop and provide reports and presentations.
• Manage and resolve data quality and consistency issues.

Skills

Data analysis

SQL

Data visualization tools (Power BI or Tableau)

Analytical skills

Communication skills

Attention to detail

Tools

SQL

Power BI

Tableau

Python

Salesforce

Microsoft Word

Microsoft Excel

Microsoft PowerPoint

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.

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, please read Recruitment Privacy Policy. California residents should read 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 or remove it.