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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
16 Jul 2020
Same period 2019 Same period 2018
Rank 416 403 383
Rank change year-on-year -13 -20 +9
Permanent jobs citing VBA 467 1,093 1,460
As % of all permanent jobs advertised in the UK 0.63% 0.75% 0.83%
As % of the Programming Languages category 1.13% 1.39% 1.48%
Number of salaries quoted 403 932 1,227
Median annual salary £47,500 £45,000 £44,000
Median salary % change year-on-year +5.56% +2.27% -2.22%
10th Percentile £30,000 £25,750 £26,250
90th Percentile £105,000 £80,000 £72,500
UK excluding London median annual salary £37,500 £34,500 £37,500
% change year-on-year +8.70% -8.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 41,505 78,431 98,445
As % of all permanent IT jobs advertised in the UK 55.80% 53.79% 55.93%
Number of salaries quoted 34,143 64,328 81,819
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £32,500 £31,250 £30,494
90th Percentile £90,000 £85,000 £80,000
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +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 16 July 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 16 July 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 -23 417 £50,000 +10.50% 27
London -23 258 £67,500 +17.60% 20
UK excluding London +23 196 £37,500 +8.70% 7
South East +76 46 £37,500 +13.64%
North of England +89 38 £25,000 -33.33% 3
East of England +67 36 £37,257 +6.45%
Wales +47 24 £35,000 -
Midlands +56 22 £36,000 +10.77% 4
Yorkshire +96 19 £25,000 -23.08%
North West +74 18 £32,500 -27.78% 3
West Midlands +69 17 £50,000 +53.85% 3
South West +51 14 £45,000 +38.46%
Work from Home +45 10 £45,000 - 3
Scotland +57 9 £55,000 +12.24%
Northern Ireland +28 7 £41,000 +9.33%
East Midlands +44 5 £33,000 -0.75% 1
North East +7 1 £57,500 +105.36%

