Period
to 26 September 2018

The following table provides summary statistics for permanent job vacancies advertised in Edinburgh 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 26 September 2018 with a comparison to the same period in the previous 2 years.

Microsoft SQL Server Analysis Services (SSAS)
Scotland > Edinburgh
6 months to
26 Sep 2018
Same period 2017 Same period 2016
Rank 126 134 111
Rank change year-on-year +8 -23 +28
Permanent jobs citing SQL Server Analysis Services 27 17 25
As % of all permanent IT jobs advertised in Edinburgh 1.07% 0.64% 1.07%
As % of the Database & Business Intelligence category 3.95% 1.86% 3.83%
Number of salaries quoted 21 10 12
Edinburgh median annual salary £40,000 £35,000 £49,750
Median salary % change year-on-year +14.29% -29.65% +4.74%
10th Percentile £32,500 £30,875 £37,563
90th Percentile £60,000 £55,375 £67,500
Scotland median annual salary £40,000 £35,000 £42,500
% change year-on-year +14.29% -17.65% -5.56%

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

All Database and Business Intelligence Skills
Edinburgh
Permanent vacancies with a requirement for database or business intelligence skills 683 915 652
As % of all permanent IT jobs advertised in Edinburgh 27.09% 34.44% 28.01%
Number of salaries quoted 487 579 424
Edinburgh median annual salary £45,000 £40,000 £45,000
Median salary % change year-on-year +12.50% -11.11% +12.50%
10th Percentile £28,000 £27,500 £27,150
90th Percentile £68,750 £65,000 £63,750
Scotland median annual salary £45,000 £41,250 £43,500
% change year-on-year +9.09% -5.17% +4.82%

SQL Server Analysis Services
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for SQL Server Analysis Services in Edinburgh

SQL Server Analysis Services
Salary Trend in Edinburgh

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

Salary trend for SQL Server Analysis Services in Edinburgh

SQL Server Analysis Services
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing SQL Server Analysis Services in Edinburgh over the 6 months to 26 September 2018.

Salary histogram for SQL Server Analysis Services in Edinburgh

For the 6 months to 26 September 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 Edinburgh region with a requirement for SQL Server Analysis Services.

1 27 (100.00%) SQL Server Integration Services
2 24 (88.89%) SQL Server Reporting Services
3 21 (77.78%) SQL Server
4 16 (59.26%) SQL
5 15 (55.56%) Microsoft
6 14 (51.85%) Business Intelligence
7 11 (40.74%) C#
8 8 (29.63%) Finance
9 7 (25.93%) JavaScript
9 7 (25.93%) T-SQL
9 7 (25.93%) .NET
9 7 (25.93%) Analytics
10 6 (22.22%) Data Modelling
10 6 (22.22%) Agile Software Development
11 5 (18.52%) Dynamics CRM
11 5 (18.52%) MVC
11 5 (18.52%) CRM
11 5 (18.52%) SharePoint
11 5 (18.52%) Data Warehouse
11 5 (18.52%) Visual Studio
11 5 (18.52%) ETL
11 5 (18.52%) SQL Server 2012
11 5 (18.52%) Microsoft Azure
11 5 (18.52%) Tableau
11 5 (18.52%) jQuery
11 5 (18.52%) Power BI
12 4 (14.81%) SQL Server 2014
12 4 (14.81%) SQL Server 2016
12 4 (14.81%) Marketing
12 4 (14.81%) Workflow

