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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
26 Nov 2021		 Same period 2020 Same period 2019
Rank 486 498 459
Rank change year-on-year +12 -39 -19
Permanent jobs citing VBA 750 229 872
As % of all permanent jobs advertised in the UK 0.58% 0.42% 0.64%
As % of the Programming Languages category 1.09% 0.71% 1.19%
Number of salaries quoted 406 190 751
10th Percentile £30,500 £26,950 £29,750
25th Percentile £35,000 £35,000 £36,250
Median annual salary (50th Percentile) £45,000 £47,500 £50,000
Median % change year-on-year -5.26% -5.00% +11.11%
75th Percentile £62,188 £85,000 £65,000
90th Percentile £77,500 £110,000 £76,250
UK excluding London median annual salary £40,000 £36,525 £39,000
% change year-on-year +9.51% -6.35% +4.00%

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 69,079 32,105 73,085
As % of all permanent IT jobs advertised in the UK 53.30% 59.06% 53.79%
Number of salaries quoted 46,250 27,661 60,814
10th Percentile £36,250 £33,750 £31,250
25th Percentile £45,000 £42,500 £38,750
Median annual salary (50th Percentile) £60,000 £55,000 £52,500
Median % change year-on-year +9.09% +4.76% +5.00%
75th Percentile £80,000 £73,750 £71,250
90th Percentile £97,500 £90,000 £87,500
UK excluding London median annual salary £50,000 £50,000 £45,000
% change year-on-year - +11.11% -

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 26 November 2021.

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 26 November 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 +14 705 £45,000 -9.09% 102
UK excluding London +55 477 £40,000 +9.51% 53
London -129 232 £57,500 -28.13% 51
East of England +20 157 £55,000 +33.33% 9
North of England +1 155 £40,000 +14.29% 16
Yorkshire -14 84 £38,500 -28.70% 5
Midlands -46 83 £35,000 +16.67% 10
Work from Home -205 74 £39,500 -14.59% 10
North West -39 60 £40,000 +45.45% 10
South East -122 56 £45,000 +13.21% 10
West Midlands -42 55 £32,500 +8.33% 6
East Midlands -53 28 £41,500 +38.33% 4
South West -73 22 £47,500 +37.63% 6
North East -19 11 £29,000 +6.91% 1
Channel Islands - 6 £78,750 - 1
Scotland -68 3 £33,750 -3.57% 1
Wales -50 1 £37,500 -10.71%

