Period
to 21 November 2017

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

Microsoft Certified Solutions Associate (MCSA) formerly Microsoft Certified Systems Administrator
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 171 172 238
Rank change year-on-year +1 +66 -13
Permanent jobs citing MCSA 56 61 36
As % of all permanent IT jobs advertised in Leeds 1.12% 1.13% 0.52%
As % of the Qualifications category 5.70% 4.82% 2.18%
Number of salaries quoted 53 54 36
Leeds median annual salary £45,000 £36,250 £36,000
Median salary % change year-on-year +24.14% +0.69% +2.86%
10th Percentile £25,750 £19,575 £17,200
90th Percentile £74,000 £42,625 £42,875
West Yorkshire median annual salary £45,000 £32,500 £36,750
% change year-on-year +38.46% -11.56% +13.08%

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

All Academic and Professional Certifications
Leeds
Permanent vacancies requiring academic qualifications or professional certifications 983 1266 1655
As % of all permanent IT jobs advertised in Leeds 19.73% 23.45% 23.88%
Number of salaries quoted 782 1097 1258
Leeds median annual salary £42,500 £40,000 £40,250
Median salary % change year-on-year +6.25% -0.62% +0.63%
10th Percentile £23,525 £26,000 £25,000
90th Percentile £61,250 £62,500 £62,500
West Yorkshire median annual salary £40,000 £40,000 £40,000

MCSA
Job Vacancy Trend in Leeds

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

Job vacancy trend for MCSA in Leeds

MCSA
Salary Trend in Leeds

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

Salary trend for MCSA in Leeds

MCSA
Salary Histogram in Leeds

The salary distribution of IT jobs citing MCSA in Leeds over the 6 months to 21 November 2017.

Salary histogram for MCSA in Leeds

For the 6 months to 21 November 2017, 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 Leeds region with a requirement for MCSA.

1 56 (100.00%) Microsoft Certification
2 45 (80.36%) Microsoft
3 43 (76.79%) MCSE
4 27 (48.21%) Windows
5 26 (46.43%) SQL
6 25 (44.64%) SQL Server
7 23 (41.07%) Active Directory
8 22 (39.29%) T-SQL
9 21 (37.50%) PowerShell
9 21 (37.50%) Windows Server
10 20 (35.71%) Performance Tuning
11 19 (33.93%) E-Commerce
11 19 (33.93%) Performance Analysis
12 16 (28.57%) Windows Server 2008
13 15 (26.79%) ETL
13 15 (26.79%) VMware
13 15 (26.79%) SQL Server Reporting Services
13 15 (26.79%) SQL Server Integration Services
14 14 (25.00%) Microsoft Azure
15 13 (23.21%) Windows Server 2012
15 13 (23.21%) WAN
15 13 (23.21%) MS Exchange
15 13 (23.21%) MCP
16 12 (21.43%) ITIL
16 12 (21.43%) Firewall
17 11 (19.64%) LAN
18 10 (17.86%) Private Cloud
18 10 (17.86%) SQL Server 2014
18 10 (17.86%) SQL Server 2016
18 10 (17.86%) Team Foundation Server

