Period
to 17 July 2018

The following table provides summary statistics for permanent job vacancies advertised in 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 6 months to 17 July 2018 with a comparison to the same period in the previous 2 years.

Data Cleansing (Data Cleaning, Data Scrubbing)
England > London
6 months to
17 Jul 2018
Same period 2017 Same period 2016
Rank 659 670 703
Rank change year-on-year +11 +33 +25
Permanent jobs citing Data Cleansing 171 182 204
As % of all permanent IT jobs advertised in London 0.24% 0.25% 0.25%
As % of the Processes & Methodologies category 0.26% 0.27% 0.27%
Number of salaries quoted 134 140 220
London median annual salary £55,000 £52,000 £42,500
Median salary % change year-on-year +5.77% +22.35% -29.17%
10th Percentile £26,075 £30,450 £30,000
90th Percentile £90,000 £85,000 £72,275
England median annual salary £47,500 £45,000 £42,500
% change year-on-year +5.56% +5.88% -5.56%

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

All Process and Methodology Skills
London
Permanent vacancies with a requirement for process or methodology skills 65,340 67,022 75,960
As % of all permanent IT jobs advertised in London 91.40% 91.73% 91.38%
Number of salaries quoted 52,279 53,535 65,496
London median annual salary £60,000 £60,000 £57,500
Median salary % change year-on-year - +4.35% +4.55%
10th Percentile £35,000 £35,000 £33,250
90th Percentile £95,000 £90,000 £87,500
England median annual salary £50,000 £50,000 £50,000

Data Cleansing
Job Vacancy Trend in London

Job postings citing Data Cleansing as a percentage of all IT jobs advertised in London.

Job vacancy trend for Data Cleansing in London

Data Cleansing
Salary Trend in London

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

Salary trend for Data Cleansing in London

Data Cleansing
Salary Histogram in London

The salary distribution of IT jobs citing Data Cleansing in London over the 6 months to 17 July 2018.

Salary histogram for Data Cleansing in London

Data Cleansing
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Cleansing within the London region over the 6 months to 17 July 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Central London -15 51 £50,000 +22.70% 9
West London +19 18 £55,000 -8.33% 6
Data Cleansing
England

For the 6 months to 17 July 2018, IT jobs citing Data Cleansing also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the London region with a requirement for Data Cleansing.

1 91 (53.22%) SQL
2 65 (38.01%) Data Quality
3 60 (35.09%) Analytics
4 50 (29.24%) ETL
5 49 (28.65%) Data Modelling
6 45 (26.32%) Finance
6 45 (26.32%) Data Analysis
7 44 (25.73%) Degree
8 43 (25.15%) Business Intelligence
9 40 (23.39%) SQL Server
10 38 (22.22%) Python
11 35 (20.47%) Analytical Skills
12 32 (18.71%) Visualisation
13 30 (17.54%) Microsoft
13 30 (17.54%) Data Management
14 29 (16.96%) Oracle
14 29 (16.96%) Migration
14 29 (16.96%) Data Governance
15 28 (16.37%) Big Data
16 26 (15.20%) Data Migration
17 25 (14.62%) Microsoft Excel
18 24 (14.04%) Mathematics
18 24 (14.04%) Power BI
19 23 (13.45%) Relational Database
19 23 (13.45%) SQL Server Reporting Services
19 23 (13.45%) SQL Server Integration Services
19 23 (13.45%) Statistics
20 22 (12.87%) Machine Learning
20 22 (12.87%) Data Science
21 21 (12.28%) Tableau

