Period
to 23 January 2018

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

Data Cleansing (Data Cleaning, Data Scrubbing)
England > London
6 months to
23 Jan 2018
Same period 2017 Same period 2016
Rank 613 609 726
Rank change year-on-year -4 +117 -38
Permanent jobs citing Data Cleansing 217 199 184
As % of all permanent IT jobs advertised in London 0.31% 0.28% 0.22%
As % of the Processes & Methodologies category 0.34% 0.31% 0.24%
Number of salaries quoted 145 184 130
London median annual salary £57,500 £50,000 £50,000
Median salary % change year-on-year +15.00% - -4.76%
10th Percentile £35,000 £27,325 £30,000
90th Percentile £88,400 £77,500 £80,250
England median annual salary £50,000 £42,500 £44,500
% change year-on-year +17.65% -4.49% +2.30%

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

All Process and Methodology Skills
London
Permanent vacancies with a requirement for process or methodology skills 64,332 63,652 75,855
As % of all permanent IT jobs advertised in London 91.53% 90.51% 89.83%
Number of salaries quoted 51,812 54,221 64,331
London median annual salary £60,000 £60,000 £55,000
Median salary % change year-on-year - +9.09% -
10th Percentile £35,750 £33,750 £33,750
90th Percentile £91,250 £90,000 £87,500
England median annual salary £50,000 £50,000 £47,500
% change year-on-year - +5.26% +5.56%

Data Cleansing
Job Vacancy Trend in London

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

Job vacancy trend for Data Cleansing in London

Data Cleansing
Salary Trend in London

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

Salary trend for Data Cleansing in London

Data Cleansing
Salary Histogram in London

The salary distribution of IT jobs citing Data Cleansing in London over the 6 months to 23 January 2018.

Salary histogram for Data Cleansing in London

Data Cleansing
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Cleansing within the London region over the 6 months to 23 January 2018. 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
Central London -26 39 £60,000 +41.18% 11
West London +32 22 £57,500 +38.55% 6
South London -21 2 £80,000 +77.78% 1
Data Cleansing
England

For the 6 months to 23 January 2018, 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 across the London region with a requirement for Data Cleansing.

1 116 (53.46%) SQL
2 111 (51.15%) Finance
3 78 (35.94%) Data Quality
4 77 (35.48%) Analytics
5 71 (32.72%) Oracle
6 70 (32.26%) Data Management
7 69 (31.80%) ETL
8 65 (29.95%) Data Analytics
9 61 (28.11%) Data Modelling
10 59 (27.19%) SQL Server
10 59 (27.19%) Microsoft Excel
11 56 (25.81%) Degree
12 51 (23.50%) Data Governance
13 50 (23.04%) Master Data Management
14 49 (22.58%) Business Intelligence
15 48 (22.12%) Microsoft
15 48 (22.12%) Visualisation
16 47 (21.66%) Migration
17 45 (20.74%) Data Analysis
18 43 (19.82%) Wealth Management
19 42 (19.35%) Asset Management
20 40 (18.43%) Tableau
21 39 (17.97%) SQL Server Integration Services
21 39 (17.97%) Data Migration
22 37 (17.05%) Data Visualisation
23 36 (16.59%) Banking
24 35 (16.13%) Management Information System
24 35 (16.13%) SAS
24 35 (16.13%) Data Warehouse
24 35 (16.13%) Machine Learning

