Period
to 19 January 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 19 January 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
19 Jan 2019
Same period 2018 Same period 2017
Rank 95 86 66
Rank change year-on-year -9 -20 -23
Contract jobs citing Data Warehouse 120 126 176
As % of all contract IT jobs advertised in the North West 2.14% 2.31% 2.87%
As % of the Database & Business Intelligence category 9.93% 9.88% 11.57%
Number of daily rates quoted 89 102 120
North West median daily rate £400 £425 £394
Median daily rate % change year-on-year -5.88% +7.94% -1.56%
10th Percentile £306 £313 £319
90th Percentile £693 £615 £650
England median daily rate £450 £450 £438
% change year-on-year - +2.86% +2.94%
Number of hourly rates quoted 7 6 0
North West median hourly rate £20.00 £39.25 -
Median hourly rate % change year-on-year -49.04% - -
England median hourly rate £19.18 £26.80 £41.00
% change year-on-year -28.44% -34.64% +6.49%

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,209 1,275 1,521
As % of all contract IT jobs advertised in the North West 21.55% 23.40% 24.82%
Number of daily rates quoted 810 906 1,046
North West median daily rate £400 £400 £375
Median daily rate % change year-on-year - +6.67% -6.25%
10th Percentile £285 £275 £266
90th Percentile £575 £625 £556
England median daily rate £484 £470 £430
% change year-on-year +2.98% +9.43% +1.06%
Number of hourly rates quoted 30 30 40
North West median hourly rate £35.61 £42.25 £29.01
Median hourly rate % change year-on-year -15.71% +45.63% -23.15%
10th Percentile £16.25 £14.73 £14.26
90th Percentile £47.67 £64.06 £46.03
England median hourly rate £35.00 £31.31 £27.50
% change year-on-year +11.79% +13.85% -8.33%

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

The hourly rate distribution of IT jobs citing Data Warehouse in the North West over the 6 months to 19 January 2019.

Contractor hourly rate histogram 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 19 January 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 -21 42 £400 -3.03% 38
Merseyside +23 33 £375 +15.38% 9
Cheshire -7 26 £450 +20.00% 16
Lancashire -18 16 £650 +6.56% 5
Cumbria - 2 - -
Data Warehouse
England

