Period
to 20 November 2017

The following table provides summary statistics for permanent job vacancies 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)
UK
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 142 137 109
Rank change year-on-year -5 -28 +19
Permanent jobs citing ETL 4367 4540 5899
As % of all permanent IT jobs advertised in the UK 2.43% 2.43% 2.70%
As % of the Processes & Methodologies category 2.70% 2.72% 3.04%
Number of salaries quoted 3438 3767 4875
UK median annual salary £50,000 £51,000 £50,000
Median salary % change year-on-year -1.96% +2.00% -
10th Percentile £32,500 £34,250 £33,750
90th Percentile £75,000 £80,000 £78,150
UK excluding London median annual salary £45,000 £45,000 £45,000

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 with a requirement for process or methodology skills.

All Process and Methodology Skills
UK
Permanent vacancies with a requirement for process or methodology skills 161665 167144 194190
As % of all permanent IT jobs advertised in the UK 89.93% 89.36% 88.79%
Number of salaries quoted 127669 138904 159942
UK median annual salary £50,000 £49,500 £47,500
Median salary % change year-on-year +1.01% +4.21% +5.56%
10th Percentile £28,750 £28,000 £27,500
90th Percentile £80,000 £78,750 £77,500
UK excluding London median annual salary £44,000 £42,500 £42,500
% change year-on-year +3.53% - +6.25%

ETL
Job Vacancy Trend

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

Job vacancy trend for ETL in the UK

ETL
Salary Trend

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

Salary trend for ETL in the UK

ETL
Salary Histogram

The salary distribution of IT jobs citing ETL over the 6 months to 20 November 2017.

Salary histogram for ETL in the UK

ETL
Top 17 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ETL within the UK over the 6 months to 20 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -5 4048 £50,000 -4.76% 255
UK excluding London +5 2237 £45,000 - 153
London -14 2037 £55,000 -8.33% 125
North of England +10 621 £42,500 - 48
South East -35 556 £52,500 +5.00% 37
Midlands +19 329 £44,000 +3.53% 25
North West -1 305 £42,500 +6.25% 19
Yorkshire +21 292 £42,500 -3.41% 24
South West +59 259 £40,000 -5.88% 10
East of England -1 233 £47,500 -5.00% 10
West Midlands +49 220 £45,000 +10.43% 17
Scotland +2 198 £45,000 -10.00% 17
East Midlands -6 102 £40,000 -11.11% 8
Wales +8 46 £40,000 +6.67% 6
North East -1 18 £42,500 +6.25% 5
Northern Ireland -30 6 £40,000 -
Isle of Man - 3 £50,000 -

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 with a requirement for ETL.

1 3072 (70.35%) SQL
2 2430 (55.64%) Business Intelligence
3 2201 (50.40%) SQL Server
4 2128 (48.73%) Data Warehouse
5 1870 (42.82%) SQL Server Integration Services
6 1441 (33.00%) Microsoft
7 1372 (31.42%) SQL Server Reporting Services
8 1274 (29.17%) Agile Software Development
9 1237 (28.33%) T-SQL
10 1213 (27.78%) Finance
11 1017 (23.29%) SQL Server Analysis Services
12 965 (22.10%) Oracle
13 955 (21.87%) Analytics
14 911 (20.86%) Data Modelling
15 665 (15.23%) Tableau
16 662 (15.16%) Analytical Skills
17 630 (14.43%) Power BI
18 603 (13.81%) Big Data
19 580 (13.28%) Visualisation
20 550 (12.59%) Data Management
21 530 (12.14%) Java
22 528 (12.09%) Degree
23 512 (11.72%) .NET
24 493 (11.29%) Data Quality
25 492 (11.27%) C#
26 489 (11.20%) Python
26 489 (11.20%) Microsoft Azure
27 467 (10.69%) Performance Tuning
28 450 (10.30%) Relational Database
29 447 (10.24%) BusinessObjects

