The table below looks at the statistics for Data Cleansing skills in IT jobs advertised for the Hertfordshire region. Included is a guide to the salaries offered in IT jobs that have cited Data Cleansing over the 3 months to 30 August 2016 with a comparison to the same period over the previous 2 years.

3 months to
30 Aug 2016
Same period 2015 Same period 2014
Data Cleansing (Data Scrubbing)
Rank 121 149 134
Rank change year-on-year
+28 -15
Permanent jobs citing Data Cleansing 12 6 15
As % of all permanent IT jobs located in Hertfordshire 0.62% 0.25% 0.65%
As % of the Processes & Methodologies category 0.73% 0.29% 0.77%
Number of salaries quoted 12 6 15
Median salary £52,500 £45,000 £36,000
Median salary % change year-on-year
+16.66% +25.00%
90% offered a salary of more than £45,000 £38,250 £27,500
10% offered a salary of more than £75,000 £71,250 £47,500
UK excluding London median salary £40,000 £39,500 £40,000
% change year-on-year
+1.26% -1.25%
Data Cleansing
East of England

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised in the Hertfordshire region.

Processes & Methodologies Category
Hertfordshire
Permanent IT job ads with a match in the
Processes & Methodologies category
1643 2057 1959
As % of all permanent IT jobs located in Hertfordshire 84.69% 85.74% 84.29%
Number of salaries quoted 1419 1783 1600
Median salary £50,000 £50,000 £47,500
Median salary % change year-on-year
- +5.26%
90% offered a salary of more than £32,500 £31,500 £32,500
10% offered a salary of more than £70,000 £75,000 £70,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

Data Cleansing
Jobs Demand Trend in Hertfordshire

The demand trend of job ads across the Hertfordshire region citing Data Cleansing as a proportion of all IT jobs with a match in the Processes & Methodologies category.

Data Cleansing Jobs Demand Trend in Hertfordshire

Data Cleansing
Salary Trend in Hertfordshire

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

Data Cleansing Salary Trend in Hertfordshire

Data Cleansing
Salary Histogram in Hertfordshire

This chart provides a salary histogram for IT jobs citing Data Cleansing across the Hertfordshire region over the 3 months to 30 August 2016.

Data Cleansing Salary Histogram in Hertfordshire

Data Cleansing
Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Cleansing within the Hertfordshire region over the 3 months to 30 August 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Watford - 6 £67,500 -
Stevenage - 5 £45,000 -
Data Cleansing
East of England

Data Cleansing
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 30 August 2016, 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 Hertfordshire region with a requirement for Data Cleansing.

1 14 (93.33%) SQL
1 14 (93.33%) T-SQL
1 14 (93.33%) ETL
2 10 (66.67%) Data Analysis
3 9 (60.00%) Data Extraction
4 8 (53.33%) VBA
5 7 (46.67%) SQL Server
5 7 (46.67%) MS Office
5 7 (46.67%) Business Intelligence
5 7 (46.67%) Data Quality
5 7 (46.67%) Retail
5 7 (46.67%) Finance
6 6 (40.00%) Degree
6 6 (40.00%) Data Migration
6 6 (40.00%) Data Conversion
6 6 (40.00%) Talend
6 6 (40.00%) Performance Tuning
6 6 (40.00%) SC Cleared
6 6 (40.00%) Security Cleared
6 6 (40.00%) Talend Open Studio
6 6 (40.00%) Migration
6 6 (40.00%) Data Warehouse
6 6 (40.00%) ERP
6 6 (40.00%) Data Mining
6 6 (40.00%) Informatica
6 6 (40.00%) XML
6 6 (40.00%) PRINCE2
6 6 (40.00%) Unix
6 6 (40.00%) Windows
6 6 (40.00%) Oracle

Data Cleansing
Top Related IT Skills in Hertfordshire 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 7 (46.67%) MS Office
2 2 (13.33%) MS Excel
Database & Business Intelligence
1 7 (46.67%) SQL Server
2 6 (40.00%) Data Mining
2 6 (40.00%) Data Warehouse
3 1 (6.67%) Microsoft Analysis Services
3 1 (6.67%) Power BI
3 1 (6.67%) Relational Database
3 1 (6.67%) SAP Data Services
3 1 (6.67%) SQL Server 2008
3 1 (6.67%) SQL Server 2012
3 1 (6.67%) SQL Server Reporting Services
Development Applications
1 6 (40.00%) Talend Open Studio
General
1 7 (46.67%) Finance
1 7 (46.67%) Retail
2 1 (6.67%) Manufacturing
2 1 (6.67%) Pharmaceutical
Job Titles
1 7 (46.67%) Consultant
2 6 (40.00%) Data Consultant
2 6 (40.00%) Data Migration Consultant
2 6 (40.00%) Migration Consultant
3 5 (33.33%) Analyst
3 5 (33.33%) Data Engineer
4 3 (20.00%) Data Analyst
4 3 (20.00%) Senior Consultant
4 3 (20.00%) SQL Analyst
4 3 (20.00%) SQL Data Analyst
4 3 (20.00%) SQL Server Analyst
5 1 (6.67%) Business Consultant
5 1 (6.67%) Business Intelligence Analyst
5 1 (6.67%) Data Manager
5 1 (6.67%) Excel Developer
5 1 (6.67%) Excel VBA Developer
5 1 (6.67%) Master Data Manager
5 1 (6.67%) SAP Manager
5 1 (6.67%) SQL Developer
5 1 (6.67%) VBA Developer
Libraries, Frameworks & Software Standards
1 6 (40.00%) XML
Miscellaneous
1 9 (60.00%) Data Extraction
2 6 (40.00%) Analytical Skills
2 6 (40.00%) Data Conversion
3 1 (6.67%) FMCG
Operating Systems
1 6 (40.00%) Unix
1 6 (40.00%) Windows
Processes & Methodologies
1 14 (93.33%) ETL
2 10 (66.67%) Data Analysis
3 7 (46.67%) Business Intelligence
4 6 (40.00%) Data Migration
4 6 (40.00%) ERP
4 6 (40.00%) Migration
4 6 (40.00%) Performance Tuning
4 6 (40.00%) PRINCE2
5 2 (13.33%) Project Management
6 1 (6.67%) Business Analysis
6 1 (6.67%) Code Optimisation
6 1 (6.67%) Continuous Improvement
6 1 (6.67%) Data Entry
6 1 (6.67%) Data Management
6 1 (6.67%) Data Transformation
6 1 (6.67%) Incident Management
6 1 (6.67%) ITIL
6 1 (6.67%) Quality Management
Programming Languages
1 14 (93.33%) SQL
1 14 (93.33%) T-SQL
2 8 (53.33%) VBA
3 6 (40.00%) C#
3 6 (40.00%) C++
3 6 (40.00%) Java
3 6 (40.00%) VB
3 6 (40.00%) VBScript
Qualifications
1 6 (40.00%) Degree
1 6 (40.00%) SC Cleared
1 6 (40.00%) Security Cleared
2 1 (6.67%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 7 (46.67%) Data Quality
2 1 (6.67%) QA
Vendors
1 6 (40.00%) Informatica
1 6 (40.00%) Oracle
1 6 (40.00%) Talend
2 2 (13.33%) Microsoft
3 1 (6.67%) SAP
3 1 (6.67%) Tableau