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

Extract, Transform and Load (ETL)
UK
6 months to
21 Apr 2018
Same period 2017 Same period 2016
Rank 136 139 113
Rank change year-on-year +3 -26 +16
Permanent jobs citing ETL 4,326 4,120 5,763
As % of all permanent IT jobs advertised in the UK 2.44% 2.41% 2.82%
As % of the Processes & Methodologies category 2.68% 2.66% 3.13%
Number of salaries quoted 3,535 3,413 4,742
UK median annual salary £52,500 £50,000 £50,000
Median salary % change year-on-year +5.00% - -4.76%
10th Percentile £34,200 £32,500 £33,500
90th Percentile £81,250 £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 161,258 154,906 183,888
As % of all permanent IT jobs advertised in the UK 90.84% 90.43% 89.94%
Number of salaries quoted 130,650 127,515 152,786
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £29,127 £27,875 £27,500
90th Percentile £81,250 £78,750 £77,500
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +5.66%

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 April 2018.

Salary histogram for ETL in the UK

ETL
Top 16 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 April 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 +7 4,030 £52,500 +5.00% 439
London +14 2,110 £60,000 +4.35% 214
UK excluding London -6 2,107 £45,000 - 249
North of England +9 569 £45,000 +12.50% 49
South East -26 544 £50,000 -7.41% 64
Midlands -14 312 £47,500 +11.76% 53
Yorkshire +40 273 £45,000 +5.88% 17
North West -21 272 £45,000 +20.00% 27
South West +22 262 £40,000 -5.88% 32
West Midlands +30 236 £50,000 +18.69% 34
East of England -60 215 £49,000 +3.16% 24
Scotland -13 163 £42,500 -5.56% 24
East Midlands -60 75 £42,500 -10.53% 19
Wales -19 51 £37,500 -6.25% 2
North East -14 24 £35,500 -21.11% 5
Northern Ireland -3 4 £33,750 -11.76% 1

For the 6 months to 21 April 2018, IT jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads with a requirement for ETL.

