Period
to 20 October 2020

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 20 October 2020 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA)
England > London
6 months to
20 Oct 2020
Same period 2019 Same period 2018
Rank 336 312 333
Rank change year-on-year -24 +21 +12
Permanent jobs citing VBA 135 540 651
As % of all permanent jobs advertised in London 0.68% 1.00% 0.96%
As % of the Programming Languages category 1.12% 1.77% 1.68%
Number of salaries quoted 115 504 579
Median annual salary £85,000 £55,000 £52,500
Median salary % change year-on-year +54.55% +4.76% -4.55%
10th Percentile £42,500 £35,000 £31,250
90th Percentile £143,750 £77,500 £81,500
England median annual salary £56,250 £47,500 £45,000
% change year-on-year +18.42% +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 12,069 30,446 38,708
As % of all permanent IT jobs advertised in London 61.11% 56.13% 57.34%
Number of salaries quoted 10,321 25,385 32,027
Median annual salary £70,000 £65,000 £62,500
Median salary % change year-on-year +7.69% +4.00% +4.17%
10th Percentile £45,000 £38,750 £37,500
90th Percentile £110,000 £100,000 £95,000
England median annual salary £57,500 £52,500 £50,000
% change year-on-year +9.52% +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 20 October 2020.

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 20 October 2020. 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 +23 26 £82,500 +43.48% 2
West London +61 9 £39,000 -2.50% 1
North London - 2 £48,750 -
East London +19 1 £105,000 +90.91% 2
VBA
England

