Period
to 19 February 2018

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

Microsoft Certified Solutions Associate (MCSA) formerly Microsoft Certified Systems Administrator
Yorkshire > West Yorkshire
6 months to
19 Feb 2018
Same period 2017 Same period 2016
Rank 181 193 279
Rank change year-on-year +12 +86 -52
Permanent jobs citing MCSA 74 69 28
As % of all permanent IT jobs advertised in West Yorkshire 1.08% 0.96% 0.31%
As % of the Qualifications category 6.31% 4.49% 1.35%
Number of salaries quoted 74 56 27
West Yorkshire median annual salary £45,000 £37,750 £36,000
Median salary % change year-on-year +19.21% +4.86% +20.00%
10th Percentile £25,750 £22,250 £17,200
90th Percentile £63,875 £43,125 £42,500
Yorkshire median annual salary £42,500 £33,500 £35,500
% change year-on-year +26.87% -5.63% +22.41%

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

All Academic and Professional Certifications
West Yorkshire
Permanent vacancies requiring academic qualifications or professional certifications 1,172 1,536 2,072
As % of all permanent IT jobs advertised in West Yorkshire 17.04% 21.44% 22.95%
Number of salaries quoted 969 1,297 1,576
West Yorkshire median annual salary £40,000 £40,000 £40,000
10th Percentile £26,200 £25,750 £24,500
90th Percentile £60,000 £56,750 £60,000
Yorkshire median annual salary £40,000 £40,000 £40,000

MCSA
Job Vacancy Trend in West Yorkshire

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

Job vacancy trend for MCSA in West Yorkshire

MCSA
Salary Trend in West Yorkshire

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

Salary trend for MCSA in West Yorkshire

MCSA
Salary Histogram in West Yorkshire

The salary distribution of IT jobs citing MCSA in West Yorkshire over the 6 months to 19 February 2018.

Salary histogram for MCSA in West Yorkshire

MCSA
Job Locations in West Yorkshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing MCSA within the West Yorkshire region over the 6 months to 19 February 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
Leeds +16 44 £40,000 +5.26% 11
Bradford +11 25 £50,000 +60.00% 2
Wakefield - 2 £18,000 -
Batley - 1 - -
Brighouse - 1 - -
Halifax - 1 £32,500 -
Liversedge - 1 £23,500 -
MCSA
Yorkshire

For the 6 months to 19 February 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 West Yorkshire region with a requirement for MCSA.

1 74 (100.00%) Microsoft Certification
2 62 (83.78%) Microsoft
3 57 (77.03%) MCSE
4 39 (52.70%) Windows
5 32 (43.24%) SQL
5 32 (43.24%) SQL Server
5 32 (43.24%) Active Directory
6 26 (35.14%) PowerShell
6 26 (35.14%) Windows Server
7 25 (33.78%) Microsoft Azure
8 22 (29.73%) Office 365
9 21 (28.38%) SQL Server Reporting Services
9 21 (28.38%) SQL Server Integration Services
9 21 (28.38%) T-SQL
10 19 (25.68%) ETL
10 19 (25.68%) Disaster Recovery
11 18 (24.32%) Performance Tuning
12 16 (21.62%) Business Intelligence
13 15 (20.27%) WAN
13 15 (20.27%) MCP
13 15 (20.27%) Firewall
14 14 (18.92%) ITIL
14 14 (18.92%) Windows Server 2008
14 14 (18.92%) Azure Active Directory
15 13 (17.57%) SaaS
15 13 (17.57%) LAN
15 13 (17.57%) Cisco Certification
16 12 (16.22%) Finance
16 12 (16.22%) VMware
16 12 (16.22%) Data Warehouse