Data Cleansing
Co-occurring IT Skills in London 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 35 (16.13%) SAS
2 20 (9.22%) Apache Spark
3 17 (7.83%) SharePoint
4 16 (7.37%) Oracle Workflow
5 11 (5.07%) IIS
6 3 (1.38%) Apache
7 2 (0.92%) ArcGIS
7 2 (0.92%) Mule
7 2 (0.92%) Mule ESB
Applications
1 59 (27.19%) Microsoft Excel
2 32 (14.75%) SPSS
3 8 (3.69%) Microsoft Office
3 8 (3.69%) Microsoft PowerPoint
3 8 (3.69%) MS Visio
4 1 (0.46%) Microsoft Project
Business Applications
1 6 (2.76%) Dynamics CRM
2 4 (1.84%) Elite 3E
3 2 (0.92%) Adobe Campaign
3 2 (0.92%) FastStats
Cloud Services
1 23 (10.60%) Amazon AWS
2 13 (5.99%) Amazon Kinesis
2 13 (5.99%) Google Cloud Platform
3 7 (3.23%) Microsoft Azure
4 5 (2.30%) Dynamics 365
4 5 (2.30%) Salesforce Service Cloud
5 3 (1.38%) Cortana Intelligence Suite
6 2 (0.92%) Amazon EMR
6 2 (0.92%) Amazon S3
6 2 (0.92%) Salesforce Sales Cloud
7 1 (0.46%) Adobe Analytics
7 1 (0.46%) Google Analytics
7 1 (0.46%) Google Tag Manager
Communications & Networking
1 1 (0.46%) Internet
Database & Business Intelligence
1 59 (27.19%) SQL Server
2 39 (17.97%) SQL Server Integration Services
3 35 (16.13%) Data Warehouse
4 32 (14.75%) Spotfire
5 28 (12.90%) Crystal Reports
6 27 (12.44%) QlikView
7 26 (11.98%) SQL Server Reporting Services
8 25 (11.52%) Oracle Database
8 25 (11.52%) Oracle Database 10g
9 23 (10.60%) Big Data
10 17 (7.83%) Data Mining
11 16 (7.37%) Apache Cassandra
11 16 (7.37%) Oracle Reports
12 14 (6.45%) Amazon Redshift
12 14 (6.45%) Power BI
12 14 (6.45%) SQL Server Analysis Services
13 13 (5.99%) BigQuery
13 13 (5.99%) SAS Visual Analytics
14 12 (5.53%) Hadoop
15 9 (4.15%) OLAP
Development Applications
1 11 (5.07%) SQL Server Management Studio (SSMS)
2 9 (4.15%) JIRA
3 5 (2.30%) Eclipse
3 5 (2.30%) ERwin
3 5 (2.30%) Visual Studio
4 4 (1.84%) Git (software)
5 1 (0.46%) Jenkins
General
1 111 (51.15%) Finance
2 36 (16.59%) Banking
3 30 (13.82%) Legal
4 26 (11.98%) Investment Banking
4 26 (11.98%) Retail Banking
5 21 (9.68%) Marketing
6 17 (7.83%) Front Office
7 13 (5.99%) Retail
8 6 (2.76%) Advertising
8 6 (2.76%) Back Office
9 4 (1.84%) Law
10 1 (0.46%) Automotive
10 1 (0.46%) Pharmaceutical
10 1 (0.46%) Publishing
Job Titles
1 51 (23.50%) Analyst
2 44 (20.28%) Developer
3 35 (16.13%) Technical Leader
4 34 (15.67%) Data Analyst
5 17 (7.83%) SQL Developer
6 13 (5.99%) Business Intelligence Developer
7 12 (5.53%) Data Scientist
8 11 (5.07%) Administrator
8 11 (5.07%) Business Analyst
8 11 (5.07%) Senior Developer
9 9 (4.15%) Applications Support
9 9 (4.15%) Applications Support Analyst
9 9 (4.15%) Architect
9 9 (4.15%) Data Architect
9 9 (4.15%) Salesforce Administrator
9 9 (4.15%) Technical Developer
10 8 (3.69%) Excel Developer
10 8 (3.69%) Excel VBA Developer
10 8 (3.69%) Technical Design Analyst
10 8 (3.69%) Technical Design Leader
Libraries, Frameworks & Software Standards
1 25 (11.52%) J2EE
2 24 (11.06%) .NET
2 24 (11.06%) .NET Framework
2 24 (11.06%) Web Services
3 18 (8.29%) D3.js
4 13 (5.99%) AngularJS
4 13 (5.99%) CSS
4 13 (5.99%) HTML
4 13 (5.99%) HTML5
4 13 (5.99%) React
5 12 (5.53%) JSON
6 11 (5.07%) Middleware
7 9 (4.15%) Pandas
7 9 (4.15%) RESTful
8 7 (3.23%) Natural Language Processing
9 4 (1.84%) Celery
9 4 (1.84%) Kafka
9 4 (1.84%) Node.js
9 4 (1.84%) NumPy
9 4 (1.84%) Scrapy
Miscellaneous
1 35 (16.13%) Management Information System
2 28 (12.90%) Reference Data
3 25 (11.52%) Analytical Skills
4 14 (6.45%) Analytical Mindset
5 13 (5.99%) Computer Science
5 13 (5.99%) User Experience
6 12 (5.53%) Algorithms
7 8 (3.69%) Social Media
8 4 (1.84%) FMCG
9 2 (0.92%) Data Structures
9 2 (0.92%) Enterprise Software
9 2 (0.92%) Fintech
9 2 (0.92%) Life Science
9 2 (0.92%) Replication
9 2 (0.92%) Taxonomies
10 1 (0.46%) Greenfield Project
10 1 (0.46%) Linux Command Line
10 1 (0.46%) Minimum Viable Product
Operating Systems
1 10 (4.61%) Windows
2 9 (4.15%) Windows Server
3 3 (1.38%) Linux
Processes & Methodologies
1 77 (35.48%) Analytics
2 70 (32.26%) Data Management
3 69 (31.80%) ETL
4 65 (29.95%) Data Analytics
5 61 (28.11%) Data Modelling
6 51 (23.50%) Data Governance
7 50 (23.04%) Master Data Management
8 49 (22.58%) Business Intelligence
9 48 (22.12%) Visualisation
10 47 (21.66%) Migration
11 45 (20.74%) Data Analysis
12 43 (19.82%) Wealth Management
13 42 (19.35%) Asset Management
14 39 (17.97%) Data Migration
15 37 (17.05%) Data Visualisation
16 35 (16.13%) Machine Learning
17 30 (13.82%) Project Management
18 25 (11.52%) Mathematics
19 24 (11.06%) Business Analysis
20 23 (10.60%) Stakeholder Management
Programming Languages
1 116 (53.46%) SQL
2 33 (15.21%) R
3 32 (14.75%) Python
4 31 (14.29%) Java
5 22 (10.14%) T-SQL
6 21 (9.68%) JavaScript
7 20 (9.22%) VBA
8 19 (8.76%) Scala
9 18 (8.29%) PL/SQL
10 17 (7.83%) VB
11 8 (3.69%) Data Analysis Expressions (DAX)
12 7 (3.23%) Apex Code
13 4 (1.84%) C#
14 2 (0.92%) Bash Shell
14 2 (0.92%) C
14 2 (0.92%) C++
Qualifications
1 56 (25.81%) Degree
2 9 (4.15%) MCITP
2 9 (4.15%) MCTS
2 9 (4.15%) Microsoft Certification
3 8 (3.69%) PhD
4 6 (2.76%) Computer Science Degree
5 5 (2.30%) Security Cleared
6 2 (0.92%) CBAP
6 2 (0.92%) IIBA
6 2 (0.92%) ISEB
6 2 (0.92%) Numerate Degree
7 1 (0.46%) DV Cleared
Quality Assurance & Compliance
1 78 (35.94%) Data Quality
2 15 (6.91%) GDPR
3 14 (6.45%) EMIR
3 14 (6.45%) MiFID
4 13 (5.99%) CRD IV
5 7 (3.23%) QA
6 6 (2.76%) PMO
6 6 (2.76%) SEPA
7 5 (2.30%) Solvency II
8 3 (1.38%) SLA
9 1 (0.46%) Actionable Recommendations
9 1 (0.46%) Dodd-Frank
9 1 (0.46%) FATCA
System Software
1 4 (1.84%) Docker
2 2 (0.92%) Apache Flume
2 2 (0.92%) HDFS
Systems Management
1 2 (0.92%) Hadoop YARN
2 1 (0.46%) Mesos
Vendors
1 71 (32.72%) Oracle
2 48 (22.12%) Microsoft
3 40 (18.43%) Tableau
4 26 (11.98%) Informatica
5 22 (10.14%) Salesforce.com
5 22 (10.14%) Talend
6 17 (7.83%) Google
6 17 (7.83%) Teradata
7 15 (6.91%) Cloudera
8 14 (6.45%) Alteryx
9 13 (5.99%) Netezza
10 10 (4.61%) IBM
11 7 (3.23%) Sybase
12 5 (2.30%) Pega
13 4 (1.84%) Ab Initio
13 4 (1.84%) Aderant
14 3 (1.38%) Adobe
14 3 (1.38%) Apple
14 3 (1.38%) Intapp
15 2 (0.92%) SAP