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

Extract, Transform and Load (ETL)
UK
6 months to
23 Sep 2018
Same period 2017 Same period 2016
Rank 132 147 135
Rank change year-on-year +15 -12 -14
Permanent jobs citing ETL 4,145 4,275 4,873
As % of all permanent IT jobs advertised in the UK 2.51% 2.43% 2.51%
As % of the Processes & Methodologies category 2.75% 2.66% 2.76%
Number of salaries quoted 3,372 3,352 3,963
UK median annual salary £52,500 £50,000 £50,500
Median salary % change year-on-year +5.00% -0.99% -3.81%
10th Percentile £35,000 £32,500 £35,000
90th Percentile £82,500 £76,250 £77,500
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 150,479 160,844 176,344
As % of all permanent IT jobs advertised in the UK 91.03% 91.55% 90.89%
Number of salaries quoted 119,704 127,010 147,108
UK median annual salary £50,000 £50,000 £48,000
Median salary % change year-on-year - +4.17% +1.05%
10th Percentile £29,000 £28,250 £27,500
90th Percentile £82,500 £80,000 £78,750
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - -

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 23 September 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 23 September 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 +17 3,901 £52,500 +5.00% 512
London +22 2,176 £60,000 +9.09% 235
UK excluding London -12 1,859 £45,000 - 318
South East +15 540 £50,000 -4.76% 75
North of England -17 472 £45,000 +5.88% 84
Midlands -2 264 £45,000 +5.88% 50
North West -10 260 £45,000 +8.43% 47
East of England +9 230 £47,500 +5.56% 31
South West -23 189 £45,000 +12.50% 38
Yorkshire -22 179 £45,000 - 29
West Midlands +7 167 £45,000 +12.50% 23
Scotland -35 142 £45,000 - 32
East Midlands -10 96 £42,500 - 27
Wales -12 42 £37,500 -6.25% 4
North East +8 33 £38,750 -13.89% 8
Northern Ireland -9 2 £43,750 +16.67% 5

