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 contractor rates offered in IT contracts that have cited Data Cleansing over the 3 months to 10 December 2016 with a comparison to the same period over 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
10 Dec 2016
Same period 2015 Same period 2014
Data Cleansing (Data Cleaning, Data Scrubbing)
Rank 144 130 170
Rank change year-on-year
-14 +40
Contract jobs citing Data Cleansing 22 24 30
As % of all contract IT jobs located in the City of London 0.70% 0.70% 0.52%
As % of the Processes & Methodologies category 0.80% 0.83% 0.65%
Number of daily rates quoted 17 21 24
Median daily rate £575 £350 £444
Median daily rate % change year-on-year
+64.28% -21.12%
90% offered a daily rate of more than £150 £320 £306
10% offered a daily rate of more than £610 £600 £500
UK excluding London median daily rate £419 £400 £350
% change year-on-year
+4.68% +14.28%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £19.72 £11.31 £10.50
% change year-on-year
+74.43% +7.66%
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
2757 2881 4626
As % of all contract IT jobs located in the City of London 87.11% 84.39% 80.51%
Number of daily rates quoted 2183 2311 3625
Median daily rate £500 £475 £450
Median daily rate % change year-on-year
+5.26% +5.55%
90% offered a daily rate of more than £363 £310 £313
10% offered a daily rate of more than £650 £650 £625
UK excluding London median daily rate £413 £400 £385
% change year-on-year
+3.12% +3.89%
Number of hourly rates quoted 27 21 49
Median hourly rate £26.25 £24.50 £18.00
Median hourly rate % change year-on-year
+7.14% +36.11%
90% offered a hourly rate of more than £14.50 £18.70 £10.80
10% offered a hourly rate of more than £55.00 £53.00 £43.75
UK excluding London median hourly rate £30.00 £34.00 £25.00
% change year-on-year
-11.76% +36.00%

Data Cleansing
Jobs Demand Trend in the City of London

The demand trend of contract jobs across the City of London region citing Data Cleansing as a proportion of all IT contracts with a match in 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 10 December 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 10 December 2016, 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 City of London region with a requirement for Data Cleansing.

1 17 (50.00%) Data Analysis
2 16 (47.06%) Data Quality
2 16 (47.06%) SQL
3 15 (44.12%) Data Modelling
3 15 (44.12%) ETL
4 11 (32.35%) Migration
4 11 (32.35%) Data Migration
5 10 (29.41%) Statistics
6 8 (23.53%) Data Warehouse
7 7 (20.59%) MS Excel
7 7 (20.59%) Data Management
7 7 (20.59%) Relational Database
8 6 (17.65%) Finance
9 5 (14.71%) Stakeholder Management
9 5 (14.71%) Management Information System
9 5 (14.71%) Microsoft
9 5 (14.71%) Data Entry
9 5 (14.71%) JIRA
9 5 (14.71%) Agile Software Development
10 4 (11.76%) Reference Data
10 4 (11.76%) SaaS
10 4 (11.76%) Workday HCM
10 4 (11.76%) ERwin
10 4 (11.76%) Business Intelligence
10 4 (11.76%) Legal
10 4 (11.76%) Data Ingestion
10 4 (11.76%) Workday
11 3 (8.82%) Data Governance
11 3 (8.82%) ERP
11 3 (8.82%) CRM

