Period
to 24 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Watford with a requirement for ETL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ETL over the 6 months to 24 November 2017 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
Hertfordshire > Watford
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 48 50 90
Rank change year-on-year +2 +40 +16
Permanent jobs citing ETL 48 38 15
As % of all permanent IT jobs advertised in Watford 4.93% 3.72% 1.41%
As % of the Processes & Methodologies category 5.75% 4.14% 1.62%
Number of salaries quoted 43 32 14
Watford median annual salary £55,000 £55,000 £45,500
Median salary % change year-on-year - +20.88% -13.33%
10th Percentile £29,900 £50,000 £35,000
90th Percentile £72,500 £69,375 £53,125
Hertfordshire median annual salary £51,500 £52,500 £47,500
% change year-on-year -1.90% +10.53% -5.00%

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

All Process and Methodology Skills
Watford
Permanent vacancies with a requirement for process or methodology skills 835 917 925
As % of all permanent IT jobs advertised in Watford 85.82% 89.73% 87.18%
Number of salaries quoted 687 783 749
Watford median annual salary £50,000 £52,500 £47,500
Median salary % change year-on-year -4.76% +10.53% +5.56%
10th Percentile £30,000 £28,000 £26,750
90th Percentile £68,750 £75,000 £72,500
Hertfordshire median annual salary £47,500 £50,000 £47,500
% change year-on-year -5.00% +5.26% +3.26%

ETL
Job Vacancy Trend in Watford

Job postings citing ETL as a percentage of all IT jobs advertised in Watford.

Job vacancy trend for ETL in Watford

ETL
Salary Trend in Watford

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

Salary trend for ETL in Watford

ETL
Salary Histogram in Watford

The salary distribution of IT jobs citing ETL in Watford over the 6 months to 24 November 2017.

Salary histogram for ETL in Watford

For the 6 months to 24 November 2017, IT jobs citing ETL 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 Watford region with a requirement for ETL.

1 45 (93.75%) SQL
2 37 (77.08%) SQL Server Integration Services
3 32 (66.67%) SQL Server
3 32 (66.67%) Business Intelligence
4 31 (64.58%) Data Warehouse
5 27 (56.25%) T-SQL
6 26 (54.17%) Data Modelling
7 25 (52.08%) .NET
8 24 (50.00%) SQL Server Analysis Services
9 21 (43.75%) SQL Server 2012
10 18 (37.50%) Power BI
10 18 (37.50%) MDX
10 18 (37.50%) Microsoft
11 17 (35.42%) Unit Testing
11 17 (35.42%) Kimball Methodology
12 16 (33.33%) Inmon Methodology
12 16 (33.33%) REST
12 16 (33.33%) Performance Tuning
12 16 (33.33%) ETL Development
12 16 (33.33%) SQL Server 2014
12 16 (33.33%) SQL Server 2016
12 16 (33.33%) PowerShell
12 16 (33.33%) Database Tuning
12 16 (33.33%) Team Foundation Server
12 16 (33.33%) MS Access
12 16 (33.33%) Cognos
12 16 (33.33%) VBA
12 16 (33.33%) SOAP
12 16 (33.33%) Web Services
12 16 (33.33%) IBM

