Period
to 20 November 2019

The following table provides summary statistics for contract job vacancies advertised in the North West with a requirement for Data Warehouse skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Data Warehouse over the 6 months to 20 November 2019 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.

Data Warehousing
England > North West
6 months to
20 Nov 2019
Same period 2018 Same period 2017
Rank 79 99 73
Rank change year-on-year +20 -26 +8
Contract jobs citing Data Warehouse 140 130 158
As % of all contract IT jobs advertised in the North West 2.59% 2.18% 2.77%
As % of the Database & Business Intelligence category 11.55% 10.45% 12.27%
Number of daily rates quoted 100 97 118
North West median daily rate £405 £400 £444
Median daily rate % change year-on-year +1.25% -9.86% +14.52%
10th Percentile £263 £306 £313
90th Percentile £600 £600 £615
England median daily rate £475 £450 £450
% change year-on-year +5.56% - +2.86%
Number of hourly rates quoted 0 2 6
North West median hourly rate - £18.50 £39.25
Median hourly rate % change year-on-year - -52.87% +91.46%
England median hourly rate £31.29 £18.50 £27.50
% change year-on-year +69.14% -32.73% -34.52%

Data Warehouse is in the Databases and Business Intelligence 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 database or business intelligence skills.

All Database and Business Intelligence Skills
North West
Contract vacancies with a requirement for database or business intelligence skills 1,212 1,244 1,288
As % of all contract IT jobs advertised in the North West 22.42% 20.82% 22.61%
Number of daily rates quoted 858 836 880
North West median daily rate £438 £400 £400
Median daily rate % change year-on-year +9.38% - +6.67%
10th Percentile £300 £285 £284
90th Percentile £575 £556 £622
England median daily rate £475 £475 £460
% change year-on-year - +3.26% +8.24%
Number of hourly rates quoted 22 24 34
North West median hourly rate £30.00 £29.50 £42.75
Median hourly rate % change year-on-year +1.69% -30.99% +19.58%
10th Percentile £12.88 £11.55 £21.30
90th Percentile £53.75 £47.50 £61.13
England median hourly rate £32.58 £35.00 £31.50
% change year-on-year -6.91% +11.11% +12.50%

Data Warehouse
Job Vacancy Trend in the North West

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

Job vacancy trend for Data Warehouse in the North West

Data Warehouse
Contractor Daily Rate Trend in the North West

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

Contractor daily rate trend for Data Warehouse in the North West

Data Warehouse
Contractor Daily Rate Histogram in the North West

The daily rate distribution of IT jobs citing Data Warehouse in the North West over the 6 months to 20 November 2019.

Contractor daily rate histogram for Data Warehouse in the North West

Data Warehouse
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 Data Warehouse in the North West.

Contractor hourly rate trend for Data Warehouse in the North West

Data Warehouse
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 Data Warehouse within the North West region over the 6 months to 20 November 2019. 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 +27 73 £388 -3.13% 42
Cheshire +3 15 £375 -6.25% 15
Lancashire +15 14 £425 -8.11% 1
Merseyside -22 12 £363 -3.33%
Cumbria -9 7 £600 -
Data Warehouse
England

For the 6 months to 20 November 2019, IT contractor jobs citing Data Warehouse 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 Data Warehouse.

1 81 (57.86%) SQL
1 81 (57.86%) Business Intelligence
2 52 (37.14%) ETL
3 43 (30.71%) SQL Server
4 39 (27.86%) Power BI
4 39 (27.86%) Power Platform
5 33 (23.57%) SQL Server Integration Services
5 33 (23.57%) Azure
6 30 (21.43%) Data Modelling
7 27 (19.29%) SQL Server Reporting Services
7 27 (19.29%) Visualisation
8 26 (18.57%) Python
8 26 (18.57%) Microsoft
9 25 (17.86%) Oracle
9 25 (17.86%) Big Data
10 23 (16.43%) Agile Software Development
11 22 (15.71%) Migration
12 20 (14.29%) Tableau
12 20 (14.29%) Data Migration
13 19 (13.57%) T-SQL
14 17 (12.14%) Data Lake
15 16 (11.43%) Hadoop
15 16 (11.43%) Analytics
16 15 (10.71%) Azure Data Factory
16 15 (10.71%) Apache Spark
17 13 (9.29%) Data Engineering
17 13 (9.29%) Azure SQL Data Warehouse
17 13 (9.29%) Databricks
17 13 (9.29%) Data Quality
17 13 (9.29%) AWS

