Period
to 24 November 2017

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

Data Cleansing (Data Cleaning, Data Scrubbing)
UK > England
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 732 818 888
Rank change year-on-year +86 +70 -65
Permanent jobs citing Data Cleansing 452 406 407
As % of all permanent IT jobs advertised in England 0.27% 0.23% 0.20%
As % of the Processes & Methodologies category 0.30% 0.25% 0.22%
Number of salaries quoted 282 348 304
England median annual salary £46,250 £45,000 £42,500
Median salary % change year-on-year +2.78% +5.88% -
10th Percentile £23,275 £27,425 £26,250
90th Percentile £85,000 £75,000 £68,375
UK median annual salary £45,000 £45,000 £41,500
% change year-on-year - +8.43% -2.35%

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

All Process and Methodology Skills
England
Permanent vacancies with a requirement for process or methodology skills 151740 159655 182630
As % of all permanent IT jobs advertised in England 89.91% 89.41% 88.75%
Number of salaries quoted 120747 133850 152095
England median annual salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26% +5.56%
10th Percentile £28,750 £28,250 £27,500
90th Percentile £80,000 £80,000 £77,500
UK median annual salary £50,000 £49,500 £47,500
% change year-on-year +1.01% +4.21% +5.56%

Data Cleansing
Job Vacancy Trend in England

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

Job vacancy trend for Data Cleansing in England

Data Cleansing
Salary Trend in England

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

Salary trend for Data Cleansing in England

Data Cleansing
Salary Histogram in England

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

Salary histogram for Data Cleansing in England

Data Cleansing
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Cleansing within the England region over the 6 months to 24 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
London +11 202 £57,500 +15.00% 14
South East +62 99 £40,750 +5.84% 7
North of England +47 77 £35,000 -12.50% 3
Yorkshire +48 41 £35,750 -22.28% 2
Midlands +38 41 £50,000 +17.65% 9
North West -12 34 £25,000 -35.90% 1
West Midlands +18 25 £52,500 +23.53% 4
South West +17 17 £40,875 +9.00% 1
East Midlands +35 16 £47,500 +5.56% 4
East of England +1 13 £35,000 -33.33% 1
North East +6 2 £36,500 -33.64%
Data Cleansing
UK

For the 6 months to 24 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 across the England region with a requirement for Data Cleansing.

1 202 (44.69%) SQL
2 159 (35.18%) ETL
2 159 (35.18%) Finance
3 144 (31.86%) Data Quality
4 136 (30.09%) Data Management
5 133 (29.42%) Business Intelligence
6 123 (27.21%) Oracle
7 117 (25.88%) Migration
8 113 (25.00%) Analytics
9 102 (22.57%) Data Migration
10 97 (21.46%) Project Management
10 97 (21.46%) SQL Server
11 93 (20.58%) Data Warehouse
12 90 (19.91%) Data Modelling
13 89 (19.69%) Legal
14 87 (19.25%) Microsoft
15 86 (19.03%) Degree
16 85 (18.81%) SAP
17 74 (16.37%) Master Data Management
18 73 (16.15%) Analytical Skills
18 73 (16.15%) Microsoft Excel
19 72 (15.93%) Data Analytics
20 68 (15.04%) Data Analysis
21 61 (13.50%) SQL Server Integration Services
22 60 (13.27%) Visualisation
23 56 (12.39%) Informatica
24 55 (12.17%) Banking
25 54 (11.95%) Asset Management
26 52 (11.50%) SQL Server Reporting Services
26 52 (11.50%) Java

