Period
to 17 November 2017

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 17 November 2017 with a comparison to the same period in the previous 2 years.

Data Cleansing (Data Cleaning, Data Scrubbing)
UK
6 months to
17 Nov 2017
Same period 2016 Same period 2015
Rank 758 818 874
Rank change year-on-year +60 +56 -60
Permanent jobs citing Data Cleansing 468 431 434
As % of all permanent IT jobs advertised in the UK 0.26% 0.23% 0.20%
As % of the Processes & Methodologies category 0.29% 0.25% 0.22%
Number of salaries quoted 291 366 326
UK median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% -2.30%
10th Percentile £23,500 £27,625 £26,250
90th Percentile £85,000 £75,000 £68,125
UK excluding London median annual salary £38,750 £40,000 £35,000
% change year-on-year -3.13% +14.29% -12.50%

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 161983 169953 194669
As % of all permanent IT jobs advertised in the UK 89.91% 89.37% 88.77%
Number of salaries quoted 127876 141202 160286
UK median annual salary £50,000 £49,000 £47,500
Median salary % change year-on-year +2.04% +3.16% +5.56%
10th Percentile £28,750 £28,000 £27,500
90th Percentile £80,000 £78,750 £77,500
UK excluding London median annual salary £44,000 £42,500 £42,500
% change year-on-year +3.53% - +6.25%

Data Cleansing
Job Vacancy Trend

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

Job vacancy trend for Data Cleansing in the UK

Data Cleansing
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Cleansing.

Salary trend for Data Cleansing in the UK

Data Cleansing
Salary Histogram

The salary distribution of IT jobs citing Data Cleansing over the 6 months to 17 November 2017.

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 17 November 2017. 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 +75 440 £45,000 - 29
UK excluding London +68 261 £38,750 -3.13% 23
London +17 197 £57,500 +15.00% 12
South East +47 100 £40,000 +1.27% 5
North of England +27 72 £35,000 -12.50% 4
Midlands +49 38 £50,000 +17.65% 6
Yorkshire +47 38 £35,000 -23.91% 2
North West 0 32 £23,000 -41.03% 1
West Midlands +15 23 £52,500 +23.53% 2
South West +5 17 £43,750 +16.67% 1
East Midlands +38 15 £48,250 +7.22% 3
East of England -1 13 £35,000 -36.36% 1
Scotland +1 11 £52,500 +43.84% 4
Wales +19 9 £38,500 +4.76% 2
North East +13 2 £36,500 -33.64% 1
Northern Ireland -20 1 £45,000 +50.00%
Channel Islands - 1 £52,500 -

For the 6 months to 17 November 2017, IT jobs citing Data Cleansing also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for Data Cleansing.

