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

3 months to
18 Jan 2017
Same period 2016 Same period 2015
Extract, Transform and Load (ETL)
East of England / Hertfordshire
Rank 95 97 106
Rank change year-on-year
+2 +9
Permanent jobs citing ETL 39 47 36
As % of all permanent IT jobs located in Hertfordshire 1.93% 2.27% 1.76%
As % of the Processes & Methodologies category 2.21% 2.70% 2.09%
Number of salaries quoted 18 41 24
Median salary £45,000 £50,000 £52,500
Median salary % change year-on-year
-10.00% -4.76%
90% offered a salary of more than £35,250 £42,500 £47,500
10% offered a salary of more than £60,750 £60,000 £57,500
UK excluding London median salary £45,000 £44,614 £45,000
% change year-on-year
+0.86% -0.85%

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
1761 1740 1721
As % of all permanent IT jobs located in Hertfordshire 87.18% 84.02% 84.03%
Number of salaries quoted 1449 1471 1348
Median salary £50,000 £53,000 £50,000
Median salary % change year-on-year
-5.66% +6.00%
90% offered a salary of more than £30,000 £32,500 £32,700
10% offered a salary of more than £70,000 £72,500 £70,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

ETL
Jobs Demand Trend in Hertfordshire

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

ETL Jobs Demand Trend in Hertfordshire

ETL
Salary Trend in Hertfordshire

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

ETL Salary Trend in Hertfordshire

ETL
Salary Histogram in Hertfordshire

This chart provides a salary histogram for IT jobs citing ETL across the Hertfordshire region over the 3 months to 18 January 2017.

ETL Salary Histogram in Hertfordshire

ETL
Job Locations in Hertfordshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the Hertfordshire region over the 3 months to 18 January 2017. 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 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 8 £50,000 -
St Albans -6 7 - -
Tring - 3 £42,500 -
Stevenage -10 2 £30,000 -53.84%
Borehamwood - 2 £45,000 -
Hemel Hempstead +7 1 £75,000 +66.66%
ETL
East of England

ETL
Top 30 Related IT Skills in Hertfordshire

For the 6 months to 18 January 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 Hertfordshire region with a requirement for ETL.

1 66 (84.62%) SQL
2 61 (78.21%) SQL Server
3 51 (65.38%) Business Intelligence
4 46 (58.97%) SQL Server Integration Services
5 41 (52.56%) T-SQL
6 38 (48.72%) Java
7 34 (43.59%) SQL Server Reporting Services
8 33 (42.31%) Degree
8 33 (42.31%) .NET
8 33 (42.31%) Analytical Skills
9 28 (35.90%) SAP
9 28 (35.90%) Data Warehouse
10 27 (34.62%) Oracle
11 25 (32.05%) SQL Server Analysis Services
12 24 (30.77%) Analytics
13 22 (28.21%) BusinessObjects
13 22 (28.21%) Finance
14 19 (24.36%) IBM
14 19 (24.36%) Microsoft
14 19 (24.36%) SOAP
14 19 (24.36%) Web Services
14 19 (24.36%) C#
14 19 (24.36%) REST
15 18 (23.08%) Tableau
15 18 (23.08%) GIS
16 17 (21.79%) MDX
16 17 (21.79%) Stakeholder Management
16 17 (21.79%) Project Management
16 17 (21.79%) SQL Server 2012
16 17 (21.79%) Computer Science

ETL
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:

