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

Microsoft Analysis Services
UK
6 months to
23 Jun 2018
Same period 2017 Same period 2016
Rank 797 791 770
Rank change year-on-year -6 -21 -140
Permanent jobs citing Microsoft Analysis Services 400 416 540
As % of all permanent IT jobs advertised in the UK 0.23% 0.24% 0.27%
As % of the Database & Business Intelligence category 0.75% 0.78% 0.88%
Number of salaries quoted 357 364 470
UK median annual salary £50,000 £45,000 £47,500
Median salary % change year-on-year +11.11% -5.26% +5.56%
10th Percentile £33,750 £33,750 £32,500
90th Percentile £70,000 £70,000 £65,250
UK excluding London median annual salary £45,000 £42,500 £45,000
% change year-on-year +5.88% -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 53,263 53,198 61,296
As % of all permanent IT jobs advertised in the UK 30.64% 30.75% 30.51%
Number of salaries quoted 43,564 44,976 52,183
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £29,500 £28,750
90th Percentile £80,000 £77,500 £75,000
UK excluding London median annual salary £45,000 £42,500 £41,000
% change year-on-year +5.88% +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 23 June 2018.

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 23 June 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 -2 387 £50,000 +11.11% 42
UK excluding London -64 197 £45,000 +5.88% 26
London +46 196 £52,500 -8.70% 19
South East -18 72 £47,500 -2.56% 7
Midlands +9 33 £45,000 - 9
East of England +17 31 £40,000 - 2
North of England -51 31 £46,250 +15.63% 1
South West +1 22 £39,500 -4.24% 4
East Midlands +21 20 £42,500 +16.44% 5
North West -57 20 £47,500 +18.75%
West Midlands +8 13 £47,500 +5.56% 4
Yorkshire +21 11 £45,000 +12.50% 1
Wales +17 9 £28,500 -41.54%
Scotland -25 6 £31,000 -7.46% 3

For the 6 months to 23 June 2018, IT jobs citing Microsoft Analysis Services also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads with a requirement for Microsoft Analysis Services.

