Period
to 20 September 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 20 September 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
20 Sep 2018
Same period 2017 Same period 2016
Rank 106 101 95
Rank change year-on-year -5 -6 -26
Contract jobs citing ETL 2,453 2,429 2,641
As % of all contract IT jobs advertised in the UK 2.38% 2.46% 2.45%
As % of the Processes & Methodologies category 2.76% 2.87% 2.88%
Number of daily rates quoted 1,725 1,645 1,763
UK median daily rate £450 £450 £425
Median daily rate % change year-on-year - +5.88% -
10th Percentile £313 £314 £313
90th Percentile £604 £596 £575
UK excluding London median daily rate £425 £425 £400
% change year-on-year - +6.25% -
Number of hourly rates quoted 18 23 18
UK median hourly rate £36.75 £40.00 £44.00
Median hourly rate % change year-on-year -8.13% -9.09% +47.90%
10th Percentile £14.50 £21.30 £20.50
90th Percentile £51.50 £67.10 £63.43
UK excluding London median hourly rate £35.00 £51.25 £44.00
% change year-on-year -31.71% +16.48% +46.67%

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 88,745 84,585 91,698
As % of all contract IT jobs advertised in the UK 86.20% 85.59% 85.03%
Number of daily rates quoted 58,601 55,681 60,671
UK median daily rate £450 £450 £425
Median daily rate % change year-on-year - +5.88% +6.12%
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% - +6.67%
Number of hourly rates quoted 2,450 2,094 2,377
UK median hourly rate £20.50 £24.00 £23.00
Median hourly rate % change year-on-year -14.58% +4.35% +4.55%
10th Percentile £11.17 £11.25 £11.25
90th Percentile £50.00 £50.00 £47.83
UK excluding London median hourly rate £20.00 £24.00 £23.39
% change year-on-year -16.67% +2.62% +6.31%

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 20 September 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 20 September 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 20 September 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 -5 2,272 £450 - 504
UK excluding London -6 1,245 £425 - 313
London -7 1,186 £500 +5.26% 233
South East +15 383 £450 +1.69% 73
North of England -12 297 £375 -9.37% 77
Midlands -41 152 £425 +6.25% 55
Yorkshire +7 148 £375 -10.45% 22
North West -22 136 £375 -8.81% 48
Scotland -13 132 £425 +3.03% 33
East of England +35 130 £475 +5.56% 27
South West -22 123 £444 +6.61% 40
East Midlands +13 98 £425 +4.29% 29
West Midlands -74 53 £425 +6.25% 26
Wales -27 20 £500 +53.85% 4
Northern Ireland +15 15 £433 -0.57% 5
North East -14 13 £350 -17.65% 7

