Period
to 22 April 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 22 April 2018 with a comparison to the same period in the previous 2 years.

Data Cleansing (Data Cleaning, Data Scrubbing)
England > London
6 months to
22 Apr 2018
Same period 2017 Same period 2016
Rank 635 615 718
Rank change year-on-year -20 +103 -67
Permanent jobs citing Data Cleansing 193 207 182
As % of all permanent IT jobs advertised in London 0.28% 0.30% 0.22%
As % of the Processes & Methodologies category 0.30% 0.33% 0.24%
Number of salaries quoted 143 179 170
London median annual salary £58,500 £45,000 £42,500
Median salary % change year-on-year +30.00% +5.88% -22.73%
10th Percentile £31,250 £30,000 £29,650
90th Percentile £90,000 £77,500 £79,125
England median annual salary £48,500 £42,500 £41,500
% change year-on-year +14.12% +2.41% -17.00%

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 64,259 62,586 76,440
As % of all permanent IT jobs advertised in London 91.80% 91.25% 91.05%
Number of salaries quoted 52,663 52,508 65,507
London median annual salary £60,000 £60,000 £55,000
Median salary % change year-on-year - +9.09% -
10th Percentile £35,750 £34,000 £33,500
90th Percentile £93,750 £90,000 £87,500
England median annual salary £50,000 £50,000 £47,500
% change year-on-year - +5.26% +2.15%

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 22 April 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 22 April 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 -42 47 £62,500 +60.26% 8
West London +29 18 £57,500 +12.20% 4
South London -20 1 £55,000 +41.94% 2
Data Cleansing
England

