Period
to 24 July 2021

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 24 July 2021 with a comparison to the same period in the previous 2 years.

Data Cleansing (Data Cleaning, Data Scrubbing)
UK
6 months to
24 Jul 2021
Same period 2020 Same period 2019
Rank 609 560 702
Rank change year-on-year -49 +142 -35
Permanent jobs citing Data Cleansing 415 251 449
As % of all permanent jobs advertised in the UK 0.37% 0.35% 0.31%
As % of the Processes & Methodologies category 0.39% 0.38% 0.34%
Number of salaries quoted 235 211 335
10th Percentile £32,500 £26,250 £30,000
25th Percentile £38,875 £33,039 £37,500
Median annual salary (50th Percentile) £52,500 £49,000 £52,500
Median % change year-on-year +7.14% -6.67% +10.53%
75th Percentile £74,000 £68,125 £71,250
90th Percentile £84,500 £87,500 £80,000
UK excluding London median annual salary £45,000 £40,000 £45,000
% change year-on-year +12.50% -11.11% -

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 105,747 65,402 133,717
As % of all permanent IT jobs advertised in the UK 93.46% 92.39% 92.45%
Number of salaries quoted 72,274 52,916 106,592
10th Percentile £32,500 £32,250 £30,000
25th Percentile £42,000 £41,250 £37,500
Median annual salary (50th Percentile) £55,000 £55,000 £52,500
Median % change year-on-year - +4.76% +5.00%
75th Percentile £75,000 £73,750 £70,000
90th Percentile £92,500 £90,000 £86,250
UK excluding London median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

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 24 July 2021.

Salary histogram for Data Cleansing in the UK

Data Cleansing
Top 17 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 24 July 2021. 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 -85 334 £52,500 +6.06% 74
London -51 181 £60,000 +2.13% 37
UK excluding London -85 162 £45,000 +12.50% 38
Work from Home -171 105 £57,500 +34.11% 12
North of England -33 52 £45,000 +80.00% 9
South East -72 36 £50,000 - 10
North West -9 31 £45,000 +50.00% 7
Midlands -82 25 £40,000 - 9
East of England -23 22 £60,000 +71.43% 5
Yorkshire -54 20 £43,750 +75.00% 2
West Midlands -69 17 £45,000 +12.50% 7
South West -68 14 £37,500 -25.00% 3
Scotland -53 12 £60,000 +20.00% 2
East Midlands -48 8 £36,750 +13.08% 2
Wales -17 2 £23,500 -49.19%
Northern Ireland - 2 - -
North East -20 1 - -

