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 8 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
8 Feb 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 58 39 77
Rank change year-on-year
-19 +38
Contract jobs citing Data Warehouse 76 98 37
As % of all contract IT jobs located in Scotland 2.98% 3.63% 1.63%
As % of the Database & Business Intelligence category 14.50% 16.50% 7.27%
Number of daily rates quoted 55 65 10
Average daily rate £375 £375 £388
Average daily rate % change year-on-year
- -3.22%
90% offered a daily rate of more than £319 £298 £311
10% offered a daily rate of more than £500 £475 £466
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
524 594 509
As % of all contract IT jobs located in Scotland 20.54% 22.01% 22.44%
Number of daily rates quoted 300 348 244
Average daily rate £370 £375 £325
Average daily rate % change year-on-year
-1.33% +15.38%
90% offered a daily rate of more than £280 £275 £238
10% offered a daily rate of more than £500 £475 £450
UK excluding London average daily rate £375 £368 £350
% change year-on-year
+2.04% +5.00%
Number of hourly rates quoted 4 5 7
Average hourly rate £25.00 £47.50 £13.50
Average hourly rate % change year-on-year
-47.36% +251.85%
90% offered a hourly rate of more than £16.00 £22.50 £10.93
10% offered a hourly rate of more than £49.41 £47.50 £16.87
UK excluding London average hourly rate £29.00 £32.50 £27.75
% change year-on-year
-10.76% +17.11%

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 8 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 8 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 -22 41 £375 -1.31% 12
Glasgow +10 30 £360 -4.00% 5
Aberdeen - 3 £465 -
Stirling +7 1 - - 1
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 8 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 100 (55.56%) Finance
2 98 (54.44%) SQL
3 74 (41.11%) Business Intelligence
4 70 (38.89%) ETL
5 53 (29.44%) Banking
6 42 (23.33%) Data Modelling
7 41 (22.78%) Analytical Skills
8 34 (18.89%) Agile Software Development
9 32 (17.78%) Analytics
10 30 (16.67%) PL/SQL
10 30 (16.67%) Oracle
11 29 (16.11%) Migration
12 27 (15.00%) QA
13 25 (13.89%) Data Analysis
13 25 (13.89%) MicroStrategy
14 22 (12.22%) Informatica
15 20 (11.11%) Relational Database
16 19 (10.56%) Retail
16 19 (10.56%) Data Migration
17 18 (10.00%) Star Schema
17 18 (10.00%) Microsoft
17 18 (10.00%) Enterprise Data Warehouse
18 17 (9.44%) Stakeholder Management
19 16 (8.89%) Service Delivery
19 16 (8.89%) BusinessObjects
20 15 (8.33%) MS Excel
21 14 (7.78%) Data Integration
21 14 (7.78%) SQL Server
21 14 (7.78%) Scrum
22 13 (7.22%) MS Access

Data Warehouse
Top Related IT Skills in Scotland by Category