ETL
Co-occurring IT Skills in Watford 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 1 (2.08%) Apache
1 1 (2.08%) Drupal
1 1 (2.08%) Tomcat
Applications
1 8 (16.67%) Microsoft Excel
Business Applications
1 3 (6.25%) Orchard Housing
2 2 (4.17%) Dynamics CRM
2 2 (4.17%) FastStats
Communications & Networking
1 14 (29.17%) DNS
1 14 (29.17%) Firewall
Database & Business Intelligence
1 37 (77.08%) SQL Server Integration Services
2 32 (66.67%) SQL Server
3 31 (64.58%) Data Warehouse
4 24 (50.00%) SQL Server Analysis Services
5 21 (43.75%) SQL Server 2012
6 18 (37.50%) Power BI
7 16 (33.33%) MS Access
7 16 (33.33%) SQL Server 2014
7 16 (33.33%) SQL Server 2016
8 14 (29.17%) SAP Data Services
9 9 (18.75%) SAP BW
10 8 (16.67%) SQL Server Reporting Services
11 7 (14.58%) Oracle Database
12 3 (6.25%) BusinessObjects
12 3 (6.25%) OLAP
12 3 (6.25%) Oracle ODI
12 3 (6.25%) RDBMS
12 3 (6.25%) Relational Database
13 2 (4.17%) DTS
13 2 (4.17%) Microsoft Analysis Services
Development Applications
1 16 (33.33%) Team Foundation Server
2 3 (6.25%) SQL Server Management Studio (SSMS)
3 2 (4.17%) JIRA
3 2 (4.17%) Zephyr
4 1 (2.08%) Cucumber
4 1 (2.08%) Jenkins
4 1 (2.08%) Selenium
4 1 (2.08%) Visual Studio
General
1 8 (16.67%) Finance
2 3 (6.25%) Banking
3 2 (4.17%) Legal
3 2 (4.17%) Marketing
4 1 (2.08%) Pharmaceutical
4 1 (2.08%) Retail
Job Titles
1 39 (81.25%) Developer
2 23 (47.92%) Business Intelligence Developer
3 11 (22.92%) Senior Developer
4 10 (20.83%) Analyst
5 7 (14.58%) Data Warehouse Developer
5 7 (14.58%) SQL Developer
6 6 (12.50%) Senior Data Warehouse Developer
7 5 (10.42%) ETL Developer
7 5 (10.42%) Microsoft BI Developer
8 4 (8.33%) Analyst Developer
8 4 (8.33%) Analyst Programmer
8 4 (8.33%) Developer Analyst
8 4 (8.33%) Junior
8 4 (8.33%) Junior Developer
8 4 (8.33%) Junior ETL Developer
8 4 (8.33%) Microsoft Developer
8 4 (8.33%) Programmer
8 4 (8.33%) SQL BI Developer
9 3 (6.25%) Senior Analyst
9 3 (6.25%) Senior Analyst Programmer
Libraries, Frameworks & Software Standards
1 25 (52.08%) .NET
2 18 (37.50%) MDX
3 16 (33.33%) REST
3 16 (33.33%) SOAP
3 16 (33.33%) Web Services
4 2 (4.17%) ODBC
5 1 (2.08%) AngularJS
5 1 (2.08%) Ionic Framework
5 1 (2.08%) Spring
Miscellaneous
1 6 (12.50%) Analytical Skills
2 4 (8.33%) NHS
3 3 (6.25%) Management Information System
4 1 (2.08%) Computer Science
Operating Systems
1 2 (4.17%) Windows
1 2 (4.17%) Windows Server
Processes & Methodologies
1 32 (66.67%) Business Intelligence
2 26 (54.17%) Data Modelling
3 17 (35.42%) Kimball Methodology
3 17 (35.42%) Unit Testing
4 16 (33.33%) Database Tuning
4 16 (33.33%) ETL Development
4 16 (33.33%) Inmon Methodology
4 16 (33.33%) Performance Tuning
5 9 (18.75%) Agile Software Development
6 6 (12.50%) CRM
7 5 (10.42%) SDLC
8 4 (8.33%) Continuous Improvement
8 4 (8.33%) Data Extraction
8 4 (8.33%) Data Migration
8 4 (8.33%) Data Protection
8 4 (8.33%) Disaster Recovery
8 4 (8.33%) Mentoring
8 4 (8.33%) Migration
8 4 (8.33%) Parallel Processing
8 4 (8.33%) Physical Data Model
Programming Languages
1 45 (93.75%) SQL
2 27 (56.25%) T-SQL
3 16 (33.33%) PowerShell
3 16 (33.33%) VBA
4 6 (12.50%) C#
4 6 (12.50%) PL/SQL
5 3 (6.25%) Shell Script
6 1 (2.08%) Java
6 1 (2.08%) VB.NET
Qualifications
1 6 (12.50%) Degree
2 2 (4.17%) ISTQB
2 2 (4.17%) ISTQB Foundation Certification
2 2 (4.17%) SC Cleared
2 2 (4.17%) Security Cleared
Quality Assurance & Compliance
1 2 (4.17%) Data Quality
1 2 (4.17%) QA
Systems Management
1 4 (8.33%) Tivoli
Vendors
1 18 (37.50%) Microsoft
2 16 (33.33%) Cognos
2 16 (33.33%) IBM
3 11 (22.92%) SAP
4 7 (14.58%) Oracle
4 7 (14.58%) Teradata
5 3 (6.25%) Orchard
6 2 (4.17%) RedGate