Job Vacancy Trend Salary Trend Salary Histogram Job Locations Skill Sets
Period
to 30 July 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 30 July 2021 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
30 Jul 2021		 Same period 2020 Same period 2019
Rank 521 424 419
Rank change year-on-year -97 -5 -34
Permanent jobs citing VBA 560 423 1,071
As % of all permanent jobs advertised in the UK 0.49% 0.62% 0.74%
As % of the Programming Languages category 0.90% 1.10% 1.39%
Number of salaries quoted 369 357 911
10th Percentile £30,925 £30,350 £26,250
25th Percentile £37,500 £35,000 £32,500
Median annual salary (50th Percentile) £51,000 £50,000 £47,500
Median % change year-on-year +2.00% +5.26% +5.56%
75th Percentile £63,750 £75,000 £62,500
90th Percentile £105,250 £111,000 £78,750
UK excluding London median annual salary £41,375 £37,500 £35,000
% change year-on-year +10.33% +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 62,465 38,629 77,273
As % of all permanent IT jobs advertised in the UK 54.99% 56.31% 53.68%
Number of salaries quoted 43,046 32,068 63,983
10th Percentile £35,000 £32,500 £31,250
25th Percentile £42,500 £41,250 £37,750
Median annual salary (50th Percentile) £57,500 £55,000 £52,500
Median % change year-on-year +4.55% +4.76% +5.00%
75th Percentile £76,250 £73,750 £70,000
90th Percentile £93,750 £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 30 July 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 30 July 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 -78 523 £52,500 +5.00% 106
UK excluding London -51 288 £41,375 +10.33% 59
London -126 246 £60,000 -14.29% 49
Work from Home -184 83 £40,175 -10.72% 7
North of England -24 76 £39,250 +42.73% 9
Midlands -19 75 £40,000 +15.94% 21
East of England -2 71 £55,000 +57.14% 4
West Midlands -39 51 £40,000 +3.23% 17
South East -93 38 £35,000 -6.67% 16
North West -23 34 £40,750 +1.88% 8
Yorkshire -50 33 £40,000 +60.00% 1
East Midlands -31 24 £35,000 +1.45% 4
Scotland -68 13 £45,000 -18.18% 2
South West -77 12 £54,500 +57.91% 7
North East -12 9 £30,000 -31.62%
Wales -48 3 £40,000 +14.29%

