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

Extract, Transform and Load (ETL)
Hertfordshire > Watford
6 months to
20 Feb 2018
Same period 2017 Same period 2016
Rank 49 76 81
Rank change year-on-year +27 +5 +21
Permanent jobs citing ETL 43 21 10
As % of all permanent IT jobs advertised in Watford 4.32% 1.93% 0.95%
As % of the Processes & Methodologies category 5.04% 2.13% 1.15%
Number of salaries quoted 41 14 9
Watford median annual salary £52,500 £55,000 £46,000
Median salary % change year-on-year -4.55% +19.57% -8.00%
10th Percentile £29,900 £45,750 £35,000
90th Percentile £57,500 £62,500 £50,400
Hertfordshire median annual salary £50,000 £55,000 £47,500
% change year-on-year -9.09% +15.79% -17.39%

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 854 985 873
As % of all permanent IT jobs advertised in Watford 85.74% 90.70% 82.51%
Number of salaries quoted 767 814 746
Watford median annual salary £50,000 £54,000 £46,000
Median salary % change year-on-year -7.41% +17.39% +2.22%
10th Percentile £30,000 £28,000 £28,000
90th Percentile £67,500 £75,000 £70,000
Hertfordshire median annual salary £50,000 £50,000 £45,525
% change year-on-year - +9.83% -4.16%

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 20 February 2018.

Salary histogram for ETL in Watford

For the 6 months to 20 February 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 42 (97.67%) SQL
2 34 (79.07%) SQL Server
3 33 (76.74%) Business Intelligence
3 33 (76.74%) SQL Server Integration Services
4 27 (62.79%) Data Warehouse
5 26 (60.47%) T-SQL
6 25 (58.14%) SQL Server Analysis Services
7 23 (53.49%) Data Modelling
8 22 (51.16%) Microsoft
9 21 (48.84%) SQL Server 2012
10 20 (46.51%) .NET
11 19 (44.19%) Unit Testing
12 18 (41.86%) PowerShell
12 18 (41.86%) Database Tuning
12 18 (41.86%) Team Foundation Server
12 18 (41.86%) Kimball Methodology
12 18 (41.86%) Inmon Methodology
12 18 (41.86%) REST
12 18 (41.86%) Performance Tuning
12 18 (41.86%) ETL Development
12 18 (41.86%) Power BI
12 18 (41.86%) SQL Server 2014
12 18 (41.86%) SQL Server 2016
12 18 (41.86%) VBA
12 18 (41.86%) SOAP
12 18 (41.86%) Web Services
12 18 (41.86%) MS Access
12 18 (41.86%) Cognos
12 18 (41.86%) IBM
12 18 (41.86%) MDX

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.33%) Apache
1 1 (2.33%) Drupal
1 1 (2.33%) Tomcat
Applications
1 7 (16.28%) Microsoft Excel
Business Applications
1 4 (9.30%) Oracle Assets
1 4 (9.30%) Oracle Cash Management
1 4 (9.30%) Oracle Payables
1 4 (9.30%) Oracle Receivables
1 4 (9.30%) Orchard Housing
Communications & Networking
1 15 (34.88%) DNS
1 15 (34.88%) Firewall
Database & Business Intelligence
1 34 (79.07%) SQL Server
2 33 (76.74%) SQL Server Integration Services
3 27 (62.79%) Data Warehouse
4 25 (58.14%) SQL Server Analysis Services
5 21 (48.84%) SQL Server 2012
6 18 (41.86%) MS Access
6 18 (41.86%) Power BI
6 18 (41.86%) SQL Server 2014
6 18 (41.86%) SQL Server 2016
7 15 (34.88%) SAP Data Services
8 10 (23.26%) SAP BW
9 7 (16.28%) SQL Server Reporting Services
10 4 (9.30%) BusinessObjects
10 4 (9.30%) Microsoft Analysis Services
10 4 (9.30%) Oracle Database
10 4 (9.30%) Oracle Database 11g
11 1 (2.33%) MySQL
Development Applications
1 18 (41.86%) Team Foundation Server
2 5 (11.63%) JIRA
2 5 (11.63%) Zephyr
3 4 (9.30%) SQL Server Management Studio (SSMS)
4 1 (2.33%) Cucumber
4 1 (2.33%) Jenkins
4 1 (2.33%) Selenium
General
1 9 (20.93%) Finance
2 4 (9.30%) General Ledger
2 4 (9.30%) Legal
Job Titles
1 29 (67.44%) Developer
2 25 (58.14%) Business Intelligence Developer
3 9 (20.93%) Analyst
4 7 (16.28%) Microsoft BI Developer
5 6 (13.95%) ETL Developer
6 5 (11.63%) Data Analyst
6 5 (11.63%) Data Migration Analyst
6 5 (11.63%) Data Migration Tester
6 5 (11.63%) Microsoft Developer
6 5 (11.63%) Migration Analyst
6 5 (11.63%) QA Analyst
6 5 (11.63%) QA Test Analyst
6 5 (11.63%) QA Tester
6 5 (11.63%) SQL BI Developer
6 5 (11.63%) SQL Developer
6 5 (11.63%) Test Analyst
6 5 (11.63%) Tester
7 4 (9.30%) Business Improvement Analyst
7 4 (9.30%) Junior ETL Developer
7 4 (9.30%) Migration Specialist
Libraries, Frameworks & Software Standards
1 20 (46.51%) .NET
2 18 (41.86%) MDX
2 18 (41.86%) REST
2 18 (41.86%) SOAP
2 18 (41.86%) Web Services
3 5 (11.63%) ODBC
4 1 (2.33%) AngularJS
4 1 (2.33%) Ionic Framework
4 1 (2.33%) Spring
Miscellaneous
1 4 (9.30%) NHS
2 3 (6.98%) Management Information System
3 2 (4.65%) Analytical Skills
3 2 (4.65%) Computer Science
Processes & Methodologies
1 33 (76.74%) Business Intelligence
2 23 (53.49%) Data Modelling
3 19 (44.19%) Unit Testing
4 18 (41.86%) Database Tuning
4 18 (41.86%) ETL Development
4 18 (41.86%) Inmon Methodology
4 18 (41.86%) Kimball Methodology
4 18 (41.86%) Performance Tuning
5 9 (20.93%) Data Migration
5 9 (20.93%) Migration
6 6 (13.95%) Data Protection
7 5 (11.63%) Agile Software Development
7 5 (11.63%) BDD
7 5 (11.63%) Scaled Agile Framework
7 5 (11.63%) Scenario Testing
7 5 (11.63%) TDD
7 5 (11.63%) Test Automation
7 5 (11.63%) Test Scripting
8 4 (9.30%) ITSM
8 4 (9.30%) Project Planning
Programming Languages
1 42 (97.67%) SQL
2 26 (60.47%) T-SQL
3 18 (41.86%) PowerShell
3 18 (41.86%) VBA
4 1 (2.33%) Java
Qualifications
1 6 (13.95%) Degree
2 5 (11.63%) ISTQB
2 5 (11.63%) ISTQB Foundation Certification
2 5 (11.63%) SC Cleared
2 5 (11.63%) Security Cleared
Quality Assurance & Compliance
1 5 (11.63%) QA
Vendors
1 22 (51.16%) Microsoft
2 18 (41.86%) Cognos
2 18 (41.86%) IBM
3 12 (27.91%) SAP
4 4 (9.30%) Oracle
4 4 (9.30%) Orchard