Period
to 16 May 2021

The following table provides summary statistics for permanent job vacancies advertised in the City of London 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 16 May 2021 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA)
Central London > City of London
6 months to
16 May 2021
Same period 2020 Same period 2019
Rank 194 228 196
Rank change year-on-year +34 -32 -15
Permanent jobs citing VBA 37 52 139
As % of all permanent jobs advertised in the City of London 0.74% 0.71% 1.38%
As % of the Programming Languages category 1.19% 1.27% 2.25%
Number of salaries quoted 36 49 131
10th Percentile £48,750 £42,500 £36,250
25th Percentile £68,125 £48,750 £42,500
Median annual salary (50th Percentile) £100,000 £62,500 £55,000
Median % change year-on-year +60.00% +13.64% +15.79%
75th Percentile £110,000 £77,500 £77,750
90th Percentile " £94,000 £85,000
Central London median annual salary £100,000 £62,500 £54,000
% change year-on-year +60.00% +15.74% +20.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 the City of London with a requirement for coding skills.

All Programming Languages
City of London
Permanent vacancies with a requirement for coding skills 3,104 4,081 6,187
As % of all permanent IT jobs advertised in the City of London 62.49% 56.06% 61.56%
Number of salaries quoted 2,859 3,642 5,613
10th Percentile £45,000 £42,500 £41,250
25th Percentile £56,250 £52,500 £51,250
Median annual salary (50th Percentile) £75,000 £70,000 £67,500
Median % change year-on-year +7.14% +3.70% +3.85%
75th Percentile £90,000 £86,250 £82,500
90th Percentile £108,750 £106,250 £96,250
Central London median annual salary £72,500 £70,000 £65,000
% change year-on-year +3.57% +7.69% +4.00%

VBA
Job Vacancy Trend in the City of London

Job postings citing VBA as a proportion of all IT jobs advertised in the City of London.

Job vacancy trend for VBA in the City of London

VBA
Salary Trend in the City of London

3-month moving average salary quoted in jobs citing VBA in the City of London.

Salary trend for VBA in the City of London

VBA
Salary Histogram in the City of London

Salary distribution for jobs citing VBA in the City of London over the 6 months to 16 May 2021.

Salary histogram for VBA in the City of London

For the 6 months to 16 May 2021, 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 City of London region with a requirement for VBA.

1 29 (78.38%) C#
1 29 (78.38%) Python
2 26 (70.27%) Microsoft
3 25 (67.57%) .NET
4 22 (59.46%) Front Office
4 22 (59.46%) Asset Management
4 22 (59.46%) IT Strategy
5 13 (35.14%) SQL
6 10 (27.03%) Microsoft Excel
7 8 (21.62%) SQL Server
8 5 (13.51%) OO
8 5 (13.51%) Finance
9 4 (10.81%) Windows
9 4 (10.81%) Oracle
9 4 (10.81%) DevOps
9 4 (10.81%) Analytical Skills
9 4 (10.81%) SDLC
9 4 (10.81%) Agile Software Development
9 4 (10.81%) Banking
9 4 (10.81%) FIX Protocol
9 4 (10.81%) PowerShell
10 3 (8.11%) Visualisation
10 3 (8.11%) Azure
10 3 (8.11%) Time Management
10 3 (8.11%) MVVM
10 3 (8.11%) Data Visualisation
10 3 (8.11%) Tableau
10 3 (8.11%) JSON
10 3 (8.11%) JIRA
10 3 (8.11%) SOLID