Application Platforms
1 16 (20.51%) SAS
2 9 (11.54%) Tomcat
3 6 (7.69%) Adobe Experience Manager
3 6 (7.69%) Apache
3 6 (7.69%) CMS
3 6 (7.69%) MQSeries
3 6 (7.69%) WebSphere
4 4 (5.13%) SharePoint
5 2 (2.56%) Oracle SOA Suite
6 1 (1.28%) Drupal
6 1 (1.28%) SharePoint 2010
Applications
1 16 (20.51%) SPSS
2 6 (7.69%) MS Excel
Business Applications
1 11 (14.10%) SAP BPC
2 6 (7.69%) Magento
3 2 (2.56%) Maximo
4 1 (1.28%) Dynamics CRM
Cloud Services
1 6 (7.69%) SaaS
2 2 (2.56%) Amazon AWS
2 2 (2.56%) IaaS
2 2 (2.56%) PaaS
Communications & Networking
1 11 (14.10%) DNS
1 11 (14.10%) Firewall
2 6 (7.69%) Internet
3 2 (2.56%) FTP
4 1 (1.28%) PPP
Database & Business Intelligence
1 61 (78.21%) SQL Server
2 46 (58.97%) SQL Server Integration Services
3 34 (43.59%) SQL Server Reporting Services
4 28 (35.90%) Data Warehouse
5 25 (32.05%) SQL Server Analysis Services
6 22 (28.21%) BusinessObjects
7 18 (23.08%) GIS
8 17 (21.79%) Power BI
8 17 (21.79%) SQL Server 2012
9 16 (20.51%) Big Data
9 16 (20.51%) Hadoop
10 12 (15.38%) Oracle Database
10 12 (15.38%) Oracle Database 10g
10 12 (15.38%) SQL Server 2008
11 11 (14.10%) MS Access
11 11 (14.10%) SAP BW
11 11 (14.10%) SAP Data Services
12 8 (10.26%) OLAP
13 6 (7.69%) MySQL
13 6 (7.69%) QlikView
Development Applications
1 12 (15.38%) Oracle Forms
2 11 (14.10%) Team Foundation Server
3 10 (12.82%) Talend Open Studio
4 6 (7.69%) Eclipse
4 6 (7.69%) Git (software)
4 6 (7.69%) JUnit
4 6 (7.69%) Log4j
4 6 (7.69%) Maven
4 6 (7.69%) Mockito
4 6 (7.69%) Subversion
5 4 (5.13%) SQL Server Management Studio (SSMS)
6 1 (1.28%) Visual Studio
General
1 22 (28.21%) Finance
2 4 (5.13%) Advertising
2 4 (5.13%) Billing
3 2 (2.56%) Manufacturing
3 2 (2.56%) Pharmaceutical
3 2 (2.56%) Retail
4 1 (1.28%) Automotive
4 1 (1.28%) Banking
Job Titles
1 51 (65.38%) Developer
2 18 (23.08%) Business Intelligence Developer
3 16 (20.51%) Analytics Manager
3 16 (20.51%) Data Analytics Manager
3 16 (20.51%) Data Manager
3 16 (20.51%) Fraud Manager
3 16 (20.51%) Senior Analytics Manager
3 16 (20.51%) Senior Manager
3 16 (20.51%) Senior Technical Manager
3 16 (20.51%) Technical Manager
4 12 (15.38%) Microsoft Developer
4 12 (15.38%) Oracle Developer
5 11 (14.10%) Microsoft BI Developer
5 11 (14.10%) SQL Developer
6 9 (11.54%) Java Developer
7 8 (10.26%) Analyst
8 7 (8.97%) Software Manager
9 6 (7.69%) Agile Developer
9 6 (7.69%) Business Intelligence Analyst
9 6 (7.69%) Unix Developer
Libraries, Frameworks & Software Standards
1 33 (42.31%) .NET
2 19 (24.36%) REST
2 19 (24.36%) SOAP
2 19 (24.36%) Web Services
3 17 (21.79%) MDX
4 12 (15.38%) Oracle ADF
5 10 (12.82%) XML
6 9 (11.54%) Spring
7 6 (7.69%) ActiveMQ
7 6 (7.69%) Apache Camel
7 6 (7.69%) EJB
7 6 (7.69%) J2EE
7 6 (7.69%) JDBC
7 6 (7.69%) JMS
7 6 (7.69%) JSON
7 6 (7.69%) JSP
7 6 (7.69%) Spring Boot
7 6 (7.69%) Spring Security
7 6 (7.69%) XSD
7 6 (7.69%) XSLT
Miscellaneous
1 33 (42.31%) Analytical Skills
2 17 (21.79%) Computer Science
3 16 (20.51%) Management Information System
3 16 (20.51%) Visualisation
4 4 (5.13%) Mathematics
4 4 (5.13%) Physics
5 3 (3.85%) Data Integration
6 2 (2.56%) Life Science
6 2 (2.56%) Performance Metrics
7 1 (1.28%) Clustering
7 1 (1.28%) Data Structures
7 1 (1.28%) Fintech
Operating Systems
1 6 (7.69%) HPUX
1 6 (7.69%) Linux
1 6 (7.69%) Solaris
1 6 (7.69%) Unix
Processes & Methodologies
1 51 (65.38%) Business Intelligence
2 24 (30.77%) Analytics
3 17 (21.79%) Project Management
3 17 (21.79%) Stakeholder Management
4 16 (20.51%) Anti-Money Laundering
4 16 (20.51%) Data Analytics
4 16 (20.51%) Data Visualisation
4 16 (20.51%) Programme Management
4 16 (20.51%) Resource Management
5 15 (19.23%) Data Modelling
6 13 (16.67%) ETL Development
7 12 (15.38%) Time Management
8 11 (14.10%) Agile Software Development
8 11 (14.10%) Database Tuning
8 11 (14.10%) Performance Tuning
8 11 (14.10%) Unit Testing
9 9 (11.54%) TDD
10 8 (10.26%) E-Commerce
11 7 (8.97%) SDLC
12 6 (7.69%) Dependency Management
Programming Languages
1 66 (84.62%) SQL
2 41 (52.56%) T-SQL
3 38 (48.72%) Java
4 19 (24.36%) C#
5 16 (20.51%) Python
5 16 (20.51%) VB.NET
6 12 (15.38%) PL/SQL
7 11 (14.10%) PowerShell
7 11 (14.10%) VBA
8 4 (5.13%) R
9 3 (3.85%) JavaScript
10 2 (2.56%) VBScript
Qualifications
1 33 (42.31%) Degree
Quality Assurance & Compliance
1 1 (1.28%) Data Quality
Vendors
1 28 (35.90%) SAP
2 27 (34.62%) Oracle
3 19 (24.36%) IBM
3 19 (24.36%) Microsoft
4 18 (23.08%) Tableau
5 11 (14.10%) Cognos
6 10 (12.82%) Talend
7 6 (7.69%) ATG
7 6 (7.69%) Blue Martini
8 3 (3.85%) hybris
9 2 (2.56%) Citrix
9 2 (2.56%) ESRI
9 2 (2.56%) VMware