Period
to 16 November 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 16 November 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
16 Nov 2018
Same period 2017 Same period 2016
Rank 91 76 51
Rank change year-on-year -15 -25 -8
Contract jobs citing ETL 143 139 245
As % of all contract IT jobs advertised in the North West 2.41% 2.42% 3.52%
As % of the Processes & Methodologies category 2.90% 2.95% 4.15%
Number of daily rates quoted 100 105 174
North West median daily rate £375 £400 £400
Median daily rate % change year-on-year -6.25% - -5.88%
10th Percentile £300 £313 £300
90th Percentile £531 £587 £546
England median daily rate £450 £450 £425
% change year-on-year +0.06% +5.88% -
Number of hourly rates quoted 3 7 1
North West median hourly rate £24.00 £46.21 £20.50
Median hourly rate % change year-on-year -48.06% +125.41% -37.88%
England median hourly rate £28.50 £46.21 £44.00
% change year-on-year -38.33% +5.02% +60.00%

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,933 4,714 5,906
As % of all contract IT jobs advertised in the North West 83.01% 82.24% 84.95%
Number of daily rates quoted 3,128 3,010 3,787
North West median daily rate £405 £400 £400
Median daily rate % change year-on-year +1.25% - -
10th Percentile £263 £263 £260
90th Percentile £575 £585 £556
England median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +1.19%
Number of hourly rates quoted 282 203 178
North West median hourly rate £21.76 £27.00 £22.00
Median hourly rate % change year-on-year -19.41% +22.73% -27.92%
10th Percentile £11.41 £11.75 £11.43
90th Percentile £51.23 £51.12 £53.00
England median hourly rate £22.00 £23.50 £22.84
% change year-on-year -6.38% +2.91% +3.80%

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 16 November 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
Contractor Hourly Rate Histogram in the North West

The hourly rate distribution of IT jobs citing ETL in the North West over the 6 months to 16 November 2018.

Contractor hourly rate histogram 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 16 November 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 -29 59 £400 - 17
Merseyside +28 36 £369 -14.74% 6
Cheshire +9 32 £344 -1.79% 16
Cumbria +1 7 £450 -
Lancashire -23 7 £325 -7.14% 7
ETL
England

