Period
to 24 September 2018

The following table provides summary statistics for contract job vacancies advertised in Tyne and Wear 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 24 September 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
North East > Tyne and Wear
6 months to
24 Sep 2018
Same period 2017 Same period 2016
Rank 77 61 136
Rank change year-on-year -16 +75 -51
Contract jobs citing Data Warehouse 16 25 34
As % of all contract IT jobs advertised in Tyne and Wear 1.76% 2.84% 1.32%
As % of the Database & Business Intelligence category 7.41% 14.71% 6.07%
Number of daily rates quoted 12 42 29
Tyne and Wear median daily rate £400 £531 £355
Median daily rate % change year-on-year -24.71% +49.65% +1.43%
10th Percentile £263 £368 £220
90th Percentile £680 £755 £800
North East median daily rate £390 £531 £375
% change year-on-year -26.59% +41.67% +7.14%
Number of hourly rates quoted 0 0 0
Tyne and Wear median hourly rate - - -
North East median hourly rate - - £16.00

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 Tyne and Wear with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Tyne and Wear
Contract vacancies with a requirement for database or business intelligence skills 216 170 560
As % of all contract IT jobs advertised in Tyne and Wear 23.71% 19.30% 21.71%
Number of daily rates quoted 157 110 380
Tyne and Wear median daily rate £375 £391 £347
Median daily rate % change year-on-year -4.15% +12.75% -16.69%
10th Percentile £263 £281 £246
90th Percentile £600 £556 £507
North East median daily rate £385 £388 £350
% change year-on-year -0.65% +10.71% -6.67%
Number of hourly rates quoted 0 3 34
Tyne and Wear median hourly rate - £18.50 £28.00
Median hourly rate % change year-on-year - -33.93% +30.23%
North East median hourly rate - £18.50 £28.00
% change year-on-year - -33.93% +51.60%

Data Warehouse
Job Vacancy Trend in Tyne and Wear

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in Tyne and Wear.

Job vacancy trend for Data Warehouse in Tyne and Wear

Data Warehouse
Contractor Daily Rate Trend in Tyne and Wear

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

Contractor daily rate trend for Data Warehouse in Tyne and Wear

Data Warehouse
Contractor Daily Rate Histogram in Tyne and Wear

The daily rate distribution of IT jobs citing Data Warehouse in Tyne and Wear over the 6 months to 24 September 2018.

Contractor daily rate histogram for Data Warehouse in Tyne and Wear

Data Warehouse
Contractor Hourly Rate Trend in Tyne and Wear

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Data Warehouse in Tyne and Wear.

Contractor hourly rate trend for Data Warehouse in Tyne and Wear

Data Warehouse
Contract Job Locations in Tyne and Wear

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 Tyne and Wear region over the 6 months to 24 September 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
Newcastle upon Tyne -17 16 £400 -24.71% 14
Data Warehouse
North East

For the 6 months to 24 September 2018, 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 Tyne and Wear region with a requirement for Data Warehouse.

1 9 (56.25%) SQL
1 9 (56.25%) Business Intelligence
2 7 (43.75%) SQL Server Integration Services
3 6 (37.50%) ETL
4 5 (31.25%) SQL Server
5 4 (25.00%) T-SQL
5 4 (25.00%) Microsoft
5 4 (25.00%) Project Management
5 4 (25.00%) SQL Server Reporting Services
5 4 (25.00%) PostgreSQL
5 4 (25.00%) Agile Software Development
5 4 (25.00%) SQL Server Analysis Services
5 4 (25.00%) Analytical Skills
6 3 (18.75%) Customer Requirements
6 3 (18.75%) Problem-Solving
6 3 (18.75%) SC Cleared
6 3 (18.75%) Security Cleared
6 3 (18.75%) Microsoft Azure
6 3 (18.75%) Analytics
6 3 (18.75%) Data Management
6 3 (18.75%) Stakeholder Management
6 3 (18.75%) Service Management
6 3 (18.75%) SMS
7 2 (12.50%) Microsoft Excel
7 2 (12.50%) Data Modelling
7 2 (12.50%) NHS
7 2 (12.50%) MySQL
7 2 (12.50%) ITIL
7 2 (12.50%) Change Management
7 2 (12.50%) Retail

