The following table provides summary statistics for permanent job vacancies advertised in Scotland with a requirement for Data Warehouse skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Warehouse over the 3 months to 25 March 2017 with a comparison to the same period in the previous 2 years.

3 months to
25 Mar 2017
Same period 2016 Same period 2015
Data Warehousing
UK / Scotland
Rank 58 65 68
Rank change year-on-year +7 +3  
Permanent jobs citing Data Warehouse 92 112 96
As % of all permanent IT jobs advertised in Scotland 3.97% 3.82% 3.10%
As % of the Database & Business Intelligence category 10.10% 12.58% 10.40%
Number of salaries quoted 51 64 69
Median salary £40,000 £47,500 £47,000
Median salary % change year-on-year -15.78% +1.06%  
90% offered a salary of more than £29,000 £37,500 £35,000
10% offered a salary of more than £62,500 £55,000 £67,500
UK excluding London median salary £45,000 £45,000 £43,000
% change year-on-year - +4.65%  

Data Warehouse is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Scotland with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
Scotland
Permanent job vacancies with a requirement for database and business intelligence skills 911 890 923
As % of all permanent IT job vacancies advertised in Scotland 39.27% 30.35% 29.85%
Number of salaries quoted 548 566 592
Median salary £42,500 £47,500 £40,000
Median salary % change year-on-year -10.52% +18.75%  
90% offered a salary of more than £31,500 £32,500 £32,000
10% offered a salary of more than £70,000 £55,000 £57,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

Data Warehouse
Job Vacancy Trend in Scotland

The job posting trend of jobs advertised in Scotland citing Data Warehouse as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for Data Warehouse in Scotland

Data Warehouse
Salary Trend in Scotland

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Warehouse in Scotland.

Salary trend for Data Warehouse in Scotland

Data Warehouse
Salary Histogram in Scotland

The salary distribution of IT jobs citing Data Warehouse in Scotland over the 3 months to 25 March 2017.

Salary histogram for Data Warehouse in Scotland

Data Warehouse
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Warehouse within the Scotland region over the 3 months to 25 March 2017. 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 Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Glasgow +29 73 £39,500 -16.84% 11
Edinburgh -53 16 £55,000 +15.78% 3
West Lothian - 2 £35,000 - 1
Scottish Borders - 1 £35,000 -
Data Warehouse
UK

Data Warehouse
Top 30 Related IT Skills in Scotland

For the 6 months to 25 March 2017, IT 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 job ads across the Scotland region with a requirement for Data Warehouse.

