Period
to 21 January 2018

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 January 2018 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
UK
6 months to
21 Jan 2018
Same period 2017 Same period 2016
Rank 138 137 101
Rank change year-on-year -1 -36 +29
Permanent jobs citing ETL 4,095 4,232 5,988
As % of all permanent IT jobs advertised in the UK 2.38% 2.41% 2.87%
As % of the Processes & Methodologies category 2.65% 2.69% 3.23%
Number of salaries quoted 3,288 3,521 4,972
UK median annual salary £50,000 £50,000 £50,000
10th Percentile £33,750 £33,250 £33,545
90th Percentile £78,575 £77,500 £76,250
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 154,446 157,552 185,134
As % of all permanent IT jobs advertised in the UK 89.85% 89.54% 88.87%
Number of salaries quoted 124,126 130,212 153,462
UK median annual salary £50,000 £48,500 £47,500
Median salary % change year-on-year +3.09% +2.11% +5.56%
10th Percentile £28,750 £28,250 £27,500
90th Percentile £80,000 £78,750 £77,500
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +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 January 2018.

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 January 2018. 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 -3 3,813 £50,000 -4.76% 511
UK excluding London -3 2,147 £45,000 - 287
London -19 1,864 £57,500 -4.17% 267
North of England +10 567 £45,000 +12.50% 63
South East -34 565 £52,500 +1.94% 69
Midlands +42 327 £45,000 +5.88% 51
South West +57 276 £40,000 -5.88% 35
Yorkshire +26 274 £44,471 +4.64% 33
North West -15 260 £45,000 +20.00% 30
West Midlands +68 243 £49,000 +15.29% 32
East of England -24 208 £50,000 - 26
Scotland -18 164 £45,000 -10.00% 34
East Midlands -19 81 £40,000 -11.11% 19
Wales +7 42 £40,000 +11.11% 8
North East -2 27 £35,500 -11.25%
Northern Ireland -16 5 £45,000 +50.00% 1
Isle of Man - 3 £50,000 -

