Period
to 21 July 2018

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 21 July 2018 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
21 Jul 2018
Same period 2017 Same period 2016
Rank 105 104 95
Rank change year-on-year -1 -9 -28
Contract jobs citing ETL 2,493 2,274 2,611
As % of all contract IT jobs advertised in the UK 2.39% 2.37% 2.37%
As % of the Processes & Methodologies category 2.79% 2.79% 2.81%
Number of daily rates quoted 1,740 1,495 1,780
UK median daily rate £450 £450 £425
Median daily rate % change year-on-year - +5.88% +1.19%
10th Percentile £313 £313 £306
90th Percentile £606 £588 £575
UK excluding London median daily rate £425 £400 £400
% change year-on-year +6.25% - -
Number of hourly rates quoted 18 16 6
UK median hourly rate £41.50 £38.75 £20.50
Median hourly rate % change year-on-year +7.10% +89.02% -37.88%
UK excluding London median hourly rate £35.00 £35.00 £20.50
% change year-on-year - +70.73% -37.88%

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 89,309 81,490 92,799
As % of all contract IT jobs advertised in the UK 85.73% 84.93% 84.32%
Number of daily rates quoted 58,913 53,342 61,105
UK median daily rate £450 £450 £425
Median daily rate % change year-on-year +0.11% +5.76% +6.25%
10th Percentile £300 £275 £263
90th Percentile £638 £625 £600
UK excluding London median daily rate £425 £400 £400
% change year-on-year +6.25% - +6.67%
Number of hourly rates quoted 2,461 2,132 2,284
UK median hourly rate £22.00 £25.00 £24.00
Median hourly rate % change year-on-year -12.00% +4.17% +11.63%
10th Percentile £11.17 £11.50 £11.50
90th Percentile £50.00 £52.49 £48.75
UK excluding London median hourly rate £21.00 £25.00 £25.00
% change year-on-year -16.00% - +16.01%

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 21 July 2018.

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 21 July 2018.

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 21 July 2018. 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 -2 2,279 £463 +2.78% 539
London -3 1,244 £500 +5.26% 259
UK excluding London -9 1,225 £425 +6.25% 304
South East +1 356 £438 +2.94% 82
North of England -18 280 £385 -3.75% 94
Scotland +7 156 £400 -5.88% 19
Midlands -31 155 £425 +6.25% 59
Yorkshire +4 151 £400 - 31
East of England +33 128 £450 +5.88% 21
South West +5 120 £435 +8.75% 23
North West -33 119 £375 - 50
East Midlands +11 92 £404 +0.94% 30
West Midlands -56 62 £425 +9.68% 29
Wales -14 23 £363 +3.57% 4
Northern Ireland +7 15 £432 -6.59% 2
North East -14 10 £350 -31.71% 13

