Excel Database Administrator - Farnham, United Kingdom - Cornucopia IT Resourcing

Cornucopia IT Resourcing

Verified Company

Farnham, United Kingdom

2 weeks ago

Posted by:

Tom O´Connor

beBee Recruiter

Description

Excel Database Administrator
Cornucopia are partnering with a business on the rise in the property surveying sector, based in Farnham.

The Position

Working mainly with MS Excel you will need to find and manipulate data within Excel and have experience with MS Access.

With our continual expansion we require help processing the day to day requests of the office staff

Duties will include:

Export data from an Azure based Postgres database and present it for staff to interrogate and validate
Import data from staff members back into MS Access database ready for client report generation
Liaise with surveyors and deal with their IT needs (allocate new works schedules, log work progress)
Manipulate client address lists and format into a something we can use
Prepare address lists ready for Postgres and Blob storage upload
General Ad-Hoc duties when needed

Skills Required:

Excellent Microsoft Excel Skills (xlookup, vlookup, concat, filters, shortcust, macros, VBA)
Good database design and query understanding
Helpful VBA skills
Methodical in approach to dealing with problems