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

Extract, Transform and Load (ETL)
UK
6 months to
19 Nov 2018
Same period 2017 Same period 2016
Rank 136 142 137
Rank change year-on-year +6 -5 -24
Permanent jobs citing ETL 4,054 4,341 4,587
As % of all permanent IT jobs advertised in the UK 2.50% 2.43% 2.43%
As % of the Processes & Methodologies category 2.74% 2.66% 2.67%
Number of salaries quoted 3,317 3,417 3,804
UK median annual salary £55,000 £50,000 £51,000
Median salary % change year-on-year +10.00% -1.96% +2.00%
10th Percentile £35,721 £32,500 £34,500
90th Percentile £82,500 £75,000 £80,000
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 147,698 163,216 171,560
As % of all permanent IT jobs advertised in the UK 91.11% 91.49% 90.94%
Number of salaries quoted 117,431 129,024 142,667
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,615
90th Percentile £84,250 £80,000 £78,750
UK excluding London median annual salary £45,000 £43,000 £42,500
% change year-on-year +4.65% +1.18% -

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 19 November 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 19 November 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 +12 3,834 £55,000 +10.00% 577
London +21 2,113 £60,000 +9.09% 280
UK excluding London -2 1,879 £45,000 - 332
South East +10 551 £50,000 -4.76% 69
North of England -23 465 £45,000 +5.88% 93
Midlands -15 263 £45,000 +2.27% 56
North West -8 260 £45,000 +5.88% 45
East of England +18 227 £52,500 +10.53% 37
South West -14 209 £48,750 +21.88% 42
West Midlands -5 173 £45,000 - 39
Yorkshire -48 171 £42,500 - 39
Scotland -41 132 £45,000 - 31
East Midlands -2 89 £42,500 +6.25% 17
Wales +4 43 £40,000 - 3
North East +16 34 £39,250 -7.65% 9
Northern Ireland -2 7 £27,500 -31.25% 1
Channel Islands - 1 £37,500 -

