Period
to 21 November 2017

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

Microsoft SQL Server Analysis Services (SSAS)
Scotland > Glasgow
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 126 118 122
Rank change year-on-year -8 +4 +8
Permanent jobs citing SQL Server Analysis Services 22 19 37
As % of all permanent IT jobs advertised in Glasgow 0.95% 0.88% 1.44%
As % of the Database & Business Intelligence category 2.49% 2.29% 3.75%
Number of salaries quoted 6 10 57
Glasgow median annual salary £42,500 £37,500 £47,500
Median salary % change year-on-year +13.33% -21.05% +18.75%
10th Percentile £34,750 £35,400 £40,250
90th Percentile £48,750 £48,000 £51,250
Scotland median annual salary £39,500 £41,421 £47,500
% change year-on-year -4.64% -12.80% +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 883 829 986
As % of all permanent IT jobs advertised in Glasgow 38.14% 38.43% 38.34%
Number of salaries quoted 512 403 613
Glasgow median annual salary £45,000 £42,500 £40,500
Median salary % change year-on-year +5.88% +4.94% +2.53%
10th Percentile £31,500 £29,050 £28,750
90th Percentile £67,500 £61,250 £60,000
Scotland median annual salary £42,500 £42,500 £40,000
% change year-on-year - +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 21 November 2017.

Salary histogram for SQL Server Analysis Services in Glasgow

For the 6 months to 21 November 2017, IT jobs citing SQL Server Analysis Services also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Glasgow region with a requirement for SQL Server Analysis Services.

1 20 (90.91%) SQL Server
2 19 (86.36%) SQL
3 18 (81.82%) Microsoft
3 18 (81.82%) SQL Server Integration Services
3 18 (81.82%) SQL Server Reporting Services
4 15 (68.18%) Business Intelligence
5 14 (63.64%) ETL
6 10 (45.45%) Performance Tuning
7 9 (40.91%) Data Warehouse
8 8 (36.36%) T-SQL
8 8 (36.36%) OLAP
9 6 (27.27%) SAS
9 6 (27.27%) RDBMS
9 6 (27.27%) Informatica
9 6 (27.27%) PowerCenter
9 6 (27.27%) MicroStrategy
9 6 (27.27%) QlikView
9 6 (27.27%) Data Integration
9 6 (27.27%) PowerShell
9 6 (27.27%) Agile Software Development
9 6 (27.27%) Relational Database
9 6 (27.27%) OLAP Cube
10 5 (22.73%) SAS Data Integration Studio
11 4 (18.18%) Advertising
12 3 (13.64%) Microsoft Certification
12 3 (13.64%) SharePoint
12 3 (13.64%) MCSA
13 2 (9.09%) Data Modelling
13 2 (9.09%) .NET
13 2 (9.09%) ERwin

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 6 (27.27%) SAS
2 3 (13.64%) SharePoint
Applications
1 1 (4.55%) Microsoft Office
Business Applications
1 2 (9.09%) Dynamics AX
2 1 (4.55%) Cognos Business Intelligence
Cloud Services
1 2 (9.09%) Microsoft Azure
Database & Business Intelligence
1 20 (90.91%) SQL Server
2 18 (81.82%) SQL Server Integration Services
2 18 (81.82%) SQL Server Reporting Services
3 9 (40.91%) Data Warehouse
4 8 (36.36%) OLAP
5 6 (27.27%) OLAP Cube
5 6 (27.27%) PowerCenter
5 6 (27.27%) QlikView
5 6 (27.27%) RDBMS
5 6 (27.27%) Relational Database
6 5 (22.73%) SAS Data Integration Studio
7 2 (9.09%) NoSQL
7 2 (9.09%) OLTP
7 2 (9.09%) Power BI
7 2 (9.09%) SQL Server 2016
8 1 (4.55%) Big Data
8 1 (4.55%) Snowflake Schema
8 1 (4.55%) SQL Server 2012
8 1 (4.55%) SQL Server 2014
8 1 (4.55%) Star Schema
Development Applications
1 2 (9.09%) ERwin
1 2 (9.09%) MorphX
1 2 (9.09%) SQL Server Management Studio (SSMS)
1 2 (9.09%) Team Foundation Server
2 1 (4.55%) Visual Studio
2 1 (4.55%) VSS/SourceSafe
General
1 4 (18.18%) Advertising
2 1 (4.55%) Finance
2 1 (4.55%) Marketing
Job Titles
1 16 (72.73%) Developer
2 12 (54.55%) Business Intelligence Developer
3 6 (27.27%) SAS BI Developer
3 6 (27.27%) SAS Developer
3 6 (27.27%) SSIS Developer
4 5 (22.73%) Informatica BI Developer
4 5 (22.73%) Informatica Developer
5 2 (9.09%) Analyst
5 2 (9.09%) Business Developer
5 2 (9.09%) Data Modeller
5 2 (9.09%) DBA
5 2 (9.09%) Dynamics AX Developer
5 2 (9.09%) ETL Developer
5 2 (9.09%) SQL DBA
6 1 (4.55%) Administrator
6 1 (4.55%) Business Analyst
6 1 (4.55%) Business Intelligence Analyst
6 1 (4.55%) Data Warehouse Developer
6 1 (4.55%) SQL Developer
6 1 (4.55%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 2 (9.09%) .NET
2 1 (4.55%) MDX
Miscellaneous
1 2 (9.09%) Data Structures
1 2 (9.09%) FMCG
2 1 (4.55%) Analytical Skills
Processes & Methodologies
1 15 (68.18%) Business Intelligence
2 14 (63.64%) ETL
3 10 (45.45%) Performance Tuning
4 6 (27.27%) Agile Software Development
4 6 (27.27%) Data Integration
5 2 (9.09%) Data Governance
5 2 (9.09%) Data Modelling
5 2 (9.09%) Data Protection
5 2 (9.09%) Stakeholder Management
6 1 (4.55%) Analytics
6 1 (4.55%) Data Cleansing
6 1 (4.55%) Data Migration
6 1 (4.55%) Disaster Recovery
6 1 (4.55%) ERP
6 1 (4.55%) ETL Development
6 1 (4.55%) Incident Management
6 1 (4.55%) ITIL
6 1 (4.55%) Migration
6 1 (4.55%) Performance Optimisation
6 1 (4.55%) Visualisation
Programming Languages
1 19 (86.36%) SQL
2 8 (36.36%) T-SQL
3 6 (27.27%) PowerShell
4 2 (9.09%) X++
Qualifications
1 3 (13.64%) MCSA
1 3 (13.64%) Microsoft Certification
2 1 (4.55%) Degree
Quality Assurance & Compliance
1 2 (9.09%) Data Quality
Vendors
1 18 (81.82%) Microsoft
2 6 (27.27%) Informatica
2 6 (27.27%) MicroStrategy
3 1 (4.55%) Cognos
3 1 (4.55%) Oracle
3 1 (4.55%) Salesforce.com