Period
to 23 January 2018

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

Microsoft Visual Basic for Applications (VBA)
Hampshire > Portsmouth
6 months to
23 Jan 2018
Same period 2017 Same period 2016
Rank 83 78 90
Rank change year-on-year -5 +12 +14
Permanent jobs citing VBA 2 2 1
As % of all permanent IT jobs advertised in Portsmouth 0.31% 0.33% 0.13%
As % of the Programming Languages category 0.54% 0.53% 0.19%
Number of salaries quoted 2 2 1
Portsmouth median annual salary £47,500 £40,000 £22,000
Median salary % change year-on-year +18.75% +81.82% -
10th Percentile £46,250 £35,000 £21,000
90th Percentile £48,750 £45,000 £23,000
Hampshire median annual salary £47,500 £40,000 £44,000
% change year-on-year +18.75% -9.09% +10.00%

VBA is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Portsmouth with a requirement for coding skills.

All Programming Languages
Portsmouth
Permanent vacancies with a requirement for coding skills 370 379 534
As % of all permanent IT jobs advertised in Portsmouth 57.90% 61.63% 68.64%
Number of salaries quoted 343 360 484
Portsmouth median annual salary £42,500 £40,000 £42,500
Median salary % change year-on-year +6.25% -5.88% +6.25%
10th Percentile £24,000 £26,000 £27,500
90th Percentile £57,500 £52,600 £58,750
Hampshire median annual salary £40,000 £40,000 £42,000
% change year-on-year - -4.76% +5.00%

VBA
Job Vacancy Trend in Portsmouth

Job postings citing VBA as a percentage of all IT jobs advertised in Portsmouth.

Job vacancy trend for VBA in Portsmouth

VBA
Salary Trend in Portsmouth

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

Salary trend for VBA in Portsmouth

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

1 1 (50.00%) Retail
1 1 (50.00%) Penetration Testing
1 1 (50.00%) Web Analytics
1 1 (50.00%) Google
1 1 (50.00%) Marketing
1 1 (50.00%) Wireshark
1 1 (50.00%) Google Analytics
1 1 (50.00%) SC Cleared
1 1 (50.00%) DV Cleared
1 1 (50.00%) Security Cleared
1 1 (50.00%) PowerShell
1 1 (50.00%) Bash Shell
1 1 (50.00%) tcpdump
1 1 (50.00%) Adobe Analytics
1 1 (50.00%) Hitwise
1 1 (50.00%) SIEM
1 1 (50.00%) Analytics
1 1 (50.00%) Cybersecurity
1 1 (50.00%) Analytical Skills
1 1 (50.00%) Network Packet Capture
1 1 (50.00%) A/B Testing
1 1 (50.00%) Conversion Rate Optimisation
1 1 (50.00%) JavaScript
1 1 (50.00%) Perl
1 1 (50.00%) PHP
1 1 (50.00%) SQL
1 1 (50.00%) VB.NET
1 1 (50.00%) .NET
1 1 (50.00%) Windows
1 1 (50.00%) Linux

VBA
Co-occurring IT Skills in Portsmouth 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:

Applications
1 1 (50.00%) Microsoft Excel
Cloud Services
1 1 (50.00%) Adobe Analytics
1 1 (50.00%) Google Analytics
Communications & Networking
1 1 (50.00%) DNS
1 1 (50.00%) HTTP
1 1 (50.00%) Internet
1 1 (50.00%) SMTP
1 1 (50.00%) TCP/IP
1 1 (50.00%) tcpdump
1 1 (50.00%) Wireshark
General
1 1 (50.00%) Marketing
1 1 (50.00%) Retail
Job Titles
1 2 (100.00%) Analyst
2 1 (50.00%) Digital Analyst
2 1 (50.00%) SOC Analyst
Libraries, Frameworks & Software Standards
1 1 (50.00%) .NET
Miscellaneous
1 1 (50.00%) Analytical Skills
Operating Systems
1 1 (50.00%) Linux
1 1 (50.00%) Windows
Processes & Methodologies
1 1 (50.00%) A/B Testing
1 1 (50.00%) Analytics
1 1 (50.00%) Conversion Rate Optimisation
1 1 (50.00%) Cybersecurity
1 1 (50.00%) E-Commerce
1 1 (50.00%) Network Packet Capture
1 1 (50.00%) Penetration Testing
1 1 (50.00%) SIEM
1 1 (50.00%) Web Analytics
Programming Languages
1 1 (50.00%) Bash Shell
1 1 (50.00%) JavaScript
1 1 (50.00%) Perl
1 1 (50.00%) PHP
1 1 (50.00%) PowerShell
1 1 (50.00%) Python
1 1 (50.00%) SQL
1 1 (50.00%) VB.NET
Qualifications
1 1 (50.00%) DV Cleared
1 1 (50.00%) SC Cleared
1 1 (50.00%) Security Cleared
Vendors
1 1 (50.00%) Adobe
1 1 (50.00%) Google
1 1 (50.00%) Hitwise