For the 6 months to 26 November 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 579 (77.20%) SQL
2 391 (52.13%) Microsoft Excel
3 322 (42.93%) Analytical Skills
4 270 (36.00%) Social Skills
5 257 (34.27%) Analytics
6 235 (31.33%) Business Intelligence
7 221 (29.47%) Finance
8 184 (24.53%) Microsoft
9 179 (23.87%) Python
10 175 (23.33%) Power Platform
11 172 (22.93%) Problem-Solving
12 169 (22.53%) Power BI
13 168 (22.40%) C#
14 161 (21.47%) Logistics
15 159 (21.20%) SQL Server
16 158 (21.07%) Data Analysis
17 148 (19.73%) Agile Software Development
18 145 (19.33%) Retail
19 144 (19.20%) .NET
20 122 (16.27%) Organisational Skills
21 110 (14.67%) Visualisation
22 109 (14.53%) Degree
23 108 (14.40%) SQL Server Integration Services
24 94 (12.53%) SQL Server Reporting Services
25 89 (11.87%) Microsoft Office
26 83 (11.07%) Data Science
27 81 (10.80%) JavaScript
28 79 (10.53%) T-SQL
28 79 (10.53%) ETL
29 76 (10.13%) Mathematics

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 (8.13%) SharePoint
2 29 (3.87%) SAS
3 13 (1.73%) IIS
4 7 (0.93%) SharePoint 2013
5 2 (0.27%) Apache Spark
5 2 (0.27%) Confluence
5 2 (0.27%) WordPress
6 1 (0.13%) Apache
6 1 (0.13%) Apache Airflow
6 1 (0.13%) Elasticsearch
6 1 (0.13%) Jetty
6 1 (0.13%) NetWeaver
6 1 (0.13%) NServiceBus
Applications
1 391 (52.13%) Microsoft Excel
2 89 (11.87%) Microsoft Office
3 23 (3.07%) Microsoft PowerPoint
4 19 (2.53%) Spreadsheet
5 13 (1.73%) SPSS
6 4 (0.53%) Simulink
7 3 (0.40%) MS Visio
8 2 (0.27%) InfoPath
8 2 (0.27%) Microsoft Project
9 1 (0.13%) Stata
Business Applications
1 16 (2.13%) IBM Planning Analytics
2 12 (1.60%) Oracle EBS
3 6 (0.80%) SAP Business One
4 5 (0.67%) SAP ERP
5 4 (0.53%) Dynamics CRM
5 4 (0.53%) Maximo
5 4 (0.53%) SAP S/4HANA
6 3 (0.40%) NetSuite
6 3 (0.40%) Oracle Financials
6 3 (0.40%) SAP BPC
6 3 (0.40%) Teamcenter
7 2 (0.27%) Line 50
7 2 (0.27%) Oracle Subledger Accounting
7 2 (0.27%) SAP CO
7 2 (0.27%) SAP FI
7 2 (0.27%) SAP FI/CO
7 2 (0.27%) Visualfiles
8 1 (0.13%) Alphatax
8 1 (0.13%) Oracle Applications
8 1 (0.13%) Oracle ERP
Cloud Services
1 175 (23.33%) Power Platform
2 70 (9.33%) Azure
3 32 (4.27%) AWS
4 31 (4.13%) Google Sheets
5 24 (3.20%) Power Automate
5 24 (3.20%) PowerApps
6 19 (2.53%) GitHub
7 18 (2.40%) Microsoft 365
8 14 (1.87%) GCP
9 10 (1.33%) Heroku
9 10 (1.33%) ServiceMax
10 8 (1.07%) Snowflake
11 6 (0.80%) SaaS
12 5 (0.67%) Cloud Computing
12 5 (0.67%) Dynamics 365
12 5 (0.67%) IaaS
12 5 (0.67%) PaaS
13 3 (0.40%) Azure Data Factory
14 2 (0.27%) Azure App Service
14 2 (0.27%) OpenShift
Communications & Networking
1 13 (1.73%) Intranet
2 9 (1.20%) FTP
3 4 (0.53%) Firewall
4 3 (0.40%) Cisco IOS
4 3 (0.40%) PuTTY
4 3 (0.40%) WinSCP
5 2 (0.27%) Broadband
5 2 (0.27%) DNS
5 2 (0.27%) DSL
5 2 (0.27%) SMS
5 2 (0.27%) TCP/IP
5 2 (0.27%) VoIP
6 1 (0.13%) HTTP
6 1 (0.13%) Kerberos
6 1 (0.13%) VPN
Database & Business Intelligence
1 169 (22.53%) Power BI
2 159 (21.20%) SQL Server
3 108 (14.40%) SQL Server Integration Services
4 94 (12.53%) SQL Server Reporting Services
5 57 (7.60%) Tableau
6 51 (6.80%) SQL Server Analysis Services
7 40 (5.33%) MS Access
8 38 (5.07%) Relational Database
9 34 (4.53%) Big Data
9 34 (4.53%) Data Warehouse
10 32 (4.27%) Data Mining
11 26 (3.47%) MySQL
12 21 (2.80%) BusinessObjects
13 18 (2.40%) DB2
14 16 (2.13%) BigQuery
14 16 (2.13%) SQL Server 2019
15 15 (2.00%) RDBMS
15 15 (2.00%) SQL Server 2014
16 14 (1.87%) Oracle Reports
17 12 (1.60%) Crystal Reports
Development Applications
1 41 (5.47%) Git (software)
2 35 (4.67%) JIRA
3 17 (2.27%) Team Foundation Server
4 16 (2.13%) Visual Studio
5 14 (1.87%) SQL Server Management Studio (SSMS)
5 14 (1.87%) Toad
6 11 (1.47%) Subversion
7 10 (1.33%) TeamCity
8 6 (0.80%) ERwin
8 6 (0.80%) NUnit
9 4 (0.53%) tSQLt
9 4 (0.53%) Visual Studio Team System
10 3 (0.40%) Octopus Deploy
11 2 (0.27%) Atlassian Bamboo
11 2 (0.27%) Bitbucket
11 2 (0.27%) Gerrit
11 2 (0.27%) LabVIEW
11 2 (0.27%) Moq
11 2 (0.27%) MSTest
11 2 (0.27%) xUnit.net
General
1 322 (42.93%) Analytical Skills
2 270 (36.00%) Social Skills
3 221 (29.47%) Finance
4 145 (19.33%) Retail
5 122 (16.27%) Organisational Skills
6 44 (5.87%) Games
7 32 (4.27%) Pharmaceutical
8 30 (4.00%) Legal
9 29 (3.87%) Banking
10 24 (3.20%) Back Office
11 21 (2.80%) Manufacturing
12 20 (2.67%) Front Office
13 19 (2.53%) Presentation Skills
14 18 (2.40%) Marketing
15 16 (2.13%) Inclusion and Diversity
16 14 (1.87%) Advertising
17 12 (1.60%) Investment Banking
18 10 (1.33%) Law
18 10 (1.33%) Publishing
19 9 (1.20%) Influencing Skills
Job Titles
1 284 (37.87%) Analyst
2 178 (23.73%) Developer
3 83 (11.07%) Analytics Manager
4 82 (10.93%) Data Analyst
5 64 (8.53%) Planning Manager
6 41 (5.47%) Support Analyst
7 37 (4.93%) Process Analyst
7 37 (4.93%) SQL Developer
8 34 (4.53%) Applications Support
9 32 (4.27%) Applications Support Analyst
10 30 (4.00%) Junior
10 30 (4.00%) Supply Chain Manager
11 28 (3.73%) Senior Analyst
12 27 (3.60%) Software Developer
12 27 (3.60%) Software Engineer
13 26 (3.47%) VBA Developer
14 25 (3.33%) C# Developer
15 23 (3.07%) Python Developer
15 23 (3.07%) SQL Analyst
16 20 (2.67%) Power BI Analyst
Libraries, Frameworks & Software Standards
1 144 (19.20%) .NET
2 71 (9.47%) HTML
3 46 (6.13%) CSS
4 32 (4.27%) jQuery
5 29 (3.87%) ASP.NET
6 25 (3.33%) .NET Framework
7 20 (2.67%) JSON
7 20 (2.67%) XML
8 15 (2.00%) .NET Core
8 15 (2.00%) Ajax
8 15 (2.00%) Kafka
9 14 (1.87%) REST
10 13 (1.73%) ADO
10 13 (1.73%) Laravel
10 13 (1.73%) Web Services
11 12 (1.60%) WPF
12 11 (1.47%) AngularJS
12 11 (1.47%) ASP.NET Web API
12 11 (1.47%) WCF
13 10 (1.33%) Django
Miscellaneous
1 69 (9.20%) Management Information System
2 61 (8.13%) Algorithms
3 33 (4.40%) Self-Motivation
4 19 (2.53%) Social Media
5 15 (2.00%) Life Science
6 14 (1.87%) Equities
7 13 (1.73%) Derivative
8 11 (1.47%) Analytical Mindset
8 11 (1.47%) Foreign Exchange (FX)
9 10 (1.33%) Data Structures
9 10 (1.33%) Driving Licence
9 10 (1.33%) Legacy Systems
10 9 (1.20%) Hedge funds
10 9 (1.20%) Reference Data
11 8 (1.07%) Reinsurance
12 6 (0.80%) Credit Derivative
12 6 (0.80%) Fixed Income
12 6 (0.80%) Robotics
13 5 (0.67%) Credit Risk
14 3 (0.40%) Wiki
Operating Systems
1 28 (3.73%) Windows
2 9 (1.20%) Linux
3 8 (1.07%) Windows Server
4 5 (0.67%) Windows 10
5 3 (0.40%) Unix
6 2 (0.27%) Android
6 2 (0.27%) Windows 7
6 2 (0.27%) Windows Server 2008
6 2 (0.27%) Windows Server 2012
Processes & Methodologies
1 257 (34.27%) Analytics
2 235 (31.33%) Business Intelligence
3 172 (22.93%) Problem-Solving
4 161 (21.47%) Logistics
5 158 (21.07%) Data Analysis
6 148 (19.73%) Agile Software Development
7 110 (14.67%) Visualisation
8 83 (11.07%) Data Science
9 79 (10.53%) ETL
10 76 (10.13%) Mathematics
11 68 (9.07%) Computer Science
12 62 (8.27%) Decision-Making
13 58 (7.73%) Requirements Gathering
14 56 (7.47%) Data Management
15 54 (7.20%) Data Visualisation
16 50 (6.67%) Data Interpretation
17 48 (6.40%) Continuous Improvement
17 48 (6.40%) Product Management
17 48 (6.40%) Workshop Facilitation
18 46 (6.13%) Project Management
Programming Languages
1 579 (77.20%) SQL
2 179 (23.87%) Python
3 168 (22.40%) C#
4 81 (10.80%) JavaScript
5 79 (10.53%) T-SQL
6 50 (6.67%) PowerShell
7 45 (6.00%) Java
7 45 (6.00%) VB.NET
8 42 (5.60%) R
9 37 (4.93%) VB
10 29 (3.87%) C
11 27 (3.60%) C++
12 22 (2.93%) PHP
13 20 (2.67%) Data Analysis Expressions (DAX)
14 19 (2.53%) MATLAB
15 13 (1.73%) TypeScript
16 9 (1.20%) Groovy
16 9 (1.20%) Perl
17 8 (1.07%) PL/SQL
18 5 (0.67%) VBScript
Qualifications
1 109 (14.53%) Degree
2 22 (2.93%) Numerate Degree
3 10 (1.33%) Master's Degree
4 6 (0.80%) Security Cleared
5 5 (0.67%) CIMA
5 5 (0.67%) Microsoft Certification
5 5 (0.67%) SC Cleared
6 4 (0.53%) Computer Science Degree
6 4 (0.53%) PhD
7 3 (0.40%) AAT
7 3 (0.40%) DBS Check
8 2 (0.27%) ACCA
8 2 (0.27%) CEH
8 2 (0.27%) CISSP
8 2 (0.27%) OSCP
8 2 (0.27%) PMP
9 1 (0.13%) HNC
9 1 (0.13%) ISEB
9 1 (0.13%) ISTQB
9 1 (0.13%) NVQ Level 3
Quality Assurance & Compliance
1 37 (4.93%) Data Quality
2 27 (3.60%) GDPR
3 14 (1.87%) QA
4 8 (1.07%) SLA
5 5 (0.67%) GLP
5 5 (0.67%) GMP
5 5 (0.67%) Good Clinical Practice
6 4 (0.53%) PMO
7 3 (0.40%) Actionable Recommendations
7 3 (0.40%) Sarbanes-Oxley
8 2 (0.27%) IFRS
9 1 (0.13%) Dodd-Frank
9 1 (0.13%) FATCA
9 1 (0.13%) IFRS 9
9 1 (0.13%) MiFID
System Software
1 21 (2.80%) Docker
2 10 (1.33%) Active Directory
3 1 (0.13%) HDFS
3 1 (0.13%) Terminal Services
3 1 (0.13%) VMware ESXi
3 1 (0.13%) VMware Infrastructure
Systems Management
1 9 (1.20%) Oracle Enterprise Manager
2 7 (0.93%) Kubernetes
3 3 (0.40%) Ansible
3 3 (0.40%) Prometheus
4 1 (0.13%) Control-M
4 1 (0.13%) EMC NetWorker
4 1 (0.13%) ITRS Geneos
4 1 (0.13%) Microsoft Intune
4 1 (0.13%) Netcool
4 1 (0.13%) QRadar
4 1 (0.13%) Tivoli
4 1 (0.13%) Tivoli Storage Manager
Vendors
1 184 (24.53%) Microsoft
2 62 (8.27%) Oracle
3 45 (6.00%) SAP
4 24 (3.20%) Alteryx
5 20 (2.67%) Facebook
6 19 (2.53%) Sage
7 18 (2.40%) Salesforce.com
8 17 (2.27%) IBM
9 16 (2.13%) Google
10 13 (1.73%) GoldenSource
11 9 (1.20%) Bloomberg
12 8 (1.07%) Fidessa
13 7 (0.93%) Workday
14 6 (0.80%) Cisco
15 5 (0.67%) Demandware
15 5 (0.67%) iManage
16 4 (0.53%) Civica
16 4 (0.53%) Cognos
16 4 (0.53%) Minitab
17 3 (0.40%) QAD
108 VBA job vacancies Nationwide