Period
to 22 May 2019

The following table provides summary statistics for permanent job vacancies advertised in Scotland 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 22 May 2019 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
UK > Scotland
6 months to
22 May 2019
Same period 2018 Same period 2017
Rank 160 165 175
Rank change year-on-year +5 +10 -13
Permanent jobs citing SQL Server Analysis Services 67 75 32
As % of all permanent IT jobs advertised in Scotland 1.27% 1.31% 0.68%
As % of the Database & Business Intelligence category 3.97% 4.05% 1.79%
Number of salaries quoted 58 54 15
Scotland median annual salary £45,500 £42,750 £35,000
Median salary % change year-on-year +6.43% +22.14% -26.32%
10th Percentile £36,750 £30,000 £27,500
90th Percentile £67,625 £52,500 £48,750
UK median annual salary £52,500 £50,000 £48,500
% change year-on-year +5.00% +3.09% +2.11%

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 Scotland with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Scotland
Permanent vacancies with a requirement for database or business intelligence skills 1,687 1,850 1,789
As % of all permanent IT jobs advertised in Scotland 31.97% 32.37% 38.22%
Number of salaries quoted 1,126 1,325 1,118
Scotland median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% -
10th Percentile £30,000 £30,000 £28,250
90th Percentile £65,000 £70,000 £69,300
UK median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +5.26% -

SQL Server Analysis Services
Job Vacancy Trend in Scotland

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

Job vacancy trend for SQL Server Analysis Services in Scotland

SQL Server Analysis Services
Salary Trend in Scotland

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

Salary trend for SQL Server Analysis Services in Scotland

SQL Server Analysis Services
Salary Histogram in Scotland

The salary distribution of IT jobs citing SQL Server Analysis Services in Scotland over the 6 months to 22 May 2019.

Salary histogram for SQL Server Analysis Services in Scotland

SQL Server Analysis Services
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing SQL Server Analysis Services within the Scotland region over the 6 months to 22 May 2019. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Glasgow +35 45 £45,500 +4.60%
Edinburgh -15 13 £45,000 +12.50% 2
South Lanarkshire +4 2 £45,000 +2.27%
Highlands - 2 £52,500 -
Aberdeen -3 1 £52,500 -
SQL Server Analysis Services
UK

For the 6 months to 22 May 2019, 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 Scotland region with a requirement for SQL Server Analysis Services.

1 63 (94.03%) SQL Server Reporting Services
2 62 (92.54%) SQL Server Integration Services
3 47 (70.15%) SQL Server
4 45 (67.16%) SQL
5 44 (65.67%) Business Intelligence
6 34 (50.75%) Visualisation
7 32 (47.76%) Power BI
7 32 (47.76%) Power Platform
8 26 (38.81%) Microsoft
8 26 (38.81%) Data Warehouse
9 25 (37.31%) Microsoft Azure
10 20 (29.85%) ETL
11 17 (25.37%) T-SQL
12 16 (23.88%) Analytics
13 15 (22.39%) Agile Software Development
14 14 (20.90%) QlikView
15 13 (19.40%) Performance Tuning
15 13 (19.40%) Data Engineering
16 11 (16.42%) Tableau
16 11 (16.42%) Finance
17 10 (14.93%) SQL Server 2012
17 10 (14.93%) Digital Transformation Programme
18 9 (13.43%) Analytical Skills
18 9 (13.43%) Data Management
18 9 (13.43%) Data Modelling
19 8 (11.94%) Oracle
20 7 (10.45%) C#
20 7 (10.45%) ERP
20 7 (10.45%) Microsoft Excel
20 7 (10.45%) Data Science

