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

Extract, Transform and Load (ETL)
UK
6 months to
21 Oct 2017
Same period 2016 Same period 2015
Rank 148 134 115
Rank change year-on-year -14 -19 +16
Permanent jobs citing ETL 4228 4773 5738
As % of all permanent IT jobs advertised in the UK 2.43% 2.50% 2.62%
As % of the Processes & Methodologies category 2.70% 2.80% 2.96%
Number of salaries quoted 3297 3933 4733
UK median annual salary £50,000 £50,000 £52,500
Median salary % change year-on-year - -4.76% +5.00%
10th Percentile £32,500 £34,800 £33,750
90th Percentile £76,250 £78,750 £80,000
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 156565 170492 194103
As % of all permanent IT jobs advertised in the UK 89.94% 89.23% 88.60%
Number of salaries quoted 123230 141844 159582
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 £76,250
UK excluding London median annual salary £43,500 £42,500 £42,500
% change year-on-year +2.35% - +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 21 October 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 21 October 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 -11 3916 £50,000 -3.85% 197
UK excluding London -2 2123 £45,000 - 114
London -19 2021 £56,000 -6.67% 91
North of England +12 592 £42,500 - 33
South East -41 512 £52,500 +5.00% 30
Midlands +7 314 £42,500 -3.41% 23
North West +2 311 £42,250 +5.63% 14
Yorkshire +20 264 £45,000 - 19
South West +29 230 £40,000 -2.44% 9
East of England +9 230 £45,000 -10.00% 11
West Midlands +16 198 £42,500 - 18
Scotland +3 194 £45,000 -10.00% 5
East Midlands +4 106 £42,500 -5.56% 5
Wales +24 51 £40,000 +11.11% 3
North East +8 11 £45,000 +10.43%
Northern Ireland -24 11 £37,500 -6.25%
Isle of Man - 3 £50,000 -

