Period
to 20 January 2018

The following table provides summary statistics for permanent job vacancies advertised in Guildford with a requirement for MCP qualifications. Included is a benchmarking guide to the salaries offered over the 6 months to 20 January 2018 with a comparison to the same period in the previous 2 years.

Microsoft Certified Professional (MCP)
Surrey > Guildford
6 months to
20 Jan 2018
Same period 2017 Same period 2016
Rank 92 70 98
Rank change year-on-year -22 +28 -5
Permanent jobs citing MCP 4 8 12
As % of all permanent IT jobs advertised in Guildford 0.45% 1.19% 1.01%
As % of the Qualifications category 1.43% 4.04% 3.39%
Number of salaries quoted 4 6 12
Guildford median annual salary £31,000 £30,000 £36,500
Median salary % change year-on-year +3.33% -17.81% -14.12%
10th Percentile £21,000 £22,500 £26,250
90th Percentile £47,000 £39,375 £42,500
Surrey median annual salary £35,000 £30,000 £40,000
% change year-on-year +16.67% -25.00% +17.65%

MCP is in the Academic Qualifications and Professional Certifications category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Guildford with a requirement for academic qualifications or professional certifications.

All Academic and Professional Certifications
Guildford
Permanent vacancies requiring academic qualifications or professional certifications 280 198 354
As % of all permanent IT jobs advertised in Guildford 31.82% 29.51% 29.92%
Number of salaries quoted 217 191 294
Guildford median annual salary £47,500 £45,000 £44,750
Median salary % change year-on-year +5.56% +0.56% -0.56%
10th Percentile £22,800 £23,250 £24,150
90th Percentile £71,250 £68,750 £65,000
Surrey median annual salary £49,000 £45,000 £45,000
% change year-on-year +8.89% - +2.27%

MCP
Job Vacancy Trend in Guildford

Job postings citing MCP as a percentage of all IT jobs advertised in Guildford.

Job vacancy trend for MCP in Guildford

MCP
Salary Trend in Guildford

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing MCP in Guildford.

Salary trend for MCP in Guildford

MCP
Salary Histogram in Guildford

The salary distribution of IT jobs citing MCP in Guildford over the 6 months to 20 January 2018.

Salary histogram for MCP in Guildford

For the 6 months to 20 January 2018, IT jobs citing MCP 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 Guildford region with a requirement for MCP.

1 3 (75.00%) MCSA
1 3 (75.00%) Microsoft Certification
2 2 (50.00%) A+ Certification
2 2 (50.00%) Internet
2 2 (50.00%) ITIL
2 2 (50.00%) WAN
3 1 (25.00%) Failover Clustering
3 1 (25.00%) Task Automation
3 1 (25.00%) Computer Science Degree
3 1 (25.00%) MVC
3 1 (25.00%) Clustering
3 1 (25.00%) Agile Software Development
3 1 (25.00%) Mitel
3 1 (25.00%) SQL Server Reporting Services
3 1 (25.00%) Capita
3 1 (25.00%) SQL Server Integration Services
3 1 (25.00%) Degree
3 1 (25.00%) SQL Server Analysis Services
3 1 (25.00%) Dimensional Modelling
3 1 (25.00%) Kanban
3 1 (25.00%) PowerShell
3 1 (25.00%) Team Foundation Server
3 1 (25.00%) ASP.NET MVC
3 1 (25.00%) Web Application Development
3 1 (25.00%) Kimball Methodology
3 1 (25.00%) Analytics
3 1 (25.00%) Data Analysis Expressions (DAX)
3 1 (25.00%) Performance Tuning
3 1 (25.00%) Power BI
3 1 (25.00%) Biml

MCP
Co-occurring IT Skills in Guildford 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 1 (25.00%) SharePoint
Communications & Networking
1 2 (50.00%) Internet
1 2 (50.00%) WAN
Database & Business Intelligence
1 1 (25.00%) Biml
1 1 (25.00%) Data Warehouse
1 1 (25.00%) Power BI
1 1 (25.00%) SQL Server
1 1 (25.00%) SQL Server Analysis Services
1 1 (25.00%) SQL Server Integration Services
1 1 (25.00%) SQL Server Reporting Services
Development Applications
1 1 (25.00%) Team Foundation Server
Job Titles
1 2 (50.00%) Administrator
1 2 (50.00%) IT Administrator
1 2 (50.00%) Junior
1 2 (50.00%) Junior IT Administrator
2 1 (25.00%) Business Developer
2 1 (25.00%) Business Intelligence Developer
2 1 (25.00%) DBA
2 1 (25.00%) Developer
2 1 (25.00%) Mitel Engineer
2 1 (25.00%) Project Engineer
2 1 (25.00%) SQL BI Developer
2 1 (25.00%) SQL DBA
2 1 (25.00%) SQL Developer
Libraries, Frameworks & Software Standards
1 1 (25.00%) .NET
1 1 (25.00%) ASP.NET
1 1 (25.00%) ASP.NET MVC
Miscellaneous
1 1 (25.00%) Clustering
Processes & Methodologies
1 2 (50.00%) ITIL
2 1 (25.00%) Agile Software Development
2 1 (25.00%) Analytics
2 1 (25.00%) BCP
2 1 (25.00%) Business Intelligence
2 1 (25.00%) CRM
2 1 (25.00%) Dimensional Modelling
2 1 (25.00%) ETL
2 1 (25.00%) Kanban
2 1 (25.00%) Kimball Methodology
2 1 (25.00%) MVC
2 1 (25.00%) Performance Tuning
2 1 (25.00%) Task Automation
2 1 (25.00%) Web Application Development
Programming Languages
1 1 (25.00%) C#
1 1 (25.00%) Data Analysis Expressions (DAX)
1 1 (25.00%) PowerShell
1 1 (25.00%) SQL
1 1 (25.00%) T-SQL
Qualifications
1 3 (75.00%) MCSA
1 3 (75.00%) Microsoft Certification
2 2 (50.00%) A+ Certification
3 1 (25.00%) Computer Science Degree
3 1 (25.00%) Degree
3 1 (25.00%) MCSE
Systems Management
1 1 (25.00%) Failover Clustering
Vendors
1 1 (25.00%) Capita
1 1 (25.00%) Microsoft
1 1 (25.00%) Mitel