The table below looks at the statistics for Data Warehouse skills in IT contracts advertised for the Glasgow region. Included is a guide to the average contractor rates offered in IT contracts that have cited Data Warehouse over the 3 months to 29 April 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.

3 months to
29 Apr 2016
Same period 2015 Same period 2014
Data Warehousing
Rank 48 40 45
Rank change year-on-year
-8 +5
Contract jobs citing Data Warehouse 18 34 21
As % of all contract IT jobs located in Glasgow 2.71% 3.84% 2.97%
As % of the Database & Business Intelligence category 12.33% 14.66% 9.77%
Number of daily rates quoted 9 18 9
Average daily rate £325 £333 £375
Average daily rate % change year-on-year
-2.25% -11.33%
90% offered a daily rate of more than £300 £246 £319
10% offered a daily rate of more than £415 £436 £413
UK excluding London average daily rate £420 £400 £375
% change year-on-year
+5.00% +6.66%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate £23.00 £34.80 £55.00
% change year-on-year
-33.90% -36.72%
Data Warehouse
Scotland

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 Glasgow region.

Database & Business Intelligence Category
Glasgow
Contract IT job ads with a match in the
Database & Business Intelligence category
146 232 215
As % of all contract IT jobs located in Glasgow 22.02% 26.21% 30.37%
Number of daily rates quoted 88 132 123
Average daily rate £365 £369 £325
Average daily rate % change year-on-year
-1.01% +13.46%
90% offered a daily rate of more than £300 £263 £272
10% offered a daily rate of more than £425 £450 £413
UK excluding London average daily rate £388 £375 £350
% change year-on-year
+3.33% +7.14%
Number of hourly rates quoted 0 2 0
Average hourly rate - £33.75 -
UK excluding London average hourly rate £33.00 £32.10 £35.00
% change year-on-year
+2.80% -8.28%

Data Warehouse
Jobs Demand Trend in Glasgow

This chart provides a 3-month moving total of IT contractor jobs citing Data Warehouse across the Glasgow region as a proportion of the total demand within the Database & Business Intelligence category.

Data Warehouse Jobs Demand Trend in Glasgow

Data Warehouse
Daily Rate Trend in Glasgow

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

Data Warehouse Daily Rate Trend in Glasgow

Data Warehouse
Daily Rate Histogram in Glasgow

This chart provides a histogram of daily rates quoted in contract IT jobs citing Data Warehouse across the Glasgow region over the 3 months to 29 April 2016.

Data Warehouse Daily Rate Histogram in Glasgow

Data Warehouse
Hourly Rate Trend in Glasgow

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

Data Warehouse Hourly Rate Trend in Glasgow

Data Warehouse
Top 30 Related IT Skills in Glasgow

For the 6 months to 29 April 2016, IT contractor jobs across the Glasgow 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 46 (85.19%) SQL
2 39 (72.22%) Business Intelligence
3 24 (44.44%) ETL
3 24 (44.44%) MicroStrategy
4 23 (42.59%) Finance
5 22 (40.74%) QA
6 21 (38.89%) Agile Software Development
7 18 (33.33%) Data Modelling
7 18 (33.33%) Relational Database
8 16 (29.63%) PL/SQL
9 15 (27.78%) Data Analysis
10 12 (22.22%) Service Delivery
11 11 (20.37%) Oracle
11 11 (20.37%) Star Schema
11 11 (20.37%) Analytical Skills
12 10 (18.52%) MS Excel
12 10 (18.52%) MS Access
12 10 (18.52%) Capacity Planning
13 9 (16.67%) Security Cleared
13 9 (16.67%) RDBMS
13 9 (16.67%) Oracle Database
13 9 (16.67%) Analytics
14 8 (14.81%) Stakeholder Management
14 8 (14.81%) Data Quality
15 7 (12.96%) Quality Management
15 7 (12.96%) Migration
16 6 (11.11%) Data Stewardship
17 5 (9.26%) Kimball Methodology
17 5 (9.26%) ISEB
17 5 (9.26%) Unix

Data Warehouse
Top Related IT Skills in Glasgow by Category

