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 30 June 2016 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
30 Jun 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 75 36 67
Rank change year-on-year
-39 +31
Contract jobs citing Data Warehouse 77 130 68
As % of all contract IT jobs located in Scotland 2.61% 4.31% 2.49%
As % of the Database & Business Intelligence category 11.03% 20.83% 12.41%
Number of daily rates quoted 54 76 31
Median daily rate £400 £369 £400
Median daily rate % change year-on-year
+8.47% -7.81%
90% offered a daily rate of more than £325 £270 £338
10% offered a daily rate of more than £500 £450 £450
UK excluding London median daily rate £400 £375 £375
% change year-on-year
+6.66% -
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £20.50 £31.50 £40.50
% change year-on-year
-34.92% -22.22%
Data Warehouse
UK

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
698 624 548
As % of all contract IT jobs located in Scotland 23.68% 20.71% 20.10%
Number of daily rates quoted 396 331 296
Median daily rate £350 £350 £350
90% offered a daily rate of more than £261 £275 £265
10% offered a daily rate of more than £488 £450 £450
UK excluding London median daily rate £375 £353 £350
% change year-on-year
+6.11% +0.96%
Number of hourly rates quoted 13 5 2
Median hourly rate £36.00 £42.50 £27.75
Median hourly rate % change year-on-year
-15.29% +53.15%
90% offered a hourly rate of more than £13.50 £18.50 £19.15
10% offered a hourly rate of more than £43.00 £65.00 £36.35
UK excluding London median hourly rate £31.90 £27.50 £30.00
% change year-on-year
+16.00% -8.33%

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 30 June 2016.

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 30 June 2016. 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
(Click see detailed
statistics and trends)
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
Edinburgh -28 45 £434 +19.65% 8
Glasgow -2 29 £400 +23.07% 6
Stirling +8 5 £538 -
Aberdeen - 1 - -
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 30 June 2016, 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 101 (58.38%) Finance
2 82 (47.40%) ETL
3 73 (42.20%) SQL
4 64 (36.99%) Data Modelling
5 57 (32.95%) Business Intelligence
6 48 (27.75%) Oracle
7 46 (26.59%) Migration
8 42 (24.28%) Banking
9 37 (21.39%) SQL Server
10 30 (17.34%) Stakeholder Management
11 29 (16.76%) Retail
11 29 (16.76%) Data Migration
12 27 (15.61%) Agile Software Development
12 27 (15.61%) Relational Database
13 26 (15.03%) Data Architecture
13 26 (15.03%) SAS
14 25 (14.45%) User Acceptance Testing
14 25 (14.45%) Data Quality
15 24 (13.87%) Analytics
15 24 (13.87%) RDBMS
16 23 (13.29%) Retail Banking
17 21 (12.14%) Oracle Database
18 20 (11.56%) Enterprise Data Warehouse
18 20 (11.56%) SQL Server Integration Services
19 19 (10.98%) Teradata
20 18 (10.40%) Microsoft
21 16 (9.25%) Data Analysis
22 15 (8.67%) Data Management
22 15 (8.67%) PL/SQL
23 14 (8.09%) Informatica

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 26 (15.03%) SAS
2 2 (1.16%) PowerExchange
2 2 (1.16%) SharePoint
3 1 (0.58%) Oracle Workflow
3 1 (0.58%) SharePoint 2010
Applications
1 10 (5.78%) MS Excel
2 5 (2.89%) MS Project
3 3 (1.73%) MS PowerPoint
4 2 (1.16%) MS Office
4 2 (1.16%) MS Visio
Business Applications
1 1 (0.58%) Cognos Business Intelligence
1 1 (0.58%) Cognos TM1
1 1 (0.58%) Infor M3
1 1 (0.58%) Maximo
1 1 (0.58%) OpenLink RightAngle
1 1 (0.58%) Primavera
Cloud Services
1 5 (2.89%) Microsoft Azure
2 2 (1.16%) Amazon AWS
3 1 (0.58%) SaaS
Communications & Networking
1 1 (0.58%) Internet
1 1 (0.58%) LAN
1 1 (0.58%) SAN
1 1 (0.58%) Wi-Fi
1 1 (0.58%) WLAN
Database & Business Intelligence
1 37 (21.39%) SQL Server
2 27 (15.61%) Relational Database
3 24 (13.87%) RDBMS
4 21 (12.14%) Oracle Database
5 20 (11.56%) Enterprise Data Warehouse
5 20 (11.56%) SQL Server Integration Services
6 13 (7.51%) SQL Server Reporting Services
7 11 (6.36%) Big Data
7 11 (6.36%) BusinessObjects
8 10 (5.78%) Hadoop
9 9 (5.20%) Oracle Reports
10 8 (4.62%) SQL Server 2012
10 8 (4.62%) SQL Server Analysis Services
11 7 (4.05%) Oracle Database 11g
11 7 (4.05%) PostgreSQL
11 7 (4.05%) SQL Server 2008
12 5 (2.89%) Data Mart
12 5 (2.89%) DB2
12 5 (2.89%) Microsoft Analysis Services
12 5 (2.89%) MongoDB
Development Applications
1 9 (5.20%) Talend Open Studio
2 6 (3.47%) Team Foundation Server
3 5 (2.89%) Git (software)
4 3 (1.73%) PVCS
4 3 (1.73%) Subversion
5 2 (1.16%) ERwin
5 2 (1.16%) Visual Studio Tools for Office
6 1 (0.58%) gulp
6 1 (0.58%) Jasmine
6 1 (0.58%) Karma Test Runner
6 1 (0.58%) Protractor
6 1 (0.58%) SQL Server Management Studio (SSMS)
6 1 (0.58%) Visual Studio
6 1 (0.58%) VSS/SourceSafe
General
1 101 (58.38%) Finance
2 42 (24.28%) Banking
3 29 (16.76%) Retail
4 23 (13.29%) Retail Banking
5 5 (2.89%) Law
6 2 (1.16%) Marketing
7 1 (0.58%) Billing
7 1 (0.58%) General Ledger
7 1 (0.58%) Manufacturing
Job Titles
1 51 (29.48%) Analyst
2 40 (23.12%) Architect
3 30 (17.34%) Data Architect
4 29 (16.76%) Developer
5 19 (10.98%) Business Analyst
5 19 (10.98%) Data Analyst
6 17 (9.83%) Data Warehouse Analyst
7 15 (8.67%) Data Warehouse Architect
7 15 (8.67%) SQL Developer
8 12 (6.94%) Project Manager
8 12 (6.94%) Solutions Architect
8 12 (6.94%) Test Analyst
9 11 (6.36%) Data Business Analyst
9 11 (6.36%) Senior Analyst
10 10 (5.78%) Consultant
11 9 (5.20%) Business Intelligence Developer
12 8 (4.62%) SQL BI Developer
13 7 (4.05%) SSIS Developer
14 6 (3.47%) Data Warehouse Business Analyst
14 6 (3.47%) ETL Analyst
Libraries, Frameworks & Software Standards
1 3 (1.73%) .NET
1 3 (1.73%) Web Services
2 2 (1.16%) ASP.NET
2 2 (1.16%) ASP.NET MVC
2 2 (1.16%) XML
3 1 (0.58%) AngularJS
3 1 (0.58%) Apache CXF
3 1 (0.58%) CSS
3 1 (0.58%) CSS3
3 1 (0.58%) D3.js
3 1 (0.58%) HTML
3 1 (0.58%) HTML5
3 1 (0.58%) Laravel
3 1 (0.58%) LESS
3 1 (0.58%) PostGIS
3 1 (0.58%) REST
3 1 (0.58%) Sass
3 1 (0.58%) SOAP
3 1 (0.58%) Spring Boot
3 1 (0.58%) Twitter Bootstrap
Miscellaneous
1 13 (7.51%) Data Integration
2 12 (6.94%) Analytical Skills
2 12 (6.94%) Credit Risk
3 7 (4.05%) Management Information System
4 5 (2.89%) Hybrid Cloud
5 3 (1.73%) Data Structures
6 2 (1.16%) Data Extraction
6 2 (1.16%) Freedom of Information
6 2 (1.16%) Mainframe
6 2 (1.16%) Visualisation
7 1 (0.58%) Derivative
7 1 (0.58%) Equities
7 1 (0.58%) Fintech
7 1 (0.58%) Hedge funds
7 1 (0.58%) Private Cloud
7 1 (0.58%) Reference Data
7 1 (0.58%) SCADA
7 1 (0.58%) User Experience
Operating Systems
1 12 (6.94%) Unix
2 4 (2.31%) Linux
3 3 (1.73%) Mac OS X
4 1 (0.58%) Windows
Processes & Methodologies
1 82 (47.40%) ETL
2 64 (36.99%) Data Modelling
3 57 (32.95%) Business Intelligence
4 46 (26.59%) Migration
5 30 (17.34%) Stakeholder Management
6 29 (16.76%) Data Migration
7 27 (15.61%) Agile Software Development
8 26 (15.03%) Data Architecture
9 25 (14.45%) User Acceptance Testing
10 24 (13.87%) Analytics
11 16 (9.25%) Data Analysis
12 15 (8.67%) Data Management
13 14 (8.09%) Dimensional Modelling
14 11 (6.36%) Mentoring
15 10 (5.78%) Business Analysis
15 10 (5.78%) Kimball Methodology
15 10 (5.78%) Scrum
16 9 (5.20%) Project Management
16 9 (5.20%) Software Testing
17 8 (4.62%) Requirements Analysis
Programming Languages
1 73 (42.20%) SQL
2 15 (8.67%) PL/SQL
3 11 (6.36%) T-SQL
4 8 (4.62%) Java
5 7 (4.05%) VBA
6 4 (2.31%) JavaScript
7 3 (1.73%) C#
7 3 (1.73%) Clojure
7 3 (1.73%) Ruby
8 2 (1.16%) Bash Shell
8 2 (1.16%) Python
9 1 (0.58%) Perl
9 1 (0.58%) PHP
9 1 (0.58%) PowerShell
Qualifications
1 9 (5.20%) Security Cleared
2 8 (4.62%) ISEB
3 2 (1.16%) SC Cleared
4 1 (0.58%) Degree
Quality Assurance & Compliance
1 25 (14.45%) Data Quality
2 9 (5.20%) QA
3 2 (1.16%) Disclosure Scotland
4 1 (0.58%) Basel III
4 1 (0.58%) FATCA
4 1 (0.58%) Solvency II
System Software
1 1 (0.58%) HDFS
Systems Management
1 9 (5.20%) HP Quality Center
Vendors
1 48 (27.75%) Oracle
2 19 (10.98%) Teradata
3 18 (10.40%) Microsoft
4 14 (8.09%) Informatica
5 11 (6.36%) MicroStrategy
6 9 (5.20%) IBM
6 9 (5.20%) Talend
7 5 (2.89%) Cognos
8 4 (2.31%) Ab Initio
8 4 (2.31%) Netezza
8 4 (2.31%) SAP
8 4 (2.31%) Trillium
9 2 (1.16%) CA
9 2 (1.16%) Sybase
9 2 (1.16%) Twitter
10 1 (0.58%) Cloudera
10 1 (0.58%) Percona
10 1 (0.58%) RedGate
10 1 (0.58%) Tableau
10 1 (0.58%) Ventyx
Edinburgh, Midlothian
Harvey Nash plc
Posted: 40 minutes ago
Glasgow
Vivid Resourcing
Posted: 5 days ago
Glasgow Area
Opus Recruitment Solutions Ltd
Rate: £400 - £500 per day
Posted: 5 days ago
Edinburgh, Midlothian
NCC Group
Rate: £280 per day
Posted: 8 days ago