Period
to 20 January 2018

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 20 January 2018 with a comparison to the same period in the previous 2 years.

Microsoft Analysis Services
UK
6 months to
20 Jan 2018
Same period 2017 Same period 2016
Rank 806 768 664
Rank change year-on-year -38 -104 +4
Permanent jobs citing Microsoft Analysis Services 360 431 738
As % of all permanent IT jobs advertised in the UK 0.21% 0.24% 0.35%
As % of the Database & Business Intelligence category 0.68% 0.82% 1.12%
Number of salaries quoted 325 401 637
UK median annual salary £46,000 £50,000 £50,000
Median salary % change year-on-year -8.00% - +6.38%
10th Percentile £32,500 £37,025 £35,000
90th Percentile £65,000 £67,500 £75,000
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 52,890 52,873 65,970
As % of all permanent IT jobs advertised in the UK 30.55% 29.87% 31.62%
Number of salaries quoted 43,850 45,259 55,738
UK median annual salary £48,000 £47,500 £45,000
Median salary % change year-on-year +1.05% +5.56% +1.12%
10th Percentile £30,000 £29,375 £28,750
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,500
% change year-on-year - +4.94% +1.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 20 January 2018.

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 20 January 2018. 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 -47 333 £45,000 -10.00% 57
UK excluding London -1 183 £42,500 -5.56% 44
London -58 163 £50,000 -9.09% 19
South East +2 59 £42,500 -10.53% 12
North of England +7 58 £40,000 -3.61% 10
North West +15 51 £40,000 -3.61% 7
East of England +28 26 £40,000 -11.11% 5
Midlands +25 22 £55,000 +22.22% 9
West Midlands +26 20 £55,000 +22.22% 7
South West +1 8 £55,000 +29.41% 2
Yorkshire +2 6 £43,750 +2.94% 3
Wales +15 5 £60,000 +50.00% 1
Scotland -34 5 £35,000 -22.22% 4
East Midlands +22 2 £42,500 -15.00% 2
North East -25 1 £40,000 +6.67%