1 392 (98.00%) SQL Server Analysis Services
2 385 (96.25%) SQL Server
3 356 (89.00%) SQL Server Integration Services
4 353 (88.25%) SQL
5 330 (82.50%) Business Intelligence
6 319 (79.75%) SQL Server Reporting Services
7 299 (74.75%) Data Warehouse
8 264 (66.00%) T-SQL
9 233 (58.25%) Microsoft
10 165 (41.25%) SQL Server 2016
11 140 (35.00%) SQL Server 2014
12 131 (32.75%) Power BI
13 122 (30.50%) ETL
14 106 (26.50%) Finance
15 83 (20.75%) Analytics
16 67 (16.75%) Tableau
17 66 (16.50%) Microsoft Azure
18 60 (15.00%) Kimball Methodology
19 59 (14.75%) Agile Software Development
20 58 (14.50%) Replication
20 58 (14.50%) Relational Database
21 45 (11.25%) OLAP
21 45 (11.25%) Problem-Solving
22 43 (10.75%) Performance Tuning
23 41 (10.25%) Advertising
23 41 (10.25%) Visualisation
24 39 (9.75%) Clustering
24 39 (9.75%) Data Modelling
25 38 (9.50%) C#
25 38 (9.50%) Marketing

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 23 (5.75%) SharePoint
2 11 (2.75%) IIS
3 9 (2.25%) BizTalk Server
4 7 (1.75%) Oracle SOA Suite
5 6 (1.50%) SAS
6 4 (1.00%) Gentran
7 3 (0.75%) WebSphere
8 2 (0.50%) SharePoint 2013
9 1 (0.25%) Apache
9 1 (0.25%) Apache Spark
9 1 (0.25%) Confluence
Applications
1 37 (9.25%) Microsoft Excel
2 9 (2.25%) Microsoft Office
3 4 (1.00%) MS Visio
4 3 (0.75%) Spreadsheet
5 2 (0.50%) Microsoft PowerPoint
Business Applications
1 11 (2.75%) MetaTrader
2 8 (2.00%) Cognos Business Intelligence
2 8 (2.00%) Cognos TM1
3 6 (1.50%) Dynamics AX
4 4 (1.00%) Dynamics NAV
4 4 (1.00%) Oracle Receivables
5 2 (0.50%) Dynamics CRM
6 1 (0.25%) Carpe Diem
Cloud Services
1 66 (16.50%) Microsoft Azure
2 32 (8.00%) Azure Data Factory
3 26 (6.50%) PaaS
4 25 (6.25%) SaaS
5 19 (4.75%) Azure Machine Learning
6 9 (2.25%) Amazon AWS
7 7 (1.75%) Office 365
8 4 (1.00%) Amazon EC2
8 4 (1.00%) Amazon S3
8 4 (1.00%) Cloud Computing
8 4 (1.00%) Cortana Intelligence Suite
8 4 (1.00%) Data Lake Analytics
8 4 (1.00%) Dynamics 365
8 4 (1.00%) IaaS
9 3 (0.75%) Azure Active Directory
10 2 (0.50%) Google Analytics
Communications & Networking
1 31 (7.75%) Internet
2 6 (1.50%) FTP
3 3 (0.75%) SMS
4 2 (0.50%) SAN
5 1 (0.25%) Firewall
Database & Business Intelligence
1 392 (98.00%) SQL Server Analysis Services
2 385 (96.25%) SQL Server
3 356 (89.00%) SQL Server Integration Services
4 319 (79.75%) SQL Server Reporting Services
5 299 (74.75%) Data Warehouse
6 165 (41.25%) SQL Server 2016
7 140 (35.00%) SQL Server 2014
8 131 (32.75%) Power BI
9 58 (14.50%) Relational Database
10 45 (11.25%) OLAP
11 36 (9.00%) SQL Server 2008
12 34 (8.50%) SQL Server 2012
13 33 (8.25%) Big Data
14 30 (7.50%) Data Mining
15 24 (6.00%) Data Lake
16 23 (5.75%) Azure SQL Database
16 23 (5.75%) MySQL
17 22 (5.50%) BusinessObjects
18 21 (5.25%) Azure SQL Data Warehouse
19 15 (3.75%) OLAP Cube
Development Applications
1 17 (4.25%) Visual Studio
2 14 (3.50%) SQL Server Management Studio (SSMS)
3 13 (3.25%) Team Foundation Server
4 9 (2.25%) Git (software)
5 6 (1.50%) JIRA
5 6 (1.50%) Visual Studio Team System
6 4 (1.00%) RStudio
7 3 (0.75%) Subversion
8 2 (0.50%) Xcode
9 1 (0.25%) ERwin
9 1 (0.25%) Octopus Deploy
9 1 (0.25%) TestRail
9 1 (0.25%) VSS/SourceSafe
General
1 106 (26.50%) Finance
2 41 (10.25%) Advertising
3 38 (9.50%) Marketing
4 16 (4.00%) Retail
5 9 (2.25%) Games
6 6 (1.50%) Banking
7 5 (1.25%) Front Office
7 5 (1.25%) Investment Banking
8 4 (1.00%) Back Office
9 3 (0.75%) Law
9 3 (0.75%) Legal
10 2 (0.50%) Billing
11 1 (0.25%) Financial Institution
Job Titles
1 237 (59.25%) Developer
2 162 (40.50%) SQL Developer
3 143 (35.75%) Business Intelligence Developer
4 108 (27.00%) SQL Server Developer
5 94 (23.50%) SQL BI Developer
6 81 (20.25%) Data Warehouse Developer
7 71 (17.75%) SQL Server BI Developer
8 62 (15.50%) SQL Server Data Warehouse Developer
9 55 (13.75%) DBA
10 42 (10.50%) SQL DBA
11 36 (9.00%) Analyst
12 30 (7.50%) SQL Server DBA
13 27 (6.75%) Internet Developer
14 26 (6.50%) Consultant
15 24 (6.00%) Microsoft Developer
16 21 (5.25%) Business Intelligence Lead
17 19 (4.75%) Architect
17 19 (4.75%) Senior Developer
18 15 (3.75%) Senior Analyst
18 15 (3.75%) SSIS Developer
Libraries, Frameworks & Software Standards
1 38 (9.50%) MDX
2 35 (8.75%) .NET
3 22 (5.50%) XML
4 19 (4.75%) ASP.NET
5 16 (4.00%) REST
6 12 (3.00%) Web Services
7 10 (2.50%) HTML
7 10 (2.50%) SOAP
8 9 (2.25%) LAMP
9 7 (1.75%) jQuery
10 6 (1.50%) CSS
11 5 (1.25%) HTML5
11 5 (1.25%) WPF
12 3 (0.75%) ASP.NET MVC
13 2 (0.50%) .NET Framework
13 2 (0.50%) AngularJS
13 2 (0.50%) ASP.NET Web Forms
13 2 (0.50%) KnockoutJS
13 2 (0.50%) Razor View Engine
13 2 (0.50%) WCF
Miscellaneous
1 58 (14.50%) Replication
2 39 (9.75%) Clustering
3 33 (8.25%) Fintech
4 31 (7.75%) Analytical Skills
5 14 (3.50%) Management Information System
6 11 (2.75%) Greenfield Project
7 10 (2.50%) Foreign Exchange (FX)
8 9 (2.25%) Data Structures
9 8 (2.00%) Computer Science
9 8 (2.00%) Enterprise Software
9 8 (2.00%) Spread Betting
10 7 (1.75%) Self-Motivation
10 7 (1.75%) Virtual Team
11 4 (1.00%) Public Cloud
12 3 (0.75%) Reinsurance
13 2 (0.50%) Smart Energy
13 2 (0.50%) Smart Meter
14 1 (0.25%) Algorithms
14 1 (0.25%) Hedge funds
14 1 (0.25%) User Experience
Operating Systems
1 21 (5.25%) Windows
2 13 (3.25%) Windows Server
3 9 (2.25%) Windows Server 2008
4 8 (2.00%) Windows Server 2012
5 5 (1.25%) Linux
6 2 (0.50%) Apple iOS
7 1 (0.25%) Windows 10
7 1 (0.25%) Windows 7
7 1 (0.25%) Windows 8
Processes & Methodologies
1 330 (82.50%) Business Intelligence
2 122 (30.50%) ETL
3 83 (20.75%) Analytics
4 60 (15.00%) Kimball Methodology
5 59 (14.75%) Agile Software Development
6 45 (11.25%) Problem-Solving
7 43 (10.75%) Performance Tuning
8 41 (10.25%) Visualisation
9 39 (9.75%) Data Modelling
10 35 (8.75%) Asset Management
11 34 (8.50%) Data Integration
11 34 (8.50%) Wealth Management
12 33 (8.25%) Data Science
13 30 (7.50%) Machine Learning
14 29 (7.25%) Data Analysis
15 28 (7.00%) Data Analytics
16 25 (6.25%) Dimensional Modelling
16 25 (6.25%) Predictive Analytics
17 23 (5.75%) Disaster Recovery
18 22 (5.50%) Master Data Management
Programming Languages
1 353 (88.25%) SQL
2 264 (66.00%) T-SQL
3 38 (9.50%) C#
4 29 (7.25%) Data Analysis Expressions (DAX)
5 22 (5.50%) R
6 18 (4.50%) PowerShell
7 17 (4.25%) JavaScript
8 16 (4.00%) VBA
9 14 (3.50%) Python
10 7 (1.75%) PL/SQL
11 6 (1.50%) U-SQL
11 6 (1.50%) VB.NET
12 5 (1.25%) Shell Script
12 5 (1.25%) VB
13 4 (1.00%) ActionScript
13 4 (1.00%) ActionScript 2.0
13 4 (1.00%) PHP
14 3 (0.75%) C
14 3 (0.75%) Java
14 3 (0.75%) XAML
Qualifications
1 28 (7.00%) Degree
2 12 (3.00%) Microsoft Certification
3 7 (1.75%) ITIL Certification
3 7 (1.75%) Postgraduate
4 6 (1.50%) Security Cleared
5 5 (1.25%) Numerate Degree
6 2 (0.50%) DV Cleared
6 2 (0.50%) MCSA
7 1 (0.25%) Computer Science Degree
7 1 (0.25%) ISTQB
7 1 (0.25%) Master's Degree
7 1 (0.25%) MCSE
7 1 (0.25%) PhD
Quality Assurance & Compliance
1 20 (5.00%) Data Quality
2 4 (1.00%) QA
3 3 (0.75%) Cyber Essentials
3 3 (0.75%) GDPR
3 3 (0.75%) ISO/IEC 27001
3 3 (0.75%) SLA
4 1 (0.25%) Basel III
4 1 (0.25%) CRD IV
4 1 (0.25%) PCI DSS
System Software
1 10 (2.50%) Active Directory
2 2 (0.50%) VMware Infrastructure
Systems Management
1 9 (2.25%) Galera Cluster
2 5 (1.25%) Failover Clustering
3 4 (1.00%) CloudHub
4 2 (0.50%) Control-M
4 2 (0.50%) HP ALM
5 1 (0.25%) Opscode Chef
5 1 (0.25%) Puppet
5 1 (0.25%) Systems Management Server (SMS)
Vendors
1 233 (58.25%) Microsoft
2 67 (16.75%) Tableau
3 25 (6.25%) Oracle
4 23 (5.75%) Facebook
5 15 (3.75%) Cognos
5 15 (3.75%) SAP
6 6 (1.50%) Google
7 5 (1.25%) Vertica
8 4 (1.00%) CA
8 4 (1.00%) Cognizant
8 4 (1.00%) IBM
8 4 (1.00%) MuleSoft
9 3 (0.75%) Alteryx
9 3 (0.75%) Nintex
10 2 (0.50%) HP
10 2 (0.50%) RedGate
10 2 (0.50%) Salesforce.com
10 2 (0.50%) TOWER Software
10 2 (0.50%) VMware
11 1 (0.25%) MicroStrategy