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

Microsoft Analysis Services
UK
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 802 763 627
Rank change year-on-year -39 -136 +12
Permanent jobs citing Microsoft Analysis Services 391 497 847
As % of all permanent IT jobs advertised in the UK 0.22% 0.26% 0.39%
As % of the Database & Business Intelligence category 0.72% 0.88% 1.23%
Number of salaries quoted 349 452 713
UK median annual salary £47,000 £50,000 £47,500
Median salary % change year-on-year -6.00% +5.26% -
10th Percentile £33,600 £37,000 £32,500
90th Percentile £70,000 £67,375 £76,250
UK excluding London median annual salary £42,500 £45,000 £45,000
% change year-on-year -5.56% - +5.88%

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 54109 56256 68994
As % of all permanent IT jobs advertised in the UK 30.24% 29.63% 31.50%
Number of salaries quoted 44517 48077 58103
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +1.12%
10th Percentile £30,000 £29,000 £28,250
90th Percentile £77,500 £76,750 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

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 18 November 2017.

Salary histogram for Microsoft Analysis Services in the UK

Microsoft Analysis Services
Top 15 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 18 November 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 -40 369 £46,000 -8.00% 21
UK excluding London +36 204 £42,500 -5.56% 14
London -70 177 £52,500 -4.55% 7
North of England +35 91 £40,000 -8.05% 6
North West +21 80 £40,000 -8.05% 4
South East +8 58 £45,000 -5.26% 3
Midlands +23 20 £55,000 +15.79%
West Midlands +20 17 £55,000 +22.22%
East of England +10 16 £37,500 -16.67% 4
Yorkshire +25 10 £40,000 -11.11% 2
South West -24 7 £55,000 +29.41% 1
Wales +16 6 £56,250 +45.16%
Scotland -4 6 £37,000 -17.78%
East Midlands +34 3 £45,000 -5.26%
North East +6 1 £40,000 +3.23%

