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

Extract, Transform and Load (ETL)
UK
6 months to
22 Aug 2017
Same period 2016 Same period 2015
Rank 147 132 120
Rank change year-on-year -15 -12 +18
Permanent jobs citing ETL 4289 5029 5512
As % of all permanent IT jobs advertised in the UK 2.44% 2.55% 2.53%
As % of the Processes & Methodologies category 2.71% 2.87% 2.87%
Number of salaries quoted 3390 4109 4575
UK median annual salary £50,000 £52,500 £52,500
Median salary % change year-on-year -4.76% - +5.00%
10th Percentile £32,500 £35,000 £33,750
90th Percentile £76,400 £77,500 £80,000
UK excluding London median annual salary £44,500 £45,000 £45,000
% change year-on-year -1.11% - +2.27%

ETL is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for process and methodology skills.

Process & Methodology Skills
UK
Permanent job vacancies with a requirement for process and methodology skills 158356 175503 192296
As % of all permanent IT job vacancies advertised in the UK 89.94% 89.07% 88.16%
Number of salaries quoted 125505 146405 157070
UK median annual salary £50,000 £49,000 £47,500
Median salary % change year-on-year +2.04% +3.16% +5.56%
10th Percentile £28,750 £27,500 £27,500
90th Percentile £80,000 £77,500 £76,250
UK excluding London median annual salary £42,500 £42,500 £42,500

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 22 August 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 22 August 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 -18 3983 £50,000 -4.76% 239
UK excluding London +5 2208 £44,500 -1.11% 158
London -27 2007 £57,500 - 103
North of England +9 611 £42,500 +6.25% 50
South East -33 504 £52,500 +5.00% 36
Midlands -4 327 £40,550 -7.84% 24
North West +7 321 £40,000 - 27
Yorkshire +11 280 £45,000 +5.88% 21
East of England +43 274 £45,000 -10.00% 14
South West +26 246 £40,000 - 13
Scotland +7 183 £45,000 -14.29% 16
West Midlands -10 181 £40,000 -5.88% 17
East Midlands +1 132 £44,500 -1.11% 7
Wales +17 68 £45,000 +12.50% 4
Northern Ireland -3 13 £36,500 -8.75% 1
North East +4 10 £67,500 +62.65% 2
Isle of Man - 1 £50,000 - 1