Data Warehouse
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 15 (10.71%) Apache Spark
2 10 (7.14%) Apache
3 8 (5.71%) Elasticsearch
4 6 (4.29%) Confluence
4 6 (4.29%) SAS
5 3 (2.14%) SharePoint
6 1 (0.71%) Skype for Business
Applications
1 6 (4.29%) Microsoft Excel
2 2 (1.43%) MS Visio
3 1 (0.71%) Stata
Business Applications
1 4 (2.86%) Dynamics NAV
2 2 (1.43%) Dynamics AX
2 2 (1.43%) Dynamics CRM
3 1 (0.71%) SAP ERP
3 1 (0.71%) SAP S/4HANA
Cloud Services
1 39 (27.86%) Power Platform
2 33 (23.57%) Azure
3 15 (10.71%) Azure Data Factory
4 13 (9.29%) AWS
5 3 (2.14%) Cloud Computing
5 3 (2.14%) GCP
6 2 (1.43%) Azure Functions
6 2 (1.43%) Dynamics 365
6 2 (1.43%) GitHub
6 2 (1.43%) Serverless
Communications & Networking
1 1 (0.71%) Firewall
1 1 (0.71%) FTP
1 1 (0.71%) HTTPS
1 1 (0.71%) Skype
1 1 (0.71%) VPN
Database & Business Intelligence
1 43 (30.71%) SQL Server
2 39 (27.86%) Power BI
3 33 (23.57%) SQL Server Integration Services
4 27 (19.29%) SQL Server Reporting Services
5 25 (17.86%) Big Data
6 17 (12.14%) Data Lake
7 16 (11.43%) Hadoop
8 13 (9.29%) Azure SQL Data Warehouse
8 13 (9.29%) SQL Server Analysis Services
9 12 (8.57%) Azure SQL Database
10 10 (7.14%) Relational Database
11 9 (6.43%) Amazon Redshift
11 9 (6.43%) BusinessObjects
11 9 (6.43%) MySQL
12 7 (5.00%) Pentaho
13 6 (4.29%) QlikView
14 5 (3.57%) Apache Hive
14 5 (3.57%) Enterprise Data Warehouse
14 5 (3.57%) Oracle Database
14 5 (3.57%) SQL Server 2012
Development Applications
1 9 (6.43%) JIRA
2 6 (4.29%) Visual Studio
3 4 (2.86%) ERwin
3 4 (2.86%) Git (software)
4 2 (1.43%) Jenkins
4 2 (1.43%) SQL Server Management Studio (SSMS)
5 1 (0.71%) Eclipse
5 1 (0.71%) ER Studio
5 1 (0.71%) GitLab
5 1 (0.71%) Sonatype Nexus
General
1 11 (7.86%) Public Sector
2 10 (7.14%) Finance
2 10 (7.14%) Retail
3 4 (2.86%) Legal
4 2 (1.43%) Banking
4 2 (1.43%) Local Government
5 1 (0.71%) Advertising
5 1 (0.71%) Back Office
5 1 (0.71%) Marketing
5 1 (0.71%) Publishing
5 1 (0.71%) Social Housing
Job Titles
1 51 (36.43%) Developer
2 26 (18.57%) Business Intelligence Developer
3 22 (15.71%) SQL Developer
4 17 (12.14%) Consultant
5 16 (11.43%) Data Engineer
6 13 (9.29%) Analyst
6 13 (9.29%) Architect
7 11 (7.86%) SQL BI Developer
8 9 (6.43%) Data Analyst
8 9 (6.43%) Data Architect
8 9 (6.43%) Data Consultant
8 9 (6.43%) ETL Developer
9 8 (5.71%) Project Manager
10 5 (3.57%) Data Migration Developer
11 4 (2.86%) Azure Engineer
11 4 (2.86%) Business Intelligence Consultant
11 4 (2.86%) Data Manager
11 4 (2.86%) Report Developer
11 4 (2.86%) SSRS Developer
11 4 (2.86%) Technical Leader
Libraries, Frameworks & Software Standards
1 7 (5.00%) Kafka
1 7 (5.00%) MDX
1 7 (5.00%) PySpark
1 7 (5.00%) REST
1 7 (5.00%) XML
2 5 (3.57%) JDBC
3 4 (2.86%) JSON
3 4 (2.86%) Web Services
4 3 (2.14%) Apache Avro
5 1 (0.71%) .NET
5 1 (0.71%) Apache Flex
5 1 (0.71%) ASP.NET
5 1 (0.71%) ASP.NET Web Forms
5 1 (0.71%) COM
5 1 (0.71%) ODBC
5 1 (0.71%) OLE
5 1 (0.71%) OLE DB
5 1 (0.71%) SAP Fiori
5 1 (0.71%) Spring
Miscellaneous
1 7 (5.00%) Analytical Skills
2 6 (4.29%) User Experience
3 5 (3.57%) Management Information System
3 5 (3.57%) NHS
4 4 (2.86%) Reference Data
5 2 (1.43%) Data Structures
5 2 (1.43%) PKI
5 2 (1.43%) Replication
5 2 (1.43%) W3C
6 1 (0.71%) Derivative
6 1 (0.71%) Driving Licence
6 1 (0.71%) Fixed Income
6 1 (0.71%) Self-Motivation
Operating Systems
1 2 (1.43%) Windows
1 2 (1.43%) Windows Server
2 1 (0.71%) Unix
2 1 (0.71%) Windows 10
2 1 (0.71%) Windows 7
2 1 (0.71%) Windows Server 2008
2 1 (0.71%) Windows Server 2012
Processes & Methodologies
1 81 (57.86%) Business Intelligence
2 52 (37.14%) ETL
3 30 (21.43%) Data Modelling
4 27 (19.29%) Visualisation
5 23 (16.43%) Agile Software Development
6 22 (15.71%) Migration
7 20 (14.29%) Data Migration
8 16 (11.43%) Analytics
9 13 (9.29%) Data Analysis
9 13 (9.29%) Data Engineering
9 13 (9.29%) Stakeholder Management
10 12 (8.57%) ERP
10 12 (8.57%) Scrum
11 11 (7.86%) Data Strategy
11 11 (7.86%) Kimball Methodology
12 10 (7.14%) Dashboard Development
12 10 (7.14%) Data Integration
13 9 (6.43%) Data Analytics
13 9 (6.43%) ETL Development
14 8 (5.71%) Data Visualisation
Programming Languages
1 81 (57.86%) SQL
2 26 (18.57%) Python
3 19 (13.57%) T-SQL
4 7 (5.00%) Data Analysis Expressions (DAX)
5 6 (4.29%) C#
6 5 (3.57%) Java
7 4 (2.86%) R
8 3 (2.14%) PL/SQL
8 3 (2.14%) Shell Script
9 2 (1.43%) Bash Shell
10 1 (0.71%) ABAP
10 1 (0.71%) ANSI SQL
10 1 (0.71%) Ruby
10 1 (0.71%) Scala
Qualifications
1 13 (9.29%) Security Cleared
2 9 (6.43%) SC Cleared
3 2 (1.43%) PMP
4 1 (0.71%) BPSS Clearance
4 1 (0.71%) Computer Science Degree
4 1 (0.71%) DBS Check
4 1 (0.71%) Degree
4 1 (0.71%) Master's Degree
Quality Assurance & Compliance
1 13 (9.29%) Data Quality
2 5 (3.57%) QA
3 2 (1.43%) GDPR
3 2 (1.43%) PMO
System Software
1 5 (3.57%) Apache Flume
2 3 (2.14%) HDFS
3 2 (1.43%) Tivoli Workload Scheduler
4 1 (0.71%) Active Directory
4 1 (0.71%) Docker
Systems Management
1 2 (1.43%) Tivoli
2 1 (0.71%) Ansible
2 1 (0.71%) Kubernetes
2 1 (0.71%) Packer
2 1 (0.71%) Puppet
2 1 (0.71%) Terraform
Vendors
1 26 (18.57%) Microsoft
2 25 (17.86%) Oracle
3 20 (14.29%) Tableau
4 13 (9.29%) Databricks
4 13 (9.29%) SAP
5 8 (5.71%) Informatica
6 5 (3.57%) Cloudera
6 5 (3.57%) Cognos
7 4 (2.86%) MicroStrategy
7 4 (2.86%) Teradata
8 3 (2.14%) IBM
8 3 (2.14%) Talend
8 3 (2.14%) Workday
9 2 (1.43%) Google
9 2 (1.43%) Intapp
9 2 (1.43%) Liquidlogic
9 2 (1.43%) Salesforce.com
9 2 (1.43%) SnapLogic
10 1 (0.71%) Ab Initio
10 1 (0.71%) Telerik