The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for MCTS qualifications. Included is a benchmarking guide to the salaries offered over the 3 months to 27 June 2017 with a comparison to the same period in the previous 2 years.

Microsoft Certified Technology Specialist (MCTS)
London / City of London
3 months to
27 Jun 2017
Same period 2016 Same period 2015
Rank 232 246 306
Rank change year-on-year +14 +60  
Permanent jobs citing MCTS 1 18 17
As % of all permanent IT jobs advertised in the City of London 0.019% 0.28% 0.17%
As % of the Qualifications category 0.079% 1.21% 0.68%
Number of salaries quoted 1 14 16
Median salary £29,000 £45,000 £45,750
Median salary % change year-on-year -35.55% -1.63%  
UK excluding London median salary £35,750 £32,000 £35,000
% change year-on-year +11.71% -8.57%  

MCTS is in the academic qualifications and professional certifications category. The following table is for comparison with the above and provides summary statistics for all academic qualifications and professional certifications cited in permanent job vacancies advertised in the City of London.

Academic & Professional Certification
City of London
Permanent job vacancies requiring academic qualifications or professional certifications 1265 1484 2484
As % of all permanent IT job vacancies advertised in the City of London 24.47% 23.22% 24.39%
Number of salaries quoted 1098 1313 2133
Median salary £55,000 £55,000 £55,000
90% offered a salary of more than £30,000 £33,500 £31,500
10% offered a salary of more than £77,500 £75,000 £80,000
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

MCTS
Job Vacancy Trend in the City of London

The job posting trend of jobs advertised in the City of London citing MCTS as a proportion of all permanent or contract IT jobs with a match in the Qualifications category.

Job vacancy trend for MCTS in the City of London

MCTS
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing MCTS in the City of London.

Salary trend for MCTS in the City of London

For the 6 months to 27 June 2017, IT jobs citing MCTS 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 City of London region with a requirement for MCTS.

1 17 (100.00%) Microsoft Certification
2 11 (64.71%) Degree
3 10 (58.82%) Windows
4 8 (47.06%) MCP
4 8 (47.06%) SQL Server
5 7 (41.18%) SQL
5 7 (41.18%) Active Directory
5 7 (41.18%) Computer Science
6 6 (35.29%) MCPD
6 6 (35.29%) Microsoft
6 6 (35.29%) CMS
6 6 (35.29%) C#
6 6 (35.29%) VB.NET
6 6 (35.29%) .NET
6 6 (35.29%) ASP.NET
6 6 (35.29%) CRM
7 5 (29.41%) TCP/IP
7 5 (29.41%) DNS
7 5 (29.41%) Finance
7 5 (29.41%) MCITP
7 5 (29.41%) Office 365
8 4 (23.53%) Windows Server 2012
8 4 (23.53%) Meraki
8 4 (23.53%) Fintech
8 4 (23.53%) IP Telephony
8 4 (23.53%) Windows Server 2008
8 4 (23.53%) Windows 7
8 4 (23.53%) Firewall
8 4 (23.53%) Wireless
8 4 (23.53%) Mac OS X

