Period
to 22 January 2018

The following table provides summary statistics for contract job vacancies advertised in London 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 22 January 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)
England > London
6 months to
22 Jan 2018
Same period 2017 Same period 2016
Rank 104 99 84
Rank change year-on-year -5 -15 -5
Contract jobs citing ETL 1,137 1,112 1,233
As % of all contract IT jobs advertised in London 2.46% 2.70% 2.79%
As % of the Processes & Methodologies category 2.84% 3.14% 3.30%
Number of daily rates quoted 853 743 890
London median daily rate £488 £460 £450
Median daily rate % change year-on-year +5.98% +2.22% -
10th Percentile £350 £331 £325
90th Percentile £638 £625 £600
England median daily rate £450 £435 £425
% change year-on-year +3.45% +2.35% -
Number of hourly rates quoted 2 12 0
London median hourly rate £62.50 £41.00 -
Median hourly rate % change year-on-year +52.44% - -
England median hourly rate £48.73 £41.00 £45.00
% change year-on-year +18.85% -8.89% +17.65%

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 advertised in London with a requirement for process or methodology skills.

All Process and Methodology Skills
London
Contract vacancies with a requirement for process or methodology skills 40,009 35,437 37,392
As % of all contract IT jobs advertised in London 86.62% 86.02% 84.70%
Number of daily rates quoted 29,226 25,499 26,670
London median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.56% -
10th Percentile £313 £310 £300
90th Percentile £675 £650 £638
England median daily rate £450 £434 £425
% change year-on-year +3.72% +2.09% +6.12%
Number of hourly rates quoted 409 421 463
London median hourly rate £22.00 £24.00 £20.00
Median hourly rate % change year-on-year -8.33% +20.00% +6.13%
10th Percentile £13.46 £12.25 £11.25
90th Percentile £48.75 £52.50 £50.00
England median hourly rate £23.50 £25.00 £23.00
% change year-on-year -6.00% +8.70% +15.00%

ETL
Job Vacancy Trend in London

Job postings citing ETL as a percentage of all IT jobs advertised in London.

Job vacancy trend for ETL in London

ETL
Contractor Daily Rate Trend in London

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing ETL in London.

Contractor daily rate trend for ETL in London

ETL
Contractor Daily Rate Histogram in London

The daily rate distribution of IT jobs citing ETL in London over the 6 months to 22 January 2018.

Contractor daily rate histogram for ETL in London

ETL
Contractor Hourly Rate Trend in London

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing ETL in London.

Contractor hourly rate trend for ETL in London

ETL
Contract Job Locations in London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing ETL within the London region over the 6 months to 22 January 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
Central London -20 230 £488 +5.41% 80
West London -22 34 £413 -2.94% 30
South London -21 24 £480 -1.54% 5
East London -21 17 £548 -4.78% 10
North London -3 3 - - 2
ETL
England

For the 6 months to 22 January 2018, 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 across the London region with a requirement for ETL.

1 731 (64.29%) SQL
2 504 (44.33%) Data Warehouse
3 460 (40.46%) Business Intelligence
4 403 (35.44%) SQL Server
5 333 (29.29%) SQL Server Integration Services
6 326 (28.67%) Agile Software Development
7 284 (24.98%) Data Modelling
8 273 (24.01%) Finance
9 251 (22.08%) Analytics
10 243 (21.37%) Big Data
11 222 (19.53%) Microsoft
11 222 (19.53%) Oracle
12 199 (17.50%) SQL Server Reporting Services
13 188 (16.53%) Hadoop
14 179 (15.74%) Java
15 178 (15.66%) Python
16 175 (15.39%) Migration
17 173 (15.22%) T-SQL
18 160 (14.07%) SQL Server Analysis Services
19 145 (12.75%) Apache Spark
20 140 (12.31%) Data Migration
21 138 (12.14%) Analytical Skills
22 136 (11.96%) Amazon AWS
23 128 (11.26%) Data Analysis
24 126 (11.08%) Data Quality
25 122 (10.73%) Tableau
26 120 (10.55%) Informatica
26 120 (10.55%) ETL Development
27 118 (10.38%) Banking
28 117 (10.29%) Visualisation

