The table below looks at the statistics for Data Cleansing skills in IT contracts advertised for the City of London region. Included is a guide to the average contractor rates offered in IT contracts that have cited Data Cleansing over the 3 months to 1 May 2016 with a comparison to the same period in the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

3 months to
1 May 2016
Same period 2015 Same period 2014
Data Cleansing (Data Scrubbing)
Rank 148 170 189
Rank change year-on-year
+22 +19
Contract jobs citing Data Cleansing 9 31 21
As % of all contract IT jobs located in the City of London 0.26% 0.55% 0.34%
As % of the Processes & Methodologies category 0.30% 0.69% 0.42%
Number of daily rates quoted 7 31 12
Average daily rate £475 £363 £450
Average daily rate % change year-on-year
+31.03% -19.48%
90% offered a daily rate of more than £433 £300 £157
10% offered a daily rate of more than £560 £475 £595
UK excluding London average daily rate £425 £375 £390
% change year-on-year
+13.33% -3.84%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate £16.00 £33.67 £17.25
% change year-on-year
-52.47% +95.15%
Data Cleansing
London

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in contract jobs advertised in the City of London region.

Processes & Methodologies Category
City of London
Contract IT job ads with a match in the
Processes & Methodologies category
2959 4515 4980
As % of all contract IT jobs located in the City of London 84.76% 80.58% 79.74%
Number of daily rates quoted 2397 3527 3669
Average daily rate £475 £463 £450
Average daily rate % change year-on-year
+2.70% +2.77%
90% offered a daily rate of more than £330 £320 £300
10% offered a daily rate of more than £625 £601 £625
UK excluding London average daily rate £400 £388 £375
% change year-on-year
+3.22% +3.33%
Number of hourly rates quoted 26 41 48
Average hourly rate £19.00 £27.37 £23.50
Average hourly rate % change year-on-year
-30.58% +16.46%
90% offered a hourly rate of more than £16.75 £13.50 £12.95
10% offered a hourly rate of more than £41.26 £92.50 £47.50
UK excluding London average hourly rate £36.00 £30.50 £31.50
% change year-on-year
+18.03% -3.17%

Data Cleansing
Jobs Demand Trend in the City of London

This chart provides a 3-month moving total of IT contractor jobs citing Data Cleansing across the City of London region as a proportion of the total demand within the Processes & Methodologies category.

Data Cleansing Jobs Demand Trend in the City of London

Data Cleansing
Daily Rate Trend in the City of London

This chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing Data Cleansing across the City of London region.

Data Cleansing Daily Rate Trend in the City of London

Data Cleansing
Daily Rate Histogram in the City of London

This chart provides a histogram of daily rates quoted in contract IT jobs citing Data Cleansing across the City of London region over the 3 months to 1 May 2016.

Data Cleansing Daily Rate Histogram in the City of London

Data Cleansing
Hourly Rate Trend in the City of London

This chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing Data Cleansing across the City of London region.

Data Cleansing Hourly Rate Trend in the City of London

Data Cleansing
Top 30 Related IT Skills in the City of London

For the 6 months to 1 May 2016, IT contractor jobs across the City of London region citing Data Cleansing also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Data Cleansing.

1 13 (54.17%) Migration
2 10 (41.67%) Finance
2 10 (41.67%) Data Migration
3 8 (33.33%) SQL
3 8 (33.33%) Data Warehouse
4 7 (29.17%) Data Quality
5 5 (20.83%) Data Modelling
5 5 (20.83%) Data Management
6 4 (16.67%) Legal
6 4 (16.67%) VBA
6 4 (16.67%) CRM
6 4 (16.67%) Microsoft
6 4 (16.67%) Data Integration
7 3 (12.50%) Scala
7 3 (12.50%) Hadoop
7 3 (12.50%) BDD
7 3 (12.50%) MongoDB
7 3 (12.50%) Big Data
7 3 (12.50%) Elasticsearch
7 3 (12.50%) Enterprise Data Warehouse
7 3 (12.50%) Business Intelligence
7 3 (12.50%) Shell Script
7 3 (12.50%) Unix
7 3 (12.50%) ETL
7 3 (12.50%) MS Excel
7 3 (12.50%) Validation
7 3 (12.50%) Agile Software Development
7 3 (12.50%) TDD
7 3 (12.50%) Data Analysis
8 2 (8.33%) Dynamics CRM

Data Cleansing
Top Related IT Skills in the City of London by Category

For the 6 months to 1 May 2016, IT contractor jobs across the City of London region citing Data Cleansing also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Data Cleansing. Up to 20 skills are shown per category.

