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

Microsoft Visual Basic for Applications (VBA)
England > London
6 months to
11 Aug 2020
Same period 2019 Same period 2018
Rank 319 312 312
Rank change year-on-year -7 0 +9
Permanent jobs citing VBA 224 578 778
As % of all permanent jobs advertised in London 0.85% 1.03% 1.11%
As % of the Programming Languages category 1.45% 1.83% 1.96%
Number of salaries quoted 198 505 653
Median annual salary £70,000 £55,000 £52,500
Median salary % change year-on-year +27.27% +4.76% -4.55%
10th Percentile £40,000 £35,000 £32,500
90th Percentile £122,500 £81,250 £82,500
England median annual salary £52,500 £47,500 £45,000
% change year-on-year +10.53% +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 15,439 31,632 39,671
As % of all permanent IT jobs advertised in London 58.57% 56.10% 56.71%
Number of salaries quoted 12,682 26,618 32,625
Median annual salary £70,000 £65,000 £62,500
Median salary % change year-on-year +7.69% +4.00% +4.17%
10th Percentile £42,500 £38,750 £37,500
90th Percentile £107,500 £97,500 £93,750
England median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +5.26%

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 11 August 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 11 August 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 +3 37 £55,000 -4.35% 8
West London +50 19 £45,000 +12.50% 1
South London +16 3 £32,500 -18.75%
East London +13 1 £105,000 +82.61% 1
VBA
England

