The table below looks at the statistics for SQL Server Analysis Services skills in IT jobs advertised for the Scotland region. Included is a guide to the salaries offered in IT jobs that have cited SQL Server Analysis Services over the 3 months to 2 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
2 Dec 2016
Same period 2015 Same period 2014
Microsoft SQL Server Analysis Services (SSAS)
Rank 121 130 142
Rank change year-on-year
+9 +12
Permanent jobs citing SQL Server Analysis Services 13 37 25
As % of all permanent IT jobs located in Scotland 0.55% 1.18% 0.76%
As % of the Database & Business Intelligence category 1.74% 3.83% 2.28%
Number of salaries quoted 10 34 11
Median salary £38,750 £47,500 £47,500
Median salary % change year-on-year
-18.42% -
90% offered a salary of more than £32,100 £40,000 £27,500
10% offered a salary of more than £45,000 £47,500 £50,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%
SQL Server Analysis Services
UK

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the Scotland region.

Database & Business Intelligence Category
Scotland
Permanent IT job ads with a match in the
Database & Business Intelligence category
745 966 1098
As % of all permanent IT jobs located in Scotland 31.47% 30.88% 33.59%
Number of salaries quoted 477 634 748
Median salary £42,500 £42,500 £40,000
Median salary % change year-on-year
- +6.25%
90% offered a salary of more than £32,500 £32,500 £30,000
10% offered a salary of more than £62,700 £60,000 £55,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

SQL Server Analysis Services
Jobs Demand Trend in Scotland

The demand trend of job ads across the Scotland region citing SQL Server Analysis Services as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

SQL Server Analysis Services Jobs Demand Trend 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 across the Scotland region.

SQL Server Analysis Services Salary Trend in Scotland

SQL Server Analysis Services
Salary Histogram in Scotland

This chart provides a salary histogram for IT jobs citing SQL Server Analysis Services across the Scotland region over the 3 months to 2 December 2016.

SQL Server Analysis Services Salary Histogram 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 3 months to 2 December 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Glasgow +15 9 £40,000 -15.78% 2
Edinburgh -10 3 £40,000 -15.78%
West Lothian - 1 £32,500 -
SQL Server Analysis Services
UK

SQL Server Analysis Services
Top 30 Related IT Skills in Scotland

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

1 35 (100.00%) SQL Server Reporting Services
2 31 (88.57%) SQL Server
3 29 (82.86%) SQL Server Integration Services
4 25 (71.43%) SQL
5 24 (68.57%) Microsoft
6 20 (57.14%) Business Intelligence
7 16 (45.71%) MS Excel
8 15 (42.86%) Data Warehouse
8 15 (42.86%) T-SQL
9 12 (34.29%) SQL Server 2012
10 10 (28.57%) Power BI
11 9 (25.71%) SQL Server 2008
12 8 (22.86%) Performance Tuning
13 7 (20.00%) Tableau
13 7 (20.00%) Finance
13 7 (20.00%) Data Modelling
14 6 (17.14%) ETL
14 6 (17.14%) Microsoft Certification
14 6 (17.14%) Continuous Improvement
14 6 (17.14%) Capacity Planning
15 5 (14.29%) QlikView
15 5 (14.29%) Analytics
15 5 (14.29%) Mentoring
15 5 (14.29%) Windows Server
15 5 (14.29%) Windows
15 5 (14.29%) C#
15 5 (14.29%) Clustering
15 5 (14.29%) Agile Software Development
15 5 (14.29%) Marketing
16 4 (11.43%) OLAP

