Period
to 17 February 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 17 February 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
17 Feb 2018
Same period 2017 Same period 2016
Rank 101 92 76
Rank change year-on-year -9 -16 -2
Contract jobs citing ETL 2,369 2,390 2,906
As % of all contract IT jobs advertised in the UK 2.35% 2.49% 2.69%
As % of the Processes & Methodologies category 2.78% 2.97% 3.25%
Number of daily rates quoted 1,711 1,549 2,112
UK median daily rate £450 £433 £425
Median daily rate % change year-on-year +4.05% +1.76% +3.03%
10th Percentile £313 £310 £290
90th Percentile £600 £600 £575
UK excluding London median daily rate £413 £400 £400
% change year-on-year +3.13% - +6.67%
Number of hourly rates quoted 16 26 6
UK median hourly rate £56.50 £40.00 £41.75
Median hourly rate % change year-on-year +41.25% -4.19% +10.23%
10th Percentile £41.40 £18.12 £28.75
90th Percentile £74.38 £48.00 £61.00
UK excluding London median hourly rate £48.73 £40.00 £41.75
% change year-on-year +21.83% -4.19% +11.33%

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 85,211 80,432 89,445
As % of all contract IT jobs advertised in the UK 84.70% 83.82% 82.82%
Number of daily rates quoted 56,902 53,269 58,166
UK median daily rate £450 £425 £425
Median daily rate % change year-on-year +5.88% - +6.25%
10th Percentile £288 £263 £263
90th Percentile £638 £613 £600
UK excluding London median daily rate £413 £400 £390
% change year-on-year +3.13% +2.56% +4.00%
Number of hourly rates quoted 2,047 2,240 2,647
UK median hourly rate £24.00 £25.00 £24.23
Median hourly rate % change year-on-year -4.00% +3.18% +21.15%
10th Percentile £11.50 £11.30 £11.50
90th Percentile £50.35 £49.50 £50.00
UK excluding London median hourly rate £25.00 £25.00 £25.66
% change year-on-year - -2.57% +25.17%

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 17 February 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 17 February 2018.

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 17 February 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 -17 2,084 £450 +2.86% 519
UK excluding London +5 1,263 £413 +3.13% 315
London -19 1,077 £500 +11.11% 250
South East -16 346 £425 -5.56% 60
North of England -16 249 £400 +3.23% 91
Scotland +29 176 £400 - 29
Midlands -17 163 £400 +8.84% 46
South West +45 162 £425 +7.26% 32
Yorkshire -6 119 £398 +9.66% 37
North West -30 106 £413 +3.13% 51
West Midlands -7 101 £425 +13.33% 35
East of England -28 90 £438 +9.38% 39
East Midlands -21 62 £344 -5.17% 10
Wales +25 58 £322 -34.95% 17
North East +29 26 £425 -9.91% 3
Northern Ireland +5 20 £385 +0.92% 1
Isle of Man - 8 £400 -

