Data Cleansing (Data Cleaning, Data Scrubbing)
UK

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 19 May 2024 with a comparison to the same period in the previous 2 years.

6 months to
19 May 2024
Same period 2023 Same period 2022
Rank 595 635 646
Rank change year-on-year +40 +11 -47
Permanent jobs citing Data Cleansing 327 347 724
As % of all permanent jobs advertised in the UK 0.33% 0.35% 0.45%
As % of the Processes & Methodologies category 0.38% 0.36% 0.47%
Number of salaries quoted 200 237 375
10th Percentile £29,000 £36,000 £32,500
25th Percentile £40,000 £44,432 £42,500
Median annual salary (50th Percentile) £54,000 £52,500 £52,500
Median % change year-on-year +2.86% - +10.53%
75th Percentile £71,250 £73,750 £67,250
90th Percentile £90,375 £85,000 £83,750
UK excluding London median annual salary £45,828 £50,000 £50,000
% change year-on-year -8.34% - +21.95%

All Process and Methodology Skills
UK

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.

Permanent vacancies with a requirement for process or methodology skills 85,150 95,114 154,445
As % of all permanent jobs advertised in the UK 85.20% 95.57% 95.77%
Number of salaries quoted 59,851 56,202 82,517
10th Percentile £29,079 £34,000 £33,645
25th Percentile £40,000 £45,000 £43,750
Median annual salary (50th Percentile) £55,000 £61,180 £60,000
Median % change year-on-year -10.10% +1.97% +9.09%
75th Percentile £72,500 £81,250 £80,000
90th Percentile £92,500 £100,000 £96,250
UK excluding London median annual salary £50,000 £55,000 £52,500
% change year-on-year -9.09% +4.76% +10.43%

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 19 May 2024.

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 19 May 2024. 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
Jobs
England +49 302 £55,000 +4.76% 145
UK excluding London +30 180 £45,828 -8.34% 90
Work from Home +128 166 £55,250 +10.50% 58
London +61 132 £62,500 +8.70% 60
South East +42 76 £40,000 -12.09% 17
Midlands -10 46 £47,500 -9.52% 21
East Midlands - 29 £44,100 - 6
North of England +27 27 £50,000 - 22
West Midlands -26 17 £57,500 +9.52% 15
Yorkshire +68 13 £56,250 +12.50% 7
South West -4 13 £27,500 -27.15% 13
North West -1 12 £50,000 -13.79% 11
Scotland -65 11 £75,000 - 2
East of England +6 6 £37,000 -64.76% 8
North East -3 2 £24,000 -48.16% 4
Northern Ireland - 1 - - 6

