Period
to

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 18 May 2022 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
18 May 2022
Same period 2021 Same period 2020
Rank 247 197 221
Rank change year-on-year -50 +24 -13
Permanent jobs citing VBA 35 39 50
As % of all permanent jobs advertised in the City of London 0.48% 0.78% 0.69%
As % of the Programming Languages category 0.91% 1.25% 1.24%
Number of salaries quoted 29 38 47
10th Percentile £42,500 £48,750 £42,500
25th Percentile £50,000 £59,375 £46,875
Median annual salary (50th Percentile) £70,000 £100,000 £62,500
Median % change year-on-year -30.00% +60.00% +13.64%
75th Percentile £78,750 £110,000 £77,500
90th Percentile £89,000 £113,375 £96,750
Central London median annual salary £50,000 £100,000 £62,500
% change year-on-year -50.00% +60.00% +15.74%

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,866 3,119 4,047
As % of all permanent IT jobs advertised in the City of London 52.92% 62.69% 56.01%
Number of salaries quoted 3,368 2,874 3,616
10th Percentile £47,500 £45,000 £42,500
25th Percentile £57,500 £56,250 £52,500
Median annual salary (50th Percentile) £75,000 £75,000 £70,000
Median % change year-on-year - +7.14% +3.70%
75th Percentile £95,000 £90,000 £86,250
90th Percentile £110,000 £108,600 £106,250
Central London median annual salary £75,000 £72,500 £70,000
% change year-on-year +3.45% +3.57% +7.69%

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 18 May 2022.

Salary histogram for VBA in the City of London

