Period
to 30 October 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 30 October 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
30 Oct 2020
Same period 2019 Same period 2018
Rank 83 84 109
Rank change year-on-year +1 +25 -10
Contract jobs citing ETL 913 2,323 2,529
As % of all contract jobs advertised in the UK 2.78% 2.74% 2.44%
As % of the Processes & Methodologies category 3.22% 3.16% 2.81%
Number of daily rates quoted 712 1,641 1,773
Median daily rate £463 £475 £450
Median daily rate % change year-on-year -2.63% +5.56% -
10th Percentile £321 £325 £320
90th Percentile £645 £660 £600
UK excluding London median daily rate £450 £445 £425
% change year-on-year +1.12% +4.71% +1.19%
Number of hourly rates quoted 28 14 18
Median hourly rate £35.00 £35.00 £35.00
10th Percentile £16.98 £22.19 £14.50
90th Percentile £42.00 £53.00 £48.05
UK excluding London median hourly rate £35.00 £35.00 £35.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 28,363 73,425 90,156
As % of all contract IT jobs advertised in the UK 86.41% 86.51% 87.07%
Number of daily rates quoted 17,871 48,212 59,573
Median daily rate £475 £475 £455
Median daily rate % change year-on-year - +4.40% +1.11%
10th Percentile £298 £300 £300
90th Percentile £663 £650 £638
UK excluding London median daily rate £435 £438 £425
% change year-on-year -0.57% +2.94% +6.25%
Number of hourly rates quoted 1,015 2,318 2,414
Median hourly rate £35.00 £23.75 £21.11
Median hourly rate % change year-on-year +47.37% +12.51% -11.12%
10th Percentile £12.43 £11.85 £11.18
90th Percentile £55.00 £53.75 £50.00
Median hourly rate £26.96 £22.50 £20.50
% change year-on-year +19.82% +9.76% -14.58%

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 30 October 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 30 October 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 30 October 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 -8 740 £468 -1.58% 242
UK excluding London +17 404 £450 +1.12% 150
London -35 355 £500 - 114
Work from Home +26 229 £500 +11.11% 35
North of England +32 95 £425 - 47
South East 0 92 £500 +11.11% 30
North West +42 71 £432 +1.05% 27
East of England +50 69 £475 +5.56% 14
Midlands +21 66 £387 -9.06% 27
East Midlands +31 33 £387 -9.06% 11
West Midlands +18 33 £381 -7.58% 16
South West +26 30 £450 +2.27% 7
Scotland +24 30 £438 -2.78% 18
Yorkshire +13 20 £375 -11.76% 14
Northern Ireland +22 16 £431 +91.56% 4
Wales +18 8 £525 +43.84% 3
North East +33 5 £550 +25.71% 6