For the 6 months to 21 July 2018, 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,521 (61.01%) SQL
2 1,081 (43.36%) Data Warehouse
3 868 (34.82%) Business Intelligence
4 809 (32.45%) Agile Software Development
5 774 (31.05%) SQL Server
6 659 (26.43%) Finance
7 627 (25.15%) SQL Server Integration Services
8 588 (23.59%) Oracle
9 501 (20.10%) Analytics
10 493 (19.78%) Data Modelling
11 491 (19.70%) Big Data
12 479 (19.21%) Python
13 437 (17.53%) Microsoft
14 409 (16.41%) Migration
15 390 (15.64%) Java
15 390 (15.64%) Hadoop
16 377 (15.12%) SQL Server Reporting Services
17 335 (13.44%) Analytical Skills
18 332 (13.32%) T-SQL
19 327 (13.12%) Amazon AWS
20 309 (12.39%) Microsoft Azure
21 298 (11.95%) Data Migration
22 284 (11.39%) Data Quality
23 281 (11.27%) Apache Spark
24 273 (10.95%) Informatica
25 265 (10.63%) Relational Database
26 257 (10.31%) Data Analysis
26 257 (10.31%) Data Integration
27 256 (10.27%) Linux
28 252 (10.11%) SQL Server Analysis Services

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 281 (11.27%) Apache Spark
2 107 (4.29%) SAS
3 99 (3.97%) Apache
4 65 (2.61%) SharePoint
5 62 (2.49%) Elasticsearch
6 48 (1.93%) Apache Pig
6 48 (1.93%) Confluence
7 29 (1.16%) Apache Solr
8 25 (1.00%) Tomcat
9 21 (0.84%) WebSphere
10 16 (0.64%) Apache Airflow
11 15 (0.60%) Oracle SOA Suite
12 14 (0.56%) Oracle Workflow
13 13 (0.52%) OpenStack
14 12 (0.48%) PowerExchange
15 9 (0.36%) WebLogic
16 7 (0.28%) Cloud Foundry
16 7 (0.28%) IBM HTTP Server
16 7 (0.28%) nginx
17 6 (0.24%) IIS
Applications
1 157 (6.30%) Microsoft Excel
2 48 (1.93%) Microsoft Office
3 39 (1.56%) MS Visio
4 15 (0.60%) Microsoft PowerPoint
5 11 (0.44%) SPSS
6 10 (0.40%) Spreadsheet
6 10 (0.40%) Stata
7 8 (0.32%) Chatbot
7 8 (0.32%) Microsoft Project
8 3 (0.12%) CATIA
Business Applications
1 21 (0.84%) Dynamics AX
1 21 (0.84%) Markit EDM
2 18 (0.72%) Dynamics CRM
3 17 (0.68%) SAP S/4HANA
4 11 (0.44%) Cognos Business Intelligence
5 8 (0.32%) BusinessWare
5 8 (0.32%) Cognos TM1
5 8 (0.32%) thinkFolio
6 7 (0.28%) SAP ERP
7 6 (0.24%) HFM
8 5 (0.20%) Dynamics NAV
8 5 (0.20%) Oracle EBS
8 5 (0.20%) Salesforce.com CRM
9 4 (0.16%) Eagle PACE
9 4 (0.16%) Line 500
9 4 (0.16%) Oracle ERP
9 4 (0.16%) Sage X3
9 4 (0.16%) SAP Oil and Gas
9 4 (0.16%) Unit4 Business World
10 3 (0.12%) Oracle Financials
Cloud Services
1 327 (13.12%) Amazon AWS
2 309 (12.39%) Microsoft Azure
3 95 (3.81%) Amazon S3
4 81 (3.25%) Google Cloud Platform
5 65 (2.61%) Azure Data Factory
6 60 (2.41%) Amazon EC2
7 38 (1.52%) PaaS
8 37 (1.48%) Amazon Kinesis
9 36 (1.44%) Amazon EMR
10 32 (1.28%) Virtual Private Cloud
11 28 (1.12%) GitHub
12 27 (1.08%) Google Analytics
12 27 (1.08%) Serverless
13 24 (0.96%) Dynamics 365
14 19 (0.76%) SaaS
15 16 (0.64%) Data Lake Analytics
16 15 (0.60%) Amazon Glacier
17 14 (0.56%) AWS Lambda
17 14 (0.56%) IaaS
18 11 (0.44%) Cloud Computing
Communications & Networking
1 31 (1.24%) FTP
2 21 (0.84%) Kerberos
3 13 (0.52%) SAN
3 13 (0.52%) SMS
4 12 (0.48%) DNS
4 12 (0.48%) VPN
5 10 (0.40%) HTTP
6 9 (0.36%) TCP/IP
7 8 (0.32%) Internet
7 8 (0.32%) SSL
8 6 (0.24%) DSL
8 6 (0.24%) ICMP
9 4 (0.16%) Firewall
9 4 (0.16%) PuTTY
9 4 (0.16%) Radio Access Network
10 3 (0.12%) ASN.1
10 3 (0.12%) NAS
10 3 (0.12%) X.509
11 2 (0.080%) Extranet
11 2 (0.080%) Reverse Proxy
Database & Business Intelligence
1 1,081 (43.36%) Data Warehouse
2 774 (31.05%) SQL Server
3 627 (25.15%) SQL Server Integration Services
4 491 (19.70%) Big Data
5 390 (15.64%) Hadoop
6 377 (15.12%) SQL Server Reporting Services
7 265 (10.63%) Relational Database
8 252 (10.11%) SQL Server Analysis Services
9 235 (9.43%) Power BI
10 230 (9.23%) Apache Hive
11 187 (7.50%) Data Lake
12 168 (6.74%) NoSQL
13 150 (6.02%) Oracle Database
14 142 (5.70%) PostgreSQL
15 136 (5.46%) Amazon Redshift
16 119 (4.77%) HBase
17 113 (4.53%) BusinessObjects
18 98 (3.93%) SQL Server 2016
19 96 (3.85%) SQL Server 2008
20 95 (3.81%) OLAP
Development Applications
1 134 (5.38%) Git (software)
2 126 (5.05%) JIRA
3 106 (4.25%) Jenkins
4 91 (3.65%) Team Foundation Server
5 67 (2.69%) Visual Studio
6 47 (1.89%) Visual Studio Team System
7 33 (1.32%) Selenium
8 25 (1.00%) Subversion
9 24 (0.96%) ERwin
10 23 (0.92%) Maven
11 22 (0.88%) SQL Server Management Studio (SSMS)
12 21 (0.84%) Octopus Deploy
13 20 (0.80%) Bitbucket
14 19 (0.76%) Artifactory
14 19 (0.76%) SpecFlow
14 19 (0.76%) TeamCity
15 18 (0.72%) Toad
16 15 (0.60%) Cucumber
17 14 (0.56%) LSMW
18 13 (0.52%) SoapUI
General
1 659 (26.43%) Finance
2 210 (8.42%) Banking
3 117 (4.69%) Retail
4 47 (1.89%) Marketing
5 41 (1.64%) Legal
6 39 (1.56%) Manufacturing
7 36 (1.44%) Investment Banking
8 23 (0.92%) Front Office
8 23 (0.92%) Publishing
9 20 (0.80%) Law
10 19 (0.76%) Telecoms
11 18 (0.72%) Games
12 15 (0.60%) Retail Banking
13 13 (0.52%) Corporate Banking
14 12 (0.48%) Advertising
15 10 (0.40%) Pharmaceutical
16 9 (0.36%) Financial Institution
17 7 (0.28%) Back Office
17 7 (0.28%) Electronics
18 5 (0.20%) Aerospace
Job Titles
1 1,102 (44.20%) Developer
2 320 (12.84%) Analyst
3 319 (12.80%) Data Engineer
4 310 (12.43%) ETL Developer
5 279 (11.19%) SQL Developer
6 258 (10.35%) Business Intelligence Developer
7 228 (9.15%) Architect
8 166 (6.66%) Data Analyst
9 112 (4.49%) Big Data Engineer
9 112 (4.49%) Consultant
10 107 (4.29%) Data Architect
10 107 (4.29%) SSIS Developer
11 75 (3.01%) AWS Engineer
12 72 (2.89%) Data Warehouse Developer
13 67 (2.69%) Python Engineer
13 67 (2.69%) SQL BI Developer
14 63 (2.53%) Solutions Architect
15 61 (2.45%) Test Analyst
16 60 (2.41%) Senior Developer
17 54 (2.17%) DBA
Libraries, Frameworks & Software Standards
1 182 (7.30%) XML
2 159 (6.38%) Kafka
3 156 (6.26%) .NET
4 97 (3.89%) Web Services
5 75 (3.01%) JSON
6 58 (2.33%) REST
7 43 (1.72%) Middleware
8 41 (1.64%) HTML
9 39 (1.56%) Spring
10 37 (1.48%) AngularJS
11 35 (1.40%) XML Schema
12 34 (1.36%) RESTful
13 32 (1.28%) CSS
13 32 (1.28%) MDX
14 25 (1.00%) ASP.NET
15 24 (0.96%) RabbitMQ
15 24 (0.96%) WCF
16 23 (0.92%) ASP.NET Web API
16 23 (0.92%) React
16 23 (0.92%) Spark Streaming
Miscellaneous
1 335 (13.44%) Analytical Skills
2 86 (3.45%) Data Structures
3 75 (3.01%) Management Information System
4 67 (2.69%) Greenfield Project
5 64 (2.57%) Computer Science
6 60 (2.41%) Fintech
7 52 (2.09%) Self-Motivation
8 44 (1.76%) Algorithms
9 36 (1.44%) Replication
10 31 (1.24%) Reference Data
11 26 (1.04%) Credit Risk
12 23 (0.92%) User Experience
13 21 (0.84%) NHS
14 17 (0.68%) Enterprise Software
14 17 (0.68%) Fixed Income
14 17 (0.68%) Mainframe
14 17 (0.68%) Virtual Team
14 17 (0.68%) Wiki
15 15 (0.60%) Market Risk
16 14 (0.56%) Reinsurance
Operating Systems
1 256 (10.27%) Linux
2 206 (8.26%) Unix
3 101 (4.05%) Windows
4 21 (0.84%) AIX
4 21 (0.84%) Windows Server
5 19 (0.76%) Red Hat Enterprise Linux
6 16 (0.64%) VMS
7 14 (0.56%) Solaris
8 10 (0.40%) Windows Server 2003
9 8 (0.32%) Ubuntu
10 6 (0.24%) CentOS
10 6 (0.24%) Windows Server 2008
11 5 (0.20%) Windows 7
12 4 (0.16%) Windows 10
13 2 (0.080%) SUSE Linux Enterprise Server
13 2 (0.080%) VME
13 2 (0.080%) Windows Server 2012
14 1 (0.040%) Mac OS X
14 1 (0.040%) MVS
14 1 (0.040%) zOS
Processes & Methodologies
1 868 (34.82%) Business Intelligence
2 809 (32.45%) Agile Software Development
3 501 (20.10%) Analytics
4 493 (19.78%) Data Modelling
5 409 (16.41%) Migration
6 298 (11.95%) Data Migration
7 257 (10.31%) Data Analysis
7 257 (10.31%) Data Integration
8 240 (9.63%) ETL Development
9 213 (8.54%) Problem-Solving
10 211 (8.46%) Data Management
11 189 (7.58%) Scrum
12 175 (7.02%) Visualisation
13 167 (6.70%) Performance Tuning
14 151 (6.06%) Data Science
14 151 (6.06%) DevOps
14 151 (6.06%) Test Automation
15 140 (5.62%) Kimball Methodology
16 136 (5.46%) Data Architecture
17 128 (5.13%) SDLC
Programming Languages
1 1,521 (61.01%) SQL
2 479 (19.21%) Python
3 390 (15.64%) Java
4 332 (13.32%) T-SQL
5 192 (7.70%) C#
6 183 (7.34%) PL/SQL
7 164 (6.58%) Scala
8 119 (4.77%) R
9 115 (4.61%) JavaScript
10 85 (3.41%) Shell Script
11 72 (2.89%) PowerShell
12 68 (2.73%) Bash Shell
13 42 (1.68%) Perl
14 37 (1.48%) Ruby
15 33 (1.32%) VBA
16 30 (1.20%) C
17 24 (0.96%) Data Analysis Expressions (DAX)
18 22 (0.88%) VB
19 21 (0.84%) Java 8
20 20 (0.80%) Go
Qualifications
1 165 (6.62%) Security Cleared
2 124 (4.97%) SC Cleared
3 102 (4.09%) Degree
4 31 (1.24%) DV Cleared
5 29 (1.16%) ISTQB
6 24 (0.96%) Computer Science Degree
7 22 (0.88%) ISEB
8 15 (0.60%) BPSS Clearance
8 15 (0.60%) PhD
9 9 (0.36%) DBS Check
9 9 (0.36%) Numerate Degree
10 8 (0.32%) PMP
10 8 (0.32%) TOGAF Certification
11 7 (0.28%) PMI Certification
12 5 (0.20%) ISTQB Foundation Certification
12 5 (0.20%) Master's Degree
13 4 (0.16%) MCSA
13 4 (0.16%) MCSE
13 4 (0.16%) Microsoft Certification
14 3 (0.12%) Oracle Certification
Quality Assurance & Compliance
1 284 (11.39%) Data Quality
2 98 (3.93%) QA
3 60 (2.41%) GDPR
4 39 (1.56%) GCP
5 13 (0.52%) IFRS
5 13 (0.52%) IFRS 9
5 13 (0.52%) PMO
6 12 (0.48%) PCI DSS
7 10 (0.40%) SLA
8 7 (0.28%) MiFID
9 5 (0.20%) EMIR
10 4 (0.16%) Disclosure Scotland
11 3 (0.12%) Dodd-Frank
11 3 (0.12%) Sarbanes-Oxley
11 3 (0.12%) SEPA
11 3 (0.12%) Solvency II
12 2 (0.080%) HL7
12 2 (0.080%) ISO 20022
12 2 (0.080%) ISO/IEC 20000
12 2 (0.080%) ISO/IEC 27001
System Software
1 88 (3.53%) HDFS
2 87 (3.49%) Docker
3 68 (2.73%) Apache Flume
4 14 (0.56%) Hyper-V
5 7 (0.28%) Apache ZooKeeper
6 6 (0.24%) Active Directory
7 5 (0.20%) Tivoli Workload Scheduler
8 4 (0.16%) Virtual Machines
9 3 (0.12%) Virtual Servers
9 3 (0.12%) VMware Infrastructure
10 1 (0.040%) Oracle RAC
10 1 (0.040%) Veritas Cluster Server
10 1 (0.040%) VirtualBox
10 1 (0.040%) VMware ESXi
10 1 (0.040%) Xen
Systems Management
1 64 (2.57%) Ansible
2 54 (2.17%) Hadoop YARN
3 41 (1.64%) Oozie
4 39 (1.56%) Opscode Chef
5 30 (1.20%) Puppet
6 26 (1.04%) Terraform
7 25 (1.00%) Kubernetes
8 23 (0.92%) Control-M
9 10 (0.40%) Ambari
9 10 (0.40%) Tivoli
10 9 (0.36%) Kibana
11 8 (0.32%) Mesos
12 7 (0.28%) Consul
12 7 (0.28%) Single Sign-On
13 6 (0.24%) Host Intrusion Detection System
13 6 (0.24%) MOM
13 6 (0.24%) Nagios
13 6 (0.24%) Network Intrusion Detection System
13 6 (0.24%) Prometheus
13 6 (0.24%) Sysdig
Vendors
1 588 (23.59%) Oracle
2 437 (17.53%) Microsoft
3 273 (10.95%) Informatica
4 203 (8.14%) Tableau
5 196 (7.86%) SAP
6 187 (7.50%) Talend
7 121 (4.85%) Cloudera
8 106 (4.25%) IBM
9 91 (3.65%) Google
10 87 (3.49%) Teradata
11 74 (2.97%) Cognos
12 68 (2.73%) Ab Initio
13 60 (2.41%) Salesforce.com
14 53 (2.13%) Hortonworks
15 40 (1.60%) Alteryx
16 34 (1.36%) Splunk
17 31 (1.24%) MicroStrategy
18 25 (1.00%) Netezza
18 25 (1.00%) Red Hat
19 24 (0.96%) webMethods