Period
to 21 February 2018

The following table provides summary statistics for contract job vacancies advertised in the North West 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 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)
England > North West
6 months to
21 Feb 2018
Same period 2017 Same period 2016
Rank 96 68 65
Rank change year-on-year -28 -3 +15
Contract jobs citing ETL 106 177 223
As % of all contract IT jobs advertised in the North West 1.97% 2.99% 2.75%
As % of the Processes & Methodologies category 2.36% 3.54% 3.36%
Number of daily rates quoted 83 110 189
North West median daily rate £413 £400 £425
Median daily rate % change year-on-year +3.13% -5.88% -5.56%
10th Percentile £313 £313 £271
90th Percentile £598 £576 £600
England median daily rate £450 £438 £425
% change year-on-year +2.86% +2.94% -
Number of hourly rates quoted 4 1 0
North West median hourly rate £44.66 £35.00 -
Median hourly rate % change year-on-year +27.59% - -
England median hourly rate £55.00 £40.00 £50.50
% change year-on-year +37.50% -20.79% +33.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 advertised in the North West with a requirement for process or methodology skills.

All Process and Methodology Skills
North West
Contract vacancies with a requirement for process or methodology skills 4,489 4,994 6,637
As % of all contract IT jobs advertised in the North West 83.42% 84.30% 81.86%
Number of daily rates quoted 2,903 3,238 4,057
North West median daily rate £413 £400 £400
Median daily rate % change year-on-year +3.13% - +6.67%
10th Percentile £256 £261 £250
90th Percentile £600 £575 £563
England median daily rate £450 £438 £425
% change year-on-year +2.86% +2.94% +4.42%
Number of hourly rates quoted 224 168 278
North West median hourly rate £23.17 £27.50 £30.15
Median hourly rate % change year-on-year -15.74% -8.79% +48.19%
10th Percentile £11.83 £12.93 £13.00
90th Percentile £56.75 £51.50 £50.80
England median hourly rate £24.09 £25.00 £23.50
% change year-on-year -3.64% +6.38% +16.77%

ETL
Job Vacancy Trend in the North West

Job postings citing ETL as a percentage of all IT jobs advertised in the North West.

Job vacancy trend for ETL in the North West

ETL
Contractor Daily Rate Trend in the North West

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

Contractor daily rate trend for ETL in the North West

ETL
Contractor Daily Rate Histogram in the North West

The daily rate distribution of IT jobs citing ETL in the North West over the 6 months to 21 February 2018.

Contractor daily rate histogram for ETL in the North West

ETL
Contractor Hourly Rate Trend in the North West

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

Contractor hourly rate trend for ETL in the North West

ETL
Contract Job Locations in the North West

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing ETL within the North West region over the 6 months to 21 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
Manchester +17 69 £428 - 16
Cheshire -49 15 £338 -15.63% 17
Merseyside +3 10 £475 +31.03% 9
Lancashire +4 5 £400 +23.08% 7
Cumbria -1 4 - -
ETL
England

For the 6 months to 21 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 across the North West region with a requirement for ETL.

1 63 (59.43%) Business Intelligence
2 59 (55.66%) SQL
3 44 (41.51%) Data Warehouse
4 35 (33.02%) SQL Server Integration Services
5 30 (28.30%) SQL Server Reporting Services
6 28 (26.42%) Microsoft
7 27 (25.47%) Data Modelling
8 25 (23.58%) Agile Software Development
9 24 (22.64%) Migration
10 23 (21.70%) SQL Server
10 23 (21.70%) Big Data
11 20 (18.87%) Data Architecture
12 19 (17.92%) Finance
13 17 (16.04%) Data Quality
14 16 (15.09%) Data Migration
15 15 (14.15%) Java
15 15 (14.15%) Hadoop
16 14 (13.21%) SQL Server Analysis Services
17 13 (12.26%) Git (software)
17 13 (12.26%) Linux
17 13 (12.26%) Python
17 13 (12.26%) Apache Spark
17 13 (12.26%) ETL Development
18 12 (11.32%) XML
18 12 (11.32%) Oracle
18 12 (11.32%) OLAP
18 12 (11.32%) Scrum
18 12 (11.32%) Data Management
19 11 (10.38%) Star Schema
20 10 (9.43%) IBM

