Period
to 25 November 2020

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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
25 Nov 2020
Same period 2019 Same period 2018
Rank 494 447 420
Rank change year-on-year -47 -27 +13
Permanent jobs citing VBA 233 868 1,172
As % of all permanent jobs advertised in the UK 0.43% 0.64% 0.73%
As % of the Programming Languages category 0.72% 1.20% 1.33%
Number of salaries quoted 205 754 1,051
Median annual salary £47,500 £50,000 £45,000
Median salary % change year-on-year -5.00% +11.11% -
10th Percentile £26,350 £29,825 £27,250
90th Percentile £109,000 £75,000 £75,000
UK excluding London median annual salary £36,000 £39,000 £37,500
% change year-on-year -7.69% +4.00% +7.14%

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

All Programming Languages
UK
Permanent vacancies with a requirement for coding skills 32,401 72,543 88,313
As % of all permanent IT jobs advertised in the UK 59.11% 53.77% 55.24%
Number of salaries quoted 27,764 59,810 73,537
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% -
10th Percentile £33,750 £31,250 £31,250
90th Percentile £90,000 £86,250 £83,750
UK excluding London median annual salary £50,000 £45,000 £45,000
% change year-on-year +11.11% - +5.88%

VBA
Job Vacancy Trend

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

Job vacancy trend for VBA in the UK

VBA
Salary Trend

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

Salary trend for VBA in the UK

VBA
Salary Histogram

Salary distribution for jobs citing VBA over the 6 months to 25 November 2020.

Salary histogram for VBA in the UK

VBA
Top 17 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing VBA within the UK over the 6 months to 25 November 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
England -66 216 £49,500 -1.00% 47
London -52 116 £80,000 +45.45% 23
UK excluding London +72 110 £36,000 -7.69% 26
South East +133 22 £39,500 -1.25% 10
North of England +53 22 £35,000 -10.26% 4
Midlands +88 21 £30,000 -4.76% 4
South West +96 17 £32,500 -23.53% 2
East of England +112 14 £45,000 - 4
East Midlands +80 14 £30,000 - 1
North West +42 14 £27,500 -29.49% 2
Work from Home +3 13 £46,250 +2.78% 4
West Midlands +81 10 £30,000 -4.76% 3
Yorkshire +85 6 £54,000 +54.29% 2
Wales +42 5 £43,500 -42.00%
Northern Ireland - 5 - - 1
Scotland +64 4 £35,000 -60.00% 1
North East +15 2 £27,125 -6.47%

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

1 150 (64.38%) SQL
2 148 (63.52%) Microsoft Excel
3 103 (44.21%) Finance
4 79 (33.91%) Microsoft
5 62 (26.61%) C#
6 60 (25.75%) .NET
7 56 (24.03%) Python
8 50 (21.46%) Business Intelligence
9 46 (19.74%) SQL Server
10 45 (19.31%) Agile Software Development
10 45 (19.31%) Power BI
10 45 (19.31%) Power Platform
11 41 (17.60%) Analytical Skills
12 40 (17.17%) Degree
13 36 (15.45%) Analytics
13 36 (15.45%) Problem-Solving
14 33 (14.16%) Asset Management
14 33 (14.16%) Data Analysis
15 31 (13.30%) Business Analysis
15 31 (13.30%) Front Office
15 31 (13.30%) Windows
16 29 (12.45%) ETL
17 28 (12.02%) Tableau
18 27 (11.59%) SQL Server Reporting Services
19 25 (10.73%) Microsoft Office
19 25 (10.73%) R
20 23 (9.87%) DevOps
20 23 (9.87%) Spreadsheet
21 22 (9.44%) Test Automation
21 22 (9.44%) Azure