For the 6 months to 16 July 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 326 (69.81%) SQL
2 307 (65.74%) Microsoft Excel
3 182 (38.97%) Finance
4 181 (38.76%) Microsoft
5 165 (35.33%) Python
6 133 (28.48%) C#
7 118 (25.27%) SQL Server
8 110 (23.55%) .NET
8 110 (23.55%) Analytical Skills
9 109 (23.34%) Agile Software Development
10 106 (22.70%) Analytics
11 83 (17.77%) Degree
12 80 (17.13%) Business Intelligence
13 76 (16.27%) Microsoft Office
14 75 (16.06%) Data Analysis
15 72 (15.42%) R
16 70 (14.99%) Front Office
17 65 (13.92%) Scrum
17 65 (13.92%) Power BI
17 65 (13.92%) Power Platform
18 61 (13.06%) Windows
19 60 (12.85%) Problem-Solving
19 60 (12.85%) Tableau
20 59 (12.63%) SQL Server Reporting Services
21 58 (12.42%) Java
22 57 (12.21%) Fixed Income
23 47 (10.06%) Migration
23 47 (10.06%) JavaScript
23 47 (10.06%) Data Warehouse
23 47 (10.06%) Business Analysis

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 21 (4.50%) Confluence
2 15 (3.21%) SharePoint
3 9 (1.93%) SAS
4 8 (1.71%) IIS
5 3 (0.64%) Elasticsearch
6 2 (0.43%) Apache Spark
7 1 (0.21%) Apache
7 1 (0.21%) ArcGIS
7 1 (0.21%) MS Exchange
7 1 (0.21%) Tomcat
Applications
1 307 (65.74%) Microsoft Excel
2 76 (16.27%) Microsoft Office
3 28 (6.00%) Microsoft PowerPoint
4 12 (2.57%) Spreadsheet
5 6 (1.28%) SPSS
6 4 (0.86%) MS Visio
7 2 (0.43%) Microsoft Project
7 2 (0.43%) Quantrix
8 1 (0.21%) AutoCAD
Business Applications
1 5 (1.07%) Cognos TM1
1 5 (1.07%) Dynamics CRM
2 4 (0.86%) Exchequer
2 4 (0.86%) Visualfiles
3 3 (0.64%) Dynamics AX
3 3 (0.64%) MIS ActiveH
3 3 (0.64%) NetSuite
4 2 (0.43%) Endur
4 2 (0.43%) Oracle Assets
4 2 (0.43%) Oracle Cash Management
4 2 (0.43%) Oracle EBS
4 2 (0.43%) Oracle EBS R12
4 2 (0.43%) Oracle Financials
4 2 (0.43%) Oracle General Ledger
4 2 (0.43%) Oracle Payables
4 2 (0.43%) Oracle Receivables
4 2 (0.43%) Raiser's Edge
4 2 (0.43%) SAP Business One
5 1 (0.21%) Primavera
5 1 (0.21%) SAP HR
Cloud Services
1 65 (13.92%) Power Platform
2 41 (8.78%) Azure
3 19 (4.07%) AWS
4 18 (3.85%) Office 365
5 12 (2.57%) GCP
5 12 (2.57%) SaaS
6 5 (1.07%) IaaS
6 5 (1.07%) PaaS
7 4 (0.86%) PowerApps
8 3 (0.64%) G Suite
8 3 (0.64%) Smartsheet
9 2 (0.43%) Azure Data Factory
9 2 (0.43%) GitHub
9 2 (0.43%) Google Analytics
9 2 (0.43%) Google Tag Manager
10 1 (0.21%) Dynamics 365
10 1 (0.21%) Power Automate
10 1 (0.21%) ServiceMax
10 1 (0.21%) SurveyMonkey
Communications & Networking
1 10 (2.14%) DNS
2 9 (1.93%) Cisco IOS
2 9 (1.93%) TCP/IP
3 8 (1.71%) DHCP
4 7 (1.50%) LAN
4 7 (1.50%) WAN
5 5 (1.07%) Skype
5 5 (1.07%) SSL
5 5 (1.07%) tcpdump
5 5 (1.07%) Wireshark
6 4 (0.86%) Radio Access Network
7 3 (0.64%) 2G
7 3 (0.64%) 3G
7 3 (0.64%) 4G
7 3 (0.64%) 5G
7 3 (0.64%) Firewall
7 3 (0.64%) UTRAN
8 2 (0.43%) HTTP
8 2 (0.43%) Internet
8 2 (0.43%) SMTP
Database & Business Intelligence
1 118 (25.27%) SQL Server
2 65 (13.92%) Power BI
3 59 (12.63%) SQL Server Reporting Services
4 47 (10.06%) Data Warehouse
5 44 (9.42%) MS Access
6 42 (8.99%) SQL Server Integration Services
7 33 (7.07%) MySQL
8 20 (4.28%) BusinessObjects
8 20 (4.28%) Relational Database
9 19 (4.07%) SQL Server Analysis Services
10 15 (3.21%) Hadoop
10 15 (3.21%) Qlik Sense
11 13 (2.78%) Crystal Reports
11 13 (2.78%) QlikView
12 12 (2.57%) NoSQL
13 10 (2.14%) RDBMS
14 8 (1.71%) Data Lake
15 7 (1.50%) Data Mining
16 6 (1.28%) SQL Server 2008
16 6 (1.28%) SQL Server 2012
Development Applications
1 19 (4.07%) JIRA
2 16 (3.43%) Subversion
3 10 (2.14%) Eclipse
4 9 (1.93%) Git (software)
5 7 (1.50%) Jenkins
5 7 (1.50%) Visual Studio
6 6 (1.28%) SQL Server Management Studio (SSMS)
7 5 (1.07%) IBM UrbanCode
8 4 (0.86%) GCC
9 3 (0.64%) LSMW
10 2 (0.43%) Oracle APEX
10 2 (0.43%) Team Foundation Server
10 2 (0.43%) Toad
11 1 (0.21%) Moq
11 1 (0.21%) TeamCity
11 1 (0.21%) tSQLt
11 1 (0.21%) Visual Studio Tools for Office
11 1 (0.21%) Xcode
General
1 182 (38.97%) Finance
2 70 (14.99%) Front Office
3 29 (6.21%) Retail
3 29 (6.21%) Telecoms
4 22 (4.71%) Back Office
4 22 (4.71%) Banking
5 20 (4.28%) Legal
6 16 (3.43%) Advertising
7 11 (2.36%) Marketing
7 11 (2.36%) Public Sector
8 7 (1.50%) Law
8 7 (1.50%) Manufacturing
9 4 (0.86%) Police
10 3 (0.64%) Billing
11 2 (0.43%) Financial Institution
11 2 (0.43%) German Language
11 2 (0.43%) Investment Banking
11 2 (0.43%) Publishing
12 1 (0.21%) Aerospace
12 1 (0.21%) Electronics
Job Titles
1 183 (39.19%) Analyst
2 159 (34.05%) Developer
3 39 (8.35%) Support Analyst
4 34 (7.28%) Analytics Manager
5 30 (6.42%) Finance Manager
5 30 (6.42%) Software Developer
6 29 (6.21%) Data Analyst
7 26 (5.57%) Financial Analyst
8 25 (5.35%) C# Developer
9 23 (4.93%) Senior Analyst
10 22 (4.71%) SQL Developer
11 20 (4.28%) Head of Analytics
11 20 (4.28%) Head of Finance
12 19 (4.07%) Business Analyst
12 19 (4.07%) Python Developer
13 18 (3.85%) Database Developer
13 18 (3.85%) Senior Developer
14 17 (3.64%) IT Support
15 16 (3.43%) Applications Support
15 16 (3.43%) Junior
Libraries, Frameworks & Software Standards
1 110 (23.55%) .NET
2 40 (8.57%) ASP.NET
3 39 (8.35%) HTML
4 38 (8.14%) XML
5 34 (7.28%) Web Services
6 27 (5.78%) WCF
7 22 (4.71%) AngularJS
8 21 (4.50%) React
9 15 (3.21%) WPF
10 12 (2.57%) CSS
10 12 (2.57%) Node.js
10 12 (2.57%) REST
11 10 (2.14%) .NET Framework
11 10 (2.14%) SOAP
12 8 (1.71%) Apache Flex
13 6 (1.28%) HTML5
13 6 (1.28%) SignalR
13 6 (1.28%) Velocity
14 5 (1.07%) Pandas
14 5 (1.07%) Twitter Bootstrap
Miscellaneous
1 110 (23.55%) Analytical Skills
2 57 (12.21%) Fixed Income
3 47 (10.06%) Derivative
4 38 (8.14%) Hedge funds
5 36 (7.71%) OTC Derivatives
6 35 (7.49%) Management Information System
7 25 (5.35%) User Experience
8 13 (2.78%) Foreign Exchange (FX)
8 13 (2.78%) Robotics
9 12 (2.57%) Greenfield Project
10 9 (1.93%) Video Conferencing
11 7 (1.50%) FMCG
11 7 (1.50%) Market Risk
12 6 (1.28%) Equities
12 6 (1.28%) Self-Motivation
13 5 (1.07%) Credit Risk
13 5 (1.07%) Data Structures
14 4 (0.86%) SWIFT
15 3 (0.64%) Analytical Mindset
15 3 (0.64%) Virtual Team
Operating Systems
1 61 (13.06%) Windows
2 32 (6.85%) Linux
3 14 (3.00%) Unix
3 14 (3.00%) Windows Server
4 8 (1.71%) Windows 10
4 8 (1.71%) Windows 7
5 3 (0.64%) Windows Server 2012
6 1 (0.21%) Apple iOS
6 1 (0.21%) Solaris
6 1 (0.21%) Windows Server 2008
6 1 (0.21%) Windows Server 2016
Processes & Methodologies
1 109 (23.34%) Agile Software Development
2 106 (22.70%) Analytics
3 80 (17.13%) Business Intelligence
4 75 (16.06%) Data Analysis
5 65 (13.92%) Scrum
6 60 (12.85%) Problem-Solving
7 47 (10.06%) Business Analysis
7 47 (10.06%) Mentoring
7 47 (10.06%) Migration
8 46 (9.85%) Investment Management
9 38 (8.14%) Asset Management
9 38 (8.14%) Computer Science
10 36 (7.71%) Performance Attribution
10 36 (7.71%) Risk Analysis
11 35 (7.49%) Fund Management
11 35 (7.49%) Software Engineering
12 34 (7.28%) Data Analytics
13 32 (6.85%) Software Architecture
14 30 (6.42%) Visualisation
15 29 (6.21%) Test Automation
Programming Languages
1 326 (69.81%) SQL
2 165 (35.33%) Python
3 133 (28.48%) C#
4 72 (15.42%) R
5 58 (12.42%) Java
6 47 (10.06%) JavaScript
7 46 (9.85%) VB
8 39 (8.35%) T-SQL
9 38 (8.14%) MATLAB
10 36 (7.71%) PHP
11 29 (6.21%) PowerShell
12 27 (5.78%) C++
13 18 (3.85%) VBScript
14 17 (3.64%) VB.NET
15 12 (2.57%) TypeScript
16 8 (1.71%) C
17 7 (1.50%) Data Analysis Expressions (DAX)
17 7 (1.50%) PL/SQL
18 5 (1.07%) Perl
18 5 (1.07%) XAML
Qualifications
1 83 (17.77%) Degree
2 10 (2.14%) SC Cleared
2 10 (2.14%) Security Cleared
3 9 (1.93%) Computer Science Degree
4 6 (1.28%) ISEB
5 5 (1.07%) ACCA
5 5 (1.07%) CIMA
5 5 (1.07%) DV Cleared
5 5 (1.07%) HNC
5 5 (1.07%) HND
6 4 (0.86%) A+ Certification
6 4 (0.86%) Numerate Degree
7 3 (0.64%) Microsoft Certification
8 2 (0.43%) PhD
8 2 (0.43%) PMI Certification
8 2 (0.43%) PMP
9 1 (0.21%) CCAB
9 1 (0.21%) CFA
9 1 (0.21%) ICAEW
9 1 (0.21%) SAS Certification
Quality Assurance & Compliance
1 13 (2.78%) QA
2 8 (1.71%) Data Quality
3 5 (1.07%) SLA
4 3 (0.64%) Sarbanes-Oxley
5 2 (0.43%) Basel II
5 2 (0.43%) Basel III
6 1 (0.21%) EMIR
6 1 (0.21%) IFRS
6 1 (0.21%) IFRS 9
6 1 (0.21%) PMO
System Software
1 17 (3.64%) Active Directory
2 5 (1.07%) Tivoli Workload Scheduler
3 2 (0.43%) XenApp
4 1 (0.21%) Cronacle
4 1 (0.21%) VMware Infrastructure
Systems Management
1 12 (2.57%) SCCM
2 5 (1.07%) Tivoli
3 3 (0.64%) Kibana
4 2 (0.43%) Oracle Enterprise Manager
5 1 (0.21%) Control-M
5 1 (0.21%) EnCase
5 1 (0.21%) FTK
Vendors
1 181 (38.76%) Microsoft
2 60 (12.85%) Tableau
3 46 (9.85%) Bloomberg
4 38 (8.14%) Oracle
5 19 (4.07%) Avaya
6 18 (3.85%) Blue Prism
7 17 (3.64%) SAP
8 16 (3.43%) UiPath
9 15 (3.21%) Google
10 14 (3.00%) IBM
11 13 (2.78%) Automation Anywhere
12 10 (2.14%) Apple
12 10 (2.14%) Reuters
13 9 (1.93%) Cisco
13 9 (1.93%) Citrix
14 8 (1.71%) Hyperion
15 7 (1.50%) Anaplan
15 7 (1.50%) DevExpress
15 7 (1.50%) HP
15 7 (1.50%) Sybase