The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for Data Cleansing skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Cleansing over the 3 months to 25 June 2017 with a comparison to the same period in the previous 2 years.

Data Cleansing (Data Cleaning, Data Scrubbing)
London / City of London
3 months to
25 Jun 2017
Same period 2016 Same period 2015
Rank 219 244 295
Rank change year-on-year +25 +51  
Permanent jobs citing Data Cleansing 12 17 11
As % of all permanent IT jobs advertised in the City of London 0.23% 0.27% 0.11%
As % of the Processes & Methodologies category 0.26% 0.30% 0.12%
Number of salaries quoted 11 17 10
Median salary £60,000 £50,000 £57,500
Median salary % change year-on-year +20.00% -13.04%  
90% offered a salary of more than £36,000 £25,500 £34,550
10% offered a salary of more than £72,500 £62,500 £95,000
UK excluding London median salary £40,000 £42,500 £40,000
% change year-on-year -5.88% +6.25%  

Data Cleansing is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in the City of London with a requirement for process and methodology skills.

Process & Methodology Skills
City of London
Permanent job vacancies with a requirement for process and methodology skills 4596 5702 9233
As % of all permanent IT job vacancies advertised in the City of London 89.29% 90.61% 89.22%
Number of salaries quoted 4057 5205 7905
Median salary £62,500 £60,000 £57,500
Median salary % change year-on-year +4.16% +4.34%  
90% offered a salary of more than £40,000 £40,000 £39,000
10% offered a salary of more than £85,000 £81,000 £85,000
UK excluding London median salary £45,000 £45,000 £44,000
% change year-on-year - +2.27%  

Data Cleansing
Job Vacancy Trend in the City of London

The job posting trend of jobs advertised in the City of London citing Data Cleansing as a proportion of all permanent or contract IT jobs with a match in the Processes & Methodologies category.

Job vacancy trend for Data Cleansing in the City of London

Data Cleansing
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Cleansing in the City of London.

Salary trend for Data Cleansing in the City of London

Data Cleansing
Salary Histogram in the City of London

The salary distribution of IT jobs citing Data Cleansing in the City of London over the 3 months to 25 June 2017.

Salary histogram for Data Cleansing in the City of London

For the 6 months to 25 June 2017, IT 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 job ads across the City of London region with a requirement for Data Cleansing.

1 14 (40.00%) ETL
2 13 (37.14%) SQL
3 12 (34.29%) Data Analysis
3 12 (34.29%) Data Quality
4 11 (31.43%) Analytical Skills
4 11 (31.43%) Validation
4 11 (31.43%) Data Modelling
5 10 (28.57%) Business Intelligence
5 10 (28.57%) Analytics
5 10 (28.57%) Data Architecture
6 9 (25.71%) Project Management
7 8 (22.86%) CRM
7 8 (22.86%) Data Integration
7 8 (22.86%) Hadoop
7 8 (22.86%) User Acceptance Testing
7 8 (22.86%) Line Management
8 7 (20.00%) Big Data
8 7 (20.00%) Time Management
8 7 (20.00%) Data Warehouse
9 6 (17.14%) Data Mining
10 5 (14.29%) Python
10 5 (14.29%) Data Protection
10 5 (14.29%) Marketing
10 5 (14.29%) Apache Spark
11 4 (11.43%) Mentoring
11 4 (11.43%) Customer Analytics
11 4 (11.43%) Kafka
11 4 (11.43%) Digital Marketing
11 4 (11.43%) Marketing Intelligence
11 4 (11.43%) Progress

