Period
to 19 October 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 19 October 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
19 Oct 2021
Same period 2020 Same period 2019
Rank 195 174 184
Rank change year-on-year -21 +10 +15
Permanent jobs citing VBA 62 26 144
As % of all permanent jobs advertised in the City of London 1.04% 0.72% 1.45%
As % of the Programming Languages category 1.72% 1.17% 2.41%
Number of salaries quoted 56 24 140
10th Percentile £42,500 £46,250 £35,500
25th Percentile £52,500 £47,500 £40,000
Median annual salary (50th Percentile) £90,000 £82,500 £57,500
Median % change year-on-year +9.09% +43.48% +4.55%
75th Percentile £110,000 £110,000 £69,000
90th Percentile £121,250 " £77,750
Central London median annual salary £75,000 £82,500 £57,500
% change year-on-year -9.09% +43.48% +4.55%

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,604 2,231 5,973
As % of all permanent IT jobs advertised in the City of London 60.50% 61.72% 59.99%
Number of salaries quoted 3,230 1,995 5,298
10th Percentile £47,000 £45,000 £42,500
25th Percentile £57,500 £55,000 £52,500
Median annual salary (50th Percentile) £75,000 £70,000 £70,000
Median % change year-on-year +7.14% - +7.69%
75th Percentile £95,000 £87,500 £84,457
90th Percentile £108,875 £105,000 £97,500
Central London median annual salary £75,000 £70,000 £67,500
% change year-on-year +7.14% +3.70% +3.85%

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 19 October 2021.

Salary histogram for VBA in the City of London

