Period
to 19 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Guildford 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 19 November 2017 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA)
Surrey > Guildford
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 84 75 94
Rank change year-on-year -9 +19 +6
Permanent jobs citing VBA 11 7 15
As % of all permanent IT jobs advertised in Guildford 1.33% 0.87% 1.16%
As % of the Programming Languages category 2.46% 1.78% 2.17%
Number of salaries quoted 11 7 15
Guildford median annual salary £55,000 £42,500 £35,000
Median salary % change year-on-year +29.41% +21.43% +4.48%
10th Percentile £50,000 £31,250 £31,250
90th Percentile £61,250 £44,000 £37,500
Surrey median annual salary £52,500 £40,000 £40,500
% change year-on-year +31.25% -1.23% +8.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 Guildford with a requirement for coding skills.

All Programming Languages
Guildford
Permanent vacancies with a requirement for coding skills 448 393 692
As % of all permanent IT jobs advertised in Guildford 54.24% 48.76% 53.73%
Number of salaries quoted 419 380 641
Guildford median annual salary £42,500 £46,250 £42,500
Median salary % change year-on-year -8.11% +8.82% -5.56%
10th Percentile £26,750 £30,000 £27,500
90th Percentile £61,050 £66,250 £65,000
Surrey median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

VBA
Job Vacancy Trend in Guildford

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

Job vacancy trend for VBA in Guildford

VBA
Salary Trend in Guildford

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

Salary trend for VBA in Guildford

For the 6 months to 19 November 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 Guildford region with a requirement for VBA.

1 11 (100.00%) SQL
1 11 (100.00%) Microsoft Excel
1 11 (100.00%) Finance
1 11 (100.00%) Data Analytics
1 11 (100.00%) Analytics
1 11 (100.00%) Relational Database
2 8 (72.73%) Data Management
2 8 (72.73%) Salesforce.com
3 7 (63.64%) Business Intelligence
3 7 (63.64%) SQL Server Reporting Services
3 7 (63.64%) SQL Server Integration Services
3 7 (63.64%) Power BI
4 6 (54.55%) C#
5 5 (45.45%) QlikView
6 3 (27.27%) Marketing
7 2 (18.18%) SQL Server
7 2 (18.18%) Continuous Improvement

VBA
Co-occurring IT Skills in Guildford 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 11 (100.00%) Microsoft Excel
Database & Business Intelligence
1 11 (100.00%) Relational Database
2 7 (63.64%) Power BI
2 7 (63.64%) SQL Server Integration Services
2 7 (63.64%) SQL Server Reporting Services
3 5 (45.45%) QlikView
4 2 (18.18%) SQL Server
General
1 11 (100.00%) Finance
2 3 (27.27%) Marketing
Job Titles
1 11 (100.00%) Developer
1 11 (100.00%) SQL Developer
2 9 (81.82%) Database Developer
2 9 (81.82%) SQL Database Developer
3 5 (45.45%) VBA Developer
4 3 (27.27%) C# Developer
4 3 (27.27%) Database Programmer
4 3 (27.27%) Programmer
4 3 (27.27%) SQL Programmer
5 2 (18.18%) Business Intelligence Developer
5 2 (18.18%) SQL BI Developer
5 2 (18.18%) VBA Programmer
Processes & Methodologies
1 11 (100.00%) Analytics
1 11 (100.00%) Data Analytics
2 8 (72.73%) Data Management
3 7 (63.64%) Business Intelligence
4 2 (18.18%) Continuous Improvement
Programming Languages
1 11 (100.00%) SQL
2 6 (54.55%) C#
Vendors
1 8 (72.73%) Salesforce.com