Data Cleansing
Co-occurring 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 5 (14.29%) Apache Spark
2 1 (2.86%) Elasticsearch
2 1 (2.86%) IPython
2 1 (2.86%) Tornado
Applications
1 1 (2.86%) Microsoft Excel
1 1 (2.86%) Microsoft Office
1 1 (2.86%) Microsoft PowerPoint
1 1 (2.86%) Microsoft Project
1 1 (2.86%) MS Visio
Business Applications
1 1 (2.86%) Markit EDM
1 1 (2.86%) Raiser's Edge
Cloud Services
1 2 (5.71%) Amazon AWS
2 1 (2.86%) Amazon Kinesis
2 1 (2.86%) Amazon S3
2 1 (2.86%) Amazon SQS
2 1 (2.86%) Google Analytics
Database & Business Intelligence
1 8 (22.86%) Hadoop
2 7 (20.00%) Big Data
2 7 (20.00%) Data Warehouse
3 6 (17.14%) Data Mining
4 3 (8.57%) Data Lake
4 3 (8.57%) Data Mart
4 3 (8.57%) Impala
4 3 (8.57%) MarkLogic
4 3 (8.57%) RDBMS
4 3 (8.57%) Relational Database
4 3 (8.57%) SQL Server Reporting Services
5 2 (5.71%) SQL Server
5 2 (5.71%) SQL Server Integration Services
6 1 (2.86%) Apache Cassandra
6 1 (2.86%) Electronic Patient Records
6 1 (2.86%) Mixpanel
6 1 (2.86%) MySQL
6 1 (2.86%) Power BI
6 1 (2.86%) QlikView
6 1 (2.86%) SQL Server Analysis Services
Development Applications
1 3 (8.57%) ERwin
1 3 (8.57%) Talend Open Studio
General
1 5 (14.29%) Marketing
2 4 (11.43%) Finance
2 4 (11.43%) Law
2 4 (11.43%) Legal
3 1 (2.86%) Retail
Job Titles
1 12 (34.29%) Analyst
2 10 (28.57%) Data Analyst
3 8 (22.86%) Administrator
4 6 (17.14%) Data Administrator
5 5 (14.29%) Business Developer
5 5 (14.29%) Business Intelligence Developer
5 5 (14.29%) Developer
6 4 (11.43%) Architect
6 4 (11.43%) Business Intelligence Lead
6 4 (11.43%) Data Architect
6 4 (11.43%) Data Quality Analyst
6 4 (11.43%) Lead Developer
6 4 (11.43%) Quality Analyst
7 3 (8.57%) Big Data Architect
7 3 (8.57%) Hadoop Architect
7 3 (8.57%) Report Analyst
8 2 (5.71%) Data Engineer
8 2 (5.71%) SQL Analyst
8 2 (5.71%) SQL Data Analyst
8 2 (5.71%) SQL Reporting Analyst
Libraries, Frameworks & Software Standards
1 4 (11.43%) Kafka
2 1 (2.86%) Flask
2 1 (2.86%) NumPy
2 1 (2.86%) Pandas
2 1 (2.86%) RESTful
2 1 (2.86%) scikit-learn
Miscellaneous
1 11 (31.43%) Analytical Skills
2 4 (11.43%) Management Information System
3 1 (2.86%) Blog
3 1 (2.86%) Data Protection Act
3 1 (2.86%) Fintech
3 1 (2.86%) PMI
3 1 (2.86%) Reference Data
Operating Systems
1 2 (5.71%) Linux
2 1 (2.86%) Mac OS X
2 1 (2.86%) Unix
Processes & Methodologies
1 14 (40.00%) ETL
2 12 (34.29%) Data Analysis
3 11 (31.43%) Data Modelling
3 11 (31.43%) Validation
4 10 (28.57%) Analytics
4 10 (28.57%) Business Intelligence
4 10 (28.57%) Data Architecture
5 9 (25.71%) Project Management
6 8 (22.86%) CRM
6 8 (22.86%) Data Integration
6 8 (22.86%) Line Management
6 8 (22.86%) User Acceptance Testing
7 7 (20.00%) Time Management
8 5 (14.29%) Data Protection
9 4 (11.43%) Customer Analytics
9 4 (11.43%) Digital Marketing
9 4 (11.43%) Marketing Intelligence
9 4 (11.43%) Mentoring
10 3 (8.57%) Data Flow Diagram
10 3 (8.57%) ETL Development
Programming Languages
1 13 (37.14%) SQL
2 5 (14.29%) Python
3 2 (5.71%) Java
3 2 (5.71%) R
4 1 (2.86%) C
4 1 (2.86%) MATLAB
4 1 (2.86%) Scala
4 1 (2.86%) VBA
Qualifications
1 3 (8.57%) Degree
2 1 (2.86%) APMP
2 1 (2.86%) Numerate Degree
2 1 (2.86%) PMI Certification
2 1 (2.86%) PMP
2 1 (2.86%) SC Cleared
2 1 (2.86%) Security Cleared
Quality Assurance & Compliance
1 12 (34.29%) Data Quality
2 1 (2.86%) P3O
System Software
1 2 (5.71%) Docker
Vendors
1 4 (11.43%) Progress
2 3 (8.57%) Cisco
2 3 (8.57%) Cloudera
2 3 (8.57%) IBM
2 3 (8.57%) Informatica
2 3 (8.57%) Talend
3 2 (5.71%) Tableau
4 1 (2.86%) Google
4 1 (2.86%) Microsoft
4 1 (2.86%) SAP
City, London
Best Practice Talent Solutions
Salary: From £25,000 to £35,000 per annum + health + pension + fast track prom
Posted: 4 days ago