VBA
Co-occurring IT Skills in the City of London 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 2 (5.41%) IIS
2 1 (2.70%) SharePoint
Applications
1 10 (27.03%) Microsoft Excel
2 2 (5.41%) Microsoft Office
3 1 (2.70%) Microsoft PowerPoint
3 1 (2.70%) MS Visio
Cloud Services
1 3 (8.11%) Azure
2 2 (5.41%) Power Platform
3 1 (2.70%) Adobe Analytics
3 1 (2.70%) Google Analytics
Communications & Networking
1 2 (5.41%) FTP
Database & Business Intelligence
1 8 (21.62%) SQL Server
2 3 (8.11%) Tableau
3 2 (5.41%) Power BI
3 2 (5.41%) SQL Server 2016
3 2 (5.41%) SQL Server Integration Services
4 1 (2.70%) BusinessObjects
4 1 (2.70%) Data Lake
4 1 (2.70%) Data Mining
4 1 (2.70%) Data Warehouse
4 1 (2.70%) Geospatial Data
4 1 (2.70%) GIS
4 1 (2.70%) QlikView
Development Applications
1 3 (8.11%) JIRA
2 1 (2.70%) Git (software)
General
1 22 (59.46%) Front Office
2 5 (13.51%) Finance
3 4 (10.81%) Analytical Skills
3 4 (10.81%) Banking
4 3 (8.11%) Investment Banking
5 2 (5.41%) Social Skills
6 1 (2.70%) Back Office
6 1 (2.70%) Local Government
6 1 (2.70%) Marketing
6 1 (2.70%) Organisational Skills
Job Titles
1 9 (24.32%) Analyst
2 4 (10.81%) Applications Support
2 4 (10.81%) Applications Support Analyst
2 4 (10.81%) Senior Analyst
2 4 (10.81%) Support Analyst
3 3 (8.11%) Data Analyst
3 3 (8.11%) Developer
4 2 (5.41%) C# Developer
4 2 (5.41%) Data Engineer
4 2 (5.41%) Senior C# Developer
4 2 (5.41%) Senior Data Analyst
4 2 (5.41%) Senior Developer
4 2 (5.41%) Senior SQL Developer
4 2 (5.41%) SQL Developer
5 1 (2.70%) Business Project Manager
5 1 (2.70%) Data Analyst - Instrument Data
5 1 (2.70%) Digital Analyst
5 1 (2.70%) Governance Analyst
5 1 (2.70%) Senior Business Intelligence Analyst
5 1 (2.70%) Senior Business Manager
Libraries, Frameworks & Software Standards
1 25 (67.57%) .NET
2 4 (10.81%) FIX Protocol
3 3 (8.11%) ASP.NET
3 3 (8.11%) JSON
4 1 (2.70%) .NET Framework
4 1 (2.70%) WCF
4 1 (2.70%) WPF
Miscellaneous
1 3 (8.11%) Equities
2 2 (5.41%) Management Information System
3 1 (2.70%) Credit Risk
3 1 (2.70%) Data Structures
3 1 (2.70%) Market Risk
3 1 (2.70%) Reference Data
Operating Systems
1 4 (10.81%) Windows
Processes & Methodologies
1 22 (59.46%) Asset Management
1 22 (59.46%) IT Strategy
2 5 (13.51%) OO
3 4 (10.81%) Agile Software Development
3 4 (10.81%) DevOps
3 4 (10.81%) SDLC
4 3 (8.11%) Business Intelligence
4 3 (8.11%) Data Visualisation
4 3 (8.11%) MVC
4 3 (8.11%) MVVM
4 3 (8.11%) OOP
4 3 (8.11%) Risk Management
4 3 (8.11%) SOLID
4 3 (8.11%) Time Management
4 3 (8.11%) Visualisation
5 2 (5.41%) Data Analysis
5 2 (5.41%) Data Management
5 2 (5.41%) Data Modelling
5 2 (5.41%) ETL
5 2 (5.41%) Scrum
Programming Languages
1 29 (78.38%) C#
1 29 (78.38%) Python
2 13 (35.14%) SQL
3 4 (10.81%) PowerShell
4 2 (5.41%) MATLAB
4 2 (5.41%) R
4 2 (5.41%) T-SQL
5 1 (2.70%) Bash Shell
5 1 (2.70%) Java
5 1 (2.70%) Perl
Qualifications
1 1 (2.70%) Degree
Quality Assurance & Compliance
1 1 (2.70%) Data Quality
1 1 (2.70%) GDPR
System Software
1 1 (2.70%) Docker
Systems Management
1 1 (2.70%) Kubernetes
Vendors
1 26 (70.27%) Microsoft
2 4 (10.81%) Oracle
3 3 (8.11%) Fidessa
4 1 (2.70%) Adobe
4 1 (2.70%) Bloomberg
4 1 (2.70%) Concur
4 1 (2.70%) Google
4 1 (2.70%) Sage
4 1 (2.70%) Sun