For the 6 months to 8 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.56%) SAS
2 2 (1.11%) Apache Pig
2 2 (1.11%) WebLogic
3 1 (0.56%) SharePoint
Applications
1 15 (8.33%) MS Excel
2 5 (2.78%) MS Project
3 4 (2.22%) MS Office
4 1 (0.56%) Spreadsheet
Business Applications
1 2 (1.11%) Cognos Business Intelligence
1 2 (1.11%) Maximo
1 2 (1.11%) Oracle EBS
2 1 (0.56%) Dynamics CRM
2 1 (0.56%) Markit EDM
2 1 (0.56%) thinkFolio
Cloud Services
1 5 (2.78%) Amazon AWS
Communications & Networking
1 1 (0.56%) HTTP
Database & Business Intelligence
1 20 (11.11%) Relational Database
2 18 (10.00%) Enterprise Data Warehouse
2 18 (10.00%) Star Schema
3 16 (8.89%) BusinessObjects
4 14 (7.78%) SQL Server
5 13 (7.22%) Data Mart
5 13 (7.22%) MS Access
6 10 (5.56%) Oracle Database
7 7 (3.89%) Oracle BI EE
7 7 (3.89%) RDBMS
7 7 (3.89%) SAP Data Services
8 6 (3.33%) Big Data
8 6 (3.33%) BusinessObjects Web Intelligence
8 6 (3.33%) DB2
8 6 (3.33%) SQL Server Integration Services
9 5 (2.78%) BusinessObjects XI
9 5 (2.78%) Hadoop
9 5 (2.78%) SQL Server 2012
10 4 (2.22%) DataStage
10 4 (2.22%) MySQL
Development Applications
1 8 (4.44%) FitNesse
1 8 (4.44%) JBehave
2 6 (3.33%) Toad
3 5 (2.78%) Cucumber
4 4 (2.22%) ERwin
4 4 (2.22%) HP UFT
5 3 (1.67%) Git (software)
5 3 (1.67%) Team Foundation Server
6 2 (1.11%) ClearCase
6 2 (1.11%) Subversion
6 2 (1.11%) Visual Studio Tools for Office
7 1 (0.56%) SQL Server Management Studio (SSMS)
General
1 100 (55.56%) Finance
2 53 (29.44%) Banking
3 19 (10.56%) Retail
4 13 (7.22%) Retail Banking
5 7 (3.89%) General Ledger
5 7 (3.89%) Investment Banking
6 4 (2.22%) Private Banking
6 4 (2.22%) Telecoms
7 2 (1.11%) Advertising
7 2 (1.11%) Law
7 2 (1.11%) Legal
7 2 (1.11%) Marketing
8 1 (0.56%) Manufacturing
Job Titles
1 74 (41.11%) Analyst
2 29 (16.11%) Developer
3 24 (13.33%) Test Analyst
4 20 (11.11%) Senior Analyst
5 17 (9.44%) Data Analyst
6 16 (8.89%) Business Analyst
6 16 (8.89%) Data Warehouse Manager
7 15 (8.33%) Delivery Manager
8 14 (7.78%) Architect
8 14 (7.78%) Senior Test Analyst
9 10 (5.56%) Consultant
10 9 (5.00%) Data Business Analyst
10 9 (5.00%) ICT Manager
10 9 (5.00%) Solutions Architect
10 9 (5.00%) Technical Analyst
11 8 (4.44%) Data Modeller
12 7 (3.89%) Data Warehouse Analyst
12 7 (3.89%) Oracle Developer
12 7 (3.89%) SQL Analyst
12 7 (3.89%) Test Manager
Libraries, Frameworks & Software Standards
1 4 (2.22%) Web Services
2 3 (1.67%) SOAP
3 2 (1.11%) MDX
3 2 (1.11%) Middleware
4 1 (0.56%) .NET
4 1 (0.56%) ActiveMQ
4 1 (0.56%) JSON
4 1 (0.56%) LAMP
4 1 (0.56%) Oracle Fusion
4 1 (0.56%) RESTful
4 1 (0.56%) Spring
4 1 (0.56%) Velocity
4 1 (0.56%) XML
Miscellaneous
1 41 (22.78%) Analytical Skills
2 14 (7.78%) Data Integration
3 7 (3.89%) Data Extraction
4 6 (3.33%) Management Information System
5 4 (2.22%) Data Structures
5 4 (2.22%) Derivative
5 4 (2.22%) Equities
6 3 (1.67%) Data Centre
7 2 (1.11%) Computer Science
7 2 (1.11%) Freedom of Information
7 2 (1.11%) Mathematics
7 2 (1.11%) Reference Data
7 2 (1.11%) Visualisation
8 1 (0.56%) Algorithms
8 1 (0.56%) Clustering
8 1 (0.56%) Economics
8 1 (0.56%) Replication
Operating Systems
1 7 (3.89%) Linux
2 4 (2.22%) Unix
3 2 (1.11%) Mac OS X
4 1 (0.56%) Red Hat Enterprise Linux
Processes & Methodologies
1 74 (41.11%) Business Intelligence
2 70 (38.89%) ETL
3 42 (23.33%) Data Modelling
4 34 (18.89%) Agile Software Development
5 32 (17.78%) Analytics
6 29 (16.11%) Migration
7 25 (13.89%) Data Analysis
8 19 (10.56%) Data Migration
9 17 (9.44%) Stakeholder Management
10 16 (8.89%) Service Delivery
11 14 (7.78%) Scrum
12 13 (7.22%) ETL Development
13 12 (6.67%) Capacity Planning
13 12 (6.67%) Non-Functional Testing
14 11 (6.11%) Data Analytics
14 11 (6.11%) Logical Data Model
14 11 (6.11%) Quality Management
14 11 (6.11%) SOA
14 11 (6.11%) Test Scripting
15 10 (5.56%) Performance Testing
Programming Languages
1 98 (54.44%) SQL
2 30 (16.67%) PL/SQL
3 10 (5.56%) VBA
4 9 (5.00%) T-SQL
5 5 (2.78%) Java
6 4 (2.22%) Perl
7 3 (1.67%) Python
7 3 (1.67%) Ruby
8 2 (1.11%) Bash Shell
8 2 (1.11%) Clojure
8 2 (1.11%) JavaScript
9 1 (0.56%) C#
9 1 (0.56%) C++
9 1 (0.56%) Scala
9 1 (0.56%) Shell Script
9 1 (0.56%) VB.NET
Qualifications
1 9 (5.00%) Security Cleared
2 6 (3.33%) Degree
3 4 (2.22%) ISEB
4 3 (1.67%) BPSS Clearance
5 2 (1.11%) ISTQB
5 2 (1.11%) ISTQB Foundation Certification
5 2 (1.11%) SC Cleared
Quality Assurance & Compliance
1 27 (15.00%) QA
2 13 (7.22%) Data Quality
3 8 (4.44%) FATCA
4 2 (1.11%) Disclosure Scotland
5 1 (0.56%) Basel III
5 1 (0.56%) Solvency II
System Software
1 1 (0.56%) Apache ZooKeeper
1 1 (0.56%) HDFS
1 1 (0.56%) Oracle RAC
1 1 (0.56%) VMware Infrastructure
Systems Management
1 9 (5.00%) HP Quality Center
2 2 (1.11%) Control-M
3 1 (0.56%) Hadoop YARN
Vendors
1 30 (16.67%) Oracle
2 25 (13.89%) MicroStrategy
3 22 (12.22%) Informatica
4 18 (10.00%) Microsoft
5 9 (5.00%) Cognos
6 8 (4.44%) MuleSoft
7 7 (3.89%) Ab Initio
7 7 (3.89%) Teradata
8 6 (3.33%) SAP
8 6 (3.33%) Tableau
9 5 (2.78%) IBM
10 4 (2.22%) Pega
11 2 (1.11%) HP
11 2 (1.11%) Netezza
11 2 (1.11%) Perforce
11 2 (1.11%) Trillium
11 2 (1.11%) Twitter
12 1 (0.56%) Cloudera
12 1 (0.56%) Hortonworks
12 1 (0.56%) MapR
Edinburgh, Midlothian
TEKsystems
Rate: £350 - £375 per day
Posted: 11 hours ago
Edinburgh, Midlothian
Cathcart Associates Ltd
Rate: £475 - £525 per day
Posted: 3 days ago
Edinburgh, Midlothian
Be-IT Resourcing
Posted: 4 days ago
Scotland
McGregor Boyall
Posted: 5 days ago
Stirlingshire
Search Consultancy
Rate: DOE
Posted: 5 days ago
Glasgow
Hays Specialist Recruitment Ltd
Rate: £300.00 - £350 per day
Posted: 13 days ago