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 17 January 2017 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
17 Jan 2017
Same period 2016 Same period 2015
Data Cleansing (Data Cleaning, Data Scrubbing)
London / City of London
Rank 137 134 169
Rank change year-on-year
-3 +35
Contract jobs citing Data Cleansing 19 16 20
As % of all contract IT jobs located in the City of London 0.65% 0.53% 0.40%
As % of the Processes & Methodologies category 0.76% 0.63% 0.49%
Number of daily rates quoted 15 12 14
Median daily rate £425 £350 £475
Median daily rate % change year-on-year
+21.42% -26.31%
90% offered a daily rate of more than £150 £235 £400
10% offered a daily rate of more than £575 £631 £500
UK excluding London median daily rate £413 £400 £350
% change year-on-year
+3.12% +14.28%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate - £10.00 £20.95
% change year-on-year
- -52.26%

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
2503 2536 4117
As % of all contract IT jobs located in the City of London 86.07% 84.53% 81.80%
Number of daily rates quoted 1976 2000 3237
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 £360 £320 £320
10% offered a daily rate of more than £650 £625 £625
UK excluding London median daily rate £410 £400 £390
% change year-on-year
+2.50% +2.56%
Number of hourly rates quoted 17 24 33
Median hourly rate £40.00 £32.80 £20.00
Median hourly rate % change year-on-year
+21.96% +63.98%
90% offered a hourly rate of more than £15.16 £18.79 £13.50
10% offered a hourly rate of more than £55.00 £53.00 £45.50
UK excluding London median hourly rate £34.50 £39.00 £25.50
% change year-on-year
-11.53% +52.94%

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 17 January 2017.

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 17 January 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 City of London region with a requirement for Data Cleansing.