ETL
Co-occurring IT Skills 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 265 (6.07%) Apache Spark
2 206 (4.72%) SAS
3 125 (2.86%) SharePoint
4 114 (2.61%) Apache
5 70 (1.60%) Tomcat
6 63 (1.44%) BizTalk Server
7 56 (1.28%) IIS
8 46 (1.05%) Elasticsearch
9 44 (1.01%) Confluence
9 44 (1.01%) JBoss
10 41 (0.94%) Apache Pig
11 28 (0.64%) Oracle SOA Suite
12 24 (0.55%) Apache Airflow
13 19 (0.44%) WebSphere
14 18 (0.41%) Drupal
15 17 (0.39%) WebLogic
16 15 (0.34%) Apache Solr
17 13 (0.30%) CMS
18 11 (0.25%) SharePoint Server
18 11 (0.25%) WordPress
Applications
1 418 (9.57%) Microsoft Excel
2 105 (2.40%) Microsoft Office
3 81 (1.85%) SPSS
4 59 (1.35%) Microsoft PowerPoint
5 32 (0.73%) MS Visio
6 11 (0.25%) Microsoft Project
7 10 (0.23%) Spreadsheet
8 4 (0.092%) EngageOne
8 4 (0.092%) SPSS Modeler
9 1 (0.023%) Mathematica
9 1 (0.023%) Weka
Business Applications
1 49 (1.12%) Cognos Business Intelligence
2 48 (1.10%) Dynamics CRM
3 24 (0.55%) Dynamics AX
4 23 (0.53%) Markit EDM
5 20 (0.46%) Oracle EBS
6 16 (0.37%) Salesforce.com CRM
7 14 (0.32%) Dynamics NAV
8 13 (0.30%) BusinessWare
8 13 (0.30%) Oracle ERP
9 11 (0.25%) Cognos TM1
9 11 (0.25%) SAP ERP
10 10 (0.23%) Dynamics GP
10 10 (0.23%) SAP S/4HANA
11 8 (0.18%) Oracle Receivables
12 7 (0.16%) HFM
12 7 (0.16%) Hyperion Planning
12 7 (0.16%) SAP Hybris
13 6 (0.14%) NetSuite
14 5 (0.11%) Eagle PACE
14 5 (0.11%) FastStats
Cloud Services
1 489 (11.20%) Microsoft Azure
2 338 (7.74%) Amazon AWS
3 110 (2.52%) GitHub
4 78 (1.79%) Google Cloud Platform
5 75 (1.72%) SaaS
6 44 (1.01%) Azure Machine Learning
6 44 (1.01%) Cloud Computing
7 33 (0.76%) Azure Data Factory
7 33 (0.76%) IaaS
8 32 (0.73%) Office 365
9 31 (0.71%) Force.com
10 30 (0.69%) Amazon Kinesis
11 27 (0.62%) Amazon EMR
12 21 (0.48%) PaaS
13 20 (0.46%) Amazon S3
14 17 (0.39%) AWS CloudFormation
15 16 (0.37%) iPaaS
16 15 (0.34%) Dynamics 365
16 15 (0.34%) Google Analytics
17 14 (0.32%) Amazon CloudWatch
Communications & Networking
1 40 (0.92%) Firewall
2 30 (0.69%) HTTP
3 24 (0.55%) Intranet
4 17 (0.39%) LDAP
5 15 (0.34%) DNS
5 15 (0.34%) Internet
6 12 (0.27%) FTP
6 12 (0.27%) SSL
7 10 (0.23%) SMS
8 9 (0.21%) Kerberos
9 8 (0.18%) AMQP
9 8 (0.18%) WinSCP
10 7 (0.16%) NAS
10 7 (0.16%) SAN
11 5 (0.11%) TCP/IP
12 4 (0.092%) Network Security
13 3 (0.069%) HTTPS
13 3 (0.069%) SNMP
13 3 (0.069%) VLAN
13 3 (0.069%) VPN
Database & Business Intelligence
1 2201 (50.40%) SQL Server
2 2128 (48.73%) Data Warehouse
3 1870 (42.82%) SQL Server Integration Services
4 1372 (31.42%) SQL Server Reporting Services
5 1017 (23.29%) SQL Server Analysis Services
6 630 (14.43%) Power BI
7 603 (13.81%) Big Data
8 450 (10.30%) Relational Database
9 447 (10.24%) BusinessObjects
10 439 (10.05%) QlikView
11 425 (9.73%) Hadoop
12 384 (8.79%) SQL Server 2012
13 349 (7.99%) OLAP
14 336 (7.69%) SQL Server 2008
15 280 (6.41%) NoSQL
16 239 (5.47%) MySQL
17 216 (4.95%) SQL Server 2014
18 199 (4.56%) Oracle Database
19 195 (4.47%) RDBMS
20 189 (4.33%) SQL Server 2016
Development Applications
1 258 (5.91%) Visual Studio
2 240 (5.50%) Team Foundation Server
3 219 (5.01%) JIRA
4 215 (4.92%) Talend Open Studio
5 144 (3.30%) SQL Server Management Studio (SSMS)
6 110 (2.52%) TeamCity
7 99 (2.27%) Git (software)
8 80 (1.83%) Jenkins
9 75 (1.72%) Subversion
10 69 (1.58%) Selenium
11 51 (1.17%) Oracle Forms
12 34 (0.78%) Toad
13 28 (0.64%) ERwin
14 27 (0.62%) HP UFT
15 26 (0.60%) Octopus Deploy
16 24 (0.55%) RStudio
17 21 (0.48%) Maven
18 20 (0.46%) Bitbucket
19 19 (0.44%) Oracle APEX
20 18 (0.41%) Rational Functional Tester
General
1 1213 (27.78%) Finance
2 325 (7.44%) Banking
3 304 (6.96%) Retail
4 227 (5.20%) Marketing
5 165 (3.78%) Legal
6 158 (3.62%) Investment Banking
7 152 (3.48%) Advertising
8 143 (3.27%) Retail Banking
9 102 (2.34%) Manufacturing
10 100 (2.29%) Telecoms
11 71 (1.63%) Games
12 67 (1.53%) Electronics
13 61 (1.40%) Publishing
14 58 (1.33%) Front Office
15 48 (1.10%) Law
16 44 (1.01%) Back Office
17 37 (0.85%) Pharmaceutical
18 24 (0.55%) Private Banking
19 23 (0.53%) Corporate Banking
20 21 (0.48%) Financial Institution
Job Titles
1 2110 (48.32%) Developer
2 819 (18.75%) Business Intelligence Developer
3 723 (16.56%) SQL Developer
4 606 (13.88%) Analyst
5 350 (8.01%) Consultant
6 340 (7.79%) Architect
7 329 (7.53%) SSIS Developer
8 302 (6.92%) ETL Developer
9 274 (6.27%) Senior Developer
10 271 (6.21%) SQL BI Developer
11 240 (5.50%) Data Warehouse Developer
12 232 (5.31%) Business Developer
13 229 (5.24%) DBA
14 221 (5.06%) SQL Server Developer
15 203 (4.65%) SSRS Developer
16 195 (4.47%) Data Engineer
17 187 (4.28%) Data Architect
18 183 (4.19%) Data Analyst
19 173 (3.96%) SQL DBA
20 148 (3.39%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 512 (11.72%) .NET
2 285 (6.53%) Web Services
3 234 (5.36%) XML
4 220 (5.04%) MDX
5 204 (4.67%) ASP.NET
6 199 (4.56%) HTML
7 104 (2.38%) SOAP
8 102 (2.34%) REST
9 98 (2.24%) CSS
10 95 (2.18%) JSON
11 76 (1.74%) .NET Framework
12 74 (1.69%) AngularJS
13 71 (1.63%) Spring
14 62 (1.42%) Kafka
15 60 (1.37%) HTML5
16 59 (1.35%) Oracle GoldenGate
17 54 (1.24%) ASP.NET MVC
18 47 (1.08%) jQuery
19 45 (1.03%) Middleware
20 44 (1.01%) Pandas
Miscellaneous
1 662 (15.16%) Analytical Skills
2 252 (5.77%) Computer Science
3 209 (4.79%) Management Information System
4 179 (4.10%) Data Structures
5 96 (2.20%) Clustering
6 85 (1.95%) Replication
7 82 (1.88%) Enterprise Software
8 77 (1.76%) Greenfield Project
9 72 (1.65%) Virtual Team
10 48 (1.10%) Life Science
11 47 (1.08%) User Experience
12 44 (1.01%) Fintech
13 41 (0.94%) Client/Server
14 38 (0.87%) Credit Risk
15 36 (0.82%) Algorithms
16 29 (0.66%) N-Tier
17 25 (0.57%) NHS
18 21 (0.48%) Reference Data
19 20 (0.46%) iPad
20 17 (0.39%) Hybrid Cloud
Operating Systems
1 284 (6.50%) Linux
2 193 (4.42%) Windows
3 183 (4.19%) Unix
4 47 (1.08%) Windows Server
5 35 (0.80%) Windows Server 2012
6 20 (0.46%) AIX
7 17 (0.39%) Solaris
7 17 (0.39%) Windows 7
8 15 (0.34%) Windows Server 2008
9 10 (0.23%) Android
10 9 (0.21%) Apple iOS
11 7 (0.16%) Red Hat Enterprise Linux
12 6 (0.14%) Ubuntu
13 3 (0.069%) Windows 10
13 3 (0.069%) Windows 8
13 3 (0.069%) Windows Server 2003
14 2 (0.046%) Mesosphere
14 2 (0.046%) Oracle Linux
15 1 (0.023%) CentOS
15 1 (0.023%) Embedded Linux
Processes & Methodologies
1 2430 (55.64%) Business Intelligence
2 1274 (29.17%) Agile Software Development
3 955 (21.87%) Analytics
4 911 (20.86%) Data Modelling
5 580 (13.28%) Visualisation
6 550 (12.59%) Data Management
7 467 (10.69%) Performance Tuning
8 417 (9.55%) Data Integration
9 406 (9.30%) Data Analysis
10 394 (9.02%) SDLC
11 390 (8.93%) Migration
12 364 (8.34%) Kimball Methodology
13 354 (8.11%) Scrum
14 334 (7.65%) ETL Development
15 332 (7.60%) Data Visualisation
16 265 (6.07%) Stakeholder Management
17 253 (5.79%) Data Analytics
18 251 (5.75%) Mentoring
19 245 (5.61%) Data Migration
20 243 (5.56%) Data Architecture
Programming Languages
1 3072 (70.35%) SQL
2 1237 (28.33%) T-SQL
3 530 (12.14%) Java
4 492 (11.27%) C#
5 489 (11.20%) Python
6 336 (7.69%) PL/SQL
7 243 (5.56%) JavaScript
8 194 (4.44%) PowerShell
9 187 (4.28%) R
10 142 (3.25%) Scala
11 121 (2.77%) VBA
12 107 (2.45%) Shell Script
13 75 (1.72%) PHP
14 72 (1.65%) Data Analysis Expressions (DAX)
15 55 (1.26%) VB
16 54 (1.24%) Bash Shell
17 45 (1.03%) VB.NET
18 35 (0.80%) C
19 32 (0.73%) Apex Code
20 31 (0.71%) Perl
Qualifications
1 528 (12.09%) Degree
2 140 (3.21%) Computer Science Degree
3 118 (2.70%) Microsoft Certification
4 67 (1.53%) Security Cleared
5 47 (1.08%) MCSA
6 44 (1.01%) MCSE
7 38 (0.87%) SC Cleared
8 34 (0.78%) ISTQB
9 32 (0.73%) ISEB
9 32 (0.73%) Master's Degree
10 20 (0.46%) Numerate Degree
11 13 (0.30%) MBA
12 12 (0.27%) MCP
12 12 (0.27%) PMI Certification
13 10 (0.23%) MCDBA
13 10 (0.23%) MCITP
14 8 (0.18%) ITIL Foundation Certificate
14 8 (0.18%) Oracle Certification
15 7 (0.16%) PhD
16 5 (0.11%) CISSP
Quality Assurance & Compliance
1 493 (11.29%) Data Quality
2 245 (5.61%) QA
3 63 (1.44%) SLA
4 33 (0.76%) GDPR
5 20 (0.46%) GCP
6 17 (0.39%) ISO/IEC 27001
7 12 (0.27%) MiFID
8 11 (0.25%) PMO
9 9 (0.21%) CRD IV
9 9 (0.21%) EMIR
10 6 (0.14%) Actionable Recommendations
10 6 (0.14%) PCI DSS
11 5 (0.11%) GPG13
11 5 (0.11%) ISO 9001
12 4 (0.092%) Solvency II
13 3 (0.069%) COBIT
13 3 (0.069%) FATCA
13 3 (0.069%) HL7
13 3 (0.069%) IFRS
13 3 (0.069%) IFRS 9
System Software
1 58 (1.33%) HDFS
2 49 (1.12%) Active Directory
3 34 (0.78%) Docker
4 29 (0.66%) Apache Flume
5 25 (0.57%) VMware Infrastructure
6 7 (0.16%) Virtual Servers
7 5 (0.11%) Firmware
7 5 (0.11%) Snort
8 4 (0.092%) Apache ZooKeeper
8 4 (0.092%) Microsoft Virtual Server
9 3 (0.069%) Hyper-V
9 3 (0.069%) Terminal Services
10 2 (0.046%) MapR-FS
10 2 (0.046%) Oracle RAC
10 2 (0.046%) Virtual Machines
11 1 (0.023%) Cronacle
11 1 (0.023%) KVM
Systems Management
1 39 (0.89%) Oozie
2 24 (0.55%) Oracle Enterprise Manager
3 23 (0.53%) SCCM
4 22 (0.50%) HP Quality Center
4 22 (0.50%) Opscode Chef
5 21 (0.48%) Puppet
6 18 (0.41%) Ambari
7 12 (0.27%) Systems Management Server (SMS)
7 12 (0.27%) ZABBIX
8 10 (0.23%) Control-M
9 9 (0.21%) Ansible
9 9 (0.21%) Failover Clustering
9 9 (0.21%) Microsoft Clustering
9 9 (0.21%) SCOM
10 7 (0.16%) Hadoop YARN
11 6 (0.14%) CA Single Sign-On
11 6 (0.14%) Marathon
11 6 (0.14%) Terraform
11 6 (0.14%) Tivoli
12 5 (0.11%) Nagios
Vendors
1 1441 (33.00%) Microsoft
2 965 (22.10%) Oracle
3 665 (15.23%) Tableau
4 420 (9.62%) SAP
5 388 (8.88%) Informatica
6 297 (6.80%) Cognos
7 215 (4.92%) Talend
8 184 (4.21%) IBM
8 184 (4.21%) MicroStrategy
9 137 (3.14%) Teradata
10 106 (2.43%) Google
11 103 (2.36%) Salesforce.com
12 96 (2.20%) Alteryx
13 79 (1.81%) Netezza
14 76 (1.74%) Cloudera
15 67 (1.53%) Ab Initio
16 47 (1.08%) Hortonworks
17 46 (1.05%) Sybase
18 42 (0.96%) RedGate
19 41 (0.94%) Hyperion