Period
to 24 April 2018

The following table provides summary statistics for permanent job vacancies advertised in Glasgow with a requirement for SQL Server Analysis Services skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL Server Analysis Services over the 6 months to 24 April 2018 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
Scotland > Glasgow
6 months to
24 Apr 2018
Same period 2017 Same period 2016
Rank 127 119 115
Rank change year-on-year -8 -4 +6
Permanent jobs citing SQL Server Analysis Services 40 8 47
As % of all permanent IT jobs advertised in Glasgow 1.61% 0.43% 1.79%
As % of the Database & Business Intelligence category 4.25% 0.93% 4.76%
Number of salaries quoted 31 1 70
Glasgow median annual salary £42,500 £35,000 £47,500
Median salary % change year-on-year +21.43% -26.32% +25.00%
10th Percentile £30,000 £35,000 £41,250
90th Percentile £48,750 £35,000 £51,250
Scotland median annual salary £42,500 £35,000 £47,500
% change year-on-year +21.43% -26.32% +18.75%

SQL Server Analysis Services 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 942 864 988
As % of all permanent IT jobs advertised in Glasgow 37.92% 45.91% 37.60%
Number of salaries quoted 676 491 540
Glasgow median annual salary £45,000 £45,000 £42,250
Median salary % change year-on-year - +6.51% +5.63%
10th Percentile £31,625 £29,000 £28,750
90th Percentile £72,500 £68,750 £63,750
Scotland median annual salary £45,000 £42,750 £42,500
% change year-on-year +5.26% +0.59% +6.25%

SQL Server Analysis Services
Job Vacancy Trend in Glasgow

Job postings citing SQL Server Analysis Services as a percentage of all IT jobs advertised in Glasgow.

Job vacancy trend for SQL Server Analysis Services in Glasgow

SQL Server Analysis Services
Salary Trend in Glasgow

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing SQL Server Analysis Services in Glasgow.

Salary trend for SQL Server Analysis Services in Glasgow

SQL Server Analysis Services
Salary Histogram in Glasgow

The salary distribution of IT jobs citing SQL Server Analysis Services in Glasgow over the 6 months to 24 April 2018.

Salary histogram for SQL Server Analysis Services in Glasgow

For the 6 months to 24 April 2018, IT jobs citing SQL Server Analysis Services 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 SQL Server Analysis Services.

1 40 (100.00%) SQL Server Integration Services
2 38 (95.00%) SQL
3 37 (92.50%) SQL Server
4 35 (87.50%) SQL Server Reporting Services
5 28 (70.00%) Microsoft
6 24 (60.00%) Business Intelligence
7 23 (57.50%) ETL
8 15 (37.50%) T-SQL
9 13 (32.50%) Microsoft Azure
10 12 (30.00%) Data Warehouse
11 11 (27.50%) Data Modelling
11 11 (27.50%) SharePoint
11 11 (27.50%) Power BI
12 10 (25.00%) Performance Tuning
12 10 (25.00%) Amazon AWS
12 10 (25.00%) Agile Software Development
12 10 (25.00%) Advertising
12 10 (25.00%) Stakeholder Management
13 9 (22.50%) Finance
13 9 (22.50%) PowerShell
14 8 (20.00%) Relational Database
14 8 (20.00%) RDBMS
15 7 (17.50%) Data Quality
15 7 (17.50%) Hadoop
15 7 (17.50%) QlikView
16 6 (15.00%) Data Integration
16 6 (15.00%) Big Data
16 6 (15.00%) Tableau
16 6 (15.00%) SQL Server 2016
16 6 (15.00%) ITIL

