Period
to 21 November 2017

The following table provides summary statistics for permanent job vacancies advertised in London 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 21 November 2017 with a comparison to the same period in the previous 2 years.

Microsoft Analysis Services
England > London
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 650 606 585
Rank change year-on-year -44 -21 -82
Permanent jobs citing Microsoft Analysis Services 182 252 342
As % of all permanent IT jobs advertised in London 0.24% 0.33% 0.39%
As % of the Database & Business Intelligence category 0.82% 1.13% 1.26%
Number of salaries quoted 160 245 294
London median annual salary £52,500 £55,000 £55,000
Median salary % change year-on-year -4.55% - +4.76%
10th Percentile £35,000 £42,500 £38,750
90th Percentile £75,125 £70,750 £90,000
England median annual salary £47,000 £50,000 £49,705
% change year-on-year -6.00% +0.59% +4.64%

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

All Database and Business Intelligence Skills
London
Permanent vacancies with a requirement for database or business intelligence skills 22238 22293 27092
As % of all permanent IT jobs advertised in London 29.43% 29.46% 30.60%
Number of salaries quoted 17833 19427 22914
London median annual salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.35% +4.55% +4.76%
10th Percentile £36,250 £35,000 £35,000
90th Percentile £88,750 £87,500 £85,000
England median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

Microsoft Analysis Services
Job Vacancy Trend in London

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

Job vacancy trend for Microsoft Analysis Services in London

Microsoft Analysis Services
Salary Trend in London

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

Salary trend for Microsoft Analysis Services in London

Microsoft Analysis Services
Salary Histogram in London

The salary distribution of IT jobs citing Microsoft Analysis Services in London over the 6 months to 21 November 2017.

Salary histogram for Microsoft Analysis Services in London

Microsoft Analysis Services
Job Locations in London

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 London region over the 6 months to 21 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
West London +35 27 £40,000 -11.11% 1
Central London -35 22 £62,500 +8.70% 2
North London +2 1 £42,500 +6.25%
Microsoft Analysis Services
England

For the 6 months to 21 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 across the London region with a requirement for Microsoft Analysis Services.

1 179 (98.35%) SQL Server
2 177 (97.25%) SQL Server Analysis Services
3 174 (95.60%) SQL
4 161 (88.46%) SQL Server Integration Services
5 153 (84.07%) SQL Server Reporting Services
6 132 (72.53%) T-SQL
7 128 (70.33%) Business Intelligence
8 106 (58.24%) Data Warehouse
9 96 (52.75%) Microsoft
10 79 (43.41%) SQL Server 2014
11 76 (41.76%) ETL
12 73 (40.11%) Finance
13 55 (30.22%) SQL Server 2016
14 50 (27.47%) MDX
15 45 (24.73%) SQL Server 2012
15 45 (24.73%) OLAP
16 39 (21.43%) Migration
17 38 (20.88%) Kimball Methodology
18 36 (19.78%) Replication
19 35 (19.23%) SharePoint
19 35 (19.23%) Performance Tuning
19 35 (19.23%) SQL Server 2008
20 33 (18.13%) Dimensional Modelling
20 33 (18.13%) Agile Software Development
20 33 (18.13%) OLAP Cube
21 31 (17.03%) Banking
22 29 (15.93%) Clustering
23 26 (14.29%) Oracle
23 26 (14.29%) Power BI
24 25 (13.74%) Degree