For the 6 months to 20 January 2018, 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 350 (97.22%) SQL Server
2 349 (96.94%) SQL Server Analysis Services
3 338 (93.89%) SQL
4 333 (92.50%) SQL Server Integration Services
5 329 (91.39%) SQL Server Reporting Services
6 295 (81.94%) Business Intelligence
7 264 (73.33%) Data Warehouse
8 248 (68.89%) T-SQL
9 177 (49.17%) SQL Server 2014
10 175 (48.61%) Microsoft
11 150 (41.67%) SQL Server 2016
12 102 (28.33%) Finance
13 100 (27.78%) ETL
14 71 (19.72%) Power BI
15 62 (17.22%) Agile Software Development
16 57 (15.83%) Performance Tuning
17 55 (15.28%) SQL Server 2012
17 55 (15.28%) Replication
18 52 (14.44%) Microsoft Azure
19 50 (13.89%) Tableau
20 49 (13.61%) Clustering
21 46 (12.78%) Internet
22 45 (12.50%) Advertising
23 43 (11.94%) OLAP
24 41 (11.39%) MDX
25 40 (11.11%) Wealth Management
25 40 (11.11%) Fintech
26 39 (10.83%) Asset Management
27 38 (10.56%) Marketing
27 38 (10.56%) Dimensional Modelling

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 28 (7.78%) SharePoint
2 4 (1.11%) Gentran
2 4 (1.11%) SAS
3 3 (0.83%) SharePoint Server
4 2 (0.56%) SharePoint 2010
5 1 (0.28%) CMS
5 1 (0.28%) EPiServer
5 1 (0.28%) SharePoint 2013
5 1 (0.28%) WebSphere
Applications
1 32 (8.89%) Microsoft Excel
2 19 (5.28%) Microsoft Office
3 5 (1.39%) Microsoft PowerPoint
4 3 (0.83%) SPSS
5 1 (0.28%) MS Visio
Business Applications
1 8 (2.22%) Dynamics AX
2 6 (1.67%) MetaTrader
3 4 (1.11%) Cognos Business Intelligence
3 4 (1.11%) Oracle ERP
4 1 (0.28%) Cognos TM1
Cloud Services
1 52 (14.44%) Microsoft Azure
2 21 (5.83%) Amazon AWS
3 16 (4.44%) Azure Data Factory
4 14 (3.89%) PaaS
5 9 (2.50%) SaaS
6 8 (2.22%) Dynamics 365
7 5 (1.39%) Cortana Intelligence Suite
7 5 (1.39%) IaaS
8 4 (1.11%) Office 365
9 3 (0.83%) Azure Machine Learning
9 3 (0.83%) Cloud Computing
9 3 (0.83%) Mimecast
9 3 (0.83%) OneDrive
Communications & Networking
1 46 (12.78%) Internet
2 4 (1.11%) FTP
3 2 (0.56%) Intranet
3 2 (0.56%) Kerberos
3 2 (0.56%) SAN
Database & Business Intelligence
1 350 (97.22%) SQL Server
2 349 (96.94%) SQL Server Analysis Services
3 333 (92.50%) SQL Server Integration Services
4 329 (91.39%) SQL Server Reporting Services
5 264 (73.33%) Data Warehouse
6 177 (49.17%) SQL Server 2014
7 150 (41.67%) SQL Server 2016
8 71 (19.72%) Power BI
9 55 (15.28%) SQL Server 2012
10 43 (11.94%) OLAP
11 34 (9.44%) SQL Server 2008
12 25 (6.94%) Azure SQL Database
13 24 (6.67%) OLAP Cube
14 23 (6.39%) BusinessObjects
15 22 (6.11%) PowerPivot
15 22 (6.11%) QlikView
16 19 (5.28%) Relational Database
17 18 (5.00%) SQL Server 2005
18 16 (4.44%) Azure SQL Data Warehouse
19 14 (3.89%) MySQL
Development Applications
1 28 (7.78%) Team Foundation Server
2 22 (6.11%) Visual Studio
3 17 (4.72%) SQL Server Management Studio (SSMS)
4 4 (1.11%) JIRA
5 3 (0.83%) Git (software)
5 3 (0.83%) Jenkins
6 2 (0.56%) Visual Studio Team System
7 1 (0.28%) Eclipse
7 1 (0.28%) IDA Disassembler
7 1 (0.28%) Octopus Deploy
7 1 (0.28%) OllyDbg
7 1 (0.28%) Selenium
7 1 (0.28%) VSS/SourceSafe
7 1 (0.28%) WinDbg
General
1 102 (28.33%) Finance
2 45 (12.50%) Advertising
3 38 (10.56%) Marketing
4 20 (5.56%) Retail
5 13 (3.61%) Games
6 11 (3.06%) Banking
6 11 (3.06%) Publishing
7 6 (1.67%) Retail Banking
8 5 (1.39%) Legal
9 4 (1.11%) Front Office
9 4 (1.11%) Telecoms
10 2 (0.56%) Electronics
10 2 (0.56%) Financial Institution
10 2 (0.56%) Manufacturing
11 1 (0.28%) Corporate Banking
11 1 (0.28%) Investment Banking
11 1 (0.28%) Private Banking
Job Titles
1 227 (63.06%) Developer
2 148 (41.11%) Business Intelligence Developer
3 147 (40.83%) SQL Developer
4 106 (29.44%) SQL Server Developer
5 85 (23.61%) SQL BI Developer
6 82 (22.78%) DBA
7 78 (21.67%) SQL DBA
8 74 (20.56%) Data Warehouse Developer
9 69 (19.17%) SQL Server BI Developer
10 64 (17.78%) SQL Server Data Warehouse Developer
11 46 (12.78%) SQL Server DBA
12 30 (8.33%) Internet Developer
13 28 (7.78%) Analyst
13 28 (7.78%) Business Developer
14 24 (6.67%) Consultant
15 19 (5.28%) Microsoft Consultant
15 19 (5.28%) Microsoft Developer
16 18 (5.00%) Business Intelligence Consultant
16 18 (5.00%) Microsoft BI Consultant
17 16 (4.44%) Azure Consultant
Libraries, Frameworks & Software Standards
1 41 (11.39%) MDX
2 27 (7.50%) .NET
3 9 (2.50%) ASP.NET
3 9 (2.50%) REST
4 5 (1.39%) CSS
4 5 (1.39%) HTML
4 5 (1.39%) XML
5 4 (1.11%) ASP.NET MVC
5 4 (1.11%) CSS3
5 4 (1.11%) HTML5
5 4 (1.11%) jQuery
6 3 (0.83%) LAMP
7 1 (0.28%) .NET Framework
7 1 (0.28%) AngularJS
7 1 (0.28%) ASP.NET MVC 3
7 1 (0.28%) ASP.NET Web Forms
7 1 (0.28%) COM
7 1 (0.28%) JDBC
7 1 (0.28%) ODBC
7 1 (0.28%) XHTML
Miscellaneous
1 55 (15.28%) Replication
2 49 (13.61%) Clustering
3 40 (11.11%) Fintech
4 37 (10.28%) Analytical Skills
5 6 (1.67%) Foreign Exchange (FX)
6 5 (1.39%) Credit Risk
6 5 (1.39%) Data Structures
6 5 (1.39%) Equities
6 5 (1.39%) Greenfield Project
6 5 (1.39%) Spread Betting
7 4 (1.11%) Blog
8 3 (0.83%) Computer Science
8 3 (0.83%) Data Centre
8 3 (0.83%) NHS
9 2 (0.56%) Algorithms
9 2 (0.56%) Enterprise Software
9 2 (0.56%) Management Information System
9 2 (0.56%) Private Cloud
10 1 (0.28%) BBC
10 1 (0.28%) Social Media
Operating Systems
1 34 (9.44%) Windows
2 23 (6.39%) Windows Server
3 7 (1.94%) Windows Server 2008
4 6 (1.67%) Windows Server 2012
5 1 (0.28%) Unix
Processes & Methodologies
1 295 (81.94%) Business Intelligence
2 100 (27.78%) ETL
3 62 (17.22%) Agile Software Development
4 57 (15.83%) Performance Tuning
5 40 (11.11%) Wealth Management
6 39 (10.83%) Asset Management
7 38 (10.56%) Dimensional Modelling
8 37 (10.28%) Kimball Methodology
9 33 (9.17%) Data Analysis
10 32 (8.89%) Visualisation
11 28 (7.78%) Analytics
12 27 (7.50%) Migration
13 26 (7.22%) Data Modelling
14 24 (6.67%) Disaster Recovery
15 23 (6.39%) High Availability
16 18 (5.00%) DevOps
17 15 (4.17%) Capacity Planning
18 14 (3.89%) Business Analysis
18 14 (3.89%) Test Automation
19 13 (3.61%) Knowledge Management
Programming Languages
1 338 (93.89%) SQL
2 248 (68.89%) T-SQL
3 25 (6.94%) C#
4 17 (4.72%) Python
5 15 (4.17%) PowerShell
6 12 (3.33%) R
7 10 (2.78%) VB.NET
8 5 (1.39%) Data Analysis Expressions (DAX)
9 4 (1.11%) ActionScript
9 4 (1.11%) ActionScript 2.0
9 4 (1.11%) C
9 4 (1.11%) JavaScript
10 3 (0.83%) VBA
11 2 (0.56%) VB
12 1 (0.28%) C++
12 1 (0.28%) Korn
12 1 (0.28%) Perl
12 1 (0.28%) PHP
12 1 (0.28%) TypeScript
12 1 (0.28%) VBScript
Qualifications
1 13 (3.61%) Degree
2 11 (3.06%) Security Cleared
3 10 (2.78%) Microsoft Certification
4 9 (2.50%) DV Cleared
5 4 (1.11%) MCITP
5 4 (1.11%) MCTS
6 3 (0.83%) MCP
7 2 (0.56%) SC Cleared
8 1 (0.28%) ITIL Certification
8 1 (0.28%) MCSA
8 1 (0.28%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 16 (4.44%) Data Quality
2 7 (1.94%) QA
3 6 (1.67%) SEPA
4 3 (0.83%) SLA
5 1 (0.28%) Cyber Essentials
5 1 (0.28%) ISO/IEC 27001
System Software
1 7 (1.94%) Active Directory
2 2 (0.56%) VMware Infrastructure
3 1 (0.28%) Snort
3 1 (0.28%) Virtual Machines
Systems Management
1 11 (3.06%) Failover Clustering
2 5 (1.39%) SCCM
2 5 (1.39%) SCOM
3 3 (0.83%) Ansible
3 3 (0.83%) Galera Cluster
4 1 (0.28%) Microsoft Clustering
4 1 (0.28%) Perfmon
4 1 (0.28%) Systems Management Server (SMS)
Vendors
1 175 (48.61%) Microsoft
2 50 (13.89%) Tableau
3 34 (9.44%) Facebook
4 22 (6.11%) Oracle
5 21 (5.83%) Cognos
6 14 (3.89%) Google
7 13 (3.61%) RedGate
8 8 (2.22%) SAP
9 5 (1.39%) Sybase
10 4 (1.11%) Vertica
11 2 (0.56%) IBM
11 2 (0.56%) VMware
12 1 (0.28%) Apple
12 1 (0.28%) Cloudera
12 1 (0.28%) HP
12 1 (0.28%) Informatica
12 1 (0.28%) Nintex
12 1 (0.28%) Red Hat
12 1 (0.28%) Sony
12 1 (0.28%) Yahoo!