For the 6 months to 30 October 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 481 (52.68%) SQL
2 283 (31.00%) Data Warehouse
3 268 (29.35%) Business Intelligence
4 267 (29.24%) Data Modelling
5 265 (29.03%) Agile Software Development
6 219 (23.99%) Python
7 207 (22.67%) Azure
8 199 (21.80%) Oracle
9 181 (19.82%) AWS
10 176 (19.28%) Analytics
10 176 (19.28%) Migration
11 161 (17.63%) Big Data
11 161 (17.63%) Security Cleared
12 155 (16.98%) SQL Server
13 153 (16.76%) Java
14 145 (15.88%) SC Cleared
15 140 (15.33%) Finance
16 138 (15.12%) Relational Database
16 138 (15.12%) Power Platform
17 137 (15.01%) Power BI
17 137 (15.01%) Data Migration
18 133 (14.57%) Microsoft
19 129 (14.13%) DevOps
20 120 (13.14%) Hadoop
21 110 (12.05%) SQL Server Integration Services
22 107 (11.72%) Apache Spark
23 104 (11.39%) Unix
24 98 (10.73%) Data Analysis
24 98 (10.73%) Data Integration
25 97 (10.62%) Scrum

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 107 (11.72%) Apache Spark
2 55 (6.02%) Apache
3 33 (3.61%) SAS
4 17 (1.86%) WebLogic
5 16 (1.75%) Apache Airflow
6 14 (1.53%) Oracle SOA Suite
7 13 (1.42%) Confluence
8 12 (1.31%) IIS
9 11 (1.20%) Elasticsearch
9 11 (1.20%) SharePoint
10 8 (0.88%) Oracle Service Bus
11 7 (0.77%) MQSeries
11 7 (0.77%) WebSphere
12 6 (0.66%) ArcGIS
12 6 (0.66%) Tomcat
13 5 (0.55%) BizTalk Server
13 5 (0.55%) GeoServer
14 3 (0.33%) Cloud Foundry
15 2 (0.22%) Jupyter
15 2 (0.22%) nginx
Applications
1 48 (5.26%) Microsoft Excel
2 27 (2.96%) Spreadsheet
3 13 (1.42%) Microsoft Office
4 6 (0.66%) MS Visio
5 4 (0.44%) SPSS
6 3 (0.33%) Microsoft Project
7 2 (0.22%) LaTeX
7 2 (0.22%) Microsoft PowerPoint
8 1 (0.11%) Chatbot
Business Applications
1 11 (1.20%) Dynamics CRM
2 10 (1.10%) Oracle EBS
3 8 (0.88%) Sparx Enterprise Architect
4 7 (0.77%) Oracle EBS R12
5 5 (0.55%) Dynamics AX
5 5 (0.55%) SAP MDG
6 3 (0.33%) NetSuite
6 3 (0.33%) SAP MDM
6 3 (0.33%) SAP S/4HANA
6 3 (0.33%) SnowdropKCS
7 2 (0.22%) Cognos Business Intelligence
7 2 (0.22%) SAP IS-U
7 2 (0.22%) Unit4 Business World
7 2 (0.22%) Workday HCM
8 1 (0.11%) Oracle BRM
8 1 (0.11%) Oracle FAH
8 1 (0.11%) Oracle General Ledger
8 1 (0.11%) Oracle Payables
8 1 (0.11%) Oracle Receivables
8 1 (0.11%) Sage X3
Cloud Services
1 207 (22.67%) Azure
2 181 (19.82%) AWS
3 138 (15.12%) Power Platform
4 77 (8.43%) Amazon S3
4 77 (8.43%) GCP
5 61 (6.68%) Azure Data Factory
6 27 (2.96%) Amazon EMR
7 25 (2.74%) Serverless
8 23 (2.52%) AWS Lambda
9 22 (2.41%) SaaS
10 21 (2.30%) PaaS
10 21 (2.30%) PowerApps
11 20 (2.19%) Amazon SQS
12 13 (1.42%) AWS CloudFormation
13 12 (1.31%) Logic Apps
14 10 (1.10%) Dynamics 365
14 10 (1.10%) OpenShift
15 8 (0.88%) Amazon SageMaker
15 8 (0.88%) GitHub
15 8 (0.88%) IaaS
Communications & Networking
1 14 (1.53%) Firewall
2 7 (0.77%) HTTP
3 5 (0.55%) DNS
3 5 (0.55%) Reverse Proxy
4 3 (0.33%) Internet
4 3 (0.33%) SSL
5 2 (0.22%) Extranet
5 2 (0.22%) FTP
5 2 (0.22%) Kerberos
5 2 (0.22%) TCP/IP
6 1 (0.11%) DSL
6 1 (0.11%) LTE
6 1 (0.11%) Network Security
6 1 (0.11%) SMS
6 1 (0.11%) SSH
Database & Business Intelligence
1 283 (31.00%) Data Warehouse
2 161 (17.63%) Big Data
3 155 (16.98%) SQL Server
4 138 (15.12%) Relational Database
5 137 (15.01%) Power BI
6 120 (13.14%) Hadoop
7 110 (12.05%) SQL Server Integration Services
8 86 (9.42%) Data Lake
9 82 (8.98%) MySQL
10 80 (8.76%) Pentaho
11 79 (8.65%) Apache Hive
12 61 (6.68%) Amazon Redshift
13 60 (6.57%) Impala
13 60 (6.57%) NoSQL
14 59 (6.46%) SQL Server Reporting Services
15 57 (6.24%) SQL Server Analysis Services
16 55 (6.02%) Tableau
17 54 (5.91%) Azure SQL Database
18 50 (5.48%) DataStage
19 43 (4.71%) Oracle Database
Development Applications
1 83 (9.09%) Git (software)
2 63 (6.90%) Jenkins
3 51 (5.59%) JIRA
4 30 (3.29%) Selenium
5 18 (1.97%) Cucumber
6 15 (1.64%) JMeter
7 14 (1.53%) Visual Studio
8 11 (1.20%) ERwin
8 11 (1.20%) SQL Server Management Studio (SSMS)
9 10 (1.10%) GitLab
9 10 (1.10%) JUnit
10 9 (0.99%) Ant
10 9 (0.99%) Eclipse
10 9 (0.99%) LoadRunner
10 9 (0.99%) SoapUI
10 9 (0.99%) Team Foundation Server
10 9 (0.99%) Toad
11 8 (0.88%) Maven
11 8 (0.88%) Postman
11 8 (0.88%) Sonatype Nexus
General
1 140 (15.33%) Finance
2 70 (7.67%) Public Sector
3 57 (6.24%) Banking
4 37 (4.05%) Marketing
5 25 (2.74%) Retail
6 19 (2.08%) Pharmaceutical
7 10 (1.10%) Investment Banking
7 10 (1.10%) Law
7 10 (1.10%) Legal
7 10 (1.10%) Publishing
7 10 (1.10%) Telecoms
8 9 (0.99%) Advertising
8 9 (0.99%) Financial Institution
9 7 (0.77%) Games
9 7 (0.77%) Manufacturing
10 5 (0.55%) Aerospace
11 4 (0.44%) Billing
11 4 (0.44%) Front Office
12 3 (0.33%) French Language
12 3 (0.33%) German Language
Job Titles
1 300 (32.86%) Developer
2 203 (22.23%) Data Engineer
3 105 (11.50%) Architect
4 80 (8.76%) Analyst
5 65 (7.12%) ETL Developer
6 59 (6.46%) Data Architect
7 49 (5.37%) Business Intelligence Developer
8 43 (4.71%) SQL Developer
9 34 (3.72%) Pentaho Developer
10 33 (3.61%) Data Analyst
11 32 (3.50%) Consultant
12 31 (3.40%) AWS Engineer
13 30 (3.29%) Azure Engineer
14 25 (2.74%) Python Engineer
14 25 (2.74%) Solutions Architect
15 24 (2.63%) Administrator
15 24 (2.63%) Senior Developer
16 23 (2.52%) Big Data Engineer
16 23 (2.52%) Senior Data Engineer
17 21 (2.30%) Ab Initio Developer
Libraries, Frameworks & Software Standards
1 46 (5.04%) Web Services
2 42 (4.60%) XML
3 41 (4.49%) Kafka
4 38 (4.16%) PySpark
5 36 (3.94%) JSON
6 34 (3.72%) RESTful
7 32 (3.50%) REST
8 31 (3.40%) SOAP
9 28 (3.07%) Spring
10 26 (2.85%) .NET
11 20 (2.19%) HTML
12 16 (1.75%) CSS
12 16 (1.75%) Middleware
13 14 (1.53%) Apache NiFi
14 12 (1.31%) AngularJS
14 12 (1.31%) React
15 11 (1.20%) Apache Beam
15 11 (1.20%) Spring Boot
16 10 (1.10%) Oracle Fusion
16 10 (1.10%) RabbitMQ
Miscellaneous
1 93 (10.19%) Analytical Skills
2 35 (3.83%) Greenfield Project
3 29 (3.18%) Data Structures
4 24 (2.63%) Management Information System
5 20 (2.19%) Virtual Team
6 14 (1.53%) Self-Motivation
6 14 (1.53%) User Experience
7 12 (1.31%) Algorithms
8 11 (1.20%) Credit Risk
8 11 (1.20%) FMCG
9 10 (1.10%) Public Cloud
10 8 (0.88%) NHS
10 8 (0.88%) Reference Data
11 6 (0.66%) Cloud Native
11 6 (0.66%) Enterprise Software
11 6 (0.66%) Social Media
12 5 (0.55%) Blog
12 5 (0.55%) EPoS
12 5 (0.55%) Hybrid Cloud
12 5 (0.55%) Replication
Operating Systems
1 104 (11.39%) Unix
2 68 (7.45%) Linux
3 15 (1.64%) Windows
4 6 (0.66%) Windows Server
5 5 (0.55%) Solaris
5 5 (0.55%) Windows Server 2012
6 4 (0.44%) Mac OS X
7 2 (0.22%) Ubuntu
7 2 (0.22%) Windows Server 2016
8 1 (0.11%) Android
8 1 (0.11%) Apple iOS
8 1 (0.11%) Red Hat Enterprise Linux
Processes & Methodologies
1 268 (29.35%) Business Intelligence
2 267 (29.24%) Data Modelling
3 265 (29.03%) Agile Software Development
4 176 (19.28%) Analytics
4 176 (19.28%) Migration
5 137 (15.01%) Data Migration
6 129 (14.13%) DevOps
7 98 (10.73%) Data Analysis
7 98 (10.73%) Data Integration
8 97 (10.62%) Scrum
9 92 (10.08%) Data Engineering
10 89 (9.75%) Visualisation
11 81 (8.87%) Problem-Solving
12 80 (8.76%) Data Science
13 73 (8.00%) Test Automation
14 70 (7.67%) ETL Development
15 62 (6.79%) Configuration Management
16 61 (6.68%) Performance Tuning
17 58 (6.35%) Data Architecture
18 56 (6.13%) Unit Testing
Programming Languages
1 481 (52.68%) SQL
2 219 (23.99%) Python
3 153 (16.76%) Java
4 55 (6.02%) Scala
5 48 (5.26%) PL/SQL
6 46 (5.04%) JavaScript
7 45 (4.93%) T-SQL
8 34 (3.72%) Shell Script
9 33 (3.61%) C#
10 26 (2.85%) R
11 19 (2.08%) Perl
11 19 (2.08%) PowerShell
12 16 (1.75%) Data Analysis Expressions (DAX)
13 15 (1.64%) Bash Shell
14 13 (1.42%) C++
15 12 (1.31%) Java 8
16 10 (1.10%) C
17 8 (0.88%) Go
17 8 (0.88%) Ruby
17 8 (0.88%) TypeScript
Qualifications
1 161 (17.63%) Security Cleared
2 145 (15.88%) SC Cleared
3 35 (3.83%) Degree
4 14 (1.53%) ISTQB
5 13 (1.42%) DV Cleared
6 12 (1.31%) BPSS Clearance
6 12 (1.31%) ISEB
6 12 (1.31%) ISTQB Foundation Certification
7 9 (0.99%) AWS Certification
8 7 (0.77%) Computer Science Degree
9 2 (0.22%) DBS Check
9 2 (0.22%) Master's Degree
9 2 (0.22%) Postgraduate
10 1 (0.11%) ACCA
10 1 (0.11%) CSPO
10 1 (0.11%) MBA
10 1 (0.11%) TOGAF Certification
Quality Assurance & Compliance
1 75 (8.21%) Data Quality
2 68 (7.45%) QA
3 7 (0.77%) GxP
4 6 (0.66%) GDPR
5 5 (0.55%) Sarbanes-Oxley
6 3 (0.33%) IFRS
6 3 (0.33%) MiFID
6 3 (0.33%) SLA
7 2 (0.22%) ISO/IEC 20000
8 1 (0.11%) Disclosure Scotland
8 1 (0.11%) IFRS 9
8 1 (0.11%) Solvency II
System Software
1 64 (7.01%) HDFS
2 27 (2.96%) Docker
3 14 (1.53%) Active Directory
4 6 (0.66%) Apache ZooKeeper
5 5 (0.55%) GeoWebCache
5 5 (0.55%) Hyper-V
5 5 (0.55%) VMware ESXi
5 5 (0.55%) VMware Infrastructure
5 5 (0.55%) VMware Workstation
6 2 (0.22%) Apache Flume
7 1 (0.11%) Samba
7 1 (0.11%) Virtual Machines
Systems Management
1 37 (4.05%) Ansible
2 31 (3.40%) Kubernetes
3 24 (2.63%) Terraform
4 7 (0.77%) Hadoop YARN
5 6 (0.66%) Grafana
6 5 (0.55%) Kibana
6 5 (0.55%) Opscode Chef
6 5 (0.55%) Puppet
7 4 (0.44%) Control-M
7 4 (0.44%) Oozie
8 3 (0.33%) HP Quality Center
9 2 (0.22%) HP ALM
9 2 (0.22%) Mesos
9 2 (0.22%) Tivoli
10 1 (0.11%) Amdocs OSS
10 1 (0.11%) Istio
10 1 (0.11%) Knative
10 1 (0.11%) Kubeflow
10 1 (0.11%) logstash
10 1 (0.11%) Prometheus
Vendors
1 199 (21.80%) Oracle
2 133 (14.57%) Microsoft
3 90 (9.86%) Informatica
4 83 (9.09%) Talend
5 64 (7.01%) Google
6 61 (6.68%) Cloudera
7 57 (6.24%) SAP
8 49 (5.37%) Databricks
8 49 (5.37%) IBM
9 36 (3.94%) Ab Initio
10 23 (2.52%) Teradata
11 16 (1.75%) Cognos
12 15 (1.64%) Alteryx
13 14 (1.53%) MuleSoft
14 12 (1.31%) MicroStrategy
14 12 (1.31%) Salesforce.com
14 12 (1.31%) TIBCO
15 10 (1.10%) Splunk
16 9 (0.99%) Sparx
17 8 (0.88%) ESRI