For the 6 months to 21 January 2018, 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 2,816 (68.77%) SQL
2 2,291 (55.95%) Business Intelligence
3 2,040 (49.82%) Data Warehouse
4 2,005 (48.96%) SQL Server
5 1,688 (41.22%) SQL Server Integration Services
6 1,272 (31.06%) Microsoft
7 1,268 (30.96%) SQL Server Reporting Services
8 1,125 (27.47%) T-SQL
9 1,072 (26.18%) Agile Software Development
10 1,028 (25.10%) Finance
11 990 (24.18%) Analytics
12 938 (22.91%) SQL Server Analysis Services
13 876 (21.39%) Data Modelling
14 792 (19.34%) Oracle
15 639 (15.60%) Tableau
16 628 (15.34%) Power BI
17 590 (14.41%) Big Data
18 576 (14.07%) Data Management
19 560 (13.68%) Analytical Skills
20 551 (13.46%) Visualisation
21 518 (12.65%) Java
22 502 (12.26%) Python
23 467 (11.40%) Microsoft Azure
24 463 (11.31%) Degree
25 440 (10.74%) Hadoop
26 429 (10.48%) C#
27 425 (10.38%) .NET
28 418 (10.21%) Data Quality
29 412 (10.06%) Data Integration
30 405 (9.89%) 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 302 (7.37%) Apache Spark
2 206 (5.03%) SAS
3 137 (3.35%) Apache
4 90 (2.20%) Elasticsearch
5 86 (2.10%) SharePoint
6 75 (1.83%) Tomcat
7 64 (1.56%) Apache Pig
8 50 (1.22%) IIS
9 45 (1.10%) BizTalk Server
10 39 (0.95%) JBoss
11 35 (0.85%) Apache Solr
12 33 (0.81%) Confluence
13 25 (0.61%) Apache Airflow
13 25 (0.61%) WebSphere
14 24 (0.59%) Drupal
15 20 (0.49%) WebLogic
16 17 (0.42%) Oracle SOA Suite
17 10 (0.24%) CMS
18 9 (0.22%) Jetty
18 9 (0.22%) SharePoint Server
Applications
1 343 (8.38%) Microsoft Excel
2 74 (1.81%) Microsoft Office
3 66 (1.61%) SPSS
4 49 (1.20%) Microsoft PowerPoint
5 18 (0.44%) MS Visio
6 11 (0.27%) Microsoft Project
7 4 (0.098%) EngageOne
7 4 (0.098%) Spreadsheet
8 3 (0.073%) SPSS Modeler
9 2 (0.049%) Weka
10 1 (0.024%) Chatbot
Business Applications
1 48 (1.17%) Dynamics CRM
2 37 (0.90%) Cognos Business Intelligence
3 32 (0.78%) Dynamics AX
4 27 (0.66%) Markit EDM
5 23 (0.56%) BusinessWare
6 18 (0.44%) Oracle EBS
7 17 (0.42%) Cognos TM1
8 15 (0.37%) NetSuite
9 13 (0.32%) Oracle ERP
10 12 (0.29%) Salesforce.com CRM
11 10 (0.24%) Dynamics NAV
11 10 (0.24%) Oracle EBS R12
11 10 (0.24%) Oracle Receivables
12 9 (0.22%) Eagle PACE
12 9 (0.22%) SAP ERP
13 8 (0.20%) Oracle Applications
13 8 (0.20%) SAP Hybris
14 6 (0.15%) Dynamics GP
14 6 (0.15%) SAP S/4HANA
15 5 (0.12%) Oracle Payables
Cloud Services
1 467 (11.40%) Microsoft Azure
2 402 (9.82%) Amazon AWS
3 94 (2.30%) Google Cloud Platform
4 91 (2.22%) GitHub
5 63 (1.54%) SaaS
6 54 (1.32%) Amazon Kinesis
7 44 (1.07%) Amazon EMR
8 43 (1.05%) Cloud Computing
9 40 (0.98%) Force.com
10 35 (0.85%) Office 365
11 33 (0.81%) Azure Machine Learning
12 32 (0.78%) Amazon S3
12 32 (0.78%) Azure Data Factory
13 23 (0.56%) PaaS
14 22 (0.54%) Google Analytics
14 22 (0.54%) IaaS
15 18 (0.44%) AWS CloudFormation
16 17 (0.42%) Serverless
17 15 (0.37%) Amazon CloudWatch
17 15 (0.37%) Dynamics 365
Communications & Networking
1 48 (1.17%) Firewall
2 26 (0.63%) HTTP
3 18 (0.44%) DNS
4 17 (0.42%) Internet
5 14 (0.34%) SMS
5 14 (0.34%) SSL
6 11 (0.27%) Ethernet
6 11 (0.27%) Wireless
7 10 (0.24%) FTP
8 9 (0.22%) AMQP
8 9 (0.22%) Kerberos
9 8 (0.20%) WinSCP
10 6 (0.15%) SAN
11 5 (0.12%) Intranet
11 5 (0.12%) NAS
12 4 (0.098%) LAN
12 4 (0.098%) Network Security
12 4 (0.098%) TCP/IP
12 4 (0.098%) VPN
12 4 (0.098%) WAN
Database & Business Intelligence
1 2,040 (49.82%) Data Warehouse
2 2,005 (48.96%) SQL Server
3 1,688 (41.22%) SQL Server Integration Services
4 1,268 (30.96%) SQL Server Reporting Services
5 938 (22.91%) SQL Server Analysis Services
6 628 (15.34%) Power BI
7 590 (14.41%) Big Data
8 440 (10.74%) Hadoop
9 405 (9.89%) BusinessObjects
10 381 (9.30%) QlikView
11 379 (9.26%) Relational Database
12 309 (7.55%) SQL Server 2012
13 298 (7.28%) OLAP
14 272 (6.64%) NoSQL
15 237 (5.79%) SQL Server 2008
16 208 (5.08%) SQL Server 2016
17 201 (4.91%) MySQL
18 187 (4.57%) SQL Server 2014
19 166 (4.05%) Amazon Redshift
20 156 (3.81%) Data Mining
Development Applications
1 208 (5.08%) Team Foundation Server
2 176 (4.30%) Visual Studio
3 165 (4.03%) JIRA
4 132 (3.22%) SQL Server Management Studio (SSMS)
5 97 (2.37%) Git (software)
6 73 (1.78%) Jenkins
7 59 (1.44%) TeamCity
8 58 (1.42%) Subversion
9 56 (1.37%) Selenium
10 45 (1.10%) Oracle Forms
11 29 (0.71%) Toad
12 26 (0.63%) ERwin
13 21 (0.51%) Cucumber
14 20 (0.49%) Bitbucket
15 18 (0.44%) Octopus Deploy
15 18 (0.44%) Oracle APEX
16 16 (0.39%) HP UFT
17 15 (0.37%) InstallShield
18 14 (0.34%) Eclipse
18 14 (0.34%) RStudio
General
1 1,028 (25.10%) Finance
2 279 (6.81%) Retail
3 227 (5.54%) Banking
4 194 (4.74%) Advertising
5 191 (4.66%) Marketing
6 113 (2.76%) Legal
7 100 (2.44%) Investment Banking
8 90 (2.20%) Retail Banking
9 80 (1.95%) Manufacturing
10 68 (1.66%) Games
11 64 (1.56%) Telecoms
12 52 (1.27%) Law
13 49 (1.20%) Front Office
14 45 (1.10%) Publishing
15 43 (1.05%) Electronics
16 32 (0.78%) Back Office
16 32 (0.78%) Pharmaceutical
17 27 (0.66%) Corporate Banking
18 26 (0.63%) Private Banking
19 19 (0.46%) Automotive
Job Titles
1 1,874 (45.76%) Developer
2 771 (18.83%) Business Intelligence Developer
3 618 (15.09%) SQL Developer
4 587 (14.33%) Analyst
5 374 (9.13%) Architect
6 317 (7.74%) Consultant
7 294 (7.18%) SSIS Developer
8 272 (6.64%) ETL Developer
9 244 (5.96%) Data Engineer
10 241 (5.89%) SQL BI Developer
11 235 (5.74%) Senior Developer
12 232 (5.67%) Business Developer
13 218 (5.32%) Data Architect
14 215 (5.25%) Data Warehouse Developer
15 187 (4.57%) SSRS Developer
16 186 (4.54%) DBA
17 185 (4.52%) Data Analyst
18 159 (3.88%) SQL Server Developer
19 155 (3.79%) SQL DBA
20 132 (3.22%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 425 (10.38%) .NET
2 290 (7.08%) Web Services
3 184 (4.49%) MDX
4 183 (4.47%) XML
5 162 (3.96%) HTML
6 142 (3.47%) ASP.NET
7 104 (2.54%) JSON
8 99 (2.42%) REST
9 98 (2.39%) SOAP
10 89 (2.17%) AngularJS
11 88 (2.15%) Kafka
12 75 (1.83%) CSS
13 62 (1.51%) Spring
14 58 (1.42%) Pandas
15 54 (1.32%) Middleware
16 53 (1.29%) React
17 47 (1.15%) .NET Framework
17 47 (1.15%) J2EE
18 46 (1.12%) HTML5
19 42 (1.03%) Oracle GoldenGate
Miscellaneous
1 560 (13.68%) Analytical Skills
2 237 (5.79%) Computer Science
3 172 (4.20%) Management Information System
4 167 (4.08%) Data Structures
5 83 (2.03%) Clustering
6 81 (1.98%) Greenfield Project
6 81 (1.98%) Virtual Team
7 66 (1.61%) Enterprise Software
8 65 (1.59%) User Experience
9 59 (1.44%) Algorithms
10 56 (1.37%) Replication
11 47 (1.15%) Fintech
12 42 (1.03%) Life Science
13 40 (0.98%) Credit Risk
14 34 (0.83%) N-Tier
15 31 (0.76%) Client/Server
16 20 (0.49%) NHS
17 19 (0.46%) Analytical Mindset
18 17 (0.42%) Data Centre
18 17 (0.42%) Driving Licence
Operating Systems
1 275 (6.72%) Linux
2 183 (4.47%) Windows
3 176 (4.30%) Unix
4 54 (1.32%) Windows Server
5 48 (1.17%) AIX
6 41 (1.00%) Windows Server 2012
7 19 (0.46%) Windows Server 2008
8 17 (0.42%) Windows 7
9 12 (0.29%) Solaris
10 5 (0.12%) Apple iOS
11 4 (0.098%) Ubuntu
12 3 (0.073%) Android
12 3 (0.073%) CentOS
13 2 (0.049%) Mesosphere
13 2 (0.049%) Oracle Linux
13 2 (0.049%) Red Hat Enterprise Linux
13 2 (0.049%) Windows 10
13 2 (0.049%) Windows 8
13 2 (0.049%) Windows Server 2003
14 1 (0.024%) Embedded Linux
Processes & Methodologies
1 2,291 (55.95%) Business Intelligence
2 1,072 (26.18%) Agile Software Development
3 990 (24.18%) Analytics
4 876 (21.39%) Data Modelling
5 576 (14.07%) Data Management
6 551 (13.46%) Visualisation
7 412 (10.06%) Data Integration
8 402 (9.82%) Data Analysis
9 380 (9.28%) Performance Tuning
10 368 (8.99%) Migration
11 336 (8.21%) Data Visualisation
12 330 (8.06%) Kimball Methodology
13 321 (7.84%) SDLC
14 287 (7.01%) Scrum
15 284 (6.94%) ETL Development
16 273 (6.67%) Data Architecture
16 273 (6.67%) Stakeholder Management
17 271 (6.62%) Data Analytics
18 266 (6.50%) Data Governance
19 244 (5.96%) Project Management
Programming Languages
1 2,816 (68.77%) SQL
2 1,125 (27.47%) T-SQL
3 518 (12.65%) Java
4 502 (12.26%) Python
5 429 (10.48%) C#
6 244 (5.96%) PL/SQL
7 216 (5.27%) JavaScript
8 199 (4.86%) PowerShell
9 181 (4.42%) R
10 164 (4.00%) Scala
11 120 (2.93%) VBA
12 87 (2.12%) PHP
13 72 (1.76%) Data Analysis Expressions (DAX)
14 68 (1.66%) Shell Script
15 49 (1.20%) VB
16 44 (1.07%) Bash Shell
17 38 (0.93%) Perl
18 36 (0.88%) Apex Code
19 32 (0.78%) VB.NET
20 30 (0.73%) C
Qualifications
1 463 (11.31%) Degree
2 124 (3.03%) Computer Science Degree
3 82 (2.00%) Microsoft Certification
4 60 (1.47%) Security Cleared
5 36 (0.88%) MCSA
6 34 (0.83%) ISTQB
7 32 (0.78%) MCSE
8 28 (0.68%) ISEB
9 27 (0.66%) Master's Degree
10 23 (0.56%) SC Cleared
11 20 (0.49%) PMI Certification
12 19 (0.46%) Numerate Degree
13 18 (0.44%) PhD
14 17 (0.42%) MBA
15 16 (0.39%) ITIL Certification
16 9 (0.22%) CEH
16 9 (0.22%) CISSP
16 9 (0.22%) GCIH
16 9 (0.22%) MCP
16 9 (0.22%) OSCP
Quality Assurance & Compliance
1 418 (10.21%) Data Quality
2 218 (5.32%) QA
3 53 (1.29%) SLA
4 43 (1.05%) GDPR
5 20 (0.49%) GCP
6 18 (0.44%) ISO/IEC 27001
7 15 (0.37%) MiFID
8 14 (0.34%) EMIR
9 13 (0.32%) CRD IV
10 9 (0.22%) GPG13
10 9 (0.22%) PMO
11 7 (0.17%) Actionable Recommendations
12 2 (0.049%) BS7666
12 2 (0.049%) COBIT
12 2 (0.049%) GxP
12 2 (0.049%) HL7
12 2 (0.049%) IFRS
12 2 (0.049%) IFRS 9
12 2 (0.049%) PCI DSS
12 2 (0.049%) Solvency II
System Software
1 71 (1.73%) HDFS
2 55 (1.34%) Active Directory
2 55 (1.34%) Docker
3 49 (1.20%) Apache Flume
4 20 (0.49%) VMware Infrastructure
5 9 (0.22%) Snort
6 8 (0.20%) Virtual Machines
7 5 (0.12%) Apache ZooKeeper
7 5 (0.12%) Hyper-V
8 3 (0.073%) Firmware
8 3 (0.073%) Virtual Servers
9 2 (0.049%) MapR-FS
9 2 (0.049%) Oracle RAC
9 2 (0.049%) Terminal Services
10 1 (0.024%) Microsoft Virtual Server
Systems Management
1 29 (0.71%) Oozie
2 26 (0.63%) Oracle Enterprise Manager
3 25 (0.61%) SCCM
4 24 (0.59%) Puppet
5 21 (0.51%) Opscode Chef
6 19 (0.46%) Ambari
6 19 (0.46%) Hadoop YARN
7 18 (0.44%) Terraform
8 16 (0.39%) HP Quality Center
9 12 (0.29%) ZABBIX
10 11 (0.27%) Systems Management Server (SMS)
11 10 (0.24%) SCOM
12 9 (0.22%) Ansible
12 9 (0.22%) Suricata
13 6 (0.15%) Failover Clustering
13 6 (0.15%) Marathon
13 6 (0.15%) Mesos
14 5 (0.12%) Microsoft Clustering
14 5 (0.12%) Oracle Identity Manager
14 5 (0.12%) SCOrch
Vendors
1 1,272 (31.06%) Microsoft
2 792 (19.34%) Oracle
3 639 (15.60%) Tableau
4 370 (9.04%) Informatica
5 364 (8.89%) SAP
6 261 (6.37%) Cognos
7 241 (5.89%) Talend
8 147 (3.59%) IBM
9 145 (3.54%) Google
10 137 (3.35%) Teradata
11 126 (3.08%) MicroStrategy
12 119 (2.91%) Salesforce.com
13 105 (2.56%) Alteryx
14 99 (2.42%) Cloudera
15 82 (2.00%) Ab Initio
16 75 (1.83%) Netezza
17 64 (1.56%) Hortonworks
18 48 (1.17%) webMethods
19 40 (0.98%) Vertica
20 35 (0.85%) Twitter