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 average contractor rates offered in IT contracts that have cited Data Warehouse over the 3 months to 12 February 2016 with a comparison to the same period in 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.

Location
3 months to
12 Feb 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 59 45 72
Rank change year-on-year
-14 +27
Contract jobs citing Data Warehouse 75 95 41
As % of all contract IT jobs located in Scotland 2.94% 3.50% 1.75%
As % of the Database & Business Intelligence category 14.20% 16.10% 7.95%
Number of daily rates quoted 54 63 13
Average daily rate £375 £380 £385
Average daily rate % change year-on-year
-1.31% -1.29%
90% offered a daily rate of more than £319 £311 £285
10% offered a daily rate of more than £500 £475 £460
UK excluding London average daily rate £400 £400 £388
% change year-on-year
- +3.22%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate £62.50 £38.25 £31.50
% change year-on-year
+63.39% +21.42%
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
528 590 516
As % of all contract IT jobs located in Scotland 20.72% 21.72% 22.06%
Number of daily rates quoted 296 345 247
Average daily rate £375 £375 £340
Average daily rate % change year-on-year
- +10.29%
90% offered a daily rate of more than £280 £280 £238
10% offered a daily rate of more than £500 £475 £450
UK excluding London average daily rate £375 £375 £350
% change year-on-year
- +7.14%
Number of hourly rates quoted 4 5 7
Average hourly rate £16.25 £47.50 £13.50
Average hourly rate % change year-on-year
-65.78% +251.85%
90% offered a hourly rate of more than £9.75 £22.50 £10.93
10% offered a hourly rate of more than £49.41 £47.50 £16.87
UK excluding London average hourly rate £32.50 £32.50 £29.00
% change year-on-year
- +12.06%

Data Warehouse
Jobs Demand Trend in Scotland

This chart provides a 3-month moving total of IT contractor jobs citing Data Warehouse across the Scotland region as a proportion of the total demand within 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 12 February 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 average contractor rates quoted in IT jobs citing Data Warehouse within the Scotland region over the 3 months to 12 February 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Average
Daily Rate
Last 3 Months
Average Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh -26 39 £375 -1.31% 14
Glasgow +15 30 £360 -5.88% 4
Aberdeen - 3 £465 -
Stirling +7 2 - -
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 12 February 2016, IT contractor jobs across the Scotland region citing Data Warehouse also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Data Warehouse.

1 99 (54.70%) Finance
2 97 (53.59%) SQL
3 75 (41.44%) Business Intelligence
4 73 (40.33%) ETL
5 52 (28.73%) Banking
6 42 (23.20%) Data Modelling
6 42 (23.20%) Analytical Skills
7 35 (19.34%) Agile Software Development
8 31 (17.13%) Analytics
9 29 (16.02%) Oracle
10 28 (15.47%) PL/SQL
10 28 (15.47%) Migration
11 27 (14.92%) QA
12 25 (13.81%) Data Analysis
12 25 (13.81%) MicroStrategy
13 22 (12.15%) Informatica
14 19 (10.50%) Microsoft
14 19 (10.50%) Retail
14 19 (10.50%) Data Migration
14 19 (10.50%) Relational Database
15 18 (9.94%) Enterprise Data Warehouse
15 18 (9.94%) Star Schema
16 17 (9.39%) BusinessObjects
16 17 (9.39%) Stakeholder Management
17 16 (8.84%) Service Delivery
17 16 (8.84%) SQL Server
17 16 (8.84%) MS Excel
18 14 (7.73%) Data Integration
18 14 (7.73%) Scrum
18 14 (7.73%) Data Quality

Data Warehouse
Top Related IT Skills in Scotland by Category

For the 6 months to 12 February 2016, IT contractor jobs across the Scotland region citing Data Warehouse also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Data Warehouse. Up to 20 skills are shown per category.