For the 6 months to 18 November 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 385 (98.47%) SQL Server
2 384 (98.21%) SQL Server Analysis Services
3 371 (94.88%) SQL
4 364 (93.09%) SQL Server Integration Services
5 351 (89.77%) SQL Server Reporting Services
6 319 (81.59%) Business Intelligence
7 285 (72.89%) T-SQL
8 264 (67.52%) Data Warehouse
9 202 (51.66%) SQL Server 2014
10 184 (47.06%) Microsoft
11 161 (41.18%) SQL Server 2016
12 135 (34.53%) ETL
13 116 (29.67%) Finance
14 79 (20.20%) SQL Server 2012
15 77 (19.69%) Performance Tuning
16 67 (17.14%) Power BI
17 66 (16.88%) Agile Software Development
18 64 (16.37%) Replication
19 61 (15.60%) MDX
20 60 (15.35%) SQL Server 2008
21 58 (14.83%) OLAP
22 57 (14.58%) Kimball Methodology
23 56 (14.32%) Microsoft Azure
23 56 (14.32%) Internet
24 55 (14.07%) Migration
25 51 (13.04%) Clustering
26 49 (12.53%) SharePoint
27 45 (11.51%) Oracle
28 44 (11.25%) Dimensional Modelling
29 40 (10.23%) Degree

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 49 (12.53%) SharePoint
2 10 (2.56%) SharePoint 2010
3 8 (2.05%) SharePoint 2013
4 4 (1.02%) BizTalk Server
4 4 (1.02%) Gentran
4 4 (1.02%) IIS
4 4 (1.02%) SAS
5 3 (0.77%) WebSphere
6 1 (0.26%) Apache
6 1 (0.26%) CMS
6 1 (0.26%) EPiServer
6 1 (0.26%) Tomcat
Applications
1 30 (7.67%) Microsoft Excel
2 17 (4.35%) Microsoft Office
3 3 (0.77%) MS Visio
3 3 (0.77%) SPSS
4 2 (0.51%) Microsoft PowerPoint
Business Applications
1 9 (2.30%) Dynamics AX
2 4 (1.02%) Cognos Business Intelligence
3 2 (0.51%) Misys Opics
3 2 (0.51%) Oracle ERP
3 2 (0.51%) Softmar
4 1 (0.26%) Cognos TM1
4 1 (0.26%) Dynamics CRM
4 1 (0.26%) StreamServe
Cloud Services
1 56 (14.32%) Microsoft Azure
2 35 (8.95%) Amazon AWS
3 17 (4.35%) IaaS
4 8 (2.05%) Azure Data Factory
4 8 (2.05%) PaaS
5 7 (1.79%) Cortana Intelligence Suite
5 7 (1.79%) SaaS
6 4 (1.02%) Dynamics 365
7 3 (0.77%) Azure Machine Learning
7 3 (0.77%) Cloud Computing
7 3 (0.77%) Mimecast
8 1 (0.26%) Office 365
Communications & Networking
1 56 (14.32%) Internet
2 4 (1.02%) Firewall
2 4 (1.02%) FTP
3 2 (0.51%) Intranet
3 2 (0.51%) Kerberos
4 1 (0.26%) SAN
Database & Business Intelligence
1 385 (98.47%) SQL Server
2 384 (98.21%) SQL Server Analysis Services
3 364 (93.09%) SQL Server Integration Services
4 351 (89.77%) SQL Server Reporting Services
5 264 (67.52%) Data Warehouse
6 202 (51.66%) SQL Server 2014
7 161 (41.18%) SQL Server 2016
8 79 (20.20%) SQL Server 2012
9 67 (17.14%) Power BI
10 60 (15.35%) SQL Server 2008
11 58 (14.83%) OLAP
12 37 (9.46%) BusinessObjects
13 36 (9.21%) OLAP Cube
14 33 (8.44%) Azure SQL Database
14 33 (8.44%) Relational Database
15 30 (7.67%) QlikView
16 27 (6.91%) PowerPivot
17 24 (6.14%) SQL Server 2005
18 21 (5.37%) NoSQL
19 18 (4.60%) Microsoft Power View
Development Applications
1 36 (9.21%) Team Foundation Server
2 33 (8.44%) Visual Studio
3 16 (4.09%) SQL Server Management Studio (SSMS)
4 5 (1.28%) Git (software)
5 4 (1.02%) Jenkins
6 2 (0.51%) JIRA
6 2 (0.51%) MSTest
6 2 (0.51%) NSubstitute
6 2 (0.51%) Rhino Mocks
6 2 (0.51%) Visual Studio Tools for Office
7 1 (0.26%) Eclipse
7 1 (0.26%) IDA Disassembler
7 1 (0.26%) OllyDbg
7 1 (0.26%) VSS/SourceSafe
7 1 (0.26%) WinDbg
General
1 116 (29.67%) Finance
2 35 (8.95%) Marketing
3 34 (8.70%) Advertising
4 33 (8.44%) Banking
5 30 (7.67%) Retail
6 20 (5.12%) Games
7 16 (4.09%) Publishing
8 12 (3.07%) Retail Banking
9 9 (2.30%) Front Office
10 8 (2.05%) Investment Banking
11 5 (1.28%) Telecoms
12 4 (1.02%) Legal
13 2 (0.51%) Back Office
13 2 (0.51%) Electronics
13 2 (0.51%) Law
13 2 (0.51%) Manufacturing
13 2 (0.51%) Pharmaceutical
14 1 (0.26%) Corporate Banking
14 1 (0.26%) Private Banking
Job Titles
1 246 (62.92%) Developer
2 176 (45.01%) SQL Developer
3 160 (40.92%) Business Intelligence Developer
4 128 (32.74%) SQL Server Developer
5 101 (25.83%) SQL BI Developer
6 86 (21.99%) DBA
7 84 (21.48%) Data Warehouse Developer
8 79 (20.20%) SQL Server BI Developer
9 77 (19.69%) SQL DBA
10 75 (19.18%) SQL Server Data Warehouse Developer
11 40 (10.23%) SQL Server DBA
12 33 (8.44%) Business Developer
12 33 (8.44%) Internet Developer
13 30 (7.67%) Consultant
14 26 (6.65%) Analyst
15 19 (4.86%) Administrator
16 16 (4.09%) SSIS Developer
16 16 (4.09%) SSRS Developer
17 14 (3.58%) Microsoft Consultant
18 13 (3.32%) Business Intelligence Consultant
Libraries, Frameworks & Software Standards
1 61 (15.60%) MDX
2 27 (6.91%) .NET
3 6 (1.53%) ASP.NET
3 6 (1.53%) XML
4 5 (1.28%) JSON
4 5 (1.28%) Web Services
5 4 (1.02%) ASP.NET MVC
6 3 (0.77%) jQuery
6 3 (0.77%) REST
7 2 (0.51%) .NET Framework
7 2 (0.51%) Entity Framework
8 1 (0.26%) ASP.NET MVC 3
8 1 (0.26%) ASP.NET Web Forms
8 1 (0.26%) COM
8 1 (0.26%) CSS
8 1 (0.26%) HTML
8 1 (0.26%) JDBC
8 1 (0.26%) ODBC
Miscellaneous
1 64 (16.37%) Replication
2 51 (13.04%) Clustering
3 30 (7.67%) Analytical Skills
4 25 (6.39%) Fintech
5 16 (4.09%) Blog
6 13 (3.32%) BBC
6 13 (3.32%) Social Media
7 7 (1.79%) Computer Science
8 6 (1.53%) Equities
9 5 (1.28%) Credit Risk
9 5 (1.28%) Greenfield Project
9 5 (1.28%) Management Information System
10 4 (1.02%) Data Structures
10 4 (1.02%) NHS
11 3 (0.77%) Enterprise Software
12 2 (0.51%) Algorithms
13 1 (0.26%) Fixed Income
13 1 (0.26%) Foreign Exchange (FX)
13 1 (0.26%) iPad
13 1 (0.26%) Private Cloud
Operating Systems
1 35 (8.95%) Windows
2 26 (6.65%) Windows Server
3 9 (2.30%) Linux
4 7 (1.79%) Windows Server 2008
5 5 (1.28%) Windows Server 2012
6 3 (0.77%) Unix
7 2 (0.51%) Windows 7
Processes & Methodologies
1 319 (81.59%) Business Intelligence
2 135 (34.53%) ETL
3 77 (19.69%) Performance Tuning
4 66 (16.88%) Agile Software Development
5 57 (14.58%) Kimball Methodology
6 55 (14.07%) Migration
7 44 (11.25%) Dimensional Modelling
8 36 (9.21%) High Availability
9 32 (8.18%) Disaster Recovery
10 30 (7.67%) Data Modelling
11 27 (6.91%) Analytics
12 26 (6.65%) Wealth Management
13 25 (6.39%) Visualisation
14 24 (6.14%) Asset Management
15 22 (5.63%) Data Analysis
16 20 (5.12%) Business Analysis
16 20 (5.12%) Data Ingestion
16 20 (5.12%) Presales
17 19 (4.86%) Capacity Planning
17 19 (4.86%) Scrum
Programming Languages
1 371 (94.88%) SQL
2 285 (72.89%) T-SQL
3 20 (5.12%) PowerShell
4 16 (4.09%) C#
5 12 (3.07%) VB
6 11 (2.81%) VBScript
7 8 (2.05%) VB.NET
8 7 (1.79%) Data Analysis Expressions (DAX)
8 7 (1.79%) Python
9 6 (1.53%) R
10 5 (1.28%) PL/SQL
11 4 (1.02%) ActionScript
11 4 (1.02%) ActionScript 2.0
11 4 (1.02%) C
11 4 (1.02%) VBA
12 3 (0.77%) Korn
12 3 (0.77%) Perl
13 2 (0.51%) JavaScript
14 1 (0.26%) C++
Qualifications
1 40 (10.23%) Degree
2 23 (5.88%) Microsoft Certification
3 12 (3.07%) Security Cleared
4 8 (2.05%) DV Cleared
5 6 (1.53%) Computer Science Degree
5 6 (1.53%) MCITP
6 4 (1.02%) SC Cleared
7 3 (0.77%) ITIL Certification
7 3 (0.77%) Master's Degree
7 3 (0.77%) MCP
7 3 (0.77%) MCTS
8 2 (0.51%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 20 (5.12%) Data Quality
2 8 (2.05%) QA
3 6 (1.53%) SEPA
4 4 (1.02%) SLA
5 3 (0.77%) Cyber Essentials
5 3 (0.77%) ISO/IEC 27001
System Software
1 6 (1.53%) Active Directory
2 2 (0.51%) VMware Infrastructure
3 1 (0.26%) Snort
3 1 (0.26%) Virtual Machines
Systems Management
1 17 (4.35%) Failover Clustering
2 15 (3.84%) Perfmon
3 5 (1.28%) SCOM
4 4 (1.02%) Ansible
4 4 (1.02%) SCCM
5 1 (0.26%) Microsoft Clustering
5 1 (0.26%) Systems Management Server (SMS)
Vendors
1 184 (47.06%) Microsoft
2 45 (11.51%) Oracle
3 40 (10.23%) Tableau
4 37 (9.46%) Facebook
5 30 (7.67%) Sybase
6 24 (6.14%) Cognos
7 18 (4.60%) Google
8 13 (3.32%) Apple
8 13 (3.32%) SAP
8 13 (3.32%) Sony
8 13 (3.32%) Yahoo!
9 11 (2.81%) RedGate
10 10 (2.56%) IBM
11 9 (2.30%) Bloomberg
11 9 (2.30%) Calypso
11 9 (2.30%) Murex
11 9 (2.30%) Reuters
12 4 (1.02%) Cognizant
12 4 (1.02%) TOWER Software
12 4 (1.02%) Vertica