MCTS
Co-occurring IT Skills in the City of 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 6 (35.29%) CMS
2 3 (17.65%) MS Exchange
3 1 (5.88%) Apache
3 1 (5.88%) Exchange Server 2003
3 1 (5.88%) Exchange Server 2010
3 1 (5.88%) Exchange Server 2013
3 1 (5.88%) IIS
3 1 (5.88%) lighttpd
3 1 (5.88%) Skype for Business
Cloud Services
1 5 (29.41%) Office 365
2 3 (17.65%) Microsoft Azure
3 1 (5.88%) Amazon AWS
3 1 (5.88%) Catchpoint
Communications & Networking
1 5 (29.41%) DNS
1 5 (29.41%) TCP/IP
2 4 (23.53%) DHCP
2 4 (23.53%) Firewall
2 4 (23.53%) IP Telephony
2 4 (23.53%) LAN
2 4 (23.53%) WAN
2 4 (23.53%) Wireless
3 2 (11.76%) VPN
4 1 (5.88%) HTTP
4 1 (5.88%) Skype
Database & Business Intelligence
1 8 (47.06%) SQL Server
2 3 (17.65%) SQL Server 2008
2 3 (17.65%) SQL Server Reporting Services
3 2 (11.76%) Data Warehouse
4 1 (5.88%) MySQL
General
1 5 (29.41%) Finance
2 1 (5.88%) Retail
Job Titles
1 6 (35.29%) 2nd Line Support
1 6 (35.29%) Developer
2 5 (29.41%) Support Engineer
3 4 (23.53%) 2nd Line Engineer
3 4 (23.53%) 2nd Line Support Engineer
4 3 (17.65%) .NET Developer
4 3 (17.65%) ASP.NET Developer
4 3 (17.65%) C# .NET Developer
4 3 (17.65%) C# ASP.NET Developer
4 3 (17.65%) C# Developer
4 3 (17.65%) Microsoft Developer
4 3 (17.65%) SQL Developer
4 3 (17.65%) SQL Server Developer
5 2 (11.76%) 1st/2nd Line Desktop Support
5 2 (11.76%) 1st/2nd Line Help Desk Support
5 2 (11.76%) 1st/2nd Line Support
5 2 (11.76%) 2nd Line Desktop Support
5 2 (11.76%) Help Desk Support
5 2 (11.76%) SQL DBA
5 2 (11.76%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 6 (35.29%) .NET
1 6 (35.29%) ASP.NET
2 3 (17.65%) Ajax
2 3 (17.65%) jQuery
2 3 (17.65%) LINQ to SQL
2 3 (17.65%) Web Services
2 3 (17.65%) WinForms
2 3 (17.65%) XML
2 3 (17.65%) XSLT
Miscellaneous
1 7 (41.18%) Computer Science
2 4 (23.53%) Client/Server
2 4 (23.53%) Fintech
3 2 (11.76%) Enterprise Software
4 1 (5.88%) Analytical Skills
4 1 (5.88%) Linux Command Line
4 1 (5.88%) Management Information System
4 1 (5.88%) NHS
Operating Systems
1 10 (58.82%) Windows
2 4 (23.53%) Mac OS X
2 4 (23.53%) Windows 7
2 4 (23.53%) Windows Server 2008
2 4 (23.53%) Windows Server 2012
3 2 (11.76%) Linux
4 1 (5.88%) CentOS
4 1 (5.88%) Unix
Processes & Methodologies
1 6 (35.29%) CRM
2 3 (17.65%) ITIL
2 3 (17.65%) Migration
2 3 (17.65%) MVC
2 3 (17.65%) OO
2 3 (17.65%) OOA/OOD
2 3 (17.65%) TDD
3 2 (11.76%) Capacity Planning
3 2 (11.76%) Data Migration
3 2 (11.76%) Performance Tuning
4 1 (5.88%) Business Intelligence
4 1 (5.88%) Case Management
4 1 (5.88%) Performance Metrics
4 1 (5.88%) Root Cause Analysis
4 1 (5.88%) Software Engineering
Programming Languages
1 7 (41.18%) SQL
2 6 (35.29%) C#
2 6 (35.29%) VB.NET
3 3 (17.65%) JavaScript
3 3 (17.65%) T-SQL
4 1 (5.88%) Bash Shell
4 1 (5.88%) Perl
4 1 (5.88%) Python
Qualifications
1 17 (100.00%) Microsoft Certification
2 11 (64.71%) Degree
3 8 (47.06%) MCP
4 6 (35.29%) MCPD
5 5 (29.41%) MCITP
6 2 (11.76%) A+ Certification
6 2 (11.76%) CCNA
6 2 (11.76%) Cisco Certification
6 2 (11.76%) MCSA
6 2 (11.76%) Network+ Certification
7 1 (5.88%) Linux+ Certification
7 1 (5.88%) MCSE
7 1 (5.88%) VMware Certified Professional (VCP)
Quality Assurance & Compliance
1 3 (17.65%) SLA
System Software
1 7 (41.18%) Active Directory
2 1 (5.88%) VMware Infrastructure
Systems Management
1 2 (11.76%) SCCM
Vendors
1 6 (35.29%) Microsoft
2 4 (23.53%) Cisco
2 4 (23.53%) Meraki
3 2 (11.76%) Citrix
3 2 (11.76%) ServiceNow
4 1 (5.88%) HP
4 1 (5.88%) Salesforce.com
4 1 (5.88%) VMware