Application Platforms
1 10 (5.52%) SAS
2 2 (1.10%) Apache Pig
3 1 (0.55%) SharePoint
3 1 (0.55%) WebLogic
Applications
1 16 (8.84%) MS Excel
2 5 (2.76%) MS Project
3 4 (2.21%) MS Office
4 1 (0.55%) Spreadsheet
Business Applications
1 2 (1.10%) Cognos Business Intelligence
1 2 (1.10%) Maximo
2 1 (0.55%) Dynamics CRM
2 1 (0.55%) Markit EDM
2 1 (0.55%) Oracle EBS
2 1 (0.55%) thinkFolio
Cloud Services
1 5 (2.76%) Amazon AWS
2 1 (0.55%) Microsoft Azure
Communications & Networking
1 1 (0.55%) HTTP
Database & Business Intelligence
1 19 (10.50%) Relational Database
2 18 (9.94%) Enterprise Data Warehouse
2 18 (9.94%) Star Schema
3 17 (9.39%) BusinessObjects
4 16 (8.84%) SQL Server
5 13 (7.18%) Data Mart
5 13 (7.18%) MS Access
6 11 (6.08%) Oracle Database
7 8 (4.42%) SQL Server Integration Services
8 7 (3.87%) BusinessObjects Web Intelligence
8 7 (3.87%) RDBMS
8 7 (3.87%) SAP Data Services
9 6 (3.31%) Big Data
9 6 (3.31%) BusinessObjects XI
9 6 (3.31%) DB2
9 6 (3.31%) Oracle BI EE
10 5 (2.76%) Hadoop
10 5 (2.76%) SQL Server 2012
11 4 (2.21%) Cognos Report Studio
11 4 (2.21%) Pentaho
Development Applications
1 8 (4.42%) FitNesse
1 8 (4.42%) JBehave
2 6 (3.31%) Toad
3 5 (2.76%) Cucumber
4 4 (2.21%) ERwin
4 4 (2.21%) HP UFT
5 3 (1.66%) Git (software)
5 3 (1.66%) Team Foundation Server
6 2 (1.10%) ClearCase
6 2 (1.10%) Subversion
6 2 (1.10%) Visual Studio Tools for Office
7 1 (0.55%) SQL Server Management Studio (SSMS)
General
1 99 (54.70%) Finance
2 52 (28.73%) Banking
3 19 (10.50%) Retail
4 13 (7.18%) Retail Banking
5 7 (3.87%) General Ledger
5 7 (3.87%) Investment Banking
6 4 (2.21%) Private Banking
6 4 (2.21%) Telecoms
7 2 (1.10%) Advertising
7 2 (1.10%) Law
7 2 (1.10%) Legal
7 2 (1.10%) Marketing
8 1 (0.55%) Manufacturing
Job Titles
1 74 (40.88%) Analyst
2 28 (15.47%) Developer
3 24 (13.26%) Test Analyst
4 20 (11.05%) Senior Analyst
5 17 (9.39%) Data Analyst
6 16 (8.84%) Business Analyst
6 16 (8.84%) Data Warehouse Manager
7 15 (8.29%) Architect
7 15 (8.29%) Delivery Manager
8 14 (7.73%) Senior Test Analyst
9 11 (6.08%) Consultant
10 9 (4.97%) Data Business Analyst
10 9 (4.97%) ICT Manager
10 9 (4.97%) Solutions Architect
10 9 (4.97%) Technical Analyst
11 8 (4.42%) Data Modeller
12 7 (3.87%) Data Warehouse Analyst
12 7 (3.87%) Project Manager
12 7 (3.87%) SQL Analyst
12 7 (3.87%) Test Manager
Libraries, Frameworks & Software Standards
1 4 (2.21%) Web Services
2 3 (1.66%) SOAP
3 2 (1.10%) MDX
4 1 (0.55%) .NET
4 1 (0.55%) ActiveMQ
4 1 (0.55%) JSON
4 1 (0.55%) LAMP
4 1 (0.55%) Middleware
4 1 (0.55%) Oracle Fusion
4 1 (0.55%) PostGIS
4 1 (0.55%) RESTful
4 1 (0.55%) Spring
4 1 (0.55%) Velocity
4 1 (0.55%) XML
Miscellaneous
1 42 (23.20%) Analytical Skills
2 14 (7.73%) Data Integration
3 7 (3.87%) Data Extraction
4 6 (3.31%) Management Information System
5 4 (2.21%) Data Structures
5 4 (2.21%) Derivative
5 4 (2.21%) Equities
6 3 (1.66%) Data Centre
7 2 (1.10%) Computer Science
7 2 (1.10%) Freedom of Information
7 2 (1.10%) Mathematics
7 2 (1.10%) Reference Data
7 2 (1.10%) Visualisation
8 1 (0.55%) Algorithms
8 1 (0.55%) Clustering
8 1 (0.55%) Economics
8 1 (0.55%) Hybrid Cloud
8 1 (0.55%) Replication
Operating Systems
1 8 (4.42%) Linux
2 4 (2.21%) Unix
3 2 (1.10%) Mac OS X
4 1 (0.55%) Red Hat Enterprise Linux
Processes & Methodologies
1 75 (41.44%) Business Intelligence
2 73 (40.33%) ETL
3 42 (23.20%) Data Modelling
4 35 (19.34%) Agile Software Development
5 31 (17.13%) Analytics
6 28 (15.47%) Migration
7 25 (13.81%) Data Analysis
8 19 (10.50%) Data Migration
9 17 (9.39%) Stakeholder Management
10 16 (8.84%) Service Delivery
11 14 (7.73%) Scrum
12 13 (7.18%) ETL Development
13 12 (6.63%) Capacity Planning
13 12 (6.63%) Non-Functional Testing
14 11 (6.08%) Data Analytics
14 11 (6.08%) Logical Data Model
14 11 (6.08%) Quality Management
14 11 (6.08%) SOA
14 11 (6.08%) Test Scripting
15 10 (5.52%) Performance Testing
Programming Languages
1 97 (53.59%) SQL
2 28 (15.47%) PL/SQL
3 10 (5.52%) VBA
4 8 (4.42%) T-SQL
5 5 (2.76%) Java
6 4 (2.21%) Perl
7 3 (1.66%) Python
7 3 (1.66%) Ruby
8 2 (1.10%) Bash Shell
8 2 (1.10%) Clojure
8 2 (1.10%) JavaScript
9 1 (0.55%) C#
9 1 (0.55%) C++
9 1 (0.55%) Scala
9 1 (0.55%) Shell Script
9 1 (0.55%) VB.NET
Qualifications
1 9 (4.97%) Security Cleared
2 6 (3.31%) Degree
3 4 (2.21%) ISEB
4 3 (1.66%) BPSS Clearance
5 2 (1.10%) ISTQB
5 2 (1.10%) ISTQB Foundation Certification
5 2 (1.10%) SC Cleared
Quality Assurance & Compliance
1 27 (14.92%) QA
2 14 (7.73%) Data Quality
3 8 (4.42%) FATCA
4 2 (1.10%) Disclosure Scotland
5 1 (0.55%) Basel III
5 1 (0.55%) Solvency II
System Software
1 1 (0.55%) Apache ZooKeeper
1 1 (0.55%) HDFS
1 1 (0.55%) Oracle RAC
1 1 (0.55%) VMware Infrastructure
Systems Management
1 9 (4.97%) HP Quality Center
2 2 (1.10%) Control-M
3 1 (0.55%) Hadoop YARN
Vendors
1 29 (16.02%) Oracle
2 25 (13.81%) MicroStrategy
3 22 (12.15%) Informatica
4 19 (10.50%) Microsoft
5 9 (4.97%) Cognos
6 8 (4.42%) MuleSoft
7 7 (3.87%) Ab Initio
7 7 (3.87%) Teradata
8 6 (3.31%) SAP
8 6 (3.31%) Tableau
9 5 (2.76%) IBM
10 4 (2.21%) Pega
11 2 (1.10%) HP
11 2 (1.10%) Netezza
11 2 (1.10%) Perforce
11 2 (1.10%) Trillium
11 2 (1.10%) Twitter
12 1 (0.55%) Cloudera
12 1 (0.55%) Hortonworks
12 1 (0.55%) Percona
Edinburgh, Midlothian
Jonathan Garth
Rate: Good Market Rates
Posted: 22 hours ago
Edinburgh, Midlothian
Sopra Steria Recruitment Limited
Rate: Market Rate
Posted: 23 hours ago
Edinburgh, Midlothian
Be-IT Resourcing
Posted: Yesterday
Glasgow, Lanarkshire
Sopra Steria Recruitment Limited
Posted: 3 days ago
Edinburgh, Midlothian
Hatstand Limited
Rate: £400 - £450 per day
Posted: 3 days ago
Edinburgh, Midlothian
TEKsystems
Rate: £350 - £375 per day
Posted: 4 days ago
Edinburgh
Cathcart Associates
Rate: £475 - £525 per day
Posted: 7 days ago
Glasgow
Hays Specialist Recruitment Ltd
Rate: £300.00 - £350 per day
Posted: 17 days ago