Period
to 17 February 2019

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 17 February 2019 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
17 Feb 2019
Same period 2018 Same period 2017
Rank 95 101 94
Rank change year-on-year +6 -7 -17
Contract jobs citing ETL 2,532 2,369 2,390
As % of all contract IT jobs advertised in the UK 2.59% 2.35% 2.49%
As % of the Processes & Methodologies category 2.98% 2.74% 2.93%
Number of daily rates quoted 1,698 1,711 1,549
UK median daily rate £460 £450 £433
Median daily rate % change year-on-year +2.22% +4.05% +1.76%
10th Percentile £325 £313 £310
90th Percentile £619 £600 £600
UK excluding London median daily rate £438 £413 £400
% change year-on-year +6.06% +3.13% -
Number of hourly rates quoted 16 16 26
UK median hourly rate £22.00 £56.50 £40.00
Median hourly rate % change year-on-year -61.06% +41.25% -4.19%
10th Percentile £19.39 £41.40 £18.12
90th Percentile £65.39 £74.38 £48.00
UK excluding London median hourly rate £22.00 £48.73 £40.00
% change year-on-year -54.85% +21.83% -4.19%

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 85,014 86,460 81,666
As % of all contract IT jobs advertised in the UK 87.06% 85.94% 85.10%
Number of daily rates quoted 56,141 57,673 53,944
UK median daily rate £475 £450 £425
Median daily rate % change year-on-year +5.56% +5.88% -
10th Percentile £300 £281 £263
90th Percentile £650 £638 £613
UK excluding London median daily rate £425 £413 £400
% change year-on-year +3.03% +3.13% +2.56%
Number of hourly rates quoted 2,220 2,105 2,357
UK median hourly rate £23.84 £24.00 £24.00
Median hourly rate % change year-on-year -0.69% - +1.05%
10th Percentile £11.25 £11.37 £11.25
90th Percentile £50.00 £50.25 £49.50
UK excluding London median hourly rate £22.50 £24.00 £22.90
% change year-on-year -6.25% +4.80% -8.40%

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 17 February 2019.

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 17 February 2019.

Contractor hourly rate histogram for ETL in the UK

ETL
Top 16 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 17 February 2019. 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 +15 2,306 £463 +2.78% 596
UK excluding London -4 1,321 £438 +6.06% 383
London +19 1,181 £489 -2.25% 263
South East -9 327 £475 +11.76% 84
North of England +9 310 £390 -2.50% 118
Midlands +13 193 £425 +6.25% 55
East of England +63 170 £460 +5.14% 31
Scotland -2 168 £450 +12.50% 39
Yorkshire +12 148 £375 -5.66% 34
North West +14 138 £400 -3.03% 75
South West -55 117 £425 - 46
West Midlands -16 104 £400 -5.88% 33
East Midlands +26 88 £450 +30.76% 22
North East -9 24 £365 -14.12% 9
Wales -35 23 £500 +55.28% 4
Northern Ireland +11 13 £215 -44.16% 7

