Role Profile:
Role title: CRM Campaign Developer

Function: CRM Data Planning
Band : B Sub-function: Data Operations/Technical Digital Marketing

Reports to: Data Director/Campaign Manager/ Data planning Manager.

Location: Ebbw Vale

The Role:
We have a rapidly growing Data Planning team where your contributions will make a big impact in fast growth of company. This is purely a technical role where need to have hand on with data.
Extracting Data from Database then segregate them into meaningful Segments, run campaigns and to analyse campaign performance. Within CRM, we have ambitions to increase the pace and scale of our data driven test and learn programs to offer more personalised experiences to client’s customers.

• Data Segmentation, Targeting and analysing the campaign performance to provide better cross selling/ upselling.
• Using SQL programming code/scripts or equivalent (Unica/Adobe campaign) to perform data extraction/ data transformation/ data load.
• Gather requirement from marketing professional and then translate them into meaning full data selection criteria and exclusions rules for Campaign.
• Have robust knowledge of data tables in database and analysing them for data quality issues, root cause the errors and create documentations.
• Owning and maintaining the data-briefing document (BAC’s) throughout the campaign life.
• Generate campaigns for data selection in UAT (development) server. Perform the QA and transfer it into production server. Provide an end-to-end solution from brief, scoping & design to QA & release.
• As a CRM Campaign developer you will responsible for preparing data for a wide range of marketing campaigns cross-channel, including email, push notifications and SMS.
• Require Data modelling (propensity modelling, predictive modelling) implementation into campaign to determine next best offer.
• Overall, analyse the campaigns performance and create dashboards/reports in Microsoft excel using advance excel Formula’s (vlookup, pivot tables and etc) for Marketers.
• Drive campaign improvement – shown by increased response rates / NPS
  improvements etc.
• Working with stakeholders, coordinating and communicating with different Departments of CRM, Acquisition, Retention and Delivery to produce regular and ad-hoc campaigns.
• Create Campaign to support A/B testing, subject line testing and waving of campaign broadcast.

The Candidate:

• The ideal candidate will have comprehensive knowledge of Data Extraction and management.
• Minimum 1 year experience in a market-leading CRM tool and implement campaigns on Unica Campaign Management system (UCMS), Unica Optimize or other Campaign management tool such as Chordiant or Adobe Campaign and etc.
• Expert UNICA user with in-depth knowledge of deploying Dynamic UNICA components such as Custom Macros, Pre-Defined Macros, User Variables, Derived Fields Table mapping, Audience levels and Writing SQL scripts.
• Good understanding of campaign reporting and Expert in Microsoft Excel to advance level. Able to create excel formulas to manipulate data and able to provide data insights.
• Ability to articulate analysis for a non-technical audience.
• Stakeholder management – works closely with commercial stakeholders in order to build & execute campaigns.
• Educated to a degree standard.
• Focused and diligent when delivering high quality solutions in a fast moving environment.
  Be able to solve problems using technology and quickly spot issues or opportunities amongst the detail.
• Strong communication skills and ability to work proactively and independently.
  CRM and Email marketing knowledge desirable.

Interview Process:
There will be two stages interview process:
1) An hour-long telephonic interview to discuss background, experience, requirements, and
candidates desired career path and fit for role. This should be seen as a two way exercise
and a chance for the candidate to get to know us as well.
2) A secondary face to face meeting to run through a number of technical and competency
based questions.

Send your CV to info@thytarget.co.uk