Period
to 27 October 2020

The following table provides summary statistics for permanent job vacancies 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 27 October 2020 with a comparison to the same period in the previous 2 years.

Data Cleansing (Data Cleaning, Data Scrubbing)
UK
6 months to
27 Oct 2020
Same period 2019 Same period 2018
Rank 560 672 686
Rank change year-on-year +112 +14 +20
Permanent jobs citing Data Cleansing 137 423 519
As % of all permanent jobs advertised in the UK 0.28% 0.31% 0.32%
As % of the Processes & Methodologies category 0.30% 0.34% 0.35%
Number of salaries quoted 143 352 376
Median annual salary £55,000 £50,000 £48,000
Median salary % change year-on-year +10.00% +4.17% +1.05%
10th Percentile £32,500 £30,000 £27,500
90th Percentile £80,000 £78,750 £78,125
UK excluding London median annual salary £50,000 £44,000 £47,500
% change year-on-year +13.64% -7.37% +18.75%

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 with a requirement for process or methodology skills.

All Process and Methodology Skills
UK
Permanent vacancies with a requirement for process or methodology skills 45,731 125,361 150,391
As % of all permanent IT jobs advertised in the UK 92.42% 92.21% 91.94%
Number of salaries quoted 37,669 98,831 119,518
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% -
10th Percentile £32,750 £30,000 £29,000
90th Percentile £90,000 £86,250 £83,750
UK excluding London median annual salary £49,000 £45,000 £45,000
% change year-on-year +8.89% - +5.88%

Data Cleansing
Job Vacancy Trend

Job postings citing Data Cleansing as a proportion of all IT jobs advertised.

Job vacancy trend for Data Cleansing in the UK

Data Cleansing
Salary Trend

3-month moving average salary quoted in jobs citing Data Cleansing.

Salary trend for Data Cleansing in the UK

Data Cleansing
Salary Histogram

Salary distribution for jobs citing Data Cleansing over the 6 months to 27 October 2020.

Salary histogram for Data Cleansing in the UK

Data Cleansing
Top 16 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Cleansing within the UK over the 6 months to 27 October 2020. 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
England +132 128 £55,000 +7.84% 29
UK excluding London +158 69 £50,000 +13.64% 16
London +136 65 £61,000 +12.96% 16
Work from Home +33 26 £55,000 +44.74% 9
North of England +131 16 £55,000 +44.74% 4
South West +117 14 £49,000 -9.26% 1
Midlands +107 14 £40,000 -7.51% 5
South East +126 12 £52,500 +5.00% 3
North West +112 11 £55,000 +10.00% 3
West Midlands +75 11 £40,000 -5.88% 5
East of England +129 6 £35,000 -5.41%
Scotland +87 5 £46,250 +20.13% 2
Yorkshire +113 4 £45,000 +28.57% 1
East Midlands +88 3 £33,000 -34.00%
Wales +46 2 £50,000 +19.76% 1
North East +26 1 £55,000 -

For the 6 months to 27 October 2020, 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 with a requirement for Data Cleansing.

1 64 (46.72%) SQL
2 52 (37.96%) Data Analysis
3 50 (36.50%) Business Intelligence
4 47 (34.31%) Python
5 41 (29.93%) Analytics
6 36 (26.28%) Data Modelling
6 36 (26.28%) Azure
7 34 (24.82%) Finance
8 33 (24.09%) Analytical Skills
9 30 (21.90%) SQL Server
10 29 (21.17%) Data Quality
10 29 (21.17%) Machine Learning
11 28 (20.44%) Power Platform
12 27 (19.71%) Big Data
12 27 (19.71%) Degree
12 27 (19.71%) Migration
12 27 (19.71%) Agile Software Development
13 25 (18.25%) ETL
13 25 (18.25%) Computer Science
14 24 (17.52%) AWS
14 24 (17.52%) Visualisation
14 24 (17.52%) Microsoft
15 23 (16.79%) Microsoft Excel
15 23 (16.79%) Power BI
15 23 (16.79%) Data Science
16 22 (16.06%) Data Warehouse
16 22 (16.06%) Mathematics
17 20 (14.60%) Data Analytics
18 19 (13.87%) R
19 18 (13.14%) Data Governance

