Data Insight Analyst

  • Location

    London, England

  • Sector:

    Data

  • Job type:

    Contract

  • Salary:

    £400 - £450.00 per day

  • Contact:

    James Jarvis

  • Contact email:

    james.jarvis@xcede.co.uk

  • Job ref:

    HQ00023787_1546964013

  • Published:

    2 months ago

  • Duration:

    3-6 Months

  • Expiry date:

    2019-03-09

  • Startdate:

    ASAP

  • Consultant:

    #

DATA ANALYST / SQL PROGRAMMING / ATHENA / HIVE / PRESTO / CRM / CAMPAIGN

Data Analyst
Location: London
Start: Early Jan
Duration: 3-6 Months
Rate: £400-450PD

Purpose of role:

Working in the data team - The Data and Insight team is looking for a campaign analyst to support campaign selections and change programme work using data analysis skills including SQL coding

Key responsibilities and accountabilities:

*Execute counts and selections for complex campaigns
*Write efficient SQL to query huge datasets, extract insight and summarise and communicate findings across the business
*Communicate learnings to technical and non-technical audiences
*Build customer segments for campaign targeting, customer acquisition, campaign optimisation, cross sell strategies etc and undertake data selections for CRM campaign activity for internal stakeholders
*Run post campaign reports, at individual and aggregate level to improve campaign performance/ effectiveness (response rates, profitability etc.)
*Analyse data for marketing purposes, including customer profiling and campaign response
*Key contact for routine and ad-hoc data and counts requests
*Provide recommendations to stakeholders about how best to use the data for targeting and other marketing goals
*Accountable for the accuracy and quality of data provided

Knowledge and experience:

*Excellent knowledge of SQL programming
*Experience of working with Presto, Athena and/or Hive
*Comfortable working with large and complex data sets
*Stakeholder management experience
*Knowledge and experience of relational databases
*Ability to conduct data extraction
*Experience of CRM and campaign management process
*Experience of Microsoft Excel (Intermediate to Advanced)
*Experience of Campaign management tools