For the 6 months to 20 September 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,524 (62.13%) SQL
2 1,014 (41.34%) Data Warehouse
3 878 (35.79%) SQL Server
4 844 (34.41%) Business Intelligence
5 804 (32.78%) Agile Software Development
6 642 (26.17%) SQL Server Integration Services
7 612 (24.95%) Finance
8 601 (24.50%) Oracle
9 501 (20.42%) Python
10 469 (19.12%) Analytics
11 442 (18.02%) Microsoft
12 436 (17.77%) Data Modelling
12 436 (17.77%) Big Data
13 411 (16.75%) Migration
14 387 (15.78%) Amazon AWS
15 372 (15.17%) SQL Server Reporting Services
16 371 (15.12%) T-SQL
17 361 (14.72%) Analytical Skills
18 354 (14.43%) Java
19 345 (14.06%) Hadoop
20 343 (13.98%) Microsoft Azure
21 310 (12.64%) Data Migration
22 295 (12.03%) Data Analysis
23 287 (11.70%) Relational Database
24 250 (10.19%) SQL Server Analysis Services
24 250 (10.19%) Power BI
25 246 (10.03%) Scrum
26 244 (9.95%) Linux
27 243 (9.91%) Data Quality
28 242 (9.87%) ETL Development

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 236 (9.62%) Apache Spark
2 99 (4.04%) SAS
3 81 (3.30%) Apache
4 62 (2.53%) Elasticsearch
5 55 (2.24%) SharePoint
6 52 (2.12%) Confluence
7 32 (1.30%) Apache Pig
8 24 (0.98%) Apache Solr
8 24 (0.98%) Tomcat
9 21 (0.86%) WebSphere
10 14 (0.57%) Apache Airflow
11 13 (0.53%) OpenStack
12 11 (0.45%) Oracle SOA Suite
13 10 (0.41%) WebLogic
14 9 (0.37%) CMS
15 8 (0.33%) Cloud Foundry
15 8 (0.33%) Oracle Workflow
16 6 (0.24%) ArcGIS
16 6 (0.24%) NServiceBus
17 5 (0.20%) IIS
Applications
1 201 (8.19%) Microsoft Excel
2 65 (2.65%) MS Visio
3 46 (1.88%) Microsoft Office
4 15 (0.61%) Microsoft PowerPoint
5 12 (0.49%) Spreadsheet
6 7 (0.29%) SPSS
7 5 (0.20%) Chatbot
7 5 (0.20%) Microsoft Project
8 3 (0.12%) Stata
9 2 (0.082%) CATIA
9 2 (0.082%) Mathematica
Business Applications
1 22 (0.90%) Dynamics AX
2 21 (0.86%) Dynamics CRM
3 19 (0.77%) Markit EDM
4 17 (0.69%) SAP S/4HANA
5 10 (0.41%) Oracle EBS
6 9 (0.37%) Cognos Business Intelligence
7 8 (0.33%) Oracle ERP
8 7 (0.29%) Dynamics NAV
8 7 (0.29%) SAP HR
9 6 (0.24%) Cognos TM1
9 6 (0.24%) Infor M3
9 6 (0.24%) SAP ERP
9 6 (0.24%) SAP Oil and Gas
9 6 (0.24%) thinkFolio
9 6 (0.24%) Workday HCM
10 4 (0.16%) HFM
10 4 (0.16%) Line 500
10 4 (0.16%) Sage X3
10 4 (0.16%) SAP MDG
10 4 (0.16%) Unit4 Business World
Cloud Services
1 387 (15.78%) Amazon AWS
2 343 (13.98%) Microsoft Azure
3 145 (5.91%) Amazon S3
4 108 (4.40%) Amazon EC2
5 81 (3.30%) Virtual Private Cloud
6 80 (3.26%) Google Cloud Platform
7 68 (2.77%) Azure Data Factory
8 57 (2.32%) Amazon EMR
9 38 (1.55%) GitHub
10 35 (1.43%) Dynamics 365
11 34 (1.39%) PaaS
12 30 (1.22%) Amazon Kinesis
13 26 (1.06%) Amazon Glacier
13 26 (1.06%) Serverless
14 23 (0.94%) Google Analytics
15 19 (0.77%) AWS Lambda
15 19 (0.77%) IaaS
16 16 (0.65%) SaaS
17 9 (0.37%) Data Lake Analytics
18 8 (0.33%) Salesforce Service Cloud
Communications & Networking
1 25 (1.02%) Kerberos
2 20 (0.82%) Internet
3 18 (0.73%) SSH
4 17 (0.69%) FTP
5 16 (0.65%) TCP/IP
6 13 (0.53%) Firewall
6 13 (0.53%) SMS
7 10 (0.41%) Extranet
7 10 (0.41%) Intranet
8 8 (0.33%) HTTP
8 8 (0.33%) SAN
9 7 (0.29%) SSL
10 6 (0.24%) VPN
11 4 (0.16%) DNS
11 4 (0.16%) Radio Access Network
12 3 (0.12%) ASN.1
12 3 (0.12%) PuTTY
12 3 (0.12%) Reverse Proxy
13 2 (0.082%) AMQP
13 2 (0.082%) tcpdump
Database & Business Intelligence
1 1,014 (41.34%) Data Warehouse
2 878 (35.79%) SQL Server
3 642 (26.17%) SQL Server Integration Services
4 436 (17.77%) Big Data
5 372 (15.17%) SQL Server Reporting Services
6 345 (14.06%) Hadoop
7 287 (11.70%) Relational Database
8 250 (10.19%) Power BI
8 250 (10.19%) SQL Server Analysis Services
9 225 (9.17%) Apache Hive
10 181 (7.38%) Data Lake
11 161 (6.56%) NoSQL
12 142 (5.79%) Oracle Database
13 127 (5.18%) PostgreSQL
14 124 (5.06%) SQL Server 2016
15 123 (5.01%) Amazon Redshift
16 116 (4.73%) BusinessObjects
17 111 (4.53%) SQL Server 2012
18 110 (4.48%) OLAP
19 109 (4.44%) SQL Server 2008
Development Applications
1 164 (6.69%) JIRA
2 154 (6.28%) Git (software)
3 152 (6.20%) Jenkins
4 98 (4.00%) Team Foundation Server
5 70 (2.85%) Visual Studio
6 49 (2.00%) Visual Studio Team System
7 41 (1.67%) Selenium
8 29 (1.18%) Bitbucket
8 29 (1.18%) Maven
9 28 (1.14%) Subversion
10 26 (1.06%) Octopus Deploy
11 24 (0.98%) Toad
12 22 (0.90%) Artifactory
13 20 (0.82%) Eclipse
14 18 (0.73%) TeamCity
15 16 (0.65%) Cucumber
16 15 (0.61%) ERwin
16 15 (0.61%) SpecFlow
17 14 (0.57%) LSMW
17 14 (0.57%) SoapUI
General
1 612 (24.95%) Finance
2 198 (8.07%) Banking
3 108 (4.40%) Retail
4 53 (2.16%) Marketing
5 42 (1.71%) Legal
6 41 (1.67%) Publishing
7 39 (1.59%) Investment Banking
8 33 (1.35%) Manufacturing
8 33 (1.35%) Telecoms
9 22 (0.90%) Front Office
10 20 (0.82%) Back Office
10 20 (0.82%) Law
11 17 (0.69%) Advertising
11 17 (0.69%) Financial Institution
11 17 (0.69%) Games
12 16 (0.65%) Retail Banking
13 12 (0.49%) Pharmaceutical
14 10 (0.41%) General Ledger
15 7 (0.29%) Electronics
16 4 (0.16%) Automotive
Job Titles
1 1,141 (46.51%) Developer
2 316 (12.88%) SQL Developer
3 304 (12.39%) ETL Developer
4 296 (12.07%) Analyst
5 276 (11.25%) Data Engineer
6 266 (10.84%) Business Intelligence Developer
7 192 (7.83%) Architect
8 155 (6.32%) Data Analyst
9 111 (4.53%) Consultant
10 100 (4.08%) SSIS Developer
11 94 (3.83%) Big Data Engineer
12 91 (3.71%) Data Architect
13 83 (3.38%) Data Warehouse Developer
14 79 (3.22%) AWS Engineer
14 79 (3.22%) SQL BI Developer
15 71 (2.89%) SQL Server Developer
16 63 (2.57%) Oracle Developer
17 56 (2.28%) DBA
18 50 (2.04%) Lead Developer
18 50 (2.04%) Senior Developer
Libraries, Frameworks & Software Standards
1 173 (7.05%) XML
2 152 (6.20%) .NET
3 144 (5.87%) Web Services
4 119 (4.85%) Kafka
5 74 (3.02%) JSON
6 51 (2.08%) HTML
7 46 (1.88%) Middleware
8 44 (1.79%) AngularJS
8 44 (1.79%) Spring
9 43 (1.75%) ASP.NET
9 43 (1.75%) REST
9 43 (1.75%) RESTful
10 37 (1.51%) CSS
11 36 (1.47%) MDX
11 36 (1.47%) Spark Streaming
12 33 (1.35%) WCF
13 28 (1.14%) ASP.NET Web API
13 28 (1.14%) HTML5
14 25 (1.02%) React
14 25 (1.02%) Spring Boot
Miscellaneous
1 361 (14.72%) Analytical Skills
2 88 (3.59%) Greenfield Project
3 76 (3.10%) Data Structures
4 68 (2.77%) Computer Science
5 58 (2.36%) Algorithms
6 52 (2.12%) Fintech
6 52 (2.12%) Wiki
7 46 (1.88%) Management Information System
8 41 (1.67%) Replication
9 38 (1.55%) Enterprise Software
10 31 (1.26%) Reference Data
11 24 (0.98%) User Experience
12 22 (0.90%) NHS
13 20 (0.82%) Fixed Income
13 20 (0.82%) Mobile App
14 19 (0.77%) Self-Motivation
15 17 (0.69%) Virtual Team
16 16 (0.65%) Reinsurance
17 13 (0.53%) Mainframe
18 11 (0.45%) Client/Server
Operating Systems
1 244 (9.95%) Linux
2 236 (9.62%) Unix
3 136 (5.54%) Windows
4 27 (1.10%) Red Hat Enterprise Linux
5 23 (0.94%) Windows Server
6 17 (0.69%) VMS
7 14 (0.57%) Solaris
8 12 (0.49%) Ubuntu
9 7 (0.29%) AIX
10 5 (0.20%) CentOS
10 5 (0.20%) Windows 10
10 5 (0.20%) Windows 7
10 5 (0.20%) Windows Server 2003
11 2 (0.082%) Apple iOS
11 2 (0.082%) SUSE Linux Enterprise Server
11 2 (0.082%) VME
12 1 (0.041%) Mac OS X
12 1 (0.041%) Oracle Linux
12 1 (0.041%) Windows Server 2008
12 1 (0.041%) zOS
Processes & Methodologies
1 844 (34.41%) Business Intelligence
2 804 (32.78%) Agile Software Development
3 469 (19.12%) Analytics
4 436 (17.77%) Data Modelling
5 411 (16.75%) Migration
6 310 (12.64%) Data Migration
7 295 (12.03%) Data Analysis
8 246 (10.03%) Scrum
9 242 (9.87%) ETL Development
10 238 (9.70%) Data Integration
11 197 (8.03%) Problem-Solving
12 195 (7.95%) Test Automation
13 186 (7.58%) Visualisation
14 174 (7.09%) Data Management
15 168 (6.85%) Continuous Integration
16 160 (6.52%) DevOps
17 147 (5.99%) Kimball Methodology
18 138 (5.63%) Performance Tuning
19 134 (5.46%) Data Science
20 127 (5.18%) Data Architecture
Programming Languages
1 1,524 (62.13%) SQL
2 501 (20.42%) Python
3 371 (15.12%) T-SQL
4 354 (14.43%) Java
5 203 (8.28%) PL/SQL
6 197 (8.03%) C#
7 151 (6.16%) Scala
8 130 (5.30%) JavaScript
9 128 (5.22%) Shell Script
10 108 (4.40%) Bash Shell
10 108 (4.40%) PowerShell
11 89 (3.63%) R
12 59 (2.41%) Perl
13 54 (2.20%) Korn
14 53 (2.16%) VBA
15 43 (1.75%) VB
16 34 (1.39%) Ruby
17 26 (1.06%) C
17 26 (1.06%) Data Analysis Expressions (DAX)
18 24 (0.98%) MATLAB
Qualifications
1 145 (5.91%) Security Cleared
2 107 (4.36%) SC Cleared
3 97 (3.95%) Degree
4 29 (1.18%) Computer Science Degree
5 19 (0.77%) ISTQB
5 19 (0.77%) Master's Degree
6 18 (0.73%) ISEB
7 16 (0.65%) BPSS Clearance
8 12 (0.49%) PhD
9 7 (0.29%) Numerate Degree
10 6 (0.24%) PMP
11 5 (0.20%) DBS Check
11 5 (0.20%) PMI Certification
11 5 (0.20%) Postgraduate
11 5 (0.20%) TOGAF Certification
12 4 (0.16%) DV Cleared
13 2 (0.082%) BC Cleared
13 2 (0.082%) ITIL Certification
13 2 (0.082%) Microsoft Certification
13 2 (0.082%) Oracle Certification
Quality Assurance & Compliance
1 243 (9.91%) Data Quality
2 120 (4.89%) QA
3 48 (1.96%) GDPR
4 39 (1.59%) GCP
5 17 (0.69%) PMO
6 11 (0.45%) PCI DSS
7 7 (0.29%) IFRS
7 7 (0.29%) SLA
8 6 (0.24%) IFRS 9
9 5 (0.20%) MiFID
10 4 (0.16%) Solvency II
11 3 (0.12%) EMIR
12 2 (0.082%) HL7
12 2 (0.082%) ISO 20022
12 2 (0.082%) ISO 9001
12 2 (0.082%) ISO 9002
12 2 (0.082%) SEPA
12 2 (0.082%) TickIT
13 1 (0.041%) Disclosure Scotland
13 1 (0.041%) Sarbanes-Oxley
System Software
1 99 (4.04%) Docker
2 91 (3.71%) HDFS
3 35 (1.43%) Apache Flume
4 13 (0.53%) Hyper-V
5 4 (0.16%) Apache ZooKeeper
5 4 (0.16%) Tivoli Workload Scheduler
6 3 (0.12%) Active Directory
6 3 (0.12%) Virtual Machines
7 2 (0.082%) iptables
7 2 (0.082%) NFS
7 2 (0.082%) Oracle RAC
8 1 (0.041%) Veritas Cluster Server
8 1 (0.041%) Virtual Servers
8 1 (0.041%) VirtualBox
8 1 (0.041%) VMware ESXi
8 1 (0.041%) VMware Infrastructure
8 1 (0.041%) Xen
Systems Management
1 133 (5.42%) Ansible
2 99 (4.04%) Opscode Chef
3 77 (3.14%) Puppet
4 75 (3.06%) Hadoop YARN
5 44 (1.79%) Kubernetes
6 21 (0.86%) Control-M
7 18 (0.73%) Kibana
7 18 (0.73%) Oozie
8 11 (0.45%) Terraform
9 10 (0.41%) logstash
9 10 (0.41%) Tivoli
10 8 (0.33%) Mesos
10 8 (0.33%) Nagios
11 6 (0.24%) Ambari
11 6 (0.24%) MOM
12 5 (0.20%) Oracle Flashback
13 4 (0.16%) Failover Clustering
13 4 (0.16%) Oracle RMAN
13 4 (0.16%) Systems Management Server (SMS)
14 3 (0.12%) Capistrano
Vendors
1 601 (24.50%) Oracle
2 442 (18.02%) Microsoft
3 226 (9.21%) Informatica
4 210 (8.56%) Tableau
5 195 (7.95%) SAP
6 180 (7.34%) Talend
7 113 (4.61%) Cloudera
8 92 (3.75%) Google
8 92 (3.75%) IBM
9 71 (2.89%) Ab Initio
9 71 (2.89%) Teradata
10 50 (2.04%) Splunk
11 47 (1.92%) Alteryx
11 47 (1.92%) Cognos
12 46 (1.88%) Salesforce.com
13 40 (1.63%) Hortonworks
14 29 (1.18%) Netezza
15 27 (1.10%) MicroStrategy
16 24 (0.98%) Red Hat
17 19 (0.77%) Workday