ETL
Co-occurring IT Skills in the North West 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 13 (12.26%) Apache Spark
2 9 (8.49%) SharePoint
3 8 (7.55%) SAS
4 1 (0.94%) Apache
4 1 (0.94%) Apache Solr
4 1 (0.94%) Confluence
4 1 (0.94%) Elasticsearch
Applications
1 8 (7.55%) Microsoft Office
2 5 (4.72%) Microsoft Excel
3 4 (3.77%) MS Visio
4 2 (1.89%) Adobe Illustrator
Business Applications
1 9 (8.49%) Cognos Business Intelligence
2 1 (0.94%) Aareon QL
2 1 (0.94%) Dynamics NAV
2 1 (0.94%) Oracle EBS
2 1 (0.94%) Oracle EBS R12
2 1 (0.94%) Oracle ERP
2 1 (0.94%) Salesforce.com CRM
Cloud Services
1 10 (9.43%) Microsoft Azure
2 5 (4.72%) Slack
3 4 (3.77%) Trello
4 1 (0.94%) Amazon AWS
4 1 (0.94%) SaaS
Communications & Networking
1 9 (8.49%) Intranet
2 3 (2.83%) HTTP
2 3 (2.83%) SSL
2 3 (2.83%) TCP/IP
Database & Business Intelligence
1 44 (41.51%) Data Warehouse
2 35 (33.02%) SQL Server Integration Services
3 30 (28.30%) SQL Server Reporting Services
4 23 (21.70%) Big Data
4 23 (21.70%) SQL Server
5 15 (14.15%) Hadoop
6 14 (13.21%) SQL Server Analysis Services
7 12 (11.32%) OLAP
8 11 (10.38%) Star Schema
9 9 (8.49%) Relational Database
10 8 (7.55%) MongoDB
10 8 (7.55%) Power BI
10 8 (7.55%) SQL Server 2014
11 7 (6.60%) Apache Hive
11 7 (6.60%) Oracle BI EE
11 7 (6.60%) PostgreSQL
12 6 (5.66%) BusinessObjects
13 4 (3.77%) Data Mining
13 4 (3.77%) OLTP
13 4 (3.77%) RDBMS
Development Applications
1 13 (12.26%) Git (software)
2 8 (7.55%) JIRA
3 7 (6.60%) TeamCity
4 4 (3.77%) Subversion
4 4 (3.77%) Visual Studio
5 3 (2.83%) Mercurial
5 3 (2.83%) Team Foundation Server
5 3 (2.83%) Toad
6 2 (1.89%) Babel
6 2 (1.89%) gulp
6 2 (1.89%) Mocha
6 2 (1.89%) webpack
7 1 (0.94%) Burp Suite
7 1 (0.94%) Cucumber
7 1 (0.94%) HP UFT
7 1 (0.94%) Jenkins
7 1 (0.94%) LoadRunner
7 1 (0.94%) Selenium
7 1 (0.94%) SQL Server Management Studio (SSMS)
7 1 (0.94%) YouTrack
General
1 19 (17.92%) Finance
2 10 (9.43%) Retail
3 7 (6.60%) Manufacturing
4 5 (4.72%) Electronics
4 5 (4.72%) Marketing
4 5 (4.72%) Telecoms
5 4 (3.77%) Banking
6 3 (2.83%) Advertising
7 2 (1.89%) Games
7 2 (1.89%) Law
7 2 (1.89%) Legal
8 1 (0.94%) Pharmaceutical
Job Titles
1 54 (50.94%) Developer
2 19 (17.92%) Business Intelligence Developer
3 17 (16.04%) Architect
4 16 (15.09%) SQL Developer
5 11 (10.38%) Analyst
5 11 (10.38%) Data Architect
6 10 (9.43%) Cognos Developer
7 9 (8.49%) Data Warehouse Developer
8 8 (7.55%) Data Engineer
8 8 (7.55%) ETL Developer
9 7 (6.60%) Cognos BI Developer
10 6 (5.66%) Scala Developer
11 5 (4.72%) Consultant
11 5 (4.72%) Data Analyst
11 5 (4.72%) Information Architect
11 5 (4.72%) Software Developer
11 5 (4.72%) Solutions Architect
11 5 (4.72%) SSIS Developer
12 4 (3.77%) Migration Consultant
12 4 (3.77%) Oracle Developer
Libraries, Frameworks & Software Standards
1 12 (11.32%) XML
2 6 (5.66%) JSON
3 5 (4.72%) PySpark
4 4 (3.77%) Hibernate
4 4 (3.77%) MDX
4 4 (3.77%) XSD
4 4 (3.77%) XSLT
5 3 (2.83%) .NET
5 3 (2.83%) jQuery
5 3 (2.83%) Kafka
5 3 (2.83%) Middleware
6 2 (1.89%) Apache Flex
6 2 (1.89%) CSS
6 2 (1.89%) Jest
6 2 (1.89%) React
6 2 (1.89%) Redux
6 2 (1.89%) Sass
7 1 (0.94%) Akka
7 1 (0.94%) ASP.NET
7 1 (0.94%) SOAP
Miscellaneous
1 10 (9.43%) Analytical Skills
2 7 (6.60%) Management Information System
3 4 (3.77%) Reference Data
3 4 (3.77%) Taxonomies
4 1 (0.94%) Computer Science
4 1 (0.94%) Data Protection Act
4 1 (0.94%) Greenfield Project
4 1 (0.94%) iPad
4 1 (0.94%) Life Science
4 1 (0.94%) Replication
4 1 (0.94%) Social Media
4 1 (0.94%) User Experience
Operating Systems
1 13 (12.26%) Linux
2 4 (3.77%) Red Hat Enterprise Linux
3 2 (1.89%) Unix
3 2 (1.89%) Windows
3 2 (1.89%) Windows 7
Processes & Methodologies
1 63 (59.43%) Business Intelligence
2 27 (25.47%) Data Modelling
3 25 (23.58%) Agile Software Development
4 24 (22.64%) Migration
5 20 (18.87%) Data Architecture
6 16 (15.09%) Data Migration
7 13 (12.26%) ETL Development
8 12 (11.32%) Data Management
8 12 (11.32%) Scrum
9 10 (9.43%) Data Governance
10 9 (8.49%) Kanban
11 8 (7.55%) Analytics
11 8 (7.55%) Data Cleansing
11 8 (7.55%) Kimball Methodology
11 8 (7.55%) Visualisation
12 7 (6.60%) Data Analysis
12 7 (6.60%) Information Architecture
13 6 (5.66%) BDD
13 6 (5.66%) Software Engineering
13 6 (5.66%) TDD
Programming Languages
1 59 (55.66%) SQL
2 15 (14.15%) Java
3 13 (12.26%) Python
4 9 (8.49%) T-SQL
5 8 (7.55%) Shell Script
6 7 (6.60%) PL/SQL
7 6 (5.66%) JavaScript
8 4 (3.77%) Data Analysis Expressions (DAX)
8 4 (3.77%) XPath
9 3 (2.83%) Scala
10 2 (1.89%) C#
10 2 (1.89%) ES6
10 2 (1.89%) R
11 1 (0.94%) VB.NET
Qualifications
1 8 (7.55%) Security Cleared
2 5 (4.72%) SC Cleared
3 1 (0.94%) ISEB
3 1 (0.94%) ISTQB
3 1 (0.94%) PhD
Quality Assurance & Compliance
1 17 (16.04%) Data Quality
2 1 (0.94%) Dodd-Frank
2 1 (0.94%) EMIR
2 1 (0.94%) HL7
2 1 (0.94%) MiFID
2 1 (0.94%) QA
2 1 (0.94%) WCAG
System Software
1 6 (5.66%) Docker
2 1 (0.94%) Apache Flume
2 1 (0.94%) Tivoli Workload Scheduler
2 1 (0.94%) Virtual Machines
Systems Management
1 3 (2.83%) Oozie
2 1 (0.94%) HP Quality Center
2 1 (0.94%) Nessus
2 1 (0.94%) Terraform
2 1 (0.94%) Tivoli
Vendors
1 28 (26.42%) Microsoft
2 12 (11.32%) Oracle
3 10 (9.43%) Cognos
3 10 (9.43%) IBM
4 9 (8.49%) Capita
5 7 (6.60%) SAP
6 5 (4.72%) Tableau
7 4 (3.77%) EnterpriseDB
7 4 (3.77%) Red Hat
8 3 (2.83%) Teradata
9 2 (1.89%) Informatica
9 2 (1.89%) Talend
10 1 (0.94%) Axway
10 1 (0.94%) Cloudera
10 1 (0.94%) Hortonworks
10 1 (0.94%) Intel
10 1 (0.94%) MapR
10 1 (0.94%) MuleSoft
10 1 (0.94%) Remedy
10 1 (0.94%) Salesforce.com