Period
to 22 October 2020

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

Microsoft Visual Basic for Applications (VBA)
UK > England
6 months to
22 Oct 2020
Same period 2019 Same period 2018
Rank 471 428 411
Rank change year-on-year -43 -17 +4
Permanent jobs citing VBA 198 872 1,174
As % of all permanent jobs advertised in England 0.44% 0.69% 0.76%
As % of the Programming Languages category 0.74% 1.29% 1.37%
Number of salaries quoted 167 779 1,041
Median annual salary £55,000 £47,500 £45,000
Median salary % change year-on-year +15.79% +5.56% -
10th Percentile £28,100 £28,750 £26,250
90th Percentile £122,500 £72,500 £75,000
UK median annual salary £50,000 £47,500 £45,000
% change year-on-year +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 England with a requirement for coding skills.

All Programming Languages
England
Permanent vacancies with a requirement for coding skills 26,671 67,813 85,682
As % of all permanent IT jobs advertised in England 59.30% 53.62% 55.79%
Number of salaries quoted 22,852 56,180 71,797
Median annual salary £57,500 £52,500 £50,000
Median salary % change year-on-year +9.52% +5.00% -
10th Percentile £35,000 £31,250 £31,250
90th Percentile £92,500 £87,500 £83,750
UK median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +3.09%

VBA
Job Vacancy Trend in England

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

Job vacancy trend for VBA in England

VBA
Salary Trend in England

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

Salary trend for VBA in England

VBA
Salary Histogram in England

Salary distribution for jobs citing VBA in England over the 6 months to 22 October 2020.

Salary histogram for VBA in England

VBA
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing VBA within the England region over the 6 months to 22 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
London -38 132 £85,000 +54.55% 19
South East +163 16 £41,250 +3.13% 9
North of England +66 16 £35,000 -10.26% 12
Midlands +102 15 £30,000 -11.76% 5
North West +56 11 £33,500 -16.25% 5
East Midlands +88 10 £31,250 +4.17% 2
East of England +108 9 £37,500 -16.67% 1
South West +88 9 £32,500 -7.14% 4
West Midlands +82 5 £26,500 -24.29% 3
Yorkshire +98 3 £35,000 - 4
North East +8 2 £27,125 -3.13% 3
VBA
UK

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

1 142 (71.72%) Microsoft Excel
2 131 (66.16%) SQL
3 106 (53.54%) Finance
4 85 (42.93%) Microsoft
5 62 (31.31%) Python
6 50 (25.25%) Agile Software Development
6 50 (25.25%) Analytics
7 45 (22.73%) R
7 45 (22.73%) Front Office
8 44 (22.22%) Asset Management
9 43 (21.72%) Business Analysis
10 41 (20.71%) Data Analysis
11 38 (19.19%) .NET
11 38 (19.19%) C#
12 37 (18.69%) MATLAB
12 37 (18.69%) Degree
13 35 (17.68%) Derivative
14 33 (16.67%) Migration
14 33 (16.67%) Investment Management
15 32 (16.16%) Analytical Skills
15 32 (16.16%) Bloomberg
15 32 (16.16%) Business Intelligence
16 31 (15.66%) Hedge funds
17 30 (15.15%) Power BI
17 30 (15.15%) SQL Server
17 30 (15.15%) Fixed Income
17 30 (15.15%) Power Platform
18 29 (14.65%) Scrum
19 28 (14.14%) OTC Derivatives
19 28 (14.14%) Performance Attribution

