Period
to 27 July 2021

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 27 July 2021 with a comparison to the same period in the previous 2 years.

Data Warehousing
Scotland > Glasgow
6 months to
27 Jul 2021
Same period 2020 Same period 2019
Rank 47 63 65
Rank change year-on-year +16 +2 +29
Permanent jobs citing Data Warehouse 68 22 78
As % of all permanent jobs advertised in Glasgow 4.79% 2.36% 4.12%
As % of the Database & Business Intelligence category 16.08% 7.33% 11.21%
Number of salaries quoted 45 11 61
10th Percentile £37,500 £38,750 £34,500
25th Percentile £37,750 £40,250 £40,000
Median annual salary (50th Percentile) £45,000 £43,500 £45,500
Median % change year-on-year +3.45% -4.40% +1.11%
75th Percentile £57,000 £50,750 £51,000
90th Percentile £70,000 £52,500 £56,250
Scotland median annual salary £50,000 £49,500 £45,500
% change year-on-year +1.01% +8.79% +1.11%

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 423 300 696
As % of all permanent IT jobs advertised in Glasgow 29.81% 32.22% 36.75%
Number of salaries quoted 290 195 496
10th Percentile £33,750 £32,500 £32,500
25th Percentile £37,500 £37,750 £36,250
Median annual salary (50th Percentile) £47,500 £45,000 £45,000
Median % change year-on-year +5.56% - -
75th Percentile £56,250 £53,750 £55,000
90th Percentile £70,000 £59,000 £65,000
Scotland median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - -

Data Warehouse
Job Vacancy Trend in Glasgow

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

Job vacancy trend for Data Warehouse in Glasgow

Data Warehouse
Salary Trend in Glasgow

3-month moving average salary quoted in jobs citing Data Warehouse in Glasgow.

Salary trend for Data Warehouse in Glasgow

Data Warehouse
Salary Histogram in Glasgow

Salary distribution for jobs citing Data Warehouse in Glasgow over the 6 months to 27 July 2021.

Salary histogram for Data Warehouse in Glasgow