Data Warehouse
Co-occurring IT Skills in Tyne and Wear 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 1 (6.25%) CMS
Applications
1 2 (12.50%) Microsoft Excel
Cloud Services
1 3 (18.75%) Microsoft Azure
2 2 (12.50%) Amazon AWS
3 1 (6.25%) Amazon EMR
3 1 (6.25%) Amazon S3
3 1 (6.25%) AWS Data Pipeline
Communications & Networking
1 3 (18.75%) SMS
Database & Business Intelligence
1 7 (43.75%) SQL Server Integration Services
2 5 (31.25%) SQL Server
3 4 (25.00%) PostgreSQL
3 4 (25.00%) SQL Server Analysis Services
3 4 (25.00%) SQL Server Reporting Services
4 2 (12.50%) MongoDB
4 2 (12.50%) MySQL
4 2 (12.50%) Relational Database
4 2 (12.50%) SQL Server 2016
5 1 (6.25%) Amazon RDS
5 1 (6.25%) Amazon Redshift
5 1 (6.25%) Apache Hive
5 1 (6.25%) Hadoop
5 1 (6.25%) HBase
5 1 (6.25%) NoSQL
5 1 (6.25%) RDBMS
Development Applications
1 1 (6.25%) Git (software)
1 1 (6.25%) GitLab
General
1 2 (12.50%) Retail
Job Titles
1 6 (37.50%) Developer
2 4 (25.00%) Architect
3 3 (18.75%) Data Warehouse Developer
3 3 (18.75%) SQL Developer
4 2 (12.50%) Analyst
4 2 (12.50%) Business Intelligence Analyst
4 2 (12.50%) Data Architect
4 2 (12.50%) Data Engineer
4 2 (12.50%) Java Architect
4 2 (12.50%) Senior Manager
4 2 (12.50%) Senior Service Manager
4 2 (12.50%) Senior Transition Manager
4 2 (12.50%) Service Manager
4 2 (12.50%) Service Transition Manager
4 2 (12.50%) Technical Architect
4 2 (12.50%) Transition Manager
5 1 (6.25%) DevOps Engineer
5 1 (6.25%) Digital Architect
5 1 (6.25%) Senior Architect
5 1 (6.25%) Senior Data Architect
Libraries, Frameworks & Software Standards
1 1 (6.25%) J2EE
Miscellaneous
1 4 (25.00%) Analytical Skills
2 2 (12.50%) Greenfield Project
2 2 (12.50%) NHS
2 2 (12.50%) Virtual Team
3 1 (6.25%) Social Media
3 1 (6.25%) Taxonomies
Operating Systems
1 1 (6.25%) Unix
Processes & Methodologies
1 9 (56.25%) Business Intelligence
2 6 (37.50%) ETL
3 4 (25.00%) Agile Software Development
3 4 (25.00%) Project Management
4 3 (18.75%) Analytics
4 3 (18.75%) Customer Requirements
4 3 (18.75%) Data Management
4 3 (18.75%) Problem-Solving
4 3 (18.75%) Service Management
4 3 (18.75%) Stakeholder Management
5 2 (12.50%) Capacity Management
5 2 (12.50%) Change Management
5 2 (12.50%) Collaborative Working
5 2 (12.50%) Data Architecture
5 2 (12.50%) Data Modelling
5 2 (12.50%) Dependency Management
5 2 (12.50%) ITIL
5 2 (12.50%) Open Source
5 2 (12.50%) Runbook
5 2 (12.50%) Virtual Team Management
Programming Languages
1 9 (56.25%) SQL
2 4 (25.00%) T-SQL
3 2 (12.50%) Java
4 1 (6.25%) Python
4 1 (6.25%) Shell Script
Qualifications
1 3 (18.75%) SC Cleared
1 3 (18.75%) Security Cleared
Quality Assurance & Compliance
1 2 (12.50%) PMO
2 1 (6.25%) Data Quality
2 1 (6.25%) GDPR
2 1 (6.25%) QA
System Software
1 1 (6.25%) Docker
Systems Management
1 1 (6.25%) Ansible
1 1 (6.25%) Terraform
Vendors
1 4 (25.00%) Microsoft
2 1 (6.25%) Cloudera
2 1 (6.25%) Hortonworks
2 1 (6.25%) Oracle