Period
to 16 January 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 16 January 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
16 Jan 2018
Same period 2017 Same period 2016
Rank 192 226 328
Rank change year-on-year +34 +102 -54
Permanent jobs citing MCSA 108 106 33
As % of all permanent IT jobs advertised in Yorkshire 1.13% 0.99% 0.26%
As % of the Qualifications category 6.41% 4.49% 1.08%
Number of salaries quoted 98 73 36
Yorkshire median annual salary £45,000 £32,500 £36,000
Median salary % change year-on-year +38.46% -9.72% +19.76%
10th Percentile £23,275 £21,350 £17,200
90th Percentile £60,375 £40,000 £42,500
England median annual salary £35,000 £37,250 £35,000
% change year-on-year -6.04% +6.43% -

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,684 2,360 3,042
As % of all permanent IT jobs advertised in Yorkshire 17.57% 21.96% 24.35%
Number of salaries quoted 1,397 1,948 2,344
Yorkshire median annual salary £40,000 £40,000 £40,000
10th Percentile £23,500 £25,000 £23,000
90th Percentile £60,000 £60,000 £61,250
England median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - -

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 16 January 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 16 January 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 +16 93 £45,000 +34.33% 6
South Yorkshire +10 9 £75,000 +188.46%
North Yorkshire - 4 £75,000 -
East Yorkshire -7 3 £24,000 -4.00%
MCSA
England

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