For the 6 months to 27 July 2021, 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 51 (75.00%) Business Intelligence
2 49 (72.06%) SQL
3 39 (57.35%) SQL Server Integration Services
4 37 (54.41%) SQL Server Analysis Services
5 31 (45.59%) Azure
5 31 (45.59%) Data Modelling
5 31 (45.59%) ETL
6 30 (44.12%) Power BI
6 30 (44.12%) Power Platform
7 26 (38.24%) SQL Server
8 22 (32.35%) Microsoft
9 21 (30.88%) Analytics
10 20 (29.41%) Visualisation
11 17 (25.00%) Agile Software Development
12 16 (23.53%) Python
12 16 (23.53%) Finance
12 16 (23.53%) Data Visualisation
13 14 (20.59%) SQL Server Reporting Services
14 12 (17.65%) BusinessObjects
14 12 (17.65%) Data Lake
14 12 (17.65%) Social Skills
15 11 (16.18%) DataOps
15 11 (16.18%) SAP
15 11 (16.18%) PowerShell
16 9 (13.24%) Data Strategy
16 9 (13.24%) Problem-Solving
16 9 (13.24%) T-SQL
16 9 (13.24%) Microsoft Certification
16 9 (13.24%) Logistics
17 8 (11.76%) Business Analysis

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 2 (2.94%) SAS
2 1 (1.47%) Apache
2 1 (1.47%) Apache Spark
2 1 (1.47%) JBoss
2 1 (1.47%) Oracle SOA Suite
2 1 (1.47%) Tomcat
Applications
1 7 (10.29%) Microsoft Excel
Cloud Services
1 31 (45.59%) Azure
2 30 (44.12%) Power Platform
3 7 (10.29%) AWS
3 7 (10.29%) Azure Data Factory
4 3 (4.41%) Azure Synapse Analytics
4 3 (4.41%) Cloud Computing
5 2 (2.94%) GCP
5 2 (2.94%) IaaS
5 2 (2.94%) SaaS
6 1 (1.47%) Matillion
6 1 (1.47%) PaaS
6 1 (1.47%) Snowflake
Communications & Networking
1 2 (2.94%) DNS
1 2 (2.94%) OpenVPN
1 2 (2.94%) SSL
Database & Business Intelligence
1 39 (57.35%) SQL Server Integration Services
2 37 (54.41%) SQL Server Analysis Services
3 30 (44.12%) Power BI
4 26 (38.24%) SQL Server
5 14 (20.59%) SQL Server Reporting Services
6 12 (17.65%) BusinessObjects
6 12 (17.65%) Data Lake
7 8 (11.76%) Azure SQL Database
7 8 (11.76%) SSDT
8 6 (8.82%) Enterprise Data Warehouse
9 5 (7.35%) OLAP
9 5 (7.35%) OLAP Cube
10 4 (5.88%) Big Data
10 4 (5.88%) Hadoop
10 4 (5.88%) Metadata
10 4 (5.88%) MongoDB
10 4 (5.88%) PowerCenter
11 3 (4.41%) Tableau
12 2 (2.94%) Oracle Database
12 2 (2.94%) Qlik Sense
Development Applications
1 2 (2.94%) Git (software)
1 2 (2.94%) Jenkins
2 1 (1.47%) ER Studio
2 1 (1.47%) ERwin
2 1 (1.47%) Oracle Forms
General
1 16 (23.53%) Finance
2 12 (17.65%) Social Skills
3 5 (7.35%) Analytical Skills
3 5 (7.35%) Publishing
4 3 (4.41%) Games
4 3 (4.41%) Legal
5 2 (2.94%) Banking
5 2 (2.94%) Manufacturing
5 2 (2.94%) Public Sector
5 2 (2.94%) Retail
6 1 (1.47%) Local Government
Job Titles
1 31 (45.59%) Developer
2 24 (35.29%) Business Intelligence Developer
3 10 (14.71%) Business Developer
3 10 (14.71%) Data Engineer
3 10 (14.71%) SQL Developer
4 8 (11.76%) Designer
5 6 (8.82%) Architect
5 6 (8.82%) Consultant
5 6 (8.82%) SQL BI Developer
6 5 (7.35%) Solutions Designer
7 4 (5.88%) Data Architect
7 4 (5.88%) Informatica Designer
8 3 (4.41%) Business Intelligence Consultant
8 3 (4.41%) SQL Server Developer
8 3 (4.41%) T-SQL Developer
9 2 (2.94%) Database Developer
9 2 (2.94%) Python Engineer
9 2 (2.94%) SAS Consultant
9 2 (2.94%) Senior Data Engineer
10 1 (1.47%) Junior Data Engineer
Libraries, Frameworks & Software Standards
1 8 (11.76%) RESTful
1 8 (11.76%) Web Services
2 4 (5.88%) Kafka
3 3 (4.41%) .NET
4 2 (2.94%) Oracle Fusion
5 1 (1.47%) EDI
5 1 (1.47%) MDX
5 1 (1.47%) Middleware
Miscellaneous
1 5 (7.35%) FMCG
1 5 (7.35%) Legacy Systems
2 4 (5.88%) Self-Motivation
3 3 (4.41%) Virtual Team
4 2 (2.94%) Data Structures
4 2 (2.94%) Management Information System
5 1 (1.47%) Clustering
5 1 (1.47%) Legacy Code
5 1 (1.47%) Replication
5 1 (1.47%) Taxonomies
Operating Systems
1 3 (4.41%) Linux
2 1 (1.47%) Red Hat Enterprise Linux
Processes & Methodologies
1 51 (75.00%) Business Intelligence
2 31 (45.59%) Data Modelling
2 31 (45.59%) ETL
3 21 (30.88%) Analytics
4 20 (29.41%) Visualisation
5 17 (25.00%) Agile Software Development
6 16 (23.53%) Data Visualisation
7 11 (16.18%) DataOps
8 9 (13.24%) Data Strategy
8 9 (13.24%) Logistics
8 9 (13.24%) Problem-Solving
9 8 (11.76%) Business Analysis
9 8 (11.76%) Data Analysis
9 8 (11.76%) Performance Tuning
9 8 (11.76%) Project Delivery
9 8 (11.76%) SDLC
10 7 (10.29%) Data Analytics
10 7 (10.29%) Data Engineering
10 7 (10.29%) Data Management
10 7 (10.29%) DevOps
Programming Languages
1 49 (72.06%) SQL
2 16 (23.53%) Python
3 11 (16.18%) PowerShell
4 9 (13.24%) T-SQL
5 8 (11.76%) C#
6 6 (8.82%) Data Analysis Expressions (DAX)
7 4 (5.88%) Bash Shell
8 2 (2.94%) PL/SQL
8 2 (2.94%) R
8 2 (2.94%) VBA
9 1 (1.47%) Java
9 1 (1.47%) Scala
Qualifications
1 9 (13.24%) Microsoft Certification
2 4 (5.88%) Degree
3 1 (1.47%) Computer Science Degree
3 1 (1.47%) Tableau Certification
Quality Assurance & Compliance
1 6 (8.82%) Data Quality
2 3 (4.41%) GDPR
3 2 (2.94%) QA
System Software
1 2 (2.94%) Docker
Systems Management
1 2 (2.94%) Kubernetes
Vendors
1 22 (32.35%) Microsoft
2 11 (16.18%) SAP
3 7 (10.29%) Informatica
4 6 (8.82%) Oracle
5 4 (5.88%) StreamSets
6 2 (2.94%) Databricks
6 2 (2.94%) DataFlux
6 2 (2.94%) Google
6 2 (2.94%) Teradata
7 1 (1.47%) Alteryx
7 1 (1.47%) Netezza
7 1 (1.47%) Red Hat
7 1 (1.47%) Remedy
7 1 (1.47%) Talend