For the 6 months to 17 February 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,406 (59.35%) SQL
2 1,029 (43.44%) Data Warehouse
3 903 (38.12%) Business Intelligence
4 762 (32.17%) SQL Server
5 712 (30.05%) SQL Server Integration Services
6 669 (28.24%) Agile Software Development
7 580 (24.48%) Data Modelling
8 548 (23.13%) Finance
9 487 (20.56%) Oracle
10 464 (19.59%) Microsoft
11 454 (19.16%) Migration
12 417 (17.60%) Analytics
13 407 (17.18%) Big Data
14 396 (16.72%) SQL Server Reporting Services
15 343 (14.48%) Data Migration
16 327 (13.80%) T-SQL
17 316 (13.34%) Python
18 308 (13.00%) Java
19 305 (12.87%) Hadoop
20 286 (12.07%) SQL Server Analysis Services
21 270 (11.40%) Analytical Skills
22 256 (10.81%) Data Analysis
22 256 (10.81%) Data Quality
23 253 (10.68%) ETL Development
23 253 (10.68%) Data Management
24 227 (9.58%) Apache Spark
25 225 (9.50%) Relational Database
26 221 (9.33%) Informatica
27 217 (9.16%) Power BI
28 206 (8.70%) Tableau

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 227 (9.58%) Apache Spark
2 141 (5.95%) SAS
3 76 (3.21%) SharePoint
4 70 (2.95%) Apache
5 45 (1.90%) Apache Pig
6 32 (1.35%) Tomcat
7 18 (0.76%) Confluence
7 18 (0.76%) Oracle SOA Suite
8 15 (0.63%) Apache Airflow
9 14 (0.59%) Apache Solr
10 13 (0.55%) Elasticsearch
11 12 (0.51%) Cloud Foundry
11 12 (0.51%) GemFire
12 11 (0.46%) JBoss
12 11 (0.46%) WebSphere
13 9 (0.38%) ArcGIS
13 9 (0.38%) IIS
13 9 (0.38%) PowerExchange
13 9 (0.38%) SharePoint Server
14 8 (0.34%) CMS
Applications
1 108 (4.56%) Microsoft Excel
2 45 (1.90%) Microsoft Office
3 29 (1.22%) MS Visio
4 13 (0.55%) SPSS
5 11 (0.46%) Microsoft Project
6 8 (0.34%) Microsoft PowerPoint
7 5 (0.21%) Spreadsheet
8 3 (0.13%) Stata
9 2 (0.084%) Adobe Illustrator
10 1 (0.042%) Chatbot
Business Applications
1 48 (2.03%) Markit EDM
2 20 (0.84%) Cognos Business Intelligence
3 19 (0.80%) Dynamics CRM
4 18 (0.76%) Dynamics AX
5 12 (0.51%) Unit4 Business World
6 10 (0.42%) Cognos TM1
6 10 (0.42%) Oracle EBS
7 9 (0.38%) Salesforce.com CRM
8 8 (0.34%) Maximo
8 8 (0.34%) Oracle ERP
8 8 (0.34%) Oracle Receivables
8 8 (0.34%) SAP MM
9 7 (0.30%) BusinessWare
9 7 (0.30%) Dynamics NAV
9 7 (0.30%) Hyperion Planning
10 6 (0.25%) SAP APO
11 5 (0.21%) Oracle Payables
11 5 (0.21%) Remedy ITSM
11 5 (0.21%) SAP ERP
11 5 (0.21%) SAP MDM
Cloud Services
1 204 (8.61%) Amazon AWS
2 189 (7.98%) Microsoft Azure
3 62 (2.62%) Amazon S3
4 48 (2.03%) Google Cloud Platform
5 39 (1.65%) GitHub
6 37 (1.56%) SaaS
7 29 (1.22%) PaaS
8 17 (0.72%) Amazon Kinesis
8 17 (0.72%) Azure Data Factory
9 16 (0.68%) Amazon EMR
9 16 (0.68%) Boomi
10 14 (0.59%) Serverless
11 13 (0.55%) Cloud Computing
11 13 (0.55%) IaaS
11 13 (0.55%) Office 365
12 12 (0.51%) Amazon EC2
12 12 (0.51%) AWS Lambda
12 12 (0.51%) Slack
13 11 (0.46%) Dynamics 365
14 10 (0.42%) Salesforce Service Cloud
Communications & Networking
1 17 (0.72%) FTP
1 17 (0.72%) Intranet
2 15 (0.63%) Internet
2 15 (0.63%) TCP/IP
3 12 (0.51%) HTTP
4 10 (0.42%) Firewall
4 10 (0.42%) Kerberos
5 9 (0.38%) SMS
6 8 (0.34%) SSL
7 7 (0.30%) DNS
7 7 (0.30%) SAN
8 5 (0.21%) DSL
8 5 (0.21%) NAS
9 4 (0.17%) Skype
10 3 (0.13%) 2G
10 3 (0.13%) 3G
10 3 (0.13%) ATM
10 3 (0.13%) DWDM
10 3 (0.13%) RNC
11 2 (0.084%) VPN
Database & Business Intelligence
1 1,029 (43.44%) Data Warehouse
2 762 (32.17%) SQL Server
3 712 (30.05%) SQL Server Integration Services
4 407 (17.18%) Big Data
5 396 (16.72%) SQL Server Reporting Services
6 305 (12.87%) Hadoop
7 286 (12.07%) SQL Server Analysis Services
8 225 (9.50%) Relational Database
9 217 (9.16%) Power BI
10 177 (7.47%) Apache Hive
11 128 (5.40%) NoSQL
12 121 (5.11%) Oracle Database
13 116 (4.90%) BusinessObjects
13 116 (4.90%) SQL Server 2008
14 103 (4.35%) RDBMS
15 102 (4.31%) SQL Server 2012
16 101 (4.26%) SQL Server 2016
17 100 (4.22%) OLAP
18 98 (4.14%) Amazon Redshift
19 97 (4.09%) QlikView
Development Applications
1 102 (4.31%) Git (software)
2 83 (3.50%) JIRA
3 68 (2.87%) Jenkins
4 64 (2.70%) Team Foundation Server
5 50 (2.11%) Visual Studio
6 44 (1.86%) SQL Server Management Studio (SSMS)
7 35 (1.48%) ERwin
8 34 (1.44%) Subversion
9 25 (1.06%) JUnit
10 24 (1.01%) Selenium
10 24 (1.01%) TeamCity
11 21 (0.89%) Eclipse
12 20 (0.84%) Maven
13 13 (0.55%) Gradle
13 13 (0.55%) LSMW
13 13 (0.55%) PowerDesigner
14 12 (0.51%) IntelliJ
14 12 (0.51%) Toad
15 11 (0.46%) Ant
16 10 (0.42%) JMeter
General
1 548 (23.13%) Finance
2 190 (8.02%) Banking
3 98 (4.14%) Retail
4 47 (1.98%) Telecoms
5 46 (1.94%) Legal
5 46 (1.94%) Marketing
6 41 (1.73%) Manufacturing
7 33 (1.39%) Investment Banking
8 27 (1.14%) Pharmaceutical
9 20 (0.84%) Retail Banking
10 18 (0.76%) Games
11 16 (0.68%) Electronics
11 16 (0.68%) Law
12 15 (0.63%) Publishing
13 14 (0.59%) Advertising
14 12 (0.51%) Front Office
15 8 (0.34%) Back Office
16 7 (0.30%) Financial Institution
17 4 (0.17%) Billing
17 4 (0.17%) French Language
Job Titles
1 1,046 (44.15%) Developer
2 368 (15.53%) Analyst
3 301 (12.71%) SQL Developer
4 273 (11.52%) Architect
5 266 (11.23%) Business Intelligence Developer
6 234 (9.88%) ETL Developer
7 230 (9.71%) Data Engineer
8 148 (6.25%) Data Analyst
9 144 (6.08%) SSIS Developer
10 131 (5.53%) Data Architect
11 104 (4.39%) Consultant
12 94 (3.97%) Senior Developer
13 86 (3.63%) Data Warehouse Developer
14 83 (3.50%) Test Analyst
15 81 (3.42%) Big Data Engineer
15 81 (3.42%) Business Intelligence Analyst
16 72 (3.04%) SQL BI Developer
17 65 (2.74%) Solutions Architect
18 58 (2.45%) SQL Server Developer
18 58 (2.45%) SSRS Developer
Libraries, Frameworks & Software Standards
1 151 (6.37%) XML
2 140 (5.91%) .NET
3 118 (4.98%) Kafka
4 92 (3.88%) Web Services
5 70 (2.95%) MDX
6 65 (2.74%) JSON
7 55 (2.32%) REST
8 48 (2.03%) Spring
9 41 (1.73%) XSD
10 35 (1.48%) SOAP
11 34 (1.44%) HTML
12 32 (1.35%) RESTful
13 31 (1.31%) XML Schema
14 30 (1.27%) Middleware
15 29 (1.22%) JMS
16 28 (1.18%) Spark Streaming
17 25 (1.06%) J2EE
18 22 (0.93%) CSS
18 22 (0.93%) Natural Language Processing
18 22 (0.93%) Spring Boot
Miscellaneous
1 270 (11.40%) Analytical Skills
2 85 (3.59%) Data Structures
3 68 (2.87%) Management Information System
4 65 (2.74%) Greenfield Project
5 58 (2.45%) Computer Science
6 34 (1.44%) Replication
7 30 (1.27%) Market Risk
8 27 (1.14%) NHS
9 24 (1.01%) Reference Data
10 23 (0.97%) Data Centre
10 23 (0.97%) User Experience
11 22 (0.93%) Fintech
12 19 (0.80%) Enterprise Software
13 16 (0.68%) Clustering
14 15 (0.63%) Mainframe
15 14 (0.59%) Virtual Team
16 13 (0.55%) Credit Risk
16 13 (0.55%) Life Science
16 13 (0.55%) Reinsurance
17 12 (0.51%) FMCG
Operating Systems
1 154 (6.50%) Unix
2 146 (6.16%) Linux
3 54 (2.28%) Windows
4 27 (1.14%) Red Hat Enterprise Linux
5 23 (0.97%) AIX
6 14 (0.59%) Windows Server
7 10 (0.42%) CentOS
8 9 (0.38%) Windows Server 2008
9 7 (0.30%) HPUX
10 6 (0.25%) Windows Server 2003
11 5 (0.21%) Windows 7
12 4 (0.17%) Solaris
12 4 (0.17%) Windows Server 2012
13 3 (0.13%) Windows 10
14 2 (0.084%) VME
15 1 (0.042%) Mac OS X
15 1 (0.042%) Ubuntu
Processes & Methodologies
1 903 (38.12%) Business Intelligence
2 669 (28.24%) Agile Software Development
3 580 (24.48%) Data Modelling
4 454 (19.16%) Migration
5 417 (17.60%) Analytics
6 343 (14.48%) Data Migration
7 256 (10.81%) Data Analysis
8 253 (10.68%) Data Management
8 253 (10.68%) ETL Development
9 181 (7.64%) Performance Tuning
10 180 (7.60%) Scrum
11 176 (7.43%) Data Integration
12 170 (7.18%) Visualisation
13 151 (6.37%) Data Architecture
14 141 (5.95%) Kimball Methodology
15 123 (5.19%) Data Science
16 117 (4.94%) Data Analytics
17 113 (4.77%) Test Automation
18 110 (4.64%) CRM
19 108 (4.56%) Data Mapping
Programming Languages
1 1,406 (59.35%) SQL
2 327 (13.80%) T-SQL
3 316 (13.34%) Python
4 308 (13.00%) Java
5 157 (6.63%) PL/SQL
6 139 (5.87%) C#
7 107 (4.52%) R
8 106 (4.47%) JavaScript
9 90 (3.80%) Scala
10 84 (3.55%) Shell Script
11 40 (1.69%) Bash Shell
12 33 (1.39%) Data Analysis Expressions (DAX)
13 32 (1.35%) Perl
14 31 (1.31%) PowerShell
15 24 (1.01%) VBA
16 18 (0.76%) Apex Code
17 13 (0.55%) C++
18 12 (0.51%) VB
19 11 (0.46%) C
19 11 (0.46%) VB.NET
Qualifications
1 113 (4.77%) Security Cleared
2 109 (4.60%) Degree
3 64 (2.70%) SC Cleared
4 25 (1.06%) Computer Science Degree
5 24 (1.01%) Microsoft Certification
6 21 (0.89%) ISTQB
7 19 (0.80%) BPSS Clearance
8 16 (0.68%) MCSE
9 12 (0.51%) DV Cleared
10 11 (0.46%) MCITP
11 10 (0.42%) ISEB
12 9 (0.38%) PhD
13 8 (0.34%) ISTQB Foundation Certification
13 8 (0.34%) Numerate Degree
14 7 (0.30%) PMI Certification
15 6 (0.25%) Master's Degree
15 6 (0.25%) MCSA
16 5 (0.21%) CTC Cleared
16 5 (0.21%) PMP
17 4 (0.17%) Oracle Certification
Quality Assurance & Compliance
1 256 (10.81%) Data Quality
2 122 (5.15%) QA
3 37 (1.56%) GDPR
4 26 (1.10%) Disclosure Scotland
5 13 (0.55%) MiFID
5 13 (0.55%) Sarbanes-Oxley
6 12 (0.51%) SLA
7 11 (0.46%) IFRS
8 10 (0.42%) IFRS 9
9 9 (0.38%) EMIR
9 9 (0.38%) GxP
10 8 (0.34%) Dodd-Frank
10 8 (0.34%) GCP
11 4 (0.17%) ISO/IEC 20000
11 4 (0.17%) PMO
12 3 (0.13%) HL7
12 3 (0.13%) ISO/IEC 27001
12 3 (0.13%) PCI DSS
13 2 (0.084%) BS7666
13 2 (0.084%) CDISC
System Software
1 68 (2.87%) HDFS
2 53 (2.24%) Docker
3 47 (1.98%) Apache Flume
4 9 (0.38%) Apache ZooKeeper
5 5 (0.21%) Oracle RAC
5 5 (0.21%) Virtual Machines
6 4 (0.17%) VMware Infrastructure
7 3 (0.13%) Tivoli Workload Scheduler
8 2 (0.084%) Active Directory
9 1 (0.042%) GeoWebCache
9 1 (0.042%) Hyper-V
9 1 (0.042%) Oracle Clusterware
9 1 (0.042%) Veritas Cluster Server
9 1 (0.042%) Virtual Servers
9 1 (0.042%) VirtualBox
9 1 (0.042%) VMware ESXi
9 1 (0.042%) Xen
Systems Management
1 49 (2.07%) Oozie
2 32 (1.35%) Hadoop YARN
3 27 (1.14%) Ansible
4 22 (0.93%) Control-M
5 13 (0.55%) Data Guard
5 13 (0.55%) Terraform
6 11 (0.46%) Opscode Chef
6 11 (0.46%) Puppet
7 10 (0.42%) Kubernetes
7 10 (0.42%) Oracle EDQ
8 7 (0.30%) Ambari
8 7 (0.30%) HP Quality Center
8 7 (0.30%) Oracle RMAN
8 7 (0.30%) Salt
8 7 (0.30%) Tivoli
9 5 (0.21%) Systems Management Server (SMS)
10 4 (0.17%) WMI
11 3 (0.13%) Grafana
11 3 (0.13%) Nagios
11 3 (0.13%) Rundeck
Vendors
1 487 (20.56%) Oracle
2 464 (19.59%) Microsoft
3 221 (9.33%) Informatica
4 206 (8.70%) Tableau
5 155 (6.54%) SAP
6 102 (4.31%) IBM
7 84 (3.55%) Cognos
8 82 (3.46%) Salesforce.com
9 79 (3.33%) Teradata
10 77 (3.25%) Talend
11 67 (2.83%) Cloudera
12 48 (2.03%) Ab Initio
13 45 (1.90%) Google
14 44 (1.86%) Hortonworks
15 30 (1.27%) Netezza
16 28 (1.18%) MicroStrategy
17 25 (1.06%) MapR
18 24 (1.01%) Capita
18 24 (1.01%) MuleSoft
19 22 (0.93%) Alteryx