For the 6 months to 16 November 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 113 (79.02%) SQL
2 62 (43.36%) Business Intelligence
3 58 (40.56%) SQL Server
4 55 (38.46%) Data Warehouse
5 49 (34.27%) SQL Server Integration Services
6 38 (26.57%) Microsoft
7 33 (23.08%) Oracle
8 32 (22.38%) SQL Server Reporting Services
8 32 (22.38%) Power BI
9 30 (20.98%) T-SQL
10 28 (19.58%) Microsoft Azure
11 27 (18.88%) Relational Database
12 26 (18.18%) Data Analysis
13 25 (17.48%) Data Modelling
14 24 (16.78%) SAP
14 24 (16.78%) Big Data
15 21 (14.69%) Finance
16 20 (13.99%) Migration
17 19 (13.29%) BusinessObjects
18 18 (12.59%) Analytics
19 17 (11.89%) Data Architecture
20 16 (11.19%) Security Cleared
21 14 (9.79%) Talend
21 14 (9.79%) Tableau
22 13 (9.09%) SQL Server Analysis Services
22 13 (9.09%) Dynamics 365
23 12 (8.39%) Analytical Skills
23 12 (8.39%) Apache Spark
23 12 (8.39%) Dimensional Modelling
23 12 (8.39%) Data Migration

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 12 (8.39%) Apache Spark
2 6 (4.20%) ArcGIS
2 6 (4.20%) SAS
3 2 (1.40%) Elasticsearch
4 1 (0.70%) Oracle Workflow
4 1 (0.70%) SharePoint
Applications
1 9 (6.29%) Microsoft Office
2 3 (2.10%) Microsoft Excel
3 1 (0.70%) MS Visio
Business Applications
1 8 (5.59%) Dynamics CRM
2 1 (0.70%) Cognos Business Intelligence
2 1 (0.70%) Cognos TM1
2 1 (0.70%) Dynamics AX
2 1 (0.70%) iTrent
Cloud Services
1 28 (19.58%) Microsoft Azure
2 13 (9.09%) Dynamics 365
3 7 (4.90%) Office 365
4 6 (4.20%) Amazon AWS
5 4 (2.80%) GitHub
6 1 (0.70%) Boomi
6 1 (0.70%) Cloud Computing
6 1 (0.70%) Slack
6 1 (0.70%) Trello
Communications & Networking
1 4 (2.80%) SMS
Database & Business Intelligence
1 58 (40.56%) SQL Server
2 55 (38.46%) Data Warehouse
3 49 (34.27%) SQL Server Integration Services
4 32 (22.38%) Power BI
4 32 (22.38%) SQL Server Reporting Services
5 27 (18.88%) Relational Database
6 24 (16.78%) Big Data
7 19 (13.29%) BusinessObjects
8 13 (9.09%) SQL Server Analysis Services
9 11 (7.69%) Apache Hive
9 11 (7.69%) SQL Server 2016
10 10 (6.99%) Hadoop
10 10 (6.99%) QlikView
11 9 (6.29%) Azure SQL Database
11 9 (6.29%) DB2
12 8 (5.59%) MySQL
12 8 (5.59%) SAP Data Services
13 7 (4.90%) Oracle Database
13 7 (4.90%) Oracle Discoverer
13 7 (4.90%) Oracle OWB
Development Applications
1 3 (2.10%) Oracle Forms
1 3 (2.10%) Team Foundation Server
2 2 (1.40%) Git (software)
2 2 (1.40%) GitLab
2 2 (1.40%) SQL Server Management Studio (SSMS)
3 1 (0.70%) Cucumber
3 1 (0.70%) HP UFT
3 1 (0.70%) LSMW
3 1 (0.70%) Selenium
General
1 21 (14.69%) Finance
2 7 (4.90%) Banking
3 5 (3.50%) Retail
4 3 (2.10%) Marketing
5 2 (1.40%) Pharmaceutical
6 1 (0.70%) Electronics
6 1 (0.70%) Legal
6 1 (0.70%) Manufacturing
6 1 (0.70%) Telecoms
Job Titles
1 90 (62.94%) Developer
2 37 (25.87%) Business Intelligence Developer
3 29 (20.28%) SQL Developer
4 20 (13.99%) Data Engineer
5 14 (9.79%) Analyst
5 14 (9.79%) ETL Developer
6 10 (6.99%) Data Analyst
6 10 (6.99%) SQL BI Developer
7 7 (4.90%) SAP BusinessObjects (BO) Developer
8 6 (4.20%) Power BI Developer
8 6 (4.20%) SAP Developer
8 6 (4.20%) SSIS Developer
8 6 (4.20%) SSRS Developer
9 5 (3.50%) AWS Engineer
9 5 (3.50%) Big Data Engineer
9 5 (3.50%) Consultant
9 5 (3.50%) Data Warehouse Developer
10 4 (2.80%) GIS Developer
10 4 (2.80%) Oracle Developer
10 4 (2.80%) SQL DBA
Libraries, Frameworks & Software Standards
1 11 (7.69%) XML
2 7 (4.90%) Lucene
3 6 (4.20%) .NET
4 5 (3.50%) ASP.NET
5 4 (2.80%) Apache Avro
5 4 (2.80%) HTML
5 4 (2.80%) HTML5
5 4 (2.80%) OpenLayers
6 3 (2.10%) Leaflet
6 3 (2.10%) MDX
7 2 (1.40%) J2EE
7 2 (1.40%) Kafka
7 2 (1.40%) Pandas
7 2 (1.40%) PostGIS
7 2 (1.40%) scikit-learn
8 1 (0.70%) ASP.NET Web API
8 1 (0.70%) COM
8 1 (0.70%) Middleware
8 1 (0.70%) Web Services
8 1 (0.70%) XGBoost
Miscellaneous
1 12 (8.39%) Analytical Skills
2 7 (4.90%) Data Structures
3 4 (2.80%) Enterprise Software
3 4 (2.80%) Mobile App
3 4 (2.80%) Taxonomies
4 3 (2.10%) Greenfield Project
4 3 (2.10%) NHS
5 2 (1.40%) Driving Licence
6 1 (0.70%) Computer Science
6 1 (0.70%) Management Information System
6 1 (0.70%) Reference Data
6 1 (0.70%) Replication
Operating Systems
1 7 (4.90%) Unix
2 5 (3.50%) Windows
3 4 (2.80%) Windows Server
4 3 (2.10%) Linux
5 1 (0.70%) Windows 7
Processes & Methodologies
1 62 (43.36%) Business Intelligence
2 26 (18.18%) Data Analysis
3 25 (17.48%) Data Modelling
4 20 (13.99%) Migration
5 18 (12.59%) Analytics
6 17 (11.89%) Data Architecture
7 12 (8.39%) Data Migration
7 12 (8.39%) Data Visualisation
7 12 (8.39%) Dimensional Modelling
7 12 (8.39%) Visualisation
8 11 (7.69%) Agile Software Development
8 11 (7.69%) ETL Development
9 10 (6.99%) Problem-Solving
10 9 (6.29%) Kimball Methodology
10 9 (6.29%) Stakeholder Management
11 8 (5.59%) CRM
11 8 (5.59%) Dashboard Development
12 7 (4.90%) API Development
12 7 (4.90%) Data Analytics
13 6 (4.20%) Master Data Management
Programming Languages
1 113 (79.02%) SQL
2 30 (20.98%) T-SQL
3 12 (8.39%) JavaScript
4 10 (6.99%) Python
5 9 (6.29%) C#
6 7 (4.90%) Java
6 7 (4.90%) PL/SQL
7 4 (2.80%) Perl
8 3 (2.10%) Go
8 3 (2.10%) PHP
9 2 (1.40%) Scala
9 2 (1.40%) VBA
10 1 (0.70%) Bash Shell
10 1 (0.70%) Data Analysis Expressions (DAX)
10 1 (0.70%) PowerShell
10 1 (0.70%) Shell Script
Qualifications
1 16 (11.19%) Security Cleared
2 10 (6.99%) SC Cleared
3 8 (5.59%) Degree
4 4 (2.80%) Postgraduate
5 1 (0.70%) ISEB
5 1 (0.70%) ISTQB
5 1 (0.70%) Master's Degree
5 1 (0.70%) PhD
Quality Assurance & Compliance
1 8 (5.59%) Data Quality
2 2 (1.40%) PMO
3 1 (0.70%) GDPR
System Software
1 4 (2.80%) HDFS
2 2 (1.40%) Docker
Systems Management
1 4 (2.80%) Oozie
2 2 (1.40%) Kibana
3 1 (0.70%) Systems Management Server (SMS)
Vendors
1 38 (26.57%) Microsoft
2 33 (23.08%) Oracle
3 24 (16.78%) SAP
4 14 (9.79%) Tableau
4 14 (9.79%) Talend
5 7 (4.90%) Cloudera
6 6 (4.20%) ESRI
7 5 (3.50%) Hyperion
8 4 (2.80%) Mapbox
9 3 (2.10%) Cognos
9 3 (2.10%) Google
9 3 (2.10%) Saba
10 2 (1.40%) Hortonworks
10 2 (1.40%) Informatica
10 2 (1.40%) MapR
10 2 (1.40%) Teradata
10 2 (1.40%) Vertica
11 1 (0.70%) Ab Initio
11 1 (0.70%) Dell
11 1 (0.70%) IBM