Data Cleansing
Co-occurring Skills and Capabilities by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same employment type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 17 (5.20%) Apache Spark
2 12 (3.67%) SAS
3 11 (3.36%) CMS
3 11 (3.36%) SharePoint
4 3 (0.92%) Apache
4 3 (0.92%) Confluence
4 3 (0.92%) Jupyter
5 1 (0.31%) ArcGIS
5 1 (0.31%) Documentum
Applications
1 64 (19.57%) Microsoft Excel
2 41 (12.54%) Microsoft Office
3 22 (6.73%) Microsoft PowerPoint
3 22 (6.73%) Spreadsheet
4 5 (1.53%) MS Visio
5 2 (0.61%) SPSS
6 1 (0.31%) InVision
6 1 (0.31%) Sketch
6 1 (0.31%) Zeplin
Business Applications
1 10 (3.06%) SAP S/4HANA
2 4 (1.22%) SAP SD
3 2 (0.61%) Dynamics CRM
3 2 (0.61%) Primavera
3 2 (0.61%) Remedy ITSM
3 2 (0.61%) SAP Business ByDesign
3 2 (0.61%) SAP PLM
3 2 (0.61%) SAP PM
4 1 (0.31%) Data Workbench
4 1 (0.31%) Dynamics AX
4 1 (0.31%) Dynamics GP
4 1 (0.31%) Endur
4 1 (0.31%) Oracle Financials
4 1 (0.31%) SAP HR
4 1 (0.31%) SAP Payroll
Cloud Services
1 104 (31.80%) Power Platform
2 66 (20.18%) Azure
3 32 (9.79%) AWS
4 26 (7.95%) SaaS
5 20 (6.12%) Azure Data Factory
6 11 (3.36%) PowerApps
7 10 (3.06%) Azure DevOps
7 10 (3.06%) Azure Synapse Analytics
7 10 (3.06%) Blackbaud
8 8 (2.45%) Google Analytics
9 7 (2.14%) Dynamics 365
9 7 (2.14%) GCP
9 7 (2.14%) Mavenlink
9 7 (2.14%) PaaS
10 6 (1.83%) IaaS
10 6 (1.83%) Microsoft 365
10 6 (1.83%) Serverless
11 5 (1.53%) Snowflake
12 4 (1.22%) AWS Lambda
12 4 (1.22%) Salesforce Sales Cloud
Communications & Networking
1 5 (1.53%) Firewall
2 4 (1.22%) Internet
2 4 (1.22%) Intranet
2 4 (1.22%) TCP/IP
3 3 (0.92%) Network Security
4 2 (0.61%) Wireless
Database & Business Intelligence
1 104 (31.80%) Power BI
2 56 (17.13%) Tableau
3 46 (14.07%) Data Warehouse
4 20 (6.12%) SQL Server
5 16 (4.89%) Big Data
5 16 (4.89%) Data Lake
5 16 (4.89%) Relational Database
6 14 (4.28%) Azure SQL Database
7 12 (3.67%) SQL Server Integration Services
8 10 (3.06%) Qlik Sense
8 10 (3.06%) Snowflake Schema
9 8 (2.45%) RDBMS
10 7 (2.14%) Data Mining
10 7 (2.14%) Metadata
10 7 (2.14%) Oracle Reports
10 7 (2.14%) PostgreSQL
10 7 (2.14%) Power Query
10 7 (2.14%) QlikView
11 6 (1.83%) Hadoop
11 6 (1.83%) NoSQL
Development Applications
1 19 (5.81%) JIRA
2 10 (3.06%) Git
3 3 (0.92%) ER Studio
3 3 (0.92%) ERwin
4 2 (0.61%) Team Foundation Server
4 2 (0.61%) Visual Studio
General
1 127 (38.84%) Social Skills
2 84 (25.69%) Finance
3 64 (19.57%) Analytical Skills
4 56 (17.13%) Legal
5 15 (4.59%) Marketing
6 14 (4.28%) Law
6 14 (4.28%) Public Sector
7 13 (3.98%) Banking
7 13 (3.98%) Retail
8 11 (3.36%) Games
8 11 (3.36%) Inclusion and Diversity
9 9 (2.75%) Billing
9 9 (2.75%) Investment Banking
10 8 (2.45%) Organisational Skills
11 7 (2.14%) Presentation Skills
12 5 (1.53%) Documentation Skills
12 5 (1.53%) Financial Institution
12 5 (1.53%) Publishing
13 4 (1.22%) Military
14 3 (0.92%) Telecoms
Job Titles
1 63 (19.27%) Analyst
2 41 (12.54%) Senior
3 36 (11.01%) Data Engineer
4 35 (10.70%) Data Analyst
5 28 (8.56%) Consultant
6 22 (6.73%) Lead
7 20 (6.12%) Data Consultant
7 20 (6.12%) Product Manager
8 19 (5.81%) Administrator
9 12 (3.67%) Data Manager
10 11 (3.36%) Data Scientist
10 11 (3.36%) Developer
10 11 (3.36%) Junior
10 11 (3.36%) SAP Consultant
10 11 (3.36%) Systems Analyst
11 8 (2.45%) Analytics Manager
11 8 (2.45%) Azure Engineer
11 8 (2.45%) Data Analytics Manager
11 8 (2.45%) Senior Analyst
12 7 (2.14%) Senior Data Engineer
Libraries, Frameworks & Software Standards
1 17 (5.20%) Web Services
2 8 (2.45%) JSON
2 8 (2.45%) XML
3 6 (1.83%) Oracle Fusion
4 4 (1.22%) ADO
4 4 (1.22%) D3.js
4 4 (1.22%) React
4 4 (1.22%) Redux
4 4 (1.22%) YAML
5 3 (0.92%) CSS
5 3 (0.92%) Google Chart
5 3 (0.92%) HTML
5 3 (0.92%) HTML5 Canvas
5 3 (0.92%) REST
6 2 (0.61%) .NET
6 2 (0.61%) .NET Framework
6 2 (0.61%) ASP.NET
6 2 (0.61%) Matplotlib
6 2 (0.61%) Seaborn
6 2 (0.61%) SOAP
Miscellaneous
1 66 (20.18%) Data Structures
2 64 (19.57%) Algorithms
3 60 (18.35%) Management Information System
4 28 (8.56%) Self-Motivation
5 21 (6.42%) Product Ownership
6 16 (4.89%) Taxonomies
7 11 (3.36%) Renewable Energy
8 9 (2.75%) Onboarding
9 7 (2.14%) Credit Risk
9 7 (2.14%) Data Centre
9 7 (2.14%) Distributed Systems
9 7 (2.14%) Legacy Systems
10 6 (1.83%) Cloud Native
10 6 (1.83%) Market Risk
11 5 (1.53%) Marketing Technology
11 5 (1.53%) Mobile App
12 4 (1.22%) Cyberattack
12 4 (1.22%) Educational Technology
12 4 (1.22%) Enterprise Cloud
12 4 (1.22%) Greenfield Project
Operating Systems
1 11 (3.36%) Linux
2 9 (2.75%) Windows
3 7 (2.14%) Windows Server
4 1 (0.31%) Windows 10
4 1 (0.31%) Windows Server 2019
Processes & Methodologies
1 128 (39.14%) Visualisation
2 125 (38.23%) Problem-Solving
3 114 (34.86%) ETL
4 104 (31.80%) Data Management
5 96 (29.36%) Analytics
5 96 (29.36%) Data Visualisation
6 90 (27.52%) Business Intelligence
7 86 (26.30%) Data Analysis
8 77 (23.55%) Decision-Making
9 76 (23.24%) Agile
10 73 (22.32%) Data Modelling
11 65 (19.88%) Data Integration
12 61 (18.65%) Migration
13 58 (17.74%) Data Strategy
14 54 (16.51%) Validation
15 53 (16.21%) Data Migration
16 52 (15.90%) Data Interpretation
17 51 (15.60%) Data Science
18 47 (14.37%) Data Analytics
19 45 (13.76%) DevOps
Programming Languages
1 137 (41.90%) SQL
2 95 (29.05%) Python
3 33 (10.09%) R
4 22 (6.73%) Java
5 15 (4.59%) C#
6 13 (3.98%) PowerShell
7 12 (3.67%) Go
8 9 (2.75%) C
9 7 (2.14%) Ruby
10 6 (1.83%) T-SQL
11 4 (1.22%) C++
11 4 (1.22%) Data Analysis Expressions
11 4 (1.22%) Scala
12 3 (0.92%) JavaScript
13 2 (0.61%) VBA
14 1 (0.31%) MATLAB
Qualifications
1 78 (23.85%) Degree
2 29 (8.87%) Master's Degree
3 15 (4.59%) Computer Science Degree
4 13 (3.98%) DBS Check
5 12 (3.67%) Security Cleared
6 11 (3.36%) MBA
7 10 (3.06%) Numerate Degree
8 8 (2.45%) SC Cleared
9 5 (1.53%) Azure Certification
9 5 (1.53%) Microsoft Certification
10 4 (1.22%) PMI Certification
11 2 (0.61%) A+ Certification
11 2 (0.61%) PRINCE2 Practitioner
12 1 (0.31%) DV Cleared
12 1 (0.31%) MCP
12 1 (0.31%) PMP
12 1 (0.31%) SAP Certification
Quality Assurance & Compliance
1 78 (23.85%) Data Quality
2 22 (6.73%) QA
3 18 (5.50%) GDPR
4 9 (2.75%) GMP
5 5 (1.53%) IFRS
6 4 (1.22%) California Consumer Privacy Act
6 4 (1.22%) PMO
6 4 (1.22%) SLA
7 3 (0.92%) Accessibility
8 1 (0.31%) IFRS 9
System Software
1 4 (1.22%) Active Directory
1 4 (1.22%) Virtual Desktop
2 3 (0.92%) VMware Infrastructure
3 2 (0.61%) Hyper-V
4 1 (0.31%) Microsoft Virtual Server
4 1 (0.31%) Virtual Servers
4 1 (0.31%) VMware ESXi
Systems Management
1 1 (0.31%) FTK
1 1 (0.31%) SCCM
Vendors
1 84 (25.69%) Microsoft
2 30 (9.17%) SAP
3 25 (7.65%) Salesforce
4 22 (6.73%) Databricks
5 17 (5.20%) Google
5 17 (5.20%) Oracle
6 11 (3.36%) Alteryx
7 7 (2.14%) Pega
8 6 (1.83%) Informatica
8 6 (1.83%) UiPath
9 5 (1.53%) ServiceNow
10 4 (1.22%) Marketo
11 3 (0.92%) Embarcadero
11 3 (0.92%) VMware
12 2 (0.61%) Adobe
12 2 (0.61%) Ariba
12 2 (0.61%) BMC
12 2 (0.61%) Cognos
12 2 (0.61%) IBM
12 2 (0.61%) MicroStrategy