Period
to 21 May 2018

The following table provides summary statistics for contract job vacancies with a requirement for ETL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited ETL over the 6 months to 21 May 2018 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Extract, Transform and Load (ETL)
UK
6 months to
21 May 2018
Same period 2017 Same period 2016
Rank 102 99 98
Rank change year-on-year -3 -1 -27
Contract jobs citing ETL 2,438 2,152 2,442
As % of all contract IT jobs advertised in the UK 2.42% 2.39% 2.31%
As % of the Processes & Methodologies category 2.83% 2.82% 2.75%
Number of daily rates quoted 1,734 1,413 1,721
UK median daily rate £450 £450 £425
Median daily rate % change year-on-year - +5.88% +0.65%
10th Percentile £313 £313 £305
90th Percentile £613 £588 £575
UK excluding London median daily rate £415 £400 £400
% change year-on-year +3.75% - -
Number of hourly rates quoted 8 15 7
UK median hourly rate £52.50 £38.00 £38.50
Median hourly rate % change year-on-year +38.16% -1.30% +1.85%
10th Percentile £43.40 £19.04 £20.50
90th Percentile £109.03 £42.50 £60.60
UK excluding London median hourly rate £48.75 £39.00 £38.50
% change year-on-year +25.00% +1.30% +1.85%

ETL is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies with a requirement for process or methodology skills.

All Process and Methodology Skills
UK
Contract vacancies with a requirement for process or methodology skills 86,297 76,245 88,684
As % of all contract IT jobs advertised in the UK 85.73% 84.63% 84.00%
Number of daily rates quoted 56,940 50,019 58,259
UK median daily rate £450 £438 £425
Median daily rate % change year-on-year +2.86% +2.94% +6.25%
10th Percentile £300 £275 £263
90th Percentile £638 £625 £606
UK excluding London median daily rate £425 £400 £400
% change year-on-year +6.13% - +6.67%
Number of hourly rates quoted 2,268 2,079 2,320
UK median hourly rate £22.00 £25.00 £25.00
Median hourly rate % change year-on-year -12.00% - +19.05%
10th Percentile £11.17 £11.46 £11.63
90th Percentile £50.00 £52.50 £50.59
UK excluding London median hourly rate £20.50 £25.00 £26.92
% change year-on-year -18.00% -7.11% +22.34%

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
Contractor Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing ETL.

Contractor daily rate trend for ETL in the UK

ETL
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing ETL over the 6 months to 21 May 2018.

Contractor daily rate histogram for ETL in the UK

ETL
Contractor Hourly Rate Trend

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing ETL.

Contractor hourly rate trend for ETL in the UK

ETL
Contractor Hourly Rate Histogram

The hourly rate distribution of IT jobs citing ETL over the 6 months to 21 May 2018.

Contractor hourly rate histogram for ETL in the UK

ETL
Top 17 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing ETL within the UK over the 6 months to 21 May 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -6 2,185 £470 +4.44% 473
London +7 1,237 £500 +10.31% 229
UK excluding London -12 1,183 £415 +3.75% 271
South East -27 321 £425 -5.56% 80
North of England -19 251 £400 +6.67% 67
Scotland +13 176 £400 - 22
Midlands -15 162 £425 +13.33% 46
Yorkshire +8 128 £393 +6.44% 30
South West +16 115 £423 +5.63% 26
North West -42 110 £388 +3.33% 34
East of England +22 104 £425 -2.86% 25
East Midlands +21 94 £400 - 15
West Midlands -46 68 £450 +24.14% 31
Wales +15 46 £338 +3.85% 4
North East +8 13 £450 -10.54% 3
Northern Ireland -3 9 £431 -6.91% 1
Isle of Man - 8 £400 -

For the 6 months to 21 May 2018, IT contractor 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 contract job ads with a requirement for ETL.

