Data Quality: Practising what we preach -  Part 2
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


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

Post Comment


How big data is changing the way we live

There’s no question that big data is everywhere, it has been reported that two and a half quintillion bytes of data are created every day, and this amount is surely only going to rise in the future. Anything we, or... Read More

Why do the top sales people use CRM Systems?

For many sales businesses their CRM system can be the life and blood of the data they hold, but for many sales people using the CRM system can seem like just another tool the business makes them use and is... Read More

Tech & Tattoos

Wearable technology is nothing new, for quite some time we have been walking around with FitBits on our wrists monitoring our health, or smart watches that make payments easy. For many, wearable tech has become a normal part of life.... Read More

How to fix a broken leg

You break your leg, what do you do? You go to the hospital. Right? You get it X-rayed, plastered up and wait for it to heal. When it twinges and you say “ohh my leg ain’t half hurtin’ today” (in... Read More

Where should we send our newsletter?