CRM Data Analyst

PCR Recruitment Ltd
London (Greater)
08 Mar 2018
17 Mar 2018
Contract Type
Full Time
Job Description

CRM Data Analyst, experienced in analysing customer data for marketing / e marketing campaigns for this leading entertainment company based in West London.
We require Strong experience of using SQL to analyse and segment subscriber/customer CRM Data. You will set up triggers for various customer journey email campaigns and report and present on impact and effectiveness, providing greater customer retention for this Direct to consumer VoD subscription service.

In addition to Strong CRM Data Analysis and SQL, we are looking for
someone with strong presenting skills, a confident communicator able to
turn data into meaningful and powerful human stories - a great story teller who is both Numerate and analytical.

Experience and Professional Qualifications Required

  • 2-8 years' experience in delivering Customer CRM Data Analysis/Analytics for brands - including analysis for successful Email Marketing / Push Messaging / Direct Marketing campaigns etc
  • Experience of Direct to Consumer / CRM Data for marketing, ideally with VoD / Entertainment subscription sector, multi-category entertainment markets
  • Experienced working in teams that deliver best in class data segmentation, analysis and insight that help develop and optimise CRM communications
  • Strong SQL coding experience and other relevant data and technology such as Python, R would be a bonus
  • Confidence with, and practical application of, analytical techniques
  • SAS experience might be useful such as SAS coding, SAS Enterprise Guide & SAS Campaign management or similar
  • Excel skills (Macro, VBA skills nice to have)
  • Strong business acumen, with ability to ask the "right questions" of the data
  • Creative Thinking & Team player
  • Strong presenting skills, Confident communicator; both written and verbal able to
  • turn data into meaningful and powerful human stories - great story teller
  • Numerate and analytical

Areas of Responsibility

The role will be tasked with delivering Data and performance analytics, and data selections for Interrogated customer datasets, incorporating customer demographic data, viewing/consumption behaviour, outbound email response data and tenure metrics
-Provide analytical, CRM data management and reporting support
-Management of ad-hoc customer data feeds, and preparation for import into central customer databases
-Data cleansing & formatting
-Create selections for outbound marketing campaigns
-Create segmentations based on eg. viewing profiles
-Email performance / post campaign analysis & reporting
-Preparation & distribution of regular &/or new CRM reports
-Automation / recreation of historic reports (historic reports contain Excel VBA)
-Creation of Ad-hoc reports/ and regular customer data reporting Visualisation
-Profiling of customers responding to emails
-Profiling of customers acquired by promotions
-Profiling value of acquired customers by promotion type
-Ad-hoc behavioural analysis
-Document, write clear and concise presentations & clearly communicate findings from analysis to internal clients
-Provide a consultative service in CRM Analytics
-Delivering upon learnings from the database and ensuring these are turned into real insights that are actioned upon in new and ongoing marketing campaigns (email, social, search, digital)

Similar jobs

Similar jobs