Application Platforms
1 3 (12.50%) Elasticsearch
2 1 (4.17%) Apache Spark
2 1 (4.17%) SAS
Applications
1 3 (12.50%) MS Excel
2 1 (4.17%) MS Office
2 1 (4.17%) MS Project
2 1 (4.17%) MS Visio
Business Applications
1 2 (8.33%) Dynamics CRM
Database & Business Intelligence
1 8 (33.33%) Data Warehouse
2 3 (12.50%) Big Data
2 3 (12.50%) Enterprise Data Warehouse
2 3 (12.50%) Hadoop
2 3 (12.50%) MongoDB
3 2 (8.33%) Apache Hive
3 2 (8.33%) CouchDB
3 2 (8.33%) Data Mining
3 2 (8.33%) GIS
3 2 (8.33%) Impala
3 2 (8.33%) Spark SQL
3 2 (8.33%) Sqoop
4 1 (4.17%) Base SAS
4 1 (4.17%) Microsoft Analysis Services
4 1 (4.17%) MS Access
4 1 (4.17%) Relational Database
4 1 (4.17%) SAP BW
4 1 (4.17%) SQL Server
4 1 (4.17%) SQL Server Analysis Services
4 1 (4.17%) SQL Server Reporting Services
General
1 10 (41.67%) Finance
2 4 (16.67%) Legal
3 2 (8.33%) Marketing
4 1 (4.17%) Banking
4 1 (4.17%) Billing
4 1 (4.17%) Financial Institution
4 1 (4.17%) Law
4 1 (4.17%) Telecoms
Job Titles
1 15 (62.50%) Analyst
2 11 (45.83%) Data Analyst
3 4 (16.67%) Project Manager
4 3 (12.50%) Business Analyst
4 3 (12.50%) CRM Analyst
4 3 (12.50%) Developer
4 3 (12.50%) Scala Developer
5 2 (8.33%) Data Business Analyst
5 2 (8.33%) Data Migration Analyst
5 2 (8.33%) Excel Analyst
5 2 (8.33%) Governance Manager
5 2 (8.33%) Migration Analyst
5 2 (8.33%) Mobile Project Manager
5 2 (8.33%) Project Governance Manager
5 2 (8.33%) SQL Analyst
6 1 (4.17%) Business Strategist
6 1 (4.17%) Insurance Business Analyst
6 1 (4.17%) Quality Analyst
6 1 (4.17%) SAP Tester
6 1 (4.17%) SAS Analyst
Libraries, Frameworks & Software Standards
1 2 (8.33%) Lucene
2 1 (4.17%) GraphX
2 1 (4.17%) MDX
2 1 (4.17%) XML
Miscellaneous
1 4 (16.67%) Data Integration
2 2 (8.33%) Mobile App
2 2 (8.33%) Reinsurance
3 1 (4.17%) Analytical Skills
3 1 (4.17%) Data Conversion
3 1 (4.17%) Management Information System
3 1 (4.17%) Reference Data
Operating Systems
1 3 (12.50%) Unix
2 1 (4.17%) Windows
Processes & Methodologies
1 13 (54.17%) Migration
2 10 (41.67%) Data Migration
3 5 (20.83%) Data Management
3 5 (20.83%) Data Modelling
4 4 (16.67%) CRM
5 3 (12.50%) Agile Software Development
5 3 (12.50%) BDD
5 3 (12.50%) Business Intelligence
5 3 (12.50%) Data Analysis
5 3 (12.50%) ETL
5 3 (12.50%) TDD
5 3 (12.50%) Validation
6 2 (8.33%) Information Management
6 2 (8.33%) Information Security
6 2 (8.33%) Logical Data Model
6 2 (8.33%) Parallel Processing
6 2 (8.33%) Physical Data Model
6 2 (8.33%) Project Management
6 2 (8.33%) Risk Assessment
6 2 (8.33%) WFM
Programming Languages
1 8 (33.33%) SQL
2 4 (16.67%) VBA
3 3 (12.50%) Scala
3 3 (12.50%) Shell Script
4 1 (4.17%) T-SQL
Qualifications
1 2 (8.33%) ACCA
1 2 (8.33%) CIMA
Quality Assurance & Compliance
1 7 (29.17%) Data Quality
2 2 (8.33%) QA
3 1 (4.17%) PCI DSS
System Software
1 2 (8.33%) Apache Flume
Vendors
1 4 (16.67%) Microsoft
2 1 (4.17%) Bloomberg
2 1 (4.17%) Google
2 1 (4.17%) Murex
2 1 (4.17%) SAP
2 1 (4.17%) Tableau
2 1 (4.17%) WorldPay