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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
18 Sep 2020
Same period 2019 Same period 2018
Rank 443 425 407
Rank change year-on-year -18 -18 +25
Permanent jobs citing VBA 263 991 1,306
As % of all permanent jobs advertised in the UK 0.52% 0.70% 0.78%
As % of the Programming Languages category 0.89% 1.31% 1.40%
Number of salaries quoted 229 879 1,120
Median annual salary £55,000 £47,500 £42,500
Median salary % change year-on-year +15.79% +11.76% -5.56%
10th Percentile £30,100 £27,500 £26,250
90th Percentile £118,750 £75,000 £74,325
UK excluding London median annual salary £36,000 £36,000 £37,500
% change year-on-year - -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 29,686 75,692 93,419
As % of all permanent IT jobs advertised in the UK 58.75% 53.46% 55.69%
Number of salaries quoted 24,814 61,848 77,658
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £33,750 £31,250 £31,000
90th Percentile £92,500 £85,000 £82,500
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 18 September 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 18 September 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 -46 241 £61,250 +28.95% 49
London -15 166 £83,750 +52.27% 23
UK excluding London +52 93 £36,000 - 31
East of England +107 18 £37,257 -17.21% 3
North of England +86 17 £35,000 -10.26% 5
Midlands +98 16 £32,500 - 5
South East +130 13 £37,500 +7.14% 8
South West +86 10 £31,250 -10.71% 5
Wales +53 10 £35,500 -3.40%
North West +69 9 £40,000 - 3
West Midlands +90 8 £35,750 +2.14% 2
East Midlands +74 8 £32,500 +8.33% 3
Work from Home +50 8 £42,500 -5.56% 1
Yorkshire +115 7 £25,000 -23.08% 1
Northern Ireland - 6 £42,000 - 3
Scotland +89 3 £55,000 -37.14% 2
North East +13 1 £30,250 +8.04% 1