For the 6 months to 24 July 2021, 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 189 (45.54%) SQL
2 127 (30.60%) Finance
3 126 (30.36%) Business Intelligence
4 122 (29.40%) ETL
5 120 (28.92%) Python
6 118 (28.43%) Analytics
6 118 (28.43%) Social Skills
7 115 (27.71%) Data Management
8 110 (26.51%) Migration
9 103 (24.82%) Power Platform
10 102 (24.58%) Power BI
11 101 (24.34%) Data Quality
12 99 (23.86%) Data Analysis
13 98 (23.61%) Degree
14 92 (22.17%) Agile Software Development
15 91 (21.93%) Visualisation
16 89 (21.45%) Data Migration
17 81 (19.52%) Data Science
18 78 (18.80%) Machine Learning
19 76 (18.31%) Validation
20 74 (17.83%) Project Management
21 73 (17.59%) Big Data
21 73 (17.59%) Azure
22 72 (17.35%) SAP
23 70 (16.87%) Data Warehouse
24 67 (16.14%) Data Modelling
25 64 (15.42%) Computer Science
26 63 (15.18%) Analytical Skills
27 62 (14.94%) Microsoft
28 61 (14.70%) Microsoft Excel

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 36 (8.67%) Apache Spark
2 13 (3.13%) SAS
3 9 (2.17%) Jupyter
3 9 (2.17%) SharePoint
4 3 (0.72%) CMS
4 3 (0.72%) Confluence
5 2 (0.48%) Documentum
6 1 (0.24%) BizTalk Server
6 1 (0.24%) Moodle
6 1 (0.24%) SharePoint 2010
Applications
1 61 (14.70%) Microsoft Excel
2 26 (6.27%) Microsoft Office
3 13 (3.13%) Microsoft PowerPoint
4 7 (1.69%) Spreadsheet
5 3 (0.72%) MS Visio
5 3 (0.72%) SPSS
6 2 (0.48%) Oracle Smart View
7 1 (0.24%) Microsoft Project
Business Applications
1 17 (4.10%) SAP S/4HANA
2 15 (3.61%) Dynamics CRM
3 10 (2.41%) Shopify
4 9 (2.17%) SAP MDG
5 8 (1.93%) SAP ERP
6 6 (1.45%) Dynamics AX
7 4 (0.96%) NetSuite
7 4 (0.96%) Oracle Clinical
8 3 (0.72%) Cognos Business Intelligence
8 3 (0.72%) Cognos TM1
9 2 (0.48%) iTrent
9 2 (0.48%) Oracle Applications
9 2 (0.48%) Oracle Assets
9 2 (0.48%) Oracle ERP
9 2 (0.48%) Oracle General Ledger
9 2 (0.48%) Oracle Payables
9 2 (0.48%) Oracle Subledger Accounting
10 1 (0.24%) Dynamics NAV
10 1 (0.24%) SAP MDM
10 1 (0.24%) Sentinel
Cloud Services
1 103 (24.82%) Power Platform
2 73 (17.59%) Azure
3 51 (12.29%) GCP
4 44 (10.60%) AWS
5 21 (5.06%) Dynamics 365
6 19 (4.58%) SaaS
7 16 (3.86%) Azure Data Factory
7 16 (3.86%) Azure Synapse Analytics
8 10 (2.41%) Google Sheets
8 10 (2.41%) Veeva
9 9 (2.17%) Cloud Computing
9 9 (2.17%) Collibra
10 8 (1.93%) PowerApps
10 8 (1.93%) Snowflake
11 7 (1.69%) Heroku
11 7 (1.69%) Salesforce Sales Cloud
11 7 (1.69%) Salesforce Service Cloud
12 6 (1.45%) Google Data Studio
13 5 (1.20%) Power Automate
13 5 (1.20%) Serverless
Communications & Networking
1 7 (1.69%) CTI
2 2 (0.48%) Broadband
3 1 (0.24%) Intranet
Database & Business Intelligence
1 102 (24.58%) Power BI
2 73 (17.59%) Big Data
3 70 (16.87%) Data Warehouse
4 55 (13.25%) Tableau
5 53 (12.77%) SQL Server Integration Services
6 41 (9.88%) SQL Server Reporting Services
7 35 (8.43%) SQL Server
8 34 (8.19%) Relational Database
9 30 (7.23%) SQL Server Analysis Services
10 27 (6.51%) Hadoop
11 23 (5.54%) PostgreSQL
12 20 (4.82%) Data Lake
12 20 (4.82%) Redis
12 20 (4.82%) SAP Data Services
13 19 (4.58%) Data Mining
14 16 (3.86%) SAP BW
14 16 (3.86%) Star Schema
15 15 (3.61%) Amazon Redshift
15 15 (3.61%) SAP HANA
16 14 (3.37%) Looker
Development Applications
1 16 (3.86%) JIRA
2 9 (2.17%) gulp
2 9 (2.17%) webpack
3 5 (1.20%) Git (software)
3 5 (1.20%) LSMW
3 5 (1.20%) SQL Server Management Studio (SSMS)
4 3 (0.72%) Visual Studio
5 1 (0.24%) GitLab
5 1 (0.24%) Team Foundation Server
General
1 127 (30.60%) Finance
2 118 (28.43%) Social Skills
3 63 (15.18%) Analytical Skills
4 46 (11.08%) Marketing
5 39 (9.40%) Pharmaceutical
6 28 (6.75%) Telecoms
7 23 (5.54%) Presentation Skills
8 22 (5.30%) Retail
9 15 (3.61%) Legal
10 8 (1.93%) Law
10 8 (1.93%) Organisational Skills
10 8 (1.93%) Public Sector
11 5 (1.20%) French Language
11 5 (1.20%) German Language
11 5 (1.20%) Inclusion and Diversity
11 5 (1.20%) Italian Language
11 5 (1.20%) Local Government
11 5 (1.20%) Spanish Language
12 4 (0.96%) Automotive
12 4 (0.96%) Manufacturing
Job Titles
1 110 (26.51%) Analyst
2 84 (20.24%) Data Analyst
3 47 (11.33%) Data Manager
4 36 (8.67%) Data Engineer
5 35 (8.43%) Developer
6 27 (6.51%) Architect
6 27 (6.51%) Consultant
6 27 (6.51%) Data Scientist
7 18 (4.34%) Business Intelligence Analyst
7 18 (4.34%) Business Intelligence Developer
8 17 (4.10%) Migration Analyst
9 16 (3.86%) Data Migration Analyst
10 15 (3.61%) Administrator
11 13 (3.13%) Data Architect
11 13 (3.13%) SAP Data Manager
11 13 (3.13%) SAP Manager
12 12 (2.89%) Senior Analyst
13 11 (2.65%) Power BI Analyst
13 11 (2.65%) SAP Architect
13 11 (2.65%) SQL Developer
Libraries, Frameworks & Software Standards
1 38 (9.16%) NumPy
2 31 (7.47%) scikit-learn
3 30 (7.23%) REST
4 26 (6.27%) Pandas
5 24 (5.78%) Keras
6 20 (4.82%) Celery
6 20 (4.82%) Django
6 20 (4.82%) TensorFlow
7 19 (4.58%) Node.js
8 18 (4.34%) Kafka
8 18 (4.34%) React
9 17 (4.10%) CSS
9 17 (4.10%) Vue.js
10 16 (3.86%) .NET
10 16 (3.86%) AngularJS
10 16 (3.86%) Torch
11 14 (3.37%) XML
12 10 (2.41%) Matplotlib
12 10 (2.41%) SciPy
13 9 (2.17%) Twitter Bootstrap
Miscellaneous
1 34 (8.19%) Hedge funds
1 34 (8.19%) Management Information System
2 33 (7.95%) Algorithms
2 33 (7.95%) Life Science
3 31 (7.47%) User Experience
4 25 (6.02%) Data Structures
5 15 (3.61%) Reference Data
6 12 (2.89%) Greenfield Project
7 11 (2.65%) Enterprise Software
8 9 (2.17%) Equities
8 9 (2.17%) Hybrid Cloud
9 7 (1.69%) Biotechnology
9 7 (1.69%) IVR
9 7 (1.69%) Reinsurance
10 6 (1.45%) Legacy Systems
11 5 (1.20%) LLPG
11 5 (1.20%) NHS
11 5 (1.20%) NLPG
12 4 (0.96%) Public Cloud
13 3 (0.72%) Self-Motivation
Operating Systems
1 6 (1.45%) Windows
2 2 (0.48%) Windows 10
3 1 (0.24%) Linux
3 1 (0.24%) Unix
Processes & Methodologies
1 126 (30.36%) Business Intelligence
2 122 (29.40%) ETL
3 118 (28.43%) Analytics
4 115 (27.71%) Data Management
5 110 (26.51%) Migration
6 99 (23.86%) Data Analysis
7 92 (22.17%) Agile Software Development
8 91 (21.93%) Visualisation
9 89 (21.45%) Data Migration
10 81 (19.52%) Data Science
11 78 (18.80%) Machine Learning
12 76 (18.31%) Validation
13 74 (17.83%) Project Management
14 67 (16.14%) Data Modelling
15 64 (15.42%) Computer Science
16 60 (14.46%) Problem-Solving
17 56 (13.49%) Project Delivery
18 50 (12.05%) Artificial Intelligence
18 50 (12.05%) Data Governance
19 48 (11.57%) Mathematics
Programming Languages
1 189 (45.54%) SQL
2 120 (28.92%) Python
3 32 (7.71%) T-SQL
4 30 (7.23%) R
5 25 (6.02%) C
6 24 (5.78%) Cython
7 21 (5.06%) Data Analysis Expressions (DAX)
8 19 (4.58%) JavaScript
9 18 (4.34%) TypeScript
10 16 (3.86%) C++
11 11 (2.65%) Java
12 9 (2.17%) VBA
13 7 (1.69%) Go
14 5 (1.20%) C#
14 5 (1.20%) Julia
14 5 (1.20%) PowerShell
14 5 (1.20%) SAS Macro
15 4 (0.96%) Bash Shell
16 3 (0.72%) ABAP
16 3 (0.72%) Scala
Qualifications
1 98 (23.61%) Degree
2 32 (7.71%) PhD
3 26 (6.27%) Computer Science Degree
4 9 (2.17%) Numerate Degree
5 8 (1.93%) Security Cleared
6 7 (1.69%) Master's Degree
7 6 (1.45%) SC Cleared
8 3 (0.72%) HND
9 2 (0.48%) AWS Certification
9 2 (0.48%) BC Cleared
9 2 (0.48%) MBA
9 2 (0.48%) RIBA
10 1 (0.24%) ITIL Foundation Certificate
10 1 (0.24%) PMI Certification
10 1 (0.24%) PMP
Quality Assurance & Compliance
1 101 (24.34%) Data Quality
2 24 (5.78%) QA
3 15 (3.61%) Good Clinical Practice
4 9 (2.17%) CDISC
5 6 (1.45%) GDPR
6 5 (1.20%) BS7666
7 2 (0.48%) AIFMD
7 2 (0.48%) GxP
8 1 (0.24%) Accessibility
8 1 (0.24%) PMO
System Software
1 11 (2.65%) Docker
2 1 (0.24%) Active Directory
2 1 (0.24%) HDFS
Systems Management
1 21 (5.06%) Ansible
1 21 (5.06%) Kubernetes
2 5 (1.20%) Single Sign-On
3 4 (0.96%) Oracle EDQ
4 1 (0.24%) Terraform
Vendors
1 72 (17.35%) SAP
2 62 (14.94%) Microsoft
3 44 (10.60%) Oracle
4 37 (8.92%) Salesforce.com
5 31 (7.47%) Informatica
6 28 (6.75%) Google
7 24 (5.78%) Yahoo!
8 20 (4.82%) Databricks
9 11 (2.65%) StreamSets
10 9 (2.17%) Cognos
11 8 (1.93%) Remedy
12 7 (1.69%) PeopleSoft
12 7 (1.69%) Saba
12 7 (1.69%) Teradata
13 5 (1.20%) Alteryx
13 5 (1.20%) Hyperion
14 4 (0.96%) Ab Initio
14 4 (0.96%) Workday
15 3 (0.72%) IBM
15 3 (0.72%) JD Edwards