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

Microsoft Analysis Services
UK
6 months to
19 Aug 2017
Same period 2016 Same period 2015
Rank 788 758 605
Rank change year-on-year -30 -153 -36
Permanent jobs citing Microsoft Analysis Services 410 543 914
As % of all permanent IT jobs advertised in the UK 0.23% 0.28% 0.42%
As % of the Database & Business Intelligence category 0.75% 0.92% 1.32%
Number of salaries quoted 362 478 774
UK median annual salary £45,000 £50,000 £47,500
Median salary % change year-on-year -10.00% +5.26% +1.60%
10th Percentile £33,750 £35,700 £32,000
90th Percentile £70,000 £66,625 £75,000
UK excluding London median annual salary £40,000 £45,000 £42,500
% change year-on-year -11.11% +5.88% -

Microsoft Analysis Services is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
UK
Permanent job vacancies with a requirement for database and business intelligence skills 54325 59227 69040
As % of all permanent IT job vacancies advertised in the UK 30.71% 30.03% 31.76%
Number of salaries quoted 45217 50571 58229
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +2.27%
10th Percentile £30,000 £28,750 £27,500
90th Percentile £77,500 £75,000 £72,500
UK excluding London median annual salary £42,500 £41,000 £40,000
% change year-on-year +3.66% +2.50% -

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 19 August 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 19 August 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 +2 394 £47,500 -5.00% 17
UK excluding London +47 226 £40,000 -11.11% 13
London -48 177 £56,000 +5.16% 7
North of England +31 104 £40,000 -11.11% 6
North West +21 90 £40,000 -11.11% 4
South East +69 75 £47,500 - 2
Midlands +17 21 £45,000 -10.00%
West Midlands +26 16 £47,500 +11.76%
Yorkshire +24 14 £40,000 -11.11% 1
East of England -29 13 £40,000 - 2
Scotland - 9 £35,000 - 2
East Midlands +1 5 £45,000 -10.00%
Wales +7 3 £50,000 +17.65% 1
South West -23 1 £42,500 - 1

