Period
to 19 November 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 19 November 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
19 Nov 2018
Same period 2017 Same period 2016
Rank 104 100 88
Rank change year-on-year -4 -12 -16
Contract jobs citing ETL 2,567 2,500 2,718
As % of all contract IT jobs advertised in the UK 2.49% 2.46% 2.59%
As % of the Processes & Methodologies category 2.88% 2.87% 3.04%
Number of daily rates quoted 1,763 1,720 1,807
UK median daily rate £455 £450 £425
Median daily rate % change year-on-year +1.11% +5.88% -
10th Percentile £325 £313 £313
90th Percentile £600 £600 £588
UK excluding London median daily rate £428 £420 £400
% change year-on-year +1.79% +5.00% -
Number of hourly rates quoted 22 29 20
UK median hourly rate £34.00 £46.21 £44.00
Median hourly rate % change year-on-year -26.42% +5.02% +49.15%
10th Percentile £15.47 £34.65 £20.41
90th Percentile £47.28 £67.50 £58.48
UK excluding London median hourly rate £28.50 £46.21 £44.00
% change year-on-year -38.33% +5.02% +49.15%

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,184 86,972 89,322
As % of all contract IT jobs advertised in the UK 86.36% 85.75% 85.19%
Number of daily rates quoted 59,020 57,836 58,961
UK median daily rate £460 £450 £425
Median daily rate % change year-on-year +2.22% +5.88% +3.03%
10th Percentile £300 £278 £263
90th Percentile £638 £625 £600
UK excluding London median daily rate £425 £400 £400
% change year-on-year +6.25% - +4.71%
Number of hourly rates quoted 2,306 2,085 2,467
UK median hourly rate £22.00 £23.00 £22.50
Median hourly rate % change year-on-year -4.35% +2.22% +2.27%
10th Percentile £11.25 £11.25 £11.25
90th Percentile £50.75 £49.75 £48.00
UK excluding London median hourly rate £21.20 £23.50 £22.50
% change year-on-year -9.79% +4.44% -

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 19 November 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 19 November 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 19 November 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 -1 2,340 £460 +2.22% 570
UK excluding London -7 1,348 £428 +1.79% 330
London +1 1,187 £500 +5.26% 276
South East -18 361 £450 +4.35% 68
North of England +6 334 £375 -6.25% 90
Yorkshire +24 175 £388 -8.82% 36
Scotland +8 169 £450 +12.50% 32
Midlands -26 165 £450 +12.50% 60
East of England +36 144 £475 +11.76% 36
North West -13 143 £375 -6.25% 45
South West -34 139 £425 - 40
East Midlands +12 87 £450 +17.33% 20
West Midlands -53 77 £425 +4.62% 40
Wales -32 26 £500 +55.28% 3
North East -21 16 £350 -17.65% 9
Northern Ireland +15 11 £434 +3.21% 1