SQL Server Analysis Services
Top Related 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 3 (8.57%) SharePoint
2 1 (2.86%) SharePoint 2010
Applications
1 16 (45.71%) MS Excel
2 2 (5.71%) MS Office
2 2 (5.71%) S-PLUS
Business Applications
1 3 (8.57%) Dynamics CRM
Cloud Services
1 2 (5.71%) Google Analytics
1 2 (5.71%) Microsoft Azure
2 1 (2.86%) Google Cloud Platform
Database & Business Intelligence
1 35 (100.00%) SQL Server Reporting Services
2 31 (88.57%) SQL Server
3 29 (82.86%) SQL Server Integration Services
4 15 (42.86%) Data Warehouse
5 12 (34.29%) SQL Server 2012
6 10 (28.57%) Power BI
7 9 (25.71%) SQL Server 2008
8 5 (14.29%) QlikView
9 4 (11.43%) OLAP
9 4 (11.43%) SQL Server 2014
10 3 (8.57%) Microsoft Analysis Services
10 3 (8.57%) Relational Database
11 2 (5.71%) Data Mining
11 2 (5.71%) Sisense
12 1 (2.86%) BigQuery
12 1 (2.86%) OLTP
12 1 (2.86%) PowerPivot
12 1 (2.86%) SQL Server 2005
12 1 (2.86%) SQL Server 2016
Development Applications
1 2 (5.71%) Team Foundation Server
1 2 (5.71%) Visual Studio
General
1 7 (20.00%) Finance
2 5 (14.29%) Marketing
3 2 (5.71%) Banking
4 1 (2.86%) Advertising
4 1 (2.86%) Retail
Job Titles
1 14 (40.00%) Developer
2 11 (31.43%) Business Intelligence Developer
3 9 (25.71%) Team Leader
4 8 (22.86%) DBA
4 8 (22.86%) SQL DBA
5 5 (14.29%) Analyst
6 4 (11.43%) Business Developer
6 4 (11.43%) Technical Leader
7 3 (8.57%) Analyst Developer
7 3 (8.57%) Business Intelligence Analyst
7 3 (8.57%) SQL BI Developer
7 3 (8.57%) SQL Developer
8 2 (5.71%) Microsoft BI Developer
8 2 (5.71%) Microsoft Developer
8 2 (5.71%) Senior DBA
8 2 (5.71%) Senior SQL DBA
8 2 (5.71%) SQL Server BI Developer
8 2 (5.71%) SQL Server DBA
8 2 (5.71%) SQL Server Developer
9 1 (2.86%) Developer Analyst
Libraries, Frameworks & Software Standards
1 4 (11.43%) MDX
2 3 (8.57%) .NET
3 1 (2.86%) ASP.NET Web Forms
3 1 (2.86%) COM
3 1 (2.86%) CSS
3 1 (2.86%) HTML
Miscellaneous
1 5 (14.29%) Clustering
2 3 (8.57%) Analytical Skills
3 2 (5.71%) Data Integration
3 2 (5.71%) Enterprise Software
4 1 (2.86%) Computer Science
Operating Systems
1 5 (14.29%) Windows
1 5 (14.29%) Windows Server
Processes & Methodologies
1 20 (57.14%) Business Intelligence
2 8 (22.86%) Performance Tuning
3 7 (20.00%) Data Modelling
4 6 (17.14%) Capacity Planning
4 6 (17.14%) Continuous Improvement
4 6 (17.14%) ETL
5 5 (14.29%) Agile Software Development
5 5 (14.29%) Analytics
5 5 (14.29%) Mentoring
6 4 (11.43%) Data Transformation
6 4 (11.43%) Scrum
7 3 (8.57%) B2B
7 3 (8.57%) CRM
7 3 (8.57%) Data Analysis
7 3 (8.57%) Data Management
8 2 (5.71%) Dashboard Development
8 2 (5.71%) Data Analytics
8 2 (5.71%) Master Data Management
8 2 (5.71%) Performance Management
9 1 (2.86%) Web Development
Programming Languages
1 25 (71.43%) SQL
2 15 (42.86%) T-SQL
3 5 (14.29%) C#
4 1 (2.86%) JavaScript
4 1 (2.86%) R
Qualifications
1 6 (17.14%) Microsoft Certification
2 4 (11.43%) MCSA
2 4 (11.43%) MCSE
3 2 (5.71%) MCDBA
3 2 (5.71%) MCITP
4 1 (2.86%) Degree
Quality Assurance & Compliance
1 2 (5.71%) Data Quality
2 1 (2.86%) QA
Vendors
1 24 (68.57%) Microsoft
2 7 (20.00%) Tableau
3 2 (5.71%) Google