Period
to 29 July 2021

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

Microsoft Visual Basic for Applications (VBA)
England > London
6 months to
29 Jul 2021
Same period 2020 Same period 2019
Rank 451 331 317
Rank change year-on-year -120 -14 -10
Permanent jobs citing VBA 244 241 594
As % of all permanent jobs advertised in London 0.54% 0.84% 1.04%
As % of the Programming Languages category 0.88% 1.44% 1.85%
Number of salaries quoted 172 213 507
10th Percentile £41,250 £40,250 £35,000
25th Percentile £48,188 £46,250 £42,500
Median annual salary (50th Percentile) £60,000 £70,000 £57,500
Median % change year-on-year -14.29% +21.74% +12.75%
75th Percentile £90,000 £96,250 £72,500
90th Percentile £110,000 £122,500 £85,000
England median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +5.26% +5.56%

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 London with a requirement for coding skills.

All Programming Languages
London
Permanent vacancies with a requirement for coding skills 27,697 16,699 32,036
As % of all permanent IT jobs advertised in London 61.51% 58.27% 56.06%
Number of salaries quoted 17,596 13,890 27,254
10th Percentile £45,000 £42,500 £38,750
25th Percentile £55,000 £52,500 £48,750
Median annual salary (50th Percentile) £70,000 £70,000 £65,000
Median % change year-on-year - +7.69% +4.00%
75th Percentile £90,000 £87,500 £82,500
90th Percentile £107,500 £105,000 £97,500
England median annual salary £57,500 £55,000 £52,500
% change year-on-year +4.55% +4.76% +5.00%

VBA
Job Vacancy Trend in London

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

Job vacancy trend for VBA in London

VBA
Salary Trend in London

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

Salary trend for VBA in London

VBA
Salary Histogram in London

Salary distribution for jobs citing VBA in London over the 6 months to 29 July 2021.

Salary histogram for VBA in London

VBA
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing VBA within the London region over the 6 months to 29 July 2021. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Central London +16 54 £100,000 +70.21% 17
East London +3 4 £40,000 -61.90% 2
West London -36 4 £60,000 +33.33% 3
VBA
England

For the 6 months to 29 July 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 London region with a requirement for VBA.

1 156 (63.93%) SQL
2 122 (50.00%) Microsoft Excel
3 114 (46.72%) Python
4 111 (45.49%) Finance
5 78 (31.97%) C#
6 73 (29.92%) Microsoft
7 69 (28.28%) .NET
8 57 (23.36%) Business Intelligence
9 54 (22.13%) Mathematics
10 51 (20.90%) Power Platform
11 49 (20.08%) Power BI
11 49 (20.08%) SQL Server
12 48 (19.67%) Social Skills
13 47 (19.26%) Degree
14 46 (18.85%) Analytical Skills
15 44 (18.03%) Analytics
16 40 (16.39%) Risk Management
17 37 (15.16%) SQL Server Integration Services
18 36 (14.75%) Visualisation
19 35 (14.34%) Banking
19 35 (14.34%) Microsoft Office
19 35 (14.34%) Windows
19 35 (14.34%) Problem-Solving
20 34 (13.93%) Asset Management
20 34 (13.93%) SQL Server Reporting Services
20 34 (13.93%) Computer Science
21 33 (13.52%) Azure
21 33 (13.52%) Derivative
22 32 (13.11%) SharePoint
22 32 (13.11%) Front Office

