Period
to 21 June 2018

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

Microsoft Certified Solutions Associate (MCSA) formerly Microsoft Certified Systems Administrator
England > Yorkshire
6 months to
21 Jun 2018
Same period 2017 Same period 2016
Rank 245 208 272
Rank change year-on-year -37 +64 +27
Permanent jobs citing MCSA 65 123 89
As % of all permanent IT jobs advertised in Yorkshire 0.67% 1.15% 0.73%
As % of the Qualifications category 4.42% 5.72% 3.08%
Number of salaries quoted 60 112 78
Yorkshire median annual salary £30,000 £37,500 £26,000
Median salary % change year-on-year -20.00% +44.23% -20.00%
10th Percentile £23,900 £21,250 £19,000
90th Percentile £50,813 £52,500 £51,125
England median annual salary £39,817 £38,250 £35,000
% change year-on-year +4.10% +9.29% -

MCSA 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 Yorkshire with a requirement for academic qualifications or professional certifications.

All Academic and Professional Certifications
Yorkshire
Permanent vacancies requiring academic qualifications or professional certifications 1,469 2,151 2,894
As % of all permanent IT jobs advertised in Yorkshire 15.23% 20.15% 23.87%
Number of salaries quoted 1,226 1,717 2,354
Yorkshire median annual salary £42,500 £42,500 £40,000
Median salary % change year-on-year - +6.25% -
10th Percentile £22,375 £23,500 £23,075
90th Percentile £60,000 £60,000 £60,000
England median annual salary £50,000 £45,000 £47,000
% change year-on-year +11.11% -4.26% +4.44%

MCSA
Job Vacancy Trend in Yorkshire

Job postings citing MCSA as a percentage of all IT jobs advertised in Yorkshire.

Job vacancy trend for MCSA in Yorkshire

MCSA
Salary Trend in Yorkshire

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

Salary trend for MCSA in Yorkshire

MCSA
Salary Histogram in Yorkshire

The salary distribution of IT jobs citing MCSA in Yorkshire over the 6 months to 21 June 2018.

Salary histogram for MCSA in Yorkshire

MCSA
Job Locations in Yorkshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing MCSA within the Yorkshire region over the 6 months to 21 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
West Yorkshire -23 51 £37,500 -6.25% 12
South Yorkshire +21 11 £28,000 -41.05%
North Yorkshire +7 2 £26,250 -25.00% 2
MCSA
England

For the 6 months to 21 June 2018, IT jobs citing MCSA 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 across the Yorkshire region with a requirement for MCSA.

1 65 (100.00%) Microsoft Certification
2 60 (92.31%) Microsoft
3 43 (66.15%) MCSE
4 34 (52.31%) Office 365
5 32 (49.23%) Windows
6 30 (46.15%) Microsoft Azure
7 29 (44.62%) Active Directory
8 24 (36.92%) Windows Server
9 21 (32.31%) VMware
10 19 (29.23%) SharePoint
11 16 (24.62%) SQL
11 16 (24.62%) Cisco
12 15 (23.08%) SQL Server
12 15 (23.08%) MS Exchange
13 14 (21.54%) Disaster Recovery
14 13 (20.00%) VMware Infrastructure
15 12 (18.46%) Microsoft Office
16 11 (16.92%) ITIL
16 11 (16.92%) Business Intelligence
16 11 (16.92%) PowerShell
16 11 (16.92%) Windows Server 2012
17 10 (15.38%) Commercial Awareness
17 10 (15.38%) VMware Certified Professional (VCP)
17 10 (15.38%) Veeam
18 9 (13.85%) Firewall
18 9 (13.85%) Finance
18 9 (13.85%) CCNA
18 9 (13.85%) Cisco Certification
18 9 (13.85%) T-SQL
18 9 (13.85%) Linux

