The table below looks at the statistics for Data Warehouse skills in IT contracts advertised for the Scotland region. Included is a guide to the contractor rates offered in IT contracts that have cited Data Warehouse over the 3 months to 22 February 2017 with a comparison to the same period over the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

3 months to
22 Feb 2017
Same period 2016 Same period 2015
Data Warehousing
UK / Scotland
Rank 49 51 43
Rank change year-on-year
+2 -8
Contract jobs citing Data Warehouse 55 87 95
As % of all contract IT jobs located in Scotland 3.14% 3.36% 3.52%
As % of the Database & Business Intelligence category 15.63% 15.43% 16.46%
Number of daily rates quoted 30 61 64
Median daily rate £394 £375 £395
Median daily rate % change year-on-year
+5.00% -5.06%
90% offered a daily rate of more than £345 £318 £296
10% offered a daily rate of more than £454 £498 £493
UK excluding London median daily rate £400 £400 £400
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £40.00 £59.25 £39.50
% change year-on-year
-32.48% +50.00%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in contract jobs advertised in the Scotland region.

Database & Business Intelligence Category
Scotland
Contract IT job ads with a match in the
Database & Business Intelligence category
352 564 577
As % of all contract IT jobs located in Scotland 20.10% 21.78% 21.35%
Number of daily rates quoted 189 313 329
Median daily rate £375 £375 £383
Median daily rate % change year-on-year
- -1.96%
90% offered a daily rate of more than £296 £283 £285
10% offered a daily rate of more than £475 £500 £475
UK excluding London median daily rate £400 £375 £370
% change year-on-year
+6.66% +1.35%
Number of hourly rates quoted 12 4 5
Median hourly rate £17.32 £16.25 £47.50
Median hourly rate % change year-on-year
+6.58% -65.78%
UK excluding London median hourly rate £38.00 £32.50 £32.50
% change year-on-year
+16.92% -

Data Warehouse
Jobs Demand Trend in Scotland

The demand trend of contract jobs across the Scotland region citing Data Warehouse as a proportion of all IT contracts with a match in the Database & Business Intelligence category.

Data Warehouse Jobs Demand Trend in Scotland

Data Warehouse
Daily Rate Trend in Scotland

This chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing Data Warehouse across the Scotland region.

Data Warehouse Daily Rate Trend in Scotland

Data Warehouse
Daily Rate Histogram in Scotland

This chart provides a histogram of daily rates quoted in contract IT jobs citing Data Warehouse across the Scotland region over the 3 months to 22 February 2017.

Data Warehouse Daily Rate Histogram in Scotland

Data Warehouse
Hourly Rate Trend in Scotland

This chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing Data Warehouse across the Scotland region.

Data Warehouse Hourly Rate Trend in Scotland

Data Warehouse
Contract Job Locations in Scotland

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 Scotland region over the 3 months to 22 February 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Glasgow +6 31 £360 +2.85% 3
Edinburgh -15 19 £388 +3.33% 2
Stirling +6 1 £425 -
Aberdeenshire - 1 £450 -
Inverclyde - 1 £375 -
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 22 February 2017, 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 Scotland region with a requirement for Data Warehouse.

1 54 (50.94%) SQL
2 46 (43.40%) SQL Server
3 44 (41.51%) Business Intelligence
4 43 (40.57%) ETL
5 33 (31.13%) Finance
6 28 (26.42%) Oracle
6 28 (26.42%) SQL Server Integration Services
7 26 (24.53%) Data Modelling
8 25 (23.58%) SQL Server Reporting Services
9 19 (17.92%) Microsoft
10 17 (16.04%) Agile Software Development
11 15 (14.15%) Banking
11 15 (14.15%) Analytics
12 14 (13.21%) Relational Database
12 14 (13.21%) SQL Server Analysis Services
13 13 (12.26%) Data Integration
13 13 (12.26%) Data Analysis
13 13 (12.26%) Business Analysis
13 13 (12.26%) Stakeholder Management
14 11 (10.38%) Migration
14 11 (10.38%) PL/SQL
14 11 (10.38%) SQL Server 2012
14 11 (10.38%) Kimball Methodology
15 10 (9.43%) Analytical Skills
15 10 (9.43%) SAS
15 10 (9.43%) Data Management
16 9 (8.49%) Management Information System
16 9 (8.49%) Logical Data Model
16 9 (8.49%) Physical Data Model
16 9 (8.49%) Oracle Database

