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

Data Cleansing (Data Cleaning, Data Scrubbing)
England > London
6 months to
23 Oct 2018
Same period 2017 Same period 2016
Rank 695 656 651
Rank change year-on-year -39 -5 +104
Permanent jobs citing Data Cleansing 126 191 210
As % of all permanent IT jobs advertised in London 0.19% 0.26% 0.28%
As % of the Processes & Methodologies category 0.20% 0.28% 0.30%
Number of salaries quoted 94 118 212
London median annual salary £50,000 £57,500 £50,000
Median salary % change year-on-year -13.04% +15.00% -16.67%
10th Percentile £26,150 £37,500 £27,275
90th Percentile £84,250 £89,300 £79,750
England median annual salary £47,500 £47,500 £45,000
% change year-on-year - +5.56% +1.12%

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 62,403 69,281 70,188
As % of all permanent IT jobs advertised in London 91.70% 92.81% 92.00%
Number of salaries quoted 50,143 53,043 60,553
London median annual salary £62,500 £60,000 £57,500
Median salary % change year-on-year +4.17% +4.35% +4.55%
10th Percentile £35,000 £35,000 £33,260
90th Percentile £95,000 £90,000 £87,500
England median annual salary £52,500 £50,000 £50,000
% change year-on-year +5.00% - +5.26%

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 23 October 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 23 October 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 -14 36 £45,000 -5.26% 4
West London +9 6 £50,000 -13.04% 3
North London - 1 £34,500 -
East London - 1 £87,500 - 1
Data Cleansing
England

