Job Vacancy Trend Salary Trend Salary Histogram Job Locations Skill Sets
Period
to 6 May 2021

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 6 May 2021 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
6 May 2021		 Same period 2020 Same period 2019
Rank 518 438 440
Rank change year-on-year -80 +2 -44
Permanent jobs citing VBA 402 656 1,027
As % of all permanent jobs advertised in the UK 0.46% 0.64% 0.70%
As % of the Programming Languages category 0.83% 1.18% 1.29%
Number of salaries quoted 312 560 836
10th Percentile £29,300 £29,975 £26,125
25th Percentile £35,000 £35,000 £32,500
Median annual salary (50th Percentile) £45,000 £47,500 £47,500
Median % change year-on-year -5.26% - +5.56%
75th Percentile £59,063 £67,500 £65,000
90th Percentile £95,000 £77,500 £82,500
UK excluding London median annual salary £40,175 £37,500 £35,000
% change year-on-year +7.13% +7.14% -6.67%

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 48,365 55,768 79,798
As % of all permanent IT jobs advertised in the UK 54.91% 54.59% 54.31%
Number of salaries quoted 38,340 46,401 65,808
10th Percentile £33,750 £32,500 £31,250
25th Percentile £42,500 £40,500 £37,500
Median annual salary (50th Percentile) £55,000 £55,000 £52,500
Median % change year-on-year - +4.76% +5.00%
75th Percentile £75,000 £72,500 £70,000
90th Percentile £90,000 £90,000 £85,000
UK excluding London median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

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 6 May 2021.

Salary histogram for VBA in the UK

VBA
Top 16 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 6 May 2021. 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 -56 366 £45,000 -10.00% 68
UK excluding London -17 207 £40,175 +7.13% 37
London -53 170 £55,000 -4.35% 34
Work from Home -101 65 £45,000 - 6
Midlands +44 57 £40,000 +23.08% 7
East of England +25 49 £45,000 +28.57% 7
West Midlands +14 41 £41,000 +28.15% 5
North of England -16 35 £36,000 +2.86% 5
South East +14 34 £36,250 -3.33% 8
Yorkshire -17 22 £41,000 +64.00% 3
East Midlands +22 19 £31,000 -13.89% 2
Scotland -2 15 £50,000 -9.09% 2
South West -34 14 £38,750 -13.89% 7
North West +3 11 £34,250 -14.38% 2
Wales +5 3 £40,000 +11.11% 1
North East +10 2 £26,000 -54.78%