MCSA
Co-occurring IT Skills in West 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 12 (16.22%) MS Exchange
2 10 (13.51%) SharePoint
3 7 (9.46%) Exchange Server 2010
4 6 (8.11%) IIS
5 5 (6.76%) Skype for Business
6 2 (2.70%) Blackberry Enterprise Server
6 2 (2.70%) Exchange Server 2013
7 1 (1.35%) Apache
7 1 (1.35%) Exchange Server 2003
7 1 (1.35%) IBM Domino
7 1 (1.35%) IBM Notes
7 1 (1.35%) SharePoint 2010
Applications
1 9 (12.16%) Microsoft Office
2 3 (4.05%) Microsoft Excel
Business Applications
1 2 (2.70%) Dynamics CRM
1 2 (2.70%) Remedy ITSM
2 1 (1.35%) Sage X3
Cloud Services
1 25 (33.78%) Microsoft Azure
2 22 (29.73%) Office 365
3 14 (18.92%) Azure Active Directory
4 13 (17.57%) SaaS
5 6 (8.11%) IaaS
6 5 (6.76%) PaaS
7 3 (4.05%) Amazon AWS
8 1 (1.35%) OneDrive
Communications & Networking
1 15 (20.27%) Firewall
1 15 (20.27%) WAN
2 13 (17.57%) LAN
3 10 (13.51%) DNS
3 10 (13.51%) TCP/IP
4 7 (9.46%) DHCP
4 7 (9.46%) VPN
5 6 (8.11%) SSL
6 4 (5.41%) FTP
6 4 (5.41%) HTTP
6 4 (5.41%) HTTPS
6 4 (5.41%) Skype
6 4 (5.41%) SMTP
6 4 (5.41%) Telnet
6 4 (5.41%) VoIP
6 4 (5.41%) Wireless
7 3 (4.05%) Cisco ASA
7 3 (4.05%) Network Security
7 3 (4.05%) Remote Desktop
7 3 (4.05%) SAN
Database & Business Intelligence
1 32 (43.24%) SQL Server
2 21 (28.38%) SQL Server Integration Services
2 21 (28.38%) SQL Server Reporting Services
3 12 (16.22%) Data Warehouse
3 12 (16.22%) SQL Server Analysis Services
4 9 (12.16%) SQL Server 2012
5 7 (9.46%) SQL Server 2014
5 7 (9.46%) SQL Server 2016
6 6 (8.11%) Azure SQL Database
6 6 (8.11%) Power BI
7 3 (4.05%) Crystal Reports
7 3 (4.05%) Data Mining
8 2 (2.70%) Data Lake
9 1 (1.35%) SQL Server 2000
9 1 (1.35%) SQL Server 2008
Development Applications
1 9 (12.16%) SQL Server Management Studio (SSMS)
2 3 (4.05%) Team Foundation Server
General
1 12 (16.22%) Finance
2 3 (4.05%) Marketing
3 2 (2.70%) Manufacturing
Job Titles
1 19 (25.68%) Administrator
2 18 (24.32%) DBA
3 9 (12.16%) Analyst
3 9 (12.16%) Implementation Specialist
3 9 (12.16%) IT Support
3 9 (12.16%) Migration Specialist
3 9 (12.16%) Office 365 Specialist
3 9 (12.16%) Senior DBA
3 9 (12.16%) Senior SQL DBA
3 9 (12.16%) SQL DBA
4 6 (8.11%) Cloud Engineer
5 4 (5.41%) IT Analyst
5 4 (5.41%) IT Support Technician
5 4 (5.41%) IT Technician
5 4 (5.41%) Service Analyst
5 4 (5.41%) Service Desk Analyst
5 4 (5.41%) Support Technician
5 4 (5.41%) Technical Engineer
6 3 (4.05%) Architect
6 3 (4.05%) Support Engineer
Miscellaneous
1 5 (6.76%) Analytical Skills
2 4 (5.41%) Management Information System
3 3 (4.05%) Data Centre
3 3 (4.05%) Linux Command Line
3 3 (4.05%) Microsoft Licensing
3 3 (4.05%) PlayStation
4 2 (2.70%) FMCG
5 1 (1.35%) CMDB
5 1 (1.35%) Hybrid Cloud
5 1 (1.35%) PKI
5 1 (1.35%) Private Cloud
5 1 (1.35%) Public Cloud
Operating Systems
1 39 (52.70%) Windows
2 26 (35.14%) Windows Server
3 14 (18.92%) Windows Server 2008
4 11 (14.86%) Windows Server 2012
5 9 (12.16%) Windows 10
5 9 (12.16%) Windows 7
6 8 (10.81%) Linux
7 6 (8.11%) Windows Server 2003
8 4 (5.41%) Windows XP
9 3 (4.05%) CentOS
9 3 (4.05%) Mac OS
9 3 (4.05%) Ubuntu
9 3 (4.05%) Windows Vista
10 2 (2.70%) Windows 8
Processes & Methodologies
1 19 (25.68%) Disaster Recovery
1 19 (25.68%) ETL
2 18 (24.32%) Performance Tuning
3 16 (21.62%) Business Intelligence
4 14 (18.92%) ITIL
5 12 (16.22%) Data Modelling
6 10 (13.51%) Migration
6 10 (13.51%) Stakeholder Engagement
7 9 (12.16%) E-Commerce
7 9 (12.16%) Load Balancing
7 9 (12.16%) Performance Analysis
8 7 (9.46%) Change Management
8 7 (9.46%) Coaching
9 6 (8.11%) Problem Management
10 5 (6.76%) Presales
10 5 (6.76%) PRINCE2
11 4 (5.41%) Asset Management
11 4 (5.41%) CRM
11 4 (5.41%) ERP
11 4 (5.41%) Fault Analysis
Programming Languages
1 32 (43.24%) SQL
2 26 (35.14%) PowerShell
3 21 (28.38%) T-SQL
4 3 (4.05%) Bash Shell
4 3 (4.05%) VBA
Qualifications
1 74 (100.00%) Microsoft Certification
2 57 (77.03%) MCSE
3 15 (20.27%) MCP
4 13 (17.57%) Cisco Certification
5 11 (14.86%) CCNA
6 5 (6.76%) CCNP
7 4 (5.41%) Degree
8 3 (4.05%) MCITP
9 2 (2.70%) ITIL Foundation Certificate
9 2 (2.70%) PRINCE2 Certification
9 2 (2.70%) VMware Certified Professional (VCP)
10 1 (1.35%) JNCIS
10 1 (1.35%) MCDST
10 1 (1.35%) MCTS
10 1 (1.35%) SC Cleared
10 1 (1.35%) Security Cleared
Quality Assurance & Compliance
1 5 (6.76%) SLA
2 1 (1.35%) HIPAA
2 1 (1.35%) ISO/IEC 27001
2 1 (1.35%) PCI DSS
System Software
1 32 (43.24%) Active Directory
2 8 (10.81%) VMware Infrastructure
3 7 (9.46%) Hyper-V
4 5 (6.76%) Terminal Services
4 5 (6.76%) XenApp
5 4 (5.41%) Virtual Servers
6 3 (4.05%) XenDesktop
7 1 (1.35%) Microsoft Virtual Server
Systems Management
1 4 (5.41%) MaaS360
2 3 (4.05%) SCCM
3 2 (2.70%) Backup Exec
3 2 (2.70%) Cisco CUCM
3 2 (2.70%) Cisco UCCE
4 1 (1.35%) AirWatch
4 1 (1.35%) EMC NetWorker
4 1 (1.35%) Microsoft Intune
4 1 (1.35%) NetBackup
4 1 (1.35%) Norton AntiVirus
4 1 (1.35%) SCOM
4 1 (1.35%) Simpana
4 1 (1.35%) Single Sign-On
Vendors
1 62 (83.78%) Microsoft
2 12 (16.22%) VMware
3 9 (12.16%) Cisco
4 8 (10.81%) Citrix
5 4 (5.41%) Kaspersky
5 4 (5.41%) Sophos
6 3 (4.05%) Apple
6 3 (4.05%) CheckPoint
6 3 (4.05%) Red Hat
6 3 (4.05%) RedGate
6 3 (4.05%) Tableau
7 2 (2.70%) BMC
7 2 (2.70%) CommVault
7 2 (2.70%) MobileIron
7 2 (2.70%) Remedy
7 2 (2.70%) SolarWinds
7 2 (2.70%) Symantec
8 1 (1.35%) Altiris
8 1 (1.35%) F5
8 1 (1.35%) Veeam