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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
2 Apr 2020
Same period 2019 Same period 2018
Rank 434 430 383
Rank change year-on-year -4 -47 +19
Permanent jobs citing VBA 749 1,026 1,411
As % of all permanent jobs advertised in the UK 0.64% 0.69% 0.80%
As % of the Programming Languages category 1.18% 1.27% 1.42%
Number of salaries quoted 629 875 1,236
Median annual salary £50,000 £47,500 £43,750
Median salary % change year-on-year +5.26% +8.57% +2.94%
10th Percentile £29,750 £25,250 £27,500
90th Percentile £77,500 £85,000 £71,875
UK excluding London median annual salary £37,500 £32,500 £37,500
% change year-on-year +15.38% -13.33% +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 63,743 80,970 99,169
As % of all permanent IT jobs advertised in the UK 54.42% 54.69% 56.03%
Number of salaries quoted 52,551 66,675 83,594
Median annual salary £54,000 £52,500 £50,000
Median salary % change year-on-year +2.86% +5.00% +5.26%
10th Percentile £32,500 £31,250 £30,000
90th Percentile £88,750 £85,000 £78,750
UK excluding London median annual salary £45,000 £45,000 £43,500
% change year-on-year - +3.45% +3.57%

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 2 April 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 2 April 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 -10 683 £50,000 +5.26% 77
London -33 383 £57,500 -4.17% 41
UK excluding London +56 344 £37,500 +15.38% 44
South East +85 100 £38,500 +28.33% 12
North of England +66 85 £35,000 -6.67% 9
North West +36 52 £32,500 -13.33% 4
East of England +41 51 £35,000 +16.67% 3
South West +39 34 £45,000 +38.46% 7
Yorkshire +52 32 £35,000 -3.45% 2
Wales +10 28 £36,000 -4.00% 1
Midlands +7 27 £32,750 -6.43% 6
West Midlands +29 21 £31,995 -1.55% 6
Scotland +20 11 £55,000 +29.41% 5
Work from Home -23 11 £45,000 -24.69% 2
Northern Ireland +23 8 £40,000 +6.67% 2
East Midlands -2 6 £36,000 -4.00%
North East -4 1 £57,500 +82.54% 3