For the 6 months to 6 May 2021, 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 255 (63.43%) SQL
2 196 (48.76%) Microsoft Excel
3 142 (35.32%) Finance
4 136 (33.83%) Python
5 131 (32.59%) C#
6 110 (27.36%) Microsoft
7 107 (26.62%) Business Intelligence
8 104 (25.87%) Analytical Skills
9 103 (25.62%) Social Skills
9 103 (25.62%) SQL Server
10 101 (25.12%) .NET
11 90 (22.39%) Analytics
12 80 (19.90%) Problem-Solving
12 80 (19.90%) Power Platform
12 80 (19.90%) Power BI
13 71 (17.66%) Degree
14 56 (13.93%) Project Management
15 45 (11.19%) Visualisation
16 43 (10.70%) SQL Server Reporting Services
16 43 (10.70%) Data Analysis
16 43 (10.70%) Agile Software Development
17 42 (10.45%) Front Office
17 42 (10.45%) T-SQL
18 38 (9.45%) Microsoft Office
18 38 (9.45%) MVC
18 38 (9.45%) SQL Server Integration Services
19 37 (9.20%) Asset Management
19 37 (9.20%) Windows
20 36 (8.96%) SharePoint
20 36 (8.96%) JavaScript

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 36 (8.96%) SharePoint
2 7 (1.74%) SAS
3 3 (0.75%) ArcGIS
3 3 (0.75%) IIS
4 2 (0.50%) Confluence
5 1 (0.25%) Apache
5 1 (0.25%) ArcSDE
5 1 (0.25%) Jetty
5 1 (0.25%) MS Exchange
5 1 (0.25%) MTS
5 1 (0.25%) Tomcat
5 1 (0.25%) WordPress
Applications
1 196 (48.76%) Microsoft Excel
2 38 (9.45%) Microsoft Office
3 19 (4.73%) MS Visio
4 9 (2.24%) Microsoft PowerPoint
4 9 (2.24%) Simulink
5 6 (1.49%) Spreadsheet
6 2 (0.50%) Microsoft Project
7 1 (0.25%) PrintSoft PReS
7 1 (0.25%) ProjectWise
Business Applications
1 5 (1.24%) NetSuite
2 4 (1.00%) Dynamics GP
3 2 (0.50%) Dynamics CRM
3 2 (0.50%) Elite 3E
3 2 (0.50%) HFM
3 2 (0.50%) iTrent
4 1 (0.25%) Aareon QL
4 1 (0.25%) Cognos TM1
4 1 (0.25%) Dynamics NAV
4 1 (0.25%) Findur
4 1 (0.25%) Hyperion Planning
4 1 (0.25%) Markit EDM
4 1 (0.25%) Orchestrade
4 1 (0.25%) Pegasus Opera
4 1 (0.25%) SAP S/4HANA
4 1 (0.25%) Sentinel
Cloud Services
1 80 (19.90%) Power Platform
2 30 (7.46%) Azure
3 26 (6.47%) Microsoft 365
4 15 (3.73%) PowerApps
5 10 (2.49%) AWS
5 10 (2.49%) Dynamics 365
6 7 (1.74%) Power Automate
7 5 (1.24%) Azure Data Factory
8 2 (0.50%) GCP
8 2 (0.50%) Google Workspace
8 2 (0.50%) IaaS
8 2 (0.50%) PaaS
8 2 (0.50%) ServiceMax
9 1 (0.25%) Adobe Analytics
9 1 (0.25%) Google Analytics
9 1 (0.25%) Mimecast
9 1 (0.25%) Trello
Communications & Networking
1 20 (4.98%) Firewall
2 8 (1.99%) Wi-Fi
3 5 (1.24%) Intranet
4 4 (1.00%) DHCP
4 4 (1.00%) DNS
4 4 (1.00%) VLAN
4 4 (1.00%) VoIP
5 3 (0.75%) FTP
5 3 (0.75%) OpenVPN
6 1 (0.25%) LAN
6 1 (0.25%) VPN
6 1 (0.25%) WAN
Database & Business Intelligence
1 103 (25.62%) SQL Server
2 80 (19.90%) Power BI
3 43 (10.70%) SQL Server Reporting Services
4 38 (9.45%) SQL Server Integration Services
5 36 (8.96%) Tableau
6 27 (6.72%) MS Access
7 20 (4.98%) Data Warehouse
8 16 (3.98%) Data Mining
8 16 (3.98%) Relational Database
9 11 (2.74%) QlikView
10 10 (2.49%) SQL Server 2016
10 10 (2.49%) SQL Server Analysis Services
11 9 (2.24%) Crystal Reports
11 9 (2.24%) Data Lake
12 8 (1.99%) MySQL
12 8 (1.99%) SQL Server 2012
13 6 (1.49%) BusinessObjects
14 4 (1.00%) ActiveReports
14 4 (1.00%) GIS
15 3 (0.75%) Azure SQL Database
Development Applications
1 21 (5.22%) Visual Studio
2 11 (2.74%) Git (software)
3 9 (2.24%) JIRA
3 9 (2.24%) WinAutomation
4 5 (1.24%) SQL Server Management Studio (SSMS)
5 2 (0.50%) Team Foundation Server
5 2 (0.50%) TeamCity
6 1 (0.25%) Artifactory
6 1 (0.25%) Atlassian Bamboo
6 1 (0.25%) Bitbucket
6 1 (0.25%) Eclipse
6 1 (0.25%) ERwin
6 1 (0.25%) GitLab
6 1 (0.25%) Gradle
6 1 (0.25%) Moq
6 1 (0.25%) NUnit
6 1 (0.25%) Subversion
6 1 (0.25%) Visual Studio Team System
General
1 142 (35.32%) Finance
2 104 (25.87%) Analytical Skills
3 103 (25.62%) Social Skills
4 42 (10.45%) Front Office
5 24 (5.97%) Banking
6 12 (2.99%) Presentation Skills
6 12 (2.99%) Retail
7 11 (2.74%) Marketing
8 10 (2.49%) Investment Banking
8 10 (2.49%) Law
9 6 (1.49%) Back Office
10 5 (1.24%) Korean Language
11 4 (1.00%) Aerospace
11 4 (1.00%) Manufacturing
11 4 (1.00%) Police
12 3 (0.75%) Automotive
12 3 (0.75%) Billing
12 3 (0.75%) Local Government
12 3 (0.75%) Pharmaceutical
12 3 (0.75%) Public Sector
Job Titles
1 140 (34.83%) Developer
2 132 (32.84%) Analyst
3 43 (10.70%) Applications Support
4 38 (9.45%) C# Developer
5 34 (8.46%) Data Analyst
6 29 (7.21%) SQL Developer
7 28 (6.97%) Applications Developer
8 23 (5.72%) Consultant
9 21 (5.22%) C# Application Developer
10 19 (4.73%) Senior Analyst
11 18 (4.48%) Robotic Process Automation Developer
11 18 (4.48%) Support Engineer
12 17 (4.23%) Applications Engineer
13 16 (3.98%) Applications Support Engineer
14 15 (3.73%) Business Intelligence Developer
15 14 (3.48%) Business Intelligence Analyst
15 14 (3.48%) Commercial Analyst
15 14 (3.48%) DBA
15 14 (3.48%) VBA Developer
16 13 (3.23%) Support Analyst
Libraries, Frameworks & Software Standards
1 101 (25.12%) .NET
2 29 (7.21%) HTML
3 19 (4.73%) CSS
4 12 (2.99%) ASP.NET
5 9 (2.24%) FIX Protocol
5 9 (2.24%) OpenCV
6 8 (1.99%) EDI
7 7 (1.74%) Pandas
7 7 (1.74%) XML
8 5 (1.24%) ASP.NET MVC
8 5 (1.24%) JSON
9 4 (1.00%) .NET Framework
9 4 (1.00%) AngularJS
9 4 (1.00%) ODBC
9 4 (1.00%) Web Services
10 3 (0.75%) .NET Core
10 3 (0.75%) ASP.NET Web API
10 3 (0.75%) jQuery
10 3 (0.75%) React
10 3 (0.75%) WPF
Miscellaneous
1 30 (7.46%) Management Information System
2 19 (4.73%) Derivative
3 16 (3.98%) Robotics
4 15 (3.73%) Data Structures
5 12 (2.99%) Hedge funds
5 12 (2.99%) Market Risk
6 11 (2.74%) Fixed Income
7 10 (2.49%) Self-Motivation
8 9 (2.24%) Credit Risk
9 8 (1.99%) Algorithms
9 8 (1.99%) Analytical Mindset
9 8 (1.99%) Foreign Exchange (FX)
10 6 (1.49%) AS400
10 6 (1.49%) Equities
11 5 (1.24%) NHS
11 5 (1.24%) SCADA
12 4 (1.00%) Learning Management System
12 4 (1.00%) SWIFT
13 3 (0.75%) FMCG
13 3 (0.75%) Renewable Energy
Operating Systems
1 37 (9.20%) Windows
2 32 (7.96%) Linux
3 10 (2.49%) Unix
3 10 (2.49%) Windows 10
4 4 (1.00%) Mac OS X
5 3 (0.75%) Windows Server
5 3 (0.75%) Windows Server 2016
6 2 (0.50%) Windows 7
7 1 (0.25%) Solaris
7 1 (0.25%) Windows Server 2008
Processes & Methodologies
1 107 (26.62%) Business Intelligence
2 90 (22.39%) Analytics
3 80 (19.90%) Problem-Solving
4 56 (13.93%) Project Management
5 45 (11.19%) Visualisation
6 43 (10.70%) Agile Software Development
6 43 (10.70%) Data Analysis
7 38 (9.45%) MVC
8 37 (9.20%) Asset Management
9 33 (8.21%) Business Analysis
9 33 (8.21%) Workflow
10 32 (7.96%) Computer Science
11 31 (7.71%) Data Analytics
12 30 (7.46%) Risk Management
13 28 (6.97%) Data Management
13 28 (6.97%) Decision-Making
14 26 (6.47%) Data Visualisation
14 26 (6.47%) IT Strategy
14 26 (6.47%) Statistics
15 24 (5.97%) ERP
Programming Languages
1 255 (63.43%) SQL
2 136 (33.83%) Python
3 131 (32.59%) C#
4 42 (10.45%) T-SQL
5 36 (8.96%) JavaScript
6 27 (6.72%) C++
6 27 (6.72%) Java
6 27 (6.72%) PowerShell
7 26 (6.47%) VB.NET
8 25 (6.22%) VB
9 23 (5.72%) MATLAB
10 22 (5.47%) R
11 20 (4.98%) Bash Shell
12 17 (4.23%) C
13 16 (3.98%) Perl
14 13 (3.23%) PHP
15 9 (2.24%) Data Analysis Expressions (DAX)
16 4 (1.00%) Shell Script
17 2 (0.50%) Delphi
17 2 (0.50%) VB6
Qualifications
1 71 (17.66%) Degree
2 21 (5.22%) Computer Science Degree
3 17 (4.23%) Numerate Degree
4 11 (2.74%) Security Cleared
5 7 (1.74%) Master's Degree
6 5 (1.24%) ACCA
6 5 (1.24%) CISA
6 5 (1.24%) CISM
6 5 (1.24%) CISSP
6 5 (1.24%) CRISC
7 4 (1.00%) CIMA
8 3 (0.75%) AAT
9 2 (0.50%) CFA
9 2 (0.50%) Microsoft Certification
9 2 (0.50%) SC Cleared
10 1 (0.25%) CBAP
10 1 (0.25%) CCAB
10 1 (0.25%) PhD
10 1 (0.25%) Postgraduate
Quality Assurance & Compliance
1 16 (3.98%) Data Quality
2 13 (3.23%) Solvency II
3 10 (2.49%) GDPR
4 8 (1.99%) Basel II
4 8 (1.99%) CRD IV
5 5 (1.24%) COSO
5 5 (1.24%) GRC
5 5 (1.24%) ISO/IEC 27001
5 5 (1.24%) NIST
5 5 (1.24%) NIST 800
5 5 (1.24%) QA
6 2 (0.50%) AIFMD
6 2 (0.50%) SLA
7 1 (0.25%) EMIR
7 1 (0.25%) IFRS
7 1 (0.25%) MiFID
System Software
1 8 (1.99%) Active Directory
2 3 (0.75%) Docker
2 3 (0.75%) Hyper-V
2 3 (0.75%) pfSense
2 3 (0.75%) VMware ESXi
3 1 (0.25%) Virtual Desktop
Systems Management
1 5 (1.24%) RSA Archer
2 2 (0.50%) Kubernetes
3 1 (0.25%) Control-M
3 1 (0.25%) Prometheus
Vendors
1 110 (27.36%) Microsoft
2 28 (6.97%) Sage
3 25 (6.22%) Oracle
4 17 (4.23%) SAP
5 12 (2.99%) Automation Anywhere
5 12 (2.99%) Splunk
6 11 (2.74%) Bloomberg
6 11 (2.74%) UiPath
7 9 (2.24%) Blue Prism
8 7 (1.74%) IBM
9 6 (1.49%) Alteryx
9 6 (1.49%) Kofax
9 6 (1.49%) Salesforce.com
10 5 (1.24%) Databricks
10 5 (1.24%) Google
11 4 (1.00%) Apple
11 4 (1.00%) ServiceNow
11 4 (1.00%) Teradata
11 4 (1.00%) Yardi
12 3 (0.75%) JD Edwards
73 VBA job vacancies Nationwide