Excel VBA Data Analyst - Fixed Term Contract

Job Ref: 50195434
Sector: Data & Analytics
Job Type: Contract
Date Added: 11 September 2018
  • Cambridge, Cambridgeshire, England
  • £22,000 - £25,000 per Annum
    ANNUM
  • Allise Collins
  • 44 203 937 8425

Quick Apply

Request a callback

Send To A Friend

Excel VBA Data Analyst - Cambridgeshire

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.

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

Lorien
11/10/2018 08:17:14
GBP 22000 22000.