Period
to 14 November 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 14 November 2018 with a comparison to the same period in the previous 2 years.

Data Warehousing
Scotland > Glasgow
6 months to
14 Nov 2018
Same period 2017 Same period 2016
Rank 65 57 60
Rank change year-on-year -8 +3 -17
Permanent jobs citing Data Warehouse 93 107 87
As % of all permanent IT jobs advertised in Glasgow 4.32% 4.67% 3.93%
As % of the Database & Business Intelligence category 10.70% 12.13% 10.14%
Number of salaries quoted 74 34 43
Glasgow median annual salary £50,000 £45,000 £50,000
Median salary % change year-on-year +11.11% -10.00% +5.26%
10th Percentile £37,500 £32,031 £36,500
90th Percentile £65,000 £58,750 £91,500
Scotland median annual salary £50,000 £45,000 £50,000
% change year-on-year +11.11% -10.00% +5.26%

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 869 882 858
As % of all permanent IT jobs advertised in Glasgow 40.40% 38.48% 38.75%
Number of salaries quoted 650 511 397
Glasgow median annual salary £47,500 £45,000 £42,500
Median salary % change year-on-year +5.56% +5.88% +1.19%
10th Percentile £32,500 £31,500 £28,900
90th Percentile £65,000 £70,000 £61,250
Scotland median annual salary £45,000 £41,750 £42,500
% change year-on-year +7.78% -1.76% +6.25%

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 14 November 2018.

Salary histogram for Data Warehouse in Glasgow