1 213 (45.51%) SQL
2 164 (35.04%) ETL
3 160 (34.19%) Finance
4 145 (30.98%) Data Quality
5 144 (30.77%) Business Intelligence
6 132 (28.21%) Data Management
7 121 (25.85%) Migration
8 120 (25.64%) Oracle
9 118 (25.21%) Analytics
10 117 (25.00%) SQL Server
11 106 (22.65%) Data Migration
12 104 (22.22%) Project Management
13 101 (21.58%) Microsoft
14 97 (20.73%) Data Modelling
15 96 (20.51%) Data Warehouse
16 88 (18.80%) Legal
16 88 (18.80%) Degree
17 86 (18.38%) SAP
18 79 (16.88%) Analytical Skills
19 76 (16.24%) Microsoft Excel
20 72 (15.38%) Data Analytics
21 71 (15.17%) Master Data Management
22 70 (14.96%) SQL Server Integration Services
23 67 (14.32%) Data Analysis
24 65 (13.89%) SQL Server Reporting Services
25 61 (13.03%) Visualisation
26 54 (11.54%) Banking
26 54 (11.54%) Informatica
27 52 (11.11%) Java
28 51 (10.90%) Asset Management

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 47 (10.04%) SAS
2 15 (3.21%) Apache Spark
3 13 (2.78%) IIS
4 12 (2.56%) SharePoint
5 4 (0.85%) Apache
5 4 (0.85%) ArcGIS
5 4 (0.85%) Oracle Workflow
6 1 (0.21%) Apache Pig
6 1 (0.21%) Elasticsearch
6 1 (0.21%) Mule
6 1 (0.21%) Mule ESB
6 1 (0.21%) NetWeaver
6 1 (0.21%) Oracle Self-Service HR
Applications
1 76 (16.24%) Microsoft Excel
2 28 (5.98%) Microsoft Office
3 23 (4.91%) SPSS
4 12 (2.56%) MS Visio
5 10 (2.14%) Microsoft PowerPoint
6 3 (0.64%) Spreadsheet
7 1 (0.21%) Microsoft Project
Business Applications
1 14 (2.99%) SAP ERP
2 12 (2.56%) Dynamics AX
3 9 (1.92%) SAP CRM
4 7 (1.50%) Dynamics CRM
5 6 (1.28%) FastStats
6 4 (0.85%) Adobe Campaign
7 2 (0.43%) SAP MDG
8 1 (0.21%) FRx
8 1 (0.21%) Investran
8 1 (0.21%) Oracle 11i
8 1 (0.21%) Oracle Applications
8 1 (0.21%) Oracle EBS
8 1 (0.21%) Oracle EBS R12
8 1 (0.21%) Oracle HRMS
8 1 (0.21%) Oracle iRecruitment
8 1 (0.21%) Oracle Payroll
8 1 (0.21%) Salesforce.com CRM
8 1 (0.21%) SAP Hybris
8 1 (0.21%) SAP S/4HANA
8 1 (0.21%) SAP SD
Cloud Services
1 25 (5.34%) Microsoft Azure
2 21 (4.49%) Amazon AWS
3 10 (2.14%) Dynamics 365
4 8 (1.71%) Azure Data Factory
5 7 (1.50%) Amazon Kinesis
5 7 (1.50%) Google Cloud Platform
6 6 (1.28%) Salesforce Service Cloud
7 5 (1.07%) Cortana Intelligence Suite
8 4 (0.85%) Amazon EMR
9 2 (0.43%) Amazon S3
9 2 (0.43%) Google Analytics
10 1 (0.21%) Google Tag Manager
10 1 (0.21%) PaaS
Communications & Networking
1 2 (0.43%) SMS
2 1 (0.21%) Internet
2 1 (0.21%) MQTT
Database & Business Intelligence
1 117 (25.00%) SQL Server
2 96 (20.51%) Data Warehouse
3 70 (14.96%) SQL Server Integration Services
4 65 (13.89%) SQL Server Reporting Services
5 48 (10.26%) Oracle Database
6 44 (9.40%) Oracle Database 10g
7 41 (8.76%) SAP Data Services
8 36 (7.69%) BusinessObjects
9 31 (6.62%) SQL Server Analysis Services
10 26 (5.56%) Data Mining
11 23 (4.91%) QlikView
11 23 (4.91%) Spotfire
12 21 (4.49%) Big Data
12 21 (4.49%) DataStage
12 21 (4.49%) Power BI
12 21 (4.49%) Relational Database
13 19 (4.06%) BODI
13 19 (4.06%) Hadoop
14 18 (3.85%) Crystal Reports
14 18 (3.85%) NoSQL
Development Applications
1 21 (4.49%) Talend Open Studio
2 14 (2.99%) SQL Server Management Studio (SSMS)
3 11 (2.35%) JIRA
4 8 (1.71%) LSMW
4 8 (1.71%) Visual Studio
5 6 (1.28%) Git (software)
6 5 (1.07%) Eclipse
6 5 (1.07%) ERwin
6 5 (1.07%) Team Foundation Server
7 3 (0.64%) Oracle Forms
8 1 (0.21%) Cucumber
8 1 (0.21%) Jenkins
8 1 (0.21%) PowerDesigner
8 1 (0.21%) Rational Rhapsody
8 1 (0.21%) Rational Rose
8 1 (0.21%) Selenium
8 1 (0.21%) Sonatype Nexus
8 1 (0.21%) VSS/SourceSafe
General
1 160 (34.19%) Finance
2 88 (18.80%) Legal
3 54 (11.54%) Banking
4 49 (10.47%) Marketing
5 45 (9.62%) Retail Banking
6 44 (9.40%) Investment Banking
7 26 (5.56%) Retail
8 19 (4.06%) Manufacturing
9 8 (1.71%) Advertising
10 6 (1.28%) Back Office
10 6 (1.28%) Games
11 5 (1.07%) Front Office
11 5 (1.07%) Law
11 5 (1.07%) Telecoms
12 4 (0.85%) Pharmaceutical
13 3 (0.64%) Billing
13 3 (0.64%) Retail Finance
14 1 (0.21%) Publishing
Job Titles
1 113 (24.15%) Analyst
2 99 (21.15%) Developer
3 74 (15.81%) Data Analyst
4 48 (10.26%) Technical Leader
5 38 (8.12%) Consultant
6 35 (7.48%) Data Manager
7 29 (6.20%) SAP Developer
8 22 (4.70%) SAP Manager
9 21 (4.49%) Business Intelligence Developer
9 21 (4.49%) SAP Data Manager
9 21 (4.49%) Senior Developer
9 21 (4.49%) SQL Developer
10 20 (4.27%) Architect
11 19 (4.06%) SAP Consultant
12 17 (3.63%) Business Analyst
12 17 (3.63%) Business Intelligence Analyst
12 17 (3.63%) SAP BusinessObjects (BO) Developer
13 16 (3.42%) Data Migration Manager
13 16 (3.42%) Migration Manager
13 16 (3.42%) SAP Data Migration Manager
Libraries, Frameworks & Software Standards
1 44 (9.40%) J2EE
2 21 (4.49%) Web Services
3 19 (4.06%) .NET
4 18 (3.85%) Middleware
5 16 (3.42%) XML
6 14 (2.99%) HTML
6 14 (2.99%) JSON
7 13 (2.78%) CSS
8 12 (2.56%) .NET Framework
9 9 (1.92%) BAPI
9 9 (1.92%) IDoc
9 9 (1.92%) Pandas
9 9 (1.92%) Web Dynpro
10 8 (1.71%) D3.js
10 8 (1.71%) RESTful
10 8 (1.71%) SAP Smart Forms
11 7 (1.50%) AngularJS
11 7 (1.50%) HTML5
11 7 (1.50%) React
12 6 (1.28%) Node.js
Miscellaneous
1 79 (16.88%) Analytical Skills
2 47 (10.04%) Reference Data
3 35 (7.48%) Management Information System
4 20 (4.27%) Algorithms
5 18 (3.85%) Computer Science
6 12 (2.56%) Social Media
7 11 (2.35%) Data Structures
8 8 (1.71%) User Experience
9 7 (1.50%) Replication
10 5 (1.07%) FMCG
10 5 (1.07%) Life Science
11 4 (0.85%) Mobile App
12 3 (0.64%) Clustering
12 3 (0.64%) Data Centre
12 3 (0.64%) Enterprise Software
12 3 (0.64%) Fintech
12 3 (0.64%) Smart Meter
13 2 (0.43%) Greenfield Project
13 2 (0.43%) LLPG
13 2 (0.43%) NHS
Operating Systems
1 16 (3.42%) Windows
2 12 (2.56%) Unix
3 11 (2.35%) Windows Server
4 7 (1.50%) Linux
5 1 (0.21%) Mac OS X
Processes & Methodologies
1 164 (35.04%) ETL
2 144 (30.77%) Business Intelligence
3 132 (28.21%) Data Management
4 121 (25.85%) Migration
5 118 (25.21%) Analytics
6 106 (22.65%) Data Migration
7 104 (22.22%) Project Management
8 97 (20.73%) Data Modelling
9 72 (15.38%) Data Analytics
10 71 (15.17%) Master Data Management
11 67 (14.32%) Data Analysis
12 61 (13.03%) Visualisation
13 51 (10.90%) Asset Management
14 50 (10.68%) Business Development
15 48 (10.26%) Wealth Management
16 47 (10.04%) Data Governance
17 44 (9.40%) Risk Management
18 43 (9.19%) Agile Software Development
18 43 (9.19%) CRM
19 42 (8.97%) Data Integration
Programming Languages
1 213 (45.51%) SQL
2 52 (11.11%) Java
3 47 (10.04%) Python
4 39 (8.33%) R
4 39 (8.33%) T-SQL
5 26 (5.56%) ABAP
5 26 (5.56%) C#
6 24 (5.13%) JavaScript
7 23 (4.91%) Scala
8 20 (4.27%) VBA
9 14 (2.99%) PL/SQL
10 10 (2.14%) VB
11 8 (1.71%) SAPscript
12 4 (0.85%) C
12 4 (0.85%) X++
13 3 (0.64%) Bash Shell
13 3 (0.64%) PHP
14 2 (0.43%) FoxPro (VFP)
14 2 (0.43%) MATLAB
14 2 (0.43%) VBScript
Qualifications
1 88 (18.80%) Degree
2 30 (6.41%) Security Cleared
3 10 (2.14%) Computer Science Degree
3 10 (2.14%) PhD
4 9 (1.92%) Microsoft Certification
5 8 (1.71%) MCITP
5 8 (1.71%) MCTS
5 8 (1.71%) SC Cleared
6 5 (1.07%) Numerate Degree
7 3 (0.64%) ISEB
8 2 (0.43%) CBAP
8 2 (0.43%) IIBA
8 2 (0.43%) Postgraduate
9 1 (0.21%) DV Cleared
9 1 (0.21%) MCSA
9 1 (0.21%) MCSE
9 1 (0.21%) PMI Certification
Quality Assurance & Compliance
1 145 (30.98%) Data Quality
2 14 (2.99%) GDPR
3 10 (2.14%) QA
4 8 (1.71%) CRD IV
4 8 (1.71%) EMIR
4 8 (1.71%) MiFID
5 6 (1.28%) PMO
5 6 (1.28%) SEPA
6 4 (0.85%) ISO/IEC 27001
6 4 (0.85%) PCI DSS
7 3 (0.64%) SLA
8 1 (0.21%) Actionable Recommendations
8 1 (0.21%) Solvency II
System Software
1 6 (1.28%) Docker
2 2 (0.43%) Apache Flume
2 2 (0.43%) HDFS
2 2 (0.43%) Hyper-V
Systems Management
1 2 (0.43%) Hadoop YARN
Vendors
1 120 (25.64%) Oracle
2 101 (21.58%) Microsoft
3 86 (18.38%) SAP
4 54 (11.54%) Informatica
5 49 (10.47%) Tableau
6 21 (4.49%) Talend
7 20 (4.27%) Salesforce.com
8 17 (3.63%) Cognos
9 16 (3.42%) IBM
9 16 (3.42%) Teradata
10 12 (2.56%) Adobe
11 10 (2.14%) Google
12 9 (1.92%) Cloudera
13 8 (1.71%) Alteryx
14 7 (1.50%) Netezza
14 7 (1.50%) Sybase
15 6 (1.28%) Ab Initio
16 5 (1.07%) Pega
16 5 (1.07%) Trillium
17 4 (0.85%) Elavon