The table below looks at the statistics for Data Cleansing skills in IT contracts advertised for the London region. Included is a guide to the contractor rates offered in IT contracts that have cited Data Cleansing over the 3 months to 6 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
6 Dec 2016
Same period 2015 Same period 2014
Data Cleansing (Data Cleaning, Data Scrubbing)
Rank 335 325 309
Rank change year-on-year
-10 -16
Contract jobs citing Data Cleansing 96 104 120
As % of all contract IT jobs located in London 0.44% 0.47% 0.51%
As % of the Processes & Methodologies category 0.51% 0.56% 0.63%
Number of daily rates quoted 61 73 79
Median daily rate £500 £425 £425
Median daily rate % change year-on-year
+17.64% -
90% offered a daily rate of more than £275 £325 £250
10% offered a daily rate of more than £625 £620 £525
UK excluding London median daily rate £425 £400 £356
% change year-on-year
+6.25% +12.28%
Number of hourly rates quoted 4 3 2
Median hourly rate £19.06 £16.00 £60.50
Median hourly rate % change year-on-year
+19.12% -73.55%
90% offered a hourly rate of more than £14.19 £16.00 £24.90
10% offered a hourly rate of more than £20.08 £18.40 £96.10
UK excluding London median hourly rate £19.72 £11.31 £10.50
% change year-on-year
+74.43% +7.66%
Data Cleansing
England

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

Processes & Methodologies Category
London
Contract IT job ads with a match in the
Processes & Methodologies category
18699 18662 19002
As % of all contract IT jobs located in London 84.89% 83.55% 80.67%
Number of daily rates quoted 13450 13314 14022
Median daily rate £475 £463 £450
Median daily rate % change year-on-year
+2.70% +2.77%
90% offered a daily rate of more than £338 £325 £300
10% offered a daily rate of more than £625 £625 £625
UK excluding London median daily rate £413 £400 £385
% change year-on-year
+3.12% +3.89%
Number of hourly rates quoted 200 227 249
Median hourly rate £27.50 £22.56 £22.50
Median hourly rate % change year-on-year
+21.89% +0.26%
90% offered a hourly rate of more than £13.35 £12.50 £11.50
10% offered a hourly rate of more than £50.00 £50.00 £53.50
UK excluding London median hourly rate £31.00 £34.95 £25.00
% change year-on-year
-11.30% +39.80%

Data Cleansing
Jobs Demand Trend in London

The demand trend of contract jobs across the 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 London

Data Cleansing
Daily Rate Trend in London

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

Data Cleansing Daily Rate Trend in London

Data Cleansing
Daily Rate Histogram in London

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

Data Cleansing Daily Rate Histogram in London

Data Cleansing
Hourly Rate Trend in London

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

Data Cleansing Hourly Rate Trend 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 3 months to 6 December 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
City of London +3 24 £475 +31.94% 2
Harrow - 3 £415 -
Docklands, London -2 1 £650 +23.80%
Uxbridge - 1 - -
Data Cleansing
England

Data Cleansing
Top 30 Related IT Skills in London

For the 6 months to 6 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 London region with a requirement for Data Cleansing.

1 72 (41.62%) SQL
2 70 (40.46%) Migration
3 65 (37.57%) Data Migration
4 63 (36.42%) Data Quality
5 59 (34.10%) ETL
6 51 (29.48%) Data Modelling
7 46 (26.59%) Data Analysis
8 41 (23.70%) Finance
9 36 (20.81%) Oracle
10 29 (16.76%) Data Management
11 27 (15.61%) SAP
11 27 (15.61%) MS Excel
11 27 (15.61%) Data Warehouse
12 26 (15.03%) ERP
13 23 (13.29%) Business Intelligence
13 23 (13.29%) SQL Server
14 22 (12.72%) Stakeholder Management
14 22 (12.72%) Data Governance
15 21 (12.14%) Agile Software Development
16 20 (11.56%) Relational Database
17 18 (10.40%) Informatica
17 18 (10.40%) Management Information System
18 17 (9.83%) T-SQL
18 17 (9.83%) SQL Server Integration Services
18 17 (9.83%) Big Data
19 16 (9.25%) Analytics
19 16 (9.25%) Data Transformation
19 16 (9.25%) Retail
19 16 (9.25%) Microsoft
20 15 (8.67%) JIRA

