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 25 June 2016 with a comparison to the same period over the previous 2 years.

3 months to
25 Jun 2016
Same period 2015 Same period 2014
Microsoft SQL Server Analysis Services (SSAS)
Rank 127 137 119
Rank change year-on-year
+10 -18
Permanent jobs citing SQL Server Analysis Services 35 31 59
As % of all permanent IT jobs located in Scotland 1.24% 0.99% 1.54%
As % of the Database & Business Intelligence category 3.85% 2.91% 4.66%
Number of salaries quoted 15 25 40
Median salary £41,421 £42,500 £37,500
Median salary % change year-on-year
-2.53% +13.33%
90% offered a salary of more than £31,500 £32,500 £26,000
10% offered a salary of more than £53,700 £55,000 £47,500
UK excluding London median salary £42,500 £42,500 £41,000
% change year-on-year
- +3.65%
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
908 1067 1266
As % of all permanent IT jobs located in Scotland 32.04% 33.93% 33.06%
Number of salaries quoted 427 675 878
Median salary £45,000 £42,500 £42,500
Median salary % change year-on-year
+5.88% -
90% offered a salary of more than £31,000 £30,700 £30,000
10% offered a salary of more than £60,000 £57,500 £60,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 25 June 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 25 June 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 -7 17 £37,500 -9.09% 2
Edinburgh +23 16 £45,000 -5.26% 3
Falkirk - 1 £37,500 -
SQL Server Analysis Services
UK

SQL Server Analysis Services
Top 30 Related IT Skills in Scotland

