Period
to 23 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Somerset with a requirement for Microsoft Office skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Microsoft Office over the 6 months to 23 November 2017 with a comparison to the same period in the previous 2 years.

Microsoft Office
South West > Somerset
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 61 57 58
Rank change year-on-year -4 +1 +2
Permanent jobs citing Microsoft Office 55 58 56
As % of all permanent IT jobs advertised in Somerset 4.10% 4.35% 4.48%
As % of the Applications category 54.46% 51.79% 71.79%
Number of salaries quoted 42 57 45
Somerset median annual salary £33,000 £34,000 £27,500
Median salary % change year-on-year -2.94% +23.64% -8.61%
10th Percentile £21,025 £19,500 £21,250
90th Percentile £45,000 £42,500 £48,600
South West median annual salary £28,500 £27,500 £28,034
% change year-on-year +3.64% -1.90% +0.12%

Microsoft Office is in the Software Applications category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Somerset with a requirement for software application skills.

All Software Application Skills
Somerset
Permanent vacancies with a requirement for software application skills 101 112 78
As % of all permanent IT jobs advertised in Somerset 7.54% 8.40% 6.24%
Number of salaries quoted 78 100 65
Somerset median annual salary £32,750 £34,000 £28,000
Median salary % change year-on-year -3.68% +21.43% -11.11%
10th Percentile £21,175 £19,500 £21,250
90th Percentile £45,750 £52,500 £48,250
South West median annual salary £32,500 £32,500 £32,500

Microsoft Office
Job Vacancy Trend in Somerset

Job postings citing Microsoft Office as a percentage of all IT jobs advertised in Somerset.

Job vacancy trend for Microsoft Office in Somerset

Microsoft Office
Salary Trend in Somerset

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Microsoft Office in Somerset.

Salary trend for Microsoft Office in Somerset

Microsoft Office
Salary Histogram in Somerset

The salary distribution of IT jobs citing Microsoft Office in Somerset over the 6 months to 23 November 2017.

Salary histogram for Microsoft Office in Somerset

Microsoft Office
Job Locations in Somerset

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Microsoft Office within the Somerset region over the 6 months to 23 November 2017. 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
Bath -10 18 £34,000 +44.68% 1
Taunton +17 10 £36,250 +20.83%
Clevedon -17 4 £22,500 -33.82%
Cheddar - 3 £23,500 -
Weston-super-Mare -1 2 £22,500 -16.67%
Street +15 1 £27,500 -42.11%
Yeovil +2 1 £20,000 -
Microsoft Office
South West

For the 6 months to 23 November 2017, IT jobs citing Microsoft Office 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 Somerset region with a requirement for Microsoft Office.

1 48 (87.27%) Microsoft
2 24 (43.64%) Windows
3 21 (38.18%) Office 365
4 17 (30.91%) Windows Server
4 17 (30.91%) VMware
5 15 (27.27%) Microsoft Excel
5 15 (27.27%) Active Directory
6 13 (23.64%) SQL
6 13 (23.64%) Degree
7 12 (21.82%) Finance
7 12 (21.82%) Windows 10
7 12 (21.82%) VMware Infrastructure
8 10 (18.18%) Windows 7
8 10 (18.18%) Xerox
9 9 (16.36%) SAN
9 9 (16.36%) Microsoft Azure
10 8 (14.55%) Windows Server 2012
10 8 (14.55%) SQL Server
11 7 (12.73%) MS Exchange
11 7 (12.73%) SLA
11 7 (12.73%) HP
11 7 (12.73%) Wireless
11 7 (12.73%) Agile Software Development
11 7 (12.73%) Test Automation
11 7 (12.73%) Security Cleared
11 7 (12.73%) Windows Server 2008
11 7 (12.73%) Driving Licence
12 6 (10.91%) vCenter Server
12 6 (10.91%) vSphere
12 6 (10.91%) ERP