1 108 (100.00%) Microsoft Certification
2 86 (79.63%) Microsoft
3 81 (75.00%) MCSE
4 59 (54.63%) Windows
5 54 (50.00%) SQL Server
6 51 (47.22%) SQL
7 45 (41.67%) Active Directory
8 43 (39.81%) PowerShell
9 40 (37.04%) Windows Server
10 38 (35.19%) T-SQL
11 36 (33.33%) Performance Tuning
12 32 (29.63%) SQL Server Integration Services
12 32 (29.63%) SQL Server Reporting Services
13 28 (25.93%) Disaster Recovery
14 27 (25.00%) ETL
14 27 (25.00%) Windows Server 2008
14 27 (25.00%) Microsoft Azure
15 26 (24.07%) VMware
16 25 (23.15%) MCP
16 25 (23.15%) Office 365
17 24 (22.22%) ITIL
18 21 (19.44%) TCP/IP
18 21 (19.44%) VMware Infrastructure
18 21 (19.44%) Windows Server 2012
19 20 (18.52%) SQL Server Analysis Services
19 20 (18.52%) Cisco Certification
20 18 (16.67%) CCNA
20 18 (16.67%) E-Commerce
20 18 (16.67%) Firewall
20 18 (16.67%) Finance

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 16 (14.81%) MS Exchange
2 10 (9.26%) Exchange Server 2010
3 9 (8.33%) SharePoint
4 8 (7.41%) IIS
5 4 (3.70%) Skype for Business
6 2 (1.85%) Apache
6 2 (1.85%) Blackberry Enterprise Server
6 2 (1.85%) Exchange Server 2013
7 1 (0.93%) Exchange Server 2003
7 1 (0.93%) IBM Domino
7 1 (0.93%) IBM Notes
7 1 (0.93%) SharePoint 2010
Applications
1 13 (12.04%) Microsoft Office
2 3 (2.78%) Microsoft Excel
Business Applications
1 4 (3.70%) Dynamics CRM
2 2 (1.85%) Remedy ITSM
3 1 (0.93%) Sage X3
Cloud Services
1 27 (25.00%) Microsoft Azure
2 25 (23.15%) Office 365
3 13 (12.04%) SaaS
4 11 (10.19%) Amazon AWS
4 11 (10.19%) Azure Active Directory
5 6 (5.56%) IaaS
6 5 (4.63%) PaaS
7 1 (0.93%) OneDrive
Communications & Networking
1 21 (19.44%) TCP/IP
2 18 (16.67%) Firewall
3 17 (15.74%) WAN
4 15 (13.89%) LAN
5 13 (12.04%) DNS
6 10 (9.26%) DHCP
7 9 (8.33%) VPN
8 8 (7.41%) Wi-Fi
9 7 (6.48%) SAN
10 6 (5.56%) SSL
11 5 (4.63%) SMTP
11 5 (4.63%) VoIP
12 4 (3.70%) FTP
12 4 (3.70%) HTTP
12 4 (3.70%) HTTPS
12 4 (3.70%) Telnet
12 4 (3.70%) Wireless
13 3 (2.78%) Cisco ASA
13 3 (2.78%) Network Security
13 3 (2.78%) Skype
Database & Business Intelligence
1 54 (50.00%) SQL Server
2 32 (29.63%) SQL Server Integration Services
2 32 (29.63%) SQL Server Reporting Services
3 20 (18.52%) SQL Server Analysis Services
4 18 (16.67%) SQL Server 2014
5 15 (13.89%) Data Warehouse
5 15 (13.89%) SQL Server 2012
6 13 (12.04%) SQL Server 2016
7 6 (5.56%) Azure SQL Database
7 6 (5.56%) NoSQL
7 6 (5.56%) SQL Server 2008
8 5 (4.63%) SQL Server 2005
9 4 (3.70%) Power BI
10 3 (2.78%) Crystal Reports
10 3 (2.78%) Data Mining
11 2 (1.85%) Data Lake
12 1 (0.93%) SQL Server 2000
Development Applications
1 12 (11.11%) SQL Server Management Studio (SSMS)
2 9 (8.33%) Team Foundation Server
3 6 (5.56%) Git (software)
General
1 18 (16.67%) Finance
2 3 (2.78%) Marketing
3 2 (1.85%) Law
3 2 (1.85%) Manufacturing
4 1 (0.93%) Telecoms
Job Titles
1 37 (34.26%) Administrator
2 36 (33.33%) DBA
3 18 (16.67%) SQL DBA
4 17 (15.74%) Senior DBA
4 17 (15.74%) Senior SQL DBA
5 14 (12.96%) Support Engineer
6 11 (10.19%) IT Support
7 10 (9.26%) Analyst
8 8 (7.41%) Implementation Specialist
8 8 (7.41%) Migration Specialist
8 8 (7.41%) Office 365 Specialist
9 6 (5.56%) IT Support Technician
9 6 (5.56%) IT Technician
9 6 (5.56%) Support Technician
10 5 (4.63%) 3rd Line Engineer
10 5 (4.63%) IT Analyst
11 4 (3.70%) Service Analyst
11 4 (3.70%) Service Desk Analyst
12 3 (2.78%) Field Engineer
12 3 (2.78%) Systems Engineer
Miscellaneous
1 7 (6.48%) Private Cloud
2 5 (4.63%) Analytical Skills
2 5 (4.63%) Data Centre
3 4 (3.70%) Management Information System
4 2 (1.85%) FMCG
4 2 (1.85%) Linux Command Line
5 1 (0.93%) CMDB
5 1 (0.93%) Hybrid Cloud
5 1 (0.93%) Microsoft Licensing
5 1 (0.93%) PKI
5 1 (0.93%) PlayStation
5 1 (0.93%) Public Cloud
Operating Systems
1 59 (54.63%) Windows
2 40 (37.04%) Windows Server
3 27 (25.00%) Windows Server 2008
4 21 (19.44%) Windows Server 2012
5 16 (14.81%) Windows 7
6 13 (12.04%) Windows 10
7 11 (10.19%) Linux
8 8 (7.41%) Windows 8
8 8 (7.41%) Windows Server 2003
9 6 (5.56%) Windows XP
10 3 (2.78%) Mac OS
10 3 (2.78%) Windows Vista
11 2 (1.85%) Ubuntu
11 2 (1.85%) Unix
12 1 (0.93%) CentOS
12 1 (0.93%) Red Hat Enterprise Linux
Processes & Methodologies
1 36 (33.33%) Performance Tuning
2 28 (25.93%) Disaster Recovery
3 27 (25.00%) ETL
4 24 (22.22%) ITIL
5 18 (16.67%) E-Commerce
5 18 (16.67%) Performance Analysis
6 17 (15.74%) Business Intelligence
7 15 (13.89%) Data Modelling
8 9 (8.33%) Change Management
8 9 (8.33%) Load Balancing
8 9 (8.33%) Migration
8 9 (8.33%) Stakeholder Engagement
9 7 (6.48%) Coaching
10 6 (5.56%) CRM
10 6 (5.56%) Data Management
10 6 (5.56%) High Availability
10 6 (5.56%) PRINCE2
10 6 (5.56%) Problem Management
10 6 (5.56%) Project Planning
10 6 (5.56%) Time Management
Programming Languages
1 51 (47.22%) SQL
2 43 (39.81%) PowerShell
3 38 (35.19%) T-SQL
4 3 (2.78%) VBA
5 1 (0.93%) Bash Shell
Qualifications
1 108 (100.00%) Microsoft Certification
2 81 (75.00%) MCSE
3 25 (23.15%) MCP
4 20 (18.52%) Cisco Certification
5 18 (16.67%) CCNA
6 5 (4.63%) CCNP
7 4 (3.70%) Degree
7 4 (3.70%) MCITP
8 3 (2.78%) ITIL Certification
8 3 (2.78%) MCDST
8 3 (2.78%) VMware Certified Professional (VCP)
9 2 (1.85%) ITIL Foundation Certificate
9 2 (1.85%) PRINCE2 Certification
10 1 (0.93%) JNCIS
10 1 (0.93%) MCDBA
10 1 (0.93%) MCTS
10 1 (0.93%) SC Cleared
10 1 (0.93%) Security Cleared
Quality Assurance & Compliance
1 12 (11.11%) SLA
2 1 (0.93%) HIPAA
2 1 (0.93%) ISO/IEC 27001
2 1 (0.93%) PCI DSS
System Software
1 45 (41.67%) Active Directory
2 21 (19.44%) VMware Infrastructure
3 16 (14.81%) Hyper-V
4 6 (5.56%) Virtual Machines
5 5 (4.63%) Terminal Services
5 5 (4.63%) XenApp
6 4 (3.70%) Virtual Servers
7 3 (2.78%) XenDesktop
8 1 (0.93%) Microsoft Virtual Server
8 1 (0.93%) VMware Server
Systems Management
1 5 (4.63%) Backup Exec
2 3 (2.78%) SCCM
3 2 (1.85%) Cisco CUCM
3 2 (1.85%) Cisco UCCE
3 2 (1.85%) EMC NetWorker
3 2 (1.85%) NetBackup
3 2 (1.85%) SCOM
3 2 (1.85%) Simpana
4 1 (0.93%) AirWatch
4 1 (0.93%) Microsoft Intune
4 1 (0.93%) Norton AntiVirus
Vendors
1 86 (79.63%) Microsoft
2 26 (24.07%) VMware
3 12 (11.11%) Cisco
4 8 (7.41%) Citrix
5 6 (5.56%) Oracle
6 4 (3.70%) CommVault
6 4 (3.70%) Kaspersky
6 4 (3.70%) Sophos
6 4 (3.70%) Symantec
7 3 (2.78%) Avaya
7 3 (2.78%) CheckPoint
7 3 (2.78%) RedGate
7 3 (2.78%) SolarWinds
7 3 (2.78%) Tableau
7 3 (2.78%) Veeam
8 2 (1.85%) BMC
8 2 (1.85%) EMC
8 2 (1.85%) NetApp
8 2 (1.85%) Red Hat
8 2 (1.85%) Remedy