Period
to 21 February 2018

The following table provides summary statistics for permanent job vacancies advertised in Glasgow 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 6 months to 21 February 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
Scotland > Glasgow
6 months to
21 Feb 2018
Same period 2017 Same period 2016
Rank 75 39 41
Rank change year-on-year -36 +2 +42
Permanent jobs citing Data Warehouse 84 105 153
As % of all permanent IT jobs advertised in Glasgow 3.69% 5.57% 5.75%
As % of the Database & Business Intelligence category 10.23% 13.67% 15.44%
Number of salaries quoted 37 64 137
Glasgow median annual salary £47,500 £50,000 £47,500
Median salary % change year-on-year -5.00% +5.26% +11.76%
10th Percentile £37,500 £27,000 £31,250
90th Percentile £62,500 £58,750 £65,000
Scotland median annual salary £47,500 £50,000 £47,500
% change year-on-year -5.00% +5.26% +5.56%

Data Warehouse is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Glasgow with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Glasgow
Permanent vacancies with a requirement for database or business intelligence skills 821 768 991
As % of all permanent IT jobs advertised in Glasgow 36.04% 40.74% 37.21%
Number of salaries quoted 547 451 573
Glasgow median annual salary £47,500 £45,000 £40,000
Median salary % change year-on-year +5.56% +12.50% -
10th Percentile £32,000 £31,250 £28,750
90th Percentile £70,000 £61,250 £60,000
Scotland median annual salary £42,500 £42,500 £41,000
% change year-on-year - +3.66% +2.50%

Data Warehouse
Job Vacancy Trend in Glasgow

Job postings citing Data Warehouse as a percentage of all IT jobs advertised in Glasgow.

Job vacancy trend for Data Warehouse in Glasgow

Data Warehouse
Salary Trend in Glasgow

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

Salary trend for Data Warehouse in Glasgow

Data Warehouse
Salary Histogram in Glasgow

The salary distribution of IT jobs citing Data Warehouse in Glasgow over the 6 months to 21 February 2018.

Salary histogram for Data Warehouse in Glasgow

For the 6 months to 21 February 2018, IT jobs citing Data Warehouse also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Glasgow region with a requirement for Data Warehouse.

1 63 (75.00%) SQL
2 42 (50.00%) Business Intelligence
3 29 (34.52%) Machine Learning
4 28 (33.33%) Relational Database
5 27 (32.14%) Microsoft
6 26 (30.95%) Python
6 26 (30.95%) Data Science
7 24 (28.57%) ETL
8 23 (27.38%) Statistics
9 22 (26.19%) Agile Software Development
9 22 (26.19%) Algorithms
10 21 (25.00%) Analytics
10 21 (25.00%) Amazon Redshift
10 21 (25.00%) PostgreSQL
11 20 (23.81%) Finance
12 18 (21.43%) Oracle
13 14 (16.67%) SQL Server
13 14 (16.67%) Analytical Skills
13 14 (16.67%) Power BI
14 12 (14.29%) Data Analysis
14 12 (14.29%) SQL Server Integration Services
14 12 (14.29%) Big Data
15 11 (13.10%) SDLC
15 11 (13.10%) User Acceptance Testing
15 11 (13.10%) Data Modelling
16 10 (11.90%) Data Integration
16 10 (11.90%) Microsoft Azure
17 9 (10.71%) Data Quality
17 9 (10.71%) Data Analytics
17 9 (10.71%) SQL Server Reporting Services

