Period
to 29 May 2020

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 29 May 2020 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
29 May 2020
Same period 2019 Same period 2018
Rank 76 93 105
Rank change year-on-year +17 +12 -1
Contract jobs citing ETL 1,278 2,318 2,475
As % of all contract jobs advertised in the UK 2.75% 2.55% 2.45%
As % of the Processes & Methodologies category 3.22% 2.92% 2.82%
Number of daily rates quoted 843 1,559 1,769
Median daily rate £470 £460 £450
Median daily rate % change year-on-year +2.17% +2.22% -
10th Percentile £325 £327 £313
90th Percentile £638 £625 £606
UK excluding London median daily rate £450 £438 £420
% change year-on-year +2.86% +4.17% +5.00%
Number of hourly rates quoted 24 16 12
Median hourly rate £35.00 £35.00 £47.50
Median hourly rate % change year-on-year - -26.32% +35.71%
10th Percentile £15.99 £20.31 £35.00
90th Percentile £48.50 £58.63 £79.18
UK excluding London median hourly rate £35.00 £42.50 £41.25
% change year-on-year -17.65% +3.03% +10.00%

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 39,726 79,287 87,767
As % of all contract IT jobs advertised in the UK 85.46% 87.25% 86.96%
Number of daily rates quoted 25,019 52,210 57,865
Median daily rate £475 £475 £450
Median daily rate % change year-on-year - +5.56% +2.86%
10th Percentile £300 £305 £298
90th Percentile £675 £650 £638
UK excluding London median daily rate £450 £438 £420
% change year-on-year +2.86% +4.17% +5.00%
Number of hourly rates quoted 1,399 2,131 2,312
Median hourly rate £30.00 £24.91 £22.00
Median hourly rate % change year-on-year +20.43% +13.23% -12.42%
10th Percentile £12.75 £11.85 £11.17
90th Percentile £55.00 £52.00 £50.00
Median hourly rate £23.00 £23.75 £21.00
% change year-on-year -3.16% +13.10% -17.65%

ETL
Job Vacancy Trend

Job postings citing ETL as a proportion of all IT jobs advertised.

Job vacancy trend for ETL in the UK

ETL
Contractor Daily Rate Trend

3-month moving average daily rate quoted in jobs citing ETL.

Daily rate trend for ETL in the UK

ETL
Daily Rate Histogram

Daily rate distribution for jobs citing ETL over the 6 months to 29 May 2020.

Daily rate histogram for ETL in the UK

ETL
Contractor Hourly Rate Trend

3-month moving average hourly rates quoted in jobs citing ETL.

Hourly rate trend for ETL in the UK

ETL
Hourly Rate Histogram

Hourly rate distribution of jobs citing ETL over the 6 months to 29 May 2020.

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 29 May 2020. 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 +18 1,157 £475 +2.70% 158
UK excluding London +24 693 £450 +2.86% 108
London +2 547 £500 +3.09% 63
South East +77 211 £475 +5.56% 24
North of England +23 137 £425 +6.25% 22
Midlands +23 117 £450 +2.86% 26
East of England +3 82 £450 -2.70% 13
North West +33 79 £425 +6.25% 19
West Midlands +30 71 £450 +2.04% 24
Wales +52 53 £450 +5.88% 3
Work from Home +35 51 £450 -12.20% 16
South West +6 48 £450 - 12
East Midlands +9 46 £390 -8.24% 2
Yorkshire +14 42 £406 +1.56% 2
Scotland -42 36 £450 - 9
North East +16 16 £475 +35.71% 1
Northern Ireland +11 10 £441 +105.12% 1