ETL
Co-occurring IT Skills in London 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 145 (12.75%) Apache Spark
2 53 (4.66%) SAS
3 47 (4.13%) Apache
4 31 (2.73%) Apache Pig
5 25 (2.20%) Tomcat
6 24 (2.11%) SharePoint
7 17 (1.50%) Apache Airflow
8 9 (0.79%) Apache Solr
8 9 (0.79%) Elasticsearch
8 9 (0.79%) JBoss
9 6 (0.53%) WebSphere
10 5 (0.44%) BizTalk Server
10 5 (0.44%) Confluence
10 5 (0.44%) GemFire
10 5 (0.44%) IIS
10 5 (0.44%) Oracle Coherence
11 4 (0.35%) nginx
11 4 (0.35%) Oracle SOA Suite
11 4 (0.35%) WebLogic
11 4 (0.35%) WildFly
Applications
1 67 (5.89%) Microsoft Excel
2 21 (1.85%) Microsoft Office
3 16 (1.41%) MS Visio
4 8 (0.70%) Microsoft PowerPoint
5 6 (0.53%) SPSS
6 4 (0.35%) Microsoft Project
7 1 (0.088%) Mingle
7 1 (0.088%) Spreadsheet
Business Applications
1 34 (2.99%) Markit EDM
2 15 (1.32%) Dynamics CRM
3 12 (1.06%) Dynamics AX
4 11 (0.97%) Unit4 Business World
5 7 (0.62%) Cognos TM1
6 5 (0.44%) Dynamics NAV
6 5 (0.44%) Salesforce.com CRM
7 4 (0.35%) Hyperion Planning
8 3 (0.26%) Cognos Business Intelligence
8 3 (0.26%) NetSuite
8 3 (0.26%) Oracle Payables
8 3 (0.26%) Oracle Receivables
8 3 (0.26%) PeopleSoft HCM
9 2 (0.18%) Dynamics GP
9 2 (0.18%) Summit
10 1 (0.088%) Bloomberg AIM
10 1 (0.088%) Oracle Procure-to-Pay
10 1 (0.088%) SAP MDG
10 1 (0.088%) SunGard APT
10 1 (0.088%) thinkFolio
Cloud Services
1 136 (11.96%) Amazon AWS
2 110 (9.67%) Microsoft Azure
3 37 (3.25%) Amazon S3
3 37 (3.25%) Google Cloud Platform
4 29 (2.55%) GitHub
5 21 (1.85%) Amazon EMR
6 19 (1.67%) Cloud Computing
7 18 (1.58%) Salesforce Service Cloud
8 17 (1.50%) SaaS
9 15 (1.32%) Force.com
10 14 (1.23%) Amazon Kinesis
10 14 (1.23%) Salesforce Sales Cloud
11 12 (1.06%) Amazon EC2
11 12 (1.06%) Serverless
12 10 (0.88%) AWS Lambda
12 10 (0.88%) Office 365
13 9 (0.79%) Azure Data Factory
14 8 (0.70%) PaaS
15 6 (0.53%) Boomi
16 5 (0.44%) iPaaS
Communications & Networking
1 9 (0.79%) Internet
1 9 (0.79%) Kerberos
2 4 (0.35%) Firewall
2 4 (0.35%) SAN
3 3 (0.26%) FTP
3 3 (0.26%) Intranet
3 3 (0.26%) Skype
4 1 (0.088%) Network Security
4 1 (0.088%) SMS
4 1 (0.088%) SSL
Database & Business Intelligence
1 504 (44.33%) Data Warehouse
2 403 (35.44%) SQL Server
3 333 (29.29%) SQL Server Integration Services
4 243 (21.37%) Big Data
5 199 (17.50%) SQL Server Reporting Services
6 188 (16.53%) Hadoop
7 160 (14.07%) SQL Server Analysis Services
8 116 (10.20%) Relational Database
9 94 (8.27%) Apache Hive
10 93 (8.18%) Power BI
11 85 (7.48%) BusinessObjects
12 79 (6.95%) NoSQL
13 67 (5.89%) HBase
14 65 (5.72%) QlikView
15 60 (5.28%) Amazon Redshift
15 60 (5.28%) Data Lake
16 58 (5.10%) DataStage
17 57 (5.01%) OLAP
18 50 (4.40%) PostgreSQL
19 45 (3.96%) SQL Server 2008
Development Applications
1 39 (3.43%) Git (software)
1 39 (3.43%) JIRA
2 35 (3.08%) Team Foundation Server
2 35 (3.08%) Visual Studio
3 27 (2.37%) Eclipse
4 23 (2.02%) ERwin
4 23 (2.02%) Jenkins
5 20 (1.76%) Ant
5 20 (1.76%) Maven
6 19 (1.67%) Subversion
7 16 (1.41%) Selenium
8 13 (1.14%) TeamCity
9 12 (1.06%) SoapUI
10 9 (0.79%) GitLab
10 9 (0.79%) JUnit
11 6 (0.53%) Cucumber
11 6 (0.53%) HP UFT
11 6 (0.53%) PowerDesigner
11 6 (0.53%) Toad
11 6 (0.53%) WebDriver
General
1 273 (24.01%) Finance
2 118 (10.38%) Banking
3 52 (4.57%) Retail
4 44 (3.87%) Marketing
5 28 (2.46%) Legal
6 27 (2.37%) Investment Banking
7 22 (1.93%) Telecoms
8 21 (1.85%) Manufacturing
9 16 (1.41%) Front Office
10 15 (1.32%) Electronics
11 13 (1.14%) Games
12 11 (0.97%) Pharmaceutical
13 7 (0.62%) Retail Banking
14 6 (0.53%) Advertising
14 6 (0.53%) Publishing
15 5 (0.44%) Financial Institution
15 5 (0.44%) Law
16 4 (0.35%) French Language
17 3 (0.26%) Local Government
18 2 (0.18%) Back Office
Job Titles
1 518 (45.56%) Developer
2 172 (15.13%) Analyst
3 161 (14.16%) SQL Developer
4 146 (12.84%) Business Intelligence Developer
5 142 (12.49%) Data Engineer
6 111 (9.76%) Architect
7 109 (9.59%) ETL Developer
8 71 (6.24%) Data Analyst
9 69 (6.07%) SSIS Developer
10 63 (5.54%) Data Architect
11 57 (5.01%) Business Intelligence Analyst
12 55 (4.84%) Consultant
13 47 (4.13%) Big Data Engineer
13 47 (4.13%) SQL BI Developer
14 46 (4.05%) Business Developer
15 41 (3.61%) Senior Developer
16 39 (3.43%) Analyst Developer
17 38 (3.34%) SQL Analyst
18 37 (3.25%) SSRS Developer
19 35 (3.08%) Solutions Architect
Libraries, Frameworks & Software Standards
1 85 (7.48%) .NET
2 82 (7.21%) Kafka
3 74 (6.51%) XML
4 61 (5.36%) MDX
5 54 (4.75%) Web Services
6 47 (4.13%) REST
7 45 (3.96%) JSON
8 36 (3.17%) JMS
9 34 (2.99%) Spring
10 19 (1.67%) Natural Language Processing
11 17 (1.50%) AngularJS
11 17 (1.50%) HTML
11 17 (1.50%) SOAP
12 16 (1.41%) Node.js
13 15 (1.32%) Hibernate
13 15 (1.32%) Spring Boot
14 14 (1.23%) ASP.NET
14 14 (1.23%) CSS
14 14 (1.23%) Spark Streaming
15 13 (1.14%) JDBC
Miscellaneous
1 138 (12.14%) Analytical Skills
2 41 (3.61%) Data Structures
3 37 (3.25%) Computer Science
4 34 (2.99%) Greenfield Project
5 31 (2.73%) Market Risk
6 21 (1.85%) Management Information System
7 20 (1.76%) Replication
7 20 (1.76%) User Experience
8 17 (1.50%) Data Centre
9 16 (1.41%) Credit Risk
10 14 (1.23%) Fintech
11 10 (0.88%) Algorithms
11 10 (0.88%) Derivative
11 10 (0.88%) Reference Data
11 10 (0.88%) Reinsurance
12 9 (0.79%) NHS
13 8 (0.70%) Clustering
14 7 (0.62%) Blog
14 7 (0.62%) Foreign Exchange (FX)
15 6 (0.53%) FMCG
Operating Systems
1 88 (7.74%) Linux
2 52 (4.57%) Unix
3 36 (3.17%) Windows
4 15 (1.32%) Red Hat Enterprise Linux
5 10 (0.88%) CentOS
6 7 (0.62%) Windows Server
7 5 (0.44%) Windows Server 2008
8 4 (0.35%) HPUX
8 4 (0.35%) Solaris
9 3 (0.26%) Windows Server 2003
10 2 (0.18%) Windows 10
10 2 (0.18%) Windows 7
11 1 (0.088%) AIX
11 1 (0.088%) Ubuntu
11 1 (0.088%) Windows Server 2012
Processes & Methodologies
1 460 (40.46%) Business Intelligence
2 326 (28.67%) Agile Software Development
3 284 (24.98%) Data Modelling
4 251 (22.08%) Analytics
5 175 (15.39%) Migration
6 140 (12.31%) Data Migration
7 128 (11.26%) Data Analysis
8 120 (10.55%) ETL Development
9 117 (10.29%) Visualisation
10 108 (9.50%) Scrum
11 97 (8.53%) Data Management
12 92 (8.09%) Data Integration
13 80 (7.04%) Kimball Methodology
13 80 (7.04%) Performance Tuning
14 77 (6.77%) Data Analytics
15 63 (5.54%) CRM
16 61 (5.36%) Data Architecture
17 56 (4.93%) Test Automation
18 54 (4.75%) Continuous Integration
18 54 (4.75%) Dimensional Modelling
Programming Languages
1 731 (64.29%) SQL
2 179 (15.74%) Java
3 178 (15.66%) Python
4 173 (15.22%) T-SQL
5 82 (7.21%) C#
6 67 (5.89%) Scala
7 65 (5.72%) PL/SQL
8 64 (5.63%) JavaScript
9 60 (5.28%) R
10 30 (2.64%) Bash Shell
11 27 (2.37%) Shell Script
12 25 (2.20%) Apex Code
13 24 (2.11%) PowerShell
14 23 (2.02%) Data Analysis Expressions (DAX)
15 16 (1.41%) VBA
16 14 (1.23%) VB
17 13 (1.14%) Perl
17 13 (1.14%) SAS Macro
17 13 (1.14%) VBScript
18 12 (1.06%) SOQL
Qualifications
1 61 (5.36%) Degree
2 55 (4.84%) Security Cleared
3 23 (2.02%) SC Cleared
4 17 (1.50%) DV Cleared
5 14 (1.23%) Computer Science Degree
6 7 (0.62%) Numerate Degree
6 7 (0.62%) PhD
7 6 (0.53%) ISEB
7 6 (0.53%) PMI Certification
8 5 (0.44%) CTC Cleared
8 5 (0.44%) PMP
9 4 (0.35%) BPSS Clearance
9 4 (0.35%) Master's Degree
9 4 (0.35%) Microsoft Certification
10 3 (0.26%) MCSE
10 3 (0.26%) Oracle Certification
11 2 (0.18%) ISTQB
11 2 (0.18%) ISTQB Foundation Certification
12 1 (0.088%) AWS Certification
12 1 (0.088%) MCSA
Quality Assurance & Compliance
1 126 (11.08%) Data Quality
2 73 (6.42%) QA
3 19 (1.67%) GDPR
4 14 (1.23%) MiFID
5 9 (0.79%) EMIR
6 7 (0.62%) SLA
7 6 (0.53%) Dodd-Frank
8 5 (0.44%) Disclosure Scotland
8 5 (0.44%) GCP
9 4 (0.35%) Actionable Recommendations
9 4 (0.35%) IFRS
9 4 (0.35%) IFRS 9
10 2 (0.18%) AIFMD
10 2 (0.18%) ISO/IEC 27001
10 2 (0.18%) Sarbanes-Oxley
11 1 (0.088%) COBIT
11 1 (0.088%) GAAP
11 1 (0.088%) PCI DSS
System Software
1 44 (3.87%) HDFS
2 22 (1.93%) Apache Flume
2 22 (1.93%) Docker
3 4 (0.35%) Oracle RAC
4 2 (0.18%) Virtual Machines
5 1 (0.088%) Active Directory
5 1 (0.088%) Apache ZooKeeper
5 1 (0.088%) Hyper-V
5 1 (0.088%) Oracle Clusterware
5 1 (0.088%) Veritas Cluster Server
5 1 (0.088%) VMware ESXi
Systems Management
1 25 (2.20%) Hadoop YARN
2 22 (1.93%) Oozie
3 19 (1.67%) Control-M
4 14 (1.23%) Ansible
5 7 (0.62%) Opscode Chef
5 7 (0.62%) Puppet
5 7 (0.62%) Salt
6 4 (0.35%) Data Guard
7 3 (0.26%) HP Quality Center
7 3 (0.26%) Rundeck
7 3 (0.26%) Tivoli
8 2 (0.18%) Kibana
8 2 (0.18%) Kubernetes
8 2 (0.18%) logstash
8 2 (0.18%) Nagios
8 2 (0.18%) WMI
9 1 (0.088%) Cacti
9 1 (0.088%) Graphite
9 1 (0.088%) Oracle Flashback
9 1 (0.088%) Oracle RMAN
Vendors
1 222 (19.53%) Microsoft
1 222 (19.53%) Oracle
2 122 (10.73%) Tableau
3 120 (10.55%) Informatica
4 68 (5.98%) Salesforce.com
5 62 (5.45%) SAP
6 51 (4.49%) IBM
7 37 (3.25%) Cloudera
8 32 (2.81%) MicroStrategy
9 31 (2.73%) Teradata
10 30 (2.64%) Talend
11 29 (2.55%) Cognos
12 25 (2.20%) Google
13 21 (1.85%) Ab Initio
13 21 (1.85%) Hortonworks
14 20 (1.76%) Netezza
15 18 (1.58%) MapR
16 16 (1.41%) Alteryx
17 11 (0.97%) Greenplum
17 11 (0.97%) TIBCO