SQL Server Analysis Services
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 5 (7.46%) SharePoint
2 1 (1.49%) SAS
Applications
1 7 (10.45%) Microsoft Excel
2 3 (4.48%) Microsoft Office
Business Applications
1 4 (5.97%) Markit EDM
2 1 (1.49%) Dynamics CRM
Cloud Services
1 32 (47.76%) Power Platform
2 25 (37.31%) Microsoft Azure
3 5 (7.46%) Amazon AWS
3 5 (7.46%) Azure Data Factory
4 4 (5.97%) Cloud Computing
4 4 (5.97%) PaaS
5 2 (2.99%) Office 365
Database & Business Intelligence
1 63 (94.03%) SQL Server Reporting Services
2 62 (92.54%) SQL Server Integration Services
3 47 (70.15%) SQL Server
4 32 (47.76%) Power BI
5 26 (38.81%) Data Warehouse
6 14 (20.90%) QlikView
7 10 (14.93%) SQL Server 2012
8 6 (8.96%) SQL Server 2008
9 5 (7.46%) Azure SQL Database
9 5 (7.46%) Data Lake
9 5 (7.46%) Microsoft Analysis Services
9 5 (7.46%) OLAP
10 4 (5.97%) Data Mining
10 4 (5.97%) MS Access
10 4 (5.97%) NoSQL
10 4 (5.97%) Qlik Sense
10 4 (5.97%) SQL Server 2005
10 4 (5.97%) SQL Server 2016
11 3 (4.48%) Oracle Database
11 3 (4.48%) SQL Server 2014
Development Applications
1 5 (7.46%) Visual Studio
2 2 (2.99%) Git (software)
2 2 (2.99%) Subversion
2 2 (2.99%) Team Foundation Server
3 1 (1.49%) Oracle Forms
General
1 11 (16.42%) Finance
2 4 (5.97%) Back Office
3 1 (1.49%) Manufacturing
Job Titles
1 25 (37.31%) Developer
2 17 (25.37%) Business Intelligence Developer
3 10 (14.93%) Consultant
4 9 (13.43%) Team Leader
5 7 (10.45%) Data Engineer
5 7 (10.45%) SQL Developer
6 6 (8.96%) Business Intelligence Consultant
7 5 (7.46%) Business Consultant
7 5 (7.46%) Business Developer
8 4 (5.97%) Analytics Manager
8 4 (5.97%) Data Analytics Manager
8 4 (5.97%) Data Manager
8 4 (5.97%) DBA
8 4 (5.97%) SQL DBA
9 3 (4.48%) Head of Management Information
9 3 (4.48%) Lead Developer
9 3 (4.48%) Senior Developer
9 3 (4.48%) SQL BI Developer
10 2 (2.99%) Senior C# .NET Developer
10 2 (2.99%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 3 (4.48%) .NET
2 2 (2.99%) ASP.NET
3 1 (1.49%) .NET Framework
Miscellaneous
1 9 (13.43%) Analytical Skills
2 5 (7.46%) Self-Motivation
3 4 (5.97%) Management Information System
3 4 (5.97%) Market Risk
4 2 (2.99%) Clustering
4 2 (2.99%) Replication
5 1 (1.49%) Greenfield Project
5 1 (1.49%) Virtual Team
Operating Systems
1 3 (4.48%) Windows
Processes & Methodologies
1 44 (65.67%) Business Intelligence
2 34 (50.75%) Visualisation
3 20 (29.85%) ETL
4 16 (23.88%) Analytics
5 15 (22.39%) Agile Software Development
6 13 (19.40%) Data Engineering
6 13 (19.40%) Performance Tuning
7 10 (14.93%) Digital Transformation Programme
8 9 (13.43%) Data Management
8 9 (13.43%) Data Modelling
9 7 (10.45%) Data Science
9 7 (10.45%) ERP
10 6 (8.96%) Continuous Integration
10 6 (8.96%) Data Analysis
10 6 (8.96%) Data Transformation
11 4 (5.97%) Business Development
11 4 (5.97%) Data Visualisation
11 4 (5.97%) High Availability
11 4 (5.97%) Strategic Management
11 4 (5.97%) Use Case
Programming Languages
1 45 (67.16%) SQL
2 17 (25.37%) T-SQL
3 7 (10.45%) C#
4 6 (8.96%) R
5 4 (5.97%) Python
5 4 (5.97%) VBA
6 2 (2.99%) PL/SQL
Qualifications
1 4 (5.97%) MCTS
1 4 (5.97%) Microsoft Certification
2 2 (2.99%) Degree
2 2 (2.99%) MCAD
2 2 (2.99%) MCDBA
2 2 (2.99%) MCITP
2 2 (2.99%) MCSD
Quality Assurance & Compliance
1 5 (7.46%) Data Quality
2 2 (2.99%) GDPR
2 2 (2.99%) QA
Vendors
1 26 (38.81%) Microsoft
2 11 (16.42%) Tableau
3 8 (11.94%) Oracle
4 5 (7.46%) Databricks
5 4 (5.97%) Bloomberg
5 4 (5.97%) FactSet
5 4 (5.97%) SAP
6 2 (2.99%) Hyperion
6 2 (2.99%) Salesforce.com
7 1 (1.49%) Informatica
7 1 (1.49%) Teradata