For the 6 months to 25 June 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 72 (97.30%) SQL Server Reporting Services
2 61 (82.43%) SQL Server Integration Services
3 54 (72.97%) Business Intelligence
4 49 (66.22%) SQL Server
5 44 (59.46%) SQL
6 32 (43.24%) Data Warehouse
6 32 (43.24%) Microsoft
7 23 (31.08%) MS Excel
8 22 (29.73%) T-SQL
8 22 (29.73%) QlikView
9 21 (28.38%) Agile Software Development
10 20 (27.03%) SharePoint
11 18 (24.32%) ETL
12 17 (22.97%) Data Management
12 17 (22.97%) Data Quality
13 16 (21.62%) SQL Server 2012
13 16 (21.62%) Visualisation
14 15 (20.27%) SQL Server 2008
15 14 (18.92%) Finance
15 14 (18.92%) Windows
16 13 (17.57%) Cognos
16 13 (17.57%) Stakeholder Management
16 13 (17.57%) BusinessObjects
17 12 (16.22%) PRINCE2
17 12 (16.22%) Talend Open Studio
17 12 (16.22%) PRINCE2 Practitioner
17 12 (16.22%) Security Cleared
17 12 (16.22%) Enterprise Data Management
17 12 (16.22%) Talend
18 11 (14.86%) Windows Server

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 20 (27.03%) SharePoint
2 8 (10.81%) SharePoint 2010
3 2 (2.70%) MS Project Server
3 2 (2.70%) SAS
4 1 (1.35%) SharePoint 2013
Applications
1 23 (31.08%) MS Excel
2 7 (9.46%) MS Office
3 2 (2.70%) MS Project
3 2 (2.70%) Spreadsheet
Business Applications
1 3 (4.05%) Dynamics AX
1 3 (4.05%) Markit EDM
2 1 (1.35%) Dynamics CRM
Cloud Services
1 4 (5.41%) Microsoft Azure
2 3 (4.05%) Amazon AWS
2 3 (4.05%) Google Analytics
3 1 (1.35%) Google Cloud Platform
Database & Business Intelligence
1 72 (97.30%) SQL Server Reporting Services
2 61 (82.43%) SQL Server Integration Services
3 49 (66.22%) SQL Server
4 32 (43.24%) Data Warehouse
5 22 (29.73%) QlikView
6 16 (21.62%) SQL Server 2012
7 15 (20.27%) SQL Server 2008
8 13 (17.57%) BusinessObjects
9 5 (6.76%) SQL Server 2014
10 4 (5.41%) OLAP
10 4 (5.41%) Power BI
10 4 (5.41%) SQL Server 2016
11 3 (4.05%) OLTP
12 2 (2.70%) Enterprise Data Warehouse
12 2 (2.70%) MS Access
12 2 (2.70%) SQL Server 2005
13 1 (1.35%) BigQuery
13 1 (1.35%) OLAP Cube
13 1 (1.35%) Oracle ODI
13 1 (1.35%) Sisense
Development Applications
1 12 (16.22%) Talend Open Studio
2 8 (10.81%) Visual Studio
3 3 (4.05%) Team Foundation Server
4 2 (2.70%) Git (software)
4 2 (2.70%) SQL Server Management Studio (SSMS)
5 1 (1.35%) MorphX
General
1 14 (18.92%) Finance
2 9 (12.16%) Banking
2 9 (12.16%) Marketing
3 3 (4.05%) Investment Banking
4 2 (2.70%) Retail
5 1 (1.35%) Legal
5 1 (1.35%) Manufacturing
Job Titles
1 53 (71.62%) Developer
2 32 (43.24%) Business Intelligence Developer
3 14 (18.92%) SQL Developer
4 13 (17.57%) Business Intelligence Consultant
4 13 (17.57%) Consultant
5 9 (12.16%) Team Leader
6 6 (8.11%) DBA
6 6 (8.11%) Senior Developer
6 6 (8.11%) SQL DBA
7 5 (6.76%) Administrator
7 5 (6.76%) Analyst
7 5 (6.76%) Software Developer
8 3 (4.05%) Analyst Developer
8 3 (4.05%) Business Developer
8 3 (4.05%) Business Intelligence Analyst
8 3 (4.05%) C# Developer
8 3 (4.05%) C# Software Developer
8 3 (4.05%) Senior Software Developer
8 3 (4.05%) Senior SQL Developer
8 3 (4.05%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 11 (14.86%) .NET
2 6 (8.11%) ASP.NET
3 3 (4.05%) COM
3 3 (4.05%) CSS
3 3 (4.05%) HTML
3 3 (4.05%) XML
3 3 (4.05%) XSLT
4 2 (2.70%) MDX
5 1 (1.35%) WinForms
Miscellaneous
1 16 (21.62%) Visualisation
2 10 (13.51%) Analytical Skills
3 6 (8.11%) Clustering
4 5 (6.76%) Data Integration
5 3 (4.05%) Enterprise Software
6 2 (2.70%) Management Information System
7 1 (1.35%) Computer Science
7 1 (1.35%) Derivative
7 1 (1.35%) Driving Licence
7 1 (1.35%) Fixed Income
7 1 (1.35%) Virtual Team
Operating Systems
1 14 (18.92%) Windows
2 11 (14.86%) Windows Server
Processes & Methodologies
1 54 (72.97%) Business Intelligence
2 21 (28.38%) Agile Software Development
3 18 (24.32%) ETL
4 17 (22.97%) Data Management
5 13 (17.57%) Stakeholder Management
6 12 (16.22%) Enterprise Data Management
6 12 (16.22%) PRINCE2
7 6 (8.11%) Analytics
7 6 (8.11%) Project Management
8 5 (6.76%) Asset Management
8 5 (6.76%) Data Modelling
8 5 (6.76%) Investment Management
8 5 (6.76%) SDLC
9 4 (5.41%) Business Analysis
9 4 (5.41%) ETL Development
9 4 (5.41%) Performance Tuning
9 4 (5.41%) Scrum
10 3 (4.05%) Master Data Management
10 3 (4.05%) Statistical Modelling
10 3 (4.05%) Technical Analysis
Programming Languages
1 44 (59.46%) SQL
2 22 (29.73%) T-SQL
3 9 (12.16%) C#
4 4 (5.41%) PowerShell
5 3 (4.05%) JavaScript
5 3 (4.05%) R
5 3 (4.05%) VB.NET
5 3 (4.05%) X++
6 1 (1.35%) Java
6 1 (1.35%) PL/SQL
6 1 (1.35%) VBA
Qualifications
1 12 (16.22%) PRINCE2 Practitioner
1 12 (16.22%) Security Cleared
2 6 (8.11%) Degree
3 1 (1.35%) MCDBA
3 1 (1.35%) MCITP
3 1 (1.35%) Microsoft Certification
Quality Assurance & Compliance
1 17 (22.97%) Data Quality
2 3 (4.05%) SLA
3 1 (1.35%) QA
Vendors
1 32 (43.24%) Microsoft
2 13 (17.57%) Cognos
3 12 (16.22%) Talend
4 4 (5.41%) Tableau
5 3 (4.05%) Google
6 1 (1.35%) Charles River
6 1 (1.35%) Informatica
6 1 (1.35%) Oracle
Edinburgh, Midlothian
Cathcart Associates Ltd
Salary: Benefits
Posted: Yesterday
Glenrothes, Fife
Search Consultancy
Salary: Benefits
Posted: Yesterday
Selkirk, Selkirkshire
Harvey Nash plc
Salary: £25000 - £35000 per annum + excellent benefits
Posted: 2 days ago
Edinburgh, Midlothian
Core-Asset Consulting Ltd
Salary: Not disclosed
Posted: 3 days ago
Glasgow
Hays Specialist Recruitment Ltd
Salary: £35000.00 - £40000.00 per annum
Posted: 11 days ago
Edinburgh
Lawrence Harvey
Salary: £60000.00 - £70000.00 per annum + pension, bonus, health care
Posted: 9 days ago
Glasgow
Hays Specialist Recruitment Ltd
Salary: DOE
Posted: 23 days ago