Period
to 20 November 2017

The following table provides summary statistics for permanent job vacancies advertised in St Albans 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 November 2017 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
Hertfordshire > St Albans
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 60 57 68
Rank change year-on-year -3 +11 -12
Permanent jobs citing ETL 6 12 9
As % of all permanent IT jobs advertised in St Albans 1.78% 2.99% 3.02%
As % of the Processes & Methodologies category 2.14% 3.39% 3.37%
Number of salaries quoted 1 1 9
St Albans median annual salary £39,000 £53,000 £55,000
Median salary % change year-on-year -26.42% -3.64% +15.79%
10th Percentile £38,000 £51,500 £45,200
90th Percentile £40,000 £54,500 £58,400
Hertfordshire median annual salary £51,500 £55,000 £47,500
% change year-on-year -6.36% +15.79% -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 St Albans with a requirement for process or methodology skills.

All Process and Methodology Skills
St Albans
Permanent vacancies with a requirement for process or methodology skills 280 354 267
As % of all permanent IT jobs advertised in St Albans 83.09% 88.28% 89.60%
Number of salaries quoted 248 331 256
St Albans median annual salary £52,500 £50,000 £46,750
Median salary % change year-on-year +5.00% +6.95% -1.58%
10th Percentile £28,500 £32,500 £25,000
90th Percentile £72,500 £72,500 £72,500
Hertfordshire median annual salary £47,500 £50,000 £47,500
% change year-on-year -5.00% +5.26% +0.53%

ETL
Job Vacancy Trend in St Albans

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

Job vacancy trend for ETL in St Albans

ETL
Salary Trend in St Albans

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

Salary trend for ETL in St Albans

For the 6 months to 20 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 St Albans region with a requirement for ETL.

1 6 (100.00%) SQL
1 6 (100.00%) .NET
1 6 (100.00%) SQL Server
2 5 (83.33%) T-SQL
2 5 (83.33%) C#
2 5 (83.33%) Java
2 5 (83.33%) SAP
2 5 (83.33%) Python
2 5 (83.33%) SAS
2 5 (83.33%) Business Intelligence
2 5 (83.33%) BusinessObjects
2 5 (83.33%) SPSS
2 5 (83.33%) Project Management
2 5 (83.33%) VB.NET
2 5 (83.33%) Finance
2 5 (83.33%) Stakeholder Management
2 5 (83.33%) Programme Management
2 5 (83.33%) SQL Server Reporting Services
2 5 (83.33%) SQL Server Integration Services
2 5 (83.33%) Degree
2 5 (83.33%) Resource Management
2 5 (83.33%) Data Analytics
2 5 (83.33%) Analytics
2 5 (83.33%) Analytical Skills
2 5 (83.33%) Anti-Money Laundering
3 4 (66.67%) Data Visualisation
3 4 (66.67%) Tableau
3 4 (66.67%) Big Data
3 4 (66.67%) QlikView
3 4 (66.67%) Hadoop

ETL
Co-occurring IT Skills in St Albans 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 5 (83.33%) SAS
2 1 (16.67%) Apache
2 1 (16.67%) Drupal
2 1 (16.67%) IIS
Applications
1 5 (83.33%) SPSS
2 1 (16.67%) Microsoft Office
Business Applications
1 1 (16.67%) Dynamics GP
Cloud Services
1 1 (16.67%) Amazon AWS
1 1 (16.67%) Microsoft Azure
1 1 (16.67%) Office 365
Communications & Networking
1 1 (16.67%) DNS
1 1 (16.67%) Intranet
Database & Business Intelligence
1 6 (100.00%) SQL Server
2 5 (83.33%) BusinessObjects
2 5 (83.33%) SQL Server Integration Services
2 5 (83.33%) SQL Server Reporting Services
3 4 (66.67%) Big Data
3 4 (66.67%) GIS
3 4 (66.67%) Hadoop
3 4 (66.67%) QlikView
4 1 (16.67%) MySQL
4 1 (16.67%) Power BI
General
1 5 (83.33%) Finance
Job Titles
1 5 (83.33%) Technical Manager
2 4 (66.67%) Analytics Manager
2 4 (66.67%) Data Analytics Manager
2 4 (66.67%) Data Manager
2 4 (66.67%) Fraud Manager
2 4 (66.67%) Senior Analytics Manager
2 4 (66.67%) Senior Manager
2 4 (66.67%) Senior Technical Manager
2 4 (66.67%) Software Manager
3 1 (16.67%) Developer
3 1 (16.67%) Forensic Manager
3 1 (16.67%) Programme Manager
3 1 (16.67%) Project Manager
3 1 (16.67%) Senior Developer
3 1 (16.67%) Senior Systems Developer
3 1 (16.67%) Systems Developer
3 1 (16.67%) Technical Project Manager
Libraries, Frameworks & Software Standards
1 6 (100.00%) .NET
2 1 (16.67%) ASP.NET
2 1 (16.67%) Web Services
Miscellaneous
1 5 (83.33%) Analytical Skills
Operating Systems
1 1 (16.67%) Windows
1 1 (16.67%) Windows Server
1 1 (16.67%) Windows Server 2008
1 1 (16.67%) Windows Server 2012
Processes & Methodologies
1 5 (83.33%) Analytics
1 5 (83.33%) Anti-Money Laundering
1 5 (83.33%) Business Intelligence
1 5 (83.33%) Data Analytics
1 5 (83.33%) Programme Management
1 5 (83.33%) Project Management
1 5 (83.33%) Resource Management
1 5 (83.33%) Stakeholder Management
2 4 (66.67%) Data Visualisation
2 4 (66.67%) Visualisation
3 1 (16.67%) Agile Software Development
3 1 (16.67%) ERP
3 1 (16.67%) Forensic Analysis
3 1 (16.67%) ITIL
3 1 (16.67%) Migration
3 1 (16.67%) PRINCE2
3 1 (16.67%) Reverse Engineering
3 1 (16.67%) Waterfall
Programming Languages
1 6 (100.00%) SQL
2 5 (83.33%) C#
2 5 (83.33%) Java
2 5 (83.33%) Python
2 5 (83.33%) T-SQL
2 5 (83.33%) VB.NET
3 1 (16.67%) PHP
3 1 (16.67%) VB
Qualifications
1 5 (83.33%) Degree
System Software
1 1 (16.67%) Active Directory
Vendors
1 5 (83.33%) SAP
2 4 (66.67%) Tableau
3 1 (16.67%) Concur
3 1 (16.67%) Microsoft