Period
to 23 November 2017

The following table provides summary statistics for contract job vacancies advertised in London with a requirement for Data Cleansing skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Data Cleansing over the 6 months to 23 November 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Data Cleansing (Data Cleaning, Data Scrubbing)
England > London
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 430 443 455
Rank change year-on-year +13 +12 -56
Contract jobs citing Data Cleansing 211 177 174
As % of all contract IT jobs advertised in London 0.45% 0.39% 0.37%
As % of the Processes & Methodologies category 0.52% 0.45% 0.45%
Number of daily rates quoted 131 115 117
London median daily rate £450 £460 £400
Median daily rate % change year-on-year -2.17% +15.00% -5.33%
10th Percentile £275 £231 £213
90th Percentile £625 £639 £548
England median daily rate £425 £435 £388
% change year-on-year -2.38% +12.35% -3.13%
Number of hourly rates quoted 1 7 3
London median hourly rate £28.50 £20.00 £16.00
Median hourly rate % change year-on-year +42.50% +25.00% -84.76%
England median hourly rate £23.75 £20.00 £15.50
% change year-on-year +18.75% +29.03% -5.73%

Data Cleansing is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in London with a requirement for process or methodology skills.

All Process and Methodology Skills
London
Contract vacancies with a requirement for process or methodology skills 40964 38955 39069
As % of all contract IT jobs advertised in London 86.95% 86.20% 83.83%
Number of daily rates quoted 29788 27920 27910
London median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.56% +2.86%
10th Percentile £313 £306 £288
90th Percentile £675 £643 £638
England median daily rate £450 £425 £425
% change year-on-year +5.88% - +6.25%
Number of hourly rates quoted 382 408 469
London median hourly rate £22.50 £21.77 £20.00
Median hourly rate % change year-on-year +3.38% +8.83% +11.11%
10th Percentile £13.32 £12.25 £11.25
90th Percentile £53.45 £50.04 £50.00
England median hourly rate £24.00 £24.00 £22.50
% change year-on-year - +6.67% +18.42%

Data Cleansing
Job Vacancy Trend in London

Job postings citing Data Cleansing as a percentage of all IT jobs advertised in London.

Job vacancy trend for Data Cleansing in London

Data Cleansing
Contractor Daily Rate Trend in London

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

Contractor daily rate trend for Data Cleansing in London

Data Cleansing
Contractor Daily Rate Histogram in London

The daily rate distribution of IT jobs citing Data Cleansing in London over the 6 months to 23 November 2017.

Contractor daily rate histogram for Data Cleansing in London

Data Cleansing
Contractor Hourly Rate Trend in London

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

Contractor hourly rate trend for Data Cleansing in London

Data Cleansing
Contract Job Locations in London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Data Cleansing within the London region over the 6 months to 23 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Central London +6 48 £450 -1.10% 5
West London -8 4 £400 -1.84%
South London -36 2 - -
East London -9 1 £700 +17.65%
Data Cleansing
England

For the 6 months to 23 November 2017, IT contractor jobs citing Data Cleansing also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the London region with a requirement for Data Cleansing.

1 101 (47.87%) SQL
2 86 (40.76%) Data Modelling
3 80 (37.91%) Migration
4 78 (36.97%) Data Migration
5 76 (36.02%) Data Quality
6 61 (28.91%) ETL
7 60 (28.44%) Oracle
8 54 (25.59%) Finance
8 54 (25.59%) Security Cleared
8 54 (25.59%) Relational Database
9 51 (24.17%) Business Intelligence
10 50 (23.70%) Data Analysis
11 44 (20.85%) Big Data
12 42 (19.91%) Data Transformation
12 42 (19.91%) Collaborative Working
13 39 (18.48%) Coaching
14 37 (17.54%) Analytics
14 37 (17.54%) Java
15 36 (17.06%) Agile Software Development
16 35 (16.59%) Microsoft
17 34 (16.11%) SQL Server
17 34 (16.11%) XML
18 32 (15.17%) JSON
19 31 (14.69%) Analytical Skills
20 30 (14.22%) Post-Production
20 30 (14.22%) PL/SQL
21 28 (13.27%) Hadoop
21 28 (13.27%) Amazon AWS
22 27 (12.80%) DV Cleared
23 26 (12.32%) CRM