For the 6 months to 23 October 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 77 (61.11%) SQL
2 42 (33.33%) Finance
3 41 (32.54%) Analytics
4 38 (30.16%) Data Quality
5 34 (26.98%) Business Intelligence
6 32 (25.40%) Data Analysis
7 31 (24.60%) Microsoft Excel
7 31 (24.60%) ETL
8 29 (23.02%) Power BI
9 28 (22.22%) Python
10 27 (21.43%) Migration
10 27 (21.43%) Visualisation
11 24 (19.05%) SQL Server
12 22 (17.46%) Salesforce.com
12 22 (17.46%) Tableau
13 20 (15.87%) R
13 20 (15.87%) Data Migration
13 20 (15.87%) Marketing
13 20 (15.87%) Stakeholder Management
14 19 (15.08%) Microsoft
14 19 (15.08%) Data Warehouse
15 18 (14.29%) SQL Server Reporting Services
16 17 (13.49%) Data Visualisation
16 17 (13.49%) Data Modelling
16 17 (13.49%) SAP
17 16 (12.70%) XML
17 16 (12.70%) CRM
17 16 (12.70%) SQL Server Analysis Services
17 16 (12.70%) Data Management
17 16 (12.70%) Degree

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 9 (7.14%) SAS
2 8 (6.35%) Apache Spark
3 6 (4.76%) SharePoint
4 5 (3.97%) Oracle Workflow
5 2 (1.59%) Apache
6 1 (0.79%) CMS
6 1 (0.79%) Confluence
Applications
1 31 (24.60%) Microsoft Excel
2 7 (5.56%) Microsoft Office
3 6 (4.76%) SPSS
4 1 (0.79%) Microsoft PowerPoint
Business Applications
1 4 (3.17%) Dynamics CRM
2 2 (1.59%) Salesforce.com CRM
2 2 (1.59%) SAP CO
2 2 (1.59%) SAP FI
2 2 (1.59%) SAP FI/CO
3 1 (0.79%) Dynamics AX
3 1 (0.79%) iTrent
3 1 (0.79%) SAP ERP
3 1 (0.79%) SAP HR
Cloud Services
1 10 (7.94%) Amazon AWS
2 8 (6.35%) Google Analytics
3 6 (4.76%) Microsoft Azure
3 6 (4.76%) SaaS
4 5 (3.97%) Salesforce Sales Cloud
5 4 (3.17%) Cortana Intelligence Suite
5 4 (3.17%) Dynamics 365
5 4 (3.17%) Siri
6 2 (1.59%) Google Cloud Platform
6 2 (1.59%) Google Tag Manager
7 1 (0.79%) Cloud Computing
7 1 (0.79%) Office 365
Communications & Networking
1 4 (3.17%) SMS
2 1 (0.79%) CHAP
2 1 (0.79%) Internet
2 1 (0.79%) Intranet
Database & Business Intelligence
1 29 (23.02%) Power BI
2 24 (19.05%) SQL Server
3 19 (15.08%) Data Warehouse
4 18 (14.29%) SQL Server Reporting Services
5 16 (12.70%) SQL Server Analysis Services
5 16 (12.70%) SQL Server Integration Services
6 15 (11.90%) Hadoop
7 13 (10.32%) Big Data
8 12 (9.52%) Relational Database
9 11 (8.73%) Crystal Reports
10 10 (7.94%) MongoDB
10 10 (7.94%) MySQL
11 9 (7.14%) RDBMS
12 6 (4.76%) Apache Cassandra
12 6 (4.76%) Enterprise Data Warehouse
13 5 (3.97%) Data Mining
13 5 (3.97%) Oracle Reports
13 5 (3.97%) QlikView
14 4 (3.17%) Apache Hive
14 4 (3.17%) HBase
Development Applications
1 6 (4.76%) Subversion
2 4 (3.17%) Dreamweaver
2 4 (3.17%) JIRA
2 4 (3.17%) Team Foundation Server
3 3 (2.38%) VSS/SourceSafe
4 2 (1.59%) Oracle Forms
5 1 (0.79%) Bitbucket
5 1 (0.79%) JMeter
5 1 (0.79%) LSMW
5 1 (0.79%) Visual Studio Team System
General
1 42 (33.33%) Finance
2 20 (15.87%) Marketing
3 9 (7.14%) Banking
4 7 (5.56%) Front Office
4 7 (5.56%) Manufacturing
5 6 (4.76%) Electronics
5 6 (4.76%) Telecoms
6 5 (3.97%) Publishing
7 3 (2.38%) Retail
8 2 (1.59%) Billing
8 2 (1.59%) General Ledger
8 2 (1.59%) Investment Banking
8 2 (1.59%) Law
9 1 (0.79%) Advertising
9 1 (0.79%) Financial Institution
9 1 (0.79%) Music Industry
9 1 (0.79%) Pharmaceutical
Job Titles
1 39 (30.95%) Analyst
2 26 (20.63%) Data Analyst
3 25 (19.84%) Developer
4 18 (14.29%) Consultant
5 15 (11.90%) Data Engineer
6 14 (11.11%) Data Consultant
7 12 (9.52%) Administrator
7 12 (9.52%) Salesforce Administrator
7 12 (9.52%) Senior Analyst
8 8 (6.35%) Data Cleansing Analyst
8 8 (6.35%) Data Migration Consultant
8 8 (6.35%) Data Scientist
8 8 (6.35%) Migration Consultant
9 7 (5.56%) SQL Developer
10 5 (3.97%) Analyst Developer
10 5 (3.97%) Data Manager
10 5 (3.97%) Senior Data Engineer
10 5 (3.97%) SQL Server Developer
10 5 (3.97%) Technical Analyst
10 5 (3.97%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 16 (12.70%) XML
2 13 (10.32%) Natural Language Processing
3 7 (5.56%) JSON
4 6 (4.76%) .NET
4 6 (4.76%) Pandas
5 5 (3.97%) HTML
6 4 (3.17%) D3.js
6 4 (3.17%) MDX
6 4 (3.17%) NumPy
6 4 (3.17%) SciPy
7 3 (2.38%) TensorFlow
8 2 (1.59%) COM
8 2 (1.59%) CSS
8 2 (1.59%) Keras
9 1 (0.79%) .NET Framework
9 1 (0.79%) BAPI
9 1 (0.79%) Middleware
9 1 (0.79%) SOAP
9 1 (0.79%) Web Services
9 1 (0.79%) WinForms
Miscellaneous
1 15 (11.90%) Analytical Skills
2 9 (7.14%) Self-Motivation
3 8 (6.35%) Algorithms
3 8 (6.35%) Data Structures
4 7 (5.56%) Social Media
5 6 (4.76%) Analytical Mindset
5 6 (4.76%) Management Information System
6 5 (3.97%) NHS
7 4 (3.17%) Computer Science
8 2 (1.59%) Fintech
8 2 (1.59%) Hedge funds
9 1 (0.79%) Anti-Piracy
9 1 (0.79%) Data Protection Act
9 1 (0.79%) FMCG
9 1 (0.79%) Greenfield Project
9 1 (0.79%) Life Science
9 1 (0.79%) Reinsurance
Operating Systems
1 2 (1.59%) Linux
2 1 (0.79%) Unix
2 1 (0.79%) Windows
Processes & Methodologies
1 41 (32.54%) Analytics
2 34 (26.98%) Business Intelligence
3 32 (25.40%) Data Analysis
4 31 (24.60%) ETL
5 27 (21.43%) Migration
5 27 (21.43%) Visualisation
6 20 (15.87%) Data Migration
6 20 (15.87%) Stakeholder Management
7 17 (13.49%) Data Modelling
7 17 (13.49%) Data Visualisation
8 16 (12.70%) CRM
8 16 (12.70%) Data Management
9 14 (11.11%) Data Analytics
10 13 (10.32%) Data Governance
10 13 (10.32%) Machine Learning
10 13 (10.32%) Mathematics
11 12 (9.52%) Validation
12 11 (8.73%) Data Science
13 10 (7.94%) Predictive Modelling
13 10 (7.94%) Project Management
Programming Languages
1 77 (61.11%) SQL
2 28 (22.22%) Python
3 20 (15.87%) R
4 15 (11.90%) T-SQL
5 10 (7.94%) Java
6 8 (6.35%) PL/SQL
7 7 (5.56%) VBA
8 6 (4.76%) VB
9 4 (3.17%) Data Analysis Expressions (DAX)
9 4 (3.17%) JavaScript
10 3 (2.38%) PowerShell
10 3 (2.38%) Scala
11 2 (1.59%) C++
12 1 (0.79%) C
12 1 (0.79%) C#
12 1 (0.79%) Java 8
Qualifications
1 16 (12.70%) Degree
2 5 (3.97%) Security Cleared
3 2 (1.59%) DBS Check
3 2 (1.59%) PhD
4 1 (0.79%) CIPD
4 1 (0.79%) Computer Science Degree
4 1 (0.79%) ISEB
4 1 (0.79%) Master's Degree
4 1 (0.79%) Microsoft Certification
4 1 (0.79%) PRINCE2 Certification
Quality Assurance & Compliance
1 38 (30.16%) Data Quality
2 13 (10.32%) GDPR
3 3 (2.38%) Solvency II
4 2 (1.59%) Cyber Essentials
4 2 (1.59%) QA
5 1 (0.79%) EMIR
5 1 (0.79%) GxP
5 1 (0.79%) MiFID
Vendors
1 22 (17.46%) Salesforce.com
1 22 (17.46%) Tableau
2 19 (15.08%) Microsoft
3 17 (13.49%) SAP
4 13 (10.32%) Google
5 12 (9.52%) Oracle
6 9 (7.14%) IBM
7 4 (3.17%) Apple
8 3 (2.38%) Mapinfo
9 2 (1.59%) Concur
9 2 (1.59%) Remedy
10 1 (0.79%) Ab Initio
10 1 (0.79%) Alteryx
10 1 (0.79%) hybris
10 1 (0.79%) MuleSoft
10 1 (0.79%) Splunk