By Mark Dexter
8th October 2012

A couple of months ago I blogged about a major data cleansing project we were embarking on to ensure our candidate information is current. Our apprentice Rachael has been well and truly initiated into the company with this assignment and her efforts have started to make a real difference to the quality of service that we provide to both clients and candidates.

We currently have more than 7,500 candidates registered on our recruitment database. Whether we spoke to them once several years ago or we know them really well, the one constant is that we have had contact with all of them since the database was established six years ago.

During this period a lot has happened and there will be many candidates who have changed roles significantly since we last had contact with them, some of them several times, and therefore some of our data is now out of date.

Subsequently, we have been through each candidate individually, contacting them to reintroduce ourselves and establish whether they still wanted to ‘opt-in’ and remain on our database, so that we can contact them about potential job opportunities.  At this point we either gathered current job and CV information or removed them from our records.

In most cases we have made contact with people quite easily, but in others we have had to make several attempts. The challenge has been deciding at what point we give up trying and simply delete them from our system.  We have gone for quality over quantity and would much rather have a smaller, accurate database of candidates - all of who are in the correct skill groups and want us to contact them. By having this detail it means that we can ensure we market to them appropriately, making contact only about positions that they actually specialise in.

What have we learned?

Since beginning the project in May, Rachael has made great progress, updating more than 5,000 records.

We have learned that contractors generally reply with CVs and availability details quite quickly, but it is a very different case when dealing with permanent workers as they generally have little interest unless they are thinking about looking for a new job.

We know how crucial it is to ensure that detailed information is input accurately in the first instance. Historically our software has done this automatically, so we have established a new system whereby Rachael goes through all new applicants to ensure the correct details and CVs are uploaded.

We have also found that people’s situations change very quickly and we need to keep on top of this on an on-going basis, so we will be looking for ways to constantly improve and better manage our data to ensure accuracy. This includes a system for not keeping people on our database indefinitely.

Also, often clients become candidates, and candidates become clients, so we have to ensure we are as up to date as possible with everybody’s situation to market to them appropriately.

What’s next?

Moving forward, we plan to maintain more up to date candidate addresses on our system so that we can implement location-based job alerts. We will also be keeping a closer eye on where people move and aspire to move, particularly those interested in or moving from contractor to permanent placement and vice versa.

For others attempting to embark on such a project, I would recommend resourcing appropriately as without Rachael’s 100% commitment we would be at a far earlier stage. Time is also a major consideration, so be realistic about how much you can achieve in a given time frame. One thing is certain though with regards to our data cleansing; now we have started we can’t stop. The more up to date we get the more we realise that our candidate data is constantly changing, not just now but forever!

Our industry is reliant on data and without it we cannot service our clients and candidates effectively, but it now plays a central role in the day-to-day operation of many organisations. Typically companies don’t just have one source of information, they have multiple, and therefore investing in time and resource to data cleanse is critical to business success.

In case you missed it - Data Quality; practising what we preach - part 1

Comments

Currently there are no comments. Be the first to post one!

Post Comment

*
*
*

Gaining a competitive edge with data analytics

It’s football season, and that means one thing in the KDR office – Fantasy Football. We have a league set up (called the KDR Cup) to see who has the best team in the office, and with most of us this... Read More

Big Data – The saviour of the ocean?

Big data is everywhere and having a major impact on much of the business world, it’s helping companies improve their customer service, products and more but can big data actually help the development of the world? My colleague James recently... Read More

What not to say at an interview

Whenever we send a candidate to an interview with a client we make sure they are fully prepped and ready to go, they know what questions they are going to ask and how to answer what they may be asked.... Read More

Are face-to-face interviews REALLY necessary for contractors?

Good contractors can be hard to come by, and making sure you hire someone who can complete the work on time and fit the company culture can be a challenge . To do this you may have a demanding recruitment process... Read More

Where should we send our newsletter?

Close