For the 6 months to 19 October 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 35 (56.45%) C#
1 35 (56.45%) Finance
2 33 (53.23%) SQL
3 29 (46.77%) .NET
3 29 (46.77%) Python
4 26 (41.94%) Microsoft Excel
5 25 (40.32%) Azure
6 24 (38.71%) Agile Software Development
7 19 (30.65%) Microsoft
8 18 (29.03%) Business Intelligence
8 18 (29.03%) SQL Server
9 17 (27.42%) Banking
9 17 (27.42%) DevOps
10 16 (25.81%) Analytics
10 16 (25.81%) ASP.NET
11 15 (24.19%) Investment Banking
11 15 (24.19%) JIRA
11 15 (24.19%) SDLC
11 15 (24.19%) Requirements Gathering
12 14 (22.58%) SOLID
12 14 (22.58%) MVVM
12 14 (22.58%) JSON
12 14 (22.58%) Equities
12 14 (22.58%) OO
12 14 (22.58%) Fidessa
12 14 (22.58%) MVC
12 14 (22.58%) Risk Management
13 13 (20.97%) Tableau
14 12 (19.35%) R
14 12 (19.35%) Power BI

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 10 (16.13%) IIS
2 5 (8.06%) SharePoint
Applications
1 26 (41.94%) Microsoft Excel
2 11 (17.74%) Microsoft Office
3 1 (1.61%) Microsoft PowerPoint
3 1 (1.61%) Spreadsheet
Business Applications
1 1 (1.61%) HFM
1 1 (1.61%) Hyperion Planning
1 1 (1.61%) IBM Planning Analytics
1 1 (1.61%) SAP BPC
Cloud Services
1 25 (40.32%) Azure
2 12 (19.35%) Power Platform
3 2 (3.23%) MailChimp
4 1 (1.61%) Adobe Analytics
4 1 (1.61%) Azure App Service
4 1 (1.61%) Azure Data Factory
4 1 (1.61%) GitHub
4 1 (1.61%) Google Analytics
Communications & Networking
1 11 (17.74%) FTP
2 2 (3.23%) Firewall
3 1 (1.61%) DSL
3 1 (1.61%) PuTTY
3 1 (1.61%) WinSCP
Database & Business Intelligence
1 18 (29.03%) SQL Server
2 13 (20.97%) Tableau
3 12 (19.35%) Power BI
4 10 (16.13%) SQL Server Analysis Services
4 10 (16.13%) SQL Server Integration Services
5 6 (9.68%) Data Mining
5 6 (9.68%) Data Warehouse
6 3 (4.84%) Geospatial Data
6 3 (4.84%) GIS
6 3 (4.84%) SQL Server Reporting Services
7 2 (3.23%) MySQL
8 1 (1.61%) Azure SQL Data Warehouse
8 1 (1.61%) Crystal Reports
8 1 (1.61%) Data Lake
8 1 (1.61%) DB2
8 1 (1.61%) MS Access
8 1 (1.61%) Neo4j
8 1 (1.61%) QlikView
8 1 (1.61%) RDBMS
8 1 (1.61%) Relational Database
Development Applications
1 15 (24.19%) JIRA
2 5 (8.06%) Git (software)
3 1 (1.61%) SQL Server Management Studio (SSMS)
3 1 (1.61%) Team Foundation Server
General
1 35 (56.45%) Finance
2 17 (27.42%) Banking
3 15 (24.19%) Investment Banking
4 12 (19.35%) Front Office
4 12 (19.35%) Social Skills
5 5 (8.06%) Analytical Skills
6 4 (6.45%) Back Office
7 3 (4.84%) Local Government
7 3 (4.84%) Organisational Skills
8 1 (1.61%) Marketing
8 1 (1.61%) Public Sector
Job Titles
1 27 (43.55%) Developer
2 13 (20.97%) SQL Developer
3 11 (17.74%) Analyst
3 11 (17.74%) VBA Developer
4 10 (16.13%) C# Developer
5 9 (14.52%) Senior Developer
6 8 (12.90%) Python Developer
6 8 (12.90%) Senior C# Developer
6 8 (12.90%) Senior SQL Developer
7 7 (11.29%) Excel Developer
7 7 (11.29%) Excel VBA Developer
7 7 (11.29%) Junior
7 7 (11.29%) Junior Developer
7 7 (11.29%) Junior Excel VBA Developer
7 7 (11.29%) Junior Python Developer
7 7 (11.29%) Junior VBA Developer
7 7 (11.29%) Software Engineer
8 5 (8.06%) ETL Developer
8 5 (8.06%) Senior Analyst
9 4 (6.45%) Data Analyst
Libraries, Frameworks & Software Standards
1 29 (46.77%) .NET
2 16 (25.81%) ASP.NET
3 14 (22.58%) JSON
4 4 (6.45%) .NET Framework
5 2 (3.23%) HTML
5 2 (3.23%) Shiny
6 1 (1.61%) Elastic Stack
6 1 (1.61%) Kafka
6 1 (1.61%) React
6 1 (1.61%) RESTful
Miscellaneous
1 14 (22.58%) Equities
2 10 (16.13%) Management Information System
3 5 (8.06%) Legacy Systems
4 4 (6.45%) Reference Data
5 2 (3.23%) Cyber Kill Chain
5 2 (3.23%) Cyberthreat
6 1 (1.61%) Data Structures
6 1 (1.61%) NHS
6 1 (1.61%) Reinsurance
6 1 (1.61%) User Experience
6 1 (1.61%) Wiki
Processes & Methodologies
1 24 (38.71%) Agile Software Development
2 18 (29.03%) Business Intelligence
3 17 (27.42%) DevOps
4 16 (25.81%) Analytics
5 15 (24.19%) Requirements Gathering
5 15 (24.19%) SDLC
6 14 (22.58%) MVC
6 14 (22.58%) MVVM
6 14 (22.58%) OO
6 14 (22.58%) Risk Management
6 14 (22.58%) SOLID
7 12 (19.35%) Asset Management
7 12 (19.35%) IT Strategy
8 11 (17.74%) Visualisation
9 10 (16.13%) Data Visualisation
9 10 (16.13%) ETL
9 10 (16.13%) Root Cause Analysis
9 10 (16.13%) Time Management
10 8 (12.90%) PRINCE2
11 7 (11.29%) Workflow
Programming Languages
1 35 (56.45%) C#
2 33 (53.23%) SQL
3 29 (46.77%) Python
4 12 (19.35%) R
5 2 (3.23%) Perl
5 2 (3.23%) PHP
5 2 (3.23%) PowerShell
6 1 (1.61%) C++
6 1 (1.61%) Java
6 1 (1.61%) T-SQL
6 1 (1.61%) VB.NET
Qualifications
1 5 (8.06%) Degree
2 2 (3.23%) CEH
2 2 (3.23%) CISSP
2 2 (3.23%) OSCP
3 1 (1.61%) ACCA
3 1 (1.61%) CIMA
Quality Assurance & Compliance
1 1 (1.61%) Data Quality
1 1 (1.61%) GDPR
1 1 (1.61%) SLA
System Software
1 5 (8.06%) Docker
Systems Management
1 4 (6.45%) Kubernetes
Vendors
1 19 (30.65%) Microsoft
2 14 (22.58%) Fidessa
3 7 (11.29%) Alteryx
4 6 (9.68%) Bloomberg
5 4 (6.45%) Concur
5 4 (6.45%) Sage
5 4 (6.45%) Sun
6 2 (3.23%) IBM
7 1 (1.61%) Adobe
7 1 (1.61%) Anaplan
7 1 (1.61%) Automation Anywhere
7 1 (1.61%) Blue Prism
7 1 (1.61%) Google
7 1 (1.61%) Hyperion
7 1 (1.61%) Kofax
7 1 (1.61%) Pega
7 1 (1.61%) RedGate
7 1 (1.61%) SAP
7 1 (1.61%) Tagetik
7 1 (1.61%) UiPath