Data Cleansing
Top Related IT Skills in the City of 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 2 (5.88%) SAS
2 1 (2.94%) Apache Spark
2 1 (2.94%) Confluence
2 1 (2.94%) WebLogic
Applications
1 7 (20.59%) MS Excel
2 2 (5.88%) MS Project
2 2 (5.88%) MS Visio
3 1 (2.94%) Spreadsheet
Business Applications
1 4 (11.76%) Workday HCM
2 1 (2.94%) Dynamics CRM
2 1 (2.94%) Dynamics GP
2 1 (2.94%) Dynamics NAV
2 1 (2.94%) Oracle Assets
2 1 (2.94%) Oracle Cash Management
2 1 (2.94%) Oracle Payables
2 1 (2.94%) Oracle Receivables
2 1 (2.94%) Salesforce.com CRM
Cloud Services
1 4 (11.76%) SaaS
2 1 (2.94%) SuccessFactors
Database & Business Intelligence
1 8 (23.53%) Data Warehouse
2 7 (20.59%) Relational Database
3 3 (8.82%) Big Data
3 3 (8.82%) SQL Server
4 2 (5.88%) SQL Server Analysis Services
4 2 (5.88%) SQL Server Integration Services
4 2 (5.88%) SQL Server Reporting Services
5 1 (2.94%) Base SAS
5 1 (2.94%) Hadoop
5 1 (2.94%) OLTP
5 1 (2.94%) Oracle Database
5 1 (2.94%) Oracle Database 11g
5 1 (2.94%) Oracle Database 12c
5 1 (2.94%) Oracle ODI
5 1 (2.94%) Qlik Sense
5 1 (2.94%) QlikView
5 1 (2.94%) SQL Server 2008
5 1 (2.94%) SQL Server 2014
5 1 (2.94%) SQL Server 2016
Development Applications
1 5 (14.71%) JIRA
2 4 (11.76%) ERwin
3 1 (2.94%) Git (software)
3 1 (2.94%) Jenkins
3 1 (2.94%) Sonatype Nexus
3 1 (2.94%) Talend Open Studio
General
1 6 (17.65%) Finance
2 4 (11.76%) Legal
3 2 (5.88%) Billing
3 2 (5.88%) Law
3 2 (5.88%) Marketing
3 2 (5.88%) Retail
4 1 (2.94%) General Ledger
Job Titles
1 16 (47.06%) Analyst
2 13 (38.24%) Data Analyst
3 5 (14.71%) Architect
4 4 (11.76%) Data Architect
4 4 (11.76%) Data Cleansing Analyst
5 3 (8.82%) Big Data Architect
5 3 (8.82%) Developer
6 2 (5.88%) Big Data Analyst
6 2 (5.88%) Data Migration Specialist
6 2 (5.88%) ETL Analyst
6 2 (5.88%) ETL Architect
6 2 (5.88%) Migration Specialist
6 2 (5.88%) SQL Analyst
6 2 (5.88%) SQL Data Analyst
6 2 (5.88%) Team Leader
7 1 (2.94%) Business Intelligence Analyst
7 1 (2.94%) Business Intelligence Developer
7 1 (2.94%) Customer Analyst
7 1 (2.94%) Data Integration Analyst
7 1 (2.94%) Integration Analyst
Libraries, Frameworks & Software Standards
1 1 (2.94%) MDX
1 1 (2.94%) Middleware
1 1 (2.94%) XML
1 1 (2.94%) XML Schema
1 1 (2.94%) XSD
1 1 (2.94%) XSL
1 1 (2.94%) XSLT
Miscellaneous
1 10 (29.41%) Statistics
2 5 (14.71%) Management Information System
3 4 (11.76%) Reference Data
4 3 (8.82%) Analytical Skills
4 3 (8.82%) Data Integration
5 1 (2.94%) Computer Science
5 1 (2.94%) Data Conversion
5 1 (2.94%) NHS
Operating Systems
1 1 (2.94%) Linux
1 1 (2.94%) Windows
Processes & Methodologies
1 17 (50.00%) Data Analysis
2 15 (44.12%) Data Modelling
2 15 (44.12%) ETL
3 11 (32.35%) Data Migration
3 11 (32.35%) Migration
4 7 (20.59%) Data Management
5 5 (14.71%) Agile Software Development
5 5 (14.71%) Data Entry
5 5 (14.71%) Stakeholder Management
6 4 (11.76%) Business Intelligence
6 4 (11.76%) Data Ingestion
7 3 (8.82%) CRM
7 3 (8.82%) Data Governance
7 3 (8.82%) ERP
8 2 (5.88%) Analytics
8 2 (5.88%) E-Commerce
8 2 (5.88%) Translating Business Requirements
9 1 (2.94%) Data Acquisition
9 1 (2.94%) Data Engineering
9 1 (2.94%) Performance Tuning
Programming Languages
1 16 (47.06%) SQL
2 2 (5.88%) T-SQL
3 1 (2.94%) PL/SQL
3 1 (2.94%) R
3 1 (2.94%) Scala
3 1 (2.94%) Shell Script
3 1 (2.94%) VBA
Qualifications
1 1 (2.94%) Degree
Quality Assurance & Compliance
1 16 (47.06%) Data Quality
2 2 (5.88%) QA
Vendors
1 5 (14.71%) Microsoft
2 4 (11.76%) Workday
3 3 (8.82%) Oracle
4 2 (5.88%) Salesforce.com
4 2 (5.88%) SAP
4 2 (5.88%) Tableau
5 1 (2.94%) Informatica
5 1 (2.94%) MicroStrategy
5 1 (2.94%) Talend
5 1 (2.94%) WorldPay