VBA
Co-occurring IT Skills in England 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 13 (6.57%) SAS
2 8 (4.04%) SharePoint
3 2 (1.01%) Confluence
Applications
1 142 (71.72%) Microsoft Excel
2 23 (11.62%) Microsoft Office
3 21 (10.61%) Spreadsheet
4 4 (2.02%) Microsoft PowerPoint
5 2 (1.01%) Quantrix
6 1 (0.51%) AutoCAD
6 1 (0.51%) Microsoft Project
6 1 (0.51%) MS Visio
6 1 (0.51%) SPSS
Business Applications
1 3 (1.52%) Oracle Financials
2 1 (0.51%) Dynamics AX
2 1 (0.51%) Elite 3E
2 1 (0.51%) FINCAD Analytics
2 1 (0.51%) PolarLake
2 1 (0.51%) Primavera
2 1 (0.51%) SAP Business One
2 1 (0.51%) Summit
Cloud Services
1 30 (15.15%) Power Platform
2 13 (6.57%) Azure
3 8 (4.04%) Office 365
4 4 (2.02%) AWS
4 4 (2.02%) GCP
5 1 (0.51%) Google Analytics
5 1 (0.51%) Google Tag Manager
5 1 (0.51%) ServiceMax
Communications & Networking
1 7 (3.54%) TCP/IP
2 6 (3.03%) DNS
3 5 (2.53%) DHCP
4 3 (1.52%) 2G
4 3 (1.52%) 3G
4 3 (1.52%) 4G
4 3 (1.52%) 5G
4 3 (1.52%) Radio Access Network
4 3 (1.52%) UTRAN
5 2 (1.01%) Firewall
5 2 (1.01%) Intranet
5 2 (1.01%) VoIP
6 1 (0.51%) HTTP
6 1 (0.51%) Internet
6 1 (0.51%) SMTP
6 1 (0.51%) tcpdump
6 1 (0.51%) VLAN
6 1 (0.51%) VPN
6 1 (0.51%) Wi-Fi
6 1 (0.51%) Wireshark
Database & Business Intelligence
1 30 (15.15%) Power BI
1 30 (15.15%) SQL Server
2 27 (13.64%) Tableau
3 19 (9.60%) SQL Server Reporting Services
4 16 (8.08%) Data Warehouse
5 13 (6.57%) MS Access
6 11 (5.56%) Relational Database
7 9 (4.55%) SQL Server Integration Services
8 6 (3.03%) BusinessObjects
9 5 (2.53%) Data Mining
9 5 (2.53%) QlikView
10 4 (2.02%) RDBMS
11 3 (1.52%) MySQL
11 3 (1.52%) SQL Server Analysis Services
12 2 (1.01%) Azure SQL Database
12 2 (1.01%) BigQuery
12 2 (1.01%) Hadoop
12 2 (1.01%) NoSQL
13 1 (0.51%) OLAP Cube
13 1 (0.51%) PowerPivot
Development Applications
1 7 (3.54%) JIRA
2 5 (2.53%) RStudio
2 5 (2.53%) Subversion
3 4 (2.02%) Git (software)
3 4 (2.02%) Visual Studio
4 2 (1.01%) GCC
4 2 (1.01%) Jenkins
4 2 (1.01%) Team Foundation Server
4 2 (1.01%) WinAutomation
5 1 (0.51%) Oracle Forms
5 1 (0.51%) SQL Server Management Studio (SSMS)
5 1 (0.51%) Visual Studio Tools for Office
5 1 (0.51%) Xcode
General
1 106 (53.54%) Finance
2 45 (22.73%) Front Office
3 9 (4.55%) Retail
4 6 (3.03%) Back Office
4 6 (3.03%) Banking
4 6 (3.03%) Marketing
4 6 (3.03%) Telecoms
5 5 (2.53%) Legal
6 3 (1.52%) Advertising
6 3 (1.52%) Financial Institution
7 2 (1.01%) Investment Banking
7 2 (1.01%) Korean Language
7 2 (1.01%) Law
8 1 (0.51%) Aerospace
8 1 (0.51%) Billing
8 1 (0.51%) Electronics
8 1 (0.51%) Manufacturing
8 1 (0.51%) Public Sector
8 1 (0.51%) Retail Banking
Job Titles
1 63 (31.82%) Analyst
2 61 (30.81%) Developer
3 23 (11.62%) Analytics Manager
4 22 (11.11%) Finance Manager
5 20 (10.10%) Financial Analyst
5 20 (10.10%) Head of Analytics
5 20 (10.10%) Head of Finance
6 12 (6.06%) Applications Support
6 12 (6.06%) Service Analyst
7 11 (5.56%) Business Analyst
7 11 (5.56%) Performance Manager
8 10 (5.05%) DevOps Developer
9 9 (4.55%) Report Developer
10 8 (4.04%) Asset Management Analyst
10 8 (4.04%) C# Developer
10 8 (4.04%) Data Analyst
11 7 (3.54%) Asset Management Business Analyst
11 7 (3.54%) Lead Business Analyst
11 7 (3.54%) Risk Analyst
11 7 (3.54%) Systems Analyst
Libraries, Frameworks & Software Standards
1 38 (19.19%) .NET
2 14 (7.07%) RESTful
3 10 (5.05%) ASP.NET
4 9 (4.55%) HTML
4 9 (4.55%) XML
5 6 (3.03%) CSS
5 6 (3.03%) Pandas
5 6 (3.03%) React
6 4 (2.02%) .NET Framework
6 4 (2.02%) AngularJS
6 4 (2.02%) HTML5
6 4 (2.02%) Web Services
6 4 (2.02%) WinForms
7 3 (1.52%) Ajax
7 3 (1.52%) FIX Protocol
7 3 (1.52%) jQuery
7 3 (1.52%) Node.js
7 3 (1.52%) NumPy
7 3 (1.52%) SciPy
7 3 (1.52%) WCF
Miscellaneous
1 35 (17.68%) Derivative
2 32 (16.16%) Analytical Skills
3 31 (15.66%) Hedge funds
4 30 (15.15%) Fixed Income
5 28 (14.14%) OTC Derivatives
6 9 (4.55%) Management Information System
7 8 (4.04%) Foreign Exchange (FX)
8 6 (3.03%) Self-Motivation
9 5 (2.53%) Client/Server
10 4 (2.02%) Data Centre
11 3 (1.52%) Credit Risk
11 3 (1.52%) Interest Rate Derivative
11 3 (1.52%) Market Risk
12 2 (1.01%) Analytical Mindset
12 2 (1.01%) Driving Licence
12 2 (1.01%) FMCG
12 2 (1.01%) Greenfield Project
12 2 (1.01%) Reference Data
12 2 (1.01%) SCADA
13 1 (0.51%) User Experience
Operating Systems
1 16 (8.08%) Windows
2 6 (3.03%) Linux
2 6 (3.03%) Windows 10
2 6 (3.03%) Windows 7
3 4 (2.02%) Unix
4 2 (1.01%) Windows Server
5 1 (0.51%) Apple iOS
5 1 (0.51%) Windows 8
5 1 (0.51%) Windows Server 2016
Processes & Methodologies
1 50 (25.25%) Agile Software Development
1 50 (25.25%) Analytics
2 44 (22.22%) Asset Management
3 43 (21.72%) Business Analysis
4 41 (20.71%) Data Analysis
5 33 (16.67%) Investment Management
5 33 (16.67%) Migration
6 32 (16.16%) Business Intelligence
7 29 (14.65%) Scrum
8 28 (14.14%) Fund Management
8 28 (14.14%) Performance Attribution
8 28 (14.14%) Risk Analysis
9 21 (10.61%) Problem-Solving
10 20 (10.10%) ETL
11 18 (9.09%) DevOps
12 16 (8.08%) Computer Science
12 16 (8.08%) Stakeholder Management
13 15 (7.58%) ERP
13 15 (7.58%) Mentoring
13 15 (7.58%) Test Automation
Programming Languages
1 131 (66.16%) SQL
2 62 (31.31%) Python
3 45 (22.73%) R
4 38 (19.19%) C#
5 37 (18.69%) MATLAB
6 16 (8.08%) JavaScript
7 14 (7.07%) PowerShell
8 12 (6.06%) VB
9 9 (4.55%) VBScript
10 8 (4.04%) C++
10 8 (4.04%) Java
10 8 (4.04%) T-SQL
11 5 (2.53%) VB.NET
12 3 (1.52%) C
13 2 (1.01%) Bash Shell
13 2 (1.01%) PHP
13 2 (1.01%) PL/SQL
13 2 (1.01%) Shell Script
14 1 (0.51%) Scala
14 1 (0.51%) XAML
Qualifications
1 37 (18.69%) Degree
2 5 (2.53%) Computer Science Degree
2 5 (2.53%) HNC
2 5 (2.53%) HND
3 3 (1.52%) Numerate Degree
4 2 (1.01%) A+ Certification
4 2 (1.01%) ACCA
4 2 (1.01%) CIMA
5 1 (0.51%) DV Cleared
5 1 (0.51%) PMI Certification
5 1 (0.51%) SAS Certification
5 1 (0.51%) SC Cleared
5 1 (0.51%) Security Cleared
Quality Assurance & Compliance
1 14 (7.07%) QA
2 5 (2.53%) SLA
3 3 (1.52%) GDPR
4 2 (1.01%) Data Quality
4 2 (1.01%) IFRS
5 1 (0.51%) COBIT
5 1 (0.51%) GLP
5 1 (0.51%) ISO/IEC 27001
5 1 (0.51%) Sarbanes-Oxley
System Software
1 7 (3.54%) Active Directory
2 1 (0.51%) Cronacle
2 1 (0.51%) Docker
2 1 (0.51%) XenDesktop
Systems Management
1 5 (2.53%) SCCM
Vendors
1 85 (42.93%) Microsoft
2 32 (16.16%) Bloomberg
3 11 (5.56%) Oracle
4 10 (5.05%) SAP
5 6 (3.03%) Google
6 5 (2.53%) HP
6 5 (2.53%) Sun
7 4 (2.02%) Blue Prism
7 4 (2.02%) Reuters
7 4 (2.02%) Salesforce.com
8 3 (1.52%) BT
8 3 (1.52%) Cognos
8 3 (1.52%) FXall
8 3 (1.52%) Huawei
8 3 (1.52%) Nokia
8 3 (1.52%) UiPath
8 3 (1.52%) Yardi
9 2 (1.01%) Automation Anywhere
9 2 (1.01%) IFS
9 2 (1.01%) Murex