Data Warehouse
Top Related IT Skills in Scotland 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 (9.43%) SAS
2 4 (3.77%) JBoss
2 4 (3.77%) Oracle Application Server
3 3 (2.83%) SharePoint
4 1 (0.94%) Oracle SOA Suite
Applications
1 8 (7.55%) MS Excel
2 1 (0.94%) MS Project
2 1 (0.94%) MS Visio
Business Applications
1 2 (1.89%) thinkFolio
2 1 (0.94%) Cognos Business Intelligence
Cloud Services
1 5 (4.72%) Microsoft Azure
2 3 (2.83%) Amazon AWS
Communications & Networking
1 4 (3.77%) LAN
2 3 (2.83%) Firewall
2 3 (2.83%) VLAN
2 3 (2.83%) VPN
2 3 (2.83%) WAN
3 1 (0.94%) Wi-Fi
Database & Business Intelligence
1 46 (43.40%) SQL Server
2 28 (26.42%) SQL Server Integration Services
3 25 (23.58%) SQL Server Reporting Services
4 14 (13.21%) Relational Database
4 14 (13.21%) SQL Server Analysis Services
5 11 (10.38%) SQL Server 2012
6 9 (8.49%) Oracle Database
7 8 (7.55%) RDBMS
7 8 (7.55%) SQL Server 2014
8 7 (6.60%) Big Data
9 6 (5.66%) BusinessObjects
9 6 (5.66%) QlikView
10 5 (4.72%) Enterprise Data Warehouse
11 4 (3.77%) Oracle Database 12c
11 4 (3.77%) Power BI
11 4 (3.77%) SQL Server 2016
12 3 (2.83%) MySQL
13 2 (1.89%) Ingres
13 2 (1.89%) Oracle Database 10g
13 2 (1.89%) Snowflake Schema
Development Applications
1 5 (4.72%) Talend Open Studio
2 2 (1.89%) ERwin
2 2 (1.89%) Visual Studio
3 1 (0.94%) Bitbucket
3 1 (0.94%) Cucumber
3 1 (0.94%) Git (software)
3 1 (0.94%) PVCS
3 1 (0.94%) Selenium
3 1 (0.94%) SQL Server Management Studio (SSMS)
3 1 (0.94%) Subversion
3 1 (0.94%) Team Foundation Server
General
1 33 (31.13%) Finance
2 15 (14.15%) Banking
3 8 (7.55%) Law
4 5 (4.72%) Back Office
5 3 (2.83%) Legal
5 3 (2.83%) Retail
5 3 (2.83%) Retail Banking
6 2 (1.89%) Investment Banking
6 2 (1.89%) Marketing
7 1 (0.94%) Front Office
Job Titles
1 37 (34.91%) Developer
2 32 (30.19%) Analyst
3 13 (12.26%) Data Analyst
4 12 (11.32%) SQL Developer
5 10 (9.43%) Business Intelligence Developer
5 10 (9.43%) ETL Developer
6 9 (8.49%) Business Analyst
7 6 (5.66%) Systems Analyst
8 5 (4.72%) .NET Developer
8 5 (4.72%) Consultant
8 5 (4.72%) Data Business Analyst
8 5 (4.72%) Data Modeller
8 5 (4.72%) Data Warehouse Developer
8 5 (4.72%) Designer
8 5 (4.72%) Senior Analyst
8 5 (4.72%) SQL BI Developer
8 5 (4.72%) SSIS Developer
9 4 (3.77%) SQL Server Developer
9 4 (3.77%) SSRS Developer
9 4 (3.77%) Technical Analyst
Libraries, Frameworks & Software Standards
1 6 (5.66%) .NET
1 6 (5.66%) ASP.NET
1 6 (5.66%) ASP.NET MVC
2 5 (4.72%) MDX
2 5 (4.72%) Web Services
3 4 (3.77%) ASP.NET Web API
3 4 (3.77%) OC4J
3 4 (3.77%) WinForms
4 2 (1.89%) CSS
4 2 (1.89%) CSS3
4 2 (1.89%) HTML
4 2 (1.89%) HTML5
4 2 (1.89%) PostGIS
4 2 (1.89%) XML
5 1 (0.94%) AngularJS
5 1 (0.94%) Apache Cordova
5 1 (0.94%) PhoneGap
Miscellaneous
1 10 (9.43%) Analytical Skills
2 9 (8.49%) Management Information System
3 5 (4.72%) Enterprise Software
4 4 (3.77%) Credit Risk
5 2 (1.89%) Data Centre
5 2 (1.89%) Data Structures
6 1 (0.94%) Hedge funds
6 1 (0.94%) Mainframe
6 1 (0.94%) Minimum Viable Product
6 1 (0.94%) Mobile App
6 1 (0.94%) Reference Data
6 1 (0.94%) Social Media
Operating Systems
1 7 (6.60%) Unix
2 4 (3.77%) AIX
2 4 (3.77%) Linux
2 4 (3.77%) Tru64
3 3 (2.83%) Windows
3 3 (2.83%) Windows Server
Processes & Methodologies
1 44 (41.51%) Business Intelligence
2 43 (40.57%) ETL
3 26 (24.53%) Data Modelling
4 17 (16.04%) Agile Software Development
5 15 (14.15%) Analytics
6 13 (12.26%) Business Analysis
6 13 (12.26%) Data Analysis
6 13 (12.26%) Data Integration
6 13 (12.26%) Stakeholder Management
7 11 (10.38%) Kimball Methodology
7 11 (10.38%) Migration
8 10 (9.43%) Data Management
9 9 (8.49%) ETL Development
9 9 (8.49%) Logical Data Model
9 9 (8.49%) Physical Data Model
10 8 (7.55%) User Acceptance Testing
11 7 (6.60%) Data Architecture
11 7 (6.60%) MVC
12 6 (5.66%) Asset Management
12 6 (5.66%) Requirements Analysis
Programming Languages
1 54 (50.94%) SQL
2 11 (10.38%) PL/SQL
3 8 (7.55%) T-SQL
4 6 (5.66%) C#
5 4 (3.77%) VBA
6 3 (2.83%) Python
7 2 (1.89%) Java
8 1 (0.94%) C
8 1 (0.94%) JavaScript
8 1 (0.94%) VB.NET
Qualifications
1 6 (5.66%) Degree
2 1 (0.94%) APMP
2 1 (0.94%) Oracle Certification
2 1 (0.94%) Postgraduate
2 1 (0.94%) Security Cleared
Quality Assurance & Compliance
1 6 (5.66%) Disclosure Scotland
2 4 (3.77%) Data Quality
3 3 (2.83%) QA
4 1 (0.94%) Basel II
4 1 (0.94%) Basel III
4 1 (0.94%) BS7666
System Software
1 4 (3.77%) Oracle RAC
2 3 (2.83%) Active Directory
2 3 (2.83%) VMware ESX
2 3 (2.83%) VMware Infrastructure
Systems Management
1 4 (3.77%) Enterprise Manager Cloud Control
1 4 (3.77%) Oracle RMAN
Vendors
1 28 (26.42%) Oracle
2 19 (17.92%) Microsoft
3 7 (6.60%) Cognos
3 7 (6.60%) SAP
4 6 (5.66%) Tableau
5 5 (4.72%) Informatica
5 5 (4.72%) MicroStrategy
5 5 (4.72%) Talend
6 4 (3.77%) Teradata
7 3 (2.83%) Alteryx
7 3 (2.83%) CheckPoint
7 3 (2.83%) Cisco
7 3 (2.83%) Cloudera
7 3 (2.83%) Juniper
7 3 (2.83%) VMware
8 2 (1.89%) Ab Initio
8 2 (1.89%) Charles River
8 2 (1.89%) IBM
9 1 (0.94%) Pega
9 1 (0.94%) Perforce