For the 6 months to 22 April 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 114 (59.07%) SQL
2 86 (44.56%) Data Quality
3 69 (35.75%) Analytics
4 66 (34.20%) Finance
5 58 (30.05%) Data Modelling
6 57 (29.53%) ETL
7 51 (26.42%) Data Governance
8 49 (25.39%) Microsoft Excel
9 48 (24.87%) Oracle
9 48 (24.87%) Microsoft
10 47 (24.35%) Visualisation
11 45 (23.32%) Business Intelligence
12 44 (22.80%) SQL Server
13 42 (21.76%) Degree
14 40 (20.73%) Data Analysis
15 38 (19.69%) Big Data
16 37 (19.17%) Data Analytics
17 36 (18.65%) Migration
18 35 (18.13%) SQL Server Integration Services
19 34 (17.62%) Python
19 34 (17.62%) Machine Learning
19 34 (17.62%) Analytical Skills
20 33 (17.10%) Tableau
20 33 (17.10%) Problem-Solving
20 33 (17.10%) Data Management
20 33 (17.10%) Data Migration
21 30 (15.54%) Data Science
21 30 (15.54%) Apache Spark
22 29 (15.03%) SAS
23 28 (14.51%) Management Information System

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 30 (15.54%) Apache Spark
2 29 (15.03%) SAS
3 21 (10.88%) SharePoint
4 16 (8.29%) Oracle Workflow
5 4 (2.07%) IIS
6 2 (1.04%) Apache
6 2 (1.04%) Mule
6 2 (1.04%) Mule ESB
7 1 (0.52%) Confluence
Applications
1 49 (25.39%) Microsoft Excel
2 20 (10.36%) SPSS
3 12 (6.22%) Microsoft Office
4 3 (1.55%) MS Visio
5 2 (1.04%) Microsoft PowerPoint
6 1 (0.52%) Microsoft Project
Business Applications
1 14 (7.25%) Dynamics CRM
2 2 (1.04%) SAP ERP
2 2 (1.04%) SAP MDG
2 2 (1.04%) SAP S/4HANA
3 1 (0.52%) Dynamics AX
3 1 (0.52%) Dynamics NAV
3 1 (0.52%) NetSuite
3 1 (0.52%) SAP MDM
Cloud Services
1 17 (8.81%) Amazon AWS
2 16 (8.29%) Microsoft Azure
3 9 (4.66%) Dynamics 365
4 8 (4.15%) Amazon Kinesis
4 8 (4.15%) Google Cloud Platform
5 5 (2.59%) Cortana Intelligence Suite
6 4 (2.07%) Office 365
7 3 (1.55%) SaaS
8 2 (1.04%) Force.com
8 2 (1.04%) Salesforce Sales Cloud
9 1 (0.52%) Adobe Analytics
9 1 (0.52%) Amazon EMR
9 1 (0.52%) Amazon S3
9 1 (0.52%) Cloud Computing
9 1 (0.52%) GitHub
9 1 (0.52%) Google Analytics
9 1 (0.52%) IaaS
Communications & Networking
1 3 (1.55%) SMS
2 1 (0.52%) Internet
Database & Business Intelligence
1 44 (22.80%) SQL Server
2 38 (19.69%) Big Data
3 35 (18.13%) SQL Server Integration Services
4 25 (12.95%) Power BI
5 24 (12.44%) Crystal Reports
5 24 (12.44%) QlikView
6 23 (11.92%) Data Mining
7 21 (10.88%) Data Warehouse
7 21 (10.88%) Oracle Reports
8 20 (10.36%) SQL Server Reporting Services
9 17 (8.81%) Relational Database
9 17 (8.81%) Spotfire
10 15 (7.77%) Apache Hive
11 14 (7.25%) NoSQL
12 13 (6.74%) Apache Cassandra
12 13 (6.74%) Hadoop
12 13 (6.74%) SQL Server Analysis Services
13 10 (5.18%) MongoDB
14 9 (4.66%) Amazon Redshift
14 9 (4.66%) Cosmos DB
Development Applications
1 8 (4.15%) ERwin
2 7 (3.63%) SQL Server Management Studio (SSMS)
3 6 (3.11%) JIRA
4 4 (2.07%) Jenkins
5 3 (1.55%) Dreamweaver
6 2 (1.04%) LSMW
7 1 (0.52%) Eclipse
7 1 (0.52%) Git (software)
7 1 (0.52%) Oracle Forms
7 1 (0.52%) Visual Studio
General
1 66 (34.20%) Finance
2 20 (10.36%) Banking
2 20 (10.36%) Marketing
3 16 (8.29%) Front Office
4 10 (5.18%) Advertising
5 7 (3.63%) Investment Banking
6 4 (2.07%) Law
6 4 (2.07%) Retail
7 3 (1.55%) Legal
7 3 (1.55%) Pharmaceutical
8 1 (0.52%) Automotive
8 1 (0.52%) Publishing
8 1 (0.52%) Retail Banking
Job Titles
1 50 (25.91%) Analyst
2 38 (19.69%) Developer
3 25 (12.95%) Data Analyst
4 16 (8.29%) Consultant
5 15 (7.77%) Data Scientist
5 15 (7.77%) SQL Developer
6 14 (7.25%) Administrator
7 12 (6.22%) Business Intelligence Developer
7 12 (6.22%) Salesforce Administrator
8 10 (5.18%) Analytics Manager
9 9 (4.66%) CRM Consultant
10 8 (4.15%) Business Analyst
10 8 (4.15%) Data Manager
10 8 (4.15%) Data Modeller
10 8 (4.15%) Excel Developer
10 8 (4.15%) Excel VBA Developer
10 8 (4.15%) Lead Developer
10 8 (4.15%) Senior Manager
10 8 (4.15%) Technical Leader
10 8 (4.15%) VBA Developer
Libraries, Frameworks & Software Standards
1 20 (10.36%) D3.js
1 20 (10.36%) Natural Language Processing
2 17 (8.81%) .NET
2 17 (8.81%) .NET Framework
3 11 (5.70%) HTML
4 10 (5.18%) Web Services
5 8 (4.15%) AngularJS
5 8 (4.15%) CSS
5 8 (4.15%) HTML5
5 8 (4.15%) React
6 7 (3.63%) JSON
7 5 (2.59%) XML
8 4 (2.07%) Kafka
8 4 (2.07%) Middleware
9 2 (1.04%) Akka
9 2 (1.04%) IDoc
9 2 (1.04%) Pandas
9 2 (1.04%) REST
9 2 (1.04%) SAP Fiori
9 2 (1.04%) Visualforce
Miscellaneous
1 34 (17.62%) Analytical Skills
2 28 (14.51%) Management Information System
3 20 (10.36%) Self-Motivation
4 12 (6.22%) Computer Science
5 8 (4.15%) Analytical Mindset
5 8 (4.15%) User Experience
6 4 (2.07%) Data Structures
7 3 (1.55%) Fintech
7 3 (1.55%) Life Science
8 2 (1.04%) Algorithms
8 2 (1.04%) Replication
8 2 (1.04%) Social Media
9 1 (0.52%) Data Protection Act
9 1 (0.52%) Fixed Income
9 1 (0.52%) Linux Command Line
9 1 (0.52%) Minimum Viable Product
9 1 (0.52%) NHS
9 1 (0.52%) Reinsurance
9 1 (0.52%) Taxonomies
Operating Systems
1 9 (4.66%) Linux
2 3 (1.55%) Unix
2 3 (1.55%) Windows
3 2 (1.04%) Windows Server
Processes & Methodologies
1 69 (35.75%) Analytics
2 58 (30.05%) Data Modelling
3 57 (29.53%) ETL
4 51 (26.42%) Data Governance
5 47 (24.35%) Visualisation
6 45 (23.32%) Business Intelligence
7 40 (20.73%) Data Analysis
8 37 (19.17%) Data Analytics
9 36 (18.65%) Migration
10 34 (17.62%) Machine Learning
11 33 (17.10%) Data Management
11 33 (17.10%) Data Migration
11 33 (17.10%) Problem-Solving
12 30 (15.54%) Data Science
13 27 (13.99%) Statistics
14 26 (13.47%) Data Visualisation
15 22 (11.40%) CRM
16 21 (10.88%) Wealth Management
17 20 (10.36%) Mathematics
18 19 (9.84%) Asset Management
Programming Languages
1 114 (59.07%) SQL
2 34 (17.62%) Python
3 23 (11.92%) R
4 18 (9.33%) PL/SQL
5 16 (8.29%) VB
5 16 (8.29%) VBA
6 12 (6.22%) T-SQL
7 11 (5.70%) JavaScript
8 10 (5.18%) Java
9 8 (4.15%) Apex Code
9 8 (4.15%) Data Analysis Expressions (DAX)
10 7 (3.63%) C++
11 6 (3.11%) C
12 4 (2.07%) ABAP
12 4 (2.07%) Scala
13 2 (1.04%) Bash Shell
Qualifications
1 42 (21.76%) Degree
2 10 (5.18%) Security Cleared
3 4 (2.07%) Computer Science Degree
4 2 (1.04%) MCITP
4 2 (1.04%) MCTS
4 2 (1.04%) Microsoft Certification
5 1 (0.52%) DV Cleared
Quality Assurance & Compliance
1 86 (44.56%) Data Quality
2 20 (10.36%) GDPR
3 10 (5.18%) Solvency II
4 9 (4.66%) EMIR
4 9 (4.66%) MiFID
5 6 (3.11%) CRD IV
6 3 (1.55%) GxP
6 3 (1.55%) QA
7 2 (1.04%) SLA
8 1 (0.52%) Dodd-Frank
8 1 (0.52%) FATCA
System Software
1 10 (5.18%) Docker
2 1 (0.52%) Apache Flume
2 1 (0.52%) HDFS
Systems Management
1 9 (4.66%) Kubernetes
2 2 (1.04%) Mesos
3 1 (0.52%) Hadoop YARN
Vendors
1 48 (24.87%) Microsoft
1 48 (24.87%) Oracle
2 33 (17.10%) Tableau
3 19 (9.84%) Informatica
4 16 (8.29%) Salesforce.com
5 14 (7.25%) Google
6 12 (6.22%) Talend
7 11 (5.70%) Alteryx
7 11 (5.70%) IBM
7 11 (5.70%) SAP
8 9 (4.66%) Cloudera
8 9 (4.66%) Teradata
9 8 (4.15%) Ab Initio
9 8 (4.15%) Netezza
10 5 (2.59%) Apple
11 3 (1.55%) Capita
11 3 (1.55%) WorldPay
12 2 (1.04%) SolarWinds
13 1 (0.52%) Omniture
13 1 (0.52%) Pega