For the 6 months to 30 July 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 364 (65.00%) SQL
2 298 (53.21%) Microsoft Excel
3 191 (34.11%) Finance
4 184 (32.86%) Python
5 173 (30.89%) C#
6 163 (29.11%) Analytical Skills
7 159 (28.39%) Microsoft
8 152 (27.14%) Business Intelligence
9 146 (26.07%) .NET
10 130 (23.21%) SQL Server
11 129 (23.04%) Analytics
12 127 (22.68%) Power Platform
13 125 (22.32%) Power BI
14 123 (21.96%) Social Skills
15 102 (18.21%) Degree
16 100 (17.86%) Problem-Solving
17 95 (16.96%) Agile Software Development
18 88 (15.71%) Microsoft Office
19 85 (15.18%) SQL Server Integration Services
20 74 (13.21%) Visualisation
21 73 (13.04%) SQL Server Reporting Services
22 62 (11.07%) T-SQL
22 62 (11.07%) Mathematics
23 61 (10.89%) SharePoint
23 61 (10.89%) Management Information System
24 57 (10.18%) Decision-Making
25 56 (10.00%) Tableau
25 56 (10.00%) Continuous Improvement
25 56 (10.00%) Azure
26 55 (9.82%) Project Management

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 61 (10.89%) SharePoint
2 22 (3.93%) SAS
3 13 (2.32%) IIS
4 3 (0.54%) Jetty
5 2 (0.36%) ArcGIS
5 2 (0.36%) ArcSDE
6 1 (0.18%) Confluence
6 1 (0.18%) Elasticsearch
6 1 (0.18%) MQSeries
6 1 (0.18%) MTS
6 1 (0.18%) NetWeaver
6 1 (0.18%) WordPress
Applications
1 298 (53.21%) Microsoft Excel
2 88 (15.71%) Microsoft Office
3 20 (3.57%) MS Visio
4 16 (2.86%) Spreadsheet
5 13 (2.32%) SPSS
6 12 (2.14%) Microsoft PowerPoint
7 7 (1.25%) Simulink
8 4 (0.71%) InfoPath
9 2 (0.36%) Microsoft Project
9 2 (0.36%) ProjectWise
10 1 (0.18%) Stata
Business Applications
1 18 (3.21%) IBM Planning Analytics
2 6 (1.07%) NetSuite
3 5 (0.89%) SAP ERP
4 3 (0.54%) Findur
4 3 (0.54%) Maximo
5 2 (0.36%) Dynamics CRM
5 2 (0.36%) Dynamics GP
5 2 (0.36%) Elite 3E
5 2 (0.36%) HFM
5 2 (0.36%) iTrent
5 2 (0.36%) Oracle EBS
5 2 (0.36%) SAP Business One
6 1 (0.18%) Aareon QL
6 1 (0.18%) Dynamics NAV
6 1 (0.18%) Markit EDM
6 1 (0.18%) Oracle Cash Management
6 1 (0.18%) Oracle Subledger Accounting
6 1 (0.18%) Orchestrade
6 1 (0.18%) SAP BPC
6 1 (0.18%) Sentinel
Cloud Services
1 127 (22.68%) Power Platform
2 56 (10.00%) Azure
3 26 (4.64%) Microsoft 365
4 24 (4.29%) AWS
5 15 (2.68%) PowerApps
6 12 (2.14%) ServiceMax
7 11 (1.96%) Power Automate
8 10 (1.79%) GCP
9 8 (1.43%) Dynamics 365
9 8 (1.43%) GitHub
10 7 (1.25%) SaaS
11 3 (0.54%) Heroku
11 3 (0.54%) Snowflake
12 2 (0.36%) Azure App Service
12 2 (0.36%) Azure Data Factory
13 1 (0.18%) Adobe Analytics
13 1 (0.18%) Amazon CloudSearch
13 1 (0.18%) Azure Synapse Analytics
13 1 (0.18%) Google Workspace
13 1 (0.18%) IaaS
Communications & Networking
1 17 (3.04%) Firewall
2 16 (2.86%) FTP
3 11 (1.96%) Intranet
4 7 (1.25%) Wi-Fi
5 3 (0.54%) Cisco IOS
5 3 (0.54%) DHCP
5 3 (0.54%) DNS
5 3 (0.54%) PuTTY
5 3 (0.54%) VLAN
5 3 (0.54%) WinSCP
6 2 (0.36%) SMS
7 1 (0.18%) Broadband
7 1 (0.18%) HTTP
7 1 (0.18%) SWIFTNet
Database & Business Intelligence
1 130 (23.21%) SQL Server
2 125 (22.32%) Power BI
3 85 (15.18%) SQL Server Integration Services
4 73 (13.04%) SQL Server Reporting Services
5 56 (10.00%) Tableau
6 37 (6.61%) Relational Database
7 35 (6.25%) SQL Server Analysis Services
8 33 (5.89%) Data Mining
9 32 (5.71%) MS Access
10 28 (5.00%) Data Warehouse
11 25 (4.46%) Big Data
12 21 (3.75%) MySQL
13 16 (2.86%) DB2
14 15 (2.68%) RDBMS
15 10 (1.79%) SQL Server 2012
15 10 (1.79%) SQL Server 2019
16 9 (1.61%) BigQuery
16 9 (1.61%) BusinessObjects
17 8 (1.43%) SQL Server 2016
18 7 (1.25%) Metadata
Development Applications
1 28 (5.00%) JIRA
2 24 (4.29%) Visual Studio
3 18 (3.21%) Git (software)
4 9 (1.61%) Subversion
5 7 (1.25%) Team Foundation Server
6 6 (1.07%) SQL Server Management Studio (SSMS)
6 6 (1.07%) WinAutomation
7 4 (0.71%) TeamCity
8 3 (0.54%) Artifactory
8 3 (0.54%) Gradle
8 3 (0.54%) Moq
8 3 (0.54%) NUnit
9 2 (0.36%) Atlassian Bamboo
9 2 (0.36%) Gerrit
9 2 (0.36%) MSTest
9 2 (0.36%) Octopus Deploy
9 2 (0.36%) xUnit.net
10 1 (0.18%) Eclipse
10 1 (0.18%) ERwin
10 1 (0.18%) Visual Studio Team System
General
1 191 (34.11%) Finance
2 163 (29.11%) Analytical Skills
3 123 (21.96%) Social Skills
4 44 (7.86%) Banking
5 32 (5.71%) Front Office
6 24 (4.29%) Back Office
6 24 (4.29%) Pharmaceutical
7 22 (3.93%) Retail
8 20 (3.57%) Investment Banking
9 19 (3.39%) Inclusion and Diversity
10 11 (1.96%) Games
10 11 (1.96%) Marketing
11 10 (1.79%) Manufacturing
11 10 (1.79%) Publishing
12 9 (1.61%) Documentation Skills
12 9 (1.61%) Financial Institution
12 9 (1.61%) Organisational Skills
13 8 (1.43%) French Language
13 8 (1.43%) German Language
13 8 (1.43%) Italian Language
Job Titles
1 228 (40.71%) Analyst
2 165 (29.46%) Developer
3 68 (12.14%) Data Analyst
4 42 (7.50%) SQL Developer
5 38 (6.79%) Applications Support
6 37 (6.61%) C# Developer
7 27 (4.82%) Support Analyst
8 22 (3.93%) Applications Support Analyst
8 22 (3.93%) Junior
9 21 (3.75%) Consultant
10 20 (3.57%) Senior Analyst
10 20 (3.57%) VBA Developer
11 17 (3.04%) Business Intelligence Analyst
11 17 (3.04%) Senior Developer
12 16 (2.86%) Qualitative Analyst
12 16 (2.86%) Quantitative Analyst
12 16 (2.86%) Quantitative Developer
13 15 (2.68%) Data Manager
13 15 (2.68%) SQL Analyst
13 15 (2.68%) Technical Analyst
Libraries, Frameworks & Software Standards
1 146 (26.07%) .NET
2 43 (7.68%) HTML
3 34 (6.07%) CSS
4 26 (4.64%) JSON
5 25 (4.46%) ASP.NET
6 20 (3.57%) .NET Framework
7 16 (2.86%) Kafka
8 14 (2.50%) .NET Core
9 12 (2.14%) Ajax
10 10 (1.79%) EDI
10 10 (1.79%) XML
11 9 (1.61%) jQuery
11 9 (1.61%) Razor View Engine
12 8 (1.43%) ASP.NET Web API
12 8 (1.43%) RESTful
13 7 (1.25%) ADO
13 7 (1.25%) OpenCV
13 7 (1.25%) Pandas
13 7 (1.25%) RabbitMQ
13 7 (1.25%) Web Services
Miscellaneous
1 61 (10.89%) Management Information System
2 33 (5.89%) Derivative
3 23 (4.11%) Foreign Exchange (FX)
4 22 (3.93%) Equities
5 20 (3.57%) Self-Motivation
5 20 (3.57%) Social Media
6 16 (2.86%) Algorithms
7 15 (2.68%) Life Science
8 13 (2.32%) Fixed Income
8 13 (2.32%) Reference Data
9 12 (2.14%) Analytical Mindset
9 12 (2.14%) Market Risk
9 12 (2.14%) Robotics
10 10 (1.79%) Data Structures
11 9 (1.61%) Legacy Systems
12 8 (1.43%) Credit Derivative
12 8 (1.43%) FMCG
13 7 (1.25%) Credit Risk
14 6 (1.07%) AS400
15 5 (0.89%) CMDB
Operating Systems
1 44 (7.86%) Windows
2 28 (5.00%) Linux
3 11 (1.96%) Unix
4 10 (1.79%) Windows 10
5 5 (0.89%) Windows Server
6 4 (0.71%) Windows 7
7 3 (0.54%) Mac OS X
8 2 (0.36%) Android
8 2 (0.36%) Windows Server 2012
9 1 (0.18%) Solaris
Processes & Methodologies
1 152 (27.14%) Business Intelligence
2 129 (23.04%) Analytics
3 100 (17.86%) Problem-Solving
4 95 (16.96%) Agile Software Development
5 74 (13.21%) Visualisation
6 62 (11.07%) Mathematics
7 57 (10.18%) Decision-Making
8 56 (10.00%) Continuous Improvement
9 55 (9.82%) Project Management
10 54 (9.64%) Computer Science
11 52 (9.29%) ETL
12 51 (9.11%) Statistics
13 50 (8.93%) Risk Management
14 49 (8.75%) Data Management
14 49 (8.75%) Data Visualisation
14 49 (8.75%) MVC
15 47 (8.39%) DevOps
16 41 (7.32%) Data Modelling
17 40 (7.14%) Data Analysis
18 39 (6.96%) Data Science
Programming Languages
1 364 (65.00%) SQL
2 184 (32.86%) Python
3 173 (30.89%) C#
4 62 (11.07%) T-SQL
5 52 (9.29%) JavaScript
6 48 (8.57%) C++
6 48 (8.57%) PowerShell
7 46 (8.21%) Java
8 40 (7.14%) R
9 33 (5.89%) VB.NET
10 30 (5.36%) MATLAB
11 29 (5.18%) C
12 20 (3.57%) Perl
12 20 (3.57%) VB
13 17 (3.04%) Bash Shell
14 15 (2.68%) Data Analysis Expressions (DAX)
15 14 (2.50%) PHP
16 8 (1.43%) TypeScript
17 6 (1.07%) Groovy
18 4 (0.71%) PL/SQL
Qualifications
1 102 (18.21%) Degree
2 30 (5.36%) Numerate Degree
3 12 (2.14%) Computer Science Degree
4 9 (1.61%) Security Cleared
5 8 (1.43%) Master's Degree
6 5 (0.89%) CISA
6 5 (0.89%) CISM
6 5 (0.89%) CISSP
6 5 (0.89%) CRISC
6 5 (0.89%) Microsoft Certification
7 4 (0.71%) ACCA
8 3 (0.54%) CIMA
9 2 (0.36%) AAT
9 2 (0.36%) CFA
9 2 (0.36%) SC Cleared
10 1 (0.18%) CBAP
10 1 (0.18%) DBS Check
10 1 (0.18%) DV Cleared
10 1 (0.18%) PhD
10 1 (0.18%) Postgraduate
Quality Assurance & Compliance
1 40 (7.14%) Data Quality
2 21 (3.75%) GDPR
3 15 (2.68%) QA
4 13 (2.32%) Solvency II
5 9 (1.61%) Basel II
5 9 (1.61%) CRD IV
6 5 (0.89%) COSO
6 5 (0.89%) GRC
6 5 (0.89%) ISO/IEC 27001
6 5 (0.89%) NIST
6 5 (0.89%) NIST 800
7 4 (0.71%) IFRS
8 3 (0.54%) MiFID
8 3 (0.54%) SLA
9 2 (0.36%) AIFMD
9 2 (0.36%) EMIR
9 2 (0.36%) GLP
9 2 (0.36%) GMP
9 2 (0.36%) Good Clinical Practice
9 2 (0.36%) IFRS 9
System Software
1 20 (3.57%) Docker
2 8 (1.43%) Active Directory
3 1 (0.18%) Virtual Desktop
Systems Management
1 10 (1.79%) Kubernetes
2 5 (0.89%) Prometheus
2 5 (0.89%) RSA Archer
3 1 (0.18%) Control-M
3 1 (0.18%) Microsoft Intune
Vendors
1 159 (28.39%) Microsoft
2 35 (6.25%) SAP
3 30 (5.36%) Oracle
3 30 (5.36%) Sage
4 21 (3.75%) IBM
5 20 (3.57%) Salesforce.com
6 19 (3.39%) Facebook
6 19 (3.39%) Instagram
7 14 (2.50%) Alteryx
7 14 (2.50%) Fidessa
8 13 (2.32%) Google
9 12 (2.14%) GoldenSource
9 12 (2.14%) Splunk
10 9 (1.61%) Bloomberg
11 7 (1.25%) Automation Anywhere
11 7 (1.25%) QAD
11 7 (1.25%) Refinitiv
12 6 (1.07%) Blue Prism
12 6 (1.07%) UiPath
13 5 (0.89%) Cognos
111 VBA job vacancies Nationwide