Period
to 13 December 2017

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 13 December 2017 with a comparison to the same period in the previous 2 years.

Data Cleansing (Data Cleaning, Data Scrubbing)
England > London
6 months to
13 Dec 2017
Same period 2016 Same period 2015
Rank 633 653 733
Rank change year-on-year +20 +80 -34
Permanent jobs citing Data Cleansing 213 179 176
As % of all permanent IT jobs advertised in London 0.29% 0.24% 0.20%
As % of the Processes & Methodologies category 0.31% 0.27% 0.22%
Number of salaries quoted 124 166 117
London median annual salary £57,500 £50,000 £47,500
Median salary % change year-on-year +15.00% +5.26% -9.52%
10th Percentile £32,950 £26,250 £28,007
90th Percentile £87,500 £80,000 £81,000
England median annual salary £47,500 £44,000 £42,500
% change year-on-year +7.95% +3.53% -2.30%

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 68044 67375 78487
As % of all permanent IT jobs advertised in London 91.66% 90.61% 89.67%
Number of salaries quoted 52862 57726 66470
London median annual salary £60,000 £59,000 £55,000
Median salary % change year-on-year +1.69% +7.27% -
10th Percentile £35,000 £33,750 £33,500
90th Percentile £90,000 £90,000 £86,500
England median annual salary £50,000 £50,000 £47,500
% change year-on-year - +5.26% +5.56%

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 13 December 2017.

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 13 December 2017. 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 -5 34 £47,500 -17.39% 2
West London +30 22 £57,500 +38.55%
South London -14 2 £80,000 +77.78%
Data Cleansing
England

For the 6 months to 13 December 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 London region with a requirement for Data Cleansing.