SQL Server Analysis Services
Co-occurring IT Skills in Edinburgh 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 (18.52%) SharePoint
Applications
1 2 (7.41%) SPSS
Business Applications
1 5 (18.52%) Dynamics CRM
2 1 (3.70%) Markit EDM
Cloud Services
1 5 (18.52%) Microsoft Azure
2 2 (7.41%) Amazon AWS
2 2 (7.41%) Google Analytics
3 1 (3.70%) Google Cloud Platform
Database & Business Intelligence
1 27 (100.00%) SQL Server Integration Services
2 24 (88.89%) SQL Server Reporting Services
3 21 (77.78%) SQL Server
4 5 (18.52%) Data Warehouse
4 5 (18.52%) Power BI
4 5 (18.52%) SQL Server 2012
5 4 (14.81%) SQL Server 2014
5 4 (14.81%) SQL Server 2016
6 3 (11.11%) SSDT
7 2 (7.41%) BusinessObjects
7 2 (7.41%) SQL Server 2008
8 1 (3.70%) BigQuery
8 1 (3.70%) Data Mining
8 1 (3.70%) Microsoft Analysis Services
8 1 (3.70%) Oracle Database
8 1 (3.70%) QlikView
Development Applications
1 5 (18.52%) Visual Studio
2 2 (7.41%) Team Foundation Server
General
1 8 (29.63%) Finance
2 4 (14.81%) Marketing
Job Titles
1 17 (62.96%) Developer
2 8 (29.63%) SQL Developer
3 7 (25.93%) Business Intelligence Developer
4 5 (18.52%) Business Developer
5 4 (14.81%) DBA
5 4 (14.81%) SQL DBA
5 4 (14.81%) Systems Developer
6 3 (11.11%) Consultant
6 3 (11.11%) Junior
6 3 (11.11%) T-SQL Developer
7 2 (7.41%) Administrator
7 2 (7.41%) Business Intelligence Consultant
7 2 (7.41%) Business Intelligence Lead
7 2 (7.41%) Data Scientist
7 2 (7.41%) Database Developer
7 2 (7.41%) Junior SQL Developer
7 2 (7.41%) Lead Developer
7 2 (7.41%) Senior Data Scientist
7 2 (7.41%) Software Developer
7 2 (7.41%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 7 (25.93%) .NET
2 5 (18.52%) jQuery
3 2 (7.41%) ASP.NET
4 1 (3.70%) .NET Framework
Miscellaneous
1 3 (11.11%) Fintech
2 2 (7.41%) Analytical Skills
2 2 (7.41%) Smartphone
3 1 (3.70%) Clustering
3 1 (3.70%) Enterprise Software
3 1 (3.70%) Replication
3 1 (3.70%) Virtual Team
Processes & Methodologies
1 14 (51.85%) Business Intelligence
2 7 (25.93%) Analytics
3 6 (22.22%) Agile Software Development
3 6 (22.22%) Data Modelling
4 5 (18.52%) CRM
4 5 (18.52%) ETL
4 5 (18.52%) MVC
5 4 (14.81%) Workflow
6 3 (11.11%) Data Visualisation
6 3 (11.11%) Performance Tuning
6 3 (11.11%) Visualisation
7 2 (7.41%) Data Cleansing
7 2 (7.41%) Data Integration
7 2 (7.41%) Data Science
7 2 (7.41%) Decision-Making
7 2 (7.41%) Digital Marketing
7 2 (7.41%) Machine Learning
7 2 (7.41%) Master Data Management
7 2 (7.41%) Problem-Solving
7 2 (7.41%) Scrum
Programming Languages
1 16 (59.26%) SQL
2 11 (40.74%) C#
3 7 (25.93%) JavaScript
3 7 (25.93%) T-SQL
4 3 (11.11%) R
5 2 (7.41%) MATLAB
5 2 (7.41%) Python
Qualifications
1 2 (7.41%) Degree
1 2 (7.41%) Microsoft Certification
2 1 (3.70%) MCSE
2 1 (3.70%) Numerate Degree
Quality Assurance & Compliance
1 2 (7.41%) Data Quality
Systems Management
1 2 (7.41%) Systems Management Server (SMS)
Vendors
1 15 (55.56%) Microsoft
2 5 (18.52%) Tableau
3 3 (11.11%) SAP
4 2 (7.41%) Google
4 2 (7.41%) Oracle