For the 6 months to 14 November 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 67 (72.04%) SQL
2 44 (47.31%) Data Modelling
3 41 (44.09%) Business Intelligence
4 35 (37.63%) SQL Server
5 31 (33.33%) ETL
5 31 (33.33%) Tableau
6 30 (32.26%) Agile Software Development
7 29 (31.18%) Analytical Skills
8 28 (30.11%) Visualisation
9 27 (29.03%) Data Visualisation
9 27 (29.03%) Analytics
9 27 (29.03%) Data Analysis
10 25 (26.88%) Cognos
11 24 (25.81%) Oracle
11 24 (25.81%) Finance
12 23 (24.73%) SDLC
13 22 (23.66%) Power BI
14 20 (21.51%) QA
15 19 (20.43%) Data Architecture
16 18 (19.35%) Microsoft Azure
17 17 (18.28%) QlikView
17 17 (18.28%) Relational Database
18 16 (17.20%) SQL Server Integration Services
18 16 (17.20%) Microsoft
19 15 (16.13%) Python
19 15 (16.13%) Big Data
19 15 (16.13%) Algorithms
19 15 (16.13%) Amazon AWS
20 14 (15.05%) Stakeholder Engagement
20 14 (15.05%) Stakeholder Management

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.23%) Oracle Workflow
1 3 (3.23%) Tomcat
1 3 (3.23%) WebLogic
2 2 (2.15%) JBoss
2 2 (2.15%) Oracle Application Server
2 2 (2.15%) Oracle SOA Suite
2 2 (2.15%) SAS
3 1 (1.08%) Apache Spark
3 1 (1.08%) Elasticsearch
Applications
1 13 (13.98%) Microsoft Excel
2 2 (2.15%) Microsoft Office
3 1 (1.08%) Microsoft PowerPoint
3 1 (1.08%) MS Visio
3 1 (1.08%) Spreadsheet
Business Applications
1 2 (2.15%) Cognos TM1
2 1 (1.08%) Cognos Business Intelligence
2 1 (1.08%) Oracle AML
Cloud Services
1 18 (19.35%) Microsoft Azure
2 15 (16.13%) Amazon AWS
3 1 (1.08%) Google Analytics
3 1 (1.08%) SaaS
Database & Business Intelligence
1 35 (37.63%) SQL Server
2 22 (23.66%) Power BI
3 17 (18.28%) QlikView
3 17 (18.28%) Relational Database
4 16 (17.20%) SQL Server Integration Services
5 15 (16.13%) Big Data
6 12 (12.90%) Data Mining
6 12 (12.90%) SQL Server Reporting Services
7 11 (11.83%) Qlik Sense
8 9 (9.68%) SQL Server 2012
9 7 (7.53%) BusinessObjects
9 7 (7.53%) Oracle Database
10 6 (6.45%) RDBMS
10 6 (6.45%) SQL Server Analysis Services
11 5 (5.38%) OLAP
11 5 (5.38%) OLTP
12 4 (4.30%) Enterprise Data Warehouse
13 3 (3.23%) Azure SQL Data Warehouse
13 3 (3.23%) Oracle OLAP
14 2 (2.15%) Spotfire
Development Applications
1 2 (2.15%) Oracle Forms
2 1 (1.08%) SQL Server Management Studio (SSMS)
2 1 (1.08%) Visual Studio
General
1 24 (25.81%) Finance
2 6 (6.45%) Banking
3 4 (4.30%) Investment Banking
3 4 (4.30%) Law
4 3 (3.23%) Retail
5 1 (1.08%) Legal
Job Titles
1 36 (38.71%) Developer
2 16 (17.20%) SQL Developer
3 14 (15.05%) Business Intelligence Consultant
3 14 (15.05%) Consultant
4 13 (13.98%) Analyst
4 13 (13.98%) Architect
5 11 (11.83%) QlikView Developer
6 10 (10.75%) Business Consultant
6 10 (10.75%) Data Architect
6 10 (10.75%) Solutions Architect
7 6 (6.45%) Senior Developer
7 6 (6.45%) Test Analyst
8 5 (5.38%) Business Intelligence Developer
9 4 (4.30%) Data Scientist
9 4 (4.30%) SQL Analyst
10 3 (3.23%) Head of Analytics
10 3 (3.23%) Head of Data Analytics
11 2 (2.15%) Business Intelligence Lead
11 2 (2.15%) Data Engineer
11 2 (2.15%) TM1 Developer
Libraries, Frameworks & Software Standards
1 11 (11.83%) HTML
2 8 (8.60%) CSS
2 8 (8.60%) HTML5
3 5 (5.38%) J2EE
3 5 (5.38%) Spring
4 2 (2.15%) OC4J
4 2 (2.15%) Web Services
5 1 (1.08%) .NET
5 1 (1.08%) ASP.NET
5 1 (1.08%) MDX
5 1 (1.08%) RESTful
Miscellaneous
1 29 (31.18%) Analytical Skills
2 15 (16.13%) Algorithms
3 12 (12.90%) Data Structures
4 3 (3.23%) User Experience
5 2 (2.15%) Greenfield Project
5 2 (2.15%) Management Information System
6 1 (1.08%) Computer Science
Operating Systems
1 10 (10.75%) Windows
2 2 (2.15%) AIX
2 2 (2.15%) Linux
2 2 (2.15%) Tru64
2 2 (2.15%) Unix
Processes & Methodologies
1 44 (47.31%) Data Modelling
2 41 (44.09%) Business Intelligence
3 31 (33.33%) ETL
4 30 (32.26%) Agile Software Development
5 28 (30.11%) Visualisation
6 27 (29.03%) Analytics
6 27 (29.03%) Data Analysis
6 27 (29.03%) Data Visualisation
7 23 (24.73%) SDLC
8 19 (20.43%) Data Architecture
9 14 (15.05%) Stakeholder Engagement
9 14 (15.05%) Stakeholder Management
10 13 (13.98%) Master Data Management
11 12 (12.90%) Waterfall
12 11 (11.83%) Collaborative Working
12 11 (11.83%) Digital Transformation Programme
12 11 (11.83%) Mentoring
12 11 (11.83%) Multithreaded Programming
12 11 (11.83%) Multithreading
13 10 (10.75%) Data Engineering
Programming Languages
1 67 (72.04%) SQL
2 15 (16.13%) Python
3 11 (11.83%) T-SQL
4 10 (10.75%) Bash Shell
4 10 (10.75%) PL/SQL
4 10 (10.75%) Scala
5 9 (9.68%) JavaScript
6 5 (5.38%) Java
6 5 (5.38%) R
7 2 (2.15%) SOQL
8 1 (1.08%) C#
8 1 (1.08%) VBA
Qualifications
1 12 (12.90%) Degree
2 4 (4.30%) ISTQB
2 4 (4.30%) ISTQB Foundation Certification
3 1 (1.08%) MCP
3 1 (1.08%) Microsoft Certification
3 1 (1.08%) Numerate Degree
Quality Assurance & Compliance
1 20 (21.51%) QA
2 12 (12.90%) Data Quality
System Software
1 2 (2.15%) Oracle RAC
Systems Management
1 2 (2.15%) Enterprise Manager Cloud Control
1 2 (2.15%) Oracle RMAN
1 2 (2.15%) Systems Management Server (SMS)
Vendors
1 31 (33.33%) Tableau
2 25 (26.88%) Cognos
3 24 (25.81%) Oracle
4 16 (17.20%) Microsoft
5 6 (6.45%) Cognizant
5 6 (6.45%) Informatica
5 6 (6.45%) MicroStrategy
6 4 (4.30%) IBM
7 3 (3.23%) SAP
8 2 (2.15%) Netezza
8 2 (2.15%) Salesforce.com
8 2 (2.15%) Talend
9 1 (1.08%) Alteryx
9 1 (1.08%) Google
9 1 (1.08%) OutlookSoft
9 1 (1.08%) Trillium
9 1 (1.08%) Twitter