Data Cleansing
Co-occurring IT Skills in England 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 48 (10.62%) SAS
2 16 (3.54%) SharePoint
3 15 (3.32%) Apache Spark
4 13 (2.88%) IIS
5 8 (1.77%) Oracle Workflow
6 4 (0.88%) Apache
6 4 (0.88%) ArcGIS
7 2 (0.44%) Mule
7 2 (0.44%) Mule ESB
8 1 (0.22%) Apache Pig
8 1 (0.22%) Elasticsearch
8 1 (0.22%) NetWeaver
Applications
1 73 (16.15%) Microsoft Excel
2 24 (5.31%) Microsoft Office
2 24 (5.31%) SPSS
3 11 (2.43%) MS Visio
4 9 (1.99%) Microsoft PowerPoint
5 1 (0.22%) Microsoft Project
5 1 (0.22%) Spreadsheet
Business Applications
1 14 (3.10%) SAP ERP
2 9 (1.99%) SAP CRM
3 5 (1.11%) Dynamics CRM
4 4 (0.88%) Dynamics AX
4 4 (0.88%) FastStats
5 3 (0.66%) Adobe Campaign
6 2 (0.44%) SAP MDG
7 1 (0.22%) Investran
7 1 (0.22%) Salesforce.com CRM
7 1 (0.22%) SAP Hybris
7 1 (0.22%) SAP SD
Cloud Services
1 23 (5.09%) Microsoft Azure
2 21 (4.65%) Amazon AWS
3 8 (1.77%) Amazon Kinesis
3 8 (1.77%) Google Cloud Platform
4 7 (1.55%) Azure Data Factory
5 6 (1.33%) Salesforce Service Cloud
6 5 (1.11%) Cortana Intelligence Suite
7 4 (0.88%) Amazon EMR
8 3 (0.66%) Dynamics 365
9 2 (0.44%) Amazon S3
9 2 (0.44%) Google Analytics
10 1 (0.22%) Adobe Analytics
10 1 (0.22%) Google Tag Manager
10 1 (0.22%) PaaS
Communications & Networking
1 2 (0.44%) Internet
1 2 (0.44%) SMS
2 1 (0.22%) MQTT
Database & Business Intelligence
1 97 (21.46%) SQL Server
2 93 (20.58%) Data Warehouse
3 61 (13.50%) SQL Server Integration Services
4 52 (11.50%) SQL Server Reporting Services
5 48 (10.62%) Oracle Database
6 44 (9.73%) Oracle Database 10g
6 44 (9.73%) SAP Data Services
7 36 (7.96%) BusinessObjects
8 28 (6.19%) Data Mining
9 25 (5.53%) SQL Server Analysis Services
10 24 (5.31%) Spotfire
11 23 (5.09%) QlikView
12 22 (4.87%) BODI
12 22 (4.87%) Crystal Reports
12 22 (4.87%) DataStage
13 19 (4.20%) Big Data
14 18 (3.98%) Oracle Reports
15 17 (3.76%) Hadoop
15 17 (3.76%) Relational Database
16 16 (3.54%) NoSQL
Development Applications
1 21 (4.65%) Talend Open Studio
2 13 (2.88%) SQL Server Management Studio (SSMS)
3 11 (2.43%) JIRA
4 8 (1.77%) LSMW
5 7 (1.55%) Visual Studio
6 5 (1.11%) Eclipse
6 5 (1.11%) ERwin
6 5 (1.11%) Git (software)
7 3 (0.66%) Oracle Forms
8 1 (0.22%) Jenkins
8 1 (0.22%) PowerDesigner
8 1 (0.22%) Rational Rhapsody
8 1 (0.22%) Rational Rose
8 1 (0.22%) Sonatype Nexus
General
1 159 (35.18%) Finance
2 89 (19.69%) Legal
3 55 (12.17%) Banking
4 47 (10.40%) Marketing
5 45 (9.96%) Retail Banking
6 44 (9.73%) Investment Banking
7 22 (4.87%) Retail
8 15 (3.32%) Manufacturing
9 9 (1.99%) Front Office
10 7 (1.55%) Advertising
11 6 (1.33%) Back Office
11 6 (1.33%) Games
12 5 (1.11%) Law
13 4 (0.88%) Pharmaceutical
13 4 (0.88%) Telecoms
14 3 (0.66%) Billing
14 3 (0.66%) Retail Finance
15 1 (0.22%) Automotive
15 1 (0.22%) Publishing
Job Titles
1 109 (24.12%) Analyst
2 97 (21.46%) Developer
3 72 (15.93%) Data Analyst
4 50 (11.06%) Technical Leader
5 35 (7.74%) Data Manager
6 32 (7.08%) SAP Developer
7 30 (6.64%) Consultant
8 23 (5.09%) SAP Manager
9 22 (4.87%) SAP Data Manager
9 22 (4.87%) SQL Developer
10 20 (4.42%) Business Intelligence Developer
11 19 (4.20%) SAP BusinessObjects (BO) Developer
12 18 (3.98%) Architect
13 17 (3.76%) Business Intelligence Analyst
13 17 (3.76%) Data Migration Manager
13 17 (3.76%) Migration Manager
13 17 (3.76%) SAP Data Migration Manager
14 16 (3.54%) Data Migration Lead
14 16 (3.54%) SAP Consultant
14 16 (3.54%) SAP Data Migration Lead
Libraries, Frameworks & Software Standards
1 44 (9.73%) J2EE
2 21 (4.65%) .NET
3 19 (4.20%) Middleware
3 19 (4.20%) Web Services
4 16 (3.54%) .NET Framework
5 15 (3.32%) XML
6 14 (3.10%) CSS
6 14 (3.10%) HTML
6 14 (3.10%) JSON
7 9 (1.99%) BAPI
7 9 (1.99%) D3.js
7 9 (1.99%) IDoc
7 9 (1.99%) Pandas
7 9 (1.99%) RESTful
7 9 (1.99%) Web Dynpro
8 8 (1.77%) AngularJS
8 8 (1.77%) HTML5
8 8 (1.77%) React
8 8 (1.77%) SAP Smart Forms
9 6 (1.33%) Node.js
Miscellaneous
1 73 (16.15%) Analytical Skills
2 47 (10.40%) Reference Data
3 38 (8.41%) Management Information System
4 20 (4.42%) Algorithms
5 17 (3.76%) Computer Science
6 12 (2.65%) Social Media
7 10 (2.21%) Analytical Mindset
8 8 (1.77%) Data Structures
8 8 (1.77%) Replication
8 8 (1.77%) User Experience
9 5 (1.11%) FMCG
9 5 (1.11%) Life Science
10 4 (0.88%) Clustering
11 3 (0.66%) Data Centre
11 3 (0.66%) Enterprise Software
11 3 (0.66%) Fintech
11 3 (0.66%) Smart Meter
12 2 (0.44%) Greenfield Project
12 2 (0.44%) LLPG
12 2 (0.44%) NHS
Operating Systems
1 17 (3.76%) Windows
2 12 (2.65%) Unix
3 10 (2.21%) Windows Server
4 6 (1.33%) Linux
5 1 (0.22%) Mac OS X
Processes & Methodologies
1 159 (35.18%) ETL
2 136 (30.09%) Data Management
3 133 (29.42%) Business Intelligence
4 117 (25.88%) Migration
5 113 (25.00%) Analytics
6 102 (22.57%) Data Migration
7 97 (21.46%) Project Management
8 90 (19.91%) Data Modelling
9 74 (16.37%) Master Data Management
10 72 (15.93%) Data Analytics
11 68 (15.04%) Data Analysis
12 60 (13.27%) Visualisation
13 54 (11.95%) Asset Management
14 52 (11.50%) Wealth Management
15 51 (11.28%) Business Development
16 49 (10.84%) Risk Management
17 46 (10.18%) Data Governance
18 44 (9.73%) Data Integration
19 40 (8.85%) Coaching
19 40 (8.85%) Data Visualisation
Programming Languages
1 202 (44.69%) SQL
2 52 (11.50%) Java
3 45 (9.96%) Python
4 38 (8.41%) R
5 32 (7.08%) T-SQL
6 26 (5.75%) ABAP
7 25 (5.53%) JavaScript
8 23 (5.09%) C#
9 22 (4.87%) Scala
9 22 (4.87%) VBA
10 17 (3.76%) PL/SQL
11 16 (3.54%) VB
12 8 (1.77%) SAPscript
13 3 (0.66%) Apex Code
13 3 (0.66%) C
14 2 (0.44%) Bash Shell
14 2 (0.44%) Data Analysis Expressions (DAX)
14 2 (0.44%) FoxPro (VFP)
14 2 (0.44%) VBScript
14 2 (0.44%) XAML
Qualifications
1 86 (19.03%) Degree
2 30 (6.64%) Security Cleared
3 10 (2.21%) Computer Science Degree
3 10 (2.21%) Microsoft Certification
3 10 (2.21%) PhD
4 9 (1.99%) MCITP
4 9 (1.99%) MCTS
5 8 (1.77%) SC Cleared
6 3 (0.66%) ISEB
6 3 (0.66%) Numerate Degree
7 2 (0.44%) CBAP
7 2 (0.44%) IIBA
7 2 (0.44%) Postgraduate
8 1 (0.22%) DV Cleared
8 1 (0.22%) MCSA
8 1 (0.22%) MCSE
8 1 (0.22%) PMI Certification
Quality Assurance & Compliance
1 144 (31.86%) Data Quality
2 13 (2.88%) GDPR
3 9 (1.99%) CRD IV
3 9 (1.99%) EMIR
3 9 (1.99%) MiFID
4 8 (1.77%) QA
5 6 (1.33%) PMO
5 6 (1.33%) SEPA
6 4 (0.88%) ISO/IEC 27001
6 4 (0.88%) PCI DSS
7 3 (0.66%) SLA
8 1 (0.22%) Actionable Recommendations
8 1 (0.22%) Solvency II
System Software
1 5 (1.11%) Docker
2 2 (0.44%) Apache Flume
2 2 (0.44%) HDFS
2 2 (0.44%) Hyper-V
Systems Management
1 2 (0.44%) Hadoop YARN
Vendors
1 123 (27.21%) Oracle
2 87 (19.25%) Microsoft
3 85 (18.81%) SAP
4 56 (12.39%) Informatica
5 50 (11.06%) Tableau
6 21 (4.65%) Salesforce.com
6 21 (4.65%) Talend
7 18 (3.98%) Teradata
8 17 (3.76%) Cognos
8 17 (3.76%) IBM
9 12 (2.65%) Adobe
10 11 (2.43%) Google
11 10 (2.21%) Cloudera
12 9 (1.99%) Alteryx
13 8 (1.77%) Netezza
14 7 (1.55%) Sybase
15 6 (1.33%) Ab Initio
16 5 (1.11%) Pega
16 5 (1.11%) Trillium
17 4 (0.88%) Elavon