Excel VBA Data Analyst - £15 per hour

Job Ref: 50188366
Sector: Data & Analytics
Date Added: 22 December 2017
  • Hertfordshire, England
  • £10 - £15 per Hour
  • Henry Wilson
  • 0207 654 1117

Quick Apply

Request a callback

Send To A Friend

Excel VBA Data Analyst - Hertfordshire

My client is a Large Manufacturing Company who are currently looking to recruit a VBA Data Analyst

The key responsibilities for this role includes:

  • Collating, transforming and cleansing existing data that are contained in numerous Excel spreadsheets into standardised data sets, in the required structure and format needed to import the data into the platform.
  • The data is largely text based, so you will need to be proficient in manipulating, reformatting, cleansing, rationalising, de-duplicating and restructuring text as well as numeric data to create standardised data sets
  • Create test data sets to validate and stress test the system.
  • Develop efficient routes to manipulate and restructure the data as well as tools to automate tasks and assure quality at each step. Documentation any tools developed for future use to support wider deployment.

The key experience and knowledge required for this role includes:

  • Proficient in the use of Excel to manipulate, cleanse and restructure text and numeric information using Excel macros and VBA
  • Proficient in validating and proof reading data sets and documentation.
  • Close attention to detail to ensure data and structures are accurate and meet all requirements at each stage of the transformation process.

This is a contract role working for a top company as a VBA Data Analyst.

To apply please contact:

Henry Wilson

Lorien

0207 654 1117

Henry.Wilson@lorien.co.uk

We are an equal opportunities employer and welcome applications from all suitably qualified persons regardless of their race, sex, disability, religion/belief, sexual orientation, gender reassignment, marriage and civil partnerships, pregnancy or maternity or age