For the 6 months to 11 August 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 163 (72.77%) Microsoft Excel
2 151 (67.41%) SQL
3 127 (56.70%) Finance
4 107 (47.77%) Python
5 94 (41.96%) Microsoft
6 71 (31.70%) Agile Software Development
7 63 (28.13%) Front Office
7 63 (28.13%) C#
8 62 (27.68%) Analytics
9 57 (25.45%) R
10 52 (23.21%) Fixed Income
11 49 (21.88%) Derivative
12 48 (21.43%) Scrum
13 47 (20.98%) SQL Server
14 46 (20.54%) Data Analysis
15 44 (19.64%) Business Analysis
15 44 (19.64%) Degree
15 44 (19.64%) Bloomberg
16 43 (19.20%) MATLAB
16 43 (19.20%) Investment Management
17 41 (18.30%) Asset Management
18 40 (17.86%) Hedge funds
19 37 (16.52%) Tableau
20 36 (16.07%) Risk Analysis
20 36 (16.07%) OTC Derivatives
20 36 (16.07%) Performance Attribution
21 35 (15.63%) Migration
21 35 (15.63%) .NET
22 34 (15.18%) Fund Management
22 34 (15.18%) Analytical Skills

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 15 (6.70%) Confluence
2 5 (2.23%) SharePoint
3 1 (0.45%) IIS
3 1 (0.45%) SAS
Applications
1 163 (72.77%) Microsoft Excel
2 17 (7.59%) Spreadsheet
3 14 (6.25%) Microsoft Office
4 7 (3.13%) Microsoft PowerPoint
5 1 (0.45%) Microsoft Project
5 1 (0.45%) MS Visio
Business Applications
1 4 (1.79%) Dynamics CRM
2 2 (0.89%) Cognos TM1
2 2 (0.89%) Endur
3 1 (0.45%) FINCAD Analytics
3 1 (0.45%) PolarLake
3 1 (0.45%) Sage 200
Cloud Services
1 32 (14.29%) Power Platform
2 22 (9.82%) Azure
3 9 (4.02%) Office 365
4 6 (2.68%) AWS
4 6 (2.68%) GCP
5 2 (0.89%) IaaS
5 2 (0.89%) PaaS
5 2 (0.89%) SaaS
Communications & Networking
1 8 (3.57%) DHCP
1 8 (3.57%) DNS
2 7 (3.13%) TCP/IP
3 5 (2.23%) Cisco IOS
4 2 (0.89%) Skype
5 1 (0.45%) 2G
5 1 (0.45%) 3G
5 1 (0.45%) 4G
5 1 (0.45%) 5G
5 1 (0.45%) Radio Access Network
5 1 (0.45%) UTRAN
5 1 (0.45%) VPN
Database & Business Intelligence
1 47 (20.98%) SQL Server
2 32 (14.29%) Power BI
3 30 (13.39%) Data Warehouse
4 15 (6.70%) Relational Database
5 13 (5.80%) MS Access
6 11 (4.91%) NoSQL
7 10 (4.46%) MySQL
8 9 (4.02%) Hadoop
8 9 (4.02%) RDBMS
8 9 (4.02%) SQL Server Integration Services
9 8 (3.57%) SQL Server Reporting Services
10 6 (2.68%) Data Lake
11 5 (2.23%) SQL Server Analysis Services
11 5 (2.23%) Sybase IQ
12 4 (1.79%) BusinessObjects
13 3 (1.34%) Azure SQL Data Warehouse
13 3 (1.34%) Azure SQL Database
14 2 (0.89%) DB2
14 2 (0.89%) Essbase
14 2 (0.89%) SQL Server 2008
Development Applications
1 16 (7.14%) JIRA
2 12 (5.36%) Subversion
3 6 (2.68%) Eclipse
4 4 (1.79%) Git (software)
4 4 (1.79%) Visual Studio
5 3 (1.34%) GCC
5 3 (1.34%) Jenkins
5 3 (1.34%) RStudio
6 2 (0.89%) SQL Server Management Studio (SSMS)
7 1 (0.45%) Oracle APEX
7 1 (0.45%) Visual Studio Tools for Office
General
1 127 (56.70%) Finance
2 63 (28.13%) Front Office
3 20 (8.93%) Back Office
4 16 (7.14%) Banking
5 15 (6.70%) Retail
6 8 (3.57%) Marketing
7 7 (3.13%) Telecoms
8 6 (2.68%) Legal
9 4 (1.79%) Advertising
9 4 (1.79%) Public Sector
10 3 (1.34%) Billing
11 2 (0.89%) Financial Institution
11 2 (0.89%) German Language
11 2 (0.89%) Investment Banking
11 2 (0.89%) Law
11 2 (0.89%) Police
12 1 (0.45%) Electronics
12 1 (0.45%) Manufacturing
12 1 (0.45%) Wholesale Banking
Job Titles
1 81 (36.16%) Developer
2 80 (35.71%) Analyst
3 28 (12.50%) Finance Manager
4 26 (11.61%) Analytics Manager
4 26 (11.61%) Financial Analyst
5 20 (8.93%) Head of Analytics
5 20 (8.93%) Head of Finance
6 16 (7.14%) Business Analyst
6 16 (7.14%) C# Developer
7 15 (6.70%) Python Developer
8 12 (5.36%) Fixed Income Business Analyst
8 12 (5.36%) Software Developer
9 11 (4.91%) Performance Manager
9 11 (4.91%) Senior Analyst
9 11 (4.91%) Service Analyst
9 11 (4.91%) Support Analyst
10 10 (4.46%) SQL Developer
11 9 (4.02%) Risk Analyst
12 8 (3.57%) Report Developer
12 8 (3.57%) VBA Developer
Libraries, Frameworks & Software Standards
1 35 (15.63%) .NET
2 18 (8.04%) Web Services
3 17 (7.59%) HTML
4 11 (4.91%) XML
5 10 (4.46%) AngularJS
5 10 (4.46%) ASP.NET
5 10 (4.46%) React
6 8 (3.57%) .NET Framework
6 8 (3.57%) RESTful
7 7 (3.13%) CSS
8 6 (2.68%) Pandas
8 6 (2.68%) SignalR
9 5 (2.23%) .NET Core
9 5 (2.23%) Node.js
9 5 (2.23%) REST
9 5 (2.23%) Twitter Bootstrap
10 4 (1.79%) HTML5
10 4 (1.79%) Velocity
10 4 (1.79%) WCF
11 3 (1.34%) WPF
Miscellaneous
1 52 (23.21%) Fixed Income
2 49 (21.88%) Derivative
3 40 (17.86%) Hedge funds
4 36 (16.07%) OTC Derivatives
5 34 (15.18%) Analytical Skills
6 14 (6.25%) Foreign Exchange (FX)
7 11 (4.91%) Greenfield Project
8 10 (4.46%) Management Information System
9 8 (3.57%) User Experience
10 7 (3.13%) FMCG
10 7 (3.13%) Market Risk
11 6 (2.68%) Equities
12 5 (2.23%) Credit Risk
12 5 (2.23%) Video Conferencing
13 4 (1.79%) Interest Rate Derivative
13 4 (1.79%) SWIFT
14 3 (1.34%) Analytical Mindset
14 3 (1.34%) Data Centre
15 2 (0.89%) Self-Motivation
15 2 (0.89%) Virtual Team
Operating Systems
1 18 (8.04%) Windows
2 15 (6.70%) Linux
3 11 (4.91%) Unix
4 8 (3.57%) Windows 10
4 8 (3.57%) Windows 7
5 2 (0.89%) Windows Server
Processes & Methodologies
1 71 (31.70%) Agile Software Development
2 62 (27.68%) Analytics
3 48 (21.43%) Scrum
4 46 (20.54%) Data Analysis
5 44 (19.64%) Business Analysis
6 43 (19.20%) Investment Management
7 41 (18.30%) Asset Management
8 36 (16.07%) Performance Attribution
8 36 (16.07%) Risk Analysis
9 35 (15.63%) Migration
10 34 (15.18%) Fund Management
11 30 (13.39%) Mentoring
12 27 (12.05%) Business Intelligence
13 26 (11.61%) Computer Science
14 20 (8.93%) Mathematics
15 17 (7.59%) DevOps
15 17 (7.59%) Software Architecture
15 17 (7.59%) Test Automation
16 16 (7.14%) Problem-Solving
16 16 (7.14%) Stakeholder Management
Programming Languages
1 151 (67.41%) SQL
2 107 (47.77%) Python
3 63 (28.13%) C#
4 57 (25.45%) R
5 43 (19.20%) MATLAB
6 33 (14.73%) Java
7 22 (9.82%) C++
8 15 (6.70%) PowerShell
9 11 (4.91%) VBScript
10 10 (4.46%) PHP
10 10 (4.46%) VB
11 9 (4.02%) JavaScript
12 8 (3.57%) T-SQL
13 5 (2.23%) Data Analysis Expressions (DAX)
13 5 (2.23%) Shell Script
13 5 (2.23%) TypeScript
14 4 (1.79%) PL/SQL
15 3 (1.34%) VB.NET
16 2 (0.89%) C
16 2 (0.89%) XAML
Qualifications
1 44 (19.64%) Degree
2 9 (4.02%) Computer Science Degree
3 4 (1.79%) A+ Certification
3 4 (1.79%) ISEB
4 2 (0.89%) Numerate Degree
4 2 (0.89%) PhD
4 2 (0.89%) SC Cleared
4 2 (0.89%) Security Cleared
5 1 (0.45%) HNC
5 1 (0.45%) HND
5 1 (0.45%) PMI Certification
5 1 (0.45%) PMP
Quality Assurance & Compliance
1 13 (5.80%) QA
2 4 (1.79%) Data Quality
2 4 (1.79%) SLA
3 2 (0.89%) Basel II
3 2 (0.89%) Basel III
3 2 (0.89%) Sarbanes-Oxley
4 1 (0.45%) EMIR
4 1 (0.45%) IFRS
4 1 (0.45%) IFRS 9
System Software
1 9 (4.02%) Active Directory
2 1 (0.45%) Cronacle
2 1 (0.45%) VMware Infrastructure
2 1 (0.45%) XenDesktop
Systems Management
1 8 (3.57%) SCCM
2 1 (0.45%) Control-M
Vendors
1 94 (41.96%) Microsoft
2 44 (19.64%) Bloomberg
3 37 (16.52%) Tableau
4 14 (6.25%) Oracle
5 8 (3.57%) Reuters
6 7 (3.13%) HP
6 7 (3.13%) Sybase
7 6 (2.68%) Google
7 6 (2.68%) Sun
8 5 (2.23%) Apple
8 5 (2.23%) Avaya
8 5 (2.23%) Cisco
9 4 (1.79%) Cognos
9 4 (1.79%) SAP
10 3 (1.34%) Aderant
10 3 (1.34%) Blue Prism
10 3 (1.34%) Intapp
10 3 (1.34%) Perforce
10 3 (1.34%) Yardi
11 2 (0.89%) ServiceNow