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.
* 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
* Pivot tables
* Ability to stay organised and work within a fast paced environment