For the 6 months to 22 August 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 3089 (72.02%) SQL
2 2332 (54.37%) Business Intelligence
3 2160 (50.36%) SQL Server
4 2098 (48.92%) Data Warehouse
5 1910 (44.53%) SQL Server Integration Services
6 1443 (33.64%) Microsoft
7 1353 (31.55%) SQL Server Reporting Services
8 1311 (30.57%) Agile Software Development
9 1202 (28.03%) T-SQL
10 1188 (27.70%) Finance
11 1050 (24.48%) SQL Server Analysis Services
12 1014 (23.64%) Oracle
13 888 (20.70%) Data Modelling
14 852 (19.86%) Analytics
15 732 (17.07%) Big Data
16 670 (15.62%) Analytical Skills
17 607 (14.15%) Tableau
18 602 (14.04%) Power BI
19 577 (13.45%) Degree
20 562 (13.10%) Java
21 551 (12.85%) Visualisation
21 551 (12.85%) Relational Database
22 525 (12.24%) .NET
23 475 (11.07%) C#
24 471 (10.98%) Microsoft Azure
25 461 (10.75%) Data Quality
26 452 (10.54%) Data Management
27 432 (10.07%) QlikView
28 429 (10.00%) BusinessObjects
29 427 (9.96%) Hadoop

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 229 (5.34%) Apache Spark
2 170 (3.96%) SAS
3 138 (3.22%) SharePoint
4 77 (1.80%) IIS
5 72 (1.68%) BizTalk Server
6 59 (1.38%) Apache
7 51 (1.19%) JBoss
8 50 (1.17%) Oracle SOA Suite
9 42 (0.98%) Confluence
9 42 (0.98%) Tomcat
10 38 (0.89%) Elasticsearch
11 37 (0.86%) Apache Pig
12 36 (0.84%) CMS
13 20 (0.47%) Sitecore CMS
14 16 (0.37%) Apache Solr
15 14 (0.33%) Apache Airflow
15 14 (0.33%) Oracle Workflow
16 11 (0.26%) OpenROAD
17 9 (0.21%) SharePoint 2013
17 9 (0.21%) WordPress
Applications
1 413 (9.63%) Microsoft Excel
2 99 (2.31%) Microsoft Office
3 77 (1.80%) SPSS
4 63 (1.47%) MS Visio
5 53 (1.24%) Microsoft PowerPoint
6 16 (0.37%) Microsoft Project
7 9 (0.21%) Spreadsheet
8 5 (0.12%) SPSS Modeler
9 1 (0.023%) EngageOne
9 1 (0.023%) Mathematica
Business Applications
1 50 (1.17%) Cognos Business Intelligence
2 39 (0.91%) Dynamics CRM
3 27 (0.63%) Oracle EBS
4 20 (0.47%) Salesforce.com CRM
5 16 (0.37%) Cognos TM1
5 16 (0.37%) Dynamics NAV
6 15 (0.35%) Dynamics AX
6 15 (0.35%) HFM
7 13 (0.30%) Hyperion Planning
7 13 (0.30%) Markit EDM
8 12 (0.28%) Dynamics GP
8 12 (0.28%) Hyperion Enterprise
9 10 (0.23%) SAP CO
9 10 (0.23%) SAP ERP
9 10 (0.23%) SAP FI
9 10 (0.23%) SAP FI/CO
10 9 (0.21%) BusinessWorks
10 9 (0.21%) iTrent
10 9 (0.21%) Oracle ERP
10 9 (0.21%) SAP S/4HANA
Cloud Services
1 471 (10.98%) Microsoft Azure
2 297 (6.92%) Amazon AWS
3 93 (2.17%) GitHub
4 74 (1.73%) Google Cloud Platform
5 58 (1.35%) SaaS
6 50 (1.17%) Azure Machine Learning
7 41 (0.96%) Cloud Computing
8 27 (0.63%) IaaS
9 26 (0.61%) Azure Data Factory
10 22 (0.51%) Google Analytics
10 22 (0.51%) Office 365
11 17 (0.40%) iPaaS
12 16 (0.37%) Force.com
13 15 (0.35%) Amazon S3
14 14 (0.33%) Amazon EC2
15 12 (0.28%) Dynamics 365
16 10 (0.23%) Salesforce Service Cloud
17 9 (0.21%) Cortana Intelligence Suite
18 7 (0.16%) Amazon EMR
19 6 (0.14%) Salesforce Sales Cloud
Communications & Networking
1 32 (0.75%) Intranet
2 18 (0.42%) FTP
2 18 (0.42%) Internet
3 16 (0.37%) Kerberos
4 13 (0.30%) HTTP
5 12 (0.28%) Firewall
6 8 (0.19%) LAN
6 8 (0.19%) LDAP
6 8 (0.19%) WAN
7 7 (0.16%) DNS
7 7 (0.16%) NAS
7 7 (0.16%) SAN
8 6 (0.14%) Extranet
8 6 (0.14%) SMS
9 5 (0.12%) Broadband
9 5 (0.12%) DHCP
10 4 (0.093%) SSL
10 4 (0.093%) WinSCP
11 3 (0.070%) GoToMeeting
11 3 (0.070%) WebEx
Database & Business Intelligence
1 2160 (50.36%) SQL Server
2 2098 (48.92%) Data Warehouse
3 1910 (44.53%) SQL Server Integration Services
4 1353 (31.55%) SQL Server Reporting Services
5 1050 (24.48%) SQL Server Analysis Services
6 732 (17.07%) Big Data
7 602 (14.04%) Power BI
8 551 (12.85%) Relational Database
9 432 (10.07%) QlikView
10 429 (10.00%) BusinessObjects
11 427 (9.96%) Hadoop
12 403 (9.40%) SQL Server 2012
13 390 (9.09%) OLAP
14 356 (8.30%) SQL Server 2008
15 329 (7.67%) NoSQL
16 275 (6.41%) Oracle Database
17 255 (5.95%) RDBMS
18 226 (5.27%) MySQL
19 216 (5.04%) SQL Server 2014
20 197 (4.59%) SQL Server 2016
Development Applications
1 233 (5.43%) Team Foundation Server
1 233 (5.43%) Visual Studio
2 211 (4.92%) Talend Open Studio
3 209 (4.87%) JIRA
4 122 (2.84%) SQL Server Management Studio (SSMS)
5 113 (2.63%) TeamCity
6 112 (2.61%) Git (software)
7 75 (1.75%) Subversion
8 68 (1.59%) Selenium
9 56 (1.31%) Oracle Forms
10 53 (1.24%) Jenkins
11 39 (0.91%) ERwin
12 35 (0.82%) HP UFT
13 29 (0.68%) Octopus Deploy
14 28 (0.65%) Maven
14 28 (0.65%) Toad
15 24 (0.56%) Rational Functional Tester
16 22 (0.51%) PowerDesigner
16 22 (0.51%) RStudio
17 19 (0.44%) WebDriver
General
1 1188 (27.70%) Finance
2 391 (9.12%) Retail
3 306 (7.13%) Banking
4 231 (5.39%) Marketing
5 179 (4.17%) Legal
6 146 (3.40%) Investment Banking
7 124 (2.89%) Retail Banking
8 115 (2.68%) Advertising
9 107 (2.49%) Telecoms
10 88 (2.05%) Games
10 88 (2.05%) Manufacturing
11 59 (1.38%) Publishing
12 58 (1.35%) Electronics
13 56 (1.31%) Front Office
14 46 (1.07%) Law
15 43 (1.00%) Pharmaceutical
16 31 (0.72%) Back Office
17 22 (0.51%) Private Banking
18 21 (0.49%) Corporate Banking
19 20 (0.47%) Polish Language
Job Titles
1 2114 (49.29%) Developer
2 806 (18.79%) Business Intelligence Developer
3 801 (18.68%) SQL Developer
4 603 (14.06%) Analyst
5 356 (8.30%) SSIS Developer
6 328 (7.65%) ETL Developer
7 327 (7.62%) Architect
8 316 (7.37%) Senior Developer
9 283 (6.60%) SQL BI Developer
10 278 (6.48%) Data Warehouse Developer
11 267 (6.23%) Consultant
12 260 (6.06%) SQL Server Developer
13 255 (5.95%) DBA
14 227 (5.29%) SSRS Developer
15 215 (5.01%) Oracle Developer
16 213 (4.97%) Data Engineer
17 212 (4.94%) Business Intelligence Analyst
18 207 (4.83%) SQL Analyst
19 189 (4.41%) Data Architect
20 179 (4.17%) SQL DBA
Libraries, Frameworks & Software Standards
1 525 (12.24%) .NET
2 265 (6.18%) XML
3 248 (5.78%) Web Services
4 224 (5.22%) MDX
5 214 (4.99%) HTML
6 176 (4.10%) ASP.NET
7 130 (3.03%) SOAP
8 125 (2.91%) CSS
9 113 (2.63%) .NET Framework
10 105 (2.45%) REST
11 98 (2.28%) Kafka
12 92 (2.15%) JSON
13 70 (1.63%) ASP.NET MVC
14 67 (1.56%) Spring
15 59 (1.38%) AngularJS
16 57 (1.33%) HTML5
17 56 (1.31%) Oracle GoldenGate
17 56 (1.31%) RESTful
18 45 (1.05%) ASP.NET Web API
19 39 (0.91%) jQuery
Miscellaneous
1 670 (15.62%) Analytical Skills
2 302 (7.04%) Computer Science
3 246 (5.74%) Management Information System
4 154 (3.59%) Data Structures
5 88 (2.05%) Clustering
6 86 (2.01%) Enterprise Software
7 84 (1.96%) Replication
8 80 (1.87%) Greenfield Project
9 73 (1.70%) Fintech
10 56 (1.31%) User Experience
11 39 (0.91%) Life Science
12 38 (0.89%) Algorithms
13 33 (0.77%) Renewable Energy
14 32 (0.75%) iPad
15 24 (0.56%) Client/Server
16 23 (0.54%) Linux Command Line
17 22 (0.51%) Credit Risk
17 22 (0.51%) NHS
17 22 (0.51%) Reference Data
17 22 (0.51%) Semantic Web
Operating Systems
1 312 (7.27%) Linux
2 204 (4.76%) Windows
3 173 (4.03%) Unix
4 67 (1.56%) Windows Server
5 20 (0.47%) Red Hat Enterprise Linux
6 18 (0.42%) Windows Server 2012
7 17 (0.40%) Windows Server 2003
8 13 (0.30%) Solaris
8 13 (0.30%) Windows 7
9 12 (0.28%) Windows Server 2008
10 10 (0.23%) Android
11 8 (0.19%) Windows 10
12 7 (0.16%) Apple iOS
13 5 (0.12%) Ubuntu
14 3 (0.070%) CentOS
14 3 (0.070%) Windows 8
15 2 (0.047%) Mesosphere
16 1 (0.023%) MVS
Processes & Methodologies
1 2332 (54.37%) Business Intelligence
2 1311 (30.57%) Agile Software Development
3 888 (20.70%) Data Modelling
4 852 (19.86%) Analytics
5 551 (12.85%) Visualisation
6 452 (10.54%) Data Management
7 414 (9.65%) Performance Tuning
8 399 (9.30%) Scrum
9 390 (9.09%) Data Integration
10 377 (8.79%) SDLC
11 356 (8.30%) Migration
12 339 (7.90%) Data Visualisation
13 338 (7.88%) Kimball Methodology
14 329 (7.67%) Data Analysis
15 311 (7.25%) ETL Development
16 251 (5.85%) Mentoring
17 247 (5.76%) Test Automation
18 227 (5.29%) Data Analytics
19 224 (5.22%) DevOps
20 223 (5.20%) CRM
Programming Languages
1 3089 (72.02%) SQL
2 1202 (28.03%) T-SQL
3 562 (13.10%) Java
4 475 (11.07%) C#
5 403 (9.40%) Python
6 396 (9.23%) PL/SQL
7 273 (6.37%) JavaScript
8 218 (5.08%) R
9 129 (3.01%) Shell Script
10 117 (2.73%) PowerShell
11 109 (2.54%) Scala
12 89 (2.08%) VBA
13 83 (1.94%) Data Analysis Expressions (DAX)
14 55 (1.28%) VB.NET
15 50 (1.17%) Bash Shell
15 50 (1.17%) C++
15 50 (1.17%) VB
16 48 (1.12%) PHP
17 45 (1.05%) C
18 35 (0.82%) VBScript
Qualifications
1 577 (13.45%) Degree
2 156 (3.64%) Computer Science Degree
3 113 (2.63%) Microsoft Certification
4 69 (1.61%) Security Cleared
5 54 (1.26%) ISEB
6 48 (1.12%) SC Cleared
7 47 (1.10%) Master's Degree
8 45 (1.05%) ISTQB
9 40 (0.93%) Numerate Degree
10 33 (0.77%) MCSA
10 33 (0.77%) MCSE
11 18 (0.42%) MCITP
12 16 (0.37%) ITIL Certification
12 16 (0.37%) ITIL Foundation Certificate
13 10 (0.23%) CITP
13 10 (0.23%) Oracle Certification
14 9 (0.21%) MCP
15 8 (0.19%) PMI Certification
15 8 (0.19%) Postgraduate
16 7 (0.16%) PhD
Quality Assurance & Compliance
1 461 (10.75%) Data Quality
2 257 (5.99%) QA
3 53 (1.24%) SLA
4 17 (0.40%) ISO/IEC 27001
5 16 (0.37%) GDPR
6 11 (0.26%) Sarbanes-Oxley
7 6 (0.14%) PMO
7 6 (0.14%) Solvency II
8 5 (0.12%) GCP
8 5 (0.12%) ISO 9001
8 5 (0.12%) MiFID
9 4 (0.093%) PCI DSS
10 3 (0.070%) FATCA
10 3 (0.070%) IFRS
11 2 (0.047%) Actionable Recommendations
11 2 (0.047%) COBIT
11 2 (0.047%) CRD IV
11 2 (0.047%) EMIR
11 2 (0.047%) IFRS 9
12 1 (0.023%) SNOMED CT
System Software
1 59 (1.38%) HDFS
2 33 (0.77%) Active Directory
3 22 (0.51%) Apache Flume
4 18 (0.42%) VMware Infrastructure
5 11 (0.26%) Docker
6 8 (0.19%) Hyper-V
7 7 (0.16%) KVM
8 6 (0.14%) Virtual Servers
9 4 (0.093%) Oracle RAC
10 3 (0.070%) Firmware
10 3 (0.070%) Microsoft Virtual Server
10 3 (0.070%) Terminal Services
11 2 (0.047%) Tivoli Workload Scheduler
12 1 (0.023%) Apache ZooKeeper
12 1 (0.023%) Cronacle
12 1 (0.023%) Virtual Machines
12 1 (0.023%) XenServer
Systems Management
1 34 (0.79%) Oozie
2 23 (0.54%) HP Quality Center
3 21 (0.49%) Tivoli
4 20 (0.47%) Opscode Chef
5 18 (0.42%) Ansible
5 18 (0.42%) Puppet
6 16 (0.37%) Control-M
7 13 (0.30%) Failover Clustering
8 11 (0.26%) Data Guard
8 11 (0.26%) SCCM
9 8 (0.19%) Oracle Enterprise Manager
10 7 (0.16%) SCOM
11 6 (0.14%) Hadoop YARN
11 6 (0.14%) Microsoft Clustering
12 5 (0.12%) logstash
12 5 (0.12%) Systems Management Server (SMS)
13 3 (0.070%) Backup Exec
13 3 (0.070%) Kubernetes
13 3 (0.070%) Norton AntiVirus
13 3 (0.070%) WSUS
Vendors
1 1443 (33.64%) Microsoft
2 1014 (23.64%) Oracle
3 607 (14.15%) Tableau
4 384 (8.95%) SAP
5 366 (8.53%) Informatica
6 211 (4.92%) Talend
7 209 (4.87%) Cognos
8 159 (3.71%) MicroStrategy
9 152 (3.54%) IBM
10 117 (2.73%) Teradata
11 89 (2.08%) Google
12 81 (1.89%) Salesforce.com
13 76 (1.77%) Alteryx
13 76 (1.77%) Netezza
14 73 (1.70%) Cloudera
15 58 (1.35%) Jaspersoft
16 56 (1.31%) Hyperion
17 53 (1.24%) Sybase
18 41 (0.96%) Ab Initio
19 40 (0.93%) Hortonworks