Data Cleansing
Top Related 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 11 (6.36%) Apache Spark
2 5 (2.89%) SAS
3 4 (2.31%) Confluence
3 4 (2.31%) Elasticsearch
4 3 (1.73%) SharePoint
5 1 (0.58%) Apache
5 1 (0.58%) Oracle Workflow
5 1 (0.58%) Tomcat
5 1 (0.58%) WebLogic
Applications
1 27 (15.61%) MS Excel
2 8 (4.62%) Spreadsheet
3 7 (4.05%) MS Visio
4 5 (2.89%) MS Project
5 4 (2.31%) MS PowerPoint
6 3 (1.73%) MS Office
7 1 (0.58%) SPSS
Business Applications
1 8 (4.62%) Oracle ERP
2 7 (4.05%) Oracle EBS R12
3 6 (3.47%) SAP Oil and Gas
4 5 (2.89%) Dynamics CRM
5 4 (2.31%) Oracle EBS
5 4 (2.31%) Workday HCM
6 3 (1.73%) Maximo
6 3 (1.73%) Oracle Procure-to-Pay
6 3 (1.73%) Salesforce.com CRM
6 3 (1.73%) SAP CRM
7 2 (1.16%) Cognos Business Intelligence
7 2 (1.16%) Oracle Financials
7 2 (1.16%) Oracle Payables
7 2 (1.16%) Oracle Retail
7 2 (1.16%) SAP PM
7 2 (1.16%) Summit
8 1 (0.58%) Oracle Assets
8 1 (0.58%) Oracle Cash Management
8 1 (0.58%) Oracle Receivables
8 1 (0.58%) SAP FI
Cloud Services
1 5 (2.89%) SaaS
2 3 (1.73%) G Suite
3 2 (1.16%) Office 365
3 2 (1.16%) SuccessFactors
4 1 (0.58%) Amazon AWS
4 1 (0.58%) Google Analytics
Communications & Networking
1 3 (1.73%) Firewall
2 2 (1.16%) Internet
2 2 (1.16%) Intranet
3 1 (0.58%) BGP
3 1 (0.58%) SNA
3 1 (0.58%) Wireless
Database & Business Intelligence
1 27 (15.61%) Data Warehouse
2 23 (13.29%) SQL Server
3 20 (11.56%) Relational Database
4 17 (9.83%) Big Data
4 17 (9.83%) SQL Server Integration Services
5 11 (6.36%) Hadoop
5 11 (6.36%) SQL Server Reporting Services
6 8 (4.62%) SQL Server Analysis Services
7 5 (2.89%) Apache Hive
7 5 (2.89%) SQL Server 2008
7 5 (2.89%) Star Schema
8 4 (2.31%) DataStage
8 4 (2.31%) MS Access
8 4 (2.31%) Oracle Reports
8 4 (2.31%) RDBMS
8 4 (2.31%) Snowflake Schema
8 4 (2.31%) SQL Server 2012
9 3 (1.73%) Apache Cassandra
9 3 (1.73%) Impala
9 3 (1.73%) Pentaho
Development Applications
1 15 (8.67%) JIRA
2 10 (5.78%) ERwin
3 6 (3.47%) Talend Open Studio
4 3 (1.73%) Team Foundation Server
5 2 (1.16%) SQL Server Management Studio (SSMS)
5 2 (1.16%) Visual Studio
6 1 (0.58%) Git (software)
6 1 (0.58%) Jenkins
6 1 (0.58%) LSMW
6 1 (0.58%) QAComplete
6 1 (0.58%) Sonatype Nexus
6 1 (0.58%) TestComplete
6 1 (0.58%) VersionOne
General
1 41 (23.70%) Finance
2 16 (9.25%) Retail
3 13 (7.51%) Banking
4 9 (5.20%) Law
5 7 (4.05%) Legal
6 6 (3.47%) Marketing
7 3 (1.73%) Back Office
7 3 (1.73%) Billing
7 3 (1.73%) Front Office
8 2 (1.16%) Financial Institution
8 2 (1.16%) General Ledger
8 2 (1.16%) Investment Banking
8 2 (1.16%) Telecoms
9 1 (0.58%) Advertising
9 1 (0.58%) Corporate Banking
9 1 (0.58%) Electronics
9 1 (0.58%) Manufacturing
9 1 (0.58%) Pharmaceutical
9 1 (0.58%) Private Banking
9 1 (0.58%) Retail Banking
Job Titles
1 49 (28.32%) Analyst
2 35 (20.23%) Data Analyst
3 24 (13.87%) Developer
4 22 (12.72%) Architect
5 17 (9.83%) Data Manager
6 13 (7.51%) Consultant
6 13 (7.51%) Data Migration Lead
7 11 (6.36%) Data Architect
8 10 (5.78%) SQL Analyst
9 9 (5.20%) Business Analyst
9 9 (5.20%) Senior Analyst
9 9 (5.20%) Senior Data Analyst
10 8 (4.62%) Data Consultant
10 8 (4.62%) SQL Data Analyst
10 8 (4.62%) SQL Developer
11 7 (4.05%) Software Architect
12 6 (3.47%) ETL Developer
13 5 (2.89%) Data Migration Analyst
13 5 (2.89%) Database Analyst
13 5 (2.89%) Oracle Consultant
Libraries, Frameworks & Software Standards
1 6 (3.47%) Kafka
2 5 (2.89%) XML
3 4 (2.31%) .NET
4 3 (1.73%) Akka
4 3 (1.73%) AngularJS
4 3 (1.73%) HTML
4 3 (1.73%) Oracle Fusion
5 2 (1.16%) ASP.NET
5 2 (1.16%) Node.js
5 2 (1.16%) Play Framework
5 2 (1.16%) REST
5 2 (1.16%) SOAP
6 1 (0.58%) D3.js
6 1 (0.58%) MDX
6 1 (0.58%) Middleware
6 1 (0.58%) Web Services
6 1 (0.58%) XML Schema
6 1 (0.58%) XSD
6 1 (0.58%) XSL
6 1 (0.58%) XSLT
Miscellaneous
1 18 (10.40%) Management Information System
2 15 (8.67%) Data Conversion
3 14 (8.09%) Data Structures
3 14 (8.09%) Statistics
4 12 (6.94%) Analytical Skills
5 8 (4.62%) Data Integration
6 7 (4.05%) Data Extraction
7 5 (2.89%) Reference Data
8 3 (1.73%) Computer Science
8 3 (1.73%) Data Protection Act
8 3 (1.73%) Enterprise Software
8 3 (1.73%) Visualisation
9 2 (1.16%) Client/Server
9 2 (1.16%) Credit Risk
9 2 (1.16%) NHS
9 2 (1.16%) Virtual Team
10 1 (0.58%) Digital Media
10 1 (0.58%) FMCG
10 1 (0.58%) Market Risk
10 1 (0.58%) PMI
Operating Systems
1 5 (2.89%) Unix
1 5 (2.89%) Windows
2 1 (0.58%) Linux
Processes & Methodologies
1 70 (40.46%) Migration
2 65 (37.57%) Data Migration
3 59 (34.10%) ETL
4 51 (29.48%) Data Modelling
5 46 (26.59%) Data Analysis
6 29 (16.76%) Data Management
7 26 (15.03%) ERP
8 23 (13.29%) Business Intelligence
9 22 (12.72%) Data Governance
9 22 (12.72%) Stakeholder Management
10 21 (12.14%) Agile Software Development
11 16 (9.25%) Analytics
11 16 (9.25%) Data Transformation
12 15 (8.67%) Data Architecture
13 14 (8.09%) Project Management
13 14 (8.09%) Validation
14 13 (7.51%) Data Mapping
15 12 (6.94%) CRM
15 12 (6.94%) Master Data Management
16 10 (5.78%) Translating Business Requirements
Programming Languages
1 72 (41.62%) SQL
2 17 (9.83%) T-SQL
3 9 (5.20%) PL/SQL
4 5 (2.89%) Scala
4 5 (2.89%) VBA
5 4 (2.31%) Python
5 4 (2.31%) Shell Script
6 2 (1.16%) C
6 2 (1.16%) Java
6 2 (1.16%) JavaScript
6 2 (1.16%) VB
7 1 (0.58%) ABAP
7 1 (0.58%) C#
7 1 (0.58%) R
7 1 (0.58%) VB.NET
7 1 (0.58%) VBScript
Qualifications
1 13 (7.51%) Degree
2 6 (3.47%) Security Cleared
3 4 (2.31%) BPSS Clearance
4 3 (1.73%) SC Cleared
5 2 (1.16%) APMP
5 2 (1.16%) DBS Check
5 2 (1.16%) PMP
6 1 (0.58%) CCNP
6 1 (0.58%) Cisco Certification
6 1 (0.58%) CTC Cleared
6 1 (0.58%) PMI Certification
6 1 (0.58%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 63 (36.42%) Data Quality
2 14 (8.09%) QA
3 2 (1.16%) Disclosure Scotland
3 2 (1.16%) EMIR
3 2 (1.16%) FATCA
4 1 (0.58%) P3O
4 1 (0.58%) SLA
System Software
1 4 (2.31%) Active Directory
2 3 (1.73%) Hyper-V
2 3 (1.73%) VMware Infrastructure
3 1 (0.58%) Firmware
Systems Management
1 3 (1.73%) Control-M
2 2 (1.16%) SCOM
3 1 (0.58%) HP Quality Center
Vendors
1 36 (20.81%) Oracle
2 27 (15.61%) SAP
3 18 (10.40%) Informatica
4 16 (9.25%) Microsoft
5 10 (5.78%) IBM
6 7 (4.05%) Salesforce.com
7 6 (3.47%) Talend
7 6 (3.47%) Workday
8 5 (2.89%) Tableau
8 5 (2.89%) Teradata
9 4 (2.31%) Cognos
9 4 (2.31%) Google
10 3 (1.73%) IFS
10 3 (1.73%) VMware
11 2 (1.16%) Calypso
11 2 (1.16%) Yardi
12 1 (0.58%) Cisco
12 1 (0.58%) HP
12 1 (0.58%) MicroStrategy
12 1 (0.58%) Pegasus