1 2,903 (67.11%) SQL
2 2,418 (55.89%) Business Intelligence
3 2,159 (49.91%) Data Warehouse
4 2,071 (47.87%) SQL Server
5 1,792 (41.42%) SQL Server Integration Services
6 1,329 (30.72%) SQL Server Reporting Services
7 1,318 (30.47%) Microsoft
8 1,211 (27.99%) Analytics
9 1,141 (26.38%) Agile Software Development
10 1,107 (25.59%) T-SQL
11 1,043 (24.11%) SQL Server Analysis Services
12 1,020 (23.58%) Finance
13 932 (21.54%) Data Modelling
14 818 (18.91%) Big Data
15 781 (18.05%) Power BI
16 761 (17.59%) Oracle
17 660 (15.26%) Python
18 640 (14.79%) Tableau
19 614 (14.19%) Hadoop
20 598 (13.82%) Java
21 588 (13.59%) Microsoft Azure
22 549 (12.69%) Analytical Skills
23 533 (12.32%) Visualisation
24 508 (11.74%) Amazon AWS
25 487 (11.26%) Relational Database
26 481 (11.12%) Degree
27 465 (10.75%) Data Management
27 465 (10.75%) C#
28 453 (10.47%) Apache Spark
29 438 (10.12%) Problem-Solving

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 453 (10.47%) Apache Spark
2 247 (5.71%) SAS
3 144 (3.33%) Apache
4 138 (3.19%) Elasticsearch
5 76 (1.76%) SharePoint
6 70 (1.62%) Apache Pig
7 54 (1.25%) Tomcat
8 53 (1.23%) Apache Solr
9 50 (1.16%) Confluence
10 37 (0.86%) IIS
11 28 (0.65%) Oracle SOA Suite
12 22 (0.51%) BizTalk Server
13 21 (0.49%) Drupal
14 18 (0.42%) WebSphere
15 16 (0.37%) Apache Airflow
15 16 (0.37%) WebLogic
16 15 (0.35%) JBoss
16 15 (0.35%) Oracle Workflow
17 9 (0.21%) CMS
18 8 (0.18%) Luigi
Applications
1 309 (7.14%) Microsoft Excel
2 77 (1.78%) Microsoft Office
3 63 (1.46%) SPSS
4 60 (1.39%) MS Visio
5 32 (0.74%) Microsoft PowerPoint
6 28 (0.65%) Microsoft Project
7 13 (0.30%) Spreadsheet
8 3 (0.069%) Chatbot
9 1 (0.023%) SPSS Modeler
9 1 (0.023%) Weka
Business Applications
1 35 (0.81%) Dynamics CRM
2 34 (0.79%) Cognos Business Intelligence
3 32 (0.74%) Cognos TM1
4 29 (0.67%) Dynamics AX
4 29 (0.67%) Markit EDM
5 28 (0.65%) BusinessWare
6 23 (0.53%) NetSuite
7 21 (0.49%) Oracle EBS
8 19 (0.44%) Oracle EBS R12
9 16 (0.37%) Oracle Receivables
10 13 (0.30%) Eagle PACE
11 11 (0.25%) Maximo
11 11 (0.25%) Salesforce.com CRM
12 10 (0.23%) Oracle Applications
13 9 (0.21%) Oracle Assets
13 9 (0.21%) Oracle Payables
14 8 (0.18%) Oracle ERP
15 7 (0.16%) Oracle Financials
15 7 (0.16%) Relativity
16 5 (0.12%) Oracle 11i
Cloud Services
1 588 (13.59%) Microsoft Azure
2 508 (11.74%) Amazon AWS
3 120 (2.77%) Google Cloud Platform
4 86 (1.99%) Amazon EMR
5 79 (1.83%) GitHub
6 75 (1.73%) Amazon Kinesis
7 60 (1.39%) Azure Data Factory
8 55 (1.27%) Amazon S3
9 52 (1.20%) Cloud Computing
10 45 (1.04%) Serverless
11 44 (1.02%) Force.com
12 41 (0.95%) SaaS
13 36 (0.83%) AWS Lambda
14 24 (0.55%) IaaS
15 22 (0.51%) Google Analytics
16 21 (0.49%) Amazon EC2
16 21 (0.49%) PaaS
17 20 (0.46%) Office 365
18 17 (0.39%) Azure Machine Learning
19 14 (0.32%) IBM Cloud
Communications & Networking
1 23 (0.53%) Firewall
2 18 (0.42%) SMS
3 14 (0.32%) HTTP
3 14 (0.32%) Kerberos
4 11 (0.25%) Internet
5 9 (0.21%) Ethernet
5 9 (0.21%) Sourcefire
5 9 (0.21%) Wireless
6 8 (0.18%) FTP
7 7 (0.16%) AMQP
8 6 (0.14%) DNS
9 5 (0.12%) Network Security
10 4 (0.092%) SAN
11 3 (0.069%) MQTT
11 3 (0.069%) SSL
12 2 (0.046%) 4G
12 2 (0.046%) Cisco ASA
12 2 (0.046%) IP Telephony
12 2 (0.046%) VPN
12 2 (0.046%) WAN
Database & Business Intelligence
1 2,159 (49.91%) Data Warehouse
2 2,071 (47.87%) SQL Server
3 1,792 (41.42%) SQL Server Integration Services
4 1,329 (30.72%) SQL Server Reporting Services
5 1,043 (24.11%) SQL Server Analysis Services
6 818 (18.91%) Big Data
7 781 (18.05%) Power BI
8 614 (14.19%) Hadoop
9 487 (11.26%) Relational Database
10 346 (8.00%) QlikView
11 312 (7.21%) NoSQL
12 310 (7.17%) OLAP
13 285 (6.59%) BusinessObjects
14 261 (6.03%) SQL Server 2012
15 249 (5.76%) Apache Hive
16 233 (5.39%) MySQL
17 224 (5.18%) RDBMS
18 222 (5.13%) Amazon Redshift
19 204 (4.72%) SQL Server 2016
20 200 (4.62%) SQL Server 2008
Development Applications
1 165 (3.81%) JIRA
2 147 (3.40%) Team Foundation Server
3 131 (3.03%) SQL Server Management Studio (SSMS)
3 131 (3.03%) Visual Studio
4 128 (2.96%) Git (software)
5 105 (2.43%) Jenkins
6 58 (1.34%) Selenium
6 58 (1.34%) Subversion
7 45 (1.04%) Cucumber
8 34 (0.79%) ERwin
9 31 (0.72%) TeamCity
10 26 (0.60%) Oracle Forms
11 25 (0.58%) Octopus Deploy
12 20 (0.46%) Maven
13 17 (0.39%) Oracle APEX
14 16 (0.37%) RStudio
15 14 (0.32%) Visual Studio Team System
16 13 (0.30%) gulp
17 12 (0.28%) Bitbucket
18 11 (0.25%) Mercurial
General
1 1,020 (23.58%) Finance
2 311 (7.19%) Retail
3 301 (6.96%) Advertising
4 196 (4.53%) Marketing
5 187 (4.32%) Banking
6 85 (1.96%) Legal
7 66 (1.53%) Manufacturing
8 61 (1.41%) Games
8 61 (1.41%) Telecoms
9 45 (1.04%) Law
10 43 (0.99%) Billing
10 43 (0.99%) Front Office
11 42 (0.97%) Pharmaceutical
12 40 (0.92%) Electronics
13 37 (0.86%) Investment Banking
14 27 (0.62%) Publishing
15 23 (0.53%) Back Office
16 22 (0.51%) Retail Banking
17 18 (0.42%) Corporate Banking
18 14 (0.32%) Automotive
Job Titles
1 1,810 (41.84%) Developer
2 766 (17.71%) Business Intelligence Developer
3 609 (14.08%) Analyst
4 554 (12.81%) SQL Developer
5 413 (9.55%) Architect
6 402 (9.29%) Data Engineer
7 327 (7.56%) Consultant
8 290 (6.70%) SSIS Developer
9 282 (6.52%) ETL Developer
10 235 (5.43%) Data Architect
11 216 (4.99%) SQL BI Developer
12 215 (4.97%) Senior Developer
13 204 (4.72%) SSRS Developer
14 199 (4.60%) Business Developer
15 195 (4.51%) DBA
16 182 (4.21%) Data Warehouse Developer
17 180 (4.16%) Business Intelligence Analyst
18 177 (4.09%) Data Analyst
19 146 (3.37%) SQL DBA
20 126 (2.91%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 422 (9.75%) .NET
2 279 (6.45%) Web Services
3 235 (5.43%) Kafka
4 228 (5.27%) XML
5 145 (3.35%) MDX
6 126 (2.91%) HTML
7 113 (2.61%) JSON
8 102 (2.36%) REST
9 95 (2.20%) SOAP
10 89 (2.06%) AngularJS
11 77 (1.78%) Middleware
12 75 (1.73%) ASP.NET
12 75 (1.73%) Pandas
13 56 (1.29%) RabbitMQ
14 52 (1.20%) .NET Framework
14 52 (1.20%) CSS
15 50 (1.16%) React
15 50 (1.16%) Spring
16 49 (1.13%) WPF
17 48 (1.11%) NumPy
Miscellaneous
1 549 (12.69%) Analytical Skills
2 233 (5.39%) Computer Science
3 210 (4.85%) Management Information System
4 192 (4.44%) Self-Motivation
5 132 (3.05%) Data Structures
6 118 (2.73%) Fintech
7 109 (2.52%) Algorithms
8 108 (2.50%) Greenfield Project
9 89 (2.06%) Clustering
10 88 (2.03%) Virtual Team
11 71 (1.64%) Replication
12 65 (1.50%) User Experience
13 59 (1.36%) Enterprise Software
14 49 (1.13%) Life Science
15 39 (0.90%) Credit Risk
16 29 (0.67%) Tandem
17 26 (0.60%) Hedge funds
18 24 (0.55%) Data Centre
18 24 (0.55%) PMI
19 23 (0.53%) Market Risk
Operating Systems
1 306 (7.07%) Linux
2 170 (3.93%) Unix
3 157 (3.63%) Windows
4 77 (1.78%) AIX
5 57 (1.32%) Windows Server
6 24 (0.55%) Windows Server 2012
7 22 (0.51%) Solaris
8 19 (0.44%) CentOS
9 18 (0.42%) HPUX
10 14 (0.32%) Windows Server 2008
11 7 (0.16%) Windows 7
12 6 (0.14%) Windows Server 2003
13 5 (0.12%) Amazon Linux
13 5 (0.12%) Ubuntu
14 4 (0.092%) Oracle Linux
14 4 (0.092%) Red Hat Enterprise Linux
15 1 (0.023%) Android
15 1 (0.023%) Embedded Linux
15 1 (0.023%) Mesosphere
15 1 (0.023%) VMS
Processes & Methodologies
1 2,418 (55.89%) Business Intelligence
2 1,211 (27.99%) Analytics
3 1,141 (26.38%) Agile Software Development
4 932 (21.54%) Data Modelling
5 533 (12.32%) Visualisation
6 465 (10.75%) Data Management
7 438 (10.12%) Problem-Solving
8 423 (9.78%) Data Integration
9 394 (9.11%) Data Analysis
10 359 (8.30%) Migration
11 349 (8.07%) Performance Tuning
12 338 (7.81%) Data Science
13 336 (7.77%) Data Visualisation
14 331 (7.65%) Kimball Methodology
15 325 (7.51%) Data Analytics
16 324 (7.49%) Scrum
17 290 (6.70%) Data Architecture
18 286 (6.61%) Data Governance
19 267 (6.17%) Project Management
20 263 (6.08%) Machine Learning
Programming Languages
1 2,903 (67.11%) SQL
2 1,107 (25.59%) T-SQL
3 660 (15.26%) Python
4 598 (13.82%) Java
5 465 (10.75%) C#
6 255 (5.89%) R
7 212 (4.90%) Scala
8 200 (4.62%) PowerShell
9 198 (4.58%) PL/SQL
10 152 (3.51%) JavaScript
11 110 (2.54%) Data Analysis Expressions (DAX)
12 101 (2.33%) VBA
13 87 (2.01%) PHP
14 70 (1.62%) Perl
14 70 (1.62%) Shell Script
15 53 (1.23%) Bash Shell
16 42 (0.97%) C++
17 40 (0.92%) Apex Code
18 39 (0.90%) VB
19 34 (0.79%) VB.NET
Qualifications
1 481 (11.12%) Degree
2 103 (2.38%) Computer Science Degree
3 67 (1.55%) Security Cleared
4 64 (1.48%) Microsoft Certification
5 39 (0.90%) Master's Degree
6 38 (0.88%) ISEB
7 37 (0.86%) PMI Certification
8 32 (0.74%) Numerate Degree
9 31 (0.72%) ISTQB
10 27 (0.62%) SC Cleared
11 25 (0.58%) ITIL Certification
12 22 (0.51%) TOGAF Certification
13 21 (0.49%) PhD
14 16 (0.37%) PMP
15 15 (0.35%) MCSE
16 14 (0.32%) MBA
17 13 (0.30%) HND
17 13 (0.30%) Microsoft Certified Architect
18 12 (0.28%) Postgraduate
19 10 (0.23%) MCSD
Quality Assurance & Compliance
1 403 (9.32%) Data Quality
2 212 (4.90%) QA
3 77 (1.78%) GDPR
4 27 (0.62%) SLA
5 22 (0.51%) GCP
6 18 (0.42%) ISO/IEC 27001
7 9 (0.21%) EMIR
7 9 (0.21%) GPG13
8 8 (0.18%) COBIT
8 8 (0.18%) MiFID
9 7 (0.16%) CRD IV
9 7 (0.16%) GxP
9 7 (0.16%) Sarbanes-Oxley
10 6 (0.14%) PCI DSS
11 5 (0.12%) IFRS
11 5 (0.12%) IFRS 9
11 5 (0.12%) PMO
11 5 (0.12%) Solvency II
12 4 (0.092%) Actionable Recommendations
13 3 (0.069%) Dodd-Frank
System Software
1 125 (2.89%) HDFS
2 102 (2.36%) Docker
3 89 (2.06%) Apache Flume
4 32 (0.74%) Active Directory
5 20 (0.46%) Virtual Machines
6 11 (0.25%) Apache ZooKeeper
7 9 (0.21%) Snort
8 8 (0.18%) VMware Infrastructure
9 7 (0.16%) VirtualBox
10 6 (0.14%) Hyper-V
11 2 (0.046%) Oracle RAC
12 1 (0.023%) MapR-FS
Systems Management
1 50 (1.16%) Oozie
2 43 (0.99%) Hadoop YARN
3 39 (0.90%) Puppet
4 32 (0.74%) Terraform
5 30 (0.69%) Ansible
6 26 (0.60%) Single Sign-On
7 24 (0.55%) Kubernetes
8 21 (0.49%) Ambari
9 18 (0.42%) Mesos
9 18 (0.42%) Opscode Chef
10 14 (0.32%) Systems Management Server (SMS)
11 13 (0.30%) Oracle Enterprise Manager
12 12 (0.28%) Docker Swarm
13 11 (0.25%) Oracle Identity Manager
14 10 (0.23%) Failover Clustering
15 9 (0.21%) Suricata
16 8 (0.18%) Control-M
17 7 (0.16%) SCCM
17 7 (0.16%) SCOM
17 7 (0.16%) SCOrch
Vendors
1 1,318 (30.47%) Microsoft
2 761 (17.59%) Oracle
3 640 (14.79%) Tableau
4 401 (9.27%) Informatica
5 308 (7.12%) Talend
6 270 (6.24%) SAP
7 208 (4.81%) Cognos
8 188 (4.35%) Google
9 171 (3.95%) IBM
10 163 (3.77%) Cloudera
11 119 (2.75%) Salesforce.com
12 97 (2.24%) Teradata
13 94 (2.17%) Hortonworks
14 93 (2.15%) Alteryx
14 93 (2.15%) MicroStrategy
15 92 (2.13%) Ab Initio
16 79 (1.83%) webMethods
17 74 (1.71%) Netezza
18 52 (1.20%) Capita
19 48 (1.11%) MuleSoft