For the 6 months to 23 September 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,838 (68.47%) SQL
2 2,080 (50.18%) Business Intelligence
3 2,064 (49.79%) Data Warehouse
4 2,012 (48.54%) SQL Server
5 1,803 (43.50%) SQL Server Integration Services
6 1,361 (32.83%) SQL Server Reporting Services
7 1,314 (31.70%) Microsoft
8 1,281 (30.90%) Agile Software Development
9 1,162 (28.03%) Finance
10 1,135 (27.38%) Analytics
11 1,062 (25.62%) T-SQL
12 940 (22.68%) SQL Server Analysis Services
13 862 (20.80%) Big Data
14 849 (20.48%) Data Modelling
15 841 (20.29%) Power BI
16 786 (18.96%) Python
17 720 (17.37%) Oracle
18 700 (16.89%) Microsoft Azure
19 656 (15.83%) Tableau
20 605 (14.60%) Java
21 599 (14.45%) Hadoop
22 582 (14.04%) Analytical Skills
23 568 (13.70%) Visualisation
24 566 (13.66%) Relational Database
25 558 (13.46%) C#
26 495 (11.94%) Problem-Solving
27 487 (11.75%) Amazon AWS
28 476 (11.48%) .NET
29 467 (11.27%) Informatica
30 459 (11.07%) Degree

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 425 (10.25%) Apache Spark
2 213 (5.14%) SAS
3 142 (3.43%) Apache
4 113 (2.73%) SharePoint
5 98 (2.36%) Elasticsearch
6 68 (1.64%) Apache Pig
7 52 (1.25%) Confluence
8 47 (1.13%) IIS
9 34 (0.82%) BizTalk Server
9 34 (0.82%) CMS
10 28 (0.68%) Oracle SOA Suite
11 24 (0.58%) Tomcat
12 19 (0.46%) WebSphere
13 18 (0.43%) Apache Airflow
14 16 (0.39%) NServiceBus
15 14 (0.34%) Hyperledger
16 12 (0.29%) JBoss
17 10 (0.24%) WebLogic
18 9 (0.22%) Oracle Application Server
19 8 (0.19%) FileNet
Applications
1 382 (9.22%) Microsoft Excel
2 68 (1.64%) Microsoft Office
3 42 (1.01%) MS Visio
4 36 (0.87%) Microsoft PowerPoint
5 34 (0.82%) Spreadsheet
6 15 (0.36%) Microsoft Project
7 12 (0.29%) SPSS
8 3 (0.072%) Stata
9 2 (0.048%) InfoPath
Business Applications
1 67 (1.62%) Cognos Business Intelligence
1 67 (1.62%) Cognos TM1
2 58 (1.40%) Dynamics CRM
3 39 (0.94%) Markit EDM
4 38 (0.92%) Dynamics AX
5 18 (0.43%) Dynamics NAV
6 15 (0.36%) Oracle EBS
7 10 (0.24%) HFM
7 10 (0.24%) NetSuite
8 9 (0.22%) Oracle EBS R12
8 9 (0.22%) Salesforce.com CRM
9 8 (0.19%) FastStats
10 7 (0.17%) Oracle Financials
11 6 (0.14%) Oracle Retail
11 6 (0.14%) PeopleSoft HCM
11 6 (0.14%) SAP S/4HANA
12 5 (0.12%) Hyperion Planning
12 5 (0.12%) Maximo
12 5 (0.12%) Oracle Receivables
13 4 (0.097%) SAP BPC
Cloud Services
1 700 (16.89%) Microsoft Azure
2 487 (11.75%) Amazon AWS
3 91 (2.20%) Azure Data Factory
4 90 (2.17%) Amazon EMR
5 84 (2.03%) Google Cloud Platform
6 62 (1.50%) SaaS
7 60 (1.45%) Amazon S3
8 57 (1.38%) Amazon Kinesis
9 48 (1.16%) Serverless
10 43 (1.04%) AWS Lambda
11 40 (0.97%) PaaS
12 39 (0.94%) Amazon EC2
13 34 (0.82%) Google Analytics
14 33 (0.80%) Cloud Computing
15 29 (0.70%) Office 365
16 24 (0.58%) IaaS
17 22 (0.53%) Dynamics 365
18 19 (0.46%) IBM Cloud
19 17 (0.41%) GitHub
20 16 (0.39%) Data Lake Analytics
Communications & Networking
1 19 (0.46%) Internet
1 19 (0.46%) SMS
2 11 (0.27%) SAN
3 9 (0.22%) Kerberos
4 8 (0.19%) DNS
4 8 (0.19%) FTP
4 8 (0.19%) HTTP
5 7 (0.17%) Firewall
6 5 (0.12%) HTTPS
7 4 (0.097%) Extranet
7 4 (0.097%) Intranet
7 4 (0.097%) MQTT
7 4 (0.097%) TCP/IP
8 3 (0.072%) SSL
9 2 (0.048%) Broadband
9 2 (0.048%) DHCP
9 2 (0.048%) Reverse Proxy
9 2 (0.048%) SSH
9 2 (0.048%) Wi-Fi
10 1 (0.024%) 4G
Database & Business Intelligence
1 2,064 (49.79%) Data Warehouse
2 2,012 (48.54%) SQL Server
3 1,803 (43.50%) SQL Server Integration Services
4 1,361 (32.83%) SQL Server Reporting Services
5 940 (22.68%) SQL Server Analysis Services
6 862 (20.80%) Big Data
7 841 (20.29%) Power BI
8 599 (14.45%) Hadoop
9 566 (13.66%) Relational Database
10 294 (7.09%) NoSQL
11 280 (6.76%) Apache Hive
11 280 (6.76%) SQL Server 2012
12 276 (6.66%) OLAP
13 261 (6.30%) BusinessObjects
14 255 (6.15%) QlikView
15 242 (5.84%) SQL Server 2008
16 218 (5.26%) MySQL
17 192 (4.63%) SQL Server 2016
18 186 (4.49%) Amazon Redshift
19 181 (4.37%) PostgreSQL
Development Applications
1 184 (4.44%) Visual Studio
2 168 (4.05%) Git (software)
3 128 (3.09%) Team Foundation Server
4 124 (2.99%) JIRA
5 113 (2.73%) Jenkins
6 94 (2.27%) SQL Server Management Studio (SSMS)
7 51 (1.23%) Subversion
8 49 (1.18%) Visual Studio Team System
9 47 (1.13%) Octopus Deploy
10 41 (0.99%) TeamCity
11 36 (0.87%) SoapUI
12 34 (0.82%) Selenium
13 31 (0.75%) Bitbucket
14 22 (0.53%) Atlassian Bamboo
14 22 (0.53%) JUnit
15 20 (0.48%) Oracle APEX
16 19 (0.46%) ERwin
17 18 (0.43%) Eclipse
17 18 (0.43%) Hudson
17 18 (0.43%) NUnit
General
1 1,162 (28.03%) Finance
2 274 (6.61%) Banking
3 235 (5.67%) Retail
4 204 (4.92%) Advertising
5 173 (4.17%) Marketing
6 80 (1.93%) Games
7 63 (1.52%) Legal
8 58 (1.40%) Investment Banking
9 55 (1.33%) Manufacturing
10 48 (1.16%) Telecoms
11 40 (0.97%) Pharmaceutical
12 32 (0.77%) Publishing
13 31 (0.75%) Law
14 30 (0.72%) Back Office
15 21 (0.51%) Financial Institution
16 16 (0.39%) Electronics
17 14 (0.34%) Front Office
18 13 (0.31%) Local Government
19 12 (0.29%) Automotive
19 12 (0.29%) Music Industry
Job Titles
1 1,866 (45.02%) Developer
2 720 (17.37%) Business Intelligence Developer
3 634 (15.30%) SQL Developer
4 539 (13.00%) Analyst
5 501 (12.09%) Data Engineer
6 327 (7.89%) Consultant
7 292 (7.04%) Architect
7 292 (7.04%) ETL Developer
8 253 (6.10%) Senior Developer
9 234 (5.65%) SSIS Developer
10 225 (5.43%) Data Warehouse Developer
11 207 (4.99%) SQL BI Developer
12 199 (4.80%) Business Developer
13 174 (4.20%) Business Intelligence Analyst
14 170 (4.10%) Data Architect
15 168 (4.05%) Database Developer
16 163 (3.93%) DBA
17 157 (3.79%) SSRS Developer
18 156 (3.76%) Big Data Engineer
19 154 (3.72%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 476 (11.48%) .NET
2 321 (7.74%) XML
3 307 (7.41%) Web Services
4 247 (5.96%) Kafka
5 142 (3.43%) HTML
6 128 (3.09%) JSON
7 119 (2.87%) MDX
8 102 (2.46%) SOAP
9 101 (2.44%) REST
10 89 (2.15%) Middleware
11 70 (1.69%) ASP.NET
11 70 (1.69%) RESTful
12 63 (1.52%) WCF
13 58 (1.40%) .NET Framework
14 56 (1.35%) ASP.NET Web API
15 55 (1.33%) Pandas
16 52 (1.25%) AngularJS
16 52 (1.25%) Node.js
17 49 (1.18%) NumPy
18 48 (1.16%) Flask
Miscellaneous
1 582 (14.04%) Analytical Skills
2 248 (5.98%) Computer Science
3 209 (5.04%) Management Information System
4 181 (4.37%) Greenfield Project
5 141 (3.40%) Data Structures
6 135 (3.26%) Fintech
7 80 (1.93%) Enterprise Software
8 79 (1.91%) Replication
9 69 (1.66%) Algorithms
10 60 (1.45%) Self-Motivation
11 56 (1.35%) Tandem
12 51 (1.23%) User Experience
13 47 (1.13%) Reinsurance
14 43 (1.04%) Life Science
15 42 (1.01%) Robotics
16 40 (0.97%) Fixed Income
16 40 (0.97%) Reference Data
17 39 (0.94%) Clustering
18 36 (0.87%) Credit Risk
18 36 (0.87%) Market Risk
Operating Systems
1 267 (6.44%) Linux
2 224 (5.40%) Unix
3 154 (3.72%) Windows
4 38 (0.92%) Windows Server
5 34 (0.82%) AIX
6 33 (0.80%) Solaris
7 31 (0.75%) HPUX
8 20 (0.48%) Windows Server 2012
9 12 (0.29%) Apple iOS
10 11 (0.27%) Windows Server 2008
11 9 (0.22%) CentOS
12 8 (0.19%) Red Hat Enterprise Linux
12 8 (0.19%) Ubuntu
13 4 (0.097%) Windows Server 2003
14 2 (0.048%) Debian
14 2 (0.048%) VMS
15 1 (0.024%) Android
15 1 (0.024%) Oracle Linux
Processes & Methodologies
1 2,080 (50.18%) Business Intelligence
2 1,281 (30.90%) Agile Software Development
3 1,135 (27.38%) Analytics
4 849 (20.48%) Data Modelling
5 568 (13.70%) Visualisation
6 495 (11.94%) Problem-Solving
7 437 (10.54%) Data Analysis
8 411 (9.92%) Data Integration
8 411 (9.92%) Data Management
9 400 (9.65%) Data Science
10 398 (9.60%) Migration
11 324 (7.82%) Data Visualisation
12 316 (7.62%) Kimball Methodology
13 313 (7.55%) Performance Tuning
14 308 (7.43%) ETL Development
15 296 (7.14%) Data Analytics
16 271 (6.54%) Scrum
17 255 (6.15%) Data Architecture
18 254 (6.13%) Project Management
19 248 (5.98%) Data Migration
Programming Languages
1 2,838 (68.47%) SQL
2 1,062 (25.62%) T-SQL
3 786 (18.96%) Python
4 605 (14.60%) Java
5 558 (13.46%) C#
6 240 (5.79%) Scala
7 223 (5.38%) JavaScript
8 222 (5.36%) PL/SQL
8 222 (5.36%) R
9 198 (4.78%) PowerShell
10 120 (2.90%) VBA
11 115 (2.77%) Data Analysis Expressions (DAX)
12 79 (1.91%) Shell Script
13 73 (1.76%) Perl
14 59 (1.42%) C
14 59 (1.42%) C++
15 55 (1.33%) Bash Shell
16 54 (1.30%) PHP
17 43 (1.04%) VB
18 41 (0.99%) Go
Qualifications
1 459 (11.07%) Degree
2 121 (2.92%) Security Cleared
3 86 (2.07%) Computer Science Degree
4 64 (1.54%) SC Cleared
5 49 (1.18%) ISEB
6 36 (0.87%) Microsoft Certification
7 33 (0.80%) Master's Degree
8 19 (0.46%) Postgraduate
9 18 (0.43%) PMP
10 17 (0.41%) Numerate Degree
11 16 (0.39%) PMI Certification
12 13 (0.31%) DV Cleared
13 12 (0.29%) Microsoft Certified Architect
14 11 (0.27%) AWS Certification
14 11 (0.27%) MCITP
14 11 (0.27%) PhD
15 9 (0.22%) ITIL Certification
16 7 (0.17%) ISTQB
16 7 (0.17%) MCP
16 7 (0.17%) MCSA
Quality Assurance & Compliance
1 409 (9.87%) Data Quality
2 214 (5.16%) QA
3 72 (1.74%) GDPR
4 21 (0.51%) SLA
5 13 (0.31%) ISO/IEC 27001
6 10 (0.24%) PMO
6 10 (0.24%) Sarbanes-Oxley
7 7 (0.17%) Actionable Recommendations
7 7 (0.17%) MiFID
8 5 (0.12%) IFRS
9 4 (0.097%) HL7
9 4 (0.097%) PCI DSS
9 4 (0.097%) Solvency II
10 3 (0.072%) Dodd-Frank
10 3 (0.072%) ISO 9001
11 2 (0.048%) COBIT
11 2 (0.048%) Cyber Essentials
11 2 (0.048%) IFRS 9
11 2 (0.048%) ISO/IEC 20000
12 1 (0.024%) Basel III
System Software
1 139 (3.35%) Docker
2 130 (3.14%) HDFS
3 43 (1.04%) Apache Flume
4 13 (0.31%) VirtualBox
5 12 (0.29%) Active Directory
6 3 (0.072%) Oracle RAC
6 3 (0.072%) VMware Infrastructure
7 2 (0.048%) Apache ZooKeeper
7 2 (0.048%) Virtual Machines
8 1 (0.024%) Hyper-V
8 1 (0.024%) Squid
8 1 (0.024%) Tivoli Workload Scheduler
8 1 (0.024%) VMware ESXi
Systems Management
1 83 (2.00%) Kubernetes
2 71 (1.71%) Oozie
3 39 (0.94%) Docker Swarm
4 37 (0.89%) Ansible
5 33 (0.80%) Puppet
5 33 (0.80%) Terraform
6 29 (0.70%) Kibana
7 26 (0.63%) Grafana
8 25 (0.60%) Prometheus
9 24 (0.58%) Systems Management Server (SMS)
10 23 (0.55%) Hadoop YARN
11 22 (0.53%) Opscode Chef
12 19 (0.46%) logstash
13 18 (0.43%) Automic
13 18 (0.43%) Dollar Universe
14 17 (0.41%) Mesos
15 11 (0.27%) Data Guard
15 11 (0.27%) Single Sign-On
16 10 (0.24%) Ambari
17 8 (0.19%) ZABBIX
Vendors
1 1,314 (31.70%) Microsoft
2 720 (17.37%) Oracle
3 656 (15.83%) Tableau
4 467 (11.27%) Informatica
5 272 (6.56%) Talend
6 234 (5.65%) SAP
7 226 (5.45%) Cognos
8 193 (4.66%) IBM
9 137 (3.31%) Google
10 134 (3.23%) Cloudera
11 116 (2.80%) Hortonworks
12 89 (2.15%) Salesforce.com
13 88 (2.12%) Alteryx
14 65 (1.57%) MicroStrategy
15 60 (1.45%) Teradata
16 46 (1.11%) Ab Initio
16 46 (1.11%) ServiceNow
17 43 (1.04%) Netezza
18 39 (0.94%) MuleSoft
19 38 (0.92%) Vertica