1 123 (57.75%) Finance
2 100 (46.95%) SQL
3 83 (38.97%) Oracle
3 83 (38.97%) Data Management
4 72 (33.80%) Degree
5 66 (30.99%) Analytics
6 65 (30.52%) Master Data Management
7 63 (29.58%) Data Quality
8 60 (28.17%) Asset Management
9 58 (27.23%) Wealth Management
9 58 (27.23%) SQL Server
9 58 (27.23%) ETL
10 55 (25.82%) Data Modelling
10 55 (25.82%) Microsoft Excel
10 55 (25.82%) Data Analytics
11 53 (24.88%) Banking
12 50 (23.47%) Legal
13 49 (23.00%) Project Management
13 49 (23.00%) Java
14 47 (22.07%) Reference Data
15 46 (21.60%) Migration
16 45 (21.13%) Business Intelligence
16 45 (21.13%) Retail Banking
17 44 (20.66%) Investment Banking
17 44 (20.66%) Microsoft
17 44 (20.66%) Oracle Database 10g
17 44 (20.66%) J2EE
17 44 (20.66%) Oracle Database
18 41 (19.25%) Data Analysis
19 38 (17.84%) Data Governance

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 25 (11.74%) SAS
2 16 (7.51%) Apache Spark
3 15 (7.04%) SharePoint
4 14 (6.57%) Oracle Workflow
5 11 (5.16%) IIS
6 3 (1.41%) Apache
7 2 (0.94%) ArcGIS
7 2 (0.94%) Mule
7 2 (0.94%) Mule ESB
8 1 (0.47%) Elasticsearch
Applications
1 55 (25.82%) Microsoft Excel
2 24 (11.27%) SPSS
3 8 (3.76%) Microsoft Office
3 8 (3.76%) Microsoft PowerPoint
3 8 (3.76%) MS Visio
4 1 (0.47%) Microsoft Project
Business Applications
1 3 (1.41%) Dynamics CRM
2 2 (0.94%) Adobe Campaign
2 2 (0.94%) FastStats
3 1 (0.47%) Investran
Cloud Services
1 21 (9.86%) Amazon AWS
2 10 (4.69%) Amazon Kinesis
2 10 (4.69%) Google Cloud Platform
3 7 (3.29%) Microsoft Azure
4 6 (2.82%) Salesforce Service Cloud
5 2 (0.94%) Amazon EMR
5 2 (0.94%) Amazon S3
5 2 (0.94%) Google Analytics
6 1 (0.47%) Adobe Analytics
6 1 (0.47%) Cortana Intelligence Suite
6 1 (0.47%) Dynamics 365
6 1 (0.47%) Google Tag Manager
6 1 (0.47%) Salesforce Sales Cloud
Communications & Networking
1 1 (0.47%) Internet
Database & Business Intelligence
1 58 (27.23%) SQL Server
2 44 (20.66%) Oracle Database
2 44 (20.66%) Oracle Database 10g
3 36 (16.90%) SQL Server Integration Services
4 33 (15.49%) Data Warehouse
5 26 (12.21%) Crystal Reports
6 25 (11.74%) SQL Server Reporting Services
7 24 (11.27%) Spotfire
8 18 (8.45%) QlikView
9 16 (7.51%) Big Data
10 14 (6.57%) Oracle Reports
11 13 (6.10%) Hadoop
11 13 (6.10%) SQL Server Analysis Services
12 12 (5.63%) Data Mining
13 11 (5.16%) Amazon Redshift
13 11 (5.16%) Apache Cassandra
14 10 (4.69%) BigQuery
14 10 (4.69%) NoSQL
14 10 (4.69%) SAS Visual Analytics
15 9 (4.23%) Power BI
Development Applications
1 20 (9.39%) Talend Open Studio
2 11 (5.16%) SQL Server Management Studio (SSMS)
3 9 (4.23%) JIRA
4 5 (2.35%) Eclipse
4 5 (2.35%) Visual Studio
5 4 (1.88%) Git (software)
6 1 (0.47%) ERwin
6 1 (0.47%) Jenkins
General
1 123 (57.75%) Finance
2 53 (24.88%) Banking
3 50 (23.47%) Legal
4 45 (21.13%) Retail Banking
5 44 (20.66%) Investment Banking
6 24 (11.27%) Marketing
7 15 (7.04%) Front Office
8 13 (6.10%) Retail
9 6 (2.82%) Back Office
10 5 (2.35%) Advertising
10 5 (2.35%) Law
11 1 (0.47%) Automotive
11 1 (0.47%) Pharmaceutical
11 1 (0.47%) Publishing
Job Titles
1 53 (24.88%) Technical Leader
2 48 (22.54%) Analyst
3 41 (19.25%) Developer
4 32 (15.02%) Data Analyst
5 17 (7.98%) SQL Developer
6 13 (6.10%) Senior Developer
7 12 (5.63%) Business Intelligence Developer
7 12 (5.63%) Data Scientist
8 11 (5.16%) Architect
9 10 (4.69%) Administrator
9 10 (4.69%) Business Analyst
9 10 (4.69%) Data Architect
10 9 (4.23%) Applications Support
10 9 (4.23%) Applications Support Analyst
11 8 (3.76%) Data Analytics Scientist
11 8 (3.76%) Data Migration Analyst
11 8 (3.76%) Migration Analyst
11 8 (3.76%) Salesforce Administrator
11 8 (3.76%) Technical Developer
12 7 (3.29%) Data Migration Business Analyst
Libraries, Frameworks & Software Standards
1 44 (20.66%) J2EE
2 22 (10.33%) .NET
2 22 (10.33%) .NET Framework
3 21 (9.86%) Web Services
4 12 (5.63%) JSON
5 11 (5.16%) D3.js
5 11 (5.16%) Middleware
6 10 (4.69%) AngularJS
6 10 (4.69%) CSS
6 10 (4.69%) HTML
6 10 (4.69%) HTML5
6 10 (4.69%) React
7 9 (4.23%) Pandas
7 9 (4.23%) RESTful
8 6 (2.82%) Node.js
9 5 (2.35%) Kafka
9 5 (2.35%) Natural Language Processing
10 4 (1.88%) Celery
10 4 (1.88%) NumPy
10 4 (1.88%) Scrapy
Miscellaneous
1 47 (22.07%) Reference Data
2 31 (14.55%) Management Information System
3 21 (9.86%) Analytical Skills
4 13 (6.10%) Algorithms
5 10 (4.69%) Analytical Mindset
5 10 (4.69%) Computer Science
5 10 (4.69%) Social Media
5 10 (4.69%) User Experience
6 4 (1.88%) FMCG
7 2 (0.94%) Data Structures
7 2 (0.94%) Enterprise Software
7 2 (0.94%) Fintech
7 2 (0.94%) Life Science
7 2 (0.94%) Replication
8 1 (0.47%) Greenfield Project
8 1 (0.47%) Linux Command Line
8 1 (0.47%) Minimum Viable Product
8 1 (0.47%) Taxonomies
Operating Systems
1 10 (4.69%) Windows
2 9 (4.23%) Windows Server
3 4 (1.88%) Linux
Processes & Methodologies
1 83 (38.97%) Data Management
2 66 (30.99%) Analytics
3 65 (30.52%) Master Data Management
4 60 (28.17%) Asset Management
5 58 (27.23%) ETL
5 58 (27.23%) Wealth Management
6 55 (25.82%) Data Analytics
6 55 (25.82%) Data Modelling
7 49 (23.00%) Project Management
8 46 (21.60%) Migration
9 45 (21.13%) Business Intelligence
10 41 (19.25%) Data Analysis
11 38 (17.84%) Data Governance
12 37 (17.37%) Data Migration
13 35 (16.43%) Visualisation
14 29 (13.62%) Machine Learning
15 27 (12.68%) Data Visualisation
16 25 (11.74%) Mathematics
17 22 (10.33%) Data Architecture
18 21 (9.86%) Business Analysis
Programming Languages
1 100 (46.95%) SQL
2 49 (23.00%) Java
3 33 (15.49%) Python
4 31 (14.55%) R
5 22 (10.33%) T-SQL
6 21 (9.86%) Scala
7 19 (8.92%) JavaScript
8 18 (8.45%) VBA
9 16 (7.51%) PL/SQL
10 15 (7.04%) VB
11 7 (3.29%) Data Analysis Expressions (DAX)
12 6 (2.82%) Apex Code
12 6 (2.82%) C#
13 2 (0.94%) Bash Shell
14 1 (0.47%) C
14 1 (0.47%) C++
Qualifications
1 72 (33.80%) Degree
2 10 (4.69%) PhD
3 9 (4.23%) MCITP
3 9 (4.23%) MCTS
3 9 (4.23%) Microsoft Certification
4 7 (3.29%) Computer Science Degree
5 2 (0.94%) CBAP
5 2 (0.94%) IIBA
5 2 (0.94%) ISEB
5 2 (0.94%) Numerate Degree
5 2 (0.94%) Security Cleared
6 1 (0.47%) DV Cleared
Quality Assurance & Compliance
1 63 (29.58%) Data Quality
2 11 (5.16%) CRD IV
2 11 (5.16%) EMIR
2 11 (5.16%) GDPR
2 11 (5.16%) MiFID
3 7 (3.29%) QA
4 6 (2.82%) PMO
4 6 (2.82%) SEPA
5 3 (1.41%) SLA
6 1 (0.47%) Actionable Recommendations
6 1 (0.47%) Solvency II
System Software
1 5 (2.35%) Docker
2 2 (0.94%) Apache Flume
2 2 (0.94%) HDFS
Systems Management
1 2 (0.94%) Hadoop YARN
2 1 (0.47%) Mesos
Vendors
1 83 (38.97%) Oracle
2 44 (20.66%) Microsoft
3 28 (13.15%) Tableau
4 21 (9.86%) Salesforce.com
5 20 (9.39%) Informatica
5 20 (9.39%) Talend
6 14 (6.57%) Teradata
7 13 (6.10%) Google
8 12 (5.63%) Cloudera
9 11 (5.16%) Alteryx
10 10 (4.69%) Netezza
11 7 (3.29%) IBM
11 7 (3.29%) Sybase
12 5 (2.35%) Pega
13 3 (1.41%) Adobe
14 2 (0.94%) ESRI
14 2 (0.94%) Progress
14 2 (0.94%) SolarWinds
15 1 (0.47%) Conga
15 1 (0.47%) Marketo