Period
to 18 July 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 18 July 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
18 Jul 2019
Same period 2018 Same period 2017
Rank 90 104 105
Rank change year-on-year +14 +1 -7
Contract jobs citing ETL 2,440 2,482 2,253
As % of all contract IT jobs advertised in the UK 2.63% 2.40% 2.37%
As % of the Processes & Methodologies category 3.03% 2.77% 2.77%
Number of daily rates quoted 1,662 1,736 1,481
UK median daily rate £460 £450 £450
Median daily rate % change year-on-year +2.22% - +5.88%
10th Percentile £328 £313 £313
90th Percentile £630 £606 £588
UK excluding London median daily rate £425 £425 £400
% change year-on-year - +6.25% -
Number of hourly rates quoted 19 17 16
UK median hourly rate £35.00 £43.00 £38.75
Median hourly rate % change year-on-year -18.60% +10.97% +89.02%
10th Percentile £20.31 £34.20 £17.50
90th Percentile £49.25 £71.30 £67.50
UK excluding London median hourly rate £27.94 £35.00 £35.00
% change year-on-year -20.17% - +70.73%

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 80,502 89,695 81,430
As % of all contract IT jobs advertised in the UK 86.90% 86.67% 85.70%
Number of daily rates quoted 52,992 59,180 53,286
UK median daily rate £475 £450 £443
Median daily rate % change year-on-year +5.56% +1.69% +4.12%
10th Percentile £300 £300 £275
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,296 2,452 2,151
UK median hourly rate £24.84 £21.50 £25.00
Median hourly rate % change year-on-year +15.51% -14.00% +3.52%
10th Percentile £11.85 £11.17 £11.50
90th Percentile £52.50 £50.00 £52.50
UK excluding London median hourly rate £23.96 £20.50 £25.00
% change year-on-year +16.85% -18.00% -

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 18 July 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 18 July 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 18 July 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 +12 2,239 £475 +2.70% 527
London +14 1,243 £500 - 233
UK excluding London +19 1,164 £425 - 327
South East +4 305 £450 +2.86% 70
North of England +9 237 £405 +4.52% 110
Midlands +43 193 £425 - 62
East of England +24 165 £469 +4.17% 23
Scotland -4 126 £440 +10.00% 14
North West +24 125 £400 +6.67% 65
West Midlands +52 104 £450 +5.88% 33
South West -32 92 £435 - 30
East Midlands +15 86 £425 +5.26% 28
Yorkshire -21 84 £425 +6.25% 35
Wales +19 35 £358 -1.38% 15
North East +39 26 £344 -1.79% 10
Northern Ireland +5 11 £373 -13.77% 4
Isle of Man +2 3 - -

