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 28 June 2017 with a comparison to the same period in the previous 2 years.

Data Warehousing
UK / Scotland
3 months to
28 Jun 2017
Same period 2016 Same period 2015
Rank 54 74 61
Rank change year-on-year +20 -13  
Permanent jobs citing Data Warehouse 113 99 108
As % of all permanent IT jobs advertised in Scotland 4.17% 3.45% 3.47%
As % of the Database & Business Intelligence category 11.28% 10.70% 10.21%
Number of salaries quoted 52 46 83
Median salary £50,000 £48,750 £45,000
Median salary % change year-on-year +2.56% +8.33%  
90% offered a salary of more than £33,050 £25,000 £32,500
10% offered a salary of more than £65,000 £60,500 £57,875
UK excluding London median salary £45,000 £45,000 £45,000

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 1002 925 1058
As % of all permanent IT job vacancies advertised in Scotland 36.97% 32.21% 33.98%
Number of salaries quoted 636 442 675
Median salary £42,500 £45,000 £42,500
Median salary % change year-on-year -5.55% +5.88%  
90% offered a salary of more than £30,000 £31,000 £30,000
10% offered a salary of more than £70,000 £60,000 £60,000
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

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 28 June 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 28 June 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 +18 69 £50,000 +2.56% 5
Edinburgh -9 43 £50,000 -8.25% 6
Stirling - 5 £45,000 - 1
West Lothian - 4 £37,500 -
Data Warehouse
UK

For the 6 months to 28 June 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 139 (67.80%) SQL
2 106 (51.71%) Business Intelligence
3 81 (39.51%) SQL Server
4 79 (38.54%) ETL
5 67 (32.68%) SQL Server Integration Services
6 57 (27.80%) Agile Software Development
7 55 (26.83%) Finance
8 51 (24.88%) Oracle
8 51 (24.88%) Relational Database
9 48 (23.41%) SQL Server Reporting Services
10 46 (22.44%) PL/SQL
10 46 (22.44%) Microsoft
11 36 (17.56%) RDBMS
12 35 (17.07%) T-SQL
13 34 (16.59%) Data Quality
14 33 (16.10%) Unix
14 33 (16.10%) Data Modelling
15 32 (15.61%) Analytics
16 31 (15.12%) Analytical Skills
16 31 (15.12%) C#
16 31 (15.12%) MVC
17 29 (14.15%) .NET
17 29 (14.15%) Investment Management
18 28 (13.66%) ASP.NET
18 28 (13.66%) Microsoft Excel
18 28 (13.66%) BusinessObjects
18 28 (13.66%) Big Data
18 28 (13.66%) ASP.NET MVC
19 27 (13.17%) Performance Tuning
19 27 (13.17%) Informatica