For the 6 months to 29 April 2016, IT contractor jobs across the Glasgow 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 1 (1.85%) SAS
Applications
1 10 (18.52%) MS Excel
2 2 (3.70%) MS Office
Business Applications
1 1 (1.85%) Cognos Business Intelligence
1 1 (1.85%) Dynamics CRM
Database & Business Intelligence
1 18 (33.33%) Relational Database
2 11 (20.37%) Star Schema
3 10 (18.52%) MS Access
4 9 (16.67%) Oracle Database
4 9 (16.67%) RDBMS
5 4 (7.41%) NoSQL
5 4 (7.41%) SQL Server
5 4 (7.41%) SQL Server Integration Services
6 3 (5.56%) Oracle Reports
7 2 (3.70%) Cognos Report Studio
7 2 (3.70%) Oracle Database 10g
7 2 (3.70%) Oracle Database 11g
7 2 (3.70%) Oracle ODI
7 2 (3.70%) Oracle8/8i Database
7 2 (3.70%) Oracle9i Database
8 1 (1.85%) Business Intelligence Development Studio
8 1 (1.85%) Enterprise Data Warehouse
8 1 (1.85%) SQL Server 2005
8 1 (1.85%) SQL Server 2008
8 1 (1.85%) SQL Server 2012
Development Applications
1 3 (5.56%) Talend Open Studio
2 2 (3.70%) Git (software)
2 2 (3.70%) PVCS
2 2 (3.70%) Subversion
3 1 (1.85%) SQL Server Management Studio (SSMS)
General
1 23 (42.59%) Finance
2 4 (7.41%) Banking
3 2 (3.70%) General Ledger
4 1 (1.85%) Retail
4 1 (1.85%) Retail Banking
Job Titles
1 22 (40.74%) Analyst
2 12 (22.22%) Delivery Manager
3 10 (18.52%) Data Analyst
3 10 (18.52%) Data Warehouse Manager
4 8 (14.81%) Data Warehouse Analyst
4 8 (14.81%) Developer
5 7 (12.96%) ICT Manager
6 6 (11.11%) Business Analyst
6 6 (11.11%) Data Business Analyst
6 6 (11.11%) Information Analyst
7 4 (7.41%) Data Warehouse Business Analyst
7 4 (7.41%) SQL Analyst
7 4 (7.41%) SQL Data Analyst
8 3 (5.56%) Business Intelligence Manager
8 3 (5.56%) Data Manager
8 3 (5.56%) MicroStrategy Analyst
8 3 (5.56%) Senior Analyst
8 3 (5.56%) SQL Developer
9 2 (3.70%) Business Data Analyst
9 2 (3.70%) Senior Information Analyst
Libraries, Frameworks & Software Standards
1 1 (1.85%) .NET
1 1 (1.85%) ASP.NET
1 1 (1.85%) ASP.NET MVC
Miscellaneous
1 11 (20.37%) Analytical Skills
2 3 (5.56%) Management Information System
3 2 (3.70%) Credit Risk
3 2 (3.70%) Data Extraction
3 2 (3.70%) Data Structures
3 2 (3.70%) Derivative
3 2 (3.70%) Equities
3 2 (3.70%) Freedom of Information
Operating Systems
1 5 (9.26%) Unix
2 3 (5.56%) Linux
2 3 (5.56%) Mac OS X
Processes & Methodologies
1 39 (72.22%) Business Intelligence
2 24 (44.44%) ETL
3 21 (38.89%) Agile Software Development
4 18 (33.33%) Data Modelling
5 15 (27.78%) Data Analysis
6 12 (22.22%) Service Delivery
7 10 (18.52%) Capacity Planning
8 9 (16.67%) Analytics
9 8 (14.81%) Stakeholder Management
10 7 (12.96%) Migration
10 7 (12.96%) Quality Management
11 6 (11.11%) Data Stewardship
12 5 (9.26%) Continuous Improvement
12 5 (9.26%) Enterprise Architecture
12 5 (9.26%) Kimball Methodology
13 4 (7.41%) Data Architecture
13 4 (7.41%) Kanban
13 4 (7.41%) OOA/OOD
13 4 (7.41%) Scrum
13 4 (7.41%) TDD
Programming Languages
1 46 (85.19%) SQL
2 16 (29.63%) PL/SQL
3 3 (5.56%) Clojure
3 3 (5.56%) Java
3 3 (5.56%) JavaScript
3 3 (5.56%) Ruby
3 3 (5.56%) T-SQL
4 2 (3.70%) VBA
5 1 (1.85%) C#
Qualifications
1 9 (16.67%) Security Cleared
2 5 (9.26%) ISEB
3 2 (3.70%) BPSS Clearance
3 2 (3.70%) Degree
3 2 (3.70%) SC Cleared
4 1 (1.85%) ISTQB
4 1 (1.85%) ISTQB Foundation Certification
Quality Assurance & Compliance
1 22 (40.74%) QA
2 8 (14.81%) Data Quality
3 4 (7.41%) Disclosure Scotland
4 2 (3.70%) FATCA
Vendors
1 24 (44.44%) MicroStrategy
2 11 (20.37%) Oracle
3 4 (7.41%) Microsoft
4 3 (5.56%) Cognos
4 3 (5.56%) Talend
5 2 (3.70%) Twitter
6 1 (1.85%) IBM
6 1 (1.85%) Informatica
6 1 (1.85%) Trillium