1 18 (50.00%) SQL
1 18 (50.00%) Data Analysis
2 15 (41.67%) Data Modelling
2 15 (41.67%) Data Quality
3 13 (36.11%) ETL
4 12 (33.33%) Finance
5 10 (27.78%) Data Management
5 10 (27.78%) Statistics
6 8 (22.22%) Migration
6 8 (22.22%) MS Excel
7 7 (19.44%) Microsoft
7 7 (19.44%) Management Information System
7 7 (19.44%) Business Intelligence
7 7 (19.44%) Data Migration
7 7 (19.44%) Data Entry
8 6 (16.67%) Reference Data
8 6 (16.67%) Relational Database
8 6 (16.67%) Data Warehouse
9 5 (13.89%) T-SQL
9 5 (13.89%) SQL Server
9 5 (13.89%) Legal
9 5 (13.89%) SQL Server Integration Services
9 5 (13.89%) JIRA
9 5 (13.89%) SQL Server Analysis Services
10 4 (11.11%) SQL Server 2012
10 4 (11.11%) Data Analysis Expressions (DAX)
10 4 (11.11%) Agile Software Development
10 4 (11.11%) ERwin
10 4 (11.11%) Data Ingestion
10 4 (11.11%) Power BI

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 1 (2.78%) Apache Spark
1 1 (2.78%) Confluence
1 1 (2.78%) SAS
1 1 (2.78%) WebLogic
Applications
1 8 (22.22%) MS Excel
2 2 (5.56%) MS Project
2 2 (5.56%) MS Visio
3 1 (2.78%) MS Office
Business Applications
1 2 (5.56%) Workday HCM
2 1 (2.78%) Dynamics CRM
2 1 (2.78%) Dynamics GP
2 1 (2.78%) Oracle Assets
2 1 (2.78%) Oracle Cash Management
2 1 (2.78%) Oracle Payables
2 1 (2.78%) Oracle Receivables
Cloud Services
1 2 (5.56%) SaaS
Database & Business Intelligence
1 6 (16.67%) Data Warehouse
1 6 (16.67%) Relational Database
2 5 (13.89%) SQL Server
2 5 (13.89%) SQL Server Analysis Services
2 5 (13.89%) SQL Server Integration Services
3 4 (11.11%) Power BI
3 4 (11.11%) SQL Server 2012
3 4 (11.11%) SQL Server 2016
4 3 (8.33%) Big Data
5 1 (2.78%) Base SAS
5 1 (2.78%) Hadoop
5 1 (2.78%) OLTP
5 1 (2.78%) Oracle Database
5 1 (2.78%) Oracle Database 11g
5 1 (2.78%) Oracle Database 12c
5 1 (2.78%) Oracle ODI
5 1 (2.78%) SQL Server Reporting Services
Development Applications
1 5 (13.89%) JIRA
2 4 (11.11%) ERwin
3 1 (2.78%) Git (software)
3 1 (2.78%) Jenkins
3 1 (2.78%) Sonatype Nexus
3 1 (2.78%) Talend Open Studio
General
1 12 (33.33%) Finance
2 5 (13.89%) Legal
3 2 (5.56%) Billing
3 2 (5.56%) Retail
4 1 (2.78%) General Ledger
4 1 (2.78%) Law
4 1 (2.78%) Marketing
Job Titles
1 17 (47.22%) Analyst
2 15 (41.67%) Data Analyst
3 6 (16.67%) Data Cleansing Analyst
4 5 (13.89%) Architect
4 5 (13.89%) Developer
5 4 (11.11%) Business Intelligence Developer
5 4 (11.11%) Data Architect
5 4 (11.11%) Power BI Developer
5 4 (11.11%) SQL BI Developer
5 4 (11.11%) SQL Developer
5 4 (11.11%) SSIS Developer
5 4 (11.11%) T-SQL Developer
6 3 (8.33%) Big Data Architect
7 2 (5.56%) Big Data Analyst
7 2 (5.56%) ETL Analyst
7 2 (5.56%) ETL Architect
7 2 (5.56%) Legal Analyst
7 2 (5.56%) SQL Analyst
7 2 (5.56%) SQL Data Analyst
7 2 (5.56%) Team Leader
Libraries, Frameworks & Software Standards
1 1 (2.78%) Middleware
1 1 (2.78%) XML
1 1 (2.78%) XML Schema
1 1 (2.78%) XSD
1 1 (2.78%) XSL
1 1 (2.78%) XSLT
Miscellaneous
1 10 (27.78%) Statistics
2 7 (19.44%) Management Information System
3 6 (16.67%) Reference Data
4 2 (5.56%) Data Conversion
4 2 (5.56%) Data Integration
5 1 (2.78%) Computer Science
5 1 (2.78%) NHS
5 1 (2.78%) PMI
Operating Systems
1 2 (5.56%) Windows
2 1 (2.78%) Linux
Processes & Methodologies
1 18 (50.00%) Data Analysis
2 15 (41.67%) Data Modelling
3 13 (36.11%) ETL
4 10 (27.78%) Data Management
5 8 (22.22%) Migration
6 7 (19.44%) Business Intelligence
6 7 (19.44%) Data Entry
6 7 (19.44%) Data Migration
7 4 (11.11%) Agile Software Development
7 4 (11.11%) Data Ingestion
8 3 (8.33%) Data Governance
9 2 (5.56%) Business Development
9 2 (5.56%) CRM
9 2 (5.56%) E-Commerce
9 2 (5.56%) ERP
9 2 (5.56%) Practice Management
9 2 (5.56%) Stakeholder Management
9 2 (5.56%) Translating Business Requirements
10 1 (2.78%) BCP
10 1 (2.78%) Project Management
Programming Languages
1 18 (50.00%) SQL
2 5 (13.89%) T-SQL
3 4 (11.11%) Data Analysis Expressions (DAX)
4 1 (2.78%) PL/SQL
4 1 (2.78%) Scala
4 1 (2.78%) Shell Script
4 1 (2.78%) VBA
Qualifications
1 2 (5.56%) Degree
2 1 (2.78%) APMP
2 1 (2.78%) PMI Certification
2 1 (2.78%) PMP
Quality Assurance & Compliance
1 15 (41.67%) Data Quality
2 2 (5.56%) QA
3 1 (2.78%) P3O
Vendors
1 7 (19.44%) Microsoft
2 3 (8.33%) Oracle
2 3 (8.33%) SAP
3 2 (5.56%) Workday
4 1 (2.78%) Informatica
4 1 (2.78%) MicroStrategy
4 1 (2.78%) Tableau
4 1 (2.78%) Talend
4 1 (2.78%) WorldPay