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

Extract, Transform and Load (ETL)
UK
6 months to
20 Jul 2018
Same period 2017 Same period 2016
Rank 132 141 129
Rank change year-on-year +9 -12 -1
Permanent jobs citing ETL 4,390 4,385 5,235
As % of all permanent IT jobs advertised in the UK 2.51% 2.47% 2.58%
As % of the Processes & Methodologies category 2.77% 2.73% 2.87%
Number of salaries quoted 3,549 3,508 4,253
UK median annual salary £52,500 £50,000 £52,500
Median salary % change year-on-year +5.00% -4.76% -
10th Percentile £35,000 £32,500 £35,000
90th Percentile £82,500 £76,400 £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 158,731 160,892 182,711
As % of all permanent IT jobs advertised in the UK 90.67% 90.74% 90.02%
Number of salaries quoted 126,853 129,433 151,996
UK median annual salary £50,000 £49,500 £47,500
Median salary % change year-on-year +1.01% +4.21% -
10th Percentile £29,000 £28,000 £27,500
90th Percentile £82,500 £80,000 £77,500
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +1.19%

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 July 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 20 July 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 +13 4,105 £52,500 +5.00% 564
London +25 2,301 £60,000 +4.35% 280
UK excluding London -20 1,966 £45,000 - 309
South East +4 556 £50,000 -7.41% 83
North of England -5 518 £45,000 +5.88% 102
Midlands -27 282 £45,000 +5.88% 56
North West -15 276 £45,000 +12.50% 57
South West -10 219 £45,000 +12.50% 22
Yorkshire -3 218 £45,000 - 32
East of England -50 199 £45,000 - 20
West Midlands +19 192 £50,000 +25.00% 28
Scotland -21 158 £43,750 -2.78% 20
East Midlands -36 90 £42,500 -5.56% 28
Wales -5 57 £42,000 -6.67% 4
North East -9 24 £37,500 -44.44% 13
Northern Ireland -17 3 £30,000 -20.00% 2

