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

Extract, Transform and Load (ETL)
Hertfordshire > Watford
6 months to
21 May 2018
Same period 2017 Same period 2016
Rank 74 76 76
Rank change year-on-year +2 0 +17
Permanent jobs citing ETL 22 24 14
As % of all permanent IT jobs advertised in Watford 2.35% 2.29% 1.31%
As % of the Processes & Methodologies category 2.72% 2.49% 1.57%
Number of salaries quoted 21 19 10
Watford median annual salary £50,000 £60,000 £51,250
Median salary % change year-on-year -16.67% +17.07% -6.82%
10th Percentile £35,750 £39,750 £43,625
90th Percentile £60,000 £95,000 £70,000
Hertfordshire median annual salary £45,000 £54,000 £50,000
% change year-on-year -16.67% +8.00% -9.09%

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 810 962 891
As % of all permanent IT jobs advertised in Watford 86.45% 91.71% 83.19%
Number of salaries quoted 715 791 759
Watford median annual salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26% -
10th Percentile £29,750 £30,000 £30,000
90th Percentile £67,500 £75,000 £70,000
Hertfordshire median annual salary £52,500 £47,500 £47,500
% change year-on-year +10.53% - +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 21 May 2018.

Salary histogram for ETL in Watford

For the 6 months to 21 May 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 18 (81.82%) SQL
2 12 (54.55%) T-SQL
2 12 (54.55%) SQL Server
3 10 (45.45%) Data Modelling
3 10 (45.45%) Business Intelligence
3 10 (45.45%) SQL Server Integration Services
4 9 (40.91%) Migration
4 9 (40.91%) Unit Testing
4 9 (40.91%) Data Migration
5 8 (36.36%) SQL Server Analysis Services
5 8 (36.36%) Microsoft
5 8 (36.36%) Data Warehouse
6 7 (31.82%) Agile Software Development
7 6 (27.27%) Finance
7 6 (27.27%) MS Access
7 6 (27.27%) VBA
7 6 (27.27%) MDX
7 6 (27.27%) PowerShell
7 6 (27.27%) Database Tuning
7 6 (27.27%) Team Foundation Server
7 6 (27.27%) SQL Server 2012
7 6 (27.27%) Performance Tuning
7 6 (27.27%) ETL Development
7 6 (27.27%) Power BI
7 6 (27.27%) SQL Server 2016
8 5 (22.73%) Security Cleared
8 5 (22.73%) REST
8 5 (22.73%) .NET
8 5 (22.73%) SOAP
8 5 (22.73%) Web Services

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 3 (13.64%) Apache
1 3 (13.64%) Drupal
1 3 (13.64%) Tomcat
Applications
1 3 (13.64%) Microsoft Excel
Business Applications
1 4 (18.18%) Oracle Assets
1 4 (18.18%) Oracle Cash Management
1 4 (18.18%) Oracle Payables
1 4 (18.18%) Oracle Receivables
2 2 (9.09%) Orchard Housing
Communications & Networking
1 3 (13.64%) DNS
1 3 (13.64%) Firewall
Database & Business Intelligence
1 12 (54.55%) SQL Server
2 10 (45.45%) SQL Server Integration Services
3 8 (36.36%) Data Warehouse
3 8 (36.36%) SQL Server Analysis Services
4 6 (27.27%) MS Access
4 6 (27.27%) Power BI
4 6 (27.27%) SQL Server 2012
4 6 (27.27%) SQL Server 2016
5 4 (18.18%) Oracle Database
5 4 (18.18%) Oracle Database 11g
5 4 (18.18%) SAP Data Services
5 4 (18.18%) SQL Server 2014
5 4 (18.18%) SQL Server Reporting Services
6 3 (13.64%) MySQL
6 3 (13.64%) SAP BW
7 2 (9.09%) BusinessObjects
7 2 (9.09%) Microsoft Analysis Services
Development Applications
1 6 (27.27%) Team Foundation Server
2 4 (18.18%) JIRA
2 4 (18.18%) Zephyr
3 3 (13.64%) Cucumber
3 3 (13.64%) Jenkins
3 3 (13.64%) Selenium
4 2 (9.09%) SQL Server Management Studio (SSMS)
General
1 6 (27.27%) Finance
2 4 (18.18%) General Ledger
3 2 (9.09%) Legal
Job Titles
1 11 (50.00%) Developer
2 8 (36.36%) Business Intelligence Developer
3 6 (27.27%) Analyst
4 4 (18.18%) Data Analyst
4 4 (18.18%) Data Migration Analyst
4 4 (18.18%) Data Migration Specialist
4 4 (18.18%) Data Migration Tester
4 4 (18.18%) Migration Analyst
4 4 (18.18%) Migration Specialist
4 4 (18.18%) QA Analyst
4 4 (18.18%) QA Test Analyst
4 4 (18.18%) QA Tester
4 4 (18.18%) Test Analyst
4 4 (18.18%) Tester
5 3 (13.64%) Angular Developer
5 3 (13.64%) Digital Developer
5 3 (13.64%) Java Developer
6 2 (9.09%) Data Warehouse Developer
6 2 (9.09%) SQL Developer
6 2 (9.09%) SSIS Developer
Libraries, Frameworks & Software Standards
1 6 (27.27%) MDX
2 5 (22.73%) .NET
2 5 (22.73%) REST
2 5 (22.73%) SOAP
2 5 (22.73%) Web Services
3 4 (18.18%) ODBC
4 3 (13.64%) AngularJS
4 3 (13.64%) HTML
4 3 (13.64%) Ionic Framework
4 3 (13.64%) Spring
Miscellaneous
1 3 (13.64%) Analytical Skills
2 2 (9.09%) Computer Science
2 2 (9.09%) Management Information System
2 2 (9.09%) Self-Motivation
Processes & Methodologies
1 10 (45.45%) Business Intelligence
1 10 (45.45%) Data Modelling
2 9 (40.91%) Data Migration
2 9 (40.91%) Migration
2 9 (40.91%) Unit Testing
3 7 (31.82%) Agile Software Development
4 6 (27.27%) Database Tuning
4 6 (27.27%) ETL Development
4 6 (27.27%) Performance Tuning
5 5 (22.73%) Problem-Solving
6 4 (18.18%) Accounts Payable
6 4 (18.18%) Accounts Receivable
6 4 (18.18%) BDD
6 4 (18.18%) Cash Management
6 4 (18.18%) Data Deduplication
6 4 (18.18%) Inmon Methodology
6 4 (18.18%) Kimball Methodology
6 4 (18.18%) Scaled Agile Framework
6 4 (18.18%) Scenario Testing
6 4 (18.18%) Test Automation
Programming Languages
1 18 (81.82%) SQL
2 12 (54.55%) T-SQL
3 6 (27.27%) PowerShell
3 6 (27.27%) VBA
4 3 (13.64%) Java
Qualifications
1 5 (22.73%) Security Cleared
2 4 (18.18%) ISTQB
2 4 (18.18%) ISTQB Foundation Certification
2 4 (18.18%) SC Cleared
3 2 (9.09%) Degree
Quality Assurance & Compliance
1 4 (18.18%) QA
2 1 (4.55%) Data Quality
Vendors
1 8 (36.36%) Microsoft
2 4 (18.18%) Cognos
2 4 (18.18%) IBM
2 4 (18.18%) Oracle
2 4 (18.18%) SAP
3 2 (9.09%) Orchard