MCSA
Co-occurring IT Skills in Yorkshire 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 19 (29.23%) SharePoint
2 15 (23.08%) MS Exchange
3 6 (9.23%) Skype for Business
4 5 (7.69%) Exchange Server 2013
5 4 (6.15%) Exchange Server 2010
5 4 (6.15%) SharePoint 2013
6 3 (4.62%) Exchange Server 2003
7 1 (1.54%) Elasticsearch
7 1 (1.54%) IBM Domino
7 1 (1.54%) IBM Notes
Applications
1 12 (18.46%) Microsoft Office
Business Applications
1 1 (1.54%) Dynamics CRM
1 1 (1.54%) Sage X3
1 1 (1.54%) Visualfiles
Cloud Services
1 34 (52.31%) Office 365
2 30 (46.15%) Microsoft Azure
3 9 (13.85%) Azure Active Directory
4 5 (7.69%) Amazon AWS
4 5 (7.69%) SaaS
5 4 (6.15%) IaaS
6 3 (4.62%) OneDrive
7 2 (3.08%) Dynamics 365
8 1 (1.54%) PaaS
Communications & Networking
1 9 (13.85%) Firewall
2 7 (10.77%) SAN
2 7 (10.77%) Wi-Fi
3 6 (9.23%) DHCP
3 6 (9.23%) DNS
3 6 (9.23%) TCP/IP
4 5 (7.69%) VPN
5 4 (6.15%) IPsec
5 4 (6.15%) LAN
5 4 (6.15%) Skype
5 4 (6.15%) WAN
6 3 (4.62%) SSL
7 2 (3.08%) 3G
7 2 (3.08%) ADSL
7 2 (3.08%) GPRS
7 2 (3.08%) HSDPA
7 2 (3.08%) MPLS
7 2 (3.08%) OSPF
7 2 (3.08%) VoIP
7 2 (3.08%) Wireless
Database & Business Intelligence
1 15 (23.08%) SQL Server
2 8 (12.31%) Data Warehouse
2 8 (12.31%) SQL Server Analysis Services
2 8 (12.31%) SQL Server Integration Services
2 8 (12.31%) SQL Server Reporting Services
3 2 (3.08%) Power BI
4 1 (1.54%) Azure SQL Database
4 1 (1.54%) Data Lake
4 1 (1.54%) SQL Server 2000
4 1 (1.54%) SQL Server 2012
Development Applications
1 8 (12.31%) SQL Server Management Studio (SSMS)
General
1 9 (13.85%) Finance
2 3 (4.62%) Retail
3 1 (1.54%) Legal
3 1 (1.54%) Marketing
3 1 (1.54%) Telecoms
Job Titles
1 12 (18.46%) Support Engineer
2 10 (15.38%) Technical Engineer
3 9 (13.85%) Administrator
3 9 (13.85%) DBA
3 9 (13.85%) IT Support
3 9 (13.85%) Senior DBA
3 9 (13.85%) Senior SQL DBA
3 9 (13.85%) Senior SQL Server DBA
3 9 (13.85%) SQL DBA
3 9 (13.85%) SQL Server DBA
4 8 (12.31%) Cloud Engineer
5 7 (10.77%) 2nd Line Support
6 6 (9.23%) Consultant
6 6 (9.23%) IT Technician
6 6 (9.23%) Office 365 Specialist
6 6 (9.23%) Senior IT Technician
6 6 (9.23%) Senior Technician
7 5 (7.69%) Infrastructure Engineer
7 5 (7.69%) Technical Support
8 4 (6.15%) Technical Support Consultant
Libraries, Frameworks & Software Standards
1 2 (3.08%) JSON
2 1 (1.54%) .NET
Miscellaneous
1 2 (3.08%) Linux Command Line
1 2 (3.08%) Microsoft Licensing
1 2 (3.08%) PlayStation
1 2 (3.08%) Replication
2 1 (1.54%) Driving Licence
2 1 (1.54%) EPoS
2 1 (1.54%) FMCG
2 1 (1.54%) Management Information System
2 1 (1.54%) Public Cloud
Operating Systems
1 32 (49.23%) Windows
2 24 (36.92%) Windows Server
3 11 (16.92%) Windows Server 2012
4 9 (13.85%) Linux
4 9 (13.85%) Windows Server 2008
5 8 (12.31%) Windows 7
6 7 (10.77%) Windows 10
7 6 (9.23%) CentOS
8 5 (7.69%) Windows 8
9 4 (6.15%) Mac OS
9 4 (6.15%) Windows XP
10 2 (3.08%) Ubuntu
10 2 (3.08%) Windows Vista
11 1 (1.54%) HPUX
Processes & Methodologies
1 14 (21.54%) Disaster Recovery
2 11 (16.92%) Business Intelligence
2 11 (16.92%) ITIL
3 10 (15.38%) Commercial Awareness
4 9 (13.85%) Data Modelling
4 9 (13.85%) Performance Tuning
5 8 (12.31%) Problem-Solving
6 7 (10.77%) Migration
7 5 (7.69%) Coaching
7 5 (7.69%) CRM
8 4 (6.15%) Mentoring
8 4 (6.15%) Stakeholder Engagement
8 4 (6.15%) Virtual Infrastructure
9 2 (3.08%) Cybersecurity
9 2 (3.08%) Decision-Making
9 2 (3.08%) Deployment Automation
9 2 (3.08%) DevOps
9 2 (3.08%) High Availability
9 2 (3.08%) Network Management
9 2 (3.08%) Software Licensing
Programming Languages
1 16 (24.62%) SQL
2 11 (16.92%) PowerShell
3 9 (13.85%) T-SQL
4 2 (3.08%) Bash Shell
5 1 (1.54%) VB.NET
Qualifications
1 65 (100.00%) Microsoft Certification
2 43 (66.15%) MCSE
3 10 (15.38%) VMware Certified Professional (VCP)
4 9 (13.85%) CCNA
4 9 (13.85%) Cisco Certification
5 7 (10.77%) MCP
6 5 (7.69%) MCITP
7 4 (6.15%) Degree
7 4 (6.15%) MCTS
8 3 (4.62%) CCNP
8 3 (4.62%) ITIL Certification
8 3 (4.62%) VCP6
9 2 (3.08%) Computer Science Degree
9 2 (3.08%) JNCIS
10 1 (1.54%) DBS Check
10 1 (1.54%) MCDST
10 1 (1.54%) MCSD
10 1 (1.54%) VCP5
Quality Assurance & Compliance
1 8 (12.31%) SLA
System Software
1 29 (44.62%) Active Directory
2 13 (20.00%) VMware Infrastructure
3 5 (7.69%) Hyper-V
4 2 (3.08%) Firmware
4 2 (3.08%) Terminal Services
4 2 (3.08%) XenApp
4 2 (3.08%) XenDesktop
5 1 (1.54%) Docker
5 1 (1.54%) VMware ESXi
5 1 (1.54%) vSphere
Systems Management
1 6 (9.23%) Backup Exec
1 6 (9.23%) SCCM
2 4 (6.15%) AirWatch
3 3 (4.62%) Microsoft Intune
3 3 (4.62%) SCOM
4 2 (3.08%) SCVMM
5 1 (1.54%) MaaS360
5 1 (1.54%) NetBackup
5 1 (1.54%) Norton AntiVirus
5 1 (1.54%) Puppet
5 1 (1.54%) SCOrch
Vendors
1 60 (92.31%) Microsoft
2 21 (32.31%) VMware
3 16 (24.62%) Cisco
4 10 (15.38%) Veeam
5 7 (10.77%) Citrix
6 6 (9.23%) Red Hat
7 2 (3.08%) Apple
7 2 (3.08%) CommVault
7 2 (3.08%) Fortinet
7 2 (3.08%) HP
7 2 (3.08%) Juniper
7 2 (3.08%) SolarWinds
7 2 (3.08%) Symantec
7 2 (3.08%) Zerto
8 1 (1.54%) Capita
8 1 (1.54%) Dell
8 1 (1.54%) EMC
8 1 (1.54%) EqualLogic
8 1 (1.54%) Kaspersky
8 1 (1.54%) Sophos