For the 6 months to 18 September 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 191 (72.62%) Microsoft Excel
2 178 (67.68%) SQL
3 133 (50.57%) Finance
4 117 (44.49%) Microsoft
5 87 (33.08%) Python
6 78 (29.66%) Agile Software Development
7 69 (26.24%) .NET
8 68 (25.86%) C#
9 61 (23.19%) Analytics
10 59 (22.43%) SQL Server
11 55 (20.91%) Front Office
12 53 (20.15%) Analytical Skills
13 52 (19.77%) R
14 49 (18.63%) Data Analysis
15 48 (18.25%) Scrum
16 47 (17.87%) Business Analysis
16 47 (17.87%) Asset Management
17 45 (17.11%) Derivative
18 44 (16.73%) MATLAB
19 43 (16.35%) Degree
20 42 (15.97%) Investment Management
21 41 (15.59%) Bloomberg
21 41 (15.59%) Fixed Income
22 40 (15.21%) Migration
23 39 (14.83%) Hedge funds
24 38 (14.45%) Power BI
24 38 (14.45%) Business Intelligence
24 38 (14.45%) Power Platform
25 36 (13.69%) OTC Derivatives
25 36 (13.69%) Performance Attribution

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 8 (3.04%) SAS
2 4 (1.52%) IIS
2 4 (1.52%) SharePoint
3 3 (1.14%) Confluence
3 3 (1.14%) Elasticsearch
4 1 (0.38%) Apache
4 1 (0.38%) MS Exchange
4 1 (0.38%) Tomcat
Applications
1 191 (72.62%) Microsoft Excel
2 31 (11.79%) Microsoft Office
3 21 (7.98%) Spreadsheet
4 14 (5.32%) Microsoft PowerPoint
5 2 (0.76%) Microsoft Project
5 2 (0.76%) Quantrix
6 1 (0.38%) AutoCAD
6 1 (0.38%) SPSS
Business Applications
1 3 (1.14%) Oracle Financials
1 3 (1.14%) SAP Business One
2 2 (0.76%) Endur
2 2 (0.76%) Exchequer
2 2 (0.76%) NetSuite
3 1 (0.38%) Dynamics AX
3 1 (0.38%) Dynamics CRM
3 1 (0.38%) FINCAD Analytics
3 1 (0.38%) MIS ActiveH
3 1 (0.38%) Oracle Assets
3 1 (0.38%) Oracle Cash Management
3 1 (0.38%) Oracle EBS
3 1 (0.38%) Oracle EBS R12
3 1 (0.38%) Oracle General Ledger
3 1 (0.38%) Oracle Payables
3 1 (0.38%) Oracle Receivables
3 1 (0.38%) PolarLake
3 1 (0.38%) Primavera
3 1 (0.38%) SAP HR
3 1 (0.38%) Summit
Cloud Services
1 38 (14.45%) Power Platform
2 21 (7.98%) Azure
3 12 (4.56%) AWS
4 8 (3.04%) GCP
5 5 (1.90%) Office 365
6 4 (1.52%) SaaS
7 3 (1.14%) G Suite
8 1 (0.38%) Google Tag Manager
Communications & Networking
1 7 (2.66%) DHCP
1 7 (2.66%) DNS
1 7 (2.66%) TCP/IP
2 4 (1.52%) LAN
2 4 (1.52%) WAN
3 3 (1.14%) 2G
3 3 (1.14%) 3G
3 3 (1.14%) 4G
3 3 (1.14%) 5G
3 3 (1.14%) Radio Access Network
3 3 (1.14%) SSL
3 3 (1.14%) UTRAN
4 1 (0.38%) Cisco IOS
Database & Business Intelligence
1 59 (22.43%) SQL Server
2 38 (14.45%) Power BI
3 27 (10.27%) SQL Server Reporting Services
4 25 (9.51%) Data Warehouse
4 25 (9.51%) MS Access
5 19 (7.22%) SQL Server Integration Services
6 15 (5.70%) Relational Database
7 13 (4.94%) MySQL
8 8 (3.04%) BusinessObjects
8 8 (3.04%) NoSQL
8 8 (3.04%) RDBMS
9 6 (2.28%) Hadoop
9 6 (2.28%) SQL Server Analysis Services
10 4 (1.52%) Crystal Reports
10 4 (1.52%) Qlik Sense
10 4 (1.52%) QlikView
10 4 (1.52%) SQL Server 2012
11 3 (1.14%) Data Lake
11 3 (1.14%) Oracle Reports
11 3 (1.14%) Sybase IQ
Development Applications
1 7 (2.66%) Git (software)
1 7 (2.66%) JIRA
1 7 (2.66%) Subversion
2 5 (1.90%) RStudio
2 5 (1.90%) Visual Studio
3 4 (1.52%) Jenkins
4 3 (1.14%) Oracle Forms
4 3 (1.14%) SQL Server Management Studio (SSMS)
5 2 (0.76%) IBM UrbanCode
5 2 (0.76%) Team Foundation Server
6 1 (0.38%) Eclipse
6 1 (0.38%) GCC
6 1 (0.38%) Toad
6 1 (0.38%) Visual Studio Tools for Office
6 1 (0.38%) Xcode
General
1 133 (50.57%) Finance
2 55 (20.91%) Front Office
3 15 (5.70%) Telecoms
4 13 (4.94%) Back Office
5 11 (4.18%) Banking
6 10 (3.80%) Advertising
7 9 (3.42%) Retail
8 8 (3.04%) Marketing
9 3 (1.14%) Legal
9 3 (1.14%) Public Sector
10 2 (0.76%) Billing
10 2 (0.76%) Financial Institution
10 2 (0.76%) Investment Banking
10 2 (0.76%) Manufacturing
11 1 (0.38%) Electronics
11 1 (0.38%) German Language
11 1 (0.38%) Law
11 1 (0.38%) Retail Banking
Job Titles
1 98 (37.26%) Developer
2 94 (35.74%) Analyst
3 28 (10.65%) Finance Manager
4 27 (10.27%) Financial Analyst
5 25 (9.51%) Analytics Manager
6 20 (7.60%) Head of Analytics
6 20 (7.60%) Head of Finance
7 16 (6.08%) Support Analyst
8 15 (5.70%) Business Analyst
9 13 (4.94%) Applications Support
9 13 (4.94%) C# Developer
10 12 (4.56%) Data Analyst
10 12 (4.56%) Fixed Income Business Analyst
10 12 (4.56%) Systems Analyst
11 11 (4.18%) Performance Manager
11 11 (4.18%) Senior Analyst
11 11 (4.18%) Service Analyst
12 10 (3.80%) Python Developer
12 10 (3.80%) Software Developer
12 10 (3.80%) SQL Analyst
Libraries, Frameworks & Software Standards
1 69 (26.24%) .NET
2 25 (9.51%) ASP.NET
3 20 (7.60%) HTML
3 20 (7.60%) XML
4 18 (6.84%) AngularJS
4 18 (6.84%) React
5 16 (6.08%) Web Services
6 13 (4.94%) WCF
7 12 (4.56%) .NET Framework
7 12 (4.56%) RESTful
8 9 (3.42%) CSS
8 9 (3.42%) Node.js
8 9 (3.42%) WPF
9 8 (3.04%) REST
10 6 (2.28%) HTML5
10 6 (2.28%) Pandas
10 6 (2.28%) SignalR
11 5 (1.90%) .NET Core
11 5 (1.90%) Twitter Bootstrap
11 5 (1.90%) WinForms
Miscellaneous
1 53 (20.15%) Analytical Skills
2 45 (17.11%) Derivative
3 41 (15.59%) Fixed Income
4 39 (14.83%) Hedge funds
5 36 (13.69%) OTC Derivatives
6 18 (6.84%) Management Information System
7 12 (4.56%) User Experience
8 9 (3.42%) Foreign Exchange (FX)
8 9 (3.42%) Greenfield Project
9 8 (3.04%) Robotics
10 4 (1.52%) Client/Server
10 4 (1.52%) Interest Rate Derivative
10 4 (1.52%) Market Risk
11 3 (1.14%) Analytical Mindset
11 3 (1.14%) Credit Risk
11 3 (1.14%) Data Centre
11 3 (1.14%) FMCG
11 3 (1.14%) N-Tier
11 3 (1.14%) Self-Motivation
12 2 (0.76%) Driving Licence
Operating Systems
1 28 (10.65%) Windows
2 16 (6.08%) Linux
3 8 (3.04%) Windows 10
3 8 (3.04%) Windows 7
4 5 (1.90%) Unix
4 5 (1.90%) Windows Server
5 3 (1.14%) Windows Server 2012
6 1 (0.38%) Apple iOS
6 1 (0.38%) Windows Server 2008
6 1 (0.38%) Windows Server 2016
Processes & Methodologies
1 78 (29.66%) Agile Software Development
2 61 (23.19%) Analytics
3 49 (18.63%) Data Analysis
4 48 (18.25%) Scrum
5 47 (17.87%) Asset Management
5 47 (17.87%) Business Analysis
6 42 (15.97%) Investment Management
7 40 (15.21%) Migration
8 38 (14.45%) Business Intelligence
9 36 (13.69%) Performance Attribution
9 36 (13.69%) Risk Analysis
10 34 (12.93%) Fund Management
11 33 (12.55%) Problem-Solving
12 29 (11.03%) Mentoring
13 24 (9.13%) DevOps
14 21 (7.98%) Computer Science
14 21 (7.98%) Stakeholder Management
15 20 (7.60%) ETL
16 18 (6.84%) Mathematics
17 17 (6.46%) ERP
Programming Languages
1 178 (67.68%) SQL
2 87 (33.08%) Python
3 68 (25.86%) C#
4 52 (19.77%) R
5 44 (16.73%) MATLAB
6 26 (9.89%) VB
7 25 (9.51%) JavaScript
8 22 (8.37%) Java
9 18 (6.84%) PowerShell
10 17 (6.46%) T-SQL
11 13 (4.94%) C++
11 13 (4.94%) PHP
12 12 (4.56%) VBScript
13 9 (3.42%) TypeScript
14 6 (2.28%) VB.NET
15 4 (1.52%) C
16 3 (1.14%) Google Apps Script
17 2 (0.76%) PL/SQL
18 1 (0.38%) Bash Shell
18 1 (0.38%) Scala
Qualifications
1 43 (16.35%) Degree
2 5 (1.90%) HNC
2 5 (1.90%) HND
3 4 (1.52%) A+ Certification
3 4 (1.52%) Computer Science Degree
4 2 (0.76%) ACCA
4 2 (0.76%) CIMA
4 2 (0.76%) Numerate Degree
5 1 (0.38%) ISEB
5 1 (0.38%) PhD
5 1 (0.38%) PMI Certification
5 1 (0.38%) SAS Certification
Quality Assurance & Compliance
1 19 (7.22%) QA
2 5 (1.90%) SLA
3 3 (1.14%) Data Quality
4 2 (0.76%) GDPR
5 1 (0.38%) Basel II
5 1 (0.38%) Basel III
5 1 (0.38%) COBIT
5 1 (0.38%) IFRS
5 1 (0.38%) ISO/IEC 27001
5 1 (0.38%) Sarbanes-Oxley
System Software
1 8 (3.04%) Active Directory
2 2 (0.76%) Tivoli Workload Scheduler
3 1 (0.38%) Cronacle
3 1 (0.38%) VMware Infrastructure
3 1 (0.38%) XenDesktop
Systems Management
1 6 (2.28%) SCCM
2 3 (1.14%) Kibana
3 2 (0.76%) Tivoli
4 1 (0.38%) Oracle Enterprise Manager
Vendors
1 117 (44.49%) Microsoft
2 41 (15.59%) Bloomberg
3 32 (12.17%) Tableau
4 17 (6.46%) Oracle
5 14 (5.32%) SAP
6 10 (3.80%) Blue Prism
7 9 (3.42%) Google
7 9 (3.42%) UiPath
8 7 (2.66%) Automation Anywhere
8 7 (2.66%) HP
8 7 (2.66%) Sun
9 6 (2.28%) Avaya
10 5 (1.90%) Reuters
11 4 (1.52%) DevExpress
12 3 (1.14%) BT
12 3 (1.14%) FXall
12 3 (1.14%) Huawei
12 3 (1.14%) Nokia
12 3 (1.14%) Sybase
12 3 (1.14%) Yardi