VBA
Co-occurring IT Skills in 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 32 (13.11%) SharePoint
2 13 (5.33%) IIS
3 4 (1.64%) SAS
4 3 (1.23%) Jetty
5 1 (0.41%) Confluence
5 1 (0.41%) Elasticsearch
5 1 (0.41%) MQSeries
5 1 (0.41%) MTS
5 1 (0.41%) NetWeaver
5 1 (0.41%) WordPress
Applications
1 122 (50.00%) Microsoft Excel
2 35 (14.34%) Microsoft Office
3 5 (2.05%) Microsoft PowerPoint
4 4 (1.64%) InfoPath
4 4 (1.64%) Spreadsheet
5 2 (0.82%) MS Visio
5 2 (0.82%) SPSS
6 1 (0.41%) Stata
Business Applications
1 18 (7.38%) IBM Planning Analytics
2 3 (1.23%) NetSuite
3 2 (0.82%) Dynamics GP
3 2 (0.82%) Findur
3 2 (0.82%) SAP ERP
4 1 (0.41%) Aareon QL
4 1 (0.41%) Dynamics CRM
4 1 (0.41%) Elite 3E
4 1 (0.41%) HFM
4 1 (0.41%) Markit EDM
4 1 (0.41%) Oracle Cash Management
4 1 (0.41%) Orchestrade
4 1 (0.41%) SAP BPC
4 1 (0.41%) Sentinel
Cloud Services
1 51 (20.90%) Power Platform
2 33 (13.52%) Azure
3 11 (4.51%) Microsoft 365
4 10 (4.10%) AWS
5 7 (2.87%) SaaS
6 5 (2.05%) Dynamics 365
7 3 (1.23%) GitHub
7 3 (1.23%) PowerApps
8 2 (0.82%) Snowflake
9 1 (0.41%) Adobe Analytics
9 1 (0.41%) Amazon CloudSearch
9 1 (0.41%) Azure App Service
9 1 (0.41%) Google Analytics
9 1 (0.41%) IaaS
9 1 (0.41%) MailChimp
9 1 (0.41%) PaaS
Communications & Networking
1 16 (6.56%) FTP
2 12 (4.92%) Firewall
3 3 (1.23%) Cisco IOS
3 3 (1.23%) DHCP
3 3 (1.23%) DNS
3 3 (1.23%) PuTTY
3 3 (1.23%) VLAN
3 3 (1.23%) Wi-Fi
3 3 (1.23%) WinSCP
4 1 (0.41%) HTTP
4 1 (0.41%) Intranet
4 1 (0.41%) SWIFTNet
Database & Business Intelligence
1 49 (20.08%) Power BI
1 49 (20.08%) SQL Server
2 37 (15.16%) SQL Server Integration Services
3 34 (13.93%) SQL Server Reporting Services
4 29 (11.89%) Tableau
5 24 (9.84%) SQL Server Analysis Services
6 19 (7.79%) Data Mining
7 18 (7.38%) Relational Database
8 15 (6.15%) Big Data
8 15 (6.15%) Data Warehouse
9 14 (5.74%) DB2
9 14 (5.74%) RDBMS
10 11 (4.51%) MS Access
11 7 (2.87%) MySQL
12 4 (1.64%) Geospatial Data
12 4 (1.64%) GIS
12 4 (1.64%) Microsoft Analysis Services
12 4 (1.64%) Oracle Database
12 4 (1.64%) Oracle Database 10g
12 4 (1.64%) SQL Server 2005
Development Applications
1 27 (11.07%) JIRA
2 8 (3.28%) Subversion
3 7 (2.87%) Git (software)
4 5 (2.05%) Visual Studio
5 4 (1.64%) Team Foundation Server
6 3 (1.23%) Artifactory
6 3 (1.23%) Gradle
6 3 (1.23%) TeamCity
7 1 (0.41%) Bitbucket
7 1 (0.41%) Eclipse
7 1 (0.41%) Moq
7 1 (0.41%) RStudio
7 1 (0.41%) SQL Server Management Studio (SSMS)
7 1 (0.41%) WinAutomation
General
1 111 (45.49%) Finance
2 48 (19.67%) Social Skills
3 46 (18.85%) Analytical Skills
4 35 (14.34%) Banking
5 32 (13.11%) Front Office
6 20 (8.20%) Investment Banking
7 12 (4.92%) Back Office
8 9 (3.69%) Documentation Skills
8 9 (3.69%) Financial Institution
8 9 (3.69%) Organisational Skills
9 6 (2.46%) Marketing
10 5 (2.05%) Advertising
11 4 (1.64%) Local Government
11 4 (1.64%) Private Banking
11 4 (1.64%) Retail
11 4 (1.64%) Retail Banking
12 3 (1.23%) Legal
13 2 (0.82%) Aerospace
13 2 (0.82%) Billing
13 2 (0.82%) Police
Job Titles
1 93 (38.11%) Analyst
2 79 (32.38%) Developer
3 29 (11.89%) Data Analyst
4 20 (8.20%) Applications Support
4 20 (8.20%) SQL Developer
5 18 (7.38%) Support Analyst
6 17 (6.97%) Applications Support Analyst
7 16 (6.56%) Quantitative Developer
8 15 (6.15%) Consultant
8 15 (6.15%) Qualitative Analyst
8 15 (6.15%) Quantitative Analyst
9 13 (5.33%) Senior Developer
10 11 (4.51%) C# Developer
10 11 (4.51%) Senior Analyst
11 10 (4.10%) Business Analyst
11 10 (4.10%) Data Quality Analyst
11 10 (4.10%) Quality Analyst
12 9 (3.69%) Firewall Consultant
12 9 (3.69%) Market Risk Developer
12 9 (3.69%) Splunk Consultant
Libraries, Frameworks & Software Standards
1 69 (28.28%) .NET
2 23 (9.43%) JSON
3 20 (8.20%) HTML
4 17 (6.97%) CSS
5 15 (6.15%) ASP.NET
6 12 (4.92%) Ajax
7 11 (4.51%) Kafka
8 8 (3.28%) .NET Core
9 7 (2.87%) Razor View Engine
10 6 (2.46%) .NET Framework
10 6 (2.46%) Laravel
10 6 (2.46%) XML
11 5 (2.05%) ADO
11 5 (2.05%) jQuery
12 4 (1.64%) FIX Protocol
12 4 (1.64%) REST
13 3 (1.23%) JAX-RS
13 3 (1.23%) PyXLL
13 3 (1.23%) RESTful
13 3 (1.23%) Swagger
Miscellaneous
1 33 (13.52%) Derivative
2 23 (9.43%) Foreign Exchange (FX)
3 22 (9.02%) Equities
4 14 (5.74%) Management Information System
5 13 (5.33%) Fixed Income
6 12 (4.92%) Market Risk
7 11 (4.51%) Reference Data
8 8 (3.28%) Credit Derivative
8 8 (3.28%) Legacy Systems
9 7 (2.87%) Analytical Mindset
9 7 (2.87%) Credit Risk
10 5 (2.05%) Self-Motivation
11 4 (1.64%) Algorithms
11 4 (1.64%) Data Structures
11 4 (1.64%) Hedge funds
12 3 (1.23%) Legacy Code
12 3 (1.23%) Robotics
12 3 (1.23%) Wiki
13 2 (0.82%) Greenfield Project
13 2 (0.82%) Learning Management System
Operating Systems
1 35 (14.34%) Windows
2 22 (9.02%) Linux
3 10 (4.10%) Unix
3 10 (4.10%) Windows 10
4 4 (1.64%) Windows 7
4 4 (1.64%) Windows Server
5 3 (1.23%) Mac OS X
6 1 (0.41%) Solaris
Processes & Methodologies
1 57 (23.36%) Business Intelligence
2 54 (22.13%) Mathematics
3 44 (18.03%) Analytics
4 40 (16.39%) Risk Management
5 36 (14.75%) Visualisation
6 35 (14.34%) Problem-Solving
7 34 (13.93%) Asset Management
7 34 (13.93%) Computer Science
8 29 (11.89%) Statistics
9 28 (11.48%) Agile Software Development
10 27 (11.07%) Data Modelling
10 27 (11.07%) Data Visualisation
10 27 (11.07%) ETL
10 27 (11.07%) SDLC
11 26 (10.66%) Decision-Making
12 25 (10.25%) SOLID
13 23 (9.43%) IT Strategy
13 23 (9.43%) Root Cause Analysis
14 21 (8.61%) Data Science
14 21 (8.61%) DevOps
Programming Languages
1 156 (63.93%) SQL
2 114 (46.72%) Python
3 78 (31.97%) C#
4 31 (12.70%) PowerShell
5 29 (11.89%) C++
6 23 (9.43%) MATLAB
7 22 (9.02%) R
8 18 (7.38%) JavaScript
9 15 (6.15%) Java
9 15 (6.15%) Perl
10 10 (4.10%) Bash Shell
11 9 (3.69%) PHP
12 8 (3.28%) VB
13 7 (2.87%) T-SQL
14 6 (2.46%) VB.NET
15 3 (1.23%) C
15 3 (1.23%) Shell Script
16 2 (0.82%) PL/SQL
17 1 (0.41%) ABAP
17 1 (0.41%) VB6
Qualifications
1 47 (19.26%) Degree
2 17 (6.97%) Numerate Degree
3 7 (2.87%) Computer Science Degree
4 6 (2.46%) Master's Degree
5 4 (1.64%) ACCA
6 3 (1.23%) CIMA
6 3 (1.23%) Security Cleared
7 2 (0.82%) AAT
7 2 (0.82%) CFA
8 1 (0.41%) CBAP
8 1 (0.41%) DBS Check
8 1 (0.41%) PhD
8 1 (0.41%) Postgraduate
8 1 (0.41%) SC Cleared
Quality Assurance & Compliance
1 18 (7.38%) Data Quality
2 15 (6.15%) GDPR
3 9 (3.69%) Basel II
3 9 (3.69%) CRD IV
4 6 (2.46%) QA
5 3 (1.23%) IFRS
5 3 (1.23%) MiFID
5 3 (1.23%) SLA
6 2 (0.82%) AIFMD
6 2 (0.82%) EMIR
6 2 (0.82%) IFRS 9
7 1 (0.41%) Dodd-Frank
7 1 (0.41%) FATCA
System Software
1 9 (3.69%) Docker
2 8 (3.28%) Active Directory
3 1 (0.41%) Virtual Desktop
Systems Management
1 5 (2.05%) Kubernetes
2 1 (0.41%) Control-M
2 1 (0.41%) Microsoft Intune
Vendors
1 73 (29.92%) Microsoft
2 17 (6.97%) Oracle
3 15 (6.15%) IBM
4 14 (5.74%) Fidessa
5 12 (4.92%) GoldenSource
6 9 (3.69%) Bloomberg
6 9 (3.69%) Splunk
7 7 (2.87%) QAD
7 7 (2.87%) Refinitiv
8 6 (2.46%) SAP
9 5 (2.05%) Cognos
10 4 (1.64%) Alteryx
10 4 (1.64%) Concur
10 4 (1.64%) Nintex
10 4 (1.64%) Sage
10 4 (1.64%) Sun
11 3 (1.23%) Apple
11 3 (1.23%) HP
11 3 (1.23%) RedGate
11 3 (1.23%) Tradeweb