Connecting...

Data Analyst | Marketing Agency

Job Title: Data Analyst | Marketing Agency
Contract Type: Permanent
Location: Birmingham, West Midlands
Industry:
Salary: £30000.00 - £40000.00 per annum
Start Date: ASAP
Reference: P7714
Contact Name: Jess Hill
Contact Email: jess@pitchconsultants.co.uk
Job Published: June 21, 2018 07:00

Job Description

Leading full service marketing agency are on the hunt for an experienced Data Analyst to join their Birmingham team to work on a leading UK retail account.

A top full service marketing agency with a fantastic reputation across the UK with various offices and on-site teams they employ over a couple hundred people. They work with a list of big name international and national brands that will be sure to impress. Culturally they consist of a team of ambitious and driven specialists who deliver first class customer service for their clients. They are now looking for a talented Data Analyst to work on a well known national UK retailer.

Key Responsibilities:

* Take raw data and perform hygiene operations to clear up irregularities and process the input data through a range of transformations and VBA scripts

* Maintain existing excel data tables

* Complex multivariable allocations in Excel

* Data cleansing on Excel

* Analyse data within spreadsheets

* Liaise with suppliers and clients to manage queries

* Investigate errors in data

The Ideal Candidate:

* Highly experienced with Microsoft Excel formulas including:

* Nested INDEX MATCH

* ARRAYS

* LOOKUPS

* OFFSET

* Pivot tables

* Ability to stay organised and work within a fast paced environment

Apply now!

AA123