VBA
Co-occurring IT Skills 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 (5.58%) SAS
2 11 (4.72%) SharePoint
3 4 (1.72%) Confluence
4 1 (0.43%) Apache
4 1 (0.43%) CMS
4 1 (0.43%) Elasticsearch
4 1 (0.43%) IIS
4 1 (0.43%) MS Exchange
4 1 (0.43%) Tomcat
Applications
1 148 (63.52%) Microsoft Excel
2 25 (10.73%) Microsoft Office
3 23 (9.87%) Spreadsheet
4 5 (2.15%) Microsoft PowerPoint
4 5 (2.15%) MS Visio
5 2 (0.86%) Quantrix
6 1 (0.43%) Microsoft Project
6 1 (0.43%) SPSS
Business Applications
1 3 (1.29%) Oracle Financials
2 2 (0.86%) NetSuite
3 1 (0.43%) Dynamics AX
3 1 (0.43%) Elite 3E
3 1 (0.43%) FINCAD Analytics
3 1 (0.43%) PolarLake
3 1 (0.43%) Primavera
3 1 (0.43%) Sage 200
3 1 (0.43%) SAP Business One
3 1 (0.43%) Summit
Cloud Services
1 45 (19.31%) Power Platform
2 22 (9.44%) Azure
3 11 (4.72%) Office 365
4 5 (2.15%) AWS
4 5 (2.15%) Azure Data Factory
4 5 (2.15%) GCP
5 2 (0.86%) Dynamics 365
5 2 (0.86%) PaaS
6 1 (0.43%) G Suite
6 1 (0.43%) Google Analytics
6 1 (0.43%) Google Tag Manager
6 1 (0.43%) IaaS
6 1 (0.43%) PowerApps
6 1 (0.43%) ServiceMax
6 1 (0.43%) Trello
Communications & Networking
1 6 (2.58%) DNS
1 6 (2.58%) Intranet
1 6 (2.58%) TCP/IP
2 5 (2.15%) DHCP
2 5 (2.15%) VoIP
3 3 (1.29%) Firewall
3 3 (1.29%) OpenVPN
3 3 (1.29%) VPN
4 2 (0.86%) VLAN
5 1 (0.43%) HTTP
5 1 (0.43%) Internet
5 1 (0.43%) LAN
5 1 (0.43%) PBX
5 1 (0.43%) SMTP
5 1 (0.43%) SSL
5 1 (0.43%) tcpdump
5 1 (0.43%) Wi-Fi
5 1 (0.43%) Wireshark
Database & Business Intelligence
1 46 (19.74%) SQL Server
2 45 (19.31%) Power BI
3 28 (12.02%) Tableau
4 27 (11.59%) SQL Server Reporting Services
5 20 (8.58%) Data Warehouse
6 13 (5.58%) MS Access
6 13 (5.58%) SQL Server Integration Services
7 11 (4.72%) Relational Database
8 7 (3.00%) BusinessObjects
8 7 (3.00%) Oracle Reports
8 7 (3.00%) QlikView
9 6 (2.58%) Crystal Reports
10 5 (2.15%) Data Lake
11 4 (1.72%) Data Mining
11 4 (1.72%) MySQL
12 3 (1.29%) Azure SQL Database
12 3 (1.29%) RDBMS
12 3 (1.29%) SQL Server Analysis Services
13 2 (0.86%) BigQuery
13 2 (0.86%) NoSQL
Development Applications
1 12 (5.15%) JIRA
2 7 (3.00%) Visual Studio
3 6 (2.58%) Git (software)
3 6 (2.58%) Subversion
4 5 (2.15%) Oracle Forms
4 5 (2.15%) RStudio
5 4 (1.72%) Jenkins
5 4 (1.72%) WinAutomation
6 3 (1.29%) GCC
7 2 (0.86%) SQL Server Management Studio (SSMS)
7 2 (0.86%) Team Foundation Server
8 1 (0.43%) Atlassian Bamboo
8 1 (0.43%) Visual Studio Tools for Office
8 1 (0.43%) Xcode
General
1 103 (44.21%) Finance
2 31 (13.30%) Front Office
3 11 (4.72%) Retail
4 9 (3.86%) Marketing
5 8 (3.43%) Banking
6 5 (2.15%) Back Office
7 4 (1.72%) Korean Language
7 4 (1.72%) Telecoms
8 3 (1.29%) Financial Institution
8 3 (1.29%) Investment Banking
8 3 (1.29%) Manufacturing
9 2 (0.86%) Housing Association
9 2 (0.86%) Legal
9 2 (0.86%) Mandarin Language
10 1 (0.43%) Advertising
10 1 (0.43%) Aerospace
10 1 (0.43%) Law
10 1 (0.43%) Public Sector
10 1 (0.43%) Retail Banking
Job Titles
1 83 (35.62%) Developer
2 77 (33.05%) Analyst
3 25 (10.73%) Applications Support
4 20 (8.58%) Financial Analyst
5 15 (6.44%) Support Analyst
6 13 (5.58%) C# Developer
7 12 (5.15%) Applications Support Analyst
7 12 (5.15%) Senior Analyst
7 12 (5.15%) Service Analyst
8 11 (4.72%) Business Analyst
9 10 (4.29%) DevOps Developer
10 9 (3.86%) Business Intelligence Developer
10 9 (3.86%) Report Developer
11 8 (3.43%) Finance Manager
11 8 (3.43%) RAD Developer
11 8 (3.43%) Robotic Process Automation Developer
11 8 (3.43%) Senior Developer
12 7 (3.00%) Analytics Manager
12 7 (3.00%) Senior Applications Support
12 7 (3.00%) Systems Analyst
Libraries, Frameworks & Software Standards
1 60 (25.75%) .NET
2 17 (7.30%) RESTful
3 14 (6.01%) HTML
4 13 (5.58%) ASP.NET
5 9 (3.86%) WinForms
6 7 (3.00%) CSS
6 7 (3.00%) XML
7 6 (2.58%) .NET Framework
8 5 (2.15%) Pandas
8 5 (2.15%) React
9 4 (1.72%) AngularJS
9 4 (1.72%) HTML5
9 4 (1.72%) jQuery
9 4 (1.72%) Web Services
10 3 (1.29%) Ajax
10 3 (1.29%) Boost C++ Libraries
10 3 (1.29%) EDI
10 3 (1.29%) Qt
10 3 (1.29%) WCF
10 3 (1.29%) WPF
Miscellaneous
1 41 (17.60%) Analytical Skills
2 14 (6.01%) Derivative
2 14 (6.01%) Management Information System
3 13 (5.58%) Self-Motivation
4 11 (4.72%) Hedge funds
5 10 (4.29%) Fixed Income
6 8 (3.43%) OTC Derivatives
7 7 (3.00%) Foreign Exchange (FX)
8 5 (2.15%) Client/Server
9 4 (1.72%) Data Centre
10 3 (1.29%) Credit Risk
10 3 (1.29%) Driving Licence
10 3 (1.29%) FMCG
10 3 (1.29%) Interest Rate Derivative
10 3 (1.29%) Robotics
11 2 (0.86%) Data Structures
11 2 (0.86%) NHS
11 2 (0.86%) Reference Data
11 2 (0.86%) SCADA
11 2 (0.86%) Virtual Team
Operating Systems
1 31 (13.30%) Windows
2 10 (4.29%) Linux
2 10 (4.29%) Windows 10
3 6 (2.58%) Windows Server
4 5 (2.15%) Unix
4 5 (2.15%) Windows 7
5 4 (1.72%) Windows Server 2016
6 2 (0.86%) Windows Server 2012
7 1 (0.43%) Apple iOS
7 1 (0.43%) Windows 8
7 1 (0.43%) Windows Server 2019
Processes & Methodologies
1 50 (21.46%) Business Intelligence
2 45 (19.31%) Agile Software Development
3 36 (15.45%) Analytics
3 36 (15.45%) Problem-Solving
4 33 (14.16%) Asset Management
4 33 (14.16%) Data Analysis
5 31 (13.30%) Business Analysis
6 29 (12.45%) ETL
7 23 (9.87%) DevOps
8 22 (9.44%) Test Automation
9 21 (9.01%) Computer Science
10 20 (8.58%) ERP
11 18 (7.73%) Stakeholder Management
12 17 (7.30%) Investment Management
12 17 (7.30%) Project Management
13 16 (6.87%) Data Modelling
14 14 (6.01%) Migration
14 14 (6.01%) Robotic Process Automation
15 13 (5.58%) Continuous Delivery
15 13 (5.58%) Mentoring
Programming Languages
1 150 (64.38%) SQL
2 62 (26.61%) C#
3 56 (24.03%) Python
4 25 (10.73%) R
5 20 (8.58%) JavaScript
6 17 (7.30%) MATLAB
7 15 (6.44%) PowerShell
8 14 (6.01%) VB
9 12 (5.15%) T-SQL
10 10 (4.29%) C++
11 8 (3.43%) Java
12 7 (3.00%) Bash Shell
12 7 (3.00%) VB.NET
12 7 (3.00%) VBScript
13 4 (1.72%) PHP
14 3 (1.29%) C
14 3 (1.29%) Shell Script
15 2 (0.86%) PL/SQL
16 1 (0.43%) Perl
16 1 (0.43%) SQR
Qualifications
1 40 (17.17%) Degree
2 10 (4.29%) Computer Science Degree
3 3 (1.29%) Numerate Degree
4 2 (0.86%) HNC
4 2 (0.86%) HND
5 1 (0.43%) ACCA
5 1 (0.43%) CCAB
5 1 (0.43%) CIMA
5 1 (0.43%) DV Cleared
5 1 (0.43%) Master's Degree
5 1 (0.43%) PMI Certification
5 1 (0.43%) SAS Certification
5 1 (0.43%) SC Cleared
5 1 (0.43%) Security Cleared
Quality Assurance & Compliance
1 17 (7.30%) QA
2 5 (2.15%) GDPR
3 4 (1.72%) SLA
4 3 (1.29%) Data Quality
4 3 (1.29%) ISO/IEC 27001
5 2 (0.86%) IFRS
6 1 (0.43%) COBIT
6 1 (0.43%) GLP
6 1 (0.43%) Sarbanes-Oxley
System Software
1 12 (5.15%) Active Directory
2 4 (1.72%) Hyper-V
2 4 (1.72%) VMware ESXi
3 3 (1.29%) pfSense
4 2 (0.86%) Docker
5 1 (0.43%) Cronacle
5 1 (0.43%) Firmware
5 1 (0.43%) XenDesktop
Systems Management
1 3 (1.29%) SCCM
2 1 (0.43%) Kibana
Vendors
1 79 (33.91%) Microsoft
2 15 (6.44%) Oracle
2 15 (6.44%) SAP
3 12 (5.15%) Bloomberg
4 10 (4.29%) UiPath
5 8 (3.43%) Blue Prism
6 7 (3.00%) Google
7 6 (2.58%) Automation Anywhere
7 6 (2.58%) Sage
8 4 (1.72%) Databricks
8 4 (1.72%) HP
8 4 (1.72%) Reuters
8 4 (1.72%) Salesforce.com
8 4 (1.72%) VMware
9 3 (1.29%) Cognos
9 3 (1.29%) FXall
9 3 (1.29%) Perforce
9 3 (1.29%) Sun
9 3 (1.29%) Yardi
10 2 (0.86%) IFS