For the 6 months to 20 October 2020, 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 105 (77.78%) Microsoft Excel
2 85 (62.96%) Finance
3 84 (62.22%) SQL
4 62 (45.93%) Microsoft
5 58 (42.96%) Python
6 45 (33.33%) Front Office
7 43 (31.85%) R
8 42 (31.11%) Agile Software Development
8 42 (31.11%) Analytics
9 41 (30.37%) Asset Management
10 37 (27.41%) Data Analysis
10 37 (27.41%) Business Analysis
10 37 (27.41%) MATLAB
11 35 (25.93%) Derivative
12 33 (24.44%) Investment Management
13 32 (23.70%) Bloomberg
14 31 (22.96%) Hedge funds
15 30 (22.22%) Fixed Income
16 29 (21.48%) Migration
17 28 (20.74%) Scrum
17 28 (20.74%) Fund Management
17 28 (20.74%) Risk Analysis
17 28 (20.74%) OTC Derivatives
17 28 (20.74%) Performance Attribution
18 27 (20.00%) C#
19 25 (18.52%) .NET
20 23 (17.04%) Tableau
21 22 (16.30%) Degree
22 19 (14.07%) Spreadsheet
23 16 (11.85%) Mentoring

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 3 (2.22%) SAS
2 2 (1.48%) Confluence
3 1 (0.74%) SharePoint
Applications
1 105 (77.78%) Microsoft Excel
2 19 (14.07%) Spreadsheet
3 6 (4.44%) Microsoft Office
4 2 (1.48%) Microsoft PowerPoint
5 1 (0.74%) SPSS
Business Applications
1 1 (0.74%) Elite 3E
1 1 (0.74%) FINCAD Analytics
1 1 (0.74%) PolarLake
Cloud Services
1 13 (9.63%) Power Platform
2 8 (5.93%) Azure
3 4 (2.96%) GCP
4 2 (1.48%) AWS
4 2 (1.48%) Office 365
5 1 (0.74%) Google Analytics
Communications & Networking
1 5 (3.70%) DHCP
1 5 (3.70%) DNS
1 5 (3.70%) TCP/IP
2 1 (0.74%) 2G
2 1 (0.74%) 3G
2 1 (0.74%) 4G
2 1 (0.74%) 5G
2 1 (0.74%) Radio Access Network
2 1 (0.74%) UTRAN
Database & Business Intelligence
1 13 (9.63%) Power BI
2 12 (8.89%) SQL Server
3 9 (6.67%) Data Warehouse
4 8 (5.93%) Relational Database
5 6 (4.44%) MS Access
6 4 (2.96%) RDBMS
6 4 (2.96%) SQL Server Reporting Services
7 3 (2.22%) Data Mining
7 3 (2.22%) SQL Server Integration Services
8 2 (1.48%) BigQuery
8 2 (1.48%) Hadoop
8 2 (1.48%) NoSQL
8 2 (1.48%) SQL Server Analysis Services
9 1 (0.74%) Base SAS
9 1 (0.74%) Big Data
9 1 (0.74%) BusinessObjects
9 1 (0.74%) MongoDB
9 1 (0.74%) Oracle Database
9 1 (0.74%) Oracle Reports
9 1 (0.74%) SQL Server 2008
Development Applications
1 5 (3.70%) JIRA
1 5 (3.70%) RStudio
1 5 (3.70%) Subversion
2 3 (2.22%) Visual Studio
3 2 (1.48%) GCC
3 2 (1.48%) Git (software)
3 2 (1.48%) Jenkins
4 1 (0.74%) SQL Server Management Studio (SSMS)
4 1 (0.74%) Visual Studio Tools for Office
General
1 85 (62.96%) Finance
2 45 (33.33%) Front Office
3 7 (5.19%) Back Office
4 5 (3.70%) Telecoms
5 4 (2.96%) Legal
5 4 (2.96%) Marketing
6 3 (2.22%) Banking
6 3 (2.22%) Financial Institution
6 3 (2.22%) Retail
7 2 (1.48%) Advertising
7 2 (1.48%) Investment Banking
7 2 (1.48%) Law
8 1 (0.74%) Billing
8 1 (0.74%) Electronics
8 1 (0.74%) Manufacturing
8 1 (0.74%) Public Sector
Job Titles
1 44 (32.59%) Developer
2 42 (31.11%) Analyst
3 23 (17.04%) Analytics Manager
4 22 (16.30%) Finance Manager
5 20 (14.81%) Head of Analytics
5 20 (14.81%) Head of Finance
6 19 (14.07%) Financial Analyst
7 11 (8.15%) Performance Manager
7 11 (8.15%) Service Analyst
8 10 (7.41%) Business Analyst
8 10 (7.41%) DevOps Developer
9 9 (6.67%) Report Developer
10 7 (5.19%) Asset Management Analyst
10 7 (5.19%) Asset Management Business Analyst
10 7 (5.19%) Lead Business Analyst
10 7 (5.19%) RAD Developer
10 7 (5.19%) Risk Analyst
11 6 (4.44%) Automation Analyst
11 6 (4.44%) MATLAB Developer
11 6 (4.44%) Tableau Analyst
Libraries, Frameworks & Software Standards
1 25 (18.52%) .NET
2 14 (10.37%) RESTful
3 6 (4.44%) Pandas
3 6 (4.44%) Web Services
4 5 (3.70%) React
5 4 (2.96%) .NET Framework
5 4 (2.96%) ASP.NET
6 3 (2.22%) Anaconda
6 3 (2.22%) AngularJS
6 3 (2.22%) FIX Protocol
6 3 (2.22%) Flask
6 3 (2.22%) HTML
6 3 (2.22%) Node.js
6 3 (2.22%) NumPy
6 3 (2.22%) Redux
6 3 (2.22%) SciPy
6 3 (2.22%) WCF
6 3 (2.22%) WPF
7 2 (1.48%) .NET Core
7 2 (1.48%) REST
Miscellaneous
1 35 (25.93%) Derivative
2 31 (22.96%) Hedge funds
3 30 (22.22%) Fixed Income
4 28 (20.74%) OTC Derivatives
5 15 (11.11%) Analytical Skills
6 8 (5.93%) Foreign Exchange (FX)
7 5 (3.70%) Management Information System
8 3 (2.22%) Data Centre
8 3 (2.22%) Interest Rate Derivative
8 3 (2.22%) Market Risk
9 2 (1.48%) Analytical Mindset
9 2 (1.48%) Credit Risk
9 2 (1.48%) FMCG
9 2 (1.48%) Reference Data
10 1 (0.74%) Equities
10 1 (0.74%) NHS
10 1 (0.74%) Robotics
10 1 (0.74%) Self-Motivation
10 1 (0.74%) Swaptions
10 1 (0.74%) User Experience
Operating Systems
1 9 (6.67%) Windows
2 6 (4.44%) Linux
3 5 (3.70%) Windows 10
3 5 (3.70%) Windows 7
4 4 (2.96%) Unix
5 1 (0.74%) Windows Server
Processes & Methodologies
1 42 (31.11%) Agile Software Development
1 42 (31.11%) Analytics
2 41 (30.37%) Asset Management
3 37 (27.41%) Business Analysis
3 37 (27.41%) Data Analysis
4 33 (24.44%) Investment Management
5 29 (21.48%) Migration
6 28 (20.74%) Fund Management
6 28 (20.74%) Performance Attribution
6 28 (20.74%) Risk Analysis
6 28 (20.74%) Scrum
7 16 (11.85%) Mentoring
8 15 (11.11%) DevOps
9 13 (9.63%) ETL
9 13 (9.63%) Stakeholder Management
10 12 (8.89%) Computer Science
10 12 (8.89%) Continuous Delivery
10 12 (8.89%) Microservices
10 12 (8.89%) Performance Management
10 12 (8.89%) Test Automation
Programming Languages
1 84 (62.22%) SQL
2 58 (42.96%) Python
3 43 (31.85%) R
4 37 (27.41%) MATLAB
5 27 (20.00%) C#
6 10 (7.41%) PowerShell
7 7 (5.19%) Java
7 7 (5.19%) VBScript
8 6 (4.44%) C++
9 4 (2.96%) T-SQL
10 3 (2.22%) VB
11 2 (1.48%) JavaScript
11 2 (1.48%) Shell Script
12 1 (0.74%) Bash Shell
12 1 (0.74%) PHP
12 1 (0.74%) PL/SQL
12 1 (0.74%) Scala
12 1 (0.74%) TypeScript
12 1 (0.74%) XAML
Qualifications
1 22 (16.30%) Degree
2 3 (2.22%) Computer Science Degree
2 3 (2.22%) Numerate Degree
3 2 (1.48%) A+ Certification
4 1 (0.74%) HNC
4 1 (0.74%) HND
Quality Assurance & Compliance
1 12 (8.89%) QA
2 2 (1.48%) SLA
3 1 (0.74%) Data Quality
System Software
1 6 (4.44%) Active Directory
2 1 (0.74%) Cronacle
2 1 (0.74%) Docker
2 1 (0.74%) XenDesktop
Systems Management
1 5 (3.70%) SCCM
Vendors
1 62 (45.93%) Microsoft
2 32 (23.70%) Bloomberg
3 23 (17.04%) Tableau
4 5 (3.70%) Google
4 5 (3.70%) HP
4 5 (3.70%) Sun
5 4 (2.96%) Oracle
5 4 (2.96%) Reuters
6 3 (2.22%) Cognos
6 3 (2.22%) FXall
6 3 (2.22%) Salesforce.com
6 3 (2.22%) SAP
6 3 (2.22%) Yardi
7 2 (1.48%) Murex
7 2 (1.48%) Perforce
8 1 (0.74%) Calypso
8 1 (0.74%) Citrix
8 1 (0.74%) GoldenSource
8 1 (0.74%) Nokia
8 1 (0.74%) VMware