For the 6 months to 17 February 2019, 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,592 (62.88%) SQL
2 1,056 (41.71%) Data Warehouse
3 903 (35.66%) SQL Server
4 835 (32.98%) Business Intelligence
5 787 (31.08%) Agile Software Development
6 745 (29.42%) SQL Server Integration Services
7 624 (24.64%) Finance
8 551 (21.76%) Oracle
9 507 (20.02%) Data Modelling
10 460 (18.17%) SQL Server Reporting Services
11 452 (17.85%) Microsoft
12 448 (17.69%) Analytics
13 434 (17.14%) Python
14 425 (16.79%) Migration
15 417 (16.47%) Big Data
16 405 (16.00%) Amazon AWS
17 402 (15.88%) Microsoft Azure
18 394 (15.56%) Analytical Skills
19 360 (14.22%) T-SQL
20 348 (13.74%) Power BI
21 347 (13.70%) Data Migration
22 345 (13.63%) Hadoop
23 301 (11.89%) Data Analysis
24 299 (11.81%) SQL Server Analysis Services
25 294 (11.61%) Java
26 292 (11.53%) Relational Database
27 267 (10.55%) Apache Spark
28 260 (10.27%) Scrum
29 238 (9.40%) Informatica
30 234 (9.24%) Data Integration

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 267 (10.55%) Apache Spark
2 147 (5.81%) SAS
3 76 (3.00%) Confluence
4 56 (2.21%) Apache
5 49 (1.94%) SharePoint
6 31 (1.22%) Elasticsearch
7 24 (0.95%) Apache Pig
8 23 (0.91%) Apache Airflow
9 14 (0.55%) Luigi
10 13 (0.51%) Tomcat
11 12 (0.47%) ArcGIS
11 12 (0.47%) IIS
11 12 (0.47%) JBoss
12 11 (0.43%) Cloud Foundry
13 8 (0.32%) Apache Solr
14 7 (0.28%) CMS
15 5 (0.20%) nginx
15 5 (0.20%) NServiceBus
15 5 (0.20%) Oracle SOA Suite
15 5 (0.20%) WebSphere
Applications
1 195 (7.70%) Microsoft Excel
2 45 (1.78%) Microsoft Office
3 36 (1.42%) MS Visio
4 23 (0.91%) Spreadsheet
5 19 (0.75%) Microsoft PowerPoint
6 12 (0.47%) SPSS
7 3 (0.12%) Mathematica
7 3 (0.12%) Microsoft Project
Business Applications
1 31 (1.22%) Dynamics CRM
2 15 (0.59%) Markit EDM
2 15 (0.59%) SAP Oil and Gas
3 14 (0.55%) Workday HCM
4 13 (0.51%) SAP HR
5 11 (0.43%) NetSuite
6 10 (0.39%) Dynamics AX
6 10 (0.39%) SAP S/4HANA
7 9 (0.36%) Oracle EBS
7 9 (0.36%) Oracle Retail
8 8 (0.32%) Dynamics NAV
9 7 (0.28%) Cognos Business Intelligence
10 6 (0.24%) Infor M3
10 6 (0.24%) Oracle EBS R12
10 6 (0.24%) SAP FI
11 5 (0.20%) SAP CO
11 5 (0.20%) SAP FI/CO
12 4 (0.16%) Cognos TM1
12 4 (0.16%) IBM Operational Decision Manager
12 4 (0.16%) Oracle Financials
Cloud Services
1 405 (16.00%) Amazon AWS
2 402 (15.88%) Microsoft Azure
3 105 (4.15%) Amazon S3
4 97 (3.83%) Azure Data Factory
5 80 (3.16%) Google Cloud Platform
6 65 (2.57%) Amazon EMR
7 62 (2.45%) Amazon EC2
8 46 (1.82%) Serverless
9 43 (1.70%) Dynamics 365
10 37 (1.46%) Virtual Private Cloud
11 35 (1.38%) AWS Lambda
12 30 (1.18%) SaaS
13 27 (1.07%) PaaS
14 20 (0.79%) GitHub
15 15 (0.59%) Amazon Glacier
15 15 (0.59%) Cloud Computing
16 13 (0.51%) Amazon Kinesis
16 13 (0.51%) Salesforce Service Cloud
17 12 (0.47%) Data Lake Analytics
18 11 (0.43%) IaaS
Communications & Networking
1 39 (1.54%) Internet
2 27 (1.07%) SSH
3 26 (1.03%) TCP/IP
4 22 (0.87%) Firewall
5 13 (0.51%) HTTP
6 12 (0.47%) DNS
7 11 (0.43%) FTP
7 11 (0.43%) Intranet
7 11 (0.43%) Kerberos
8 7 (0.28%) VPN
9 5 (0.20%) Extranet
10 3 (0.12%) DMZ
10 3 (0.12%) ICMP
10 3 (0.12%) OpenLDAP
10 3 (0.12%) SMTP
10 3 (0.12%) SSL
10 3 (0.12%) X.509
11 2 (0.079%) DHCP
11 2 (0.079%) Reverse Proxy
11 2 (0.079%) Wireshark
Database & Business Intelligence
1 1,056 (41.71%) Data Warehouse
2 903 (35.66%) SQL Server
3 745 (29.42%) SQL Server Integration Services
4 460 (18.17%) SQL Server Reporting Services
5 417 (16.47%) Big Data
6 348 (13.74%) Power BI
7 345 (13.63%) Hadoop
8 299 (11.81%) SQL Server Analysis Services
9 292 (11.53%) Relational Database
10 229 (9.04%) Apache Hive
11 165 (6.52%) NoSQL
12 159 (6.28%) Data Lake
13 156 (6.16%) Oracle Database
14 130 (5.13%) SQL Server 2008
15 129 (5.09%) BusinessObjects
16 116 (4.58%) MySQL
17 109 (4.30%) SQL Server 2016
18 105 (4.15%) OLAP
19 104 (4.11%) Amazon Redshift
20 102 (4.03%) PostgreSQL
Development Applications
1 175 (6.91%) JIRA
2 133 (5.25%) Jenkins
3 119 (4.70%) Git (software)
4 72 (2.84%) Selenium
5 70 (2.76%) Team Foundation Server
6 62 (2.45%) Visual Studio
7 51 (2.01%) Maven
8 36 (1.42%) Subversion
9 33 (1.30%) ERwin
10 31 (1.22%) Bitbucket
10 31 (1.22%) Visual Studio Team System
11 27 (1.07%) SQL Server Management Studio (SSMS)
12 26 (1.03%) Cucumber
12 26 (1.03%) Toad
13 23 (0.91%) SoapUI
13 23 (0.91%) SpecFlow
14 21 (0.83%) Ant
15 20 (0.79%) Gradle
16 19 (0.75%) LoadRunner
17 18 (0.71%) JMeter
General
1 624 (24.64%) Finance
2 202 (7.98%) Banking
3 122 (4.82%) Retail
4 59 (2.33%) Marketing
5 55 (2.17%) Legal
6 51 (2.01%) Back Office
7 50 (1.97%) Investment Banking
8 39 (1.54%) Front Office
9 30 (1.18%) Publishing
10 26 (1.03%) Telecoms
11 21 (0.83%) Pharmaceutical
12 20 (0.79%) Retail Banking
13 19 (0.75%) Manufacturing
14 18 (0.71%) Financial Institution
15 14 (0.55%) General Ledger
16 13 (0.51%) Advertising
17 10 (0.39%) Games
18 9 (0.36%) Law
19 6 (0.24%) Electronics
20 5 (0.20%) Corporate Banking
Job Titles
1 1,176 (46.45%) Developer
2 334 (13.19%) Analyst
3 319 (12.60%) SQL Developer
4 274 (10.82%) ETL Developer
5 256 (10.11%) Architect
6 253 (9.99%) Business Intelligence Developer
7 234 (9.24%) Data Engineer
8 167 (6.60%) Data Analyst
9 120 (4.74%) Data Architect
10 116 (4.58%) Consultant
11 91 (3.59%) SSIS Developer
12 78 (3.08%) Data Warehouse Developer
13 77 (3.04%) Oracle Developer
14 74 (2.92%) SQL Server Developer
15 73 (2.88%) SQL BI Developer
16 70 (2.76%) Big Data Engineer
17 69 (2.73%) Senior Developer
17 69 (2.73%) Solutions Architect
17 69 (2.73%) SQL Analyst
18 65 (2.57%) DBA
Libraries, Frameworks & Software Standards
1 175 (6.91%) Web Services
1 175 (6.91%) XML
2 144 (5.69%) .NET
3 117 (4.62%) Kafka
4 116 (4.58%) JSON
5 49 (1.94%) HTML
6 48 (1.90%) REST
7 44 (1.74%) SOAP
7 44 (1.74%) Spring
8 41 (1.62%) MDX
9 38 (1.50%) AngularJS
9 38 (1.50%) CSS
10 37 (1.46%) React
11 36 (1.42%) Middleware
11 36 (1.42%) Spark Streaming
12 34 (1.34%) RESTful
13 33 (1.30%) ASP.NET Web API
14 30 (1.18%) ASP.NET
14 30 (1.18%) WCF
15 27 (1.07%) HTML5
Miscellaneous
1 394 (15.56%) Analytical Skills
2 110 (4.34%) Data Structures
3 98 (3.87%) Greenfield Project
4 64 (2.53%) Management Information System
5 62 (2.45%) Algorithms
6 55 (2.17%) Self-Motivation
7 50 (1.97%) Replication
8 41 (1.62%) Reference Data
9 40 (1.58%) Enterprise Software
10 31 (1.22%) Equities
11 29 (1.15%) User Experience
12 24 (0.95%) Fixed Income
13 20 (0.79%) Fintech
14 19 (0.75%) Client/Server
15 18 (0.71%) NHS
16 17 (0.67%) Wiki
17 15 (0.59%) Data Centre
18 14 (0.55%) Clustering
18 14 (0.55%) Mainframe
19 11 (0.43%) Hedge funds
Operating Systems
1 223 (8.81%) Unix
2 193 (7.62%) Linux
3 73 (2.88%) Windows
4 18 (0.71%) Windows Server
5 17 (0.67%) Red Hat Enterprise Linux
6 16 (0.63%) Solaris
7 6 (0.24%) Apple iOS
8 5 (0.20%) Android
9 2 (0.079%) AIX
9 2 (0.079%) VME
10 1 (0.039%) DC/OS
10 1 (0.039%) Mac OS X
10 1 (0.039%) Oracle Linux
10 1 (0.039%) VMS
Processes & Methodologies
1 835 (32.98%) Business Intelligence
2 787 (31.08%) Agile Software Development
3 507 (20.02%) Data Modelling
4 448 (17.69%) Analytics
5 425 (16.79%) Migration
6 347 (13.70%) Data Migration
7 301 (11.89%) Data Analysis
8 260 (10.27%) Scrum
9 234 (9.24%) Data Integration
10 229 (9.04%) Visualisation
11 227 (8.97%) Problem-Solving
12 223 (8.81%) ETL Development
13 196 (7.74%) Test Automation
14 187 (7.39%) Kimball Methodology
15 183 (7.23%) Data Science
15 183 (7.23%) Performance Tuning
16 180 (7.11%) Data Management
17 171 (6.75%) DevOps
18 146 (5.77%) Data Architecture
19 143 (5.65%) Data Analytics
Programming Languages
1 1,592 (62.88%) SQL
2 434 (17.14%) Python
3 360 (14.22%) T-SQL
4 294 (11.61%) Java
5 198 (7.82%) C#
6 168 (6.64%) PL/SQL
7 124 (4.90%) Scala
8 109 (4.30%) R
9 104 (4.11%) JavaScript
10 101 (3.99%) Shell Script
11 71 (2.80%) PowerShell
12 58 (2.29%) VBA
13 53 (2.09%) Bash Shell
14 44 (1.74%) VB
15 36 (1.42%) MATLAB
16 34 (1.34%) C
16 34 (1.34%) Data Analysis Expressions (DAX)
17 24 (0.95%) C++
17 24 (0.95%) Ruby
18 23 (0.91%) Perl
Qualifications
1 149 (5.88%) Security Cleared
2 122 (4.82%) Degree
2 122 (4.82%) SC Cleared
3 53 (2.09%) Computer Science Degree
4 36 (1.42%) ISTQB
5 35 (1.38%) Master's Degree
6 27 (1.07%) ISEB
7 21 (0.83%) PhD
8 19 (0.75%) BPSS Clearance
9 13 (0.51%) Microsoft Certification
10 8 (0.32%) PMI Certification
11 7 (0.28%) MCSE
12 6 (0.24%) ACCA
12 6 (0.24%) Numerate Degree
12 6 (0.24%) RHCE
13 5 (0.20%) PMP
14 4 (0.16%) CFA
14 4 (0.16%) DV Cleared
14 4 (0.16%) MCITP
14 4 (0.16%) MCSA
Quality Assurance & Compliance
1 226 (8.93%) Data Quality
2 171 (6.75%) QA
3 28 (1.11%) GDPR
4 16 (0.63%) SLA
5 10 (0.39%) IFRS
6 9 (0.36%) IFRS 9
7 8 (0.32%) Basel III
8 5 (0.20%) ISO/IEC 27001
9 4 (0.16%) Disclosure Scotland
9 4 (0.16%) PMO
10 3 (0.12%) HL7
10 3 (0.12%) MiFID
11 2 (0.079%) EMIR
11 2 (0.079%) Government Security Classifications
12 1 (0.039%) Dodd-Frank
12 1 (0.039%) ISO 9001
12 1 (0.039%) ISO 9002
12 1 (0.039%) PSD2
12 1 (0.039%) TickIT
System Software
1 86 (3.40%) Docker
2 53 (2.09%) HDFS
3 43 (1.70%) Apache Flume
4 11 (0.43%) Active Directory
5 10 (0.39%) Oracle RAC
6 4 (0.16%) Apache ZooKeeper
6 4 (0.16%) VMware Infrastructure
7 2 (0.079%) Squid
7 2 (0.079%) Virtual Machines
7 2 (0.079%) VMware ESXi
8 1 (0.039%) Cronacle
8 1 (0.039%) iptables
8 1 (0.039%) NFS
8 1 (0.039%) Postfix
8 1 (0.039%) Sendmail
8 1 (0.039%) VMware Server
Systems Management
1 97 (3.83%) Ansible
2 63 (2.49%) Kubernetes
3 59 (2.33%) Opscode Chef
4 42 (1.66%) Puppet
5 37 (1.46%) Hadoop YARN
6 25 (0.99%) Oozie
7 24 (0.95%) Terraform
8 22 (0.87%) Control-M
9 8 (0.32%) Kibana
9 8 (0.32%) SCOM
10 6 (0.24%) logstash
11 5 (0.20%) Consul
11 5 (0.20%) HAProxy
11 5 (0.20%) Tivoli
12 4 (0.16%) Ambari
12 4 (0.16%) BladeLogic
12 4 (0.16%) HP ALM
12 4 (0.16%) Prometheus
13 3 (0.12%) Single Sign-On
13 3 (0.12%) Sysdig
Vendors
1 551 (21.76%) Oracle
2 452 (17.85%) Microsoft
3 238 (9.40%) Informatica
4 211 (8.33%) Tableau
5 165 (6.52%) Talend
6 154 (6.08%) SAP
7 99 (3.91%) Google
8 92 (3.63%) Teradata
9 82 (3.24%) Ab Initio
10 79 (3.12%) Cloudera
11 67 (2.65%) IBM
12 45 (1.78%) Netezza
13 38 (1.50%) Cognos
14 37 (1.46%) Salesforce.com
15 36 (1.42%) MicroStrategy
16 34 (1.34%) Hortonworks
16 34 (1.34%) Splunk
17 29 (1.15%) Alteryx
18 27 (1.07%) Databricks
19 26 (1.03%) Workday