For the 6 months to 19 January 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 78 (65.00%) SQL
2 61 (50.83%) Business Intelligence
3 46 (38.33%) ETL
4 31 (25.83%) Power BI
5 30 (25.00%) SQL Server
6 29 (24.17%) Data Modelling
7 25 (20.83%) Microsoft
8 23 (19.17%) SQL Server Integration Services
8 23 (19.17%) Big Data
8 23 (19.17%) Analytics
9 20 (16.67%) SQL Server Reporting Services
9 20 (16.67%) Relational Database
10 19 (15.83%) SAP
11 17 (14.17%) T-SQL
11 17 (14.17%) Visualisation
12 16 (13.33%) BusinessObjects
12 16 (13.33%) Data Analysis
13 15 (12.50%) Agile Software Development
13 15 (12.50%) Migration
13 15 (12.50%) Hadoop
13 15 (12.50%) Data Architecture
13 15 (12.50%) Tableau
14 14 (11.67%) Dimensional Modelling
15 13 (10.83%) Finance
16 12 (10.00%) Banking
16 12 (10.00%) Microsoft Excel
16 12 (10.00%) QlikView
17 11 (9.17%) SQL Server Analysis Services
17 11 (9.17%) Microsoft Azure
17 11 (9.17%) Oracle

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 8 (6.67%) SAS
2 6 (5.00%) Apache Spark
3 2 (1.67%) SharePoint
Applications
1 12 (10.00%) Microsoft Excel
2 3 (2.50%) Microsoft Office
3 2 (1.67%) Microsoft Project
4 1 (0.83%) Microsoft PowerPoint
Business Applications
1 2 (1.67%) Teamcenter
2 1 (0.83%) Cognos Business Intelligence
2 1 (0.83%) SAP S/4HANA
Cloud Services
1 11 (9.17%) Microsoft Azure
2 6 (5.00%) Amazon AWS
3 5 (4.17%) Azure Data Factory
4 3 (2.50%) Office 365
4 3 (2.50%) PaaS
5 2 (1.67%) Amazon EC2
5 2 (1.67%) Amazon EMR
5 2 (1.67%) Amazon S3
5 2 (1.67%) Data Lake Analytics
5 2 (1.67%) IaaS
5 2 (1.67%) Trello
6 1 (0.83%) AWS Lambda
6 1 (0.83%) Google Drive
6 1 (0.83%) Salesforce Service Cloud
6 1 (0.83%) Serverless
Communications & Networking
1 2 (1.67%) LAN
1 2 (1.67%) WAN
2 1 (0.83%) Firewall
2 1 (0.83%) Kerberos
2 1 (0.83%) VPN
Database & Business Intelligence
1 31 (25.83%) Power BI
2 30 (25.00%) SQL Server
3 23 (19.17%) Big Data
3 23 (19.17%) SQL Server Integration Services
4 20 (16.67%) Relational Database
4 20 (16.67%) SQL Server Reporting Services
5 16 (13.33%) BusinessObjects
6 15 (12.50%) Hadoop
7 12 (10.00%) QlikView
8 11 (9.17%) Data Lake
8 11 (9.17%) SQL Server Analysis Services
9 9 (7.50%) Apache Hive
10 8 (6.67%) Azure SQL Database
10 8 (6.67%) OLAP
11 7 (5.83%) OLAP Cube
12 6 (5.00%) HBase
12 6 (5.00%) Oracle Database
13 5 (4.17%) Enterprise Data Warehouse
13 5 (4.17%) SQL Server 2008
14 4 (3.33%) Pentaho
Development Applications
1 3 (2.50%) ERwin
1 3 (2.50%) Visual Studio
2 2 (1.67%) JIRA
2 2 (1.67%) Oracle Forms
2 2 (1.67%) RStudio
3 1 (0.83%) ER Studio
3 1 (0.83%) gulp
3 1 (0.83%) Jasmine
3 1 (0.83%) Jenkins
3 1 (0.83%) Karma Test Runner
3 1 (0.83%) Protractor
3 1 (0.83%) Visual Studio Team System
General
1 13 (10.83%) Finance
2 12 (10.00%) Banking
3 3 (2.50%) Publishing
3 3 (2.50%) Retail
4 2 (1.67%) Marketing
5 1 (0.83%) Billing
5 1 (0.83%) Telecoms
Job Titles
1 58 (48.33%) Developer
2 22 (18.33%) Business Intelligence Developer
3 18 (15.00%) SQL Developer
4 17 (14.17%) Architect
5 14 (11.67%) Analyst
6 11 (9.17%) Data Engineer
7 10 (8.33%) Data Architect
8 9 (7.50%) Power BI Developer
9 8 (6.67%) SQL BI Developer
10 6 (5.00%) Data Analyst
10 6 (5.00%) ETL Developer
10 6 (5.00%) SAP BusinessObjects (BO) Developer
11 5 (4.17%) Data Warehouse Developer
11 5 (4.17%) Project Manager
11 5 (4.17%) SSRS Developer
12 4 (3.33%) QlikView Developer
12 4 (3.33%) SAP BI Developer
12 4 (3.33%) SAP Developer
12 4 (3.33%) SSIS Developer
13 3 (2.50%) Senior Data Architect
Libraries, Frameworks & Software Standards
1 3 (2.50%) MDX
2 1 (0.83%) .NET
2 1 (0.83%) .NET Core
2 1 (0.83%) AngularJS
2 1 (0.83%) CSS
2 1 (0.83%) CSS3
2 1 (0.83%) D3.js
2 1 (0.83%) HTML
2 1 (0.83%) HTML5
2 1 (0.83%) JSON
2 1 (0.83%) Laravel
2 1 (0.83%) LESS
2 1 (0.83%) Node.js
2 1 (0.83%) Sass
2 1 (0.83%) SVG
2 1 (0.83%) Twitter Bootstrap
Miscellaneous
1 9 (7.50%) Analytical Skills
2 8 (6.67%) Data Structures
3 3 (2.50%) NHS
4 2 (1.67%) Greenfield Project
4 2 (1.67%) Management Information System
4 2 (1.67%) Public Cloud
5 1 (0.83%) Algorithms
5 1 (0.83%) Data Protection Act
5 1 (0.83%) FMCG
5 1 (0.83%) Mobile App
5 1 (0.83%) Private Cloud
5 1 (0.83%) Reference Data
5 1 (0.83%) User Experience
5 1 (0.83%) Virtual Team
Operating Systems
1 4 (3.33%) Linux
1 4 (3.33%) Unix
Processes & Methodologies
1 61 (50.83%) Business Intelligence
2 46 (38.33%) ETL
3 29 (24.17%) Data Modelling
4 23 (19.17%) Analytics
5 17 (14.17%) Visualisation
6 16 (13.33%) Data Analysis
7 15 (12.50%) Agile Software Development
7 15 (12.50%) Data Architecture
7 15 (12.50%) Migration
8 14 (11.67%) Dimensional Modelling
9 10 (8.33%) Data Visualisation
10 9 (7.50%) Data Governance
10 9 (7.50%) Data Strategy
10 9 (7.50%) Stakeholder Management
11 7 (5.83%) Dashboard Development
11 7 (5.83%) Data Integration
11 7 (5.83%) Data Migration
11 7 (5.83%) ETL Development
12 6 (5.00%) Data Analytics
12 6 (5.00%) Problem-Solving
Programming Languages
1 78 (65.00%) SQL
2 17 (14.17%) T-SQL
3 4 (3.33%) Java
3 4 (3.33%) PHP
4 3 (2.50%) C#
4 3 (2.50%) Go
5 2 (1.67%) PL/SQL
5 2 (1.67%) PowerShell
5 2 (1.67%) Python
5 2 (1.67%) R
5 2 (1.67%) Shell Script
6 1 (0.83%) Apex Code
6 1 (0.83%) C
6 1 (0.83%) Data Analysis Expressions (DAX)
6 1 (0.83%) Scala
6 1 (0.83%) U-SQL
6 1 (0.83%) VBA
Qualifications
1 5 (4.17%) SC Cleared
1 5 (4.17%) Security Cleared
2 3 (2.50%) ISEB
2 3 (2.50%) ISTQB
2 3 (2.50%) ISTQB Foundation Certification
3 2 (1.67%) Degree
4 1 (0.83%) BPSS Clearance
4 1 (0.83%) DBS Check
4 1 (0.83%) PRINCE2 Certification
Quality Assurance & Compliance
1 10 (8.33%) Data Quality
2 2 (1.67%) PCI DSS
2 2 (1.67%) QA
3 1 (0.83%) GDPR
3 1 (0.83%) PMO
System Software
1 4 (3.33%) HDFS
2 1 (0.83%) Active Directory
2 1 (0.83%) Docker
2 1 (0.83%) Virtual Machines
Systems Management
1 1 (0.83%) Oozie
Vendors
1 25 (20.83%) Microsoft
2 19 (15.83%) SAP
3 15 (12.50%) Tableau
4 11 (9.17%) Oracle
5 5 (4.17%) Google
6 4 (3.33%) Cognos
7 3 (2.50%) Hortonworks
8 2 (1.67%) CA
8 2 (1.67%) IBM
8 2 (1.67%) Informatica
8 2 (1.67%) Sybase
8 2 (1.67%) Talend
8 2 (1.67%) VMware
9 1 (0.83%) Cloudera
9 1 (0.83%) Dundas
9 1 (0.83%) HP
9 1 (0.83%) Remedy
9 1 (0.83%) Salesforce.com
9 1 (0.83%) TSYS
9 1 (0.83%) Vertica