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

6 months to
26 Apr 2024
Same period 2023 Same period 2022
Rank 590 637 643
Rank change year-on-year +47 +6 -46
Permanent jobs citing Data Cleansing 325 380 683
As % of all permanent jobs advertised in the UK 0.33% 0.36% 0.44%
As % of the Processes & Methodologies category 0.38% 0.38% 0.46%
Number of salaries quoted 201 242 383
10th Percentile £29,000 £36,825 £31,400
25th Percentile £40,000 £45,000 £42,500
Median annual salary (50th Percentile) £55,000 £55,000 £52,500
Median % change year-on-year - +4.76% +10.53%
75th Percentile £71,915 £73,750 £67,500
90th Percentile £85,000 £85,000 £84,750
UK excluding London median annual salary £45,828 £50,669 £45,000
% change year-on-year -9.55% +12.60% +12.50%

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 84,460 100,219 147,325
As % of all permanent jobs advertised in the UK 86.03% 95.64% 95.59%
Number of salaries quoted 59,759 58,822 83,132
10th Percentile £29,000 £34,000 £33,500
25th Percentile £40,000 £45,000 £43,750
Median annual salary (50th Percentile) £55,000 £62,000 £60,000
Median % change year-on-year -11.29% +3.33% +9.09%
75th Percentile £72,500 £82,500 £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% +9.38%

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 26 April 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 26 April 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 +71 297 £55,000 +4.76% 117
UK excluding London +8 172 £45,828 -9.55% 72
Work from Home +136 164 £55,000 +10.00% 55
London +101 138 £62,500 +6.38% 51
South East +71 74 £40,000 -20.53% 13
Midlands -15 38 £47,500 -9.52% 12
North of England +20 27 £50,000 - 20
East Midlands - 22 £44,100 - 6
West Midlands -17 16 £55,000 +4.76% 6
Yorkshire +80 13 £56,250 +12.50% 4
North West +1 13 £50,000 -23.08% 12
South West -21 12 £26,250 -30.46% 11
Scotland -51 12 £75,000 - 4
East of England +27 6 £37,000 -53.02% 10
Northern Ireland - 3 - - 5
North East -2 1 £24,000 -48.16% 4

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 12 (3.69%) SAS
2 11 (3.38%) Apache Spark
2 11 (3.38%) CMS
2 11 (3.38%) SharePoint
3 3 (0.92%) Apache
3 3 (0.92%) Confluence
3 3 (0.92%) Jupyter
4 2 (0.62%) Apache Airflow
5 1 (0.31%) ArcGIS
5 1 (0.31%) Documentum
Applications
1 66 (20.31%) Microsoft Excel
2 41 (12.62%) Microsoft Office
3 23 (7.08%) Microsoft PowerPoint
4 22 (6.77%) Spreadsheet
5 5 (1.54%) MS Visio
6 2 (0.62%) SPSS
7 1 (0.31%) InVision
7 1 (0.31%) Sketch
7 1 (0.31%) Zeplin
Business Applications
1 8 (2.46%) SAP S/4HANA
2 4 (1.23%) SAP SD
3 2 (0.62%) Dynamics CRM
3 2 (0.62%) Primavera
3 2 (0.62%) Remedy ITSM
3 2 (0.62%) SAP PLM
3 2 (0.62%) 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 Business ByDesign
4 1 (0.31%) SAP HR
4 1 (0.31%) SAP Payroll
Cloud Services
1 108 (33.23%) Power Platform
2 70 (21.54%) Azure
3 30 (9.23%) AWS
3 30 (9.23%) SaaS
4 21 (6.46%) Azure Data Factory
5 11 (3.38%) Azure Synapse Analytics
5 11 (3.38%) PowerApps
6 10 (3.08%) Azure DevOps
6 10 (3.08%) Blackbaud
7 8 (2.46%) GCP
7 8 (2.46%) Google Analytics
8 7 (2.15%) Dynamics 365
8 7 (2.15%) Mavenlink
9 6 (1.85%) Microsoft 365
9 6 (1.85%) Serverless
9 6 (1.85%) Snowflake
10 5 (1.54%) AWS Lambda
10 5 (1.54%) IaaS
10 5 (1.54%) PaaS
11 4 (1.23%) GitHub
Communications & Networking
1 7 (2.15%) Network Security
2 5 (1.54%) Firewall
3 4 (1.23%) Internet
3 4 (1.23%) Intranet
3 4 (1.23%) TCP/IP
4 2 (0.62%) Wireless
Database & Business Intelligence
1 108 (33.23%) Power BI
2 58 (17.85%) Tableau
3 40 (12.31%) Data Warehouse
4 19 (5.85%) SQL Server
5 16 (4.92%) Data Lake
5 16 (4.92%) Relational Database
6 14 (4.31%) Azure SQL Database
6 14 (4.31%) Big Data
7 12 (3.69%) SQL Server Integration Services
8 10 (3.08%) Qlik Sense
8 10 (3.08%) Snowflake Schema
9 9 (2.77%) Data Mining
10 8 (2.46%) Metadata
10 8 (2.46%) Power Query
10 8 (2.46%) RDBMS
11 7 (2.15%) Oracle Reports
11 7 (2.15%) PostgreSQL
11 7 (2.15%) QlikView
12 6 (1.85%) Hadoop
12 6 (1.85%) NoSQL
Development Applications
1 20 (6.15%) JIRA
2 8 (2.46%) Git
3 3 (0.92%) ER Studio
3 3 (0.92%) ERwin
4 1 (0.31%) CA Release Automation
4 1 (0.31%) Cucumber
4 1 (0.31%) IBM UrbanCode
4 1 (0.31%) Jenkins
4 1 (0.31%) Mocha
4 1 (0.31%) Selenium
4 1 (0.31%) SonarQube
4 1 (0.31%) Subversion
4 1 (0.31%) Team Foundation Server
4 1 (0.31%) Zephyr
General
1 128 (39.38%) Social Skills
2 88 (27.08%) Finance
3 70 (21.54%) Analytical Skills
4 55 (16.92%) Legal
5 17 (5.23%) Marketing
6 16 (4.92%) Banking
6 16 (4.92%) Law
7 15 (4.62%) Public Sector
8 14 (4.31%) Inclusion and Diversity
8 14 (4.31%) Retail
9 11 (3.38%) Games
9 11 (3.38%) Investment Banking
10 9 (2.77%) Billing
10 9 (2.77%) Presentation Skills
11 8 (2.46%) Organisational Skills
12 5 (1.54%) Financial Institution
12 5 (1.54%) Publishing
13 4 (1.23%) Documentation Skills
13 4 (1.23%) Military
14 3 (0.92%) Influencing Skills
Job Titles
1 64 (19.69%) Analyst
2 38 (11.69%) Senior
3 34 (10.46%) Data Analyst
4 31 (9.54%) Data Engineer
5 27 (8.31%) Consultant
6 22 (6.77%) Lead
7 20 (6.15%) Product Manager
8 19 (5.85%) Data Consultant
9 18 (5.54%) Administrator
10 14 (4.31%) Data Manager
11 12 (3.69%) Junior
12 11 (3.38%) Data Scientist
12 11 (3.38%) Systems Analyst
13 9 (2.77%) Azure Engineer
13 9 (2.77%) Developer
13 9 (2.77%) SAP Consultant
13 9 (2.77%) Technical Analyst
14 8 (2.46%) Analytics Manager
14 8 (2.46%) Business Analyst
14 8 (2.46%) Data Analytics Manager
Libraries, Frameworks & Software Standards
1 17 (5.23%) Web Services
2 8 (2.46%) JSON
2 8 (2.46%) XML
3 6 (1.85%) Oracle Fusion
4 4 (1.23%) ADO
4 4 (1.23%) D3.js
4 4 (1.23%) React
4 4 (1.23%) Redux
4 4 (1.23%) 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%) Pandas
5 3 (0.92%) REST
6 2 (0.62%) .NET
6 2 (0.62%) ASP.NET
6 2 (0.62%) Matplotlib
6 2 (0.62%) NumPy
6 2 (0.62%) SOAP
Miscellaneous
1 63 (19.38%) Algorithms
2 59 (18.15%) Management Information System
3 58 (17.85%) Data Structures
4 28 (8.62%) Self-Motivation
5 23 (7.08%) Product Ownership
6 16 (4.92%) Taxonomies
7 9 (2.77%) Onboarding
8 8 (2.46%) Distributed Systems
9 7 (2.15%) Credit Risk
9 7 (2.15%) Legacy Systems
10 6 (1.85%) Cloud Native
10 6 (1.85%) Data Centre
10 6 (1.85%) Market Risk
11 5 (1.54%) Marketing Technology
11 5 (1.54%) Mobile App
12 4 (1.23%) Cyberattack
12 4 (1.23%) Educational Technology
12 4 (1.23%) Enterprise Cloud
12 4 (1.23%) Greenfield Project
12 4 (1.23%) Renewable Energy
Operating Systems
1 9 (2.77%) Windows
2 7 (2.15%) Windows Server
3 4 (1.23%) Linux
4 1 (0.31%) Windows 10
4 1 (0.31%) Windows Server 2019
Processes & Methodologies
1 131 (40.31%) Problem-Solving
2 126 (38.77%) Visualisation
3 116 (35.69%) ETL
4 103 (31.69%) Data Management
5 100 (30.77%) Analytics
6 93 (28.62%) Business Intelligence
6 93 (28.62%) Data Visualisation
7 88 (27.08%) Data Analysis
8 81 (24.92%) Agile
9 77 (23.69%) Decision-Making
10 67 (20.62%) Data Modelling
11 66 (20.31%) Data Integration
12 58 (17.85%) Validation
13 57 (17.54%) Data Strategy
14 55 (16.92%) Migration
15 53 (16.31%) Data Science
16 51 (15.69%) Data Interpretation
17 49 (15.08%) Data Analytics
18 48 (14.77%) Data Migration
18 48 (14.77%) Roadmaps
Programming Languages
1 134 (41.23%) SQL
2 95 (29.23%) Python
3 36 (11.08%) R
4 20 (6.15%) Java
5 15 (4.62%) C#
6 12 (3.69%) Go
6 12 (3.69%) PowerShell
7 8 (2.46%) C
8 7 (2.15%) Ruby
9 6 (1.85%) T-SQL
10 5 (1.54%) Scala
11 3 (0.92%) C++
11 3 (0.92%) Data Analysis Expressions
11 3 (0.92%) JavaScript
12 2 (0.62%) VBA
13 1 (0.31%) MATLAB
13 1 (0.31%) SOQL
Qualifications
1 80 (24.62%) Degree
2 28 (8.62%) Master's Degree
3 17 (5.23%) Computer Science Degree
4 11 (3.38%) MBA
4 11 (3.38%) Security Cleared
5 10 (3.08%) Numerate Degree
6 8 (2.46%) SC Cleared
7 6 (1.85%) DBS Check
7 6 (1.85%) Microsoft Certification
8 5 (1.54%) Azure Certification
9 3 (0.92%) PMI Certification
10 2 (0.62%) A+ Certification
10 2 (0.62%) PRINCE2 Practitioner
11 1 (0.31%) DV Cleared
11 1 (0.31%) MCP
11 1 (0.31%) SAP Certification
Quality Assurance & Compliance
1 71 (21.85%) Data Quality
2 22 (6.77%) QA
3 18 (5.54%) GDPR
4 9 (2.77%) GMP
5 5 (1.54%) IFRS
6 4 (1.23%) California Consumer Privacy Act
6 4 (1.23%) PMO
6 4 (1.23%) SLA
7 3 (0.92%) Accessibility
8 1 (0.31%) IFRS 9
System Software
1 4 (1.23%) Active Directory
1 4 (1.23%) Virtual Desktop
2 2 (0.62%) VMware Infrastructure
3 1 (0.31%) Hyper-V
3 1 (0.31%) Microsoft Virtual Server
3 1 (0.31%) Virtual Servers
3 1 (0.31%) VMware ESXi
Systems Management
1 1 (0.31%) Kibana
1 1 (0.31%) Nagios
1 1 (0.31%) Prometheus
1 1 (0.31%) Puppet
1 1 (0.31%) SCCM
Vendors
1 81 (24.92%) Microsoft
2 27 (8.31%) SAP
3 26 (8.00%) Salesforce
4 18 (5.54%) Google
5 17 (5.23%) Oracle
6 16 (4.92%) Databricks
7 11 (3.38%) Alteryx
8 7 (2.15%) Pega
9 6 (1.85%) Informatica
9 6 (1.85%) UiPath
10 5 (1.54%) ServiceNow
11 4 (1.23%) Marketo
12 3 (0.92%) Embarcadero
13 2 (0.62%) Adobe
13 2 (0.62%) Ariba
13 2 (0.62%) BMC
13 2 (0.62%) Cognos
13 2 (0.62%) IBM
13 2 (0.62%) MicroStrategy
13 2 (0.62%) Sage