Period
to 23 July 2017

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 July 2017 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA)
Hampshire > Portsmouth
6 months to
23 Jul 2017
Same period 2016 Same period 2015
Rank 82 65 -
Rank change year-on-year -17 - +92
Permanent jobs citing VBA 2 2 0
As % of all permanent IT jobs advertised in Portsmouth 0.28% 0.39% -
As % of the Programming Languages category 0.42% 0.65% -
Number of salaries quoted 2 2 0
Portsmouth median annual salary £40,750 £40,000 -
Median salary % change year-on-year +1.88% - -
Hampshire median annual salary £27,500 £37,500 £40,000
% change year-on-year -26.67% -6.25% +26.98%

VBA is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Portsmouth with a requirement for programming language skills.

Programming Language Skills
Portsmouth
Permanent job vacancies with a requirement for programming language skills 471 307 392
As % of all permanent IT job vacancies advertised in Portsmouth 65.78% 59.27% 64.16%
Number of salaries quoted 437 293 354
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,500 £27,500 £26,250
90th Percentile £57,500 £55,000 £55,000
Hampshire median annual salary £41,316 £40,000 £40,000
% change year-on-year +3.29% - -

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 July 2017, IT jobs citing VBA 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 Portsmouth region with a requirement for VBA.

1 1 (50.00%) Agile Software Development
1 1 (50.00%) Penetration Testing
1 1 (50.00%) Data Analysis
1 1 (50.00%) Wireshark
1 1 (50.00%) Spotfire
1 1 (50.00%) QlikView
1 1 (50.00%) SC Cleared
1 1 (50.00%) DV Cleared
1 1 (50.00%) Security Cleared
1 1 (50.00%) Visualisation
1 1 (50.00%) tcpdump
1 1 (50.00%) Data Visualisation
1 1 (50.00%) SIEM
1 1 (50.00%) Tableau
1 1 (50.00%) Cybersecurity
1 1 (50.00%) Malware Analysis
1 1 (50.00%) Power BI
1 1 (50.00%) Network Packet Capture
1 1 (50.00%) JavaScript
1 1 (50.00%) SQL
1 1 (50.00%) VB.NET
1 1 (50.00%) .NET
1 1 (50.00%) PRINCE2
1 1 (50.00%) Windows
1 1 (50.00%) Linux
1 1 (50.00%) Microsoft Excel
1 1 (50.00%) Cognos
1 1 (50.00%) SMTP
1 1 (50.00%) HTTP
1 1 (50.00%) TCP/IP

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
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
Database & Business Intelligence
1 1 (50.00%) Power BI
1 1 (50.00%) QlikView
1 1 (50.00%) Spotfire
Job Titles
1 2 (100.00%) Analyst
2 1 (50.00%) Data Analyst
2 1 (50.00%) Excel Analyst
2 1 (50.00%) SOC Analyst
Libraries, Frameworks & Software Standards
1 1 (50.00%) .NET
Operating Systems
1 1 (50.00%) Linux
1 1 (50.00%) Windows
Processes & Methodologies
1 1 (50.00%) Agile Software Development
1 1 (50.00%) Business Intelligence
1 1 (50.00%) Cybersecurity
1 1 (50.00%) Data Analysis
1 1 (50.00%) Data Visualisation
1 1 (50.00%) Malware Analysis
1 1 (50.00%) Network Packet Capture
1 1 (50.00%) Penetration Testing
1 1 (50.00%) PRINCE2
1 1 (50.00%) Project Management
1 1 (50.00%) SIEM
1 1 (50.00%) Visualisation
Programming Languages
1 1 (50.00%) JavaScript
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%) Cognos
1 1 (50.00%) Tableau