Period
to 20 January 2018

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 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.

Data Warehousing
England > North West
6 months to
20 Jan 2018
Same period 2017 Same period 2016
Rank 85 66 43
Rank change year-on-year -19 -23 +11
Contract jobs citing Data Warehouse 126 177 302
As % of all contract IT jobs advertised in the North West 2.33% 2.89% 3.58%
As % of the Database & Business Intelligence category 9.94% 11.61% 16.53%
Number of daily rates quoted 102 120 223
North West median daily rate £425 £394 £400
Median daily rate % change year-on-year +7.94% -1.56% +6.67%
10th Percentile £313 £319 £250
90th Percentile £615 £650 £574
England median daily rate £450 £438 £425
% change year-on-year +2.86% +2.94% -
Number of hourly rates quoted 6 0 1
North West median hourly rate £39.25 - £62.50
10th Percentile £27.00 - £58.75
90th Percentile £53.00 - £66.25
England median hourly rate £26.80 £41.00 £32.25
% change year-on-year -34.64% +27.13% -18.35%

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,267 1,524 1,827
As % of all contract IT jobs advertised in the North West 23.44% 24.87% 21.68%
Number of daily rates quoted 902 1,048 1,196
North West median daily rate £400 £375 £400
Median daily rate % change year-on-year +6.67% -6.25% +23.08%
10th Percentile £275 £269 £250
90th Percentile £625 £556 £526
England median daily rate £470 £430 £425
% change year-on-year +9.30% +1.18% +6.25%
Number of hourly rates quoted 30 39 46
North West median hourly rate £42.25 £28.50 £37.75
Median hourly rate % change year-on-year +48.25% -24.50% +18.15%
10th Percentile £14.73 £14.15 £16.25
90th Percentile £64.06 £44.15 £66.38
England median hourly rate £31.23 £27.50 £30.00
% change year-on-year +13.56% -8.33% +4.57%

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 January 2018.

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 20 January 2018.

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 20 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
Manchester +6 60 £413 +10.00% 34
Cheshire -11 31 £375 -7.69% 11
Lancashire +12 17 £610 +62.67% 4
Merseyside 0 8 £325 -16.13% 6
Data Warehouse
England

For the 6 months to 20 January 2018, IT contractor jobs citing Data Warehouse 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 North West region with a requirement for Data Warehouse.

