Period
to 15 October 2018

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 15 October 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
Hertfordshire > Watford
6 months to
15 Oct 2018
Same period 2017 Same period 2016
Rank 57 48 53
Rank change year-on-year -9 +5 +41
Permanent jobs citing ETL 43 50 40
As % of all permanent IT jobs advertised in Watford 4.55% 4.98% 4.13%
As % of the Processes & Methodologies category 5.13% 5.59% 4.63%
Number of salaries quoted 39 41 37
Watford median annual salary £65,000 £55,000 £55,000
Median salary % change year-on-year +18.18% - +22.22%
10th Percentile £52,500 £29,900 £50,000
90th Percentile £92,500 £92,500 £70,000
Hertfordshire median annual salary £55,000 £51,500 £53,000
% change year-on-year +6.80% -2.83% +11.58%

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 839 894 864
As % of all permanent IT jobs advertised in Watford 88.69% 88.96% 89.26%
Number of salaries quoted 700 715 736
Watford median annual salary £50,000 £50,000 £50,000
10th Percentile £27,500 £29,750 £27,500
90th Percentile £80,000 £71,250 £75,000
Hertfordshire median annual salary £50,000 £47,500 £47,500
% change year-on-year +5.26% - +5.56%

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 15 October 2018.

Salary histogram for ETL in Watford

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

1 38 (88.37%) Analytical Skills
1 38 (88.37%) Problem-Solving
2 36 (83.72%) Migration
2 36 (83.72%) Data Migration
3 35 (81.40%) Security Cleared
4 34 (79.07%) Data Quality
5 28 (65.12%) SC Cleared
5 28 (65.12%) SQL
6 27 (62.79%) SQL Server
7 20 (46.51%) Data Analysis
7 20 (46.51%) Master Data Management
8 19 (44.19%) Reference Data
8 19 (44.19%) PostgreSQL
8 19 (44.19%) XML
8 19 (44.19%) C#
9 16 (37.21%) T-SQL
10 15 (34.88%) Oracle
10 15 (34.88%) SQL Server Reporting Services
10 15 (34.88%) Agile Software Development
10 15 (34.88%) TDD
10 15 (34.88%) SQL Server Integration Services
10 15 (34.88%) Test Automation
10 15 (34.88%) BDD
10 15 (34.88%) Scaled Agile Framework
10 15 (34.88%) SQL Server 2016
11 14 (32.56%) Data Mapping
11 14 (32.56%) PL/SQL
12 13 (30.23%) JSON
13 12 (27.91%) VBA
14 9 (20.93%) JIRA

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:

Business Applications
1 1 (2.33%) Oracle Assets
1 1 (2.33%) Oracle Cash Management
1 1 (2.33%) Oracle Payables
1 1 (2.33%) Oracle Receivables
Communications & Networking
1 4 (9.30%) DNS
1 4 (9.30%) Firewall
Database & Business Intelligence
1 27 (62.79%) SQL Server
2 19 (44.19%) PostgreSQL
3 15 (34.88%) SQL Server 2016
3 15 (34.88%) SQL Server Integration Services
3 15 (34.88%) SQL Server Reporting Services
4 7 (16.28%) Data Warehouse
4 7 (16.28%) MS Access
4 7 (16.28%) Power BI
4 7 (16.28%) SQL Server 2012
4 7 (16.28%) SQL Server Analysis Services
5 4 (9.30%) SAP Data Services
6 1 (2.33%) Oracle Database
6 1 (2.33%) Oracle Database 11g
Development Applications
1 9 (20.93%) JIRA
2 8 (18.60%) Subversion
3 7 (16.28%) Team Foundation Server
4 1 (2.33%) Zephyr
General
1 1 (2.33%) Finance
1 1 (2.33%) General Ledger
Job Titles
1 21 (48.84%) Developer
2 20 (46.51%) ETL Developer
3 18 (41.86%) SQL Developer
4 15 (34.88%) Consultant
4 15 (34.88%) Data Consultant
4 15 (34.88%) Data Migration Consultant
4 15 (34.88%) Data Migration Lead
4 15 (34.88%) Migration Consultant
5 14 (32.56%) Data Migration Developer
5 14 (32.56%) Oracle Developer
5 14 (32.56%) Oracle ETL Developer
5 14 (32.56%) PostgreSQL Developer
5 14 (32.56%) SQL Server Developer
6 6 (13.95%) Data Warehouse Developer
7 5 (11.63%) Architect
7 5 (11.63%) Business Intelligence Developer
7 5 (11.63%) Data Architect
7 5 (11.63%) Data Migration Architect
7 5 (11.63%) Migration Architect
8 4 (9.30%) SSIS Developer
Libraries, Frameworks & Software Standards
1 19 (44.19%) XML
2 13 (30.23%) JSON
3 7 (16.28%) MDX
4 5 (11.63%) RESTful
4 5 (11.63%) XSD
5 4 (9.30%) .NET
5 4 (9.30%) REST
5 4 (9.30%) SOAP
5 4 (9.30%) Web Services
6 1 (2.33%) ODBC
Miscellaneous
1 38 (88.37%) Analytical Skills
2 19 (44.19%) Reference Data
3 4 (9.30%) Computer Science
3 4 (9.30%) Management Information System
Processes & Methodologies
1 38 (88.37%) Problem-Solving
2 36 (83.72%) Data Migration
2 36 (83.72%) Migration
3 20 (46.51%) Data Analysis
3 20 (46.51%) Master Data Management
4 15 (34.88%) Agile Software Development
4 15 (34.88%) BDD
4 15 (34.88%) Scaled Agile Framework
4 15 (34.88%) TDD
4 15 (34.88%) Test Automation
5 14 (32.56%) Data Mapping
6 8 (18.60%) Data Modelling
7 7 (16.28%) Business Intelligence
7 7 (16.28%) Database Tuning
7 7 (16.28%) ETL Development
7 7 (16.28%) Performance Tuning
7 7 (16.28%) Unit Testing
8 5 (11.63%) Data Management
8 5 (11.63%) Reference Data Management
9 4 (9.30%) Time Management
Programming Languages
1 28 (65.12%) SQL
2 19 (44.19%) C#
3 16 (37.21%) T-SQL
4 14 (32.56%) PL/SQL
5 12 (27.91%) VBA
6 7 (16.28%) PowerShell
7 5 (11.63%) C++
Qualifications
1 35 (81.40%) Security Cleared
2 28 (65.12%) SC Cleared
3 4 (9.30%) Degree
4 1 (2.33%) ISTQB
4 1 (2.33%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 34 (79.07%) Data Quality
2 1 (2.33%) QA
Vendors
1 15 (34.88%) Oracle
2 8 (18.60%) Talend
3 7 (16.28%) Microsoft
4 4 (9.30%) SAP