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

Microsoft Visual Basic for Applications (VBA)
UK > England
6 months to
7 Aug 2020
Same period 2019 Same period 2018
Rank 416 403 387
Rank change year-on-year -13 -16 +11
Permanent jobs citing VBA 360 1,010 1,359
As % of all permanent jobs advertised in England 0.60% 0.76% 0.85%
As % of the Programming Languages category 1.06% 1.42% 1.51%
Number of salaries quoted 313 878 1,155
Median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% -
10th Percentile £30,000 £26,250 £26,250
90th Percentile £115,000 £76,751 £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 33,876 71,205 89,796
As % of all permanent IT jobs advertised in England 56.52% 53.89% 56.14%
Number of salaries quoted 28,159 58,881 75,094
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £33,750 £31,250 £31,250
90th Percentile £92,500 £86,250 £82,500
UK median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +5.26%

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 7 August 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 7 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
London -3 234 £70,000 +21.95% 20
North of England +78 31 £30,000 -23.08% 4
South East +103 29 £37,500 +8.70% 3
East of England +87 27 £35,000 -9.09% 1
Midlands +70 23 £36,000 +10.77% 6
Yorkshire +102 16 £25,000 -23.08% 2
West Midlands +74 16 £45,000 +38.46% 3
South West +61 15 £32,500 - 3
North West +75 14 £40,000 -11.11% 2
East Midlands +55 7 £33,000 +10.00% 3
North East +7 1 £30,250 +8.04%
VBA
UK

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