Data Warehouse
Co-occurring 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 22 (10.73%) SAS
2 12 (5.85%) Apache Spark
3 3 (1.46%) SharePoint
3 3 (1.46%) Tomcat
4 1 (0.49%) Confluence
Applications
1 28 (13.66%) Microsoft Excel
2 4 (1.95%) SPSS
3 3 (1.46%) Microsoft Office
4 2 (0.98%) Microsoft PowerPoint
5 1 (0.49%) MS Visio
Business Applications
1 4 (1.95%) Cognos Business Intelligence
2 1 (0.49%) Markit EDM
2 1 (0.49%) thinkFolio
Cloud Services
1 12 (5.85%) Microsoft Azure
2 7 (3.41%) Amazon AWS
3 2 (0.98%) Cloud Computing
3 2 (0.98%) SaaS
4 1 (0.49%) Azure Data Factory
4 1 (0.49%) Google Analytics
Database & Business Intelligence
1 81 (39.51%) SQL Server
2 67 (32.68%) SQL Server Integration Services
3 51 (24.88%) Relational Database
4 48 (23.41%) SQL Server Reporting Services
5 36 (17.56%) RDBMS
6 28 (13.66%) Big Data
6 28 (13.66%) BusinessObjects
7 21 (10.24%) Oracle Database
8 18 (8.78%) Oracle Database 11g
9 17 (8.29%) BusinessObjects Web Intelligence
10 16 (7.80%) NoSQL
10 16 (7.80%) Oracle Database 10g
11 15 (7.32%) Oracle8/8i Database
11 15 (7.32%) Oracle9i Database
11 15 (7.32%) SQL Server Analysis Services
12 14 (6.83%) SQL Server 2012
13 13 (6.34%) PowerCenter
14 12 (5.85%) DB2
15 11 (5.37%) DataStage
16 10 (4.88%) Hadoop
Development Applications
1 25 (12.20%) Git (software)
2 22 (10.73%) Bitbucket
3 16 (7.80%) Talend Open Studio
4 15 (7.32%) PVCS
5 10 (4.88%) Subversion
6 7 (3.41%) JUnit
6 7 (3.41%) Selenium
6 7 (3.41%) Team Foundation Server
6 7 (3.41%) tSQLt
7 6 (2.93%) JIRA
8 5 (2.44%) Maven
9 4 (1.95%) TeamCity
9 4 (1.95%) Visual Studio
10 3 (1.46%) Jenkins
11 1 (0.49%) Atlassian Bamboo
11 1 (0.49%) ClearCase
11 1 (0.49%) ERwin
General
1 55 (26.83%) Finance
2 9 (4.39%) Banking
3 5 (2.44%) Telecoms
4 4 (1.95%) Manufacturing
5 3 (1.46%) Investment Banking
6 2 (0.98%) Back Office
6 2 (0.98%) Local Government
6 2 (0.98%) Retail
7 1 (0.49%) Publishing
7 1 (0.49%) Retail Banking
Job Titles
1 120 (58.54%) Developer
2 43 (20.98%) SQL Developer
3 29 (14.15%) Database Developer
4 28 (13.66%) Consultant
4 28 (13.66%) SQL Database Developer
5 22 (10.73%) Business Intelligence Developer
5 22 (10.73%) C# Developer
5 22 (10.73%) Senior Developer
6 21 (10.24%) Oracle Developer
7 18 (8.78%) Analyst
7 18 (8.78%) Data Consultant
8 17 (8.29%) SAP BusinessObjects (BO) Developer
9 16 (7.80%) Data Warehouse Consultant
10 15 (7.32%) ETL Developer
10 15 (7.32%) Senior Oracle Developer
11 13 (6.34%) SQL Server Developer
12 12 (5.85%) ETL Consultant
13 11 (5.37%) Data Warehouse Developer
14 10 (4.88%) Big Data Consultant
14 10 (4.88%) Business Intelligence Consultant
Libraries, Frameworks & Software Standards
1 29 (14.15%) .NET
2 28 (13.66%) ASP.NET
2 28 (13.66%) ASP.NET MVC
3 23 (11.22%) XML
4 7 (3.41%) CSS
5 6 (2.93%) J2EE
5 6 (2.93%) Spring
6 5 (2.44%) ASP.NET Web Forms
6 5 (2.44%) HTML
6 5 (2.44%) jQuery
6 5 (2.44%) MLlib
6 5 (2.44%) NumPy
6 5 (2.44%) RESTful
6 5 (2.44%) SciPy
6 5 (2.44%) SOAP
6 5 (2.44%) Twitter Bootstrap
7 3 (1.46%) .NET Framework
7 3 (1.46%) Kafka
7 3 (1.46%) Middleware
7 3 (1.46%) Web Services
Miscellaneous
1 31 (15.12%) Analytical Skills
2 25 (12.20%) Credit Risk
3 22 (10.73%) Hedge funds
4 12 (5.85%) Computer Science
5 8 (3.90%) Management Information System
6 5 (2.44%) Driving Licence
7 3 (1.46%) Data Structures
7 3 (1.46%) FMCG
7 3 (1.46%) Mainframe
8 2 (0.98%) Algorithms
8 2 (0.98%) User Experience
9 1 (0.49%) Clustering
9 1 (0.49%) Enterprise Software
9 1 (0.49%) Greenfield Project
Operating Systems
1 33 (16.10%) Unix
2 11 (5.37%) Linux
3 3 (1.46%) Windows
Processes & Methodologies
1 106 (51.71%) Business Intelligence
2 79 (38.54%) ETL
3 57 (27.80%) Agile Software Development
4 33 (16.10%) Data Modelling
5 32 (15.61%) Analytics
6 31 (15.12%) MVC
7 29 (14.15%) Investment Management
8 27 (13.17%) Data Analysis
8 27 (13.17%) Information Management
8 27 (13.17%) Performance Tuning
9 24 (11.71%) Data Management
10 21 (10.24%) User Acceptance Testing
11 19 (9.27%) SDLC
12 18 (8.78%) Customer Engagement
13 17 (8.29%) Scorecard
13 17 (8.29%) Test Planning
14 15 (7.32%) Infrastructure Management
14 15 (7.32%) Master Data Management
14 15 (7.32%) Visualisation
15 14 (6.83%) Data Integration
Programming Languages
1 139 (67.80%) SQL
2 46 (22.44%) PL/SQL
3 35 (17.07%) T-SQL
4 31 (15.12%) C#
5 25 (12.20%) Java
6 23 (11.22%) VBA
7 22 (10.73%) VB.NET
8 13 (6.34%) Python
9 7 (3.41%) JavaScript
10 5 (2.44%) R
11 3 (1.46%) Perl
11 3 (1.46%) PowerShell
11 3 (1.46%) Ruby
11 3 (1.46%) Scala
12 2 (0.98%) Korn
13 1 (0.49%) C
13 1 (0.49%) MATLAB
13 1 (0.49%) PHP
13 1 (0.49%) SAS Macro
13 1 (0.49%) Shell Script
Qualifications
1 20 (9.76%) Degree
2 16 (7.80%) Security Cleared
3 2 (0.98%) Computer Science Degree
4 1 (0.49%) ISEB
4 1 (0.49%) ISTQB
4 1 (0.49%) Oracle Certification
4 1 (0.49%) PhD
Quality Assurance & Compliance
1 34 (16.59%) Data Quality
2 25 (12.20%) Basel III
2 25 (12.20%) QA
System Software
1 2 (0.98%) Docker
2 1 (0.49%) Apache Flume
2 1 (0.49%) HDFS
2 1 (0.49%) KVM
2 1 (0.49%) Virtual Machines
Vendors
1 51 (24.88%) Oracle
2 46 (22.44%) Microsoft
3 27 (13.17%) Informatica
4 26 (12.68%) MicroStrategy
5 21 (10.24%) Perforce
6 20 (9.76%) Cognos
7 16 (7.80%) Talend
8 15 (7.32%) Netezza
9 12 (5.85%) IBM
10 9 (4.39%) Tableau
11 6 (2.93%) Teradata
12 5 (2.44%) Cognizant
13 4 (1.95%) DataFlux
14 3 (1.46%) F5
14 3 (1.46%) Vertica
15 1 (0.49%) Google
15 1 (0.49%) Remedy
15 1 (0.49%) Salesforce.com
15 1 (0.49%) SAP
Glasgow, Lanarkshire
Eximius Group Limited
Posted: Yesterday
Edinburgh
Churchill Frank
Salary: £50000 per annum
Posted: Yesterday
Glasgow, Lanarkshire
Search Consultancy
Salary: £35000.00 - £45000.00 per annum + benefits
Posted: Yesterday
Glasgow, Lanarkshire
Search Consultancy
Salary: £40000.00 - £50000.00 per annum + excellent benefits
Posted: 2 days ago
Edinburgh, Midlothian
Eximius Group Limited
Posted: 5 days ago
Edinburgh, Midlothian
Capita Resourcing - IT Resourcing
Salary: £35000 - £45000.00 per annum
Posted: 6 days ago
Glasgow, Lanarkshire
Cognizant
Salary: Unspecified
Posted: 8 days ago
Glasgow
Call Centre Associates
Posted: 22 days ago
Edinburgh
Churchill Frank
Salary: £35000 - £50000 per annum
Posted: 19 days ago
Stirling
Cathcart Associates
Salary: £40000 - £60000 per annum + Benefits
Posted: 8 days ago