For the 6 months to 19 November 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,762 (68.13%) SQL
2 2,083 (51.38%) Business Intelligence
3 2,076 (51.21%) Data Warehouse
4 1,987 (49.01%) SQL Server
5 1,775 (43.78%) SQL Server Integration Services
6 1,320 (32.56%) Agile Software Development
7 1,313 (32.39%) SQL Server Reporting Services
8 1,290 (31.82%) Microsoft
9 1,105 (27.26%) Finance
10 1,084 (26.74%) Analytics
11 1,026 (25.31%) T-SQL
12 940 (23.19%) Data Modelling
13 897 (22.13%) SQL Server Analysis Services
14 826 (20.37%) Big Data
15 817 (20.15%) Power BI
16 782 (19.29%) Microsoft Azure
17 773 (19.07%) Python
18 724 (17.86%) Oracle
19 665 (16.40%) Tableau
20 587 (14.48%) Analytical Skills
21 578 (14.26%) Relational Database
22 561 (13.84%) Java
23 558 (13.76%) C#
24 555 (13.69%) Visualisation
25 553 (13.64%) Hadoop
26 511 (12.60%) Amazon AWS
27 468 (11.54%) Problem-Solving
28 462 (11.40%) Data Analysis
29 461 (11.37%) Informatica
30 448 (11.05%) Data Management

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 394 (9.72%) Apache Spark
2 155 (3.82%) SAS
3 137 (3.38%) Apache
4 121 (2.98%) SharePoint
5 96 (2.37%) Elasticsearch
6 58 (1.43%) Apache Pig
7 46 (1.13%) Confluence
8 30 (0.74%) CMS
8 30 (0.74%) IIS
9 27 (0.67%) Oracle SOA Suite
10 22 (0.54%) Apache Airflow
11 19 (0.47%) BizTalk Server
12 18 (0.44%) Tomcat
13 17 (0.42%) WebSphere
14 15 (0.37%) Apache Solr
14 15 (0.37%) WebLogic
15 14 (0.35%) Hyperledger
15 14 (0.35%) NServiceBus
15 14 (0.35%) Oracle Workflow
16 8 (0.20%) nginx
Applications
1 398 (9.82%) Microsoft Excel
2 71 (1.75%) Microsoft Office
3 35 (0.86%) Microsoft PowerPoint
3 35 (0.86%) MS Visio
4 27 (0.67%) Spreadsheet
5 11 (0.27%) Microsoft Project
5 11 (0.27%) SPSS
6 3 (0.074%) Stata
7 2 (0.049%) Chatbot
7 2 (0.049%) InfoPath
Business Applications
1 62 (1.53%) Dynamics CRM
2 54 (1.33%) Cognos Business Intelligence
3 53 (1.31%) Cognos TM1
4 42 (1.04%) Dynamics AX
5 25 (0.62%) Markit EDM
6 21 (0.52%) Dynamics NAV
7 12 (0.30%) Oracle EBS
8 11 (0.27%) FastStats
9 10 (0.25%) NetSuite
10 7 (0.17%) HFM
11 6 (0.15%) Oracle EBS R12
11 6 (0.15%) Oracle Retail
12 5 (0.12%) SAP HR
12 5 (0.12%) SAP S/4HANA
13 4 (0.099%) Actimize
13 4 (0.099%) FastStats PeopleStage
13 4 (0.099%) Hyperion Planning
13 4 (0.099%) Maximo
13 4 (0.099%) Misys Opics
13 4 (0.099%) Oracle Financials
Cloud Services
1 782 (19.29%) Microsoft Azure
2 511 (12.60%) Amazon AWS
3 111 (2.74%) Azure Data Factory
4 89 (2.20%) Google Cloud Platform
5 74 (1.83%) Amazon EMR
6 49 (1.21%) Amazon S3
6 49 (1.21%) Serverless
7 45 (1.11%) SaaS
8 41 (1.01%) Amazon EC2
9 39 (0.96%) Amazon Kinesis
10 35 (0.86%) Office 365
10 35 (0.86%) PaaS
11 31 (0.76%) AWS Lambda
11 31 (0.76%) Data Lake Analytics
12 30 (0.74%) Cloud Computing
13 29 (0.72%) Google Analytics
14 26 (0.64%) GitHub
15 22 (0.54%) Boomi
15 22 (0.54%) Dynamics 365
16 19 (0.47%) IaaS
Communications & Networking
1 18 (0.44%) Internet
2 16 (0.39%) HTTP
3 11 (0.27%) HTTPS
4 10 (0.25%) SAN
5 9 (0.22%) SMS
6 8 (0.20%) Kerberos
6 8 (0.20%) SSL
7 7 (0.17%) FTP
8 6 (0.15%) DNS
8 6 (0.15%) Extranet
9 4 (0.099%) Firewall
9 4 (0.099%) Intranet
10 3 (0.074%) Network Security
10 3 (0.074%) TCP/IP
10 3 (0.074%) WAN
11 2 (0.049%) Broadband
11 2 (0.049%) LAN
11 2 (0.049%) PBX
11 2 (0.049%) SSH
11 2 (0.049%) VoIP
Database & Business Intelligence
1 2,076 (51.21%) Data Warehouse
2 1,987 (49.01%) SQL Server
3 1,775 (43.78%) SQL Server Integration Services
4 1,313 (32.39%) SQL Server Reporting Services
5 897 (22.13%) SQL Server Analysis Services
6 826 (20.37%) Big Data
7 817 (20.15%) Power BI
8 578 (14.26%) Relational Database
9 553 (13.64%) Hadoop
10 322 (7.94%) BusinessObjects
11 302 (7.45%) NoSQL
12 267 (6.59%) Apache Hive
13 257 (6.34%) QlikView
14 231 (5.70%) SQL Server 2012
15 230 (5.67%) OLAP
16 228 (5.62%) SQL Server 2008
17 219 (5.40%) Data Lake
18 207 (5.11%) SQL Server 2016
19 199 (4.91%) MySQL
20 186 (4.59%) PostgreSQL
Development Applications
1 171 (4.22%) Visual Studio
2 170 (4.19%) Git (software)
3 133 (3.28%) Team Foundation Server
4 131 (3.23%) JIRA
5 99 (2.44%) Jenkins
6 72 (1.78%) SQL Server Management Studio (SSMS)
7 64 (1.58%) Octopus Deploy
7 64 (1.58%) Subversion
8 62 (1.53%) Visual Studio Team System
9 46 (1.13%) TeamCity
10 40 (0.99%) ERwin
11 35 (0.86%) SoapUI
12 31 (0.76%) Eclipse
13 24 (0.59%) Bitbucket
13 24 (0.59%) ER Studio
14 20 (0.49%) Selenium
15 19 (0.47%) Oracle APEX
16 18 (0.44%) JUnit
17 16 (0.39%) Hudson
17 16 (0.39%) RStudio
General
1 1,105 (27.26%) Finance
2 266 (6.56%) Banking
3 241 (5.94%) Retail
4 156 (3.85%) Marketing
5 126 (3.11%) Advertising
6 62 (1.53%) Investment Banking
7 59 (1.46%) Games
8 51 (1.26%) Telecoms
9 50 (1.23%) Manufacturing
10 49 (1.21%) Legal
11 40 (0.99%) Law
12 33 (0.81%) Pharmaceutical
13 31 (0.76%) Publishing
14 23 (0.57%) Back Office
15 21 (0.52%) Automotive
16 13 (0.32%) Music Industry
17 12 (0.30%) Financial Institution
18 11 (0.27%) Electronics
19 10 (0.25%) General Ledger
20 6 (0.15%) Local Government
Job Titles
1 1,826 (45.04%) Developer
2 721 (17.78%) Business Intelligence Developer
3 649 (16.01%) SQL Developer
4 507 (12.51%) Analyst
5 467 (11.52%) Data Engineer
6 310 (7.65%) Consultant
7 306 (7.55%) Architect
8 291 (7.18%) ETL Developer
9 273 (6.73%) Senior Developer
10 241 (5.94%) SQL BI Developer
11 237 (5.85%) SSIS Developer
12 212 (5.23%) Data Warehouse Developer
13 209 (5.16%) Data Architect
14 179 (4.42%) Business Developer
15 164 (4.05%) Data Analyst
16 161 (3.97%) Database Developer
17 157 (3.87%) Business Intelligence Analyst
18 155 (3.82%) DBA
19 154 (3.80%) SQL Server Developer
20 146 (3.60%) SSRS Developer
Libraries, Frameworks & Software Standards
1 435 (10.73%) .NET
2 328 (8.09%) XML
3 303 (7.47%) Web Services
4 217 (5.35%) Kafka
5 154 (3.80%) HTML
6 149 (3.68%) JSON
7 120 (2.96%) Middleware
8 115 (2.84%) MDX
9 99 (2.44%) SOAP
10 92 (2.27%) REST
11 85 (2.10%) RESTful
12 71 (1.75%) ASP.NET
13 69 (1.70%) ASP.NET Web API
14 64 (1.58%) WCF
15 57 (1.41%) CSS
16 47 (1.16%) HTML5
16 47 (1.16%) Spring
17 44 (1.09%) AngularJS
17 44 (1.09%) Node.js
18 39 (0.96%) Spark Streaming
Miscellaneous
1 587 (14.48%) Analytical Skills
2 216 (5.33%) Computer Science
3 183 (4.51%) Greenfield Project
4 176 (4.34%) Management Information System
5 153 (3.77%) Data Structures
6 107 (2.64%) Fintech
7 86 (2.12%) Replication
8 78 (1.92%) Algorithms
9 69 (1.70%) User Experience
10 65 (1.60%) Self-Motivation
11 59 (1.46%) Reinsurance
12 58 (1.43%) Enterprise Software
13 53 (1.31%) Reference Data
14 49 (1.21%) FMCG
15 45 (1.11%) Tandem
16 43 (1.06%) Robotics
17 39 (0.96%) Life Science
18 35 (0.86%) Virtual Team
19 33 (0.81%) Clustering
19 33 (0.81%) NHS
Operating Systems
1 274 (6.76%) Linux
2 204 (5.03%) Unix
3 143 (3.53%) Windows
4 31 (0.76%) Windows Server
5 21 (0.52%) AIX
6 19 (0.47%) Solaris
7 18 (0.44%) Apple iOS
7 18 (0.44%) HPUX
8 13 (0.32%) Red Hat Enterprise Linux
9 12 (0.30%) Windows Server 2012
10 8 (0.20%) CentOS
10 8 (0.20%) Ubuntu
10 8 (0.20%) Windows Server 2008
11 5 (0.12%) Android
12 2 (0.049%) DC/OS
12 2 (0.049%) Debian
12 2 (0.049%) VMS
13 1 (0.025%) Oracle Linux
13 1 (0.025%) Windows 10
13 1 (0.025%) Windows Server 2003
Processes & Methodologies
1 2,083 (51.38%) Business Intelligence
2 1,320 (32.56%) Agile Software Development
3 1,084 (26.74%) Analytics
4 940 (23.19%) Data Modelling
5 555 (13.69%) Visualisation
6 468 (11.54%) Problem-Solving
7 462 (11.40%) Data Analysis
8 448 (11.05%) Data Management
9 416 (10.26%) Data Integration
10 403 (9.94%) Migration
11 393 (9.69%) Data Science
12 333 (8.21%) ETL Development
13 316 (7.79%) Kimball Methodology
14 305 (7.52%) Performance Tuning
15 293 (7.23%) Scrum
16 291 (7.18%) Data Visualisation
17 288 (7.10%) Data Migration
17 288 (7.10%) Dimensional Modelling
18 279 (6.88%) Data Engineering
19 256 (6.31%) SDLC
Programming Languages
1 2,762 (68.13%) SQL
2 1,026 (25.31%) T-SQL
3 773 (19.07%) Python
4 561 (13.84%) Java
5 558 (13.76%) C#
6 258 (6.36%) JavaScript
7 242 (5.97%) PL/SQL
8 216 (5.33%) Scala
9 196 (4.83%) R
10 190 (4.69%) PowerShell
11 119 (2.94%) VBA
12 96 (2.37%) Data Analysis Expressions (DAX)
13 69 (1.70%) Bash Shell
14 64 (1.58%) VB
15 62 (1.53%) Shell Script
16 61 (1.50%) C++
17 50 (1.23%) C
18 49 (1.21%) PHP
19 43 (1.06%) Perl
20 39 (0.96%) VB.NET
Qualifications
1 443 (10.93%) Degree
2 134 (3.31%) Security Cleared
3 84 (2.07%) SC Cleared
4 76 (1.87%) Computer Science Degree
5 45 (1.11%) ISEB
6 27 (0.67%) Master's Degree
7 20 (0.49%) AWS Certification
8 18 (0.44%) Microsoft Certification
9 15 (0.37%) DV Cleared
10 14 (0.35%) Numerate Degree
10 14 (0.35%) Postgraduate
11 13 (0.32%) PMI Certification
12 12 (0.30%) PhD
12 12 (0.30%) PMP
13 10 (0.25%) ISTQB
14 8 (0.20%) ITIL Certification
14 8 (0.20%) PRINCE2 Certification
15 7 (0.17%) ITIL Foundation Certificate
16 5 (0.12%) ISTQB Foundation Certification
16 5 (0.12%) SAS Certification
Quality Assurance & Compliance
1 439 (10.83%) Data Quality
2 225 (5.55%) QA
3 81 (2.00%) GDPR
4 31 (0.76%) SLA
5 13 (0.32%) ISO/IEC 27001
6 10 (0.25%) IFRS
7 9 (0.22%) MiFID
8 8 (0.20%) Solvency II
9 6 (0.15%) Dodd-Frank
9 6 (0.15%) Sarbanes-Oxley
10 5 (0.12%) IFRS 9
11 3 (0.074%) Actionable Recommendations
11 3 (0.074%) Cyber Essentials
11 3 (0.074%) ISO 9001
11 3 (0.074%) PMO
12 2 (0.049%) ISO/IEC 20000
13 1 (0.025%) COBIT
13 1 (0.025%) GxP
13 1 (0.025%) HL7
13 1 (0.025%) PCI DSS
System Software
1 132 (3.26%) Docker
2 101 (2.49%) HDFS
3 32 (0.79%) Apache Flume
4 8 (0.20%) Virtual Machines
5 4 (0.099%) Active Directory
5 4 (0.099%) Apache ZooKeeper
5 4 (0.099%) Varnish
5 4 (0.099%) VirtualBox
5 4 (0.099%) VMware Infrastructure
6 3 (0.074%) Oracle RAC
6 3 (0.074%) Tivoli Workload Scheduler
7 1 (0.025%) VMware ESXi
Systems Management
1 94 (2.32%) Kubernetes
2 71 (1.75%) Oozie
3 39 (0.96%) Docker Swarm
4 38 (0.94%) Puppet
5 34 (0.84%) Ansible
6 30 (0.74%) Grafana
7 28 (0.69%) Kibana
7 28 (0.69%) Terraform
8 24 (0.59%) Opscode Chef
8 24 (0.59%) Prometheus
9 21 (0.52%) Control-M
10 20 (0.49%) logstash
11 18 (0.44%) Automic
11 18 (0.44%) Systems Management Server (SMS)
12 15 (0.37%) Mesos
13 11 (0.27%) Dollar Universe
14 10 (0.25%) Hadoop YARN
15 9 (0.22%) Rundeck
16 8 (0.20%) Data Guard
17 7 (0.17%) Microsoft Clustering
Vendors
1 1,290 (31.82%) Microsoft
2 724 (17.86%) Oracle
3 665 (16.40%) Tableau
4 461 (11.37%) Informatica
5 302 (7.45%) SAP
6 208 (5.13%) Talend
7 207 (5.11%) Cognos
8 188 (4.64%) IBM
9 135 (3.33%) Hortonworks
10 132 (3.26%) Google
11 123 (3.03%) Cloudera
12 95 (2.34%) Teradata
13 85 (2.10%) Salesforce.com
14 78 (1.92%) Ab Initio
15 75 (1.85%) Alteryx
16 60 (1.48%) MicroStrategy
17 56 (1.38%) Netezza
18 53 (1.31%) Red Hat
19 46 (1.13%) MuleSoft
20 44 (1.09%) ServiceNow