Period
to 17 October 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 October 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 Oct 2019
Same period 2018 Same period 2017
Rank 86 110 105
Rank change year-on-year +24 -5 -13
Contract jobs citing ETL 2,363 2,457 2,425
As % of all contract IT jobs advertised in the UK 2.78% 2.38% 2.44%
As % of the Processes & Methodologies category 3.21% 2.74% 2.83%
Number of daily rates quoted 1,639 1,714 1,650
UK median daily rate £475 £450 £450
Median daily rate % change year-on-year +5.50% +0.06% +5.88%
10th Percentile £325 £319 £313
90th Percentile £651 £600 £600
UK excluding London median daily rate £444 £425 £425
% change year-on-year +4.41% - +6.25%
Number of hourly rates quoted 14 17 27
UK median hourly rate £35.00 £35.00 £45.00
Median hourly rate % change year-on-year - -22.22% +2.27%
10th Percentile £22.19 £14.32 £34.30
90th Percentile £45.78 £48.15 £67.50
UK excluding London median hourly rate £35.00 £35.00 £46.21
% change year-on-year - -24.26% +5.02%

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 73,535 89,538 85,627
As % of all contract IT jobs advertised in the UK 86.42% 86.78% 86.23%
Number of daily rates quoted 48,274 59,055 56,652
UK median daily rate £475 £450 £450
Median daily rate % change year-on-year +5.56% - +5.88%
10th Percentile £300 £300 £278
90th Percentile £650 £638 £625
UK excluding London median daily rate £438 £425 £400
% change year-on-year +2.94% +6.25% -
Number of hourly rates quoted 2,262 2,433 2,077
UK median hourly rate £24.00 £20.50 £24.87
Median hourly rate % change year-on-year +17.07% -17.57% +10.53%
10th Percentile £11.81 £11.18 £11.25
90th Percentile £53.75 £50.00 £50.00
UK excluding London median hourly rate £23.21 £20.00 £25.00
% change year-on-year +16.04% -20.00% +6.38%

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 October 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 October 2019.

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 17 October 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 +23 2,186 £475 +4.40% 529
London +30 1,221 £500 - 252
UK excluding London +14 1,099 £444 +4.41% 314
South East +31 374 £450 +0.56% 76
North of England -8 214 £425 +13.33% 86
Midlands +43 142 £425 - 58
North West +13 121 £425 +13.33% 49
South West -16 118 £445 +1.71% 39
East of England +7 111 £460 -3.16% 18
Scotland -3 99 £450 - 29
West Midlands +59 85 £425 - 35
Yorkshire -11 85 £425 +9.68% 25
East Midlands +12 55 £425 -2.86% 22
Wales +31 30 £365 -27.00% 7
North East +12 9 £438 +25.00% 12
Northern Ireland +2 8 £229 -48.80% 1
Isle of Man - 3 - -

