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 27 August 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
27 Aug 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 50 39 54
Rank change year-on-year
-11 +15
Contract jobs citing Data Warehouse 82 119 83
As % of all contract IT jobs located in Scotland 3.66% 3.63% 2.97%
As % of the Database & Business Intelligence category 14.91% 19.32% 14.41%
Number of daily rates quoted 53 69 40
Median daily rate £400 £375 £413
Median daily rate % change year-on-year
+6.66% -9.09%
90% offered a daily rate of more than £304 £288 £338
10% offered a daily rate of more than £500 £525 £610
UK excluding London median daily rate £400 £400 £375
% change year-on-year
- +6.66%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £44.00 £30.00 £67.00
% change year-on-year
+46.66% -55.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
550 616 576
As % of all contract IT jobs located in Scotland 24.56% 18.80% 20.65%
Number of daily rates quoted 305 329 292
Median daily rate £350 £363 £360
Median daily rate % change year-on-year
-3.44% +0.69%
90% offered a daily rate of more than £266 £288 £250
10% offered a daily rate of more than £475 £525 £463
UK excluding London median daily rate £375 £375 £350
% change year-on-year
- +7.14%
Number of hourly rates quoted 10 5 8
Median hourly rate £42.00 £24.46 £17.50
Median hourly rate % change year-on-year
+71.69% +39.78%
90% offered a hourly rate of more than £11.11 £11.56 £11.00
10% offered a hourly rate of more than £47.25 £65.00 £135.00
UK excluding London median hourly rate £28.18 £33.00 £28.50
% change year-on-year
-14.60% +15.78%

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 27 August 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 27 August 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 -8 47 £400 +3.22% 5
Glasgow -4 26 £400 +17.64% 2
Stirling +5 3 £475 - 1
Aberdeen - 1 - -
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 27 August 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 74 (49.33%) Finance
2 70 (46.67%) ETL
3 63 (42.00%) SQL
4 57 (38.00%) Data Modelling
5 51 (34.00%) Oracle
6 47 (31.33%) Business Intelligence
7 34 (22.67%) SQL Server
8 31 (20.67%) Banking
8 31 (20.67%) Relational Database
9 30 (20.00%) Migration
10 27 (18.00%) Agile Software Development
11 25 (16.67%) RDBMS
12 23 (15.33%) Stakeholder Management
12 23 (15.33%) SQL Server Integration Services
13 22 (14.67%) Data Architecture
13 22 (14.67%) Oracle Database
14 21 (14.00%) Analytics
15 20 (13.33%) Teradata
15 20 (13.33%) SAS
16 18 (12.00%) User Acceptance Testing
17 17 (11.33%) Retail
17 17 (11.33%) Data Migration
18 16 (10.67%) Informatica
18 16 (10.67%) Data Integration
18 16 (10.67%) Enterprise Data Warehouse
19 15 (10.00%) Data Quality
19 15 (10.00%) Talend
19 15 (10.00%) Credit Risk
19 15 (10.00%) Dimensional Modelling
19 15 (10.00%) Talend Open Studio

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 20 (13.33%) SAS
2 2 (1.33%) Oracle Workflow
2 2 (1.33%) PowerExchange
2 2 (1.33%) SharePoint
2 2 (1.33%) SharePoint 2010
Applications
1 6 (4.00%) MS Excel
2 4 (2.67%) MS PowerPoint
3 3 (2.00%) MS Project
4 2 (1.33%) MS Visio
5 1 (0.67%) Spreadsheet
Business Applications
1 2 (1.33%) Cognos TM1
2 1 (0.67%) Infor M3
2 1 (0.67%) Maximo
2 1 (0.67%) OpenLink RightAngle
2 1 (0.67%) Oracle ERP
2 1 (0.67%) Primavera
Cloud Services
1 1 (0.67%) SaaS
Communications & Networking
1 1 (0.67%) Internet
1 1 (0.67%) LAN
1 1 (0.67%) SAN
1 1 (0.67%) Wi-Fi
1 1 (0.67%) WLAN
Database & Business Intelligence
1 34 (22.67%) SQL Server
2 31 (20.67%) Relational Database
3 25 (16.67%) RDBMS
4 23 (15.33%) SQL Server Integration Services
5 22 (14.67%) Oracle Database
6 16 (10.67%) Enterprise Data Warehouse
7 14 (9.33%) SQL Server Reporting Services
8 13 (8.67%) Big Data
9 12 (8.00%) Oracle Reports
10 11 (7.33%) Hadoop
11 10 (6.67%) BusinessObjects
12 7 (4.67%) SQL Server 2008
13 6 (4.00%) MongoDB
13 6 (4.00%) SQL Server 2012
14 5 (3.33%) IBM PureData
14 5 (3.33%) Oracle Database 10g
14 5 (3.33%) Oracle Database 11g
14 5 (3.33%) Oracle Exadata
14 5 (3.33%) Oracle8/8i Database
14 5 (3.33%) Oracle9i Database
Development Applications
1 15 (10.00%) Talend Open Studio
2 5 (3.33%) PVCS
2 5 (3.33%) Team Foundation Server
3 4 (2.67%) ERwin
4 2 (1.33%) Visual Studio
5 1 (0.67%) FitNesse
5 1 (0.67%) Git (software)
5 1 (0.67%) gulp
5 1 (0.67%) Jasmine
5 1 (0.67%) JIRA
5 1 (0.67%) Karma Test Runner
5 1 (0.67%) Protractor
5 1 (0.67%) SQL Server Management Studio (SSMS)
5 1 (0.67%) Subversion
5 1 (0.67%) VSS/SourceSafe
General
1 74 (49.33%) Finance
2 31 (20.67%) Banking
3 17 (11.33%) Retail
4 13 (8.67%) Retail Banking
5 5 (3.33%) Law
6 1 (0.67%) Billing
6 1 (0.67%) Investment Banking
6 1 (0.67%) Manufacturing
6 1 (0.67%) Wholesale Banking
Job Titles
1 44 (29.33%) Analyst
2 34 (22.67%) Architect
3 30 (20.00%) Data Architect
4 23 (15.33%) Developer
5 20 (13.33%) Data Analyst
6 17 (11.33%) Data Warehouse Architect
7 16 (10.67%) Data Warehouse Analyst
8 13 (8.67%) Business Analyst
8 13 (8.67%) Test Analyst
9 11 (7.33%) SQL Developer
10 10 (6.67%) Data Business Analyst
10 10 (6.67%) ETL Developer
11 9 (6.00%) Business Intelligence Developer
11 9 (6.00%) Consultant
11 9 (6.00%) Solutions Architect
12 8 (5.33%) Project Manager
12 8 (5.33%) SSIS Developer
13 7 (4.67%) ETL Analyst
13 7 (4.67%) Senior Analyst
14 6 (4.00%) Senior Test Analyst
Libraries, Frameworks & Software Standards
1 4 (2.67%) .NET
1 4 (2.67%) HTML
2 3 (2.00%) HTML5
3 2 (1.33%) ASP.NET
3 2 (1.33%) ASP.NET MVC
3 2 (1.33%) CSS
3 2 (1.33%) XML
4 1 (0.67%) Apache CXF
4 1 (0.67%) CSS3
4 1 (0.67%) D3.js
4 1 (0.67%) FpML
4 1 (0.67%) Laravel
4 1 (0.67%) Middleware
4 1 (0.67%) REST
4 1 (0.67%) Sass
4 1 (0.67%) SOAP
4 1 (0.67%) Spring
4 1 (0.67%) SVG
4 1 (0.67%) Web Services
4 1 (0.67%) XML Schema
Miscellaneous
1 16 (10.67%) Data Integration
2 15 (10.00%) Credit Risk
3 13 (8.67%) Analytical Skills
4 3 (2.00%) Reference Data
5 2 (1.33%) Mainframe
5 2 (1.33%) Visualisation
6 1 (0.67%) Data Extraction
6 1 (0.67%) Data Structures
6 1 (0.67%) Hedge funds
6 1 (0.67%) Management Information System
6 1 (0.67%) Private Cloud
6 1 (0.67%) SCADA
6 1 (0.67%) Statistics
6 1 (0.67%) User Experience
Operating Systems
1 12 (8.00%) Unix
2 1 (0.67%) Windows
Processes & Methodologies
1 70 (46.67%) ETL
2 57 (38.00%) Data Modelling
3 47 (31.33%) Business Intelligence
4 30 (20.00%) Migration
5 27 (18.00%) Agile Software Development
6 23 (15.33%) Stakeholder Management
7 22 (14.67%) Data Architecture
8 21 (14.00%) Analytics
9 18 (12.00%) User Acceptance Testing
10 17 (11.33%) Data Migration
11 15 (10.00%) Dimensional Modelling
12 14 (9.33%) Business Analysis
13 12 (8.00%) Data Analysis
14 11 (7.33%) Kimball Methodology
15 8 (5.33%) Logical Data Model
15 8 (5.33%) Performance Tuning
15 8 (5.33%) Waterfall
16 7 (4.67%) Data Mapping
16 7 (4.67%) Scrum
16 7 (4.67%) Test Scripting
Programming Languages
1 63 (42.00%) SQL
2 13 (8.67%) PL/SQL
3 10 (6.67%) T-SQL
4 4 (2.67%) Java
5 3 (2.00%) C#
6 2 (1.33%) C
6 2 (1.33%) JavaScript
6 2 (1.33%) VBA
7 1 (0.67%) PHP
7 1 (0.67%) Python
7 1 (0.67%) SAS Macro
Qualifications
1 7 (4.67%) ISEB
2 6 (4.00%) Security Cleared
3 1 (0.67%) Degree
Quality Assurance & Compliance
1 15 (10.00%) Data Quality
2 4 (2.67%) QA
3 2 (1.33%) Disclosure Scotland
4 1 (0.67%) Basel III
4 1 (0.67%) Solvency II
System Software
1 1 (0.67%) HDFS
Systems Management
1 8 (5.33%) HP Quality Center
Vendors
1 51 (34.00%) Oracle
2 20 (13.33%) Teradata
3 16 (10.67%) Informatica
4 15 (10.00%) Talend
5 13 (8.67%) Microsoft
6 11 (7.33%) MicroStrategy
7 9 (6.00%) IBM
8 5 (3.33%) Cognos
8 5 (3.33%) Netezza
8 5 (3.33%) Trillium
9 4 (2.67%) Ab Initio
9 4 (2.67%) SAP
10 3 (2.00%) Cloudera
11 2 (1.33%) CA
11 2 (1.33%) Nintex
12 1 (0.67%) ESRI
12 1 (0.67%) Perforce
12 1 (0.67%) Siemens
12 1 (0.67%) Sybase
12 1 (0.67%) Ventyx
Scotland
Harvey Nash plc
Rate: £300 - £350 per day
Posted: 2 days ago
Edinburgh
Robert Walters UK
Rate: £300 - £350 per day + Market Day rates
Posted: 3 days ago
Edinburgh, Midlothian
Robert Walters
Rate: £300 - £350 per day
Posted: 2 days ago