SQL Server Analysis Services
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 11 (27.50%) SharePoint
2 5 (12.50%) Apache Spark
Business Applications
1 5 (12.50%) Dynamics AX
Cloud Services
1 13 (32.50%) Microsoft Azure
2 10 (25.00%) Amazon AWS
3 3 (7.50%) Azure Data Factory
Database & Business Intelligence
1 40 (100.00%) SQL Server Integration Services
2 37 (92.50%) SQL Server
3 35 (87.50%) SQL Server Reporting Services
4 12 (30.00%) Data Warehouse
5 11 (27.50%) Power BI
6 8 (20.00%) RDBMS
6 8 (20.00%) Relational Database
7 7 (17.50%) Hadoop
7 7 (17.50%) QlikView
8 6 (15.00%) Big Data
8 6 (15.00%) SQL Server 2016
9 5 (12.50%) MySQL
9 5 (12.50%) Snowflake Schema
9 5 (12.50%) SQL Server 2012
9 5 (12.50%) Star Schema
10 4 (10.00%) PowerCenter
11 3 (7.50%) Azure SQL Data Warehouse
11 3 (7.50%) Azure SQL Database
11 3 (7.50%) Data Lake
11 3 (7.50%) SQL Server 2014
Development Applications
1 5 (12.50%) MorphX
2 1 (2.50%) Team Foundation Server
General
1 10 (25.00%) Advertising
2 9 (22.50%) Finance
3 2 (5.00%) Banking
4 1 (2.50%) Marketing
4 1 (2.50%) Retail
4 1 (2.50%) Retail Finance
4 1 (2.50%) Telecoms
Job Titles
1 15 (37.50%) Developer
2 7 (17.50%) Consultant
3 6 (15.00%) Analyst
4 5 (12.50%) DBA
4 5 (12.50%) Designer
4 5 (12.50%) Dynamics AX Developer
4 5 (12.50%) ETL Developer
4 5 (12.50%) SQL DBA
5 4 (10.00%) Business Intelligence Consultant
5 4 (10.00%) Business Intelligence Developer
5 4 (10.00%) SSIS Consultant
6 3 (7.50%) Data Engineer
7 2 (5.00%) Data Consultant
7 2 (5.00%) SQL Developer
7 2 (5.00%) SSRS Developer
8 1 (2.50%) Business Integration Analyst
8 1 (2.50%) Data Integration Analyst
8 1 (2.50%) Integration Analyst
8 1 (2.50%) Senior Business Intelligence Analyst
8 1 (2.50%) Senior Integration Analyst
Libraries, Frameworks & Software Standards
1 6 (15.00%) .NET
2 2 (5.00%) XML
3 1 (2.50%) MDX
Miscellaneous
1 5 (12.50%) Clustering
1 5 (12.50%) Data Centre
1 5 (12.50%) Greenfield Project
1 5 (12.50%) Replication
2 4 (10.00%) Reference Data
3 2 (5.00%) Driving Licence
4 1 (2.50%) Analytical Skills
4 1 (2.50%) Management Information System
Operating Systems
1 5 (12.50%) Windows
Processes & Methodologies
1 24 (60.00%) Business Intelligence
2 23 (57.50%) ETL
3 11 (27.50%) Data Modelling
4 10 (25.00%) Agile Software Development
4 10 (25.00%) Performance Tuning
4 10 (25.00%) Stakeholder Management
5 6 (15.00%) Data Integration
5 6 (15.00%) ITIL
6 5 (12.50%) Analytics
6 5 (12.50%) Change Management
6 5 (12.50%) Collaborative Working
6 5 (12.50%) Data Analysis
6 5 (12.50%) Database Tuning
6 5 (12.50%) DevOps
6 5 (12.50%) High Availability
6 5 (12.50%) Information Management
6 5 (12.50%) Statistics
6 5 (12.50%) Translating Business Requirements
7 4 (10.00%) Creative Thinking
7 4 (10.00%) Process Improvement
Programming Languages
1 38 (95.00%) SQL
2 15 (37.50%) T-SQL
3 9 (22.50%) PowerShell
4 5 (12.50%) X++
5 2 (5.00%) C#
6 1 (2.50%) Python
Quality Assurance & Compliance
1 7 (17.50%) Data Quality
System Software
1 5 (12.50%) Active Directory
2 2 (5.00%) HDFS
Vendors
1 28 (70.00%) Microsoft
2 6 (15.00%) Oracle
2 6 (15.00%) Tableau
3 5 (12.50%) IDERA
3 5 (12.50%) RedGate
3 5 (12.50%) SolarWinds
4 4 (10.00%) MicroStrategy
5 3 (7.50%) SAP