For the 6 months to 19 August 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 404 (98.54%) SQL Server
1 404 (98.54%) SQL Server Analysis Services
2 379 (92.44%) SQL
3 375 (91.46%) SQL Server Integration Services
4 355 (86.59%) SQL Server Reporting Services
5 322 (78.54%) Business Intelligence
6 296 (72.20%) T-SQL
7 262 (63.90%) Data Warehouse
8 214 (52.20%) SQL Server 2014
9 187 (45.61%) SQL Server 2016
10 163 (39.76%) Microsoft
11 120 (29.27%) ETL
12 106 (25.85%) Performance Tuning
13 101 (24.63%) Finance
14 90 (21.95%) Replication
15 71 (17.32%) Clustering
16 67 (16.34%) MDX
17 66 (16.10%) SQL Server 2008
18 64 (15.61%) SQL Server 2012
19 62 (15.12%) Agile Software Development
20 61 (14.88%) Microsoft Azure
21 59 (14.39%) SharePoint
22 51 (12.44%) Power BI
23 49 (11.95%) Internet
24 48 (11.71%) OLAP
24 48 (11.71%) Oracle
24 48 (11.71%) Migration
25 47 (11.46%) Kimball Methodology
26 44 (10.73%) Degree
27 43 (10.49%) Facebook

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 59 (14.39%) SharePoint
2 15 (3.66%) IIS
2 15 (3.66%) SharePoint 2013
3 12 (2.93%) SharePoint 2010
4 8 (1.95%) WebSphere
5 4 (0.98%) BizTalk Server
6 3 (0.73%) Gentran
7 2 (0.49%) Apache
7 2 (0.49%) SharePoint Server
7 2 (0.49%) Tomcat
Applications
1 40 (9.76%) Microsoft Excel
2 8 (1.95%) Microsoft Office
2 8 (1.95%) MS Visio
Business Applications
1 13 (3.17%) Dynamics AX
2 5 (1.22%) Dynamics CRM
3 2 (0.49%) Cognos Business Intelligence
3 2 (0.49%) Cognos TM1
3 2 (0.49%) Dynamics NAV
3 2 (0.49%) Misys Opics
3 2 (0.49%) Softmar
4 1 (0.24%) SAP BPC
4 1 (0.24%) StreamServe
Cloud Services
1 61 (14.88%) Microsoft Azure
2 38 (9.27%) Amazon AWS
3 24 (5.85%) IaaS
4 18 (4.39%) Google Play
5 14 (3.41%) SaaS
6 10 (2.44%) PaaS
7 8 (1.95%) Office 365
8 7 (1.71%) Cortana Intelligence Suite
9 4 (0.98%) Dynamics 365
10 3 (0.73%) Azure Data Factory
10 3 (0.73%) Azure Machine Learning
Communications & Networking
1 49 (11.95%) Internet
2 7 (1.71%) DMZ
3 6 (1.46%) SAN
4 4 (0.98%) Firewall
5 3 (0.73%) FTP
6 1 (0.24%) DHCP
6 1 (0.24%) GoToMeeting
6 1 (0.24%) TCP/IP
6 1 (0.24%) Unified Communications
Database & Business Intelligence
1 404 (98.54%) SQL Server
1 404 (98.54%) SQL Server Analysis Services
2 375 (91.46%) SQL Server Integration Services
3 355 (86.59%) SQL Server Reporting Services
4 262 (63.90%) Data Warehouse
5 214 (52.20%) SQL Server 2014
6 187 (45.61%) SQL Server 2016
7 66 (16.10%) SQL Server 2008
8 64 (15.61%) SQL Server 2012
9 51 (12.44%) Power BI
10 48 (11.71%) OLAP
11 38 (9.27%) BusinessObjects
12 37 (9.02%) Relational Database
13 32 (7.80%) OLAP Cube
14 29 (7.07%) NoSQL
15 27 (6.59%) Azure SQL Database
16 24 (5.85%) PowerPivot
17 22 (5.37%) RDBMS
18 21 (5.12%) QlikView
19 17 (4.15%) SQL Server 2005
Development Applications
1 34 (8.29%) Visual Studio
2 32 (7.80%) Team Foundation Server
3 11 (2.68%) Git (software)
4 6 (1.46%) MSTest
4 6 (1.46%) NSubstitute
4 6 (1.46%) Rhino Mocks
4 6 (1.46%) SQL Server Management Studio (SSMS)
4 6 (1.46%) Visual Studio Tools for Office
5 4 (0.98%) Jenkins
6 1 (0.24%) JIRA
6 1 (0.24%) Octopus Deploy
6 1 (0.24%) Visual Studio Team System
6 1 (0.24%) VSS/SourceSafe
General
1 101 (24.63%) Finance
2 42 (10.24%) Banking
3 39 (9.51%) Marketing
4 37 (9.02%) Games
5 35 (8.54%) Retail
6 26 (6.34%) Advertising
7 17 (4.15%) Front Office
8 13 (3.17%) Publishing
9 10 (2.44%) Investment Banking
10 8 (1.95%) Retail Banking
11 4 (0.98%) Music Industry
11 4 (0.98%) Telecoms
12 3 (0.73%) Legal
12 3 (0.73%) Manufacturing
13 2 (0.49%) Back Office
13 2 (0.49%) Electronics
13 2 (0.49%) Law
13 2 (0.49%) Pharmaceutical
Job Titles
1 236 (57.56%) Developer
2 181 (44.15%) SQL Developer
3 153 (37.32%) Business Intelligence Developer
4 132 (32.20%) SQL Server Developer
5 102 (24.88%) SQL BI Developer
6 100 (24.39%) DBA
7 87 (21.22%) SQL DBA
8 80 (19.51%) Data Warehouse Developer
9 78 (19.02%) SQL Server BI Developer
10 72 (17.56%) SQL Server Data Warehouse Developer
11 55 (13.41%) SQL Server DBA
12 30 (7.32%) Analyst
12 30 (7.32%) Consultant
12 30 (7.32%) Internet Developer
13 27 (6.59%) SSIS Developer
13 27 (6.59%) SSRS Developer
14 26 (6.34%) Business Developer
15 22 (5.37%) Administrator
15 22 (5.37%) Architect
16 19 (4.63%) SQL Analyst
Libraries, Frameworks & Software Standards
1 67 (16.34%) MDX
2 37 (9.02%) .NET
3 14 (3.41%) XML
4 10 (2.44%) ASP.NET
4 10 (2.44%) JSON
5 8 (1.95%) .NET Framework
6 7 (1.71%) jQuery
6 7 (1.71%) Web Services
7 6 (1.46%) ASP.NET MVC
7 6 (1.46%) Entity Framework
7 6 (1.46%) OAuth
7 6 (1.46%) SAML
8 5 (1.22%) HTML
9 3 (0.73%) CSS
10 2 (0.49%) COM
11 1 (0.24%) D3.js
11 1 (0.24%) JDBC
11 1 (0.24%) MSMQ
11 1 (0.24%) ODBC
11 1 (0.24%) RESTful
Miscellaneous
1 90 (21.95%) Replication
2 71 (17.32%) Clustering
3 24 (5.85%) Analytical Skills
3 24 (5.85%) BBC
3 24 (5.85%) Social Media
4 18 (4.39%) iPhone
4 18 (4.39%) Mobile App
5 16 (3.90%) Blog
6 12 (2.93%) Management Information System
7 11 (2.68%) Computer Science
8 10 (2.44%) Data Centre
9 7 (1.71%) Fintech
10 6 (1.46%) Greenfield Project
11 4 (0.98%) Tandem
12 3 (0.73%) NHS
13 2 (0.49%) Data Structures
13 2 (0.49%) Enterprise Software
13 2 (0.49%) Foreign Exchange (FX)
13 2 (0.49%) iPad
14 1 (0.24%) Hedge funds
Operating Systems
1 38 (9.27%) Windows
2 18 (4.39%) Android
3 17 (4.15%) Windows Server
4 10 (2.44%) Linux
5 8 (1.95%) Windows Server 2008
5 8 (1.95%) Windows Server 2012
6 3 (0.73%) Unix
7 2 (0.49%) Windows 7
8 1 (0.24%) CentOS
8 1 (0.24%) Mac OS X
Processes & Methodologies
1 322 (78.54%) Business Intelligence
2 120 (29.27%) ETL
3 106 (25.85%) Performance Tuning
4 62 (15.12%) Agile Software Development
5 48 (11.71%) Migration
6 47 (11.46%) Kimball Methodology
7 38 (9.27%) High Availability
8 32 (7.80%) Dimensional Modelling
9 30 (7.32%) Disaster Recovery
10 29 (7.07%) Data Modelling
11 26 (6.34%) Business Analysis
11 26 (6.34%) Presales
12 23 (5.61%) Data Management
12 23 (5.61%) Scrum
13 22 (5.37%) Analytics
14 21 (5.12%) Data Visualisation
14 21 (5.12%) Visualisation
15 18 (4.39%) Security Management
16 17 (4.15%) Data Protection
16 17 (4.15%) ITIL
Programming Languages
1 379 (92.44%) SQL
2 296 (72.20%) T-SQL
3 37 (9.02%) PowerShell
4 23 (5.61%) C#
5 12 (2.93%) VB
6 11 (2.68%) Data Analysis Expressions (DAX)
6 11 (2.68%) PL/SQL
6 11 (2.68%) VBScript
7 7 (1.71%) VB.NET
7 7 (1.71%) VBA
8 5 (1.22%) JavaScript
9 3 (0.73%) ActionScript
9 3 (0.73%) ActionScript 2.0
9 3 (0.73%) Korn
9 3 (0.73%) Perl
10 2 (0.49%) Java
11 1 (0.24%) C++
11 1 (0.24%) R
Qualifications
1 44 (10.73%) Degree
2 22 (5.37%) Microsoft Certification
3 9 (2.20%) Computer Science Degree
4 5 (1.22%) PRINCE2 Practitioner
4 5 (1.22%) Security Cleared
5 4 (0.98%) ITIL Certification
5 4 (0.98%) SC Cleared
6 3 (0.73%) Master's Degree
6 3 (0.73%) MCITP
7 1 (0.24%) AAT
7 1 (0.24%) CIMA
7 1 (0.24%) DV Cleared
7 1 (0.24%) MCP
7 1 (0.24%) MCSE
Quality Assurance & Compliance
1 17 (4.15%) QA
2 16 (3.90%) Data Quality
3 7 (1.71%) Cyber Essentials
3 7 (1.71%) ISO/IEC 27001
4 6 (1.46%) SLA
5 1 (0.24%) DICOM
5 1 (0.24%) HL7
5 1 (0.24%) Sarbanes-Oxley
System Software
1 20 (4.88%) Active Directory
2 6 (1.46%) Virtual Machines
3 2 (0.49%) VMware Infrastructure
4 1 (0.24%) Hyper-V
4 1 (0.24%) Microsoft App-V
Systems Management
1 19 (4.63%) Failover Clustering
2 15 (3.66%) Perfmon
3 6 (1.46%) CA Single Sign-On
4 4 (0.98%) Ansible
5 1 (0.24%) Control-M
5 1 (0.24%) Microsoft Clustering
5 1 (0.24%) Opscode Chef
5 1 (0.24%) Puppet
5 1 (0.24%) SCOM
5 1 (0.24%) Systems Management Server (SMS)
Vendors
1 163 (39.76%) Microsoft
2 48 (11.71%) Oracle
3 43 (10.49%) Facebook
4 42 (10.24%) Google
5 31 (7.56%) Sybase
6 28 (6.83%) Tableau
7 24 (5.85%) Apple
7 24 (5.85%) Sony
7 24 (5.85%) Yahoo!
8 23 (5.61%) SAP
9 22 (5.37%) IBM
10 13 (3.17%) Cognos
11 9 (2.20%) Bloomberg
11 9 (2.20%) Calypso
11 9 (2.20%) Murex
11 9 (2.20%) Reuters
12 8 (1.95%) Nintex
12 8 (1.95%) Vertica
13 6 (1.46%) CA
14 4 (0.98%) Cognizant