1 251 (69.72%) SQL
2 248 (68.89%) Microsoft Excel
3 159 (44.17%) Finance
4 156 (43.33%) Microsoft
5 128 (35.56%) Python
6 101 (28.06%) C#
7 92 (25.56%) Agile Software Development
8 91 (25.28%) SQL Server
9 87 (24.17%) Analytics
10 79 (21.94%) .NET
11 76 (21.11%) Analytical Skills
12 65 (18.06%) R
13 64 (17.78%) Data Analysis
13 64 (17.78%) Front Office
14 59 (16.39%) Degree
15 58 (16.11%) Business Intelligence
16 55 (15.28%) Scrum
17 53 (14.72%) Power BI
17 53 (14.72%) Power Platform
18 52 (14.44%) Fixed Income
18 52 (14.44%) Microsoft Office
18 52 (14.44%) Tableau
19 50 (13.89%) Derivative
20 49 (13.61%) Business Analysis
21 48 (13.33%) Data Warehouse
22 45 (12.50%) Windows
23 44 (12.22%) Bloomberg
24 43 (11.94%) Migration
24 43 (11.94%) Investment Management
25 42 (11.67%) Asset Management

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 17 (4.72%) Confluence
2 10 (2.78%) SharePoint
3 8 (2.22%) SAS
4 3 (0.83%) IIS
5 1 (0.28%) Apache
5 1 (0.28%) Apache Spark
5 1 (0.28%) MS Exchange
5 1 (0.28%) Tomcat
Applications
1 248 (68.89%) Microsoft Excel
2 52 (14.44%) Microsoft Office
3 17 (4.72%) Spreadsheet
4 14 (3.89%) Microsoft PowerPoint
5 4 (1.11%) SPSS
6 2 (0.56%) Microsoft Project
6 2 (0.56%) Quantrix
7 1 (0.28%) AutoCAD
7 1 (0.28%) MS Visio
Business Applications
1 4 (1.11%) Dynamics CRM
1 4 (1.11%) Exchequer
2 3 (0.83%) Cognos TM1
2 3 (0.83%) Dynamics AX
2 3 (0.83%) MIS ActiveH
3 2 (0.56%) Endur
3 2 (0.56%) SAP Business One
4 1 (0.28%) FINCAD Analytics
4 1 (0.28%) NetSuite
4 1 (0.28%) PolarLake
4 1 (0.28%) Primavera
4 1 (0.28%) Raiser's Edge
4 1 (0.28%) Sage 200
4 1 (0.28%) SAP ERP
4 1 (0.28%) SAP HR
4 1 (0.28%) SAP InfiniteInsight
4 1 (0.28%) Summit
Cloud Services
1 53 (14.72%) Power Platform
2 33 (9.17%) Azure
3 14 (3.89%) AWS
4 11 (3.06%) Office 365
4 11 (3.06%) SaaS
5 7 (1.94%) GCP
6 3 (0.83%) IaaS
6 3 (0.83%) PaaS
7 2 (0.56%) PowerApps
7 2 (0.56%) Smartsheet
8 1 (0.28%) Azure Data Factory
8 1 (0.28%) GitHub
8 1 (0.28%) Google Tag Manager
8 1 (0.28%) Power Automate
Communications & Networking
1 8 (2.22%) DHCP
1 8 (2.22%) DNS
2 7 (1.94%) LAN
2 7 (1.94%) TCP/IP
2 7 (1.94%) WAN
3 5 (1.39%) Cisco IOS
4 4 (1.11%) Radio Access Network
4 4 (1.11%) Skype
5 3 (0.83%) 2G
5 3 (0.83%) 3G
5 3 (0.83%) 4G
5 3 (0.83%) 5G
5 3 (0.83%) UTRAN
6 2 (0.56%) Firewall
7 1 (0.28%) LTE
7 1 (0.28%) SSL
7 1 (0.28%) tcpdump
7 1 (0.28%) UMTS
7 1 (0.28%) VPN
7 1 (0.28%) Wireshark
Database & Business Intelligence
1 91 (25.28%) SQL Server
2 53 (14.72%) Power BI
3 48 (13.33%) Data Warehouse
4 34 (9.44%) SQL Server Reporting Services
5 33 (9.17%) MS Access
5 33 (9.17%) SQL Server Integration Services
6 21 (5.83%) MySQL
7 19 (5.28%) Relational Database
8 17 (4.72%) BusinessObjects
9 14 (3.89%) SQL Server Analysis Services
10 12 (3.33%) NoSQL
10 12 (3.33%) Qlik Sense
11 11 (3.06%) Crystal Reports
11 11 (3.06%) Hadoop
12 9 (2.50%) QlikView
12 9 (2.50%) RDBMS
13 7 (1.94%) Data Lake
14 5 (1.39%) Sybase IQ
15 4 (1.11%) SQL Server 2008
15 4 (1.11%) SQL Server 2012
Development Applications
1 18 (5.00%) JIRA
2 13 (3.61%) Subversion
3 9 (2.50%) Git (software)
4 7 (1.94%) Eclipse
5 6 (1.67%) SQL Server Management Studio (SSMS)
5 6 (1.67%) Visual Studio
6 5 (1.39%) IBM UrbanCode
7 4 (1.11%) GCC
7 4 (1.11%) Jenkins
8 2 (0.56%) LSMW
8 2 (0.56%) Oracle APEX
8 2 (0.56%) RStudio
8 2 (0.56%) Team Foundation Server
9 1 (0.28%) Moq
9 1 (0.28%) TeamCity
9 1 (0.28%) tSQLt
9 1 (0.28%) Visual Studio Tools for Office
9 1 (0.28%) Xcode
General
1 159 (44.17%) Finance
2 64 (17.78%) Front Office
3 26 (7.22%) Telecoms
4 22 (6.11%) Back Office
4 22 (6.11%) Banking
4 22 (6.11%) Retail
5 11 (3.06%) Marketing
6 8 (2.22%) Legal
6 8 (2.22%) Public Sector
7 5 (1.39%) Manufacturing
8 4 (1.11%) Advertising
9 3 (0.83%) Billing
9 3 (0.83%) Police
10 2 (0.56%) Financial Institution
10 2 (0.56%) German Language
10 2 (0.56%) Investment Banking
10 2 (0.56%) Law
11 1 (0.28%) Electronics
11 1 (0.28%) Publishing
11 1 (0.28%) Wholesale Banking
Job Titles
1 131 (36.39%) Analyst
2 128 (35.56%) Developer
3 29 (8.06%) Analytics Manager
4 28 (7.78%) Finance Manager
4 28 (7.78%) Support Analyst
5 27 (7.50%) Financial Analyst
6 22 (6.11%) Data Analyst
7 20 (5.56%) Head of Analytics
7 20 (5.56%) Head of Finance
8 19 (5.28%) C# Developer
8 19 (5.28%) Software Developer
9 18 (5.00%) Python Developer
10 16 (4.44%) Business Analyst
11 15 (4.17%) SQL Developer
12 14 (3.89%) IT Support
12 14 (3.89%) Senior Analyst
13 13 (3.61%) Senior Developer
14 12 (3.33%) Database Developer
14 12 (3.33%) Fixed Income Business Analyst
14 12 (3.33%) Systems Analyst
Libraries, Frameworks & Software Standards
1 79 (21.94%) .NET
2 32 (8.89%) XML
3 30 (8.33%) ASP.NET
4 27 (7.50%) HTML
5 24 (6.67%) Web Services
6 22 (6.11%) WCF
7 18 (5.00%) AngularJS
8 17 (4.72%) React
9 15 (4.17%) WPF
10 12 (3.33%) Node.js
10 12 (3.33%) REST
11 10 (2.78%) CSS
12 8 (2.22%) .NET Framework
13 7 (1.94%) Apache Flex
14 6 (1.67%) HTML5
14 6 (1.67%) Pandas
14 6 (1.67%) RESTful
14 6 (1.67%) SignalR
15 5 (1.39%) .NET Core
15 5 (1.39%) Twitter Bootstrap
Miscellaneous
1 76 (21.11%) Analytical Skills
2 52 (14.44%) Fixed Income
3 50 (13.89%) Derivative
4 40 (11.11%) Hedge funds
5 36 (10.00%) OTC Derivatives
6 19 (5.28%) User Experience
7 16 (4.44%) Management Information System
8 14 (3.89%) Foreign Exchange (FX)
9 12 (3.33%) Greenfield Project
10 7 (1.94%) FMCG
10 7 (1.94%) Market Risk
11 6 (1.67%) Credit Risk
11 6 (1.67%) Equities
11 6 (1.67%) Robotics
11 6 (1.67%) Self-Motivation
12 5 (1.39%) Video Conferencing
13 4 (1.11%) Data Structures
13 4 (1.11%) Interest Rate Derivative
13 4 (1.11%) SWIFT
14 3 (0.83%) Data Centre
Operating Systems
1 45 (12.50%) Windows
2 25 (6.94%) Linux
3 12 (3.33%) Unix
3 12 (3.33%) Windows Server
4 8 (2.22%) Windows 10
4 8 (2.22%) Windows 7
5 1 (0.28%) Apple iOS
5 1 (0.28%) Solaris
5 1 (0.28%) Windows Server 2008
5 1 (0.28%) Windows Server 2016
Processes & Methodologies
1 92 (25.56%) Agile Software Development
2 87 (24.17%) Analytics
3 64 (17.78%) Data Analysis
4 58 (16.11%) Business Intelligence
5 55 (15.28%) Scrum
6 49 (13.61%) Business Analysis
7 43 (11.94%) Investment Management
7 43 (11.94%) Migration
8 42 (11.67%) Asset Management
8 42 (11.67%) Problem-Solving
9 38 (10.56%) Mentoring
10 36 (10.00%) Performance Attribution
10 36 (10.00%) Risk Analysis
11 34 (9.44%) Fund Management
12 32 (8.89%) Computer Science
13 27 (7.50%) Mathematics
14 25 (6.94%) Data Analytics
15 23 (6.39%) ERP
15 23 (6.39%) ETL
15 23 (6.39%) Software Architecture
Programming Languages
1 251 (69.72%) SQL
2 128 (35.56%) Python
3 101 (28.06%) C#
4 65 (18.06%) R
5 42 (11.67%) MATLAB
6 40 (11.11%) Java
6 40 (11.11%) VB
7 33 (9.17%) JavaScript
8 31 (8.61%) T-SQL
9 25 (6.94%) C++
10 22 (6.11%) PHP
11 18 (5.00%) PowerShell
12 15 (4.17%) VBScript
13 12 (3.33%) TypeScript
14 10 (2.78%) VB.NET
15 7 (1.94%) C
15 7 (1.94%) PL/SQL
16 6 (1.67%) Data Analysis Expressions (DAX)
17 5 (1.39%) Shell Script
18 2 (0.56%) XAML
Qualifications
1 59 (16.39%) Degree
2 9 (2.50%) Computer Science Degree
3 5 (1.39%) HNC
3 5 (1.39%) HND
4 4 (1.11%) A+ Certification
4 4 (1.11%) ISEB
4 4 (1.11%) SC Cleared
4 4 (1.11%) Security Cleared
5 2 (0.56%) ACCA
5 2 (0.56%) CIMA
5 2 (0.56%) Microsoft Certification
5 2 (0.56%) Numerate Degree
5 2 (0.56%) PhD
6 1 (0.28%) DV Cleared
6 1 (0.28%) PMI Certification
6 1 (0.28%) PMP
6 1 (0.28%) SAS Certification
Quality Assurance & Compliance
1 13 (3.61%) QA
2 6 (1.67%) Data Quality
3 4 (1.11%) SLA
4 2 (0.56%) Basel II
4 2 (0.56%) Basel III
4 2 (0.56%) Sarbanes-Oxley
5 1 (0.28%) EMIR
5 1 (0.28%) IFRS
5 1 (0.28%) IFRS 9
5 1 (0.28%) PMO
System Software
1 18 (5.00%) Active Directory
2 5 (1.39%) Tivoli Workload Scheduler
3 2 (0.56%) XenApp
4 1 (0.28%) Cronacle
4 1 (0.28%) VMware Infrastructure
4 1 (0.28%) XenDesktop
Systems Management
1 9 (2.50%) SCCM
2 5 (1.39%) Tivoli
3 1 (0.28%) Control-M
Vendors
1 156 (43.33%) Microsoft
2 52 (14.44%) Tableau
3 44 (12.22%) Bloomberg
4 24 (6.67%) Oracle
5 14 (3.89%) SAP
6 10 (2.78%) Citrix
7 9 (2.50%) Blue Prism
7 9 (2.50%) IBM
8 8 (2.22%) Google
8 8 (2.22%) Reuters
9 7 (1.94%) DevExpress
9 7 (1.94%) HP
9 7 (1.94%) Sybase
10 6 (1.67%) Sun
11 5 (1.39%) Apple
11 5 (1.39%) Automation Anywhere
11 5 (1.39%) Avaya
11 5 (1.39%) Cisco
11 5 (1.39%) Cognos
11 5 (1.39%) UiPath