For the 6 months to 20 July 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 3,025 (68.91%) SQL
2 2,315 (52.73%) Business Intelligence
3 2,157 (49.13%) Data Warehouse
4 2,126 (48.43%) SQL Server
5 1,859 (42.35%) SQL Server Integration Services
6 1,382 (31.48%) SQL Server Reporting Services
7 1,370 (31.21%) Microsoft
8 1,301 (29.64%) Agile Software Development
9 1,282 (29.20%) Analytics
10 1,135 (25.85%) T-SQL
11 1,094 (24.92%) Finance
12 1,036 (23.60%) SQL Server Analysis Services
13 935 (21.30%) Data Modelling
14 933 (21.25%) Big Data
15 871 (19.84%) Power BI
16 830 (18.91%) Oracle
17 765 (17.43%) Python
18 690 (15.72%) Hadoop
19 664 (15.13%) Java
20 656 (14.94%) Microsoft Azure
21 630 (14.35%) Tableau
22 615 (14.01%) Relational Database
23 576 (13.12%) Analytical Skills
24 556 (12.67%) Visualisation
25 533 (12.14%) C#
26 527 (12.00%) Amazon AWS
27 504 (11.48%) Problem-Solving
28 492 (11.21%) Apache Spark
29 488 (11.12%) Degree
30 470 (10.71%) .NET

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 492 (11.21%) Apache Spark
2 240 (5.47%) SAS
3 148 (3.37%) Apache
4 111 (2.53%) Elasticsearch
5 107 (2.44%) SharePoint
6 78 (1.78%) Apache Pig
7 63 (1.44%) Confluence
8 47 (1.07%) IIS
9 41 (0.93%) BizTalk Server
10 36 (0.82%) Oracle SOA Suite
11 34 (0.77%) Tomcat
12 30 (0.68%) CMS
13 28 (0.64%) Apache Solr
14 22 (0.50%) WebSphere
15 16 (0.36%) JBoss
16 14 (0.32%) Hyperledger
16 14 (0.32%) WebLogic
17 13 (0.30%) NServiceBus
17 13 (0.30%) Oracle Workflow
18 11 (0.25%) Oracle Application Server
Applications
1 376 (8.56%) Microsoft Excel
2 83 (1.89%) Microsoft Office
3 68 (1.55%) MS Visio
4 37 (0.84%) Spreadsheet
5 28 (0.64%) SPSS
6 22 (0.50%) Microsoft PowerPoint
6 22 (0.50%) Microsoft Project
7 3 (0.068%) Stata
8 2 (0.046%) Chatbot
9 1 (0.023%) SPSS Modeler
Business Applications
1 63 (1.44%) Cognos Business Intelligence
2 54 (1.23%) Cognos TM1
3 49 (1.12%) Dynamics CRM
4 41 (0.93%) Markit EDM
5 25 (0.57%) Dynamics AX
6 16 (0.36%) BusinessWare
6 16 (0.36%) NetSuite
7 12 (0.27%) Dynamics NAV
8 11 (0.25%) Oracle EBS
8 11 (0.25%) Oracle EBS R12
8 11 (0.25%) Oracle Financials
9 10 (0.23%) HFM
10 9 (0.21%) Maximo
10 9 (0.21%) PeopleSoft HCM
11 8 (0.18%) FastStats
11 8 (0.18%) Oracle Receivables
12 6 (0.14%) Salesforce.com CRM
12 6 (0.14%) SAP BPC
12 6 (0.14%) SAP S/4HANA
13 5 (0.11%) PeopleSoft CRM
Cloud Services
1 656 (14.94%) Microsoft Azure
2 527 (12.00%) Amazon AWS
3 107 (2.44%) Google Cloud Platform
4 104 (2.37%) Amazon EMR
5 80 (1.82%) Azure Data Factory
6 66 (1.50%) Amazon Kinesis
7 62 (1.41%) Amazon S3
8 61 (1.39%) SaaS
9 54 (1.23%) Serverless
10 49 (1.12%) GitHub
11 48 (1.09%) AWS Lambda
12 47 (1.07%) Cloud Computing
13 43 (0.98%) Amazon EC2
14 34 (0.77%) PaaS
15 29 (0.66%) Google Analytics
16 28 (0.64%) Office 365
17 25 (0.57%) Force.com
17 25 (0.57%) IaaS
18 23 (0.52%) IBM Cloud
19 14 (0.32%) Dynamics 365
Communications & Networking
1 22 (0.50%) SMS
2 20 (0.46%) Internet
3 14 (0.32%) HTTP
3 14 (0.32%) Kerberos
4 11 (0.25%) Firewall
4 11 (0.25%) SAN
5 7 (0.16%) FTP
6 6 (0.14%) DNS
7 5 (0.11%) MQTT
8 4 (0.091%) TCP/IP
9 3 (0.068%) 3G
9 3 (0.068%) 4G
9 3 (0.068%) Intranet
10 2 (0.046%) Extranet
10 2 (0.046%) Reverse Proxy
10 2 (0.046%) Wi-Fi
11 1 (0.023%) AMQP
11 1 (0.023%) IP Telephony
11 1 (0.023%) Network Security
11 1 (0.023%) SSH
Database & Business Intelligence
1 2,157 (49.13%) Data Warehouse
2 2,126 (48.43%) SQL Server
3 1,859 (42.35%) SQL Server Integration Services
4 1,382 (31.48%) SQL Server Reporting Services
5 1,036 (23.60%) SQL Server Analysis Services
6 933 (21.25%) Big Data
7 871 (19.84%) Power BI
8 690 (15.72%) Hadoop
9 615 (14.01%) Relational Database
10 323 (7.36%) NoSQL
11 315 (7.18%) OLAP
12 305 (6.95%) Apache Hive
13 302 (6.88%) SQL Server 2012
14 279 (6.36%) QlikView
15 252 (5.74%) SQL Server 2008
16 248 (5.65%) MySQL
17 247 (5.63%) RDBMS
18 236 (5.38%) BusinessObjects
19 208 (4.74%) SQL Server 2016
20 200 (4.56%) Amazon Redshift
Development Applications
1 170 (3.87%) Visual Studio
2 169 (3.85%) Git (software)
3 159 (3.62%) JIRA
4 143 (3.26%) Team Foundation Server
5 131 (2.98%) Jenkins
6 106 (2.41%) SQL Server Management Studio (SSMS)
7 58 (1.32%) Subversion
8 48 (1.09%) Selenium
9 39 (0.89%) Octopus Deploy
10 38 (0.87%) TeamCity
11 36 (0.82%) Cucumber
12 35 (0.80%) ERwin
13 33 (0.75%) Visual Studio Team System
14 31 (0.71%) Bitbucket
15 23 (0.52%) SoapUI
16 21 (0.48%) JUnit
16 21 (0.48%) Oracle APEX
17 20 (0.46%) Atlassian Bamboo
17 20 (0.46%) Maven
17 20 (0.46%) Mercurial
General
1 1,094 (24.92%) Finance
2 280 (6.38%) Retail
3 260 (5.92%) Banking
4 243 (5.54%) Advertising
5 207 (4.72%) Marketing
6 80 (1.82%) Games
7 76 (1.73%) Legal
8 57 (1.30%) Manufacturing
9 56 (1.28%) Telecoms
10 47 (1.07%) Investment Banking
11 37 (0.84%) Law
11 37 (0.84%) Pharmaceutical
12 36 (0.82%) Billing
13 31 (0.71%) Back Office
14 27 (0.62%) Front Office
15 26 (0.59%) Publishing
16 25 (0.57%) Electronics
17 19 (0.43%) Financial Institution
18 11 (0.25%) Automotive
19 10 (0.23%) General Ledger
Job Titles
1 1,932 (44.01%) Developer
2 762 (17.36%) Business Intelligence Developer
3 621 (14.15%) Analyst
4 614 (13.99%) SQL Developer
5 497 (11.32%) Data Engineer
6 337 (7.68%) Consultant
7 336 (7.65%) Architect
8 303 (6.90%) ETL Developer
9 282 (6.42%) SSIS Developer
10 232 (5.28%) Senior Developer
11 221 (5.03%) Data Warehouse Developer
12 207 (4.72%) SQL BI Developer
13 200 (4.56%) Business Intelligence Analyst
14 197 (4.49%) SSRS Developer
15 190 (4.33%) Business Developer
16 177 (4.03%) Data Architect
17 176 (4.01%) DBA
18 173 (3.94%) Data Analyst
19 162 (3.69%) Big Data Engineer
20 148 (3.37%) Database Developer
Libraries, Frameworks & Software Standards
1 470 (10.71%) .NET
2 323 (7.36%) XML
3 305 (6.95%) Web Services
4 301 (6.86%) Kafka
5 146 (3.33%) HTML
6 142 (3.23%) MDX
7 120 (2.73%) JSON
8 110 (2.51%) Middleware
8 110 (2.51%) REST
9 103 (2.35%) SOAP
10 74 (1.69%) ASP.NET
11 72 (1.64%) AngularJS
12 67 (1.53%) RabbitMQ
13 63 (1.44%) .NET Framework
14 61 (1.39%) RESTful
14 61 (1.39%) WCF
15 60 (1.37%) Pandas
16 58 (1.32%) Node.js
17 50 (1.14%) NumPy
18 48 (1.09%) ASP.NET Web API
Miscellaneous
1 576 (13.12%) Analytical Skills
2 249 (5.67%) Computer Science
3 230 (5.24%) Management Information System
4 171 (3.90%) Greenfield Project
5 151 (3.44%) Fintech
6 125 (2.85%) Self-Motivation
7 122 (2.78%) Data Structures
8 103 (2.35%) Enterprise Software
9 100 (2.28%) Algorithms
10 92 (2.10%) Replication
11 62 (1.41%) Clustering
12 50 (1.14%) User Experience
13 48 (1.09%) Tandem
14 47 (1.07%) Life Science
15 43 (0.98%) Credit Risk
16 41 (0.93%) Virtual Team
17 35 (0.80%) Data Centre
18 34 (0.77%) Reinsurance
19 33 (0.75%) Fixed Income
20 31 (0.71%) Market Risk
Operating Systems
1 309 (7.04%) Linux
2 214 (4.87%) Unix
3 166 (3.78%) Windows
4 59 (1.34%) AIX
5 55 (1.25%) Windows Server
6 37 (0.84%) Solaris
7 31 (0.71%) HPUX
8 27 (0.62%) Windows Server 2012
9 23 (0.52%) CentOS
10 13 (0.30%) Windows Server 2008
11 12 (0.27%) Ubuntu
12 10 (0.23%) Red Hat Enterprise Linux
13 6 (0.14%) Windows Server 2003
14 5 (0.11%) Amazon Linux
14 5 (0.11%) Apple iOS
14 5 (0.11%) Oracle Linux
15 2 (0.046%) VMS
15 2 (0.046%) Windows 7
16 1 (0.023%) Android
Processes & Methodologies
1 2,315 (52.73%) Business Intelligence
2 1,301 (29.64%) Agile Software Development
3 1,282 (29.20%) Analytics
4 935 (21.30%) Data Modelling
5 556 (12.67%) Visualisation
6 504 (11.48%) Problem-Solving
7 452 (10.30%) Data Management
8 430 (9.79%) Data Integration
9 425 (9.68%) Data Analysis
10 393 (8.95%) Performance Tuning
11 389 (8.86%) Migration
12 384 (8.75%) Data Science
13 344 (7.84%) Kimball Methodology
14 329 (7.49%) Data Analytics
15 320 (7.29%) Data Visualisation
16 307 (6.99%) Scrum
17 293 (6.67%) ETL Development
18 292 (6.65%) Project Management
19 284 (6.47%) Machine Learning
20 266 (6.06%) Data Architecture
Programming Languages
1 3,025 (68.91%) SQL
2 1,135 (25.85%) T-SQL
3 765 (17.43%) Python
4 664 (15.13%) Java
5 533 (12.14%) C#
6 279 (6.36%) R
7 257 (5.85%) Scala
8 247 (5.63%) PL/SQL
9 210 (4.78%) PowerShell
10 188 (4.28%) JavaScript
11 128 (2.92%) VBA
12 121 (2.76%) Data Analysis Expressions (DAX)
13 88 (2.00%) Shell Script
14 83 (1.89%) Perl
15 65 (1.48%) PHP
16 63 (1.44%) C++
17 48 (1.09%) VB
18 47 (1.07%) Bash Shell
19 45 (1.03%) C
20 41 (0.93%) VB.NET
Qualifications
1 488 (11.12%) Degree
2 99 (2.26%) Security Cleared
3 90 (2.05%) Computer Science Degree
4 54 (1.23%) Microsoft Certification
5 52 (1.18%) ISEB
6 49 (1.12%) SC Cleared
7 40 (0.91%) Master's Degree
8 33 (0.75%) Numerate Degree
9 25 (0.57%) Postgraduate
10 23 (0.52%) PMI Certification
11 19 (0.43%) ITIL Certification
11 19 (0.43%) PMP
12 16 (0.36%) ISTQB
13 15 (0.34%) Microsoft Certified Architect
14 14 (0.32%) HND
14 14 (0.32%) MCITP
14 14 (0.32%) TOGAF Certification
15 12 (0.27%) MCSE
16 11 (0.25%) PhD
17 10 (0.23%) MCSA
Quality Assurance & Compliance
1 450 (10.25%) Data Quality
2 223 (5.08%) QA
3 100 (2.28%) GDPR
4 22 (0.50%) GCP
5 21 (0.48%) SLA
6 17 (0.39%) Sarbanes-Oxley
7 13 (0.30%) PMO
8 9 (0.21%) COBIT
9 8 (0.18%) PCI DSS
10 7 (0.16%) IFRS
11 6 (0.14%) Actionable Recommendations
11 6 (0.14%) GxP
11 6 (0.14%) HL7
11 6 (0.14%) IFRS 9
12 4 (0.091%) ISO/IEC 27001
12 4 (0.091%) Solvency II
13 3 (0.068%) Dodd-Frank
13 3 (0.068%) EMIR
13 3 (0.068%) MiFID
14 2 (0.046%) ISO/IEC 20000
System Software
1 152 (3.46%) HDFS
2 119 (2.71%) Docker
3 77 (1.75%) Apache Flume
4 23 (0.52%) Active Directory
5 16 (0.36%) VirtualBox
6 15 (0.34%) Virtual Machines
7 9 (0.21%) Apache ZooKeeper
8 3 (0.068%) Hyper-V
9 1 (0.023%) Oracle RAC
9 1 (0.023%) Squid
9 1 (0.023%) VMware Infrastructure
Systems Management
1 84 (1.91%) Oozie
2 55 (1.25%) Kubernetes
3 48 (1.09%) Puppet
4 47 (1.07%) Ansible
5 36 (0.82%) Terraform
6 35 (0.80%) Hadoop YARN
7 26 (0.59%) Docker Swarm
8 25 (0.57%) Systems Management Server (SMS)
9 23 (0.52%) Kibana
10 19 (0.43%) Mesos
10 19 (0.43%) Opscode Chef
11 18 (0.41%) Ambari
12 17 (0.39%) Automic
12 17 (0.39%) Dollar Universe
13 14 (0.32%) Single Sign-On
14 13 (0.30%) Grafana
14 13 (0.30%) logstash
14 13 (0.30%) Prometheus
15 12 (0.27%) Data Guard
16 10 (0.23%) Control-M
Vendors
1 1,370 (31.21%) Microsoft
2 830 (18.91%) Oracle
3 630 (14.35%) Tableau
4 460 (10.48%) Informatica
5 350 (7.97%) Talend
6 242 (5.51%) SAP
7 190 (4.33%) IBM
8 183 (4.17%) Cognos
9 174 (3.96%) Cloudera
10 173 (3.94%) Google
11 107 (2.44%) Hortonworks
12 105 (2.39%) Salesforce.com
13 83 (1.89%) Alteryx
14 75 (1.71%) MicroStrategy
15 64 (1.46%) Teradata
16 61 (1.39%) Ab Initio
17 58 (1.32%) MuleSoft
18 53 (1.21%) webMethods
19 51 (1.16%) Netezza
20 45 (1.03%) Sybase