Data Cleansing
Co-occurring IT Skills in London by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 20 (9.48%) Apache
2 9 (4.27%) Apache Spark
2 9 (4.27%) SharePoint
3 5 (2.37%) Oracle Workflow
4 4 (1.90%) Elasticsearch
4 4 (1.90%) SAS
5 3 (1.42%) Apache Pig
6 2 (0.95%) IBM Notes
6 2 (0.95%) SharePoint 2010
6 2 (0.95%) SharePoint 2013
7 1 (0.47%) Confluence
7 1 (0.47%) Jupyter
7 1 (0.47%) Oracle SOA Suite
7 1 (0.47%) SugarCRM
Applications
1 24 (11.37%) Microsoft Excel
2 13 (6.16%) MS Visio
3 12 (5.69%) Microsoft Office
4 11 (5.21%) Microsoft Project
5 8 (3.79%) InfoPath
6 5 (2.37%) Microsoft PowerPoint
6 5 (2.37%) SPSS
7 1 (0.47%) Spreadsheet
Business Applications
1 10 (4.74%) Dynamics CRM
2 3 (1.42%) Markit EDM
2 3 (1.42%) SAP CO
2 3 (1.42%) SAP ERP
2 3 (1.42%) SAP FI
2 3 (1.42%) SAP FI/CO
3 2 (0.95%) Dynamics AX
3 2 (0.95%) Eloqua
3 2 (0.95%) Oracle TCA
3 2 (0.95%) Raiser's Edge
3 2 (0.95%) Salesforce.com CRM
4 1 (0.47%) Investran
4 1 (0.47%) Relativity
4 1 (0.47%) SAP CRM
Cloud Services
1 28 (13.27%) Amazon AWS
2 8 (3.79%) Microsoft Azure
3 3 (1.42%) Dynamics 365
4 2 (0.95%) Azure Data Factory
4 2 (0.95%) Google Cloud Platform
5 1 (0.47%) GitHub
5 1 (0.47%) Office 365
5 1 (0.47%) Salesforce Sales Cloud
Communications & Networking
1 3 (1.42%) Wi-Fi
2 2 (0.95%) SNA
3 1 (0.47%) Kerberos
3 1 (0.47%) SMS
Database & Business Intelligence
1 54 (25.59%) Relational Database
2 44 (20.85%) Big Data
3 34 (16.11%) SQL Server
4 28 (13.27%) Hadoop
5 23 (10.90%) Oracle Database
6 21 (9.95%) Data Warehouse
6 21 (9.95%) SQL Server Integration Services
7 18 (8.53%) HBase
8 13 (6.16%) Data Mining
9 11 (5.21%) Power BI
10 9 (4.27%) PostgreSQL
11 8 (3.79%) MySQL
11 8 (3.79%) QlikView
12 7 (3.32%) Amazon RDS
12 7 (3.32%) Oracle Reports
12 7 (3.32%) RDBMS
12 7 (3.32%) SQL Server Analysis Services
13 6 (2.84%) Oracle Database 11g
13 6 (2.84%) SQL Server 2012
13 6 (2.84%) SQL Server 2016
Development Applications
1 10 (4.74%) JIRA
2 8 (3.79%) Talend Open Studio
3 5 (2.37%) Visual Studio
4 4 (1.90%) Rational Rhapsody
4 4 (1.90%) Team Foundation Server
5 3 (1.42%) ERwin
6 1 (0.47%) Cucumber
6 1 (0.47%) Git (software)
6 1 (0.47%) GitLab
General
1 54 (25.59%) Finance
2 20 (9.48%) Banking
3 12 (5.69%) Marketing
4 11 (5.21%) Legal
5 10 (4.74%) Law
5 10 (4.74%) Telecoms
6 6 (2.84%) Electronics
6 6 (2.84%) Manufacturing
6 6 (2.84%) Pharmaceutical
6 6 (2.84%) Retail
7 4 (1.90%) Financial Institution
7 4 (1.90%) Front Office
7 4 (1.90%) Publishing
8 2 (0.95%) Investment Banking
9 1 (0.47%) Advertising
9 1 (0.47%) Back Office
9 1 (0.47%) Billing
9 1 (0.47%) Retail Banking
Job Titles
1 57 (27.01%) Analyst
2 49 (23.22%) Developer
3 30 (14.22%) Data Analyst
4 24 (11.37%) Business Analyst
5 20 (9.48%) Oracle Developer
6 17 (8.06%) SQL Developer
7 15 (7.11%) Consultant
8 14 (6.64%) Architect
9 13 (6.16%) DBA
9 13 (6.16%) Oracle DBA
10 12 (5.69%) Data Migration Specialist
10 12 (5.69%) Migration Specialist
11 11 (5.21%) Data Architect
12 10 (4.74%) Data Manager
13 9 (4.27%) Legal Analyst
13 9 (4.27%) PL/SQL Developer
14 8 (3.79%) Business Intelligence Developer
14 8 (3.79%) DevOps Engineer
15 7 (3.32%) Big Data Developer
15 7 (3.32%) Data Scientist
Libraries, Frameworks & Software Standards
1 34 (16.11%) XML
2 32 (15.17%) JSON
3 20 (9.48%) Kafka
4 18 (8.53%) JMS
5 5 (2.37%) .NET
5 5 (2.37%) Oracle GoldenGate
6 4 (1.90%) .NET Framework
7 3 (1.42%) MDX
7 3 (1.42%) Middleware
7 3 (1.42%) MLlib
7 3 (1.42%) NumPy
7 3 (1.42%) Pandas
7 3 (1.42%) RHadoop
7 3 (1.42%) scikit-learn
7 3 (1.42%) Web Services
8 2 (0.95%) GraphX
8 2 (0.95%) Lucene
8 2 (0.95%) Natural Language Processing
8 2 (0.95%) REST
8 2 (0.95%) TensorFlow
Miscellaneous
1 31 (14.69%) Analytical Skills
2 20 (9.48%) Data Structures
3 12 (5.69%) Management Information System
4 8 (3.79%) Blog
5 6 (2.84%) Reference Data
6 5 (2.37%) Computer Science
7 4 (1.90%) Algorithms
7 4 (1.90%) Life Science
8 3 (1.42%) Digital Media
8 3 (1.42%) Taxonomies
9 2 (0.95%) CMDB
9 2 (0.95%) Fixed Income
9 2 (0.95%) Private Cloud
9 2 (0.95%) Replication
9 2 (0.95%) Social Network
10 1 (0.47%) Data Protection Act
10 1 (0.47%) FMCG
10 1 (0.47%) Hybrid Cloud
10 1 (0.47%) Tandem
10 1 (0.47%) User Experience
Operating Systems
1 15 (7.11%) Unix
2 14 (6.64%) Linux
3 8 (3.79%) Mac OS X
Processes & Methodologies
1 86 (40.76%) Data Modelling
2 80 (37.91%) Migration
3 78 (36.97%) Data Migration
4 61 (28.91%) ETL
5 51 (24.17%) Business Intelligence
6 50 (23.70%) Data Analysis
7 42 (19.91%) Collaborative Working
7 42 (19.91%) Data Transformation
8 39 (18.48%) Coaching
9 37 (17.54%) Analytics
10 36 (17.06%) Agile Software Development
11 30 (14.22%) Post-Production
12 26 (12.32%) CRM
13 22 (10.43%) Logical Data Model
14 21 (9.95%) Data Integration
15 20 (9.48%) Data Management
15 20 (9.48%) Data Mapping
15 20 (9.48%) User Acceptance Testing
16 19 (9.00%) Data Architecture
16 19 (9.00%) MapReduce
Programming Languages
1 101 (47.87%) SQL
2 37 (17.54%) Java
3 30 (14.22%) PL/SQL
4 22 (10.43%) Python
5 14 (6.64%) R
6 11 (5.21%) VBA
7 8 (3.79%) T-SQL
8 5 (2.37%) Apex Code
8 5 (2.37%) MATLAB
9 4 (1.90%) C#
9 4 (1.90%) Data Analysis Expressions (DAX)
9 4 (1.90%) Scala
9 4 (1.90%) Shell Script
9 4 (1.90%) VB
10 2 (0.95%) PHP
11 1 (0.47%) C
11 1 (0.47%) Groovy
11 1 (0.47%) VB.NET
Qualifications
1 54 (25.59%) Security Cleared
2 27 (12.80%) DV Cleared
3 21 (9.95%) SC Cleared
4 10 (4.74%) Degree
5 6 (2.84%) CTC Cleared
6 4 (1.90%) Computer Science Degree
7 2 (0.95%) ITIL Certification
8 1 (0.47%) Numerate Degree
Quality Assurance & Compliance
1 76 (36.02%) Data Quality
2 6 (2.84%) GDPR
3 5 (2.37%) QA
4 3 (1.42%) PMO
5 2 (0.95%) SLA
5 2 (0.95%) Solvency II
System Software
1 14 (6.64%) Oracle Clusterware
1 14 (6.64%) Oracle RAC
2 2 (0.95%) Apache Flume
3 1 (0.47%) HDFS
Systems Management
1 14 (6.64%) Data Guard
1 14 (6.64%) Oracle Flashback
1 14 (6.64%) Oracle RMAN
Vendors
1 60 (28.44%) Oracle
2 35 (16.59%) Microsoft
3 19 (9.00%) SAP
4 15 (7.11%) Salesforce.com
5 8 (3.79%) Tableau
5 8 (3.79%) Talend
6 6 (2.84%) Informatica
7 4 (1.90%) Yardi
8 3 (1.42%) Bloomberg
8 3 (1.42%) Google
8 3 (1.42%) Marketo
9 2 (0.95%) CA
9 2 (0.95%) Greenplum
9 2 (0.95%) IBM
9 2 (0.95%) Jaspersoft
9 2 (0.95%) Lotus
9 2 (0.95%) Palantir
9 2 (0.95%) ServiceNow
9 2 (0.95%) SmartStream
9 2 (0.95%) TIBCO