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 24 February 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
24 Feb 2017
Same period 2016 Same period 2015
Data Cleansing (Data Cleaning, Data Scrubbing)
London / City of London
Rank 140 143 169
Rank change year-on-year
+3 +26
Contract jobs citing Data Cleansing 17 10 23
As % of all contract IT jobs located in the City of London 0.57% 0.31% 0.44%
As % of the Processes & Methodologies category 0.68% 0.36% 0.53%
Number of daily rates quoted 15 8 18
Median daily rate £280 £438 £431
Median daily rate % change year-on-year
-36.00% +1.44%
90% offered a daily rate of more than £150 £284 £218
10% offered a daily rate of more than £440 £594 £503
UK excluding London median daily rate £350 £400 £365
% change year-on-year
-12.50% +9.58%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate - £13.50 -

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
2518 2776 4300
As % of all contract IT jobs located in the City of London 84.98% 86.83% 82.92%
Number of daily rates quoted 1989 2205 3354
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 £350 £325 £313
10% offered a daily rate of more than £625 £625 £625
UK excluding London median daily rate £408 £400 £400
% change year-on-year
+1.87% -
Number of hourly rates quoted 15 28 33
Median hourly rate £21.75 £22.00 £22.69
Median hourly rate % change year-on-year
-1.13% -3.04%
90% offered a hourly rate of more than £13.50 £13.00 £13.40
10% offered a hourly rate of more than £80.00 £53.00 £45.50
UK excluding London median hourly rate £36.00 £40.00 £27.50
% change year-on-year
-10.00% +45.45%

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 24 February 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 24 February 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 22 (56.41%) Data Analysis
2 19 (48.72%) SQL
3 14 (35.90%) Data Modelling
3 14 (35.90%) Data Quality
4 13 (33.33%) Data Management
4 13 (33.33%) ETL
5 12 (30.77%) MS Excel
6 11 (28.21%) Management Information System
6 11 (28.21%) Finance
6 11 (28.21%) Data Entry
7 10 (25.64%) Statistics
7 10 (25.64%) Reference Data
8 9 (23.08%) Business Intelligence
9 6 (15.38%) Migration
9 6 (15.38%) Data Warehouse
9 6 (15.38%) Microsoft
9 6 (15.38%) Relational Database
10 5 (12.82%) Data Migration
10 5 (12.82%) JIRA
10 5 (12.82%) SQL Server Analysis Services
10 5 (12.82%) SQL Server Integration Services
10 5 (12.82%) Agile Software Development
10 5 (12.82%) T-SQL
10 5 (12.82%) SQL Server
10 5 (12.82%) Power BI
11 4 (10.26%) SQL Server 2016
11 4 (10.26%) Data Ingestion
11 4 (10.26%) ERwin
11 4 (10.26%) Legal
11 4 (10.26%) Oracle

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.56%) Apache Spark
1 1 (2.56%) Confluence
1 1 (2.56%) SAS
1 1 (2.56%) WebLogic
Applications
1 12 (30.77%) MS Excel
2 2 (5.13%) MS Project
2 2 (5.13%) MS Visio
3 1 (2.56%) MS Office
Business Applications
1 1 (2.56%) Dynamics CRM
1 1 (2.56%) Dynamics GP
1 1 (2.56%) Oracle Assets
1 1 (2.56%) Oracle Cash Management
1 1 (2.56%) Oracle EBS
1 1 (2.56%) Oracle Payables
1 1 (2.56%) Oracle Payroll
1 1 (2.56%) Oracle Receivables
Cloud Services
1 1 (2.56%) SaaS
Database & Business Intelligence
1 6 (15.38%) Data Warehouse
1 6 (15.38%) Relational Database
2 5 (12.82%) Power BI
2 5 (12.82%) SQL Server
2 5 (12.82%) SQL Server Analysis Services
2 5 (12.82%) SQL Server Integration Services
3 4 (10.26%) SQL Server 2012
3 4 (10.26%) SQL Server 2016
4 3 (7.69%) Big Data
5 2 (5.13%) Oracle Database
5 2 (5.13%) Oracle Database 11g
6 1 (2.56%) Base SAS
6 1 (2.56%) Hadoop
6 1 (2.56%) OLTP
6 1 (2.56%) Oracle BI EE
6 1 (2.56%) Oracle Database 12c
6 1 (2.56%) Oracle ODI
6 1 (2.56%) SQL Server Reporting Services
Development Applications
1 5 (12.82%) JIRA
2 4 (10.26%) ERwin
3 1 (2.56%) Git (software)
3 1 (2.56%) Jenkins
3 1 (2.56%) Sonatype Nexus
3 1 (2.56%) Talend Open Studio
General
1 11 (28.21%) Finance
2 4 (10.26%) Legal
3 2 (5.13%) Billing
3 2 (5.13%) Retail
4 1 (2.56%) General Ledger
4 1 (2.56%) Law
4 1 (2.56%) Marketing
Job Titles
1 21 (53.85%) Analyst
2 18 (46.15%) Data Analyst
3 10 (25.64%) Data Cleansing Analyst
4 5 (12.82%) Architect
4 5 (12.82%) Developer
5 4 (10.26%) Business Intelligence Developer
5 4 (10.26%) Data Architect
5 4 (10.26%) Power BI Developer
5 4 (10.26%) SQL BI Developer
5 4 (10.26%) SQL Developer
5 4 (10.26%) SSIS Developer
5 4 (10.26%) T-SQL Developer
6 3 (7.69%) Big Data Architect
7 2 (5.13%) Big Data Analyst
7 2 (5.13%) ETL Analyst
7 2 (5.13%) ETL Architect
7 2 (5.13%) Report Analyst
7 2 (5.13%) SQL Analyst
7 2 (5.13%) SQL Data Analyst
7 2 (5.13%) Team Leader
Libraries, Frameworks & Software Standards
1 1 (2.56%) Middleware
1 1 (2.56%) Oracle Fusion
1 1 (2.56%) XML
1 1 (2.56%) XML Schema
1 1 (2.56%) XSD
1 1 (2.56%) XSL
1 1 (2.56%) XSLT
Miscellaneous
1 11 (28.21%) Management Information System
2 10 (25.64%) Reference Data
3 2 (5.13%) Analytical Skills
4 1 (2.56%) Computer Science
4 1 (2.56%) NHS
4 1 (2.56%) PMI
Operating Systems
1 1 (2.56%) Linux
1 1 (2.56%) Windows
Processes & Methodologies
1 22 (56.41%) Data Analysis
2 14 (35.90%) Data Modelling
3 13 (33.33%) Data Management
3 13 (33.33%) ETL
4 11 (28.21%) Data Entry
5 10 (25.64%) Statistics
6 9 (23.08%) Business Intelligence
7 6 (15.38%) Migration
8 5 (12.82%) Agile Software Development
8 5 (12.82%) Data Migration
9 4 (10.26%) Data Ingestion
10 3 (7.69%) Data Governance
10 3 (7.69%) ERP
11 2 (5.13%) CRM
11 2 (5.13%) Data Conversion
11 2 (5.13%) Data Integration
11 2 (5.13%) E-Commerce
11 2 (5.13%) Practice Management
11 2 (5.13%) Stakeholder Engagement
11 2 (5.13%) Translating Business Requirements
Programming Languages
1 19 (48.72%) SQL
2 5 (12.82%) T-SQL
3 4 (10.26%) Data Analysis Expressions (DAX)
4 1 (2.56%) PL/SQL
4 1 (2.56%) Scala
4 1 (2.56%) Shell Script
4 1 (2.56%) VBA
Qualifications
1 2 (5.13%) Degree
2 1 (2.56%) APMP
2 1 (2.56%) PMI Certification
2 1 (2.56%) PMP
2 1 (2.56%) SC Cleared
2 1 (2.56%) Security Cleared
Quality Assurance & Compliance
1 14 (35.90%) Data Quality
2 2 (5.13%) QA
3 1 (2.56%) P3O
Vendors
1 6 (15.38%) Microsoft
2 4 (10.26%) Oracle
3 3 (7.69%) SAP
4 1 (2.56%) Informatica
4 1 (2.56%) MicroStrategy
4 1 (2.56%) Tableau
4 1 (2.56%) Talend
4 1 (2.56%) WorldPay
City, London
2M Employment Solutions
Rate: £9.75 per hour
Posted: Yesterday