For the 6 months to 17 October 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,498 (63.39%) SQL
2 930 (39.36%) Data Warehouse
3 812 (34.36%) Business Intelligence
4 743 (31.44%) Agile Software Development
5 741 (31.36%) SQL Server
6 667 (28.23%) SQL Server Integration Services
7 573 (24.25%) Data Modelling
8 541 (22.89%) Python
9 482 (20.40%) Microsoft
10 469 (19.85%) Azure
11 465 (19.68%) Oracle
12 444 (18.79%) Migration
13 443 (18.75%) Finance
14 431 (18.24%) AWS
15 423 (17.90%) Analytics
16 405 (17.14%) Power BI
16 405 (17.14%) Power Platform
17 354 (14.98%) Big Data
18 319 (13.50%) Data Migration
19 317 (13.42%) Hadoop
20 308 (13.03%) T-SQL
21 306 (12.95%) SQL Server Reporting Services
22 301 (12.74%) Apache Spark
23 294 (12.44%) Java
24 273 (11.55%) SQL Server Analysis Services
25 265 (11.21%) Visualisation
25 265 (11.21%) DevOps
26 264 (11.17%) Scrum
27 241 (10.20%) Analytical Skills
28 240 (10.16%) Tableau

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 301 (12.74%) Apache Spark
2 105 (4.44%) Apache
3 102 (4.32%) SAS
4 54 (2.29%) Confluence
5 47 (1.99%) Apache Airflow
5 47 (1.99%) SharePoint
6 32 (1.35%) Elasticsearch
7 14 (0.59%) Tomcat
8 13 (0.55%) Apache Pig
8 13 (0.55%) Luigi
9 12 (0.51%) CMS
9 12 (0.51%) WebLogic
10 10 (0.42%) Pachyderm
11 9 (0.38%) Jupyter
12 7 (0.30%) JBoss
13 6 (0.25%) WebLogic Integration
14 4 (0.17%) Apache Solr
14 4 (0.17%) IIS
14 4 (0.17%) MQSeries
14 4 (0.17%) Oracle SOA Suite
Applications
1 178 (7.53%) Microsoft Excel
2 33 (1.40%) Microsoft Office
3 26 (1.10%) Spreadsheet
4 23 (0.97%) MS Visio
5 20 (0.85%) SPSS
6 17 (0.72%) XMetaL
7 10 (0.42%) Microsoft PowerPoint
8 5 (0.21%) Stata
9 2 (0.085%) Microsoft Project
10 1 (0.042%) S-PLUS
Business Applications
1 21 (0.89%) Dynamics CRM
2 16 (0.68%) Oracle EBS
3 10 (0.42%) Oracle Applications
4 9 (0.38%) Dynamics AX
4 9 (0.38%) Oracle EBS R12
5 8 (0.34%) FINCAD Analytics
5 8 (0.34%) NetSuite
5 8 (0.34%) SAP Oil and Gas
5 8 (0.34%) SAP S/4HANA
6 7 (0.30%) Oracle Financials
7 6 (0.25%) Dynamics NAV
7 6 (0.25%) Sparx Enterprise Architect
7 6 (0.25%) Unit4 Business World
8 5 (0.21%) Markit EDM
9 4 (0.17%) Oracle AML
10 3 (0.13%) Adobe Campaign
10 3 (0.13%) Hyperion Planning
10 3 (0.13%) Oracle HRMS
11 2 (0.085%) HFM
11 2 (0.085%) Oracle Payroll
Cloud Services
1 469 (19.85%) Azure
2 431 (18.24%) AWS
3 405 (17.14%) Power Platform
4 168 (7.11%) GCP
5 108 (4.57%) Azure Data Factory
6 103 (4.36%) Amazon S3
7 92 (3.89%) Serverless
8 71 (3.00%) Amazon EMR
9 62 (2.62%) AWS Lambda
10 59 (2.50%) GitHub
11 43 (1.82%) Dynamics 365
12 36 (1.52%) Cloud Computing
13 25 (1.06%) Amazon SQS
14 23 (0.97%) Google Sheets
15 21 (0.89%) Amazon Kinesis
16 20 (0.85%) Azure Functions
16 20 (0.85%) PaaS
17 18 (0.76%) Amazon EC2
17 18 (0.76%) SaaS
18 17 (0.72%) Office 365
Communications & Networking
1 24 (1.02%) FTP
2 23 (0.97%) Internet
3 7 (0.30%) Firewall
4 5 (0.21%) HTTP
5 4 (0.17%) F5 BIG-IP GTM
5 4 (0.17%) F5 BIG-IP LTM
5 4 (0.17%) SMTP
6 2 (0.085%) HTTPS
6 2 (0.085%) Intranet
6 2 (0.085%) Skype
6 2 (0.085%) SSH
6 2 (0.085%) VPN
7 1 (0.042%) 2G
7 1 (0.042%) 3G
7 1 (0.042%) 4G
7 1 (0.042%) Kerberos
7 1 (0.042%) LAN
7 1 (0.042%) Node B
7 1 (0.042%) RNC
7 1 (0.042%) SSL
Database & Business Intelligence
1 930 (39.36%) Data Warehouse
2 741 (31.36%) SQL Server
3 667 (28.23%) SQL Server Integration Services
4 405 (17.14%) Power BI
5 354 (14.98%) Big Data
6 317 (13.42%) Hadoop
7 306 (12.95%) SQL Server Reporting Services
8 273 (11.55%) SQL Server Analysis Services
9 236 (9.99%) Relational Database
10 177 (7.49%) Amazon Redshift
11 156 (6.60%) NoSQL
12 153 (6.47%) Data Lake
13 143 (6.05%) Apache Hive
14 142 (6.01%) Oracle Database
15 120 (5.08%) PostgreSQL
16 114 (4.82%) Azure SQL Database
17 112 (4.74%) MySQL
18 97 (4.10%) MongoDB
19 94 (3.98%) SQL Server 2012
20 92 (3.89%) BigQuery
Development Applications
1 177 (7.49%) Git (software)
2 147 (6.22%) JIRA
3 111 (4.70%) Jenkins
4 64 (2.71%) Visual Studio
5 40 (1.69%) Team Foundation Server
6 28 (1.18%) Maven
7 26 (1.10%) Selenium
8 24 (1.02%) Visual Studio Team System
9 20 (0.85%) Artifactory
10 18 (0.76%) Cucumber
11 17 (0.72%) ERwin
12 15 (0.63%) SQL Server Management Studio (SSMS)
13 14 (0.59%) JUnit
14 13 (0.55%) Atlassian Bamboo
14 13 (0.55%) Eclipse
15 12 (0.51%) Sonatype Nexus
16 11 (0.47%) TeamCity
16 11 (0.47%) WebDriver
17 9 (0.38%) Bitbucket
17 9 (0.38%) JMeter
General
1 443 (18.75%) Finance
2 122 (5.16%) Banking
3 118 (4.99%) Public Sector
4 108 (4.57%) Retail
5 68 (2.88%) Telecoms
6 53 (2.24%) Front Office
7 46 (1.95%) Legal
8 44 (1.86%) Marketing
9 34 (1.44%) Publishing
10 31 (1.31%) Investment Banking
11 21 (0.89%) Manufacturing
12 20 (0.85%) Back Office
13 18 (0.76%) Pharmaceutical
14 16 (0.68%) Retail Banking
15 13 (0.55%) Electronics
16 12 (0.51%) Advertising
16 12 (0.51%) Games
17 9 (0.38%) Local Government
18 8 (0.34%) Financial Institution
19 5 (0.21%) Automotive
Job Titles
1 981 (41.52%) Developer
2 366 (15.49%) Data Engineer
3 299 (12.65%) Analyst
4 275 (11.64%) SQL Developer
5 228 (9.65%) Business Intelligence Developer
6 221 (9.35%) ETL Developer
7 177 (7.49%) Architect
8 142 (6.01%) Data Analyst
9 126 (5.33%) Data Architect
10 109 (4.61%) Consultant
11 96 (4.06%) Python Engineer
12 93 (3.94%) SSIS Developer
13 70 (2.96%) Senior Developer
14 65 (2.75%) SQL BI Developer
15 63 (2.67%) Python Developer
16 62 (2.62%) Data Warehouse Developer
17 60 (2.54%) SQL Analyst
18 58 (2.45%) AWS Engineer
18 58 (2.45%) SQL Server Developer
19 53 (2.24%) DBA
Libraries, Frameworks & Software Standards
1 174 (7.36%) XML
2 150 (6.35%) Kafka
3 148 (6.26%) .NET
4 117 (4.95%) JSON
5 116 (4.91%) Web Services
6 82 (3.47%) REST
7 70 (2.96%) HTML
8 67 (2.84%) MDX
9 57 (2.41%) PySpark
10 53 (2.24%) SOAP
11 47 (1.99%) RESTful
12 45 (1.90%) Pandas
13 38 (1.61%) Middleware
14 37 (1.57%) CSS
15 34 (1.44%) AngularJS
15 34 (1.44%) Apache Beam
15 34 (1.44%) Spring
16 29 (1.23%) NumPy
17 23 (0.97%) XML Schema
18 22 (0.93%) XSLT
Miscellaneous
1 241 (10.20%) Analytical Skills
2 97 (4.10%) Data Structures
3 64 (2.71%) Algorithms
4 54 (2.29%) Greenfield Project
5 51 (2.16%) Self-Motivation
6 45 (1.90%) Management Information System
7 37 (1.57%) Enterprise Software
8 29 (1.23%) Hedge funds
8 29 (1.23%) Reinsurance
8 29 (1.23%) User Experience
9 23 (0.97%) Replication
10 19 (0.80%) NHS
11 17 (0.72%) Fixed Income
12 15 (0.63%) Public Cloud
13 14 (0.59%) CMDB
13 14 (0.59%) Derivative
13 14 (0.59%) Reference Data
14 12 (0.51%) Clustering
15 11 (0.47%) Taxonomies
16 10 (0.42%) Data Centre
Operating Systems
1 191 (8.08%) Linux
2 133 (5.63%) Unix
3 50 (2.12%) Windows
4 15 (0.63%) AIX
5 12 (0.51%) VMS
6 9 (0.38%) Windows Server
7 6 (0.25%) Oracle Linux
8 4 (0.17%) Solaris
9 3 (0.13%) Android
10 2 (0.085%) Red Hat Enterprise Linux
10 2 (0.085%) Windows 10
Processes & Methodologies
1 812 (34.36%) Business Intelligence
2 743 (31.44%) Agile Software Development
3 573 (24.25%) Data Modelling
4 444 (18.79%) Migration
5 423 (17.90%) Analytics
6 319 (13.50%) Data Migration
7 265 (11.21%) DevOps
7 265 (11.21%) Visualisation
8 264 (11.17%) Scrum
9 220 (9.31%) Data Analysis
10 210 (8.89%) Data Integration
11 208 (8.80%) Data Science
12 191 (8.08%) ETL Development
13 188 (7.96%) Problem-Solving
14 178 (7.53%) Data Management
15 170 (7.19%) Data Engineering
16 156 (6.60%) Data Architecture
17 155 (6.56%) Data Visualisation
18 139 (5.88%) Machine Learning
19 132 (5.59%) Performance Tuning
Programming Languages
1 1,498 (63.39%) SQL
2 541 (22.89%) Python
3 308 (13.03%) T-SQL
4 294 (12.44%) Java
5 193 (8.17%) C#
6 182 (7.70%) PL/SQL
7 145 (6.14%) Scala
8 125 (5.29%) JavaScript
9 98 (4.15%) R
10 87 (3.68%) Shell Script
11 83 (3.51%) Data Analysis Expressions (DAX)
12 75 (3.17%) PowerShell
13 38 (1.61%) VBA
14 31 (1.31%) VB
15 29 (1.23%) Perl
16 24 (1.02%) VB.NET
17 23 (0.97%) C++
18 22 (0.93%) Bash Shell
19 21 (0.89%) C
20 20 (0.85%) XQuery
Qualifications
1 153 (6.47%) Security Cleared
2 152 (6.43%) Degree
3 127 (5.37%) SC Cleared
4 61 (2.58%) Computer Science Degree
5 20 (0.85%) TOGAF Certification
6 16 (0.68%) ISEB
7 15 (0.63%) Master's Degree
8 14 (0.59%) ISTQB
9 12 (0.51%) Microsoft Certification
10 9 (0.38%) DBS Check
11 8 (0.34%) Cisco Certification
12 7 (0.30%) BPSS Clearance
12 7 (0.30%) DV Cleared
13 6 (0.25%) CFA
13 6 (0.25%) CIMA
13 6 (0.25%) Numerate Degree
14 5 (0.21%) ACCA
14 5 (0.21%) AWS Certification
14 5 (0.21%) MCSE
15 4 (0.17%) (ISC)2 CCSP
Quality Assurance & Compliance
1 192 (8.13%) Data Quality
2 87 (3.68%) QA
3 43 (1.82%) GDPR
4 11 (0.47%) IFRS
5 8 (0.34%) SLA
6 7 (0.30%) Solvency II
7 6 (0.25%) PMO
8 5 (0.21%) ISO/IEC 27001
9 2 (0.085%) HL7
9 2 (0.085%) IFRS 9
9 2 (0.085%) MiFID
10 1 (0.042%) Basel III
10 1 (0.042%) GxP
10 1 (0.042%) ISO 20022
10 1 (0.042%) ISO/IEC 27002 (supersedes ISO/IEC 17799)
10 1 (0.042%) PCI DSS
System Software
1 117 (4.95%) Docker
2 44 (1.86%) HDFS
3 19 (0.80%) Tivoli Workload Scheduler
4 18 (0.76%) Active Directory
5 14 (0.59%) Apache Flume
6 11 (0.47%) Oracle RAC
7 9 (0.38%) VirtualBox
8 4 (0.17%) VMware Infrastructure
9 2 (0.085%) Virtual Machines
10 1 (0.042%) Apache ZooKeeper
10 1 (0.042%) Postfix
Systems Management
1 98 (4.15%) Kubernetes
2 60 (2.54%) Terraform
3 51 (2.16%) Ansible
4 29 (1.23%) Hadoop YARN
5 19 (0.80%) Tivoli
6 13 (0.55%) Control-M
7 11 (0.47%) Kubeflow
8 9 (0.38%) Docker Swarm
8 9 (0.38%) Oozie
9 6 (0.25%) Grafana
9 6 (0.25%) Kibana
10 5 (0.21%) Graphite
10 5 (0.21%) HP ALM
10 5 (0.21%) Opscode Chef
10 5 (0.21%) Oracle RMAN
11 4 (0.17%) Data Guard
11 4 (0.17%) FortiGate
11 4 (0.17%) Puppet
12 3 (0.13%) Istio
12 3 (0.13%) linkerd
Vendors
1 482 (20.40%) Microsoft
2 465 (19.68%) Oracle
3 240 (10.16%) Tableau
4 179 (7.58%) Informatica
5 167 (7.07%) Google
6 138 (5.84%) Talend
7 104 (4.40%) SAP
8 86 (3.64%) Teradata
9 73 (3.09%) Databricks
10 71 (3.00%) IBM
11 54 (2.29%) Cloudera
12 53 (2.24%) Alteryx
13 46 (1.95%) Salesforce.com
14 38 (1.61%) Cognos
15 32 (1.35%) MicroStrategy
16 24 (1.02%) Ab Initio
17 23 (0.97%) Hortonworks
17 23 (0.97%) Remedy
18 18 (0.76%) MuleSoft
19 17 (0.72%) HP