1 122 (71.76%) SQL
2 85 (50.00%) Business Intelligence
3 69 (40.59%) Finance
4 61 (35.88%) ETL
5 60 (35.29%) SQL Server
6 53 (31.18%) Data Modelling
7 52 (30.59%) SQL Server Integration Services
8 43 (25.29%) PL/SQL
9 42 (24.71%) Oracle
10 41 (24.12%) Agile Software Development
11 38 (22.35%) SQL Server Reporting Services
11 38 (22.35%) Analytical Skills
12 36 (21.18%) Relational Database
12 36 (21.18%) Microsoft
13 33 (19.41%) MS Excel
14 32 (18.82%) .NET
14 32 (18.82%) Analytics
15 31 (18.24%) C#
16 29 (17.06%) MicroStrategy
16 29 (17.06%) Data Management
17 28 (16.47%) Performance Tuning
18 27 (15.88%) RDBMS
19 25 (14.71%) BusinessObjects
19 25 (14.71%) XML
20 24 (14.12%) Unix
20 24 (14.12%) VBA
20 24 (14.12%) Data Integration
20 24 (14.12%) Git (software)
21 23 (13.53%) Investment Management
21 23 (13.53%) VB.NET

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 21 (12.35%) SAS
2 5 (2.94%) BizTalk Server
3 4 (2.35%) Apache Spark
4 3 (1.76%) Confluence
4 3 (1.76%) SharePoint
5 2 (1.18%) Apache
5 2 (1.18%) JBoss
5 2 (1.18%) Oracle SOA Suite
5 2 (1.18%) Tomcat
6 1 (0.59%) Apache Pig
Applications
1 33 (19.41%) MS Excel
2 2 (1.18%) MS Office
2 2 (1.18%) MS PowerPoint
3 1 (0.59%) Spreadsheet
Business Applications
1 2 (1.18%) Cognos Business Intelligence
1 2 (1.18%) Markit EDM
1 2 (1.18%) thinkFolio
Cloud Services
1 6 (3.53%) Amazon AWS
2 4 (2.35%) Microsoft Azure
2 4 (2.35%) SaaS
3 2 (1.18%) Amazon EMR
3 2 (1.18%) GitHub
3 2 (1.18%) IaaS
4 1 (0.59%) Cloud Computing
4 1 (0.59%) Google Analytics
Database & Business Intelligence
1 60 (35.29%) SQL Server
2 52 (30.59%) SQL Server Integration Services
3 38 (22.35%) SQL Server Reporting Services
4 36 (21.18%) Relational Database
5 27 (15.88%) RDBMS
6 25 (14.71%) BusinessObjects
7 22 (12.94%) Oracle Database
8 21 (12.35%) Big Data
9 17 (10.00%) BusinessObjects Web Intelligence
10 16 (9.41%) Oracle Database 11g
11 15 (8.82%) Oracle8/8i Database
12 14 (8.24%) Oracle Database 10g
13 13 (7.65%) Oracle9i Database
14 11 (6.47%) NoSQL
14 11 (6.47%) SAS Enterprise Guide
14 11 (6.47%) SQL Server 2012
15 10 (5.88%) DB2
15 10 (5.88%) Hadoop
16 9 (5.29%) SAS Data Integration Studio
16 9 (5.29%) SQL Server Analysis Services
Development Applications
1 24 (14.12%) Git (software)
2 21 (12.35%) Bitbucket
3 14 (8.24%) Talend Open Studio
4 13 (7.65%) PVCS
5 9 (5.29%) ERwin
6 8 (4.71%) Selenium
7 5 (2.94%) MagicDraw
7 5 (2.94%) Visual Studio
8 3 (1.76%) JIRA
8 3 (1.76%) Oracle Forms
8 3 (1.76%) Team Foundation Server
9 2 (1.18%) JBehave
9 2 (1.18%) Jenkins
9 2 (1.18%) Maven
General
1 69 (40.59%) Finance
2 17 (10.00%) Banking
3 6 (3.53%) Back Office
3 6 (3.53%) Retail
4 4 (2.35%) General Ledger
5 2 (1.18%) Retail Banking
6 1 (0.59%) Legal
Job Titles
1 84 (49.41%) Developer
2 32 (18.82%) SQL Developer
3 22 (12.94%) Database Developer
3 22 (12.94%) SQL Database Developer
4 21 (12.35%) C# Developer
5 20 (11.76%) Senior Developer
6 18 (10.59%) Oracle Developer
7 17 (10.00%) Architect
7 17 (10.00%) Business Intelligence Developer
7 17 (10.00%) SAP BusinessObjects (BO) Developer
8 16 (9.41%) Analyst
9 14 (8.24%) Consultant
10 13 (7.65%) DBA
10 13 (7.65%) Senior Oracle Developer
11 10 (5.88%) Business Intelligence Consultant
12 9 (5.29%) Administrator
12 9 (5.29%) Data Architect
13 7 (4.12%) Data Consultant
13 7 (4.12%) Data Warehouse Consultant
13 7 (4.12%) Senior Architect
Libraries, Frameworks & Software Standards
1 32 (18.82%) .NET
2 25 (14.71%) XML
3 22 (12.94%) ASP.NET
3 22 (12.94%) ASP.NET MVC
4 4 (2.35%) XML Schema
5 3 (1.76%) HTML
5 3 (1.76%) Kafka
6 2 (1.18%) ASP.NET Web Forms
6 2 (1.18%) CSS
6 2 (1.18%) Middleware
6 2 (1.18%) Spring
6 2 (1.18%) XMPP
7 1 (0.59%) ASP.NET Web API
7 1 (0.59%) Grails
7 1 (0.59%) J2EE
7 1 (0.59%) JDO
7 1 (0.59%) jQuery
7 1 (0.59%) RESTful
7 1 (0.59%) SOAP
7 1 (0.59%) Web Services
Miscellaneous
1 38 (22.35%) Analytical Skills
2 21 (12.35%) Credit Risk
2 21 (12.35%) Hedge funds
3 6 (3.53%) Management Information System
3 6 (3.53%) Reference Data
4 4 (2.35%) Taxonomies
5 3 (1.76%) Computer Science
5 3 (1.76%) Data Structures
6 2 (1.18%) Mainframe
6 2 (1.18%) Virtual Team
7 1 (0.59%) Clustering
7 1 (0.59%) Enterprise Software
Operating Systems
1 24 (14.12%) Unix
2 3 (1.76%) Linux
3 2 (1.18%) Red Hat Enterprise Linux
4 1 (0.59%) Windows
Processes & Methodologies
1 85 (50.00%) Business Intelligence
2 61 (35.88%) ETL
3 53 (31.18%) Data Modelling
4 41 (24.12%) Agile Software Development
5 32 (18.82%) Analytics
6 29 (17.06%) Data Management
7 28 (16.47%) Performance Tuning
8 24 (14.12%) Data Integration
9 23 (13.53%) Investment Management
9 23 (13.53%) MVC
10 22 (12.94%) Data Analysis
11 20 (11.76%) User Acceptance Testing
12 18 (10.59%) Infrastructure Management
13 17 (10.00%) Scorecard
13 17 (10.00%) Test Planning
14 15 (8.82%) Data Architecture
15 14 (8.24%) ETL Development
16 13 (7.65%) Metadata Management
17 12 (7.06%) Information Management
17 12 (7.06%) Waterfall
Programming Languages
1 122 (71.76%) SQL
2 43 (25.29%) PL/SQL
3 31 (18.24%) C#
4 24 (14.12%) VBA
5 23 (13.53%) VB.NET
6 22 (12.94%) T-SQL
7 12 (7.06%) Java
8 5 (2.94%) Python
9 4 (2.35%) PowerShell
10 3 (1.76%) JavaScript
10 3 (1.76%) Ruby
11 1 (0.59%) Bash Shell
11 1 (0.59%) C++
11 1 (0.59%) Groovy
11 1 (0.59%) Perl
11 1 (0.59%) Scala
Qualifications
1 14 (8.24%) Security Cleared
2 11 (6.47%) Degree
3 5 (2.94%) ISEB
3 5 (2.94%) MCITP
3 5 (2.94%) MCSA
3 5 (2.94%) MCSE
3 5 (2.94%) Microsoft Certification
4 1 (0.59%) ISTQB
Quality Assurance & Compliance
1 22 (12.94%) QA
2 21 (12.35%) Basel III
3 17 (10.00%) Data Quality
4 4 (2.35%) ISO20022
Systems Management
1 4 (2.35%) HP Quality Center
Vendors
1 42 (24.71%) Oracle
2 36 (21.18%) Microsoft
3 29 (17.06%) MicroStrategy
4 21 (12.35%) Perforce
5 15 (8.82%) Cognos
6 14 (8.24%) Talend
7 13 (7.65%) IBM
8 10 (5.88%) Netezza
9 8 (4.71%) Informatica
9 8 (4.71%) Teradata
10 7 (4.12%) Tableau
11 5 (2.94%) HP
11 5 (2.94%) Pega
12 4 (2.35%) SAP
13 3 (1.76%) DataFlux
14 2 (1.18%) CA Agile Central
14 2 (1.18%) Red Hat
14 2 (1.18%) Salesforce.com
15 1 (0.59%) Google
15 1 (0.59%) Remedy
Edinburgh, Midlothian
HAYS INFORMATION TECHNOLOGY
Salary: £35000.00 - £46000.00 per annum
Posted: Yesterday
Glasgow, Lanarkshire
Search Consultancy
Salary: Excellent Package Available
Posted: Yesterday
Glasgow, Lanarkshire
Morgan Mckinley
Salary: £20000 - £30000 per annum + Benefits
Posted: 2 days ago
Glasgow, Lanarkshire
Morgan Mckinley
Salary: £25000 - £30000 per annum
Posted: 4 days ago
Glasgow, Lanarkshire
Empiric.com
Salary: From £60,000 to £75,000 per annum Bonus and Benefits package
Posted: 2 days ago
Edinburgh, Midlothian
Search Consultancy
Salary: £40000.00 - £50000.00 per annum + benefits
Posted: 3 days ago
Edinburgh, Midlothian
Churchill Frank
Salary: £35000 - £50000 per annum + Bonus, Pension, SAS Training & More
Posted: 5 days ago
Glasgow, Lanarkshire
Durham Professional Services Limited
Salary: From £20,000 to £30,000 per annum
Posted: 5 days ago
Glasgow, Lanarkshire
Sopra Steria Recruitment
Salary: From £40,000 to £50,000 per annum Plus excellent benefits
Posted: 3 days ago
Glasgow, Lanarkshire
Net Talent
Salary: excellent package on offer
Posted: 4 days ago
Glasgow, Lanarkshire
Evolution Recruitment Solutions
Salary: 30k - 35k + bonus and benefits
Posted: 3 days ago
Bathgate
Hays Specialist Recruitment Ltd
Salary: £25000.00 - £35000.00 per annum
Posted: 9 days ago
Stirling, Stirlingshire
PRUDENTIAL
Posted: 8 days ago
Glasgow, Lanarkshire
HAYS INFORMATION TECHNOLOGY
Salary: £55000.00 - £61000.00 per annum
Posted: 3 days ago
Glasgow, Lanarkshire
HAYS INFORMATION TECHNOLOGY
Salary: £55000.00 - £61000.00 per annum
Posted: 5 days ago