Data Warehouse
Co-occurring IT Skills in Glasgow 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 3 (3.57%) Apache Spark
2 2 (2.38%) SAS
3 1 (1.19%) Tomcat
Applications
1 8 (9.52%) MS Visio
2 3 (3.57%) Mingle
3 2 (2.38%) Microsoft Excel
4 1 (1.19%) Microsoft Office
4 1 (1.19%) Microsoft PowerPoint
4 1 (1.19%) Microsoft Project
Cloud Services
1 10 (11.90%) Microsoft Azure
2 6 (7.14%) Azure Data Factory
3 5 (5.95%) Cloud Computing
4 2 (2.38%) Amazon AWS
Database & Business Intelligence
1 28 (33.33%) Relational Database
2 21 (25.00%) Amazon Redshift
2 21 (25.00%) PostgreSQL
3 14 (16.67%) Power BI
3 14 (16.67%) SQL Server
4 12 (14.29%) Big Data
4 12 (14.29%) SQL Server Integration Services
5 9 (10.71%) SQL Server Reporting Services
6 8 (9.52%) BusinessObjects
7 6 (7.14%) Data Lake
7 6 (7.14%) QlikView
8 5 (5.95%) Data Mining
8 5 (5.95%) SQL Server Analysis Services
9 4 (4.76%) BusinessObjects Business Intelligence
9 4 (4.76%) BusinessObjects Web Intelligence
9 4 (4.76%) Star Schema
10 3 (3.57%) GIS
10 3 (3.57%) Hadoop
10 3 (3.57%) Snowflake Schema
10 3 (3.57%) SQL Server 2012
Development Applications
1 3 (3.57%) Oracle Forms
1 3 (3.57%) Toad
2 1 (1.19%) ERwin
2 1 (1.19%) JIRA
2 1 (1.19%) SQL Server Management Studio (SSMS)
General
1 20 (23.81%) Finance
2 7 (8.33%) Marketing
3 6 (7.14%) Manufacturing
4 5 (5.95%) Electronics
4 5 (5.95%) Telecoms
5 4 (4.76%) Advertising
6 2 (2.38%) Retail
7 1 (1.19%) Banking
7 1 (1.19%) Front Office
7 1 (1.19%) Retail Banking
Job Titles
1 26 (30.95%) Data Scientist
2 16 (19.05%) Developer
3 13 (15.48%) Analyst
4 10 (11.90%) Business Analyst
5 5 (5.95%) Architect
5 5 (5.95%) Business Intelligence Developer
5 5 (5.95%) Business Systems Analyst
5 5 (5.95%) Data Warehouse Developer
5 5 (5.95%) DBA
5 5 (5.95%) Systems Analyst
6 4 (4.76%) Business Intelligence Specialist
6 4 (4.76%) Consultant
6 4 (4.76%) Data Architect
6 4 (4.76%) ETL Developer
6 4 (4.76%) SAP BusinessObjects Specialist
6 4 (4.76%) SQL DBA
6 4 (4.76%) Technical Analyst
6 4 (4.76%) Technical Business Analyst
7 3 (3.57%) Business Developer
7 3 (3.57%) SQL Developer
Libraries, Frameworks & Software Standards
1 1 (1.19%) Bokeh
1 1 (1.19%) MDX
1 1 (1.19%) Pandas
1 1 (1.19%) PySpark
1 1 (1.19%) SOAP
1 1 (1.19%) SparkR
Miscellaneous
1 22 (26.19%) Algorithms
2 14 (16.67%) Analytical Skills
3 3 (3.57%) FMCG
4 2 (2.38%) Social Media
5 1 (1.19%) Clustering
5 1 (1.19%) Credit Risk
5 1 (1.19%) Data Structures
5 1 (1.19%) Driving Licence
5 1 (1.19%) Hedge funds
5 1 (1.19%) Mainframe
5 1 (1.19%) Management Information System
Operating Systems
1 2 (2.38%) Unix
1 2 (2.38%) Windows
2 1 (1.19%) Windows 10
Processes & Methodologies
1 42 (50.00%) Business Intelligence
2 29 (34.52%) Machine Learning
3 26 (30.95%) Data Science
4 24 (28.57%) ETL
5 23 (27.38%) Statistics
6 22 (26.19%) Agile Software Development
7 21 (25.00%) Analytics
8 12 (14.29%) Data Analysis
9 11 (13.10%) Data Modelling
9 11 (13.10%) SDLC
9 11 (13.10%) User Acceptance Testing
10 10 (11.90%) Data Integration
11 9 (10.71%) Business Analysis
11 9 (10.71%) Data Analytics
12 8 (9.52%) Stakeholder Management
13 6 (7.14%) Data Engineering
13 6 (7.14%) Data Management
13 6 (7.14%) Project Management
14 5 (5.95%) Data Transformation
14 5 (5.95%) User Stories
Programming Languages
1 63 (75.00%) SQL
2 26 (30.95%) Python
3 9 (10.71%) T-SQL
4 6 (7.14%) R
5 5 (5.95%) PL/SQL
6 2 (2.38%) Scala
7 1 (1.19%) C#
7 1 (1.19%) HiveQL
7 1 (1.19%) Java
7 1 (1.19%) Perl
7 1 (1.19%) Shell Script
Qualifications
1 2 (2.38%) Degree
1 2 (2.38%) MCSA
1 2 (2.38%) Microsoft Certification
2 1 (1.19%) PRINCE2 Certification
Quality Assurance & Compliance
1 9 (10.71%) Data Quality
2 5 (5.95%) QA
3 1 (1.19%) Basel III
Vendors
1 27 (32.14%) Microsoft
2 18 (21.43%) Oracle
3 9 (10.71%) SAP
4 4 (4.76%) Informatica
5 3 (3.57%) BT
6 2 (2.38%) Cognos
6 2 (2.38%) IBM
6 2 (2.38%) MicroStrategy
6 2 (2.38%) Netezza
7 1 (1.19%) Tableau
7 1 (1.19%) Teradata