For the 6 months to 18 July 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,553 (63.65%) SQL
2 1,019 (41.76%) Data Warehouse
3 845 (34.63%) Business Intelligence
4 761 (31.19%) Agile Software Development
5 758 (31.07%) SQL Server
6 679 (27.83%) SQL Server Integration Services
7 579 (23.73%) Data Modelling
8 567 (23.24%) Oracle
9 515 (21.11%) Python
10 497 (20.37%) Finance
11 477 (19.55%) Microsoft Azure
12 445 (18.24%) Microsoft
13 436 (17.87%) Migration
14 421 (17.25%) Amazon AWS
15 411 (16.84%) Big Data
16 388 (15.90%) Analytics
17 369 (15.12%) Power BI
17 369 (15.12%) Power Platform
18 362 (14.84%) T-SQL
19 345 (14.14%) Data Migration
20 300 (12.30%) SQL Server Reporting Services
21 296 (12.13%) Java
21 296 (12.13%) Hadoop
22 293 (12.01%) Apache Spark
23 276 (11.31%) Analytical Skills
24 244 (10.00%) Scrum
25 243 (9.96%) Relational Database
26 241 (9.88%) SQL Server Analysis Services
27 230 (9.43%) Visualisation
28 225 (9.22%) Problem-Solving

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 293 (12.01%) Apache Spark
2 121 (4.96%) Apache
3 116 (4.75%) SAS
4 66 (2.70%) Confluence
5 53 (2.17%) SharePoint
6 42 (1.72%) Apache Airflow
7 32 (1.31%) Elasticsearch
8 20 (0.82%) Apache Pig
8 20 (0.82%) Tomcat
9 19 (0.78%) Luigi
10 15 (0.61%) JBoss
11 14 (0.57%) Pachyderm
12 11 (0.45%) CMS
13 6 (0.25%) IIS
14 5 (0.20%) Adobe Experience Manager
14 5 (0.20%) Apache Solr
15 4 (0.16%) Drupal
15 4 (0.16%) MQSeries
15 4 (0.16%) Oracle SOA Suite
15 4 (0.16%) WebLogic
Applications
1 171 (7.01%) Microsoft Excel
2 30 (1.23%) Spreadsheet
3 20 (0.82%) Microsoft PowerPoint
4 18 (0.74%) Microsoft Office
5 16 (0.66%) MS Visio
5 16 (0.66%) SPSS
6 5 (0.20%) Stata
7 2 (0.082%) Microsoft Project
7 2 (0.082%) Mingle
Business Applications
1 19 (0.78%) Dynamics CRM
2 14 (0.57%) SAP Oil and Gas
3 12 (0.49%) Oracle EBS
4 11 (0.45%) Oracle Financials
5 9 (0.37%) Oracle AML
6 8 (0.33%) Oracle EBS R12
6 8 (0.33%) SAP S/4HANA
7 7 (0.29%) Dynamics AX
7 7 (0.29%) Markit EDM
8 6 (0.25%) Adobe Campaign
8 6 (0.25%) Dynamics NAV
8 6 (0.25%) HFM
9 5 (0.20%) Actimize
9 5 (0.20%) NetSuite
10 4 (0.16%) Oracle Applications
10 4 (0.16%) Oracle HRMS
10 4 (0.16%) SAP CO
10 4 (0.16%) SAP FI
10 4 (0.16%) SAP FI/CO
10 4 (0.16%) Unit4 Business World
Cloud Services
1 477 (19.55%) Microsoft Azure
2 421 (17.25%) Amazon AWS
3 369 (15.12%) Power Platform
4 157 (6.43%) Google Cloud Platform
5 112 (4.59%) Amazon S3
6 91 (3.73%) Azure Data Factory
7 76 (3.11%) Serverless
8 67 (2.75%) Amazon EMR
9 46 (1.89%) AWS Lambda
10 45 (1.84%) Amazon EC2
11 43 (1.76%) Cloud Computing
12 42 (1.72%) GitHub
13 34 (1.39%) Dynamics 365
14 32 (1.31%) Amazon SQS
15 31 (1.27%) PaaS
16 30 (1.23%) Google Sheets
17 29 (1.19%) SaaS
18 26 (1.07%) Amazon CloudWatch
18 26 (1.07%) AWS CloudFormation
19 24 (0.98%) Virtual Private Cloud
Communications & Networking
1 28 (1.15%) Internet
2 12 (0.49%) FTP
3 10 (0.41%) SMTP
4 7 (0.29%) Firewall
4 7 (0.29%) HTTP
4 7 (0.29%) Network Security
5 4 (0.16%) Kerberos
5 4 (0.16%) SSH
6 3 (0.12%) DNS
7 2 (0.082%) DMZ
7 2 (0.082%) HTTPS
7 2 (0.082%) Intranet
7 2 (0.082%) LAN
7 2 (0.082%) OpenLDAP
7 2 (0.082%) RTP
7 2 (0.082%) Skype
7 2 (0.082%) TCP/IP
8 1 (0.041%) 4G
8 1 (0.041%) Node B
8 1 (0.041%) Remote Desktop
Database & Business Intelligence
1 1,019 (41.76%) Data Warehouse
2 758 (31.07%) SQL Server
3 679 (27.83%) SQL Server Integration Services
4 411 (16.84%) Big Data
5 369 (15.12%) Power BI
6 300 (12.30%) SQL Server Reporting Services
7 296 (12.13%) Hadoop
8 243 (9.96%) Relational Database
9 241 (9.88%) SQL Server Analysis Services
10 170 (6.97%) Oracle Database
11 163 (6.68%) NoSQL
12 153 (6.27%) Apache Hive
13 133 (5.45%) MySQL
14 132 (5.41%) PostgreSQL
15 128 (5.25%) Data Lake
16 126 (5.16%) Amazon Redshift
17 111 (4.55%) SQL Server 2012
18 110 (4.51%) MongoDB
19 104 (4.26%) BusinessObjects
20 98 (4.02%) SQL Server 2008
Development Applications
1 172 (7.05%) Git (software)
2 163 (6.68%) JIRA
3 124 (5.08%) Jenkins
4 60 (2.46%) Selenium
5 58 (2.38%) Maven
6 54 (2.21%) Visual Studio
7 42 (1.72%) Cucumber
7 42 (1.72%) Team Foundation Server
8 28 (1.15%) TeamCity
9 27 (1.11%) SpecFlow
10 23 (0.94%) SQL Server Management Studio (SSMS)
11 20 (0.82%) ERwin
11 20 (0.82%) SoapUI
12 19 (0.78%) Bitbucket
12 19 (0.78%) Visual Studio Team System
13 18 (0.74%) Ant
13 18 (0.74%) JUnit
14 17 (0.70%) ER Studio
14 17 (0.70%) JMeter
15 14 (0.57%) tSQLt
General
1 497 (20.37%) Finance
2 147 (6.02%) Banking
3 107 (4.39%) Retail
4 65 (2.66%) Telecoms
5 54 (2.21%) Legal
6 52 (2.13%) Marketing
7 31 (1.27%) Publishing
8 30 (1.23%) Investment Banking
9 29 (1.19%) Front Office
10 25 (1.02%) Manufacturing
11 18 (0.74%) Pharmaceutical
12 17 (0.70%) Back Office
13 16 (0.66%) Retail Banking
14 15 (0.61%) Financial Institution
15 13 (0.53%) Electronics
16 10 (0.41%) Advertising
17 9 (0.37%) Games
18 6 (0.25%) General Ledger
19 5 (0.20%) Billing
19 5 (0.20%) Law
Job Titles
1 993 (40.70%) Developer
2 341 (13.98%) Data Engineer
3 286 (11.72%) Analyst
4 269 (11.02%) SQL Developer
5 235 (9.63%) Business Intelligence Developer
6 211 (8.65%) Architect
7 203 (8.32%) ETL Developer
8 127 (5.20%) Data Analyst
9 102 (4.18%) Consultant
10 97 (3.98%) Data Architect
11 91 (3.73%) Python Engineer
12 86 (3.52%) Data Warehouse Developer
13 79 (3.24%) SSIS Developer
14 64 (2.62%) SQL BI Developer
15 63 (2.58%) DBA
16 60 (2.46%) Business Analyst
16 60 (2.46%) Tester
17 58 (2.38%) Senior Developer
18 56 (2.30%) SQL DBA
19 55 (2.25%) .NET Developer
Libraries, Frameworks & Software Standards
1 175 (7.17%) .NET
2 169 (6.93%) XML
3 152 (6.23%) Kafka
4 119 (4.88%) JSON
5 115 (4.71%) Web Services
6 97 (3.98%) REST
7 90 (3.69%) SOAP
8 62 (2.54%) HTML
9 54 (2.21%) RESTful
10 52 (2.13%) Middleware
11 45 (1.84%) MDX
12 44 (1.80%) PySpark
13 40 (1.64%) CSS
13 40 (1.64%) Pandas
13 40 (1.64%) Spring
14 36 (1.48%) Apache NiFi
14 36 (1.48%) Velocity
15 34 (1.39%) ASP.NET Web API
15 34 (1.39%) WinForms
16 28 (1.15%) WCF
Miscellaneous
1 276 (11.31%) Analytical Skills
2 101 (4.14%) Data Structures
3 74 (3.03%) Self-Motivation
4 52 (2.13%) Algorithms
5 49 (2.01%) Enterprise Software
6 47 (1.93%) Greenfield Project
7 40 (1.64%) Replication
8 34 (1.39%) Management Information System
9 23 (0.94%) NHS
9 23 (0.94%) User Experience
10 20 (0.82%) Reinsurance
11 17 (0.70%) Hedge funds
12 15 (0.61%) Reference Data
13 14 (0.57%) Clustering
13 14 (0.57%) Public Cloud
14 13 (0.53%) Client/Server
14 13 (0.53%) Data Centre
14 13 (0.53%) Linux Command Line
15 12 (0.49%) Data Protection Act
16 10 (0.41%) Mobile App
Operating Systems
1 211 (8.65%) Unix
2 207 (8.48%) Linux
3 59 (2.42%) Windows
4 12 (0.49%) Solaris
5 3 (0.12%) Red Hat Enterprise Linux
6 2 (0.082%) Android
6 2 (0.082%) Apple iOS
6 2 (0.082%) VMS
6 2 (0.082%) Windows Server
7 1 (0.041%) AIX
7 1 (0.041%) Ubuntu
7 1 (0.041%) Windows Server 2003
7 1 (0.041%) Windows Server 2008
Processes & Methodologies
1 845 (34.63%) Business Intelligence
2 761 (31.19%) Agile Software Development
3 579 (23.73%) Data Modelling
4 436 (17.87%) Migration
5 388 (15.90%) Analytics
6 345 (14.14%) Data Migration
7 244 (10.00%) Scrum
8 230 (9.43%) Visualisation
9 225 (9.22%) Problem-Solving
10 204 (8.36%) DevOps
11 203 (8.32%) Data Analysis
12 201 (8.24%) ETL Development
13 180 (7.38%) Data Integration
14 173 (7.09%) Test Automation
15 168 (6.89%) Data Engineering
16 164 (6.72%) Data Science
17 156 (6.39%) Performance Tuning
18 147 (6.02%) Data Management
19 140 (5.74%) Data Architecture
20 135 (5.53%) Kimball Methodology
Programming Languages
1 1,553 (63.65%) SQL
2 515 (21.11%) Python
3 362 (14.84%) T-SQL
4 296 (12.13%) Java
5 196 (8.03%) C#
6 187 (7.66%) PL/SQL
7 125 (5.12%) JavaScript
8 118 (4.84%) Scala
9 102 (4.18%) Shell Script
10 78 (3.20%) PowerShell
11 70 (2.87%) Data Analysis Expressions (DAX)
12 63 (2.58%) R
13 53 (2.17%) Bash Shell
13 53 (2.17%) VBA
14 48 (1.97%) VB.NET
15 39 (1.60%) VB
16 30 (1.23%) Java 8
17 26 (1.07%) Perl
18 25 (1.02%) SAS Macro
19 17 (0.70%) C
Qualifications
1 170 (6.97%) Security Cleared
2 146 (5.98%) SC Cleared
3 113 (4.63%) Degree
4 47 (1.93%) Computer Science Degree
4 47 (1.93%) ISTQB
5 35 (1.43%) ISEB
6 18 (0.74%) CTC Cleared
7 15 (0.61%) Master's Degree
8 13 (0.53%) TOGAF Certification
9 12 (0.49%) ACCA
9 12 (0.49%) BPSS Clearance
9 12 (0.49%) ISTQB Foundation Certification
10 9 (0.37%) Microsoft Certification
11 8 (0.33%) MCSE
12 7 (0.29%) DV Cleared
13 6 (0.25%) MCSA
14 5 (0.20%) CIMA
14 5 (0.20%) ISTQB Advanced Certification
14 5 (0.20%) PhD
14 5 (0.20%) PMP
Quality Assurance & Compliance
1 195 (7.99%) Data Quality
2 103 (4.22%) QA
3 44 (1.80%) GDPR
4 13 (0.53%) IFRS
5 11 (0.45%) SLA
6 7 (0.29%) Solvency II
7 5 (0.20%) ISO/IEC 27001
7 5 (0.20%) PMO
8 2 (0.082%) HL7
8 2 (0.082%) IFRS 9
8 2 (0.082%) MiFID
9 1 (0.041%) ISO 20022
9 1 (0.041%) ISO/IEC 27002 (supersedes ISO/IEC 17799)
9 1 (0.041%) PCI DSS
System Software
1 95 (3.89%) Docker
2 36 (1.48%) HDFS
3 25 (1.02%) Apache Flume
4 22 (0.90%) Active Directory
5 15 (0.61%) Oracle RAC
6 8 (0.33%) VMware Infrastructure
7 3 (0.12%) Virtual Machines
8 2 (0.082%) Tivoli Workload Scheduler
8 2 (0.082%) VMware ESXi
9 1 (0.041%) Postfix
9 1 (0.041%) VMware Server
Systems Management
1 94 (3.85%) Kubernetes
2 54 (2.21%) Ansible
3 26 (1.07%) Hadoop YARN
4 19 (0.78%) Terraform
5 18 (0.74%) Control-M
6 14 (0.57%) Kubeflow
6 14 (0.57%) Oozie
7 10 (0.41%) Opscode Chef
8 9 (0.37%) Puppet
9 8 (0.33%) Grafana
10 6 (0.25%) Kibana
11 5 (0.20%) Graphite
12 4 (0.16%) Ambari
12 4 (0.16%) Data Guard
12 4 (0.16%) HP ALM
12 4 (0.16%) SCOM
13 3 (0.12%) HP Quality Center
13 3 (0.12%) Microsoft Clustering
13 3 (0.12%) Oracle RMAN
13 3 (0.12%) Tivoli
Vendors
1 567 (23.24%) Oracle
2 445 (18.24%) Microsoft
3 204 (8.36%) Informatica
4 201 (8.24%) Tableau
5 191 (7.83%) Google
6 119 (4.88%) Talend
7 107 (4.39%) SAP
8 68 (2.79%) Teradata
9 59 (2.42%) Databricks
10 54 (2.21%) Salesforce.com
11 39 (1.60%) IBM
12 38 (1.56%) Ab Initio
13 37 (1.52%) Alteryx
13 37 (1.52%) Netezza
14 36 (1.48%) MicroStrategy
15 33 (1.35%) Cloudera
16 26 (1.07%) Cognos
17 15 (0.61%) Greenplum
18 14 (0.57%) EXASOL
19 13 (0.53%) MuleSoft