Data Cleansing
Co-occurring 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 20 (11.70%) Apache Spark
2 9 (5.26%) SharePoint
3 8 (4.68%) SAS
4 5 (2.92%) Oracle Workflow
5 2 (1.17%) Confluence
6 1 (0.58%) Apache
Applications
1 25 (14.62%) Microsoft Excel
2 14 (8.19%) Microsoft Office
3 2 (1.17%) SPSS
4 1 (0.58%) Microsoft PowerPoint
Business Applications
1 13 (7.60%) Dynamics CRM
2 2 (1.17%) Dynamics AX
2 2 (1.17%) SAP CO
2 2 (1.17%) SAP ERP
2 2 (1.17%) SAP FI
2 2 (1.17%) SAP FI/CO
2 2 (1.17%) SAP MDG
2 2 (1.17%) SAP S/4HANA
3 1 (0.58%) Dynamics NAV
3 1 (0.58%) NetSuite
3 1 (0.58%) SAP MDM
Cloud Services
1 14 (8.19%) Microsoft Azure
2 11 (6.43%) Google Analytics
2 11 (6.43%) SaaS
3 8 (4.68%) Amazon AWS
3 8 (4.68%) Dynamics 365
4 4 (2.34%) Office 365
5 2 (1.17%) Cortana Intelligence Suite
5 2 (1.17%) Force.com
5 2 (1.17%) Google Tag Manager
6 1 (0.58%) Cloud Computing
6 1 (0.58%) GitHub
6 1 (0.58%) Google Cloud Platform
6 1 (0.58%) IaaS
6 1 (0.58%) Salesforce Sales Cloud
Communications & Networking
1 7 (4.09%) SMS
2 1 (0.58%) CHAP
2 1 (0.58%) Internet
2 1 (0.58%) Intranet
Database & Business Intelligence
1 40 (23.39%) SQL Server
2 28 (16.37%) Big Data
3 24 (14.04%) Power BI
4 23 (13.45%) Relational Database
4 23 (13.45%) SQL Server Integration Services
4 23 (13.45%) SQL Server Reporting Services
5 18 (10.53%) Data Warehouse
5 18 (10.53%) SQL Server Analysis Services
6 16 (9.36%) Data Mining
7 15 (8.77%) Crystal Reports
8 14 (8.19%) MongoDB
9 13 (7.60%) RDBMS
10 12 (7.02%) MySQL
10 12 (7.02%) NoSQL
11 11 (6.43%) QlikView
12 10 (5.85%) Apache Hive
12 10 (5.85%) Hadoop
12 10 (5.85%) Oracle Reports
13 9 (5.26%) Cosmos DB
13 9 (5.26%) Data Lake
Development Applications
1 8 (4.68%) JIRA
2 7 (4.09%) Dreamweaver
3 5 (2.92%) ERwin
3 5 (2.92%) SQL Server Management Studio (SSMS)
4 3 (1.75%) Jenkins
4 3 (1.75%) Subversion
4 3 (1.75%) Team Foundation Server
4 3 (1.75%) VSS/SourceSafe
5 2 (1.17%) LSMW
6 1 (0.58%) Bitbucket
6 1 (0.58%) JMeter
6 1 (0.58%) Oracle Forms
General
1 45 (26.32%) Finance
2 16 (9.36%) Banking
3 14 (8.19%) Marketing
4 9 (5.26%) Advertising
4 9 (5.26%) Investment Banking
5 6 (3.51%) Front Office
5 6 (3.51%) Law
6 4 (2.34%) Pharmaceutical
6 4 (2.34%) Retail
7 3 (1.75%) Publishing
8 2 (1.17%) Billing
8 2 (1.17%) General Ledger
8 2 (1.17%) Legal
9 1 (0.58%) Manufacturing
9 1 (0.58%) Retail Banking
Job Titles
1 53 (30.99%) Analyst
2 31 (18.13%) Data Analyst
3 25 (14.62%) Developer
4 20 (11.70%) Consultant
5 19 (11.11%) Data Scientist
6 11 (6.43%) Administrator
7 10 (5.85%) Data Manager
7 10 (5.85%) Salesforce Administrator
8 8 (4.68%) Data Consultant
9 7 (4.09%) Business Analyst
9 7 (4.09%) Business Intelligence Analyst
9 7 (4.09%) Campaign Executive
9 7 (4.09%) Data Quality Analyst
9 7 (4.09%) Marketing Executive
9 7 (4.09%) Quality Analyst
10 6 (3.51%) Architect
10 6 (3.51%) Business Intelligence Developer
10 6 (3.51%) CRM Consultant
10 6 (3.51%) Data Migration Consultant
10 6 (3.51%) Migration Consultant
Libraries, Frameworks & Software Standards
1 17 (9.94%) Natural Language Processing
2 7 (4.09%) D3.js
2 7 (4.09%) HTML
2 7 (4.09%) XML
3 6 (3.51%) Mason
3 6 (3.51%) Pandas
4 4 (2.34%) .NET
4 4 (2.34%) MDX
4 4 (2.34%) NumPy
4 4 (2.34%) SciPy
5 3 (1.75%) JSON
5 3 (1.75%) REST
5 3 (1.75%) SOAP
6 2 (1.17%) IDoc
6 2 (1.17%) Keras
6 2 (1.17%) SAP Fiori
6 2 (1.17%) TensorFlow
6 2 (1.17%) Visualforce
7 1 (0.58%) ggplot
7 1 (0.58%) Kafka
Miscellaneous
1 35 (20.47%) Analytical Skills
2 11 (6.43%) Management Information System
3 10 (5.85%) Self-Motivation
4 9 (5.26%) Analytical Mindset
5 8 (4.68%) Computer Science
6 7 (4.09%) Data Structures
7 5 (2.92%) Fintech
8 4 (2.34%) Algorithms
8 4 (2.34%) Life Science
9 3 (1.75%) NHS
10 2 (1.17%) Data Protection Act
10 2 (1.17%) Hedge funds
10 2 (1.17%) Replication
10 2 (1.17%) Social Media
11 1 (0.58%) Fixed Income
11 1 (0.58%) Greenfield Project
11 1 (0.58%) Reinsurance
11 1 (0.58%) Taxonomies
Operating Systems
1 9 (5.26%) Linux
2 4 (2.34%) Unix
3 3 (1.75%) Windows
4 2 (1.17%) Windows Server
Processes & Methodologies
1 60 (35.09%) Analytics
2 50 (29.24%) ETL
3 49 (28.65%) Data Modelling
4 45 (26.32%) Data Analysis
5 43 (25.15%) Business Intelligence
6 32 (18.71%) Visualisation
7 30 (17.54%) Data Management
8 29 (16.96%) Data Governance
8 29 (16.96%) Migration
9 26 (15.20%) Data Migration
10 24 (14.04%) Mathematics
11 23 (13.45%) Statistics
12 22 (12.87%) Data Science
12 22 (12.87%) Machine Learning
13 19 (11.11%) CRM
13 19 (11.11%) Problem-Solving
14 17 (9.94%) Validation
15 15 (8.77%) Data Engineering
15 15 (8.77%) Data Visualisation
16 14 (8.19%) Deep Learning
Programming Languages
1 91 (53.22%) SQL
2 38 (22.22%) Python
3 17 (9.94%) Java
3 17 (9.94%) T-SQL
4 12 (7.02%) R
5 10 (5.85%) PL/SQL
6 7 (4.09%) C++
7 5 (2.92%) C
7 5 (2.92%) VB
7 5 (2.92%) VBA
8 4 (2.34%) ABAP
8 4 (2.34%) Data Analysis Expressions (DAX)
8 4 (2.34%) JavaScript
9 3 (1.75%) PowerShell
9 3 (1.75%) Scala
10 2 (1.17%) Apex Code
11 1 (0.58%) Bash Shell
Qualifications
1 44 (25.73%) Degree
2 11 (6.43%) Security Cleared
3 4 (2.34%) Computer Science Degree
4 1 (0.58%) Master's Degree
4 1 (0.58%) Microsoft Certification
4 1 (0.58%) PhD
Quality Assurance & Compliance
1 65 (38.01%) Data Quality
2 20 (11.70%) GDPR
3 5 (2.92%) Solvency II
4 4 (2.34%) GxP
5 3 (1.75%) EMIR
5 3 (1.75%) MiFID
6 1 (0.58%) QA
System Software
1 9 (5.26%) Docker
Systems Management
1 9 (5.26%) Kubernetes
2 1 (0.58%) Mesos
Vendors
1 30 (17.54%) Microsoft
2 29 (16.96%) Oracle
3 21 (12.28%) Tableau
4 18 (10.53%) SAP
5 17 (9.94%) Salesforce.com
6 13 (7.60%) Google
7 11 (6.43%) IBM
8 7 (4.09%) Capita
9 6 (3.51%) Informatica
10 5 (2.92%) Ab Initio
11 4 (2.34%) Alteryx
12 3 (1.75%) Talend
12 3 (1.75%) WorldPay
13 2 (1.17%) Apple
13 2 (1.17%) Concur
13 2 (1.17%) Remedy
14 1 (0.58%) Conga
14 1 (0.58%) FIS
14 1 (0.58%) JD Edwards
14 1 (0.58%) SmartStream