For the 6 months to 21 October 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 3029 (71.64%) SQL
2 2308 (54.59%) Business Intelligence
3 2144 (50.71%) SQL Server
4 2047 (48.42%) Data Warehouse
5 1846 (43.66%) SQL Server Integration Services
6 1434 (33.92%) Microsoft
7 1303 (30.82%) SQL Server Reporting Services
8 1289 (30.49%) Agile Software Development
9 1208 (28.57%) T-SQL
10 1155 (27.32%) Finance
11 989 (23.39%) SQL Server Analysis Services
12 966 (22.85%) Oracle
13 898 (21.24%) Analytics
14 884 (20.91%) Data Modelling
15 662 (15.66%) Analytical Skills
16 642 (15.18%) Big Data
17 615 (14.55%) Tableau
18 610 (14.43%) Power BI
19 564 (13.34%) Visualisation
20 534 (12.63%) Java
21 518 (12.25%) Degree
22 511 (12.09%) Data Management
23 508 (12.02%) .NET
24 492 (11.64%) Data Quality
25 482 (11.40%) Relational Database
26 473 (11.19%) Microsoft Azure
27 467 (11.05%) C#
28 466 (11.02%) Performance Tuning
29 442 (10.45%) BusinessObjects
30 431 (10.19%) Python

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 242 (5.72%) Apache Spark
2 185 (4.38%) SAS
3 141 (3.33%) SharePoint
4 86 (2.03%) Apache
5 69 (1.63%) BizTalk Server
6 62 (1.47%) IIS
7 56 (1.32%) Tomcat
8 44 (1.04%) Confluence
8 44 (1.04%) JBoss
9 41 (0.97%) Oracle SOA Suite
10 39 (0.92%) Apache Pig
11 29 (0.69%) CMS
12 20 (0.47%) Apache Airflow
12 20 (0.47%) Elasticsearch
13 18 (0.43%) WebSphere
14 16 (0.38%) Sitecore CMS
14 16 (0.38%) WebLogic
15 13 (0.31%) OpenROAD
16 12 (0.28%) Drupal
17 11 (0.26%) WordPress
Applications
1 415 (9.82%) Microsoft Excel
2 98 (2.32%) Microsoft Office
3 79 (1.87%) SPSS
4 56 (1.32%) Microsoft PowerPoint
5 45 (1.06%) MS Visio
6 9 (0.21%) Spreadsheet
7 7 (0.17%) Microsoft Project
8 4 (0.095%) EngageOne
8 4 (0.095%) SPSS Modeler
9 1 (0.024%) Mathematica
9 1 (0.024%) Weka
Business Applications
1 57 (1.35%) Cognos Business Intelligence
2 48 (1.14%) Dynamics CRM
3 23 (0.54%) Salesforce.com CRM
4 21 (0.50%) Markit EDM
5 20 (0.47%) Dynamics AX
5 20 (0.47%) Oracle EBS
6 15 (0.35%) Dynamics NAV
7 13 (0.31%) Cognos TM1
7 13 (0.31%) Dynamics GP
8 11 (0.26%) HFM
8 11 (0.26%) SAP ERP
9 10 (0.24%) BusinessWare
9 10 (0.24%) Hyperion Planning
9 10 (0.24%) SAP S/4HANA
10 9 (0.21%) Oracle ERP
11 7 (0.17%) Hyperion Enterprise
12 6 (0.14%) FastStats
12 6 (0.14%) Oracle Receivables
12 6 (0.14%) SAP Hybris
13 5 (0.12%) Oracle BPM
Cloud Services
1 473 (11.19%) Microsoft Azure
2 305 (7.21%) Amazon AWS
3 114 (2.70%) GitHub
4 78 (1.84%) Google Cloud Platform
5 71 (1.68%) SaaS
6 44 (1.04%) Azure Machine Learning
7 39 (0.92%) Cloud Computing
8 33 (0.78%) Azure Data Factory
9 32 (0.76%) IaaS
9 32 (0.76%) Office 365
10 22 (0.52%) Force.com
11 18 (0.43%) iPaaS
12 17 (0.40%) Amazon S3
12 17 (0.40%) Google Analytics
12 17 (0.40%) PaaS
13 14 (0.33%) Amazon Kinesis
13 14 (0.33%) Dynamics 365
14 13 (0.31%) Amazon EMR
14 13 (0.31%) AWS CloudFormation
15 12 (0.28%) Cortana Intelligence Suite
Communications & Networking
1 39 (0.92%) Firewall
2 30 (0.71%) HTTP
3 29 (0.69%) Intranet
4 18 (0.43%) LDAP
5 17 (0.40%) Internet
6 15 (0.35%) DNS
6 15 (0.35%) FTP
6 15 (0.35%) SSL
7 11 (0.26%) Kerberos
8 8 (0.19%) SMS
9 7 (0.17%) NAS
9 7 (0.17%) SAN
9 7 (0.17%) WinSCP
10 5 (0.12%) LAN
10 5 (0.12%) WAN
11 4 (0.095%) TCP/IP
12 3 (0.071%) HTTPS
12 3 (0.071%) SNMP
12 3 (0.071%) VPN
12 3 (0.071%) Wi-Fi
Database & Business Intelligence
1 2144 (50.71%) SQL Server
2 2047 (48.42%) Data Warehouse
3 1846 (43.66%) SQL Server Integration Services
4 1303 (30.82%) SQL Server Reporting Services
5 989 (23.39%) SQL Server Analysis Services
6 642 (15.18%) Big Data
7 610 (14.43%) Power BI
8 482 (11.40%) Relational Database
9 442 (10.45%) BusinessObjects
10 422 (9.98%) Hadoop
11 415 (9.82%) QlikView
12 387 (9.15%) SQL Server 2012
13 377 (8.92%) OLAP
14 347 (8.21%) SQL Server 2008
15 302 (7.14%) NoSQL
16 224 (5.30%) MySQL
17 214 (5.06%) RDBMS
18 202 (4.78%) Oracle Database
19 201 (4.75%) SQL Server 2014
20 186 (4.40%) SQL Server 2016
Development Applications
1 246 (5.82%) Visual Studio
2 243 (5.75%) Team Foundation Server
3 227 (5.37%) JIRA
4 197 (4.66%) Talend Open Studio
5 129 (3.05%) SQL Server Management Studio (SSMS)
6 126 (2.98%) TeamCity
7 101 (2.39%) Git (software)
8 77 (1.82%) Subversion
9 68 (1.61%) Jenkins
9 68 (1.61%) Selenium
10 55 (1.30%) Oracle Forms
11 35 (0.83%) Toad
12 32 (0.76%) HP UFT
13 31 (0.73%) ERwin
14 30 (0.71%) Octopus Deploy
15 27 (0.64%) Maven
16 22 (0.52%) Rational Functional Tester
16 22 (0.52%) RStudio
17 18 (0.43%) WebDriver
18 17 (0.40%) Bitbucket
General
1 1155 (27.32%) Finance
2 356 (8.42%) Banking
3 303 (7.17%) Retail
4 235 (5.56%) Marketing
5 183 (4.33%) Legal
6 169 (4.00%) Investment Banking
7 154 (3.64%) Retail Banking
8 112 (2.65%) Advertising
9 97 (2.29%) Manufacturing
10 95 (2.25%) Telecoms
11 76 (1.80%) Games
12 63 (1.49%) Publishing
13 58 (1.37%) Electronics
13 58 (1.37%) Front Office
14 48 (1.14%) Law
15 46 (1.09%) Back Office
16 33 (0.78%) Pharmaceutical
17 24 (0.57%) Financial Institution
18 19 (0.45%) Corporate Banking
18 19 (0.45%) Private Banking
Job Titles
1 2125 (50.26%) Developer
2 802 (18.97%) Business Intelligence Developer
3 750 (17.74%) SQL Developer
4 587 (13.88%) Analyst
5 342 (8.09%) SSIS Developer
6 318 (7.52%) Architect
7 315 (7.45%) ETL Developer
8 310 (7.33%) Consultant
9 308 (7.28%) Senior Developer
10 273 (6.46%) SQL BI Developer
11 256 (6.05%) Data Warehouse Developer
12 234 (5.53%) SQL Server Developer
13 228 (5.39%) DBA
14 204 (4.82%) Business Developer
14 204 (4.82%) SSRS Developer
15 189 (4.47%) Data Engineer
16 172 (4.07%) Data Analyst
17 171 (4.04%) Data Architect
18 169 (4.00%) SQL DBA
19 159 (3.76%) SQL Analyst
Libraries, Frameworks & Software Standards
1 508 (12.02%) .NET
2 266 (6.29%) Web Services
3 239 (5.65%) MDX
3 239 (5.65%) XML
4 207 (4.90%) HTML
5 199 (4.71%) ASP.NET
6 110 (2.60%) SOAP
7 105 (2.48%) CSS
8 95 (2.25%) REST
9 89 (2.11%) .NET Framework
10 81 (1.92%) JSON
11 78 (1.84%) Kafka
12 64 (1.51%) Spring
13 63 (1.49%) AngularJS
14 62 (1.47%) Oracle GoldenGate
15 57 (1.35%) ASP.NET MVC
16 56 (1.32%) HTML5
17 46 (1.09%) jQuery
18 45 (1.06%) ASP.NET Web API
19 39 (0.92%) RESTful
Miscellaneous
1 662 (15.66%) Analytical Skills
2 255 (6.03%) Computer Science
3 220 (5.20%) Management Information System
4 169 (4.00%) Data Structures
5 88 (2.08%) Clustering
6 86 (2.03%) Enterprise Software
7 83 (1.96%) Replication
8 63 (1.49%) Greenfield Project
9 54 (1.28%) Fintech
10 46 (1.09%) User Experience
11 42 (0.99%) Life Science
12 39 (0.92%) Client/Server
13 33 (0.78%) Credit Risk
14 31 (0.73%) Algorithms
15 27 (0.64%) Reference Data
16 26 (0.61%) N-Tier
17 25 (0.59%) iPad
18 24 (0.57%) Virtual Team
19 23 (0.54%) Renewable Energy
20 22 (0.52%) NHS
Operating Systems
1 284 (6.72%) Linux
2 206 (4.87%) Windows
3 174 (4.12%) Unix
4 53 (1.25%) Windows Server
5 41 (0.97%) Windows Server 2012
6 20 (0.47%) Solaris
6 20 (0.47%) Windows Server 2008
7 18 (0.43%) Windows 7
8 15 (0.35%) AIX
9 12 (0.28%) Red Hat Enterprise Linux
10 10 (0.24%) Android
11 9 (0.21%) Apple iOS
12 7 (0.17%) Windows Server 2003
13 6 (0.14%) Ubuntu
14 5 (0.12%) Windows 10
15 3 (0.071%) Windows 8
16 2 (0.047%) CentOS
16 2 (0.047%) Mesosphere
16 2 (0.047%) Oracle Linux
Processes & Methodologies
1 2308 (54.59%) Business Intelligence
2 1289 (30.49%) Agile Software Development
3 898 (21.24%) Analytics
4 884 (20.91%) Data Modelling
5 564 (13.34%) Visualisation
6 511 (12.09%) Data Management
7 466 (11.02%) Performance Tuning
8 404 (9.56%) SDLC
9 399 (9.44%) Data Integration
10 380 (8.99%) Migration
11 372 (8.80%) Data Analysis
12 366 (8.66%) Kimball Methodology
13 365 (8.63%) Scrum
14 324 (7.66%) ETL Development
15 322 (7.62%) Data Visualisation
16 259 (6.13%) Mentoring
17 242 (5.72%) Stakeholder Management
18 239 (5.65%) Data Migration
19 238 (5.63%) Dimensional Modelling
20 233 (5.51%) CRM
Programming Languages
1 3029 (71.64%) SQL
2 1208 (28.57%) T-SQL
3 534 (12.63%) Java
4 467 (11.05%) C#
5 431 (10.19%) Python
6 342 (8.09%) PL/SQL
7 256 (6.05%) JavaScript
8 189 (4.47%) R
9 168 (3.97%) PowerShell
10 133 (3.15%) Scala
11 116 (2.74%) Shell Script
12 112 (2.65%) VBA
13 79 (1.87%) Data Analysis Expressions (DAX)
14 60 (1.42%) PHP
15 54 (1.28%) VB
16 49 (1.16%) VB.NET
17 43 (1.02%) Bash Shell
18 41 (0.97%) C
19 40 (0.95%) C++
20 30 (0.71%) VBScript
Qualifications
1 518 (12.25%) Degree
2 143 (3.38%) Computer Science Degree
3 123 (2.91%) Microsoft Certification
4 63 (1.49%) Security Cleared
5 47 (1.11%) MCSA
6 42 (0.99%) MCSE
6 42 (0.99%) SC Cleared
7 39 (0.92%) Master's Degree
8 33 (0.78%) ISEB
8 33 (0.78%) ISTQB
9 26 (0.61%) Numerate Degree
10 15 (0.35%) MCITP
11 13 (0.31%) ITIL Certification
12 11 (0.26%) MCP
13 9 (0.21%) MCDBA
14 8 (0.19%) ITIL Foundation Certificate
14 8 (0.19%) MBA
14 8 (0.19%) Oracle Certification
14 8 (0.19%) PMI Certification
15 7 (0.17%) PhD
Quality Assurance & Compliance
1 492 (11.64%) Data Quality
2 245 (5.79%) QA
3 62 (1.47%) SLA
4 28 (0.66%) GDPR
5 16 (0.38%) GCP
6 11 (0.26%) MiFID
6 11 (0.26%) PMO
7 8 (0.19%) ISO/IEC 27001
8 7 (0.17%) CRD IV
8 7 (0.17%) EMIR
9 6 (0.14%) Actionable Recommendations
10 5 (0.12%) ISO 9001
10 5 (0.12%) PCI DSS
11 4 (0.095%) Solvency II
12 3 (0.071%) COBIT
12 3 (0.071%) FATCA
12 3 (0.071%) HL7
12 3 (0.071%) IFRS
12 3 (0.071%) IFRS 9
13 1 (0.024%) Disclosure Scotland
System Software
1 57 (1.35%) HDFS
2 54 (1.28%) Active Directory
3 32 (0.76%) Apache Flume
4 23 (0.54%) VMware Infrastructure
5 16 (0.38%) Docker
6 7 (0.17%) Virtual Servers
7 5 (0.12%) Firmware
7 5 (0.12%) Hyper-V
8 4 (0.095%) Microsoft Virtual Server
9 3 (0.071%) KVM
9 3 (0.071%) Terminal Services
10 2 (0.047%) Apache ZooKeeper
11 1 (0.024%) Cronacle
11 1 (0.024%) MapR-FS
11 1 (0.024%) Oracle RAC
11 1 (0.024%) Virtual Machines
Systems Management
1 42 (0.99%) Oozie
2 24 (0.57%) SCCM
3 22 (0.52%) HP Quality Center
3 22 (0.52%) Oracle Enterprise Manager
4 20 (0.47%) Opscode Chef
5 19 (0.45%) Puppet
6 14 (0.33%) Ambari
7 11 (0.26%) ZABBIX
8 10 (0.24%) Control-M
8 10 (0.24%) Systems Management Server (SMS)
9 9 (0.21%) Failover Clustering
9 9 (0.21%) Microsoft Clustering
9 9 (0.21%) SCOM
10 8 (0.19%) Ansible
10 8 (0.19%) Tivoli
11 5 (0.12%) Nagios
12 4 (0.095%) CA Single Sign-On
12 4 (0.095%) Data Guard
12 4 (0.095%) Dollar Universe
12 4 (0.095%) Hadoop YARN
Vendors
1 1434 (33.92%) Microsoft
2 966 (22.85%) Oracle
3 615 (14.55%) Tableau
4 427 (10.10%) SAP
5 360 (8.51%) Informatica
6 247 (5.84%) Cognos
7 197 (4.66%) Talend
8 181 (4.28%) MicroStrategy
9 170 (4.02%) IBM
10 136 (3.22%) Teradata
11 101 (2.39%) Google
12 95 (2.25%) Salesforce.com
13 92 (2.18%) Alteryx
14 77 (1.82%) Netezza
15 76 (1.80%) Cloudera
16 55 (1.30%) Ab Initio
17 53 (1.25%) Sybase
18 52 (1.23%) Jaspersoft
19 49 (1.16%) Hyperion
20 42 (0.99%) Hortonworks