Period
to 21 November 2017

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 November 2017 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 Nov 2017
Same period 2016 Same period 2015
Rank 100 87 71
Rank change year-on-year -13 -16 +7
Contract jobs citing ETL 2533 2725 3265
As % of all contract IT jobs advertised in the UK 2.46% 2.60% 2.87%
As % of the Processes & Methodologies category 2.91% 3.10% 3.52%
Number of daily rates quoted 1743 1799 2312
UK median daily rate £450 £425 £425
Median daily rate % change year-on-year +5.88% - +1.19%
10th Percentile £313 £313 £288
90th Percentile £600 £588 £575
UK excluding London median daily rate £420 £400 £400
% change year-on-year +5.00% - +6.67%
Number of hourly rates quoted 29 22 13
UK median hourly rate £46.21 £43.00 £29.50
Median hourly rate % change year-on-year +7.47% +45.76% -22.88%
10th Percentile £34.65 £16.97 £21.50
90th Percentile £67.50 £55.56 £32.45
UK excluding London median hourly rate £46.21 £44.00 £29.50
% change year-on-year +5.02% +49.15% -22.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 87132 87864 92880
As % of all contract IT jobs advertised in the UK 84.49% 83.90% 81.77%
Number of daily rates quoted 58048 58076 60168
UK median daily rate £450 £425 £413
Median daily rate % change year-on-year +5.88% +3.03% +3.13%
10th Percentile £281 £263 £263
90th Percentile £630 £600 £600
UK excluding London median daily rate £400 £400 £385
% change year-on-year - +3.90% +2.67%
Number of hourly rates quoted 2060 2332 2734
UK median hourly rate £23.50 £24.00 £22.50
Median hourly rate % change year-on-year -2.08% +6.67% +18.42%
10th Percentile £11.49 £11.31 £11.50
90th Percentile £49.75 £48.75 £47.71
UK excluding London median hourly rate £24.00 £24.50 £23.75
% change year-on-year -2.04% +3.16% +18.75%

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 November 2017.

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 November 2017.

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 November 2017. 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 -11 2312 £450 +5.88% 261
UK excluding London -9 1314 £420 +5.00% 158
London -5 1186 £475 +3.26% 124
South East +2 372 £425 +2.41% 34
North of England -21 285 £400 - 55
Midlands -4 196 £400 +2.56% 26
South West +43 179 £425 +13.33% 12
North West -22 138 £400 - 25
Scotland +3 134 £400 - 15
West Midlands +3 121 £419 +4.69% 19
Yorkshire -12 120 £425 +10.68% 25
East of England -31 92 £425 +5.30% 10
East Midlands -13 75 £380 +4.83% 7
Wales +6 33 £322 -14.13% 6
North East +35 32 £425 - 5
Northern Ireland -17 31 £420 -

For the 6 months to 21 November 2017, IT contractor jobs citing ETL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads with a requirement for ETL.