For the 6 months to 2 April 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 529 (70.63%) SQL
2 452 (60.35%) Microsoft Excel
3 298 (39.79%) Finance
4 234 (31.24%) Python
5 209 (27.90%) C#
6 203 (27.10%) SQL Server
6 203 (27.10%) Microsoft
7 171 (22.83%) Analytical Skills
8 155 (20.69%) .NET
9 153 (20.43%) Business Intelligence
10 142 (18.96%) Analytics
11 139 (18.56%) Degree
12 128 (17.09%) Power BI
12 128 (17.09%) Power Platform
13 123 (16.42%) Microsoft Office
14 122 (16.29%) Agile Software Development
15 120 (16.02%) SQL Server Reporting Services
16 108 (14.42%) Tableau
17 104 (13.89%) T-SQL
17 104 (13.89%) VB
18 101 (13.48%) Problem-Solving
19 99 (13.22%) Data Analysis
20 97 (12.95%) Java
20 97 (12.95%) Oracle
21 96 (12.82%) MS Access
22 94 (12.55%) SQL Server Integration Services
23 90 (12.02%) Front Office
24 82 (10.95%) Windows
25 80 (10.68%) R
26 74 (9.88%) Visualisation

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 30 (4.01%) SharePoint
2 28 (3.74%) Confluence
3 21 (2.80%) SAS
4 10 (1.34%) IIS
5 4 (0.53%) Apache Spark
6 2 (0.27%) ArcGIS
7 1 (0.13%) Apache
7 1 (0.13%) ArcSDE
7 1 (0.13%) CMS
7 1 (0.13%) GeoServer
7 1 (0.13%) MS Exchange
7 1 (0.13%) Oracle Workflow
7 1 (0.13%) Tomcat
Applications
1 452 (60.35%) Microsoft Excel
2 123 (16.42%) Microsoft Office
3 28 (3.74%) Microsoft PowerPoint
4 14 (1.87%) Spreadsheet
5 10 (1.34%) SPSS
6 7 (0.93%) MS Visio
7 2 (0.27%) CPLEX
Business Applications
1 12 (1.60%) Oracle EBS
2 7 (0.93%) Cognos TM1
2 7 (0.93%) Oracle Financials
3 6 (0.80%) Dynamics CRM
4 5 (0.67%) Distributed Ledger
4 5 (0.67%) RiskWrite
5 4 (0.53%) Adobe Campaign
5 4 (0.53%) Exchequer
5 4 (0.53%) FastStats
5 4 (0.53%) NetSuite
5 4 (0.53%) Unica
5 4 (0.53%) Visualfiles
6 3 (0.40%) Dynamics AX
6 3 (0.40%) Markit EDM
6 3 (0.40%) MIS ActiveH
6 3 (0.40%) thinkFolio
7 2 (0.27%) Oracle Assets
7 2 (0.27%) Oracle Cash Management
7 2 (0.27%) Oracle Payables
7 2 (0.27%) Oracle Receivables
Cloud Services
1 128 (17.09%) Power Platform
2 60 (8.01%) Azure
3 45 (6.01%) Office 365
4 17 (2.27%) AWS
5 13 (1.74%) SaaS
6 10 (1.34%) IaaS
6 10 (1.34%) PaaS
7 6 (0.80%) GCP
8 5 (0.67%) PowerApps
8 5 (0.67%) Salesforce Sales Cloud
8 5 (0.67%) Salesforce Service Cloud
9 4 (0.53%) Azure Data Factory
9 4 (0.53%) Responsys
9 4 (0.53%) Silverpop
10 3 (0.40%) Cloud Computing
10 3 (0.40%) Dynamics 365
10 3 (0.40%) Google Analytics
10 3 (0.40%) Smartsheet
11 2 (0.27%) GitHub
11 2 (0.27%) Microsoft Flow
Communications & Networking
1 23 (3.07%) Cisco IOS
2 8 (1.07%) Skype
3 7 (0.93%) DNS
3 7 (0.93%) TCP/IP
4 6 (0.80%) tcpdump
4 6 (0.80%) Wireshark
5 5 (0.67%) LAN
5 5 (0.67%) WAN
6 4 (0.53%) DHCP
6 4 (0.53%) Firewall
6 4 (0.53%) WinSCP
7 3 (0.40%) HTTP
7 3 (0.40%) Internet
7 3 (0.40%) SMTP
8 2 (0.27%) Ethernet
8 2 (0.27%) Modbus
8 2 (0.27%) SSL
8 2 (0.27%) VPN
9 1 (0.13%) LTE
9 1 (0.13%) Radio Access Network
Database & Business Intelligence
1 203 (27.10%) SQL Server
2 128 (17.09%) Power BI
3 120 (16.02%) SQL Server Reporting Services
4 96 (12.82%) MS Access
5 94 (12.55%) SQL Server Integration Services
6 71 (9.48%) Data Warehouse
7 53 (7.08%) MySQL
8 44 (5.87%) SQL Server Analysis Services
9 40 (5.34%) BusinessObjects
10 28 (3.74%) Relational Database
11 25 (3.34%) Qlik Sense
12 24 (3.20%) Crystal Reports
13 22 (2.94%) QlikView
14 20 (2.67%) Hadoop
15 19 (2.54%) DB2
16 16 (2.14%) Data Mining
17 13 (1.74%) Data Lake
18 12 (1.60%) Oracle Database
19 11 (1.47%) Oracle Reports
20 10 (1.34%) Oracle ODI
Development Applications
1 31 (4.14%) Subversion
2 29 (3.87%) Eclipse
3 28 (3.74%) JIRA
4 22 (2.94%) Visual Studio
5 10 (1.34%) Selenium
6 9 (1.20%) Jenkins
7 8 (1.07%) Git (software)
7 8 (1.07%) Team Foundation Server
7 8 (1.07%) WebDriver
8 7 (0.93%) GCC
9 6 (0.80%) SQL Server Management Studio (SSMS)
10 5 (0.67%) IBM UrbanCode
11 3 (0.40%) LSMW
11 3 (0.40%) Toad
12 2 (0.27%) Oracle APEX
12 2 (0.27%) Postman
12 2 (0.27%) SpecFlow
13 1 (0.13%) Moq
13 1 (0.13%) SoapUI
13 1 (0.13%) TeamCity
General
1 298 (39.79%) Finance
2 90 (12.02%) Front Office
3 59 (7.88%) Banking
4 50 (6.68%) Back Office
5 37 (4.94%) Retail
6 28 (3.74%) Legal
7 22 (2.94%) Telecoms
8 21 (2.80%) Marketing
9 12 (1.60%) Public Sector
10 11 (1.47%) Advertising
10 11 (1.47%) Manufacturing
11 10 (1.34%) Law
12 9 (1.20%) Billing
12 9 (1.20%) Investment Banking
13 6 (0.80%) Financial Institution
14 5 (0.67%) Police
15 3 (0.40%) Aerospace
15 3 (0.40%) Automotive
16 2 (0.27%) German Language
16 2 (0.27%) Publishing
Job Titles
1 288 (38.45%) Analyst
2 276 (36.85%) Developer
3 76 (10.15%) SQL Developer
4 65 (8.68%) Data Analyst
4 65 (8.68%) Support Analyst
5 56 (7.48%) Senior Analyst
6 52 (6.94%) Software Developer
7 49 (6.54%) C# Developer
8 33 (4.41%) .NET Developer
8 33 (4.41%) VBA Developer
9 32 (4.27%) Applications Support
9 32 (4.27%) Junior
9 32 (4.27%) Python Developer
10 31 (4.14%) Business Intelligence Analyst
10 31 (4.14%) SQL Analyst
11 30 (4.01%) Systems Developer
12 29 (3.87%) IT Support
13 27 (3.60%) Database Developer
14 25 (3.34%) Architect
14 25 (3.34%) Insight Analyst
Libraries, Frameworks & Software Standards
1 155 (20.69%) .NET
2 55 (7.34%) XML
3 53 (7.08%) HTML
4 46 (6.14%) ASP.NET
5 44 (5.87%) Web Services
6 22 (2.94%) WCF
7 16 (2.14%) WPF
8 14 (1.87%) CSS
9 11 (1.47%) REST
9 11 (1.47%) WinForms
10 10 (1.34%) AngularJS
10 10 (1.34%) React
10 10 (1.34%) SOAP
11 8 (1.07%) Apache Flex
11 8 (1.07%) Boost C++ Libraries
11 8 (1.07%) Qt
12 6 (0.80%) ASP.NET Web API
12 6 (0.80%) FIX Protocol
12 6 (0.80%) Node.js
12 6 (0.80%) Velocity
Miscellaneous
1 171 (22.83%) Analytical Skills
2 42 (5.61%) Fixed Income
3 35 (4.67%) Management Information System
4 32 (4.27%) User Experience
5 27 (3.60%) Derivative
6 26 (3.47%) Foreign Exchange (FX)
7 22 (2.94%) Video Conferencing
8 15 (2.00%) Self-Motivation
9 14 (1.87%) Greenfield Project
10 13 (1.74%) Equities
11 12 (1.60%) Credit Risk
11 12 (1.60%) FMCG
11 12 (1.60%) Hedge funds
12 8 (1.07%) OTC Derivatives
12 8 (1.07%) Robotics
12 8 (1.07%) SWIFT
13 6 (0.80%) Data Structures
14 5 (0.67%) Analytical Mindset
14 5 (0.67%) Driving Licence
14 5 (0.67%) Virtual Team
Operating Systems
1 82 (10.95%) Windows
2 47 (6.28%) Linux
3 19 (2.54%) Unix
4 17 (2.27%) Windows Server
5 5 (0.67%) Windows 7
6 2 (0.27%) Android
6 2 (0.27%) Windows 10
7 1 (0.13%) Solaris
7 1 (0.13%) Windows Server 2008
7 1 (0.13%) Windows Server 2016
Processes & Methodologies
1 153 (20.43%) Business Intelligence
2 142 (18.96%) Analytics
3 122 (16.29%) Agile Software Development
4 101 (13.48%) Problem-Solving
5 99 (13.22%) Data Analysis
6 74 (9.88%) Visualisation
7 69 (9.21%) Mentoring
8 66 (8.81%) Test Automation
9 57 (7.61%) Computer Science
9 57 (7.61%) Project Management
10 56 (7.48%) ETL
11 51 (6.81%) Coaching
12 49 (6.54%) Stakeholder Management
13 48 (6.41%) Time Management
14 46 (6.14%) Data Analytics
14 46 (6.14%) Data Visualisation
14 46 (6.14%) Mathematics
15 43 (5.74%) Data Management
16 41 (5.47%) OO
17 40 (5.34%) Workflow
Programming Languages
1 529 (70.63%) SQL
2 234 (31.24%) Python
3 209 (27.90%) C#
4 104 (13.89%) T-SQL
4 104 (13.89%) VB
5 97 (12.95%) Java
6 80 (10.68%) R
7 57 (7.61%) PHP
8 55 (7.34%) PowerShell
9 49 (6.54%) JavaScript
10 46 (6.14%) C++
11 33 (4.41%) PL/SQL
11 33 (4.41%) VB.NET
12 25 (3.34%) C
13 20 (2.67%) VBScript
14 15 (2.00%) Shell Script
15 11 (1.47%) MATLAB
15 11 (1.47%) VB6
16 9 (1.20%) Data Analysis Expressions (DAX)
17 6 (0.80%) TypeScript
Qualifications
1 139 (18.56%) Degree
2 29 (3.87%) Computer Science Degree
3 15 (2.00%) SC Cleared
3 15 (2.00%) Security Cleared
4 10 (1.34%) Numerate Degree
5 8 (1.07%) CIMA
6 7 (0.93%) ISEB
7 6 (0.80%) DV Cleared
7 6 (0.80%) IIBA
8 5 (0.67%) ACCA
9 4 (0.53%) Microsoft Certification
9 4 (0.53%) Six Sigma Green Belt
10 2 (0.27%) PhD
10 2 (0.27%) PMI Certification
10 2 (0.27%) PMP
10 2 (0.27%) TOGAF Certification
11 1 (0.13%) CCAB
11 1 (0.13%) CFA
11 1 (0.13%) MCSA
11 1 (0.13%) PRINCE2 Certification
Quality Assurance & Compliance
1 28 (3.74%) QA
2 20 (2.67%) Data Quality
3 7 (0.93%) GDPR
4 5 (0.67%) PMO
5 4 (0.53%) COBIT
5 4 (0.53%) ISO/IEC 27001
6 3 (0.40%) EMIR
6 3 (0.40%) Sarbanes-Oxley
7 2 (0.27%) Basel II
7 2 (0.27%) Basel III
7 2 (0.27%) BS7799
7 2 (0.27%) SLA
8 1 (0.13%) IFRS
8 1 (0.13%) IFRS 9
8 1 (0.13%) MiFID
8 1 (0.13%) P3O
System Software
1 17 (2.27%) Active Directory
2 5 (0.67%) Tivoli Workload Scheduler
3 2 (0.27%) XenApp
4 1 (0.13%) Cronacle
4 1 (0.13%) VMware Infrastructure
Systems Management
1 15 (2.00%) SCCM
2 5 (0.67%) Tivoli
3 3 (0.40%) Control-M
4 2 (0.27%) EnCase
4 2 (0.27%) FTK
4 2 (0.27%) Oracle Enterprise Manager
Vendors
1 203 (27.10%) Microsoft
2 108 (14.42%) Tableau
3 97 (12.95%) Oracle
4 32 (4.27%) Bloomberg
5 29 (3.87%) Avaya
5 29 (3.87%) Blue Prism
6 28 (3.74%) WorldPay
7 25 (3.34%) Cisco
8 23 (3.07%) Apple
8 23 (3.07%) Reuters
9 21 (2.80%) Xceptor
10 18 (2.40%) IBM
11 16 (2.14%) Citrix
11 16 (2.14%) SAP
12 15 (2.00%) Salesforce.com
13 12 (1.60%) Informatica
14 11 (1.47%) Google
15 10 (1.34%) Aderant
15 10 (1.34%) Intapp
15 10 (1.34%) UiPath