Period
to 17 October 2017

The following table provides summary statistics for permanent job vacancies with a requirement for Microsoft Analysis Services skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Microsoft Analysis Services over the 6 months to 17 October 2017 with a comparison to the same period in the previous 2 years.

Microsoft Analysis Services
UK
6 months to
17 Oct 2017
Same period 2016 Same period 2015
Rank 812 754 610
Rank change year-on-year -58 -144 +31
Permanent jobs citing Microsoft Analysis Services 381 514 901
As % of all permanent IT jobs advertised in the UK 0.22% 0.27% 0.41%
As % of the Database & Business Intelligence category 0.71% 0.90% 1.31%
Number of salaries quoted 334 457 766
UK median annual salary £45,000 £50,000 £47,500
Median salary % change year-on-year -10.00% +5.26% -
10th Percentile £33,225 £36,250 £32,500
90th Percentile £70,000 £66,750 £76,250
UK excluding London median annual salary £41,250 £45,000 £45,000
% change year-on-year -8.33% - -

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

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 53338 56897 68761
As % of all permanent IT jobs advertised in the UK 30.49% 29.65% 31.57%
Number of salaries quoted 43863 48410 57997
UK median annual salary £47,987 £47,500 £45,000
Median salary % change year-on-year +1.02% +5.56% -
10th Percentile £30,000 £28,750 £28,000
90th Percentile £77,500 £76,250 £73,750
UK excluding London median annual salary £42,500 £41,500 £40,000
% change year-on-year +2.41% +3.75% -

Microsoft Analysis Services
Job Vacancy Trend

Job postings citing Microsoft Analysis Services as a percentage of all IT jobs advertised.

Job vacancy trend for Microsoft Analysis Services in the UK

Microsoft Analysis Services
Salary Trend

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

Salary trend for Microsoft Analysis Services in the UK

Microsoft Analysis Services
Salary Histogram

The salary distribution of IT jobs citing Microsoft Analysis Services over the 6 months to 17 October 2017.

Salary histogram for Microsoft Analysis Services in the UK

Microsoft Analysis Services
Top 14 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Microsoft Analysis Services within the UK over the 6 months to 17 October 2017. 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
England -26 366 £47,000 -6.00% 17
UK excluding London +33 203 £41,250 -8.33% 11
London -63 172 £52,500 - 6
North of England +45 97 £40,000 -8.05% 4
North West +35 81 £40,000 -11.11% 3
South East +52 58 £45,000 -5.26% 3
Midlands +33 19 £55,000 +10.00% 2
West Midlands +35 16 £55,000 +15.79%
Yorkshire +34 16 £42,500 -2.86% 1
East of England +4 13 £40,000 -11.11% 2
Scotland -1 7 £35,000 -22.22%
South West -6 5 £55,000 +29.41%
Wales +10 4 £51,250 +32.26%
East Midlands +30 3 £45,000 -10.00% 2

For the 6 months to 17 October 2017, IT jobs citing Microsoft 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 with a requirement for Microsoft Analysis Services.

1 375 (98.43%) SQL Server
2 373 (97.90%) SQL Server Analysis Services
3 356 (93.44%) SQL
4 354 (92.91%) SQL Server Integration Services
5 336 (88.19%) SQL Server Reporting Services
6 304 (79.79%) Business Intelligence
7 273 (71.65%) T-SQL
8 250 (65.62%) Data Warehouse
9 198 (51.97%) SQL Server 2014
10 169 (44.36%) Microsoft
11 159 (41.73%) SQL Server 2016
12 131 (34.38%) ETL
13 114 (29.92%) Finance
14 81 (21.26%) Performance Tuning
15 73 (19.16%) SQL Server 2012
16 68 (17.85%) Replication
17 67 (17.59%) MDX
18 65 (17.06%) SQL Server 2008
19 64 (16.80%) Agile Software Development
20 59 (15.49%) Power BI
21 58 (15.22%) Migration
22 57 (14.96%) Kimball Methodology
23 53 (13.91%) Microsoft Azure
23 53 (13.91%) Clustering
23 53 (13.91%) SharePoint
24 52 (13.65%) OLAP
25 47 (12.34%) Oracle
26 46 (12.07%) Internet
27 44 (11.55%) BusinessObjects
28 41 (10.76%) Retail