Data Cleansing
Co-occurring IT Skills 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 8 (5.84%) Apache Spark
2 7 (5.11%) Confluence
3 2 (1.46%) Elasticsearch
3 2 (1.46%) SharePoint
4 1 (0.73%) BizTalk Server
4 1 (0.73%) SAS
Applications
1 23 (16.79%) Microsoft Excel
2 2 (1.46%) GNU Octave
3 1 (0.73%) Microsoft Office
3 1 (0.73%) Spreadsheet
Business Applications
1 7 (5.11%) Dynamics CRM
2 5 (3.65%) Dynamics AX
3 2 (1.46%) CODA-Financials
3 2 (1.46%) Dynamics GP
3 2 (1.46%) Dynamics NAV
3 2 (1.46%) Infor SunSystems
3 2 (1.46%) Magento
3 2 (1.46%) NetSuite
3 2 (1.46%) Shopify
3 2 (1.46%) Unit4 Business World
4 1 (0.73%) Salesforce.com CRM
4 1 (0.73%) SAP Business One
4 1 (0.73%) SAP MDG
4 1 (0.73%) SAP MDM
4 1 (0.73%) SAP SD
4 1 (0.73%) Sparx Enterprise Architect
Cloud Services
1 36 (26.28%) Azure
2 28 (20.44%) Power Platform
3 24 (17.52%) AWS
4 12 (8.76%) Azure Data Factory
5 9 (6.57%) GCP
6 8 (5.84%) Dynamics 365
7 6 (4.38%) Amazon S3
8 5 (3.65%) G Suite
8 5 (3.65%) Logic Apps
8 5 (3.65%) Serverless
9 2 (1.46%) Office 365
9 2 (1.46%) SaaS
10 1 (0.73%) Cloud Computing
10 1 (0.73%) Google Analytics
10 1 (0.73%) Google Tag Manager
Communications & Networking
1 1 (0.73%) Skype
Database & Business Intelligence
1 30 (21.90%) SQL Server
2 27 (19.71%) Big Data
3 23 (16.79%) Power BI
4 22 (16.06%) Data Warehouse
5 18 (13.14%) Data Mining
6 17 (12.41%) Tableau
7 16 (11.68%) SQL Server Integration Services
8 15 (10.95%) Data Lake
8 15 (10.95%) SQL Server Reporting Services
9 14 (10.22%) Relational Database
10 8 (5.84%) Hadoop
10 8 (5.84%) NoSQL
11 5 (3.65%) Azure SQL Database
11 5 (3.65%) SQL Server Analysis Services
12 3 (2.19%) Amazon RDS
12 3 (2.19%) Amazon Redshift
12 3 (2.19%) PowerPivot
13 2 (1.46%) MongoDB
13 2 (1.46%) Oracle ODI
13 2 (1.46%) SQL Server 2008
Development Applications
1 10 (7.30%) JIRA
2 5 (3.65%) Visual Studio
3 1 (0.73%) ERwin
3 1 (0.73%) Flyway
3 1 (0.73%) Jenkins
3 1 (0.73%) Liquibase
3 1 (0.73%) LSMW
3 1 (0.73%) ProC
General
1 34 (24.82%) Finance
2 9 (6.57%) Games
3 6 (4.38%) Banking
3 6 (4.38%) Marketing
4 3 (2.19%) Retail
5 2 (1.46%) Front Office
6 1 (0.73%) General Ledger
6 1 (0.73%) Legal
6 1 (0.73%) Manufacturing
6 1 (0.73%) Pharmaceutical
6 1 (0.73%) Public Sector
6 1 (0.73%) Publishing
Job Titles
1 45 (32.85%) Analyst
2 24 (17.52%) Data Analyst
3 23 (16.79%) Developer
4 22 (16.06%) Data Engineer
5 21 (15.33%) Business Analyst
6 17 (12.41%) Data Scientist
7 14 (10.22%) Data Business Analyst
8 12 (8.76%) Business Intelligence Developer
9 10 (7.30%) Agile Business Analyst
10 9 (6.57%) Architect
11 8 (5.84%) Azure Developer
11 8 (5.84%) Lead Developer
12 5 (3.65%) Business Developer
12 5 (3.65%) Business Intelligence Analyst
12 5 (3.65%) Business Intelligence Lead
12 5 (3.65%) CRM Architect
12 5 (3.65%) Dynamics CRM Architect
12 5 (3.65%) Project Analyst
12 5 (3.65%) Technical Architect
13 4 (2.92%) Python Developer
Libraries, Frameworks & Software Standards
1 12 (8.76%) HTML
2 11 (8.03%) XML
3 8 (5.84%) .NET
4 7 (5.11%) Kafka
5 6 (4.38%) ASP.NET
6 5 (3.65%) ASP.NET Web API
6 5 (3.65%) CSS
6 5 (3.65%) HTML5 Canvas
6 5 (3.65%) Pandas
6 5 (3.65%) WCF
6 5 (3.65%) XSD
7 4 (2.92%) Natural Language Processing
7 4 (2.92%) PyTorch
7 4 (2.92%) TensorFlow
8 3 (2.19%) JSON
8 3 (2.19%) RESTful
9 2 (1.46%) MDX
9 2 (1.46%) Node.js
9 2 (1.46%) NumPy
9 2 (1.46%) Web Services
Miscellaneous
1 33 (24.09%) Analytical Skills
2 14 (10.22%) Data Structures
3 11 (8.03%) Algorithms
4 9 (6.57%) Self-Motivation
5 7 (5.11%) Reinsurance
6 5 (3.65%) Data Centre
7 3 (2.19%) Hedge funds
7 3 (2.19%) Reference Data
8 2 (1.46%) Equities
8 2 (1.46%) Management Information System
8 2 (1.46%) Public Cloud
9 1 (0.73%) CMDB
9 1 (0.73%) Derivative
9 1 (0.73%) Digital Media
9 1 (0.73%) Driving Licence
9 1 (0.73%) Hybrid Cloud
9 1 (0.73%) Renewable Energy
9 1 (0.73%) User Experience
9 1 (0.73%) Wiki
Operating Systems
1 3 (2.19%) Linux
2 1 (0.73%) Windows
Processes & Methodologies
1 52 (37.96%) Data Analysis
2 50 (36.50%) Business Intelligence
3 41 (29.93%) Analytics
4 36 (26.28%) Data Modelling
5 29 (21.17%) Machine Learning
6 27 (19.71%) Agile Software Development
6 27 (19.71%) Migration
7 25 (18.25%) Computer Science
7 25 (18.25%) ETL
8 24 (17.52%) Visualisation
9 23 (16.79%) Data Science
10 22 (16.06%) Mathematics
11 20 (14.60%) Data Analytics
12 18 (13.14%) Data Governance
13 17 (12.41%) BDD
14 16 (11.68%) Data Management
14 16 (11.68%) Data Migration
15 15 (10.95%) Data Visualisation
15 15 (10.95%) Statistics
16 14 (10.22%) Data Enrichment
Programming Languages
1 64 (46.72%) SQL
2 47 (34.31%) Python
3 19 (13.87%) R
4 11 (8.03%) Java
5 7 (5.11%) C#
5 7 (5.11%) JavaScript
6 5 (3.65%) C
7 4 (2.92%) C++
7 4 (2.92%) PowerShell
8 3 (2.19%) MATLAB
9 2 (1.46%) Go
9 2 (1.46%) Julia
9 2 (1.46%) T-SQL
10 1 (0.73%) ABAP
10 1 (0.73%) HiveQL
10 1 (0.73%) PROC SQL
10 1 (0.73%) SAS Macro
10 1 (0.73%) Scala
10 1 (0.73%) U-SQL
10 1 (0.73%) VB
Qualifications
1 27 (19.71%) Degree
2 9 (6.57%) PhD
3 8 (5.84%) Computer Science Degree
4 7 (5.11%) Security Cleared
5 5 (3.65%) SC Cleared
6 4 (2.92%) DV Cleared
7 2 (1.46%) AWS Certification
7 2 (1.46%) Master's Degree
7 2 (1.46%) Postgraduate
8 1 (0.73%) Microsoft Certification
8 1 (0.73%) Numerate Degree
Quality Assurance & Compliance
1 29 (21.17%) Data Quality
2 5 (3.65%) GDPR
2 5 (3.65%) IFRS
System Software
1 1 (0.73%) Docker
1 1 (0.73%) HDFS
Systems Management
1 1 (0.73%) Terraform
Vendors
1 24 (17.52%) Microsoft
2 11 (8.03%) Databricks
3 7 (5.11%) Oracle
4 5 (3.65%) SAP
5 3 (2.19%) Google
5 3 (2.19%) Informatica
6 2 (1.46%) Ab Initio
6 2 (1.46%) Alteryx
6 2 (1.46%) CODA
6 2 (1.46%) JD Edwards
6 2 (1.46%) Maconomy
6 2 (1.46%) PeopleSoft
6 2 (1.46%) Sage
6 2 (1.46%) Salesforce.com
6 2 (1.46%) WooCommerce
6 2 (1.46%) Xero
7 1 (0.73%) Instagram
7 1 (0.73%) MuleSoft
7 1 (0.73%) ServiceNow
7 1 (0.73%) Workday