1 1,451 (59.52%) SQL
2 1,067 (43.77%) Data Warehouse
3 853 (34.99%) Business Intelligence
4 795 (32.61%) Agile Software Development
5 703 (28.84%) SQL Server
6 629 (25.80%) Finance
7 626 (25.68%) SQL Server Integration Services
8 557 (22.85%) Data Modelling
9 549 (22.52%) Oracle
10 496 (20.34%) Analytics
11 483 (19.81%) Big Data
12 447 (18.33%) Python
13 443 (18.17%) Microsoft
14 411 (16.86%) Migration
15 371 (15.22%) SQL Server Reporting Services
16 370 (15.18%) Hadoop
17 364 (14.93%) Java
18 318 (13.04%) Data Migration
19 316 (12.96%) T-SQL
20 294 (12.06%) Analytical Skills
21 292 (11.98%) Apache Spark
22 288 (11.81%) Amazon AWS
23 282 (11.57%) Informatica
24 279 (11.44%) Data Quality
25 254 (10.42%) Data Analysis
25 254 (10.42%) Microsoft Azure
26 253 (10.38%) Data Integration
27 249 (10.21%) ETL Development
28 244 (10.01%) Relational Database
29 237 (9.72%) SQL Server Analysis Services

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 292 (11.98%) Apache Spark
2 123 (5.05%) SAS
3 97 (3.98%) Apache
4 70 (2.87%) SharePoint
5 53 (2.17%) Elasticsearch
6 48 (1.97%) Apache Pig
7 33 (1.35%) Confluence
8 26 (1.07%) Apache Solr
9 24 (0.98%) Tomcat
10 19 (0.78%) Oracle SOA Suite
11 18 (0.74%) Apache Airflow
12 15 (0.62%) PowerExchange
13 14 (0.57%) Oracle Workflow
14 10 (0.41%) nginx
14 10 (0.41%) OpenStack
14 10 (0.41%) WebLogic
14 10 (0.41%) WebSphere
15 8 (0.33%) IIS
15 8 (0.33%) SharePoint Server
16 7 (0.29%) JBoss
Applications
1 137 (5.62%) Microsoft Excel
2 49 (2.01%) Microsoft Office
3 30 (1.23%) MS Visio
4 15 (0.62%) SPSS
5 14 (0.57%) Microsoft PowerPoint
6 10 (0.41%) Stata
7 9 (0.37%) Spreadsheet
8 7 (0.29%) Microsoft Project
9 5 (0.21%) Chatbot
10 3 (0.12%) CATIA
Business Applications
1 29 (1.19%) Markit EDM
2 20 (0.82%) Dynamics AX
3 18 (0.74%) Dynamics CRM
4 11 (0.45%) Cognos Business Intelligence
5 10 (0.41%) Oracle EBS
6 8 (0.33%) BusinessWare
7 7 (0.29%) HFM
8 6 (0.25%) Salesforce.com CRM
8 6 (0.25%) SAP S/4HANA
8 6 (0.25%) thinkFolio
9 5 (0.21%) Cognos TM1
9 5 (0.21%) NetSuite
9 5 (0.21%) Oracle Receivables
10 4 (0.16%) Dynamics NAV
10 4 (0.16%) Line 500
10 4 (0.16%) Oracle Payables
10 4 (0.16%) Sage X3
10 4 (0.16%) Summit
10 4 (0.16%) Unit4 Business World
11 3 (0.12%) Oracle Procure-to-Pay
Cloud Services
1 288 (11.81%) Amazon AWS
2 254 (10.42%) Microsoft Azure
3 73 (2.99%) Amazon S3
4 62 (2.54%) Google Cloud Platform
5 51 (2.09%) Azure Data Factory
6 26 (1.07%) Serverless
7 24 (0.98%) Amazon EC2
7 24 (0.98%) PaaS
8 23 (0.94%) GitHub
9 22 (0.90%) SaaS
10 20 (0.82%) Amazon Kinesis
11 17 (0.70%) Google Analytics
12 14 (0.57%) Amazon EMR
12 14 (0.57%) Data Lake Analytics
12 14 (0.57%) Dynamics 365
13 11 (0.45%) AWS Lambda
13 11 (0.45%) Cloud Computing
14 9 (0.37%) Boomi
14 9 (0.37%) IaaS
15 8 (0.33%) Office 365
Communications & Networking
1 29 (1.19%) FTP
2 22 (0.90%) Kerberos
3 16 (0.66%) HTTP
4 15 (0.62%) TCP/IP
5 14 (0.57%) SSL
6 13 (0.53%) SAN
7 12 (0.49%) DNS
8 11 (0.45%) VPN
9 9 (0.37%) SMS
10 8 (0.33%) DSL
11 6 (0.25%) ICMP
11 6 (0.25%) Internet
12 5 (0.21%) Firewall
13 4 (0.16%) PuTTY
14 3 (0.12%) AMQP
14 3 (0.12%) NAS
14 3 (0.12%) X.509
15 2 (0.082%) MQTT
15 2 (0.082%) Reverse Proxy
15 2 (0.082%) Skype
Database & Business Intelligence
1 1,067 (43.77%) Data Warehouse
2 703 (28.84%) SQL Server
3 626 (25.68%) SQL Server Integration Services
4 483 (19.81%) Big Data
5 371 (15.22%) SQL Server Reporting Services
6 370 (15.18%) Hadoop
7 244 (10.01%) Relational Database
8 237 (9.72%) SQL Server Analysis Services
9 226 (9.27%) Apache Hive
10 220 (9.02%) Power BI
11 157 (6.44%) NoSQL
12 155 (6.36%) Data Lake
13 131 (5.37%) Oracle Database
14 125 (5.13%) PostgreSQL
15 124 (5.09%) Amazon Redshift
16 118 (4.84%) HBase
17 97 (3.98%) BusinessObjects
18 92 (3.77%) DataStage
18 92 (3.77%) OLAP
19 90 (3.69%) SQL Server 2012
Development Applications
1 129 (5.29%) Git (software)
2 106 (4.35%) JIRA
3 96 (3.94%) Jenkins
4 80 (3.28%) Team Foundation Server
5 49 (2.01%) Visual Studio
6 32 (1.31%) SQL Server Management Studio (SSMS)
7 28 (1.15%) ERwin
8 27 (1.11%) TeamCity
9 25 (1.03%) Visual Studio Team System
10 23 (0.94%) Selenium
10 23 (0.94%) Subversion
11 19 (0.78%) Maven
12 14 (0.57%) Octopus Deploy
12 14 (0.57%) SpecFlow
13 13 (0.53%) GitLab
14 12 (0.49%) JUnit
14 12 (0.49%) PowerDesigner
15 11 (0.45%) Cucumber
15 11 (0.45%) RStudio
15 11 (0.45%) Toad
General
1 629 (25.80%) Finance
2 191 (7.83%) Banking
3 114 (4.68%) Retail
4 49 (2.01%) Manufacturing
4 49 (2.01%) Marketing
5 39 (1.60%) Legal
6 33 (1.35%) Investment Banking
7 21 (0.86%) Front Office
7 21 (0.86%) Law
8 18 (0.74%) Games
8 18 (0.74%) Retail Banking
8 18 (0.74%) Telecoms
9 14 (0.57%) Publishing
10 13 (0.53%) Corporate Banking
11 12 (0.49%) Advertising
12 9 (0.37%) Back Office
12 9 (0.37%) Electronics
13 8 (0.33%) Financial Institution
13 8 (0.33%) Pharmaceutical
14 6 (0.25%) Automotive
Job Titles
1 1,026 (42.08%) Developer
2 338 (13.86%) Analyst
3 311 (12.76%) Data Engineer
4 266 (10.91%) Architect
5 264 (10.83%) ETL Developer
6 247 (10.13%) SQL Developer
7 226 (9.27%) Business Intelligence Developer
8 153 (6.28%) Data Analyst
9 137 (5.62%) Data Architect
10 108 (4.43%) Consultant
11 102 (4.18%) SSIS Developer
12 97 (3.98%) Big Data Engineer
13 71 (2.91%) Data Warehouse Developer
13 71 (2.91%) Solutions Architect
14 67 (2.75%) Test Analyst
15 64 (2.63%) Senior Developer
16 63 (2.58%) Python Engineer
17 58 (2.38%) Business Intelligence Analyst
18 55 (2.26%) AWS Engineer
18 55 (2.26%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 154 (6.32%) XML
2 148 (6.07%) .NET
3 145 (5.95%) Kafka
4 77 (3.16%) Web Services
5 70 (2.87%) JSON
6 58 (2.38%) REST
7 43 (1.76%) MDX
8 41 (1.68%) Middleware
9 40 (1.64%) XML Schema
10 35 (1.44%) HTML
11 30 (1.23%) Natural Language Processing
11 30 (1.23%) SOAP
12 26 (1.07%) Spring
13 24 (0.98%) AngularJS
13 24 (0.98%) RESTful
14 23 (0.94%) CSS
15 22 (0.90%) React
15 22 (0.90%) Spark Streaming
15 22 (0.90%) XSD
16 21 (0.86%) .NET Framework
Miscellaneous
1 294 (12.06%) Analytical Skills
2 85 (3.49%) Data Structures
3 75 (3.08%) Management Information System
4 73 (2.99%) Computer Science
5 70 (2.87%) Self-Motivation
6 59 (2.42%) Greenfield Project
7 44 (1.80%) Fintech
8 36 (1.48%) Replication
9 33 (1.35%) Reference Data
10 29 (1.19%) Algorithms
11 25 (1.03%) Credit Risk
12 23 (0.94%) NHS
13 21 (0.86%) User Experience
14 20 (0.82%) Mainframe
15 18 (0.74%) Market Risk
16 16 (0.66%) Reinsurance
17 15 (0.62%) Foreign Exchange (FX)
18 14 (0.57%) Enterprise Software
19 13 (0.53%) Data Centre
19 13 (0.53%) Fixed Income
Operating Systems
1 211 (8.65%) Linux
2 169 (6.93%) Unix
3 74 (3.04%) Windows
4 25 (1.03%) AIX
5 17 (0.70%) Windows Server
6 14 (0.57%) Red Hat Enterprise Linux
7 9 (0.37%) VMS
7 9 (0.37%) Windows Server 2003
7 9 (0.37%) Windows Server 2008
8 6 (0.25%) CentOS
8 6 (0.25%) Solaris
8 6 (0.25%) Windows 7
9 4 (0.16%) Ubuntu
9 4 (0.16%) Windows 10
10 3 (0.12%) Windows Server 2012
11 2 (0.082%) Mac OS X
11 2 (0.082%) SUSE Linux Enterprise Server
11 2 (0.082%) VME
12 1 (0.041%) MVS
Processes & Methodologies
1 853 (34.99%) Business Intelligence
2 795 (32.61%) Agile Software Development
3 557 (22.85%) Data Modelling
4 496 (20.34%) Analytics
5 411 (16.86%) Migration
6 318 (13.04%) Data Migration
7 254 (10.42%) Data Analysis
8 253 (10.38%) Data Integration
9 249 (10.21%) ETL Development
10 223 (9.15%) Data Management
11 212 (8.70%) Problem-Solving
12 182 (7.47%) Visualisation
13 174 (7.14%) Scrum
14 171 (7.01%) Performance Tuning
15 153 (6.28%) Data Architecture
16 150 (6.15%) Data Science
17 140 (5.74%) DevOps
18 138 (5.66%) Data Analytics
19 124 (5.09%) Test Automation
20 123 (5.05%) Data Mapping
Programming Languages
1 1,451 (59.52%) SQL
2 447 (18.33%) Python
3 364 (14.93%) Java
4 316 (12.96%) T-SQL
5 170 (6.97%) C#
6 162 (6.64%) PL/SQL
7 145 (5.95%) Scala
8 139 (5.70%) R
9 104 (4.27%) JavaScript
10 79 (3.24%) Shell Script
11 62 (2.54%) PowerShell
12 58 (2.38%) Bash Shell
13 38 (1.56%) Ruby
14 34 (1.39%) Perl
15 30 (1.23%) VBA
16 27 (1.11%) Data Analysis Expressions (DAX)
17 24 (0.98%) C
18 20 (0.82%) Java 8
19 19 (0.78%) VB.NET
20 18 (0.74%) VB
Qualifications
1 169 (6.93%) Security Cleared
2 119 (4.88%) SC Cleared
3 107 (4.39%) Degree
4 31 (1.27%) DV Cleared
5 28 (1.15%) Computer Science Degree
6 25 (1.03%) ISTQB
7 20 (0.82%) BPSS Clearance
8 16 (0.66%) Numerate Degree
9 14 (0.57%) PhD
10 11 (0.45%) ISEB
11 10 (0.41%) Microsoft Certification
11 10 (0.41%) TOGAF Certification
12 8 (0.33%) ISTQB Foundation Certification
13 7 (0.29%) MCSE
14 6 (0.25%) DBS Check
14 6 (0.25%) MCSA
14 6 (0.25%) PMI Certification
15 5 (0.21%) Oracle Certification
15 5 (0.21%) PMP
16 4 (0.16%) Master's Degree
Quality Assurance & Compliance
1 279 (11.44%) Data Quality
2 110 (4.51%) QA
3 59 (2.42%) GDPR
4 28 (1.15%) GCP
5 16 (0.66%) IFRS
6 15 (0.62%) Disclosure Scotland
6 15 (0.62%) IFRS 9
7 10 (0.41%) SLA
8 9 (0.37%) MiFID
8 9 (0.37%) PMO
9 8 (0.33%) EMIR
10 7 (0.29%) Dodd-Frank
10 7 (0.29%) PCI DSS
10 7 (0.29%) Sarbanes-Oxley
11 4 (0.16%) ISO/IEC 20000
12 3 (0.12%) Solvency II
13 2 (0.082%) Cyber Essentials
13 2 (0.082%) Cyber Essentials PLUS
13 2 (0.082%) ISO 20022
13 2 (0.082%) ISO/IEC 27001
System Software
1 82 (3.36%) HDFS
2 73 (2.99%) Docker
3 66 (2.71%) Apache Flume
4 12 (0.49%) Hyper-V
5 6 (0.25%) Active Directory
5 6 (0.25%) Apache ZooKeeper
6 5 (0.21%) Tivoli Workload Scheduler
7 4 (0.16%) Virtual Machines
7 4 (0.16%) VMware Infrastructure
8 3 (0.12%) Virtual Servers
9 2 (0.082%) Veritas Cluster Server
9 2 (0.082%) VMware ESXi
10 1 (0.041%) GeoWebCache
10 1 (0.041%) VirtualBox
10 1 (0.041%) Xen
Systems Management
1 50 (2.05%) Ansible
2 49 (2.01%) Oozie
3 42 (1.72%) Hadoop YARN
4 27 (1.11%) Terraform
5 21 (0.86%) Control-M
6 18 (0.74%) Kubernetes
7 17 (0.70%) Puppet
8 15 (0.62%) Opscode Chef
9 10 (0.41%) Ambari
9 10 (0.41%) Tivoli
10 8 (0.33%) Kibana
10 8 (0.33%) Nagios
10 8 (0.33%) Single Sign-On
11 7 (0.29%) Consul
11 7 (0.29%) Mesos
12 6 (0.25%) Host Intrusion Detection System
12 6 (0.25%) MOM
12 6 (0.25%) Network Intrusion Detection System
12 6 (0.25%) Prometheus
12 6 (0.25%) Sysdig
Vendors
1 549 (22.52%) Oracle
2 443 (18.17%) Microsoft
3 282 (11.57%) Informatica
4 198 (8.12%) Tableau
5 180 (7.38%) SAP
6 147 (6.03%) Talend
7 131 (5.37%) Cloudera
8 114 (4.68%) IBM
9 90 (3.69%) Teradata
10 82 (3.36%) Cognos
11 67 (2.75%) Google
12 65 (2.67%) Salesforce.com
13 63 (2.58%) Ab Initio
14 61 (2.50%) Hortonworks
15 35 (1.44%) MicroStrategy
16 32 (1.31%) webMethods
17 30 (1.23%) Alteryx
18 26 (1.07%) Splunk
19 25 (1.03%) MuleSoft
20 24 (0.98%) MapR