Microsoft Analysis Services
Co-occurring IT Skills 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 53 (13.91%) SharePoint
2 10 (2.62%) SharePoint 2010
3 8 (2.10%) SharePoint 2013
4 7 (1.84%) WebSphere
5 5 (1.31%) IIS
6 4 (1.05%) BizTalk Server
6 4 (1.05%) Gentran
6 4 (1.05%) SAS
7 1 (0.26%) Apache
7 1 (0.26%) CMS
7 1 (0.26%) EPiServer
7 1 (0.26%) Tomcat
Applications
1 33 (8.66%) Microsoft Excel
2 15 (3.94%) Microsoft Office
3 7 (1.84%) MS Visio
4 2 (0.52%) SPSS
Business Applications
1 9 (2.36%) Dynamics AX
2 4 (1.05%) Cognos Business Intelligence
3 2 (0.52%) Misys Opics
3 2 (0.52%) Softmar
4 1 (0.26%) Cognos TM1
4 1 (0.26%) Dynamics CRM
4 1 (0.26%) StreamServe
Cloud Services
1 53 (13.91%) Microsoft Azure
2 34 (8.92%) Amazon AWS
3 19 (4.99%) IaaS
4 9 (2.36%) Cortana Intelligence Suite
5 7 (1.84%) PaaS
5 7 (1.84%) SaaS
6 4 (1.05%) Dynamics 365
7 3 (0.79%) Azure Data Factory
7 3 (0.79%) Azure Machine Learning
7 3 (0.79%) Cloud Computing
7 3 (0.79%) Mimecast
8 2 (0.52%) Google Play
8 2 (0.52%) Office 365
Communications & Networking
1 46 (12.07%) Internet
2 4 (1.05%) Firewall
2 4 (1.05%) FTP
3 2 (0.52%) Intranet
3 2 (0.52%) Kerberos
3 2 (0.52%) SAN
4 1 (0.26%) DMZ
Database & Business Intelligence
1 375 (98.43%) SQL Server
2 373 (97.90%) SQL Server Analysis Services
3 354 (92.91%) SQL Server Integration Services
4 336 (88.19%) SQL Server Reporting Services
5 250 (65.62%) Data Warehouse
6 198 (51.97%) SQL Server 2014
7 159 (41.73%) SQL Server 2016
8 73 (19.16%) SQL Server 2012
9 65 (17.06%) SQL Server 2008
10 59 (15.49%) Power BI
11 52 (13.65%) OLAP
12 44 (11.55%) BusinessObjects
13 38 (9.97%) Relational Database
14 34 (8.92%) OLAP Cube
15 30 (7.87%) QlikView
16 29 (7.61%) Azure SQL Database
17 27 (7.09%) PowerPivot
18 26 (6.82%) NoSQL
19 25 (6.56%) SQL Server 2005
20 20 (5.25%) RDBMS
Development Applications
1 30 (7.87%) Team Foundation Server
1 30 (7.87%) Visual Studio
2 17 (4.46%) SQL Server Management Studio (SSMS)
3 6 (1.57%) Git (software)
4 4 (1.05%) Jenkins
4 4 (1.05%) MSTest
4 4 (1.05%) NSubstitute
4 4 (1.05%) Rhino Mocks
4 4 (1.05%) Visual Studio Tools for Office
5 1 (0.26%) IDA Disassembler
5 1 (0.26%) JIRA
5 1 (0.26%) Octopus Deploy
5 1 (0.26%) OllyDbg
5 1 (0.26%) Visual Studio Team System
5 1 (0.26%) VSS/SourceSafe
5 1 (0.26%) WinDbg
General
1 114 (29.92%) Finance
2 41 (10.76%) Retail
3 37 (9.71%) Marketing
4 35 (9.19%) Banking
5 26 (6.82%) Advertising
6 25 (6.56%) Games
7 16 (4.20%) Publishing
8 13 (3.41%) Front Office
9 11 (2.89%) Retail Banking
10 8 (2.10%) Investment Banking
11 4 (1.05%) Telecoms
12 3 (0.79%) Legal
13 2 (0.52%) Back Office
13 2 (0.52%) Electronics
13 2 (0.52%) Law
13 2 (0.52%) Manufacturing
13 2 (0.52%) Pharmaceutical
Job Titles
1 236 (61.94%) Developer
2 174 (45.67%) SQL Developer
3 151 (39.63%) Business Intelligence Developer
4 126 (33.07%) SQL Server Developer
5 100 (26.25%) SQL BI Developer
6 84 (22.05%) DBA
7 77 (20.21%) SQL Server BI Developer
8 76 (19.95%) Data Warehouse Developer
9 74 (19.42%) SQL DBA
10 72 (18.90%) SQL Server Data Warehouse Developer
11 37 (9.71%) SQL Server DBA
12 30 (7.87%) Business Developer
13 29 (7.61%) Consultant
14 28 (7.35%) Internet Developer
15 24 (6.30%) Analyst
16 22 (5.77%) SSIS Developer
17 21 (5.51%) SSRS Developer
18 19 (4.99%) Administrator
19 15 (3.94%) Architect
20 13 (3.41%) Senior Developer
Libraries, Frameworks & Software Standards
1 67 (17.59%) MDX
2 29 (7.61%) .NET
3 10 (2.62%) XML
4 8 (2.10%) ASP.NET
4 8 (2.10%) JSON
5 5 (1.31%) ASP.NET MVC
5 5 (1.31%) jQuery
5 5 (1.31%) Web Services
6 4 (1.05%) .NET Framework
6 4 (1.05%) Entity Framework
7 2 (0.52%) COM
7 2 (0.52%) HTML
7 2 (0.52%) REST
8 1 (0.26%) ASP.NET MVC 3
8 1 (0.26%) CSS
8 1 (0.26%) JDBC
8 1 (0.26%) OAuth
8 1 (0.26%) ODBC
8 1 (0.26%) RESTful
8 1 (0.26%) SAML
Miscellaneous
1 68 (17.85%) Replication
2 53 (13.91%) Clustering
3 25 (6.56%) Analytical Skills
4 18 (4.72%) BBC
4 18 (4.72%) Fintech
4 18 (4.72%) Social Media
5 17 (4.46%) Blog
6 9 (2.36%) Computer Science
7 7 (1.84%) Management Information System
8 5 (1.31%) Data Structures
9 4 (1.05%) Enterprise Software
9 4 (1.05%) NHS
10 2 (0.52%) Greenfield Project
10 2 (0.52%) iPad
10 2 (0.52%) iPhone
10 2 (0.52%) Mobile App
11 1 (0.26%) Algorithms
11 1 (0.26%) Data Centre
11 1 (0.26%) Private Cloud
11 1 (0.26%) User Experience
Operating Systems
1 33 (8.66%) Windows
2 23 (6.04%) Windows Server
3 9 (2.36%) Linux
4 5 (1.31%) Windows Server 2008
5 4 (1.05%) Windows Server 2012
6 3 (0.79%) Unix
7 2 (0.52%) Android
7 2 (0.52%) Windows 7
Processes & Methodologies
1 304 (79.79%) Business Intelligence
2 131 (34.38%) ETL
3 81 (21.26%) Performance Tuning
4 64 (16.80%) Agile Software Development
5 58 (15.22%) Migration
6 57 (14.96%) Kimball Methodology
7 38 (9.97%) Dimensional Modelling
8 36 (9.45%) High Availability
9 32 (8.40%) Data Modelling
10 31 (8.14%) Disaster Recovery
11 30 (7.87%) Analytics
12 24 (6.30%) Presales
13 23 (6.04%) Business Analysis
13 23 (6.04%) Scrum
14 21 (5.51%) Visualisation
15 19 (4.99%) Data Management
16 18 (4.72%) Data Ingestion
16 18 (4.72%) Data Visualisation
16 18 (4.72%) Security Management
16 18 (4.72%) Wealth Management
Programming Languages
1 356 (93.44%) SQL
2 273 (71.65%) T-SQL
3 20 (5.25%) PowerShell
4 17 (4.46%) C#
5 12 (3.15%) Data Analysis Expressions (DAX)
5 12 (3.15%) VB
6 11 (2.89%) VBScript
7 8 (2.10%) PL/SQL
7 8 (2.10%) VB.NET
8 4 (1.05%) ActionScript
8 4 (1.05%) ActionScript 2.0
8 4 (1.05%) VBA
9 3 (0.79%) JavaScript
9 3 (0.79%) Korn
9 3 (0.79%) Perl
9 3 (0.79%) R
10 1 (0.26%) C
10 1 (0.26%) C++
10 1 (0.26%) Java
10 1 (0.26%) Python
Qualifications
1 39 (10.24%) Degree
2 24 (6.30%) Microsoft Certification
3 12 (3.15%) Security Cleared
4 7 (1.84%) Computer Science Degree
5 6 (1.57%) DV Cleared
5 6 (1.57%) SC Cleared
6 4 (1.05%) ITIL Certification
6 4 (1.05%) MCITP
6 4 (1.05%) PRINCE2 Practitioner
7 3 (0.79%) Master's Degree
8 2 (0.52%) MCP
9 1 (0.26%) MCTS
Quality Assurance & Compliance
1 17 (4.46%) Data Quality
2 9 (2.36%) QA
3 6 (1.57%) Cyber Essentials
3 6 (1.57%) ISO/IEC 27001
3 6 (1.57%) SEPA
4 5 (1.31%) SLA
System Software
1 5 (1.31%) Active Directory
2 3 (0.79%) Virtual Machines
3 1 (0.26%) Snort
3 1 (0.26%) VMware Infrastructure
Systems Management
1 16 (4.20%) Failover Clustering
2 15 (3.94%) Perfmon
3 4 (1.05%) Ansible
4 3 (0.79%) SCOM
5 2 (0.52%) SCCM
6 1 (0.26%) CA Single Sign-On
6 1 (0.26%) Control-M
6 1 (0.26%) Microsoft Clustering
6 1 (0.26%) Opscode Chef
6 1 (0.26%) Puppet
6 1 (0.26%) Systems Management Server (SMS)
Vendors
1 169 (44.36%) Microsoft
2 47 (12.34%) Oracle
3 37 (9.71%) Tableau
4 36 (9.45%) Facebook
5 31 (8.14%) Sybase
6 21 (5.51%) Cognos
6 21 (5.51%) SAP
7 20 (5.25%) Google
8 18 (4.72%) Apple
8 18 (4.72%) IBM
8 18 (4.72%) Sony
8 18 (4.72%) Yahoo!
9 9 (2.36%) Bloomberg
9 9 (2.36%) Calypso
9 9 (2.36%) Murex
9 9 (2.36%) Reuters
10 7 (1.84%) Nintex
10 7 (1.84%) Vertica
11 6 (1.57%) RedGate
12 4 (1.05%) TOWER Software