Period
to 17 January 2018

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

Data Cleansing (Data Cleaning, Data Scrubbing)
Scotland > Glasgow
6 months to
17 Jan 2018
Same period 2017 Same period 2016
Rank 138 123 153
Rank change year-on-year -15 +30 -18
Permanent jobs citing Data Cleansing 8 1 4
As % of all permanent IT jobs advertised in Glasgow 0.36% 0.053% 0.15%
As % of the Processes & Methodologies category 0.40% 0.057% 0.17%
Number of salaries quoted 4 0 0
Glasgow median annual salary £52,500 - -
Scotland median annual salary £50,000 £42,250 £47,500
% change year-on-year +18.34% -11.05% +11.76%

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

All Process and Methodology Skills
Glasgow
Permanent vacancies with a requirement for process or methodology skills 2,024 1,753 2,382
As % of all permanent IT jobs advertised in Glasgow 92.29% 92.21% 91.30%
Number of salaries quoted 1,341 1,016 1,495
Glasgow median annual salary £47,500 £43,000 £42,500
Median salary % change year-on-year +10.47% +1.18% +6.25%
10th Percentile £31,500 £30,000 £28,750
90th Percentile £67,500 £60,000 £60,000
Scotland median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -

Data Cleansing
Job Vacancy Trend in Glasgow

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

Job vacancy trend for Data Cleansing in Glasgow

Data Cleansing
Salary Trend in Glasgow

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

Salary trend for Data Cleansing in Glasgow

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

1 8 (100.00%) Microsoft
2 7 (87.50%) Business Intelligence
3 6 (75.00%) ETL
4 5 (62.50%) SQL Server Reporting Services
4 5 (62.50%) Analytics
4 5 (62.50%) Analytical Skills
5 4 (50.00%) Performance Tuning
5 4 (50.00%) SQL Server
5 4 (50.00%) SQL Server Integration Services
6 3 (37.50%) SAP
6 3 (37.50%) SQL
6 3 (37.50%) Data Modelling
6 3 (37.50%) BusinessObjects
6 3 (37.50%) Front End Development
6 3 (37.50%) Power BI
6 3 (37.50%) User Acceptance Testing
6 3 (37.50%) Test Scripting
6 3 (37.50%) Business Analytics
7 2 (25.00%) Data Lake
7 2 (25.00%) Customer Requirements
7 2 (25.00%) Dynamics 365
7 2 (25.00%) Azure Data Factory
7 2 (25.00%) Data Migration
7 2 (25.00%) Microsoft Azure
7 2 (25.00%) Data Quality
7 2 (25.00%) Machine Learning
7 2 (25.00%) Big Data
7 2 (25.00%) Big Data Analytics
7 2 (25.00%) Data Analytics
7 2 (25.00%) Presales

Data Cleansing
Co-occurring IT Skills in Glasgow 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:

Applications
1 1 (12.50%) Microsoft Excel
Business Applications
1 2 (25.00%) Dynamics AX
2 1 (12.50%) Dynamics CRM
Cloud Services
1 2 (25.00%) Azure Data Factory
1 2 (25.00%) Dynamics 365
1 2 (25.00%) Microsoft Azure
Database & Business Intelligence
1 5 (62.50%) SQL Server Reporting Services
2 4 (50.00%) SQL Server
2 4 (50.00%) SQL Server Integration Services
3 3 (37.50%) BusinessObjects
3 3 (37.50%) Power BI
4 2 (25.00%) Big Data
4 2 (25.00%) Data Lake
4 2 (25.00%) Data Warehouse
5 1 (12.50%) Snowflake Schema
5 1 (12.50%) SQL Server Analysis Services
5 1 (12.50%) Star Schema
Development Applications
1 1 (12.50%) Team Foundation Server
1 1 (12.50%) VSS/SourceSafe
General
1 2 (25.00%) Advertising
1 2 (25.00%) Manufacturing
Job Titles
1 5 (62.50%) Consultant
2 3 (37.50%) Analytics Consultant
2 3 (37.50%) Business Analytics Consultant
2 3 (37.50%) Business Consultant
2 3 (37.50%) Customer Analytics Consultant
2 3 (37.50%) SAP Business Consultant
2 3 (37.50%) SAP Consultant
2 3 (37.50%) SAP Support
2 3 (37.50%) SAP Support Consultant
2 3 (37.50%) Support Consultant
3 2 (25.00%) Data Engineer
4 1 (12.50%) CRM Consultant
4 1 (12.50%) Developer
4 1 (12.50%) Dynamics AX Consultant
4 1 (12.50%) Dynamics CRM Consultant
4 1 (12.50%) ETL Developer
4 1 (12.50%) Functional Consultant
Miscellaneous
1 5 (62.50%) Analytical Skills
Processes & Methodologies
1 7 (87.50%) Business Intelligence
2 6 (75.00%) ETL
3 5 (62.50%) Analytics
4 4 (50.00%) Performance Tuning
5 3 (37.50%) Business Analytics
5 3 (37.50%) Data Modelling
5 3 (37.50%) Front End Development
5 3 (37.50%) Test Scripting
5 3 (37.50%) User Acceptance Testing
6 2 (25.00%) Artificial Intelligence
6 2 (25.00%) Big Data Analytics
6 2 (25.00%) Coaching
6 2 (25.00%) Customer Requirements
6 2 (25.00%) Data Analytics
6 2 (25.00%) Data Migration
6 2 (25.00%) ERP
6 2 (25.00%) Machine Learning
6 2 (25.00%) Migration
6 2 (25.00%) Presales
6 2 (25.00%) Project Management
Programming Languages
1 3 (37.50%) SQL
Quality Assurance & Compliance
1 2 (25.00%) Data Quality
Vendors
1 8 (100.00%) Microsoft
2 3 (37.50%) SAP