Microsoft Analysis Services
Co-occurring IT Skills in London 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 35 (19.23%) SharePoint
2 9 (4.95%) SharePoint 2010
3 7 (3.85%) SharePoint 2013
4 4 (2.20%) BizTalk Server
4 4 (2.20%) Gentran
4 4 (2.20%) IIS
5 2 (1.10%) WebSphere
6 1 (0.55%) CMS
6 1 (0.55%) EPiServer
Applications
1 15 (8.24%) Microsoft Excel
2 14 (7.69%) Microsoft Office
3 3 (1.65%) Microsoft PowerPoint
4 2 (1.10%) MS Visio
Business Applications
1 7 (3.85%) Dynamics AX
2 3 (1.65%) Oracle ERP
3 2 (1.10%) Misys Opics
3 2 (1.10%) Softmar
Cloud Services
1 21 (11.54%) Microsoft Azure
2 18 (9.89%) Amazon AWS
3 10 (5.49%) IaaS
4 3 (1.65%) Cloud Computing
4 3 (1.65%) Dynamics 365
4 3 (1.65%) Mimecast
4 3 (1.65%) SaaS
5 2 (1.10%) PaaS
6 1 (0.55%) Azure Data Factory
6 1 (0.55%) Azure Machine Learning
6 1 (0.55%) Cortana Intelligence Suite
Communications & Networking
1 22 (12.09%) Internet
2 4 (2.20%) Firewall
2 4 (2.20%) FTP
3 2 (1.10%) Intranet
Database & Business Intelligence
1 179 (98.35%) SQL Server
2 177 (97.25%) SQL Server Analysis Services
3 161 (88.46%) SQL Server Integration Services
4 153 (84.07%) SQL Server Reporting Services
5 106 (58.24%) Data Warehouse
6 79 (43.41%) SQL Server 2014
7 55 (30.22%) SQL Server 2016
8 45 (24.73%) OLAP
8 45 (24.73%) SQL Server 2012
9 35 (19.23%) SQL Server 2008
10 33 (18.13%) OLAP Cube
11 26 (14.29%) Power BI
12 24 (13.19%) BusinessObjects
13 18 (9.89%) PowerPivot
13 18 (9.89%) QlikView
14 16 (8.79%) Microsoft Power View
14 16 (8.79%) Relational Database
15 14 (7.69%) Azure SQL Database
15 14 (7.69%) SQL Server 2005
16 11 (6.04%) MySQL
Development Applications
1 18 (9.89%) Team Foundation Server
2 17 (9.34%) Visual Studio
3 7 (3.85%) SQL Server Management Studio (SSMS)
4 4 (2.20%) Git (software)
4 4 (2.20%) Jenkins
5 2 (1.10%) JIRA
5 2 (1.10%) MSTest
5 2 (1.10%) NSubstitute
5 2 (1.10%) Rhino Mocks
5 2 (1.10%) Visual Studio Tools for Office
6 1 (0.55%) Eclipse
6 1 (0.55%) Visual Studio Team System
General
1 73 (40.11%) Finance
2 31 (17.03%) Banking
3 22 (12.09%) Retail
4 19 (10.44%) Marketing
5 16 (8.79%) Publishing
6 14 (7.69%) Advertising
7 12 (6.59%) Retail Banking
8 9 (4.95%) Front Office
9 8 (4.40%) Investment Banking
10 6 (3.30%) Telecoms
11 2 (1.10%) Back Office
11 2 (1.10%) Electronics
11 2 (1.10%) Law
11 2 (1.10%) Manufacturing
11 2 (1.10%) Pharmaceutical
12 1 (0.55%) Corporate Banking
12 1 (0.55%) Legal
12 1 (0.55%) Private Banking
Job Titles
1 108 (59.34%) Developer
2 80 (43.96%) Business Intelligence Developer
3 67 (36.81%) SQL Developer
4 43 (23.63%) DBA
5 41 (22.53%) SQL BI Developer
6 38 (20.88%) SQL DBA
7 37 (20.33%) SQL Server Developer
8 34 (18.68%) Data Warehouse Developer
9 29 (15.93%) SQL Server BI Developer
9 29 (15.93%) SQL Server Data Warehouse Developer
10 27 (14.84%) Business Developer
11 17 (9.34%) SQL Server DBA
12 15 (8.24%) Analyst
13 12 (6.59%) Administrator
13 12 (6.59%) Consultant
13 12 (6.59%) Microsoft BI Developer
13 12 (6.59%) Microsoft Developer
14 11 (6.04%) SSAS Developer
15 9 (4.95%) Applications Support
15 9 (4.95%) Applications Support Analyst
Libraries, Frameworks & Software Standards
1 50 (27.47%) MDX
2 17 (9.34%) .NET
3 5 (2.75%) ASP.NET
4 4 (2.20%) ASP.NET MVC
4 4 (2.20%) Web Services
5 3 (1.65%) jQuery
6 2 (1.10%) .NET Framework
6 2 (1.10%) Entity Framework
7 1 (0.55%) ASP.NET MVC 3
7 1 (0.55%) ASP.NET Web Forms
7 1 (0.55%) COM
7 1 (0.55%) JDBC
7 1 (0.55%) ODBC
Miscellaneous
1 36 (19.78%) Replication
2 29 (15.93%) Clustering
3 14 (7.69%) Analytical Skills
3 14 (7.69%) Fintech
4 10 (5.49%) Blog
5 6 (3.30%) Equities
6 5 (2.75%) Credit Risk
7 4 (2.20%) NHS
8 3 (1.65%) Management Information System
9 2 (1.10%) Data Structures
9 2 (1.10%) Greenfield Project
10 1 (0.55%) Fixed Income
10 1 (0.55%) Foreign Exchange (FX)
Operating Systems
1 17 (9.34%) Windows
2 12 (6.59%) Windows Server
3 9 (4.95%) Linux
4 3 (1.65%) Unix
5 2 (1.10%) Windows 7
Processes & Methodologies
1 128 (70.33%) Business Intelligence
2 76 (41.76%) ETL
3 39 (21.43%) Migration
4 38 (20.88%) Kimball Methodology
5 35 (19.23%) Performance Tuning
6 33 (18.13%) Agile Software Development
6 33 (18.13%) Dimensional Modelling
7 20 (10.99%) High Availability
8 19 (10.44%) Disaster Recovery
9 16 (8.79%) Business Analysis
9 16 (8.79%) Capacity Planning
9 16 (8.79%) Scrum
9 16 (8.79%) Wealth Management
10 14 (7.69%) Asset Management
10 14 (7.69%) Kanban
11 13 (7.14%) ITIL
11 13 (7.14%) Presales
12 12 (6.59%) Data Analysis
12 12 (6.59%) Security Management
12 12 (6.59%) Workflow
Programming Languages
1 174 (95.60%) SQL
2 132 (72.53%) T-SQL
3 18 (9.89%) PowerShell
4 11 (6.04%) VB
4 11 (6.04%) VBScript
5 8 (4.40%) C#
6 4 (2.20%) ActionScript
6 4 (2.20%) ActionScript 2.0
7 3 (1.65%) C
7 3 (1.65%) Korn
7 3 (1.65%) Perl
7 3 (1.65%) VB.NET
8 2 (1.10%) Data Analysis Expressions (DAX)
8 2 (1.10%) VBA
9 1 (0.55%) JavaScript
9 1 (0.55%) R
Qualifications
1 25 (13.74%) Degree
2 9 (4.95%) Microsoft Certification
3 2 (1.10%) ITIL Certification
3 2 (1.10%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 11 (6.04%) Data Quality
2 6 (3.30%) SEPA
3 5 (2.75%) QA
4 2 (1.10%) Cyber Essentials
4 2 (1.10%) ISO/IEC 27001
4 2 (1.10%) SLA
System Software
1 1 (0.55%) Virtual Machines
1 1 (0.55%) VMware Infrastructure
Systems Management
1 11 (6.04%) Perfmon
2 4 (2.20%) Ansible
2 4 (2.20%) Failover Clustering
3 1 (0.55%) Microsoft Clustering
3 1 (0.55%) SCOM
Vendors
1 96 (52.75%) Microsoft
2 26 (14.29%) Oracle
3 24 (13.19%) Sybase
3 24 (13.19%) Tableau
4 12 (6.59%) Cognos
5 11 (6.04%) RedGate
6 10 (5.49%) Facebook
7 9 (4.95%) Bloomberg
7 9 (4.95%) Calypso
7 9 (4.95%) Murex
7 9 (4.95%) Reuters
8 4 (2.20%) Cognizant
8 4 (2.20%) SAP
8 4 (2.20%) TOWER Software
8 4 (2.20%) Vertica
9 3 (1.65%) Red Hat
9 3 (1.65%) Sun
10 2 (1.10%) IBM
10 2 (1.10%) Misys
10 2 (1.10%) OpenLink