1 75 (59.52%) Business Intelligence
2 74 (58.73%) SQL
3 45 (35.71%) ETL
4 38 (30.16%) SQL Server
5 36 (28.57%) SQL Server Reporting Services
5 36 (28.57%) SQL Server Integration Services
6 32 (25.40%) Agile Software Development
7 31 (24.60%) Finance
8 21 (16.67%) Microsoft
8 21 (16.67%) Analytics
9 20 (15.87%) SQL Server Analysis Services
10 19 (15.08%) Oracle
10 19 (15.08%) Cognos
11 18 (14.29%) Data Modelling
11 18 (14.29%) Banking
11 18 (14.29%) Tableau
12 17 (13.49%) Data Analysis
12 17 (13.49%) T-SQL
12 17 (13.49%) IBM
13 16 (12.70%) Data Architecture
13 16 (12.70%) Hadoop
13 16 (12.70%) Big Data
14 15 (11.90%) Apache Hive
14 15 (11.90%) Cognos Business Intelligence
15 14 (11.11%) Analytical Skills
15 14 (11.11%) Power BI
16 13 (10.32%) Kanban
17 12 (9.52%) Data Integration
17 12 (9.52%) Data Management
17 12 (9.52%) Migration

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 10 (7.94%) SAS
2 6 (4.76%) Apache Spark
3 3 (2.38%) SharePoint
4 1 (0.79%) Apache
4 1 (0.79%) Elasticsearch
Applications
1 5 (3.97%) Microsoft Excel
2 1 (0.79%) Microsoft Office
2 1 (0.79%) Microsoft Project
Business Applications
1 15 (11.90%) Cognos Business Intelligence
2 3 (2.38%) SAP ERP
3 1 (0.79%) Dynamics NAV
3 1 (0.79%) HFM
3 1 (0.79%) Hyperion Planning
3 1 (0.79%) Infor LN
3 1 (0.79%) Salesforce.com CRM
Cloud Services
1 4 (3.17%) Amazon AWS
1 4 (3.17%) Microsoft Azure
2 1 (0.79%) Amazon EMR
2 1 (0.79%) Amazon S3
2 1 (0.79%) AWS Lambda
2 1 (0.79%) Google Cloud Platform
2 1 (0.79%) Serverless
Communications & Networking
1 1 (0.79%) SMS
Database & Business Intelligence
1 38 (30.16%) SQL Server
2 36 (28.57%) SQL Server Integration Services
2 36 (28.57%) SQL Server Reporting Services
3 20 (15.87%) SQL Server Analysis Services
4 16 (12.70%) Big Data
4 16 (12.70%) Hadoop
5 15 (11.90%) Apache Hive
6 14 (11.11%) Power BI
7 10 (7.94%) DataStage
8 8 (6.35%) Oracle Database
9 7 (5.56%) MongoDB
9 7 (5.56%) QlikView
9 7 (5.56%) SQL Server 2008
10 6 (4.76%) Data Lake
10 6 (4.76%) Enterprise Data Warehouse
10 6 (4.76%) PostgreSQL
10 6 (4.76%) SQL Server 2014
11 5 (3.97%) HBase
11 5 (3.97%) Relational Database
11 5 (3.97%) SQL Server 2016
Development Applications
1 4 (3.17%) ERwin
2 3 (2.38%) JIRA
2 3 (2.38%) Team Foundation Server
2 3 (2.38%) Toad
3 2 (1.59%) Git (software)
3 2 (1.59%) Mercurial
3 2 (1.59%) SQL Server Management Studio (SSMS)
3 2 (1.59%) Subversion
3 2 (1.59%) TeamCity
3 2 (1.59%) Visual Studio
3 2 (1.59%) YouTrack
4 1 (0.79%) Oracle Forms
General
1 31 (24.60%) Finance
2 18 (14.29%) Banking
3 9 (7.14%) Retail
4 3 (2.38%) Advertising
5 2 (1.59%) Law
5 2 (1.59%) Marketing
6 1 (0.79%) Aerospace
6 1 (0.79%) Legal
6 1 (0.79%) Manufacturing
6 1 (0.79%) Pharmaceutical
Job Titles
1 60 (47.62%) Developer
2 33 (26.19%) Analyst
3 32 (25.40%) Business Intelligence Developer
4 18 (14.29%) Architect
5 17 (13.49%) Data Architect
6 10 (7.94%) Data Warehouse Developer
6 10 (7.94%) SQL Developer
6 10 (7.94%) Test Analyst
7 8 (6.35%) Cognos Developer
7 8 (6.35%) Data Analyst
7 8 (6.35%) Data Warehouse Analyst
8 7 (5.56%) Systems Analyst
9 6 (4.76%) ETL Developer
9 6 (4.76%) Lead Architect
9 6 (4.76%) SQL Analyst
10 5 (3.97%) Business Intelligence Architect
10 5 (3.97%) Cognos BI Developer
10 5 (3.97%) DataStage Developer
10 5 (3.97%) Lead Data Architect
10 5 (3.97%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 8 (6.35%) .NET
2 4 (3.17%) MDX
2 4 (3.17%) Web Services
3 3 (2.38%) LINQ
4 2 (1.59%) .NET Framework
4 2 (1.59%) Entity Framework
5 1 (0.79%) Ajax
5 1 (0.79%) ASP.NET
5 1 (0.79%) Dapper ORM
5 1 (0.79%) HTML
5 1 (0.79%) Node.js
5 1 (0.79%) Velocity
5 1 (0.79%) WCF
5 1 (0.79%) WPF
5 1 (0.79%) XML
Miscellaneous
1 14 (11.11%) Analytical Skills
2 11 (8.73%) Management Information System
3 7 (5.56%) Data Structures
4 4 (3.17%) Enterprise Software
5 3 (2.38%) Data Protection Act
6 2 (1.59%) Greenfield Project
6 2 (1.59%) Replication
7 1 (0.79%) EPoS
7 1 (0.79%) Mainframe
7 1 (0.79%) NHS
7 1 (0.79%) Virtual Team
Operating Systems
1 10 (7.94%) Unix
2 6 (4.76%) Linux
3 4 (3.17%) Windows
4 3 (2.38%) AIX
5 1 (0.79%) Windows Server
Processes & Methodologies
1 75 (59.52%) Business Intelligence
2 45 (35.71%) ETL
3 32 (25.40%) Agile Software Development
4 21 (16.67%) Analytics
5 18 (14.29%) Data Modelling
6 17 (13.49%) Data Analysis
7 16 (12.70%) Data Architecture
8 13 (10.32%) Kanban
9 12 (9.52%) Data Integration
9 12 (9.52%) Data Management
9 12 (9.52%) Migration
10 11 (8.73%) Visualisation
11 10 (7.94%) Kimball Methodology
12 9 (7.14%) Data Migration
12 9 (7.14%) Data Protection
12 9 (7.14%) Time Management
13 8 (6.35%) Data Governance
13 8 (6.35%) Data Visualisation
13 8 (6.35%) Kalman Filter
14 7 (5.56%) Performance Tuning
Programming Languages
1 74 (58.73%) SQL
2 17 (13.49%) T-SQL
3 7 (5.56%) C#
3 7 (5.56%) Shell Script
4 5 (3.97%) Python
5 4 (3.17%) Data Analysis Expressions (DAX)
5 4 (3.17%) PL/SQL
5 4 (3.17%) VBA
6 3 (2.38%) PowerShell
7 1 (0.79%) C
7 1 (0.79%) Embedded C
7 1 (0.79%) JavaScript
7 1 (0.79%) R
Qualifications
1 3 (2.38%) Security Cleared
2 2 (1.59%) ACCA
2 2 (1.59%) CIMA
2 2 (1.59%) Degree
2 2 (1.59%) ISTQB
2 2 (1.59%) SC Cleared
3 1 (0.79%) BPSS Clearance
3 1 (0.79%) Master's Degree
Quality Assurance & Compliance
1 9 (7.14%) Data Quality
2 5 (3.97%) QA
3 2 (1.59%) SLA
4 1 (0.79%) Dodd-Frank
4 1 (0.79%) EMIR
4 1 (0.79%) MiFID
System Software
1 3 (2.38%) Oracle RAC
1 3 (2.38%) Tivoli Workload Scheduler
Systems Management
1 3 (2.38%) Data Guard
1 3 (2.38%) Oozie
1 3 (2.38%) Oracle RMAN
1 3 (2.38%) Tivoli
Vendors
1 21 (16.67%) Microsoft
2 19 (15.08%) Cognos
2 19 (15.08%) Oracle
3 18 (14.29%) Tableau
4 17 (13.49%) IBM
5 9 (7.14%) Capita
5 9 (7.14%) Informatica
6 8 (6.35%) MicroStrategy
7 6 (4.76%) SAP
8 5 (3.97%) Cisco
8 5 (3.97%) Teradata
9 4 (3.17%) CA
10 3 (2.38%) EMC
10 3 (2.38%) HP
10 3 (2.38%) Red Hat
10 3 (2.38%) Remedy
11 1 (0.79%) BMC
11 1 (0.79%) Google
11 1 (0.79%) Hyperion
11 1 (0.79%) Salesforce.com