For the 6 months to 29 May 2020, 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 786 (61.50%) SQL
2 496 (38.81%) Data Warehouse
3 468 (36.62%) Business Intelligence
4 405 (31.69%) Agile Software Development
5 360 (28.17%) Data Modelling
6 346 (27.07%) SQL Server
7 314 (24.57%) Azure
8 302 (23.63%) SQL Server Integration Services
9 282 (22.07%) Python
10 271 (21.21%) Finance
11 262 (20.50%) Analytics
12 251 (19.64%) Microsoft
12 251 (19.64%) Migration
13 240 (18.78%) AWS
14 231 (18.08%) Oracle
15 229 (17.92%) Power Platform
16 226 (17.68%) Power BI
17 199 (15.57%) DevOps
18 182 (14.24%) Big Data
19 164 (12.83%) Data Migration
20 156 (12.21%) SQL Server Reporting Services
21 154 (12.05%) Relational Database
22 152 (11.89%) Analytical Skills
23 150 (11.74%) Data Engineering
24 147 (11.50%) Security Cleared
25 141 (11.03%) Hadoop
25 141 (11.03%) T-SQL
26 136 (10.64%) SC Cleared
27 135 (10.56%) Apache Spark
28 130 (10.17%) Java

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 135 (10.56%) Apache Spark
2 50 (3.91%) SAS
3 39 (3.05%) Confluence
4 21 (1.64%) Elasticsearch
5 20 (1.56%) WebLogic
6 19 (1.49%) Apache
7 18 (1.41%) SharePoint
8 15 (1.17%) ArcGIS
9 9 (0.70%) Apache Airflow
10 7 (0.55%) Tomcat
11 6 (0.47%) Apache Pig
11 6 (0.47%) Oracle Workflow
12 5 (0.39%) IIS
12 5 (0.39%) Oracle SOA Suite
13 4 (0.31%) IBM Notes
13 4 (0.31%) OnBase
14 3 (0.23%) Apache Pulsar
14 3 (0.23%) Luigi
14 3 (0.23%) Oracle Application Server
14 3 (0.23%) WebSphere
Applications
1 95 (7.43%) Microsoft Excel
2 13 (1.02%) Microsoft Office
3 7 (0.55%) Microsoft PowerPoint
4 5 (0.39%) MS Visio
5 4 (0.31%) Photoshop
6 3 (0.23%) Adobe Illustrator
6 3 (0.23%) InDesign
6 3 (0.23%) Microsoft Project
7 2 (0.16%) Chatbot
7 2 (0.16%) Stata
8 1 (0.078%) SPSS
Business Applications
1 20 (1.56%) Oracle EBS
2 10 (0.78%) Dynamics CRM
3 8 (0.63%) Adobe Campaign
4 7 (0.55%) Dynamics NAV
5 6 (0.47%) NetSuite
5 6 (0.47%) Oracle Applications
6 5 (0.39%) Oracle Procure-to-Pay
6 5 (0.39%) SAP S/4HANA
7 4 (0.31%) FINCAD Analytics
7 4 (0.31%) Oracle ERP
8 3 (0.23%) Dynamics AX
8 3 (0.23%) SAP MDM
9 2 (0.16%) Markit EDM
9 2 (0.16%) Oracle BPM
9 2 (0.16%) PolarLake
9 2 (0.16%) Salesforce.com CRM
9 2 (0.16%) SAP ERP
9 2 (0.16%) SAP PM
9 2 (0.16%) Siebel CRM
10 1 (0.078%) SAP Hybris
Cloud Services
1 314 (24.57%) Azure
2 240 (18.78%) AWS
3 229 (17.92%) Power Platform
4 85 (6.65%) Azure Data Factory
5 71 (5.56%) GCP
6 65 (5.09%) Amazon S3
7 42 (3.29%) Serverless
8 41 (3.21%) PaaS
9 34 (2.66%) AWS Lambda
10 31 (2.43%) Amazon EMR
11 21 (1.64%) Amazon SQS
11 21 (1.64%) Dynamics 365
12 18 (1.41%) Amazon Kinesis
12 18 (1.41%) SaaS
13 17 (1.33%) Amazon EC2
13 17 (1.33%) IaaS
14 13 (1.02%) Cloud Computing
15 12 (0.94%) Azure Stack
15 12 (0.94%) PowerApps
16 11 (0.86%) AWS Step Functions
Communications & Networking
1 5 (0.39%) HTTP
2 4 (0.31%) DNS
2 4 (0.31%) Internet
3 3 (0.23%) AMQP
3 3 (0.23%) DKIM
3 3 (0.23%) Firewall
3 3 (0.23%) Kerberos
3 3 (0.23%) SMTP
3 3 (0.23%) WebEx
4 2 (0.16%) FTP
4 2 (0.16%) Radio Access Network
4 2 (0.16%) SNMP
4 2 (0.16%) VLAN
5 1 (0.078%) 2G
5 1 (0.078%) 3G
5 1 (0.078%) 4G
5 1 (0.078%) PuTTY
5 1 (0.078%) Reverse Proxy
5 1 (0.078%) Skype
5 1 (0.078%) Unified Communications
Database & Business Intelligence
1 496 (38.81%) Data Warehouse
2 346 (27.07%) SQL Server
3 302 (23.63%) SQL Server Integration Services
4 226 (17.68%) Power BI
5 182 (14.24%) Big Data
6 156 (12.21%) SQL Server Reporting Services
7 154 (12.05%) Relational Database
8 141 (11.03%) Hadoop
9 126 (9.86%) SQL Server Analysis Services
10 107 (8.37%) Data Lake
11 95 (7.43%) NoSQL
12 93 (7.28%) Amazon Redshift
13 84 (6.57%) Azure SQL Database
14 81 (6.34%) Apache Hive
15 61 (4.77%) Oracle Database
16 59 (4.62%) MySQL
16 59 (4.62%) RDBMS
17 57 (4.46%) Azure SQL Data Warehouse
18 56 (4.38%) PostgreSQL
19 54 (4.23%) Impala
Development Applications
1 111 (8.69%) Git (software)
2 110 (8.61%) JIRA
3 73 (5.71%) Jenkins
4 34 (2.66%) SQL Server Management Studio (SSMS)
5 31 (2.43%) Visual Studio
6 25 (1.96%) Team Foundation Server
7 18 (1.41%) Visual Studio Team System
8 16 (1.25%) Selenium
9 14 (1.10%) Bitbucket
10 13 (1.02%) Subversion
11 12 (0.94%) GitLab
11 12 (0.94%) Maven
12 11 (0.86%) Artifactory
13 9 (0.70%) ERwin
13 9 (0.70%) JUnit
14 8 (0.63%) Cucumber
14 8 (0.63%) Oracle APEX
14 8 (0.63%) Postman
15 7 (0.55%) JMeter
16 6 (0.47%) Eclipse
General
1 271 (21.21%) Finance
2 80 (6.26%) Public Sector
3 64 (5.01%) Banking
4 36 (2.82%) Retail
5 29 (2.27%) Marketing
6 28 (2.19%) Law
7 27 (2.11%) Legal
7 27 (2.11%) Telecoms
8 15 (1.17%) Manufacturing
9 14 (1.10%) Publishing
10 12 (0.94%) Pharmaceutical
11 9 (0.70%) Front Office
12 7 (0.55%) Electronics
13 6 (0.47%) Back Office
13 6 (0.47%) Investment Banking
14 5 (0.39%) Financial Institution
15 4 (0.31%) Advertising
15 4 (0.31%) Aerospace
15 4 (0.31%) Automotive
15 4 (0.31%) Billing
Job Titles
1 443 (34.66%) Developer
2 271 (21.21%) Data Engineer
3 163 (12.75%) Analyst
4 138 (10.80%) Architect
5 119 (9.31%) SQL Developer
6 115 (9.00%) Business Intelligence Developer
7 90 (7.04%) ETL Developer
8 86 (6.73%) Data Architect
9 76 (5.95%) Consultant
10 68 (5.32%) Data Analyst
11 55 (4.30%) Azure Engineer
12 53 (4.15%) AWS Engineer
13 39 (3.05%) Data Warehouse Developer
14 35 (2.74%) Business Analyst
15 33 (2.58%) Technical Analyst
16 32 (2.50%) SQL BI Developer
17 30 (2.35%) Big Data Engineer
18 28 (2.19%) ETL Analyst
18 28 (2.19%) Python Engineer
18 28 (2.19%) SQL Analyst
Libraries, Frameworks & Software Standards
1 89 (6.96%) XML
2 74 (5.79%) Web Services
3 70 (5.48%) Kafka
4 50 (3.91%) PySpark
5 45 (3.52%) .NET
6 44 (3.44%) JSON
7 35 (2.74%) REST
8 32 (2.50%) HTML
9 30 (2.35%) RESTful
10 27 (2.11%) CSS
11 19 (1.49%) Middleware
12 18 (1.41%) SOAP
13 16 (1.25%) AngularJS
13 16 (1.25%) scikit-learn
13 16 (1.25%) Spring
13 16 (1.25%) TensorFlow
14 15 (1.17%) Apache NiFi
15 14 (1.10%) Node.js
16 13 (1.02%) MDX
16 13 (1.02%) React
Miscellaneous
1 152 (11.89%) Analytical Skills
2 48 (3.76%) Data Structures
3 34 (2.66%) Reference Data
4 30 (2.35%) Algorithms
4 30 (2.35%) Greenfield Project
5 23 (1.80%) Public Cloud
6 22 (1.72%) Replication
7 18 (1.41%) Management Information System
8 15 (1.17%) Data Centre
9 14 (1.10%) Self-Motivation
10 13 (1.02%) Enterprise Software
10 13 (1.02%) NHS
11 12 (0.94%) User Experience
12 11 (0.86%) Derivative
13 10 (0.78%) Credit Risk
13 10 (0.78%) Fixed Income
13 10 (0.78%) Reinsurance
14 9 (0.70%) Acoustics
14 9 (0.70%) Hedge funds
14 9 (0.70%) Taxonomies
Operating Systems
1 81 (6.34%) Unix
2 56 (4.38%) Linux
3 28 (2.19%) Windows
4 9 (0.70%) Windows Server
5 8 (0.63%) Oracle Linux
6 7 (0.55%) Solaris
7 4 (0.31%) Mac OS X
8 3 (0.23%) Windows 10
8 3 (0.23%) Windows XP
9 2 (0.16%) HPUX
9 2 (0.16%) VMS
9 2 (0.16%) Windows Server 2003
10 1 (0.078%) DC/OS
10 1 (0.078%) Red Hat Enterprise Linux
10 1 (0.078%) Windows Mobile
10 1 (0.078%) Windows Server 2012
10 1 (0.078%) zOS
Processes & Methodologies
1 468 (36.62%) Business Intelligence
2 405 (31.69%) Agile Software Development
3 360 (28.17%) Data Modelling
4 262 (20.50%) Analytics
5 251 (19.64%) Migration
6 199 (15.57%) DevOps
7 164 (12.83%) Data Migration
8 150 (11.74%) Data Engineering
9 130 (10.17%) Data Analysis
10 123 (9.62%) Visualisation
11 118 (9.23%) Kimball Methodology
12 107 (8.37%) ETL Development
13 98 (7.67%) Scrum
14 97 (7.59%) Data Management
15 96 (7.51%) Data Architecture
15 96 (7.51%) Data Integration
16 90 (7.04%) Data Science
17 86 (6.73%) Performance Tuning
18 77 (6.03%) Data Analytics
18 77 (6.03%) Validation
Programming Languages
1 786 (61.50%) SQL
2 282 (22.07%) Python
3 141 (11.03%) T-SQL
4 130 (10.17%) Java
5 103 (8.06%) PL/SQL
6 82 (6.42%) JavaScript
7 75 (5.87%) Scala
8 50 (3.91%) C#
9 44 (3.44%) Shell Script
10 42 (3.29%) Data Analysis Expressions (DAX)
11 41 (3.21%) PowerShell
11 41 (3.21%) R
12 22 (1.72%) VBA
13 21 (1.64%) C
13 21 (1.64%) Perl
13 21 (1.64%) VB
14 15 (1.17%) Ruby
15 14 (1.10%) Bash Shell
16 12 (0.94%) C++
17 11 (0.86%) TypeScript
Qualifications
1 147 (11.50%) Security Cleared
2 136 (10.64%) SC Cleared
3 68 (5.32%) Degree
4 17 (1.33%) BPSS Clearance
5 14 (1.10%) Computer Science Degree
6 10 (0.78%) Postgraduate
7 6 (0.47%) PRINCE2 Practitioner
8 5 (0.39%) AWS Certification
8 5 (0.39%) DBS Check
9 4 (0.31%) ISEB
10 3 (0.23%) DV Cleared
10 3 (0.23%) ISTQB
10 3 (0.23%) Oracle Certification
11 2 (0.16%) ACCA
11 2 (0.16%) CIMA
11 2 (0.16%) Microsoft Certification
12 1 (0.078%) BC Cleared
12 1 (0.078%) Cisco Certification
12 1 (0.078%) ISTQB Foundation Certification
12 1 (0.078%) PMI Certification
Quality Assurance & Compliance
1 83 (6.49%) Data Quality
2 56 (4.38%) QA
3 23 (1.80%) GDPR
4 11 (0.86%) IFRS
4 11 (0.86%) Solvency II
5 4 (0.31%) GxP
6 3 (0.23%) HL7
6 3 (0.23%) SLA
7 2 (0.16%) SNOMED CT
8 1 (0.078%) Disclosure Scotland
8 1 (0.078%) WCAG
System Software
1 46 (3.60%) HDFS
2 37 (2.90%) Docker
3 16 (1.25%) Apache Flume
4 10 (0.78%) Virtual Machines
5 4 (0.31%) Active Directory
6 2 (0.16%) NFS
7 1 (0.078%) Apache ZooKeeper
7 1 (0.078%) GeoWebCache
7 1 (0.078%) Hyper-V
7 1 (0.078%) VMware ESXi
7 1 (0.078%) VMware Infrastructure
7 1 (0.078%) VMware Workstation
Systems Management
1 44 (3.44%) Kubernetes
2 38 (2.97%) Terraform
3 32 (2.50%) Ansible
4 5 (0.39%) Control-M
4 5 (0.39%) Oozie
5 4 (0.31%) Data Guard
5 4 (0.31%) Kibana
5 4 (0.31%) Kubeflow
5 4 (0.31%) Single Sign-On
6 3 (0.23%) Grafana
6 3 (0.23%) HP Quality Center
6 3 (0.23%) Oracle Statspack
6 3 (0.23%) Puppet
7 2 (0.16%) Cisco CUCM
7 2 (0.16%) Failover Clustering
7 2 (0.16%) Hadoop YARN
7 2 (0.16%) Microsoft Clustering
7 2 (0.16%) Opscode Chef
7 2 (0.16%) Oracle RMAN
7 2 (0.16%) Oracle ZFS
Vendors
1 251 (19.64%) Microsoft
2 231 (18.08%) Oracle
3 110 (8.61%) Tableau
4 106 (8.29%) Informatica
5 88 (6.89%) SAP
6 81 (6.34%) Cloudera
7 77 (6.03%) Talend
8 57 (4.46%) Databricks
9 44 (3.44%) Google
10 32 (2.50%) Salesforce.com
11 19 (1.49%) IBM
12 17 (1.33%) Ab Initio
12 17 (1.33%) MapR
12 17 (1.33%) Teradata
13 16 (1.25%) Alteryx
14 15 (1.17%) Adobe
15 11 (0.86%) Cognos
15 11 (0.86%) Hortonworks
16 10 (0.78%) Salesforce Marketing Cloud
17 9 (0.70%) MicroStrategy