Microsoft Office
Co-occurring IT Skills in Somerset 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 7 (12.73%) MS Exchange
2 3 (5.45%) SharePoint
3 2 (3.64%) Exchange Server 2010
4 1 (1.82%) Skype for Business
Applications
1 15 (27.27%) Microsoft Excel
2 4 (7.27%) Microsoft PowerPoint
3 3 (5.45%) Microsoft Project
3 3 (5.45%) MS Visio
4 1 (1.82%) Spreadsheet
Business Applications
1 4 (7.27%) Dynamics AX
Cloud Services
1 21 (38.18%) Office 365
2 9 (16.36%) Microsoft Azure
3 4 (7.27%) Amazon AWS
4 1 (1.82%) Cloud Computing
4 1 (1.82%) Dynamics 365
Communications & Networking
1 9 (16.36%) SAN
2 7 (12.73%) Wireless
3 5 (9.09%) LAN
3 5 (9.09%) WLAN
4 4 (7.27%) DECT
4 4 (7.27%) Firewall
5 2 (3.64%) Remote Desktop
5 2 (3.64%) TCP/IP
5 2 (3.64%) VLAN
5 2 (3.64%) VPN
5 2 (3.64%) WAN
6 1 (1.82%) Skype
Database & Business Intelligence
1 8 (14.55%) SQL Server
2 4 (7.27%) MySQL
3 3 (5.45%) SQL Server Reporting Services
4 2 (3.64%) Crystal Reports
4 2 (3.64%) SQL Server 2008
Development Applications
1 4 (7.27%) Team Foundation Server
1 4 (7.27%) Visual Studio Team System
General
1 12 (21.82%) Finance
2 5 (9.09%) Marketing
2 5 (9.09%) Publishing
3 4 (7.27%) Advertising
3 4 (7.27%) Law
3 4 (7.27%) Manufacturing
4 3 (5.45%) Military
5 1 (1.82%) Banking
Job Titles
1 12 (21.82%) Support Engineer
2 10 (18.18%) Analyst
3 9 (16.36%) IT Support
4 7 (12.73%) Systems Analyst
5 6 (10.91%) IT Technician
6 5 (9.09%) IT Engineer
6 5 (9.09%) IT Support Engineer
6 5 (9.09%) Senior Analyst
6 5 (9.09%) Senior Support Analyst
6 5 (9.09%) Senior Systems Analyst
6 5 (9.09%) Support Analyst
6 5 (9.09%) Support Technician
6 5 (9.09%) Systems Support
6 5 (9.09%) Systems Support Analyst
7 4 (7.27%) 3rd Line Engineer
7 4 (7.27%) 3rd Line Support
7 4 (7.27%) 3rd Line Support Engineer
7 4 (7.27%) IT Support Technician
8 3 (5.45%) QA Test Engineer
8 3 (5.45%) Software QA Engineer
Libraries, Frameworks & Software Standards
1 5 (9.09%) .NET
2 4 (7.27%) .NET Framework
2 4 (7.27%) ASP.NET
2 4 (7.27%) ASP.NET MVC
2 4 (7.27%) WPF
3 3 (5.45%) LAMP
3 3 (5.45%) Web Services
4 2 (3.64%) EDI
5 1 (1.82%) COM
Miscellaneous
1 7 (12.73%) Driving Licence
2 5 (9.09%) Analytical Skills
2 5 (9.09%) Management Information System
3 4 (7.27%) CCTV
3 4 (7.27%) Graphic Design
4 3 (5.45%) Computer Science
5 2 (3.64%) Life Science
5 2 (3.64%) Replication
6 1 (1.82%) Digital Media
6 1 (1.82%) Social Media
Operating Systems
1 24 (43.64%) Windows
2 17 (30.91%) Windows Server
3 12 (21.82%) Windows 10
4 10 (18.18%) Windows 7
5 8 (14.55%) Windows Server 2012
6 7 (12.73%) Windows Server 2008
7 3 (5.45%) Windows 8
8 2 (3.64%) Linux
8 2 (3.64%) Windows Server 2003
9 1 (1.82%) Mac OS X
Processes & Methodologies
1 7 (12.73%) Agile Software Development
1 7 (12.73%) Test Automation
2 6 (10.91%) ERP
2 6 (10.91%) ITIL
3 5 (9.09%) Document Management
3 5 (9.09%) Project Management
3 5 (9.09%) Service Delivery
3 5 (9.09%) Time Management
4 4 (7.27%) Data Analysis
4 4 (7.27%) Facilities Management
4 4 (7.27%) Logistics
4 4 (7.27%) MVC
4 4 (7.27%) Personalization
4 4 (7.27%) Process Improvement
4 4 (7.27%) SDLC
4 4 (7.27%) Supply Chain Management
4 4 (7.27%) System Testing
4 4 (7.27%) Workflow
5 3 (5.45%) Performance Testing
5 3 (5.45%) Software Testing
Programming Languages
1 13 (23.64%) SQL
2 4 (7.27%) C#
3 3 (5.45%) VBScript
Qualifications
1 13 (23.64%) Degree
2 7 (12.73%) Security Cleared
3 4 (7.27%) BPSS Clearance
3 4 (7.27%) SC Cleared
4 3 (5.45%) Computer Science Degree
4 3 (5.45%) ISTQB
5 1 (1.82%) DV Cleared
5 1 (1.82%) PMI Certification
5 1 (1.82%) PMP
5 1 (1.82%) PRINCE2 Certification
5 1 (1.82%) PRINCE2 Practitioner
Quality Assurance & Compliance
1 7 (12.73%) SLA
2 4 (7.27%) QA
3 2 (3.64%) Data Quality
3 2 (3.64%) PMO
4 1 (1.82%) Actionable Recommendations
System Software
1 15 (27.27%) Active Directory
2 12 (21.82%) VMware Infrastructure
3 6 (10.91%) vSphere
4 2 (3.64%) Virtual Desktop
Systems Management
1 6 (10.91%) vCenter Server
2 5 (9.09%) SCCM
3 3 (5.45%) Systems Management Server (SMS)
4 2 (3.64%) NetBackup
Vendors
1 48 (87.27%) Microsoft
2 17 (30.91%) VMware
3 10 (18.18%) Xerox
4 7 (12.73%) HP
5 5 (9.09%) 3PAR
5 5 (9.09%) Barracuda Networks
5 5 (9.09%) Cisco
6 4 (7.27%) Mitel
6 4 (7.27%) Xamarin
7 3 (5.45%) Apple
8 2 (3.64%) Citrix
8 2 (3.64%) Salesforce.com
8 2 (3.64%) Sun
8 2 (3.64%) Veeam
9 1 (1.82%) Google
9 1 (1.82%) SAP