MCSA
Co-occurring IT Skills in Leeds 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 13 (23.21%) MS Exchange
2 8 (14.29%) Exchange Server 2010
3 6 (10.71%) Exchange Server 2013
3 6 (10.71%) SharePoint
4 3 (5.36%) Exchange Server 2003
5 2 (3.57%) Apache
5 2 (3.57%) IBM Domino
5 2 (3.57%) IBM Notes
5 2 (3.57%) IIS
6 1 (1.79%) SharePoint 2010
6 1 (1.79%) Skype for Business
Applications
1 4 (7.14%) Microsoft Office
2 3 (5.36%) Microsoft Excel
Cloud Services
1 14 (25.00%) Microsoft Azure
2 9 (16.07%) Amazon AWS
3 6 (10.71%) Office 365
4 3 (5.36%) Azure Active Directory
4 3 (5.36%) IaaS
4 3 (5.36%) PaaS
Communications & Networking
1 13 (23.21%) WAN
2 12 (21.43%) Firewall
3 11 (19.64%) LAN
4 9 (16.07%) TCP/IP
4 9 (16.07%) VPN
5 7 (12.50%) DNS
6 4 (7.14%) DHCP
6 4 (7.14%) SAN
6 4 (7.14%) VoIP
7 3 (5.36%) Cisco ASA
7 3 (5.36%) iSCSI
7 3 (5.36%) VLAN
8 2 (3.57%) MPLS
8 2 (3.57%) Network Security
8 2 (3.57%) Wireless
9 1 (1.79%) BGP
9 1 (1.79%) EIGRP
9 1 (1.79%) OSPF
9 1 (1.79%) SSL
9 1 (1.79%) VRRP
Database & Business Intelligence
1 25 (44.64%) SQL Server
2 15 (26.79%) SQL Server Integration Services
2 15 (26.79%) SQL Server Reporting Services
3 10 (17.86%) SQL Server 2014
3 10 (17.86%) SQL Server 2016
4 7 (12.50%) NoSQL
5 5 (8.93%) SQL Server 2012
6 3 (5.36%) Crystal Reports
6 3 (5.36%) Data Mining
6 3 (5.36%) Data Warehouse
6 3 (5.36%) Power BI
6 3 (5.36%) SQL Server Analysis Services
7 1 (1.79%) SQL Server 2008
Development Applications
1 10 (17.86%) Team Foundation Server
2 7 (12.50%) Git (software)
General
1 3 (5.36%) Marketing
2 2 (3.57%) Finance
2 2 (3.57%) Law
3 1 (1.79%) Manufacturing
Job Titles
1 21 (37.50%) Administrator
2 20 (35.71%) DBA
3 10 (17.86%) IT Support
4 7 (12.50%) Analyst
4 7 (12.50%) IT Support Technician
4 7 (12.50%) IT Technician
4 7 (12.50%) Support Technician
5 6 (10.71%) Windows Engineer
6 4 (7.14%) Consultant
6 4 (7.14%) Support Analyst
7 3 (5.36%) Architect
7 3 (5.36%) Business Intelligence Analyst
7 3 (5.36%) Infrastructure Architect
7 3 (5.36%) Infrastructure Engineer
7 3 (5.36%) IT Support Analyst
7 3 (5.36%) Senior Infrastructure Engineer
7 3 (5.36%) Server Analyst
7 3 (5.36%) Server Support
7 3 (5.36%) Server Support Analyst
7 3 (5.36%) Support Engineer
Libraries, Frameworks & Software Standards
1 1 (1.79%) COM
Miscellaneous
1 10 (17.86%) Private Cloud
2 7 (12.50%) Analytical Skills
3 5 (8.93%) Management Information System
4 3 (5.36%) CMDB
4 3 (5.36%) Public Cloud
5 2 (3.57%) Data Centre
6 1 (1.79%) Hybrid Cloud
6 1 (1.79%) PKI
Operating Systems
1 27 (48.21%) Windows
2 21 (37.50%) Windows Server
3 16 (28.57%) Windows Server 2008
4 13 (23.21%) Windows Server 2012
5 7 (12.50%) Linux
6 6 (10.71%) Windows 10
6 6 (10.71%) Windows Server 2003
7 5 (8.93%) Windows 7
8 4 (7.14%) Windows XP
9 3 (5.36%) Mac OS
10 2 (3.57%) CentOS
10 2 (3.57%) Red Hat Enterprise Linux
10 2 (3.57%) Unix
10 2 (3.57%) Windows 8
11 1 (1.79%) Windows Vista
Processes & Methodologies
1 20 (35.71%) Performance Tuning
2 19 (33.93%) E-Commerce
2 19 (33.93%) Performance Analysis
3 15 (26.79%) ETL
4 12 (21.43%) ITIL
5 9 (16.07%) Change Management
5 9 (16.07%) Disaster Recovery
5 9 (16.07%) Time Management
6 7 (12.50%) Project Planning
7 5 (8.93%) Data Management
8 4 (7.14%) Asset Management
8 4 (7.14%) Business Intelligence
8 4 (7.14%) Coaching
8 4 (7.14%) Customer-Centricity
8 4 (7.14%) Incident Management
8 4 (7.14%) Presales
9 3 (5.36%) Kimball Methodology
9 3 (5.36%) Master Data Management
9 3 (5.36%) Performance Optimisation
9 3 (5.36%) Statistical Modelling
Programming Languages
1 26 (46.43%) SQL
2 22 (39.29%) T-SQL
3 21 (37.50%) PowerShell
4 3 (5.36%) VBA
Qualifications
1 56 (100.00%) Microsoft Certification
2 43 (76.79%) MCSE
3 13 (23.21%) MCP
4 9 (16.07%) CCNA
4 9 (16.07%) Cisco Certification
5 6 (10.71%) MCITP
6 4 (7.14%) ITIL Foundation Certificate
7 3 (5.36%) CCNP
7 3 (5.36%) MCTS
7 3 (5.36%) SC Cleared
7 3 (5.36%) Security Cleared
7 3 (5.36%) VMware Certified Professional (VCP)
8 2 (3.57%) MCDST
9 1 (1.79%) MCDBA
Quality Assurance & Compliance
1 2 (3.57%) PCI DSS
2 1 (1.79%) HIPAA
2 1 (1.79%) ISO/IEC 27001
2 1 (1.79%) SLA
System Software
1 23 (41.07%) Active Directory
2 9 (16.07%) VMware Infrastructure
3 7 (12.50%) Virtual Machines
4 5 (8.93%) Virtual Servers
5 4 (7.14%) Hyper-V
5 4 (7.14%) Terminal Services
6 3 (5.36%) Microsoft Virtual Server
Systems Management
1 4 (7.14%) Backup Exec
2 3 (5.36%) SCCM
3 2 (3.57%) Norton AntiVirus
3 2 (3.57%) ServiceCenter
4 1 (1.79%) EMC NetWorker
4 1 (1.79%) NetBackup
4 1 (1.79%) SCOM
4 1 (1.79%) SCOrch
4 1 (1.79%) SCSM
4 1 (1.79%) Simpana
Vendors
1 45 (80.36%) Microsoft
2 15 (26.79%) VMware
3 7 (12.50%) Oracle
4 5 (8.93%) Symantec
5 4 (7.14%) Kaspersky
5 4 (7.14%) Sophos
6 3 (5.36%) CheckPoint
6 3 (5.36%) Cisco
6 3 (5.36%) RedGate
6 3 (5.36%) Tableau
6 3 (5.36%) Veeam
7 2 (3.57%) Altiris
7 2 (3.57%) Dell
7 2 (3.57%) HP
7 2 (3.57%) Lotus
7 2 (3.57%) NetApp
7 2 (3.57%) Veritas
8 1 (1.79%) Avaya
8 1 (1.79%) CommVault