1 1510 (59.61%) SQL
2 1055 (41.65%) Data Warehouse
3 938 (37.03%) Business Intelligence
4 844 (33.32%) SQL Server
5 728 (28.74%) SQL Server Integration Services
6 692 (27.32%) Agile Software Development
7 627 (24.75%) Data Modelling
8 599 (23.65%) Finance
9 556 (21.95%) Oracle
10 504 (19.90%) Migration
11 491 (19.38%) Microsoft
12 426 (16.82%) SQL Server Reporting Services
13 396 (15.63%) Analytics
14 393 (15.52%) Big Data
15 360 (14.21%) T-SQL
16 357 (14.09%) Java
17 356 (14.05%) Data Migration
18 330 (13.03%) Hadoop
19 316 (12.48%) SQL Server Analysis Services
20 315 (12.44%) Analytical Skills
21 283 (11.17%) Data Quality
22 280 (11.05%) Python
23 257 (10.15%) Data Analysis
24 247 (9.75%) Relational Database
25 226 (8.92%) ETL Development
25 226 (8.92%) Data Integration
26 225 (8.88%) Data Management
27 221 (8.72%) Performance Tuning
28 217 (8.57%) Informatica
29 216 (8.53%) Apache Spark

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 216 (8.53%) Apache Spark
2 116 (4.58%) SAS
3 81 (3.20%) Apache
3 81 (3.20%) SharePoint
4 50 (1.97%) Tomcat
5 46 (1.82%) Apache Pig
6 21 (0.83%) Confluence
6 21 (0.83%) WebSphere
7 20 (0.79%) GemFire
8 17 (0.67%) Cloud Foundry
9 16 (0.63%) Apache Airflow
10 15 (0.59%) WebLogic
11 14 (0.55%) ArcGIS
11 14 (0.55%) BizTalk Server
11 14 (0.55%) Elasticsearch
11 14 (0.55%) JBoss
11 14 (0.55%) Oracle SOA Suite
12 13 (0.51%) Documentum
12 13 (0.51%) OpenStack
12 13 (0.51%) PowerExchange
Applications
1 109 (4.30%) Microsoft Excel
2 49 (1.93%) Microsoft Office
3 27 (1.07%) MS Visio
4 14 (0.55%) SPSS
5 12 (0.47%) Microsoft Project
6 9 (0.36%) Microsoft PowerPoint
7 2 (0.079%) Adobe Illustrator
8 1 (0.039%) Mingle
8 1 (0.039%) Spreadsheet
8 1 (0.039%) Stata
8 1 (0.039%) Weka
Business Applications
1 49 (1.93%) Markit EDM
2 27 (1.07%) Dynamics CRM
3 22 (0.87%) Maximo
4 20 (0.79%) Dynamics AX
5 19 (0.75%) Cognos Business Intelligence
6 14 (0.55%) Cognos TM1
7 12 (0.47%) Oracle ERP
7 12 (0.47%) Unit4 Business World
8 11 (0.43%) Salesforce.com CRM
8 11 (0.43%) SAP CRM
9 10 (0.39%) Dynamics NAV
10 8 (0.32%) Hyperion Planning
10 8 (0.32%) SAP MM
11 6 (0.24%) Oracle Receivables
11 6 (0.24%) SAP APO
12 5 (0.20%) Oracle BPM
12 5 (0.20%) Remedy ITSM
12 5 (0.20%) SAP ERP
12 5 (0.20%) SAP MDM
13 4 (0.16%) Oracle iProcurement
Cloud Services
1 207 (8.17%) Amazon AWS
2 178 (7.03%) Microsoft Azure
3 82 (3.24%) GitHub
4 48 (1.89%) Amazon S3
5 44 (1.74%) Google Cloud Platform
6 31 (1.22%) PaaS
6 31 (1.22%) SaaS
7 29 (1.14%) Amazon EMR
8 22 (0.87%) Salesforce Service Cloud
9 21 (0.83%) Cloud Computing
10 20 (0.79%) Amazon Kinesis
11 18 (0.71%) Amazon EC2
12 15 (0.59%) Force.com
12 15 (0.59%) IaaS
13 13 (0.51%) Boomi
13 13 (0.51%) Salesforce Sales Cloud
14 12 (0.47%) npm
15 11 (0.43%) Dynamics 365
16 10 (0.39%) AWS Lambda
16 10 (0.39%) Serverless
Communications & Networking
1 27 (1.07%) Internet
2 25 (0.99%) Intranet
3 19 (0.75%) FTP
3 19 (0.75%) VPN
4 15 (0.59%) LAN
5 14 (0.55%) WAN
6 13 (0.51%) LDAP
7 11 (0.43%) SMS
8 10 (0.39%) SAN
9 7 (0.28%) Kerberos
10 6 (0.24%) DNS
10 6 (0.24%) Firewall
10 6 (0.24%) HTTP
10 6 (0.24%) TCP/IP
11 4 (0.16%) Remote Desktop
12 3 (0.12%) 2G
12 3 (0.12%) 3G
12 3 (0.12%) ATM
12 3 (0.12%) DWDM
12 3 (0.12%) Skype
Database & Business Intelligence
1 1055 (41.65%) Data Warehouse
2 844 (33.32%) SQL Server
3 728 (28.74%) SQL Server Integration Services
4 426 (16.82%) SQL Server Reporting Services
5 393 (15.52%) Big Data
6 330 (13.03%) Hadoop
7 316 (12.48%) SQL Server Analysis Services
8 247 (9.75%) Relational Database
9 189 (7.46%) Power BI
10 188 (7.42%) Apache Hive
11 143 (5.65%) SQL Server 2008
12 142 (5.61%) BusinessObjects
13 138 (5.45%) OLAP
14 124 (4.90%) Oracle Database
15 120 (4.74%) HBase
16 119 (4.70%) QlikView
17 118 (4.66%) NoSQL
18 114 (4.50%) RDBMS
19 113 (4.46%) SQL Server 2016
20 112 (4.42%) SQL Server 2012
Development Applications
1 127 (5.01%) Git (software)
2 110 (4.34%) JIRA
3 98 (3.87%) Talend Open Studio
4 91 (3.59%) Team Foundation Server
5 78 (3.08%) Visual Studio
6 67 (2.65%) Jenkins
7 52 (2.05%) Eclipse
8 50 (1.97%) Subversion
9 48 (1.89%) JUnit
10 47 (1.86%) Maven
11 34 (1.34%) ERwin
12 31 (1.22%) SQL Server Management Studio (SSMS)
13 30 (1.18%) Selenium
14 26 (1.03%) Gradle
15 24 (0.95%) IntelliJ
16 23 (0.91%) Ant
17 20 (0.79%) Octopus Deploy
18 18 (0.71%) Cucumber
18 18 (0.71%) SoapUI
19 17 (0.67%) Mockito
General
1 599 (23.65%) Finance
2 215 (8.49%) Banking
3 85 (3.36%) Marketing
4 82 (3.24%) Retail
5 69 (2.72%) Telecoms
6 58 (2.29%) Legal
7 45 (1.78%) Investment Banking
8 35 (1.38%) Front Office
9 31 (1.22%) Manufacturing
9 31 (1.22%) Pharmaceutical
10 27 (1.07%) Retail Banking
11 26 (1.03%) Electronics
11 26 (1.03%) Games
12 25 (0.99%) Publishing
13 16 (0.63%) Back Office
14 15 (0.59%) Advertising
15 9 (0.36%) Law
16 7 (0.28%) Financial Institution
17 5 (0.20%) Japanese Language
18 4 (0.16%) German Language
Job Titles
1 1151 (45.44%) Developer
2 381 (15.04%) Analyst
3 347 (13.70%) SQL Developer
4 282 (11.13%) Business Intelligence Developer
5 281 (11.09%) Architect
6 267 (10.54%) ETL Developer
7 192 (7.58%) Data Engineer
8 171 (6.75%) Data Analyst
9 155 (6.12%) SSIS Developer
10 138 (5.45%) Data Architect
11 115 (4.54%) Consultant
12 94 (3.71%) Senior Developer
13 90 (3.55%) Business Developer
14 89 (3.51%) Data Warehouse Developer
15 80 (3.16%) Business Intelligence Analyst
15 80 (3.16%) Test Analyst
16 78 (3.08%) SQL Server Developer
17 74 (2.92%) SQL BI Developer
18 73 (2.88%) Big Data Engineer
18 73 (2.88%) Java Developer
Libraries, Frameworks & Software Standards
1 199 (7.86%) XML
2 158 (6.24%) .NET
3 153 (6.04%) Kafka
4 149 (5.88%) Web Services
5 119 (4.70%) MDX
6 99 (3.91%) JSON
6 99 (3.91%) Spring
7 87 (3.43%) REST
8 67 (2.65%) Spark Streaming
9 55 (2.17%) JMS
10 48 (1.89%) HTML
11 43 (1.70%) AngularJS
12 42 (1.66%) J2EE
12 42 (1.66%) RESTful
13 41 (1.62%) CSS
13 41 (1.62%) Spring Boot
14 40 (1.58%) SOAP
15 39 (1.54%) XSD
16 37 (1.46%) Hibernate
17 34 (1.34%) Ajax
Miscellaneous
1 315 (12.44%) Analytical Skills
2 95 (3.75%) Data Structures
3 81 (3.20%) Management Information System
4 60 (2.37%) Greenfield Project
5 47 (1.86%) Replication
6 39 (1.54%) Algorithms
6 39 (1.54%) Computer Science
7 29 (1.14%) Market Risk
8 28 (1.11%) Credit Risk
9 25 (0.99%) User Experience
10 24 (0.95%) Fintech
10 24 (0.95%) Fixed Income
11 23 (0.91%) Reference Data
11 23 (0.91%) Virtual Team
12 22 (0.87%) NHS
13 20 (0.79%) Data Centre
14 19 (0.75%) Clustering
15 18 (0.71%) Enterprise Software
16 17 (0.67%) Blog
16 17 (0.67%) Derivative
Operating Systems
1 202 (7.97%) Linux
2 177 (6.99%) Unix
3 70 (2.76%) Windows
4 29 (1.14%) Red Hat Enterprise Linux
5 16 (0.63%) HPUX
6 13 (0.51%) Solaris
7 12 (0.47%) CentOS
8 10 (0.39%) Windows Server
9 8 (0.32%) Mac OS X
10 4 (0.16%) AIX
10 4 (0.16%) Windows Server 2008
11 3 (0.12%) Windows Server 2003
11 3 (0.12%) Windows XP
12 2 (0.079%) Oracle Linux
13 1 (0.039%) OpenVMS
13 1 (0.039%) Windows 10
13 1 (0.039%) Windows 7
13 1 (0.039%) Windows Server 2012
Processes & Methodologies
1 938 (37.03%) Business Intelligence
2 692 (27.32%) Agile Software Development
3 627 (24.75%) Data Modelling
4 504 (19.90%) Migration
5 396 (15.63%) Analytics
6 356 (14.05%) Data Migration
7 257 (10.15%) Data Analysis
8 226 (8.92%) Data Integration
8 226 (8.92%) ETL Development
9 225 (8.88%) Data Management
10 221 (8.72%) Performance Tuning
11 214 (8.45%) Scrum
12 200 (7.90%) Kimball Methodology
13 158 (6.24%) Data Architecture
14 155 (6.12%) Visualisation
15 147 (5.80%) Continuous Integration
16 141 (5.57%) Test Automation
17 136 (5.37%) Data Cleansing
17 136 (5.37%) DevOps
18 128 (5.05%) Dimensional Modelling
Programming Languages
1 1510 (59.61%) SQL
2 360 (14.21%) T-SQL
3 357 (14.09%) Java
4 280 (11.05%) Python
5 168 (6.63%) C#
6 166 (6.55%) PL/SQL
7 148 (5.84%) JavaScript
8 124 (4.90%) Shell Script
9 109 (4.30%) Scala
10 59 (2.33%) Data Analysis Expressions (DAX)
11 55 (2.17%) PowerShell
12 54 (2.13%) R
13 38 (1.50%) Bash Shell
14 31 (1.22%) VBA
15 29 (1.14%) Perl
16 28 (1.11%) Apex Code
17 21 (0.83%) SAS Macro
18 20 (0.79%) C
18 20 (0.79%) VBScript
19 15 (0.59%) TypeScript
Qualifications
1 170 (6.71%) Security Cleared
2 119 (4.70%) Degree
3 115 (4.54%) SC Cleared
4 27 (1.07%) ISTQB
5 25 (0.99%) DV Cleared
5 25 (0.99%) ISEB
6 24 (0.95%) Microsoft Certification
7 20 (0.79%) MCITP
8 19 (0.75%) MCSE
9 16 (0.63%) BPSS Clearance
10 13 (0.51%) Computer Science Degree
11 11 (0.43%) Master's Degree
12 8 (0.32%) PMI Certification
13 6 (0.24%) CTC Cleared
13 6 (0.24%) ISTQB Foundation Certification
14 5 (0.20%) CFA
15 4 (0.16%) PMP
16 3 (0.12%) PhD
16 3 (0.12%) Postgraduate
16 3 (0.12%) SAS Certification
Quality Assurance & Compliance
1 283 (11.17%) Data Quality
2 136 (5.37%) QA
3 23 (0.91%) GDPR
4 17 (0.67%) Disclosure Scotland
5 16 (0.63%) MiFID
5 16 (0.63%) SLA
6 9 (0.36%) EMIR
6 9 (0.36%) GxP
7 8 (0.32%) Actionable Recommendations
8 7 (0.28%) IFRS
8 7 (0.28%) IFRS 9
8 7 (0.28%) Sarbanes-Oxley
9 5 (0.20%) Dodd-Frank
10 4 (0.16%) GCP
11 3 (0.12%) AIFMD
11 3 (0.12%) HL7
11 3 (0.12%) ISO/IEC 27001
11 3 (0.12%) Solvency II
12 2 (0.079%) CDISC
12 2 (0.079%) ISO 20022
System Software
1 59 (2.33%) Apache Flume
2 57 (2.25%) HDFS
3 35 (1.38%) Docker
4 13 (0.51%) Apache ZooKeeper
5 10 (0.39%) Active Directory
6 7 (0.28%) Tivoli Workload Scheduler
7 6 (0.24%) Oracle RAC
7 6 (0.24%) VMware Infrastructure
8 5 (0.20%) Virtual Machines
9 4 (0.16%) NFS
10 1 (0.039%) Hyper-V
10 1 (0.039%) Oracle Clusterware
10 1 (0.039%) VirtualBox
10 1 (0.039%) Xen
Systems Management
1 40 (1.58%) Ansible
2 37 (1.46%) Oozie
3 33 (1.30%) Hadoop YARN
4 27 (1.07%) Control-M
5 18 (0.71%) Data Guard
6 16 (0.63%) Prometheus
7 15 (0.59%) Oracle EDQ
7 15 (0.59%) Puppet
8 13 (0.51%) Opscode Chef
9 12 (0.47%) Oracle RMAN
10 10 (0.39%) Tivoli
11 7 (0.28%) Kubernetes
12 6 (0.24%) Ambari
12 6 (0.24%) Terraform
13 5 (0.20%) HP Quality Center
14 4 (0.16%) Failover Clustering
14 4 (0.16%) Systems Management Server (SMS)
15 3 (0.12%) Oracle Identity Manager
15 3 (0.12%) Rundeck
15 3 (0.12%) Salt
Vendors
1 556 (21.95%) Oracle
2 491 (19.38%) Microsoft
3 217 (8.57%) Informatica
4 203 (8.01%) Tableau
5 135 (5.33%) SAP
6 119 (4.70%) IBM
7 98 (3.87%) Talend
8 90 (3.55%) Teradata
9 85 (3.36%) Salesforce.com
10 79 (3.12%) Cognos
11 45 (1.78%) Cloudera
12 37 (1.46%) Ab Initio
12 37 (1.46%) Google
13 32 (1.26%) Netezza
14 31 (1.22%) MicroStrategy
15 28 (1.11%) Hortonworks
16 25 (0.99%) HP
16 25 (0.99%) MapR
17 24 (0.95%) Alteryx
17 24 (0.95%) RedGate