For the 6 months to 19 November 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,633 (63.62%) SQL
2 1,037 (40.40%) Data Warehouse
3 980 (38.18%) SQL Server
4 876 (34.13%) Business Intelligence
5 833 (32.45%) Agile Software Development
6 760 (29.61%) SQL Server Integration Services
7 644 (25.09%) Finance
8 614 (23.92%) Oracle
9 489 (19.05%) Python
10 468 (18.23%) Data Modelling
11 464 (18.08%) Analytics
12 461 (17.96%) Microsoft
13 454 (17.69%) SQL Server Reporting Services
14 448 (17.45%) Migration
15 429 (16.71%) Big Data
16 419 (16.32%) Analytical Skills
17 389 (15.15%) Amazon AWS
18 388 (15.11%) Microsoft Azure
19 380 (14.80%) T-SQL
20 370 (14.41%) Hadoop
21 341 (13.28%) Data Migration
22 327 (12.74%) Data Analysis
23 318 (12.39%) Java
24 317 (12.35%) Relational Database
25 309 (12.04%) Power BI
26 299 (11.65%) SQL Server Analysis Services
27 271 (10.56%) Scrum
28 255 (9.93%) Unix
29 251 (9.78%) Apache Spark
30 247 (9.62%) Data Quality

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 251 (9.78%) Apache Spark
2 119 (4.64%) SAS
3 58 (2.26%) Confluence
4 55 (2.14%) Apache
5 52 (2.03%) Elasticsearch
6 43 (1.68%) SharePoint
7 26 (1.01%) Apache Pig
8 19 (0.74%) Apache Solr
9 16 (0.62%) Cloud Foundry
9 16 (0.62%) WebSphere
10 14 (0.55%) Tomcat
11 12 (0.47%) ArcGIS
12 11 (0.43%) WebLogic
13 10 (0.39%) Apache Airflow
14 8 (0.31%) Oracle SOA Suite
15 7 (0.27%) NServiceBus
16 5 (0.19%) CMS
16 5 (0.19%) JBoss
17 4 (0.16%) IIS
17 4 (0.16%) nginx
Applications
1 205 (7.99%) Microsoft Excel
2 61 (2.38%) MS Visio
3 53 (2.06%) Microsoft Office
4 19 (0.74%) Spreadsheet
5 11 (0.43%) Microsoft PowerPoint
6 6 (0.23%) SPSS
7 5 (0.19%) Microsoft Project
8 3 (0.12%) Chatbot
8 3 (0.12%) Mathematica
Business Applications
1 27 (1.05%) Dynamics CRM
2 19 (0.74%) Dynamics AX
3 18 (0.70%) SAP S/4HANA
4 17 (0.66%) Markit EDM
5 13 (0.51%) SAP Oil and Gas
6 10 (0.39%) Cognos Business Intelligence
6 10 (0.39%) Oracle EBS
7 9 (0.35%) Dynamics NAV
8 8 (0.31%) Infor M3
8 8 (0.31%) Workday HCM
9 7 (0.27%) SAP HR
10 6 (0.23%) NetSuite
10 6 (0.23%) SAP ERP
11 5 (0.19%) Cognos TM1
11 5 (0.19%) Oracle ERP
12 4 (0.16%) IBM Operational Decision Manager
12 4 (0.16%) iTrent
12 4 (0.16%) Oracle EBS R12
12 4 (0.16%) Oracle Retail
12 4 (0.16%) SAP MDG
Cloud Services
1 389 (15.15%) Amazon AWS
2 388 (15.11%) Microsoft Azure
3 152 (5.92%) Amazon S3
4 112 (4.36%) Amazon EC2
5 88 (3.43%) Virtual Private Cloud
6 78 (3.04%) Google Cloud Platform
7 77 (3.00%) Amazon EMR
8 76 (2.96%) Azure Data Factory
9 52 (2.03%) Dynamics 365
10 40 (1.56%) PaaS
11 36 (1.40%) GitHub
12 35 (1.36%) Amazon Glacier
13 27 (1.05%) Serverless
14 23 (0.90%) Amazon Kinesis
14 23 (0.90%) AWS Lambda
15 17 (0.66%) SaaS
16 16 (0.62%) Google Analytics
16 16 (0.62%) IaaS
17 14 (0.55%) Data Lake Analytics
18 13 (0.51%) Salesforce Service Cloud
Communications & Networking
1 27 (1.05%) Internet
2 24 (0.93%) SSH
2 24 (0.93%) TCP/IP
3 19 (0.74%) Kerberos
4 18 (0.70%) Firewall
5 12 (0.47%) Intranet
6 9 (0.35%) Extranet
6 9 (0.35%) SMS
7 7 (0.27%) HTTP
7 7 (0.27%) VPN
8 6 (0.23%) DNS
9 5 (0.19%) FTP
10 4 (0.16%) SSL
11 3 (0.12%) ICMP
11 3 (0.12%) Radio Access Network
12 2 (0.078%) ASN.1
12 2 (0.078%) HTTPS
12 2 (0.078%) PuTTY
12 2 (0.078%) tcpdump
13 1 (0.039%) Bluetooth
Database & Business Intelligence
1 1,037 (40.40%) Data Warehouse
2 980 (38.18%) SQL Server
3 760 (29.61%) SQL Server Integration Services
4 454 (17.69%) SQL Server Reporting Services
5 429 (16.71%) Big Data
6 370 (14.41%) Hadoop
7 317 (12.35%) Relational Database
8 309 (12.04%) Power BI
9 299 (11.65%) SQL Server Analysis Services
10 235 (9.15%) Apache Hive
11 178 (6.93%) Data Lake
12 168 (6.54%) SQL Server 2016
13 165 (6.43%) NoSQL
14 153 (5.96%) Oracle Database
15 122 (4.75%) SQL Server 2008
16 120 (4.67%) BusinessObjects
17 119 (4.64%) Amazon Redshift
18 109 (4.25%) SQL Server 2012
19 106 (4.13%) OLAP
20 104 (4.05%) PostgreSQL
Development Applications
1 175 (6.82%) JIRA
2 163 (6.35%) Jenkins
3 142 (5.53%) Git (software)
4 91 (3.54%) Team Foundation Server
5 72 (2.80%) Visual Studio
6 64 (2.49%) Selenium
7 55 (2.14%) Visual Studio Team System
8 47 (1.83%) Subversion
9 38 (1.48%) Bitbucket
10 30 (1.17%) Octopus Deploy
11 29 (1.13%) Maven
11 29 (1.13%) Toad
12 28 (1.09%) SpecFlow
13 22 (0.86%) Eclipse
13 22 (0.86%) ERwin
14 21 (0.82%) Artifactory
15 19 (0.74%) LSMW
16 15 (0.58%) Ant
16 15 (0.58%) FitNesse
16 15 (0.58%) TeamCity
General
1 644 (25.09%) Finance
2 225 (8.77%) Banking
3 116 (4.52%) Retail
4 52 (2.03%) Marketing
5 51 (1.99%) Publishing
6 50 (1.95%) Investment Banking
7 49 (1.91%) Legal
8 40 (1.56%) Back Office
9 35 (1.36%) Front Office
9 35 (1.36%) Telecoms
10 22 (0.86%) Manufacturing
11 20 (0.78%) Retail Banking
12 19 (0.74%) Advertising
13 18 (0.70%) Financial Institution
14 17 (0.66%) Pharmaceutical
15 15 (0.58%) Law
16 14 (0.55%) General Ledger
17 12 (0.47%) Games
18 6 (0.23%) Electronics
19 5 (0.19%) Corporate Banking
Job Titles
1 1,287 (50.14%) Developer
2 360 (14.02%) SQL Developer
3 321 (12.50%) Business Intelligence Developer
4 314 (12.23%) ETL Developer
5 288 (11.22%) Analyst
6 259 (10.09%) Data Engineer
7 194 (7.56%) Architect
8 160 (6.23%) Data Analyst
9 127 (4.95%) Consultant
10 118 (4.60%) SSIS Developer
11 94 (3.66%) Data Architect
12 93 (3.62%) SQL BI Developer
13 92 (3.58%) Big Data Engineer
14 90 (3.51%) Data Warehouse Developer
15 84 (3.27%) Oracle Developer
16 82 (3.19%) SQL Server Developer
17 75 (2.92%) AWS Engineer
17 75 (2.92%) Senior Developer
18 53 (2.06%) DBA
18 53 (2.06%) SQL Analyst
Libraries, Frameworks & Software Standards
1 199 (7.75%) XML
2 180 (7.01%) Web Services
3 149 (5.80%) .NET
4 121 (4.71%) Kafka
5 116 (4.52%) JSON
6 56 (2.18%) HTML
7 50 (1.95%) REST
8 49 (1.91%) AngularJS
9 45 (1.75%) React
10 44 (1.71%) Spark Streaming
11 43 (1.68%) RESTful
12 42 (1.64%) CSS
13 41 (1.60%) ASP.NET
13 41 (1.60%) HTML5
14 38 (1.48%) Middleware
15 37 (1.44%) SOAP
16 35 (1.36%) MDX
17 34 (1.32%) Spring
18 32 (1.25%) WCF
19 31 (1.21%) ASP.NET Web API
Miscellaneous
1 419 (16.32%) Analytical Skills
2 106 (4.13%) Greenfield Project
3 101 (3.93%) Computer Science
4 85 (3.31%) Data Structures
5 83 (3.23%) Algorithms
6 52 (2.03%) Management Information System
7 49 (1.91%) Wiki
8 45 (1.75%) Fintech
8 45 (1.75%) Reference Data
9 43 (1.68%) Enterprise Software
10 35 (1.36%) Replication
11 33 (1.29%) User Experience
12 32 (1.25%) Self-Motivation
13 26 (1.01%) Equities
14 25 (0.97%) Fixed Income
15 23 (0.90%) NHS
16 17 (0.66%) Mobile App
17 15 (0.58%) Reinsurance
18 14 (0.55%) Virtual Team
19 13 (0.51%) Data Centre
Operating Systems
1 255 (9.93%) Unix
2 215 (8.38%) Linux
3 122 (4.75%) Windows
4 26 (1.01%) Windows Server
5 25 (0.97%) Red Hat Enterprise Linux
6 10 (0.39%) Solaris
6 10 (0.39%) Ubuntu
7 8 (0.31%) VMS
8 7 (0.27%) AIX
9 3 (0.12%) Windows 10
9 3 (0.12%) Windows 7
10 2 (0.078%) Apple iOS
10 2 (0.078%) CentOS
10 2 (0.078%) DC/OS
10 2 (0.078%) VME
11 1 (0.039%) Android
11 1 (0.039%) Mac OS X
11 1 (0.039%) Oracle Linux
11 1 (0.039%) Windows Server 2003
11 1 (0.039%) zOS
Processes & Methodologies
1 876 (34.13%) Business Intelligence
2 833 (32.45%) Agile Software Development
3 468 (18.23%) Data Modelling
4 464 (18.08%) Analytics
5 448 (17.45%) Migration
6 341 (13.28%) Data Migration
7 327 (12.74%) Data Analysis
8 271 (10.56%) Scrum
9 233 (9.08%) Data Integration
10 227 (8.84%) Test Automation
11 222 (8.65%) ETL Development
12 216 (8.41%) Visualisation
13 208 (8.10%) Problem-Solving
14 179 (6.97%) Data Management
15 173 (6.74%) Kimball Methodology
16 163 (6.35%) DevOps
17 160 (6.23%) Data Science
18 158 (6.16%) Performance Tuning
19 154 (6.00%) Continuous Integration
20 132 (5.14%) Data Architecture
Programming Languages
1 1,633 (63.62%) SQL
2 489 (19.05%) Python
3 380 (14.80%) T-SQL
4 318 (12.39%) Java
5 205 (7.99%) C#
6 200 (7.79%) PL/SQL
7 149 (5.80%) Scala
8 141 (5.49%) Shell Script
9 112 (4.36%) JavaScript
10 109 (4.25%) R
11 98 (3.82%) PowerShell
12 91 (3.54%) Bash Shell
13 51 (1.99%) Korn
14 48 (1.87%) VBA
15 46 (1.79%) Perl
16 41 (1.60%) VB
17 40 (1.56%) MATLAB
18 34 (1.32%) Data Analysis Expressions (DAX)
19 27 (1.05%) C
20 23 (0.90%) C++
Qualifications
1 155 (6.04%) Security Cleared
2 124 (4.83%) SC Cleared
3 115 (4.48%) Degree
4 44 (1.71%) Computer Science Degree
5 29 (1.13%) Master's Degree
6 18 (0.70%) PhD
7 15 (0.58%) ISEB
8 14 (0.55%) ISTQB
9 13 (0.51%) BPSS Clearance
10 10 (0.39%) PMI Certification
11 7 (0.27%) DBS Check
11 7 (0.27%) Microsoft Certification
12 6 (0.23%) Numerate Degree
13 5 (0.19%) MCSE
13 5 (0.19%) PMP
14 4 (0.16%) MCITP
14 4 (0.16%) Postgraduate
15 3 (0.12%) AWS Certification
15 3 (0.12%) OSCP
15 3 (0.12%) TOGAF Certification
Quality Assurance & Compliance
1 247 (9.62%) Data Quality
2 153 (5.96%) QA
3 38 (1.48%) GDPR
4 12 (0.47%) PMO
5 10 (0.39%) SLA
6 9 (0.35%) IFRS
7 8 (0.31%) IFRS 9
7 8 (0.31%) PCI DSS
8 6 (0.23%) Basel III
9 3 (0.12%) MiFID
10 2 (0.078%) Disclosure Scotland
10 2 (0.078%) EMIR
10 2 (0.078%) HL7
10 2 (0.078%) ISO 9001
10 2 (0.078%) ISO 9002
10 2 (0.078%) SEPA
10 2 (0.078%) TickIT
11 1 (0.039%) Dodd-Frank
11 1 (0.039%) Solvency II
System Software
1 102 (3.97%) Docker
2 81 (3.16%) HDFS
3 34 (1.32%) Apache Flume
4 6 (0.23%) Apache ZooKeeper
5 5 (0.19%) Oracle RAC
6 4 (0.16%) Virtual Machines
7 3 (0.12%) Active Directory
7 3 (0.12%) Hyper-V
8 2 (0.078%) iptables
8 2 (0.078%) NFS
9 1 (0.039%) Cronacle
Systems Management
1 138 (5.38%) Ansible
2 104 (4.05%) Opscode Chef
3 70 (2.73%) Hadoop YARN
4 69 (2.69%) Puppet
5 55 (2.14%) Kubernetes
6 25 (0.97%) Oozie
7 23 (0.90%) Control-M
8 13 (0.51%) Kibana
9 11 (0.43%) logstash
9 11 (0.43%) Terraform
10 5 (0.19%) Ambari
10 5 (0.19%) Failover Clustering
10 5 (0.19%) Tivoli
11 4 (0.16%) HP Quality Center
11 4 (0.16%) Mesos
11 4 (0.16%) Oracle RMAN
11 4 (0.16%) Prometheus
11 4 (0.16%) Systems Management Server (SMS)
12 3 (0.12%) Microsoft Clustering
12 3 (0.12%) Sysdig
Vendors
1 614 (23.92%) Oracle
2 461 (17.96%) Microsoft
3 227 (8.84%) Informatica
4 211 (8.22%) Tableau
5 207 (8.06%) Talend
6 186 (7.25%) SAP
7 95 (3.70%) Cloudera
8 92 (3.58%) Ab Initio
8 92 (3.58%) Google
9 81 (3.16%) Teradata
10 71 (2.77%) IBM
11 51 (1.99%) Splunk
12 46 (1.79%) Salesforce.com
13 41 (1.60%) Alteryx
14 35 (1.36%) Hortonworks
15 31 (1.21%) Cognos
16 29 (1.13%) Netezza
17 23 (0.90%) MicroStrategy
18 20 (0.78%) Workday
19 18 (0.70%) Atlassian