For the 6 months to 18 May 2022, 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 30 (85.71%) SQL
2 26 (74.29%) Finance
3 23 (65.71%) Microsoft Excel
4 14 (40.00%) Problem-Solving
5 12 (34.29%) Analytics
6 10 (28.57%) Python
6 10 (28.57%) Business Intelligence
6 10 (28.57%) Project Management
6 10 (28.57%) Catastrophe Modelling
6 10 (28.57%) Power BI
6 10 (28.57%) Power Platform
6 10 (28.57%) Social Skills
7 8 (22.86%) C#
7 8 (22.86%) .NET
7 8 (22.86%) Risk Management
7 8 (22.86%) Analytical Skills
8 7 (20.00%) Git (software)
8 7 (20.00%) JIRA
8 7 (20.00%) SQL Server
8 7 (20.00%) Microsoft
9 6 (17.14%) Data Modelling
9 6 (17.14%) SOA
9 6 (17.14%) Configuration Management
9 6 (17.14%) HTML
9 6 (17.14%) T-SQL
9 6 (17.14%) OO
9 6 (17.14%) JavaScript
9 6 (17.14%) CSS
9 6 (17.14%) Web Services
9 6 (17.14%) TDD

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 1 (2.86%) SAS
Applications
1 23 (65.71%) Microsoft Excel
Business Applications
1 3 (8.57%) Alphatax
1 3 (8.57%) Dynamics GP
2 1 (2.86%) FINCAD Analytics
Cloud Services
1 10 (28.57%) Power Platform
2 2 (5.71%) Azure
Database & Business Intelligence
1 10 (28.57%) Power BI
2 7 (20.00%) SQL Server
3 4 (11.43%) MS Access
4 3 (8.57%) Crystal Reports
4 3 (8.57%) SQL Server Analysis Services
4 3 (8.57%) SQL Server Integration Services
4 3 (8.57%) SQL Server Reporting Services
5 2 (5.71%) MySQL
5 2 (5.71%) Neo4j
5 2 (5.71%) RDBMS
5 2 (5.71%) Relational Database
6 1 (2.86%) Big Data
6 1 (2.86%) EDRMS
6 1 (2.86%) Spotfire
6 1 (2.86%) Tableau
Development Applications
1 7 (20.00%) Git (software)
1 7 (20.00%) JIRA
2 6 (17.14%) NUnit
2 6 (17.14%) Visual Studio Team System
3 3 (8.57%) SQL Server Management Studio (SSMS)
General
1 26 (74.29%) Finance
2 10 (28.57%) Social Skills
3 8 (22.86%) Analytical Skills
4 4 (11.43%) Legal
5 3 (8.57%) Advertising
5 3 (8.57%) Inclusion and Diversity
5 3 (8.57%) Marketing
6 1 (2.86%) Banking
6 1 (2.86%) Investment Banking
6 1 (2.86%) Law
6 1 (2.86%) Pharmaceutical
Job Titles
1 14 (40.00%) Developer
2 10 (28.57%) Analyst
3 7 (20.00%) Applications Support
4 6 (17.14%) WPF Developer
5 4 (11.43%) Murex Support
5 4 (11.43%) Python Developer
6 3 (8.57%) Analyst Developer
6 3 (8.57%) Applications Support Analyst
6 3 (8.57%) Excel Developer
6 3 (8.57%) Excel VBA Developer
6 3 (8.57%) Financial Analyst
6 3 (8.57%) Junior
6 3 (8.57%) Junior Excel VBA Developer
6 3 (8.57%) Junior Python Developer
6 3 (8.57%) Junior VBA Developer
6 3 (8.57%) Report Analyst
6 3 (8.57%) Report Developer
6 3 (8.57%) Support Analyst
6 3 (8.57%) Systems Analyst
6 3 (8.57%) VBA Developer
Libraries, Frameworks & Software Standards
1 8 (22.86%) .NET
2 6 (17.14%) .NET Core
2 6 (17.14%) .NET Framework
2 6 (17.14%) AngularJS
2 6 (17.14%) ASP.NET Web API
2 6 (17.14%) CSS
2 6 (17.14%) CSS3
2 6 (17.14%) Dapper ORM
2 6 (17.14%) Entity Framework
2 6 (17.14%) HTML
2 6 (17.14%) HTML5
2 6 (17.14%) jQuery
2 6 (17.14%) Task Parallel Library
2 6 (17.14%) WCF
2 6 (17.14%) Web Services
2 6 (17.14%) WPF
3 2 (5.71%) ASP.NET
3 2 (5.71%) JSON
3 2 (5.71%) React
3 2 (5.71%) XML
Miscellaneous
1 6 (17.14%) Derivative
1 6 (17.14%) Reference Data
1 6 (17.14%) Reinsurance
2 5 (14.29%) Foreign Exchange (FX)
3 4 (11.43%) Fixed Income
3 4 (11.43%) Interest Rate Derivative
3 4 (11.43%) Market Risk
4 3 (8.57%) Data Structures
5 2 (5.71%) Hedge funds
6 1 (2.86%) Algorithms
6 1 (2.86%) Equity Derivative
6 1 (2.86%) OTC Derivatives
Processes & Methodologies
1 14 (40.00%) Problem-Solving
2 12 (34.29%) Analytics
3 10 (28.57%) Business Intelligence
3 10 (28.57%) Catastrophe Modelling
3 10 (28.57%) Project Management
4 8 (22.86%) Risk Management
5 6 (17.14%) Async-Await
5 6 (17.14%) Capital Modelling
5 6 (17.14%) Configuration Management
5 6 (17.14%) Data Analytics
5 6 (17.14%) Data Modelling
5 6 (17.14%) Mathematical Modelling
5 6 (17.14%) Mathematics
5 6 (17.14%) Multithreading
5 6 (17.14%) OO
5 6 (17.14%) SOA
5 6 (17.14%) SOLID
5 6 (17.14%) TDD
5 6 (17.14%) Unit Testing
5 6 (17.14%) User Acceptance Testing
Programming Languages
1 30 (85.71%) SQL
2 10 (28.57%) Python
3 8 (22.86%) C#
4 6 (17.14%) JavaScript
4 6 (17.14%) T-SQL
5 3 (8.57%) Java
Qualifications
1 6 (17.14%) Degree
Quality Assurance & Compliance
1 4 (11.43%) SLA
2 2 (5.71%) QA
3 1 (2.86%) IFRS
Vendors
1 7 (20.00%) Microsoft
2 4 (11.43%) Bloomberg
2 4 (11.43%) Murex
3 1 (2.86%) Oracle
3 1 (2.86%) SAP