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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
18 Feb 2020
Same period 2019 Same period 2018
Rank 447 438 426
Rank change year-on-year -9 -12 -20
Permanent jobs citing VBA 781 1,034 1,257
As % of all permanent IT jobs advertised in the UK 0.63% 0.69% 0.72%
As % of the Programming Languages category 1.16% 1.25% 1.29%
Number of salaries quoted 638 866 1,068
UK median annual salary £50,000 £45,500 £45,000
Median salary % change year-on-year +9.89% +1.11% +5.88%
10th Percentile £30,000 £26,750 £27,500
90th Percentile £72,500 £80,000 £72,500
UK excluding London median annual salary £40,000 £35,000 £38,000
% change year-on-year +14.29% -7.89% +8.57%

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 67,365 82,808 97,075
As % of all permanent IT jobs advertised in the UK 54.21% 54.99% 55.72%
Number of salaries quoted 55,661 68,483 81,558
UK median annual salary £52,500 £52,000 £50,000
Median salary % change year-on-year +0.96% +4.00% +5.26%
10th Percentile £32,000 £31,250 £29,750
90th Percentile £87,500 £85,000 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -

VBA
Job Vacancy Trend

Job postings citing VBA as a percentage of all IT jobs advertised.

Job vacancy trend for VBA in the UK

VBA
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing VBA.

Salary trend for VBA in the UK

VBA
Salary Histogram

The salary distribution of IT jobs citing VBA over the 6 months to 18 February 2020.

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 18 February 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 +4 737 £50,000 +5.26% 131
London -8 443 £55,000 -4.76% 55
UK excluding London +1 323 £40,000 +14.29% 91
South East +70 95 £40,000 +23.08% 26
North of England +46 94 £40,000 +6.67% 22
North West +27 62 £40,000 +6.67% 11
East of England +17 42 £35,000 -12.50% 5
South West +30 39 £42,500 +30.77% 13
Yorkshire +24 29 £37,500 -6.25% 9
Midlands -20 21 £32,495 -0.02% 11
Wales -4 18 £37,500 +7.14% 9
West Midlands +12 16 £32,490 -0.03% 11
Northern Ireland +14 8 £40,000 +6.67%
Scotland +15 6 £37,500 +7.14% 6
East Midlands -9 5 £42,500 +13.33%
North East +4 3 £31,000 -17.33% 2

For the 6 months to 18 February 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 549 (70.29%) SQL
2 463 (59.28%) Microsoft Excel
3 347 (44.43%) Finance
4 229 (29.32%) SQL Server
5 220 (28.17%) Python
6 211 (27.02%) C#
7 195 (24.97%) Microsoft
8 173 (22.15%) Analytical Skills
9 167 (21.38%) Business Intelligence
10 158 (20.23%) .NET
11 151 (19.33%) Analytics
12 138 (17.67%) Degree
13 125 (16.01%) SQL Server Reporting Services
14 124 (15.88%) Power Platform
15 122 (15.62%) Tableau
16 119 (15.24%) Power BI
17 117 (14.98%) T-SQL
18 115 (14.72%) VB
19 109 (13.96%) Oracle
20 108 (13.83%) Agile Software Development
20 108 (13.83%) SQL Server Integration Services
21 107 (13.70%) Microsoft Office
21 107 (13.70%) Problem-Solving
22 100 (12.80%) Data Analysis
23 93 (11.91%) MS Access
24 86 (11.01%) Visualisation
25 85 (10.88%) R
26 82 (10.50%) Java
27 79 (10.12%) Front Office
28 77 (9.86%) Windows

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 37 (4.74%) SharePoint
2 34 (4.35%) SAS
3 24 (3.07%) Confluence
4 15 (1.92%) IIS
5 5 (0.64%) ArcGIS
5 5 (0.64%) WordPress
6 4 (0.51%) Apache Spark
7 3 (0.38%) CMS
7 3 (0.38%) Jupyter
7 3 (0.38%) nginx
8 1 (0.13%) ArcSDE
8 1 (0.13%) Exchange Server 2010
8 1 (0.13%) GeoServer
8 1 (0.13%) MS Exchange
8 1 (0.13%) Oracle Workflow
8 1 (0.13%) SharePoint 2010
8 1 (0.13%) SharePoint 2013
8 1 (0.13%) Tomcat
Applications
1 463 (59.28%) Microsoft Excel
2 107 (13.70%) Microsoft Office
3 17 (2.18%) Microsoft PowerPoint
4 14 (1.79%) Spreadsheet
5 13 (1.66%) MS Visio
6 9 (1.15%) SPSS
7 5 (0.64%) Microsoft Project
8 3 (0.38%) SPSS Modeler
9 2 (0.26%) CPLEX
10 1 (0.13%) PTC Creo
10 1 (0.13%) Windchill
Business Applications
1 14 (1.79%) Oracle EBS
2 7 (0.90%) Payment Gateway
3 6 (0.77%) Cognos TM1
4 5 (0.64%) Distributed Ledger
4 5 (0.64%) Dynamics CRM
4 5 (0.64%) FastStats
4 5 (0.64%) Oracle Financials
4 5 (0.64%) RiskWrite
5 4 (0.51%) Adobe Campaign
5 4 (0.51%) NetSuite
5 4 (0.51%) Unica
5 4 (0.51%) Visualfiles
6 3 (0.38%) Dynamics AX
6 3 (0.38%) Markit EDM
6 3 (0.38%) thinkFolio
7 2 (0.26%) Magento
7 2 (0.26%) Relativity
7 2 (0.26%) Sage 200
7 2 (0.26%) SAP ERP
7 2 (0.26%) SAP InfiniteInsight
Cloud Services
1 124 (15.88%) Power Platform
2 66 (8.45%) Azure
3 49 (6.27%) Office 365
4 12 (1.54%) AWS
4 12 (1.54%) Salesforce Sales Cloud
4 12 (1.54%) Salesforce Service Cloud
5 9 (1.15%) IaaS
5 9 (1.15%) PaaS
5 9 (1.15%) SaaS
6 7 (0.90%) Microsoft Flow
7 5 (0.64%) GCP
7 5 (0.64%) PowerApps
8 4 (0.51%) Azure Data Factory
8 4 (0.51%) Dynamics 365
8 4 (0.51%) Responsys
8 4 (0.51%) Silverpop
9 3 (0.38%) Cloud Computing
9 3 (0.38%) Google Analytics
10 2 (0.26%) GitHub
10 2 (0.26%) Smartsheet
Communications & Networking
1 23 (2.94%) Cisco IOS
2 6 (0.77%) DNS
2 6 (0.77%) Skype
2 6 (0.77%) tcpdump
2 6 (0.77%) Wireshark
3 5 (0.64%) TCP/IP
4 4 (0.51%) Internet
4 4 (0.51%) WinSCP
5 3 (0.38%) DHCP
5 3 (0.38%) Firewall
5 3 (0.38%) HTTP
5 3 (0.38%) SMTP
6 2 (0.26%) Ethernet
6 2 (0.26%) Extranet
6 2 (0.26%) Intranet
6 2 (0.26%) Modbus
6 2 (0.26%) VPN
7 1 (0.13%) Remote Desktop
7 1 (0.13%) Wireless
7 1 (0.13%) Wireless Security
Database & Business Intelligence
1 229 (29.32%) SQL Server
2 125 (16.01%) SQL Server Reporting Services
3 119 (15.24%) Power BI
4 108 (13.83%) SQL Server Integration Services
5 93 (11.91%) MS Access
6 64 (8.19%) Data Warehouse
7 63 (8.07%) SQL Server Analysis Services
8 52 (6.66%) MySQL
9 31 (3.97%) BusinessObjects
10 27 (3.46%) Crystal Reports
11 26 (3.33%) Relational Database
12 23 (2.94%) QlikView
13 19 (2.43%) Big Data
13 19 (2.43%) Oracle Database
13 19 (2.43%) Qlik Sense
14 18 (2.30%) Azure SQL Database
15 16 (2.05%) Data Mining
15 16 (2.05%) DB2
16 15 (1.92%) Hadoop
17 14 (1.79%) Oracle ODI
Development Applications
1 36 (4.61%) Subversion
2 33 (4.23%) Visual Studio
3 30 (3.84%) Eclipse
4 26 (3.33%) JIRA
5 17 (2.18%) Selenium
6 14 (1.79%) WebDriver
7 13 (1.66%) Git (software)
8 12 (1.54%) Team Foundation Server
9 9 (1.15%) Jenkins
10 7 (0.90%) GCC
11 3 (0.38%) Oracle Forms
11 3 (0.38%) Postman
11 3 (0.38%) Redmine
11 3 (0.38%) SpecFlow
11 3 (0.38%) SQL Server Management Studio (SSMS)
12 2 (0.26%) LSMW
12 2 (0.26%) Oracle APEX
13 1 (0.13%) TeamCity
13 1 (0.13%) TortoiseSVN
13 1 (0.13%) Visual Studio Tools for Office
General
1 347 (44.43%) Finance
2 79 (10.12%) Front Office
3 68 (8.71%) Banking
4 51 (6.53%) Back Office
5 33 (4.23%) Retail
6 31 (3.97%) Marketing
7 29 (3.71%) Legal
8 18 (2.30%) Investment Banking
9 16 (2.05%) Law
10 10 (1.28%) Financial Institution
11 9 (1.15%) Advertising
11 9 (1.15%) Manufacturing
11 9 (1.15%) Public Sector
12 8 (1.02%) Billing
13 6 (0.77%) Telecoms
14 5 (0.64%) Police
15 3 (0.38%) Aerospace
15 3 (0.38%) Automotive
15 3 (0.38%) Publishing
16 1 (0.13%) Games
Job Titles
1 306 (39.18%) Developer
2 280 (35.85%) Analyst
3 95 (12.16%) SQL Developer
4 75 (9.60%) Data Analyst
5 61 (7.81%) C# Developer
6 57 (7.30%) Senior Analyst
7 51 (6.53%) Support Analyst
8 46 (5.89%) .NET Developer
8 46 (5.89%) Software Developer
9 42 (5.38%) VBA Developer
10 39 (4.99%) Junior
11 37 (4.74%) Python Developer
12 36 (4.61%) Applications Support
13 35 (4.48%) Systems Developer
14 30 (3.84%) Business Intelligence Analyst
14 30 (3.84%) SQL Analyst
15 29 (3.71%) Insight Analyst
16 28 (3.59%) Consultant
16 28 (3.59%) Database Developer
17 24 (3.07%) Architect
Libraries, Frameworks & Software Standards
1 158 (20.23%) .NET
2 61 (7.81%) HTML
3 46 (5.89%) ASP.NET
4 41 (5.25%) XML
5 37 (4.74%) Web Services
6 16 (2.05%) WinForms
7 14 (1.79%) CSS
8 13 (1.66%) WPF
9 12 (1.54%) Visualforce
10 11 (1.41%) ASP.NET Web API
10 11 (1.41%) Boost C++ Libraries
10 11 (1.41%) Node.js
10 11 (1.41%) Qt
11 9 (1.15%) jQuery
12 8 (1.02%) JSON
12 8 (1.02%) REST
13 7 (0.90%) FIX Protocol
14 6 (0.77%) .NET Framework
15 5 (0.64%) D3.js
15 5 (0.64%) Pandas
Miscellaneous
1 173 (22.15%) Analytical Skills
2 30 (3.84%) Fixed Income
3 29 (3.71%) Management Information System
4 28 (3.59%) User Experience
5 24 (3.07%) Foreign Exchange (FX)
6 20 (2.56%) Derivative
7 19 (2.43%) Video Conferencing
8 15 (1.92%) Self-Motivation
9 12 (1.54%) Equities
10 10 (1.28%) Greenfield Project
11 9 (1.15%) Algorithms
11 9 (1.15%) Credit Risk
12 8 (1.02%) Reinsurance
13 6 (0.77%) Driving Licence
13 6 (0.77%) Hedge funds
14 5 (0.64%) Analytical Mindset
14 5 (0.64%) Data Protection Act
14 5 (0.64%) Equity Derivative
14 5 (0.64%) FMCG
14 5 (0.64%) SWIFT
Operating Systems
1 77 (9.86%) Windows
2 44 (5.63%) Linux
3 20 (2.56%) Windows Server
4 12 (1.54%) Unix
5 9 (1.15%) Windows 7
6 8 (1.02%) Windows Server 2012
7 3 (0.38%) Windows 10
8 2 (0.26%) Android
9 1 (0.13%) Solaris
9 1 (0.13%) Windows 8
9 1 (0.13%) Windows XP
Processes & Methodologies
1 167 (21.38%) Business Intelligence
2 151 (19.33%) Analytics
3 108 (13.83%) Agile Software Development
4 107 (13.70%) Problem-Solving
5 100 (12.80%) Data Analysis
6 86 (11.01%) Visualisation
7 66 (8.45%) ETL
8 64 (8.19%) Mentoring
9 63 (8.07%) Test Automation
10 60 (7.68%) Project Management
11 59 (7.55%) Data Visualisation
12 57 (7.30%) Coaching
13 51 (6.53%) Stakeholder Management
14 46 (5.89%) Mathematics
14 46 (5.89%) Time Management
15 44 (5.63%) CRM
16 43 (5.51%) Computer Science
16 43 (5.51%) Data Analytics
16 43 (5.51%) SDLC
17 40 (5.12%) Data Modelling
Programming Languages
1 549 (70.29%) SQL
2 220 (28.17%) Python
3 211 (27.02%) C#
4 117 (14.98%) T-SQL
5 115 (14.72%) VB
6 85 (10.88%) R
7 82 (10.50%) Java
8 69 (8.83%) PowerShell
9 54 (6.91%) PHP
10 48 (6.15%) VB.NET
11 46 (5.89%) C++
12 40 (5.12%) PL/SQL
13 35 (4.48%) JavaScript
14 24 (3.07%) C
15 17 (2.18%) VBScript
16 14 (1.79%) Shell Script
17 12 (1.54%) Apex Code
17 12 (1.54%) VB6
18 9 (1.15%) Perl
19 8 (1.02%) TypeScript
Qualifications
1 138 (17.67%) Degree
2 31 (3.97%) Computer Science Degree
3 15 (1.92%) SC Cleared
3 15 (1.92%) Security Cleared
4 12 (1.54%) Numerate Degree
5 11 (1.41%) Master's Degree
6 9 (1.15%) ISEB
6 9 (1.15%) Microsoft Certification
7 7 (0.90%) CIMA
8 6 (0.77%) DV Cleared
8 6 (0.77%) IIBA
8 6 (0.77%) ISTQB
9 4 (0.51%) ACCA
9 4 (0.51%) MCSE
9 4 (0.51%) Six Sigma Green Belt
10 3 (0.38%) ITIL Foundation Certificate
11 2 (0.26%) TOGAF Certification
12 1 (0.13%) MCP
12 1 (0.13%) MCSA
12 1 (0.13%) PhD
Quality Assurance & Compliance
1 32 (4.10%) QA
2 29 (3.71%) Data Quality
3 9 (1.15%) GDPR
4 5 (0.64%) EMIR
4 5 (0.64%) PMO
5 4 (0.51%) COBIT
5 4 (0.51%) ISO/IEC 27001
5 4 (0.51%) MiFID
6 3 (0.38%) Sarbanes-Oxley
6 3 (0.38%) SLA
7 2 (0.26%) BS7799
7 2 (0.26%) IFRS
7 2 (0.26%) P3O
8 1 (0.13%) IFRS 9
System Software
1 17 (2.18%) Active Directory
2 1 (0.13%) Cronacle
2 1 (0.13%) Virtual Machines
2 1 (0.13%) XenApp
Systems Management
1 13 (1.66%) SCCM
2 3 (0.38%) Icinga
2 3 (0.38%) Prometheus
3 2 (0.26%) Control-M
3 2 (0.26%) EnCase
3 2 (0.26%) FTK
4 1 (0.13%) Ansible
4 1 (0.13%) Backup Exec
4 1 (0.13%) WSUS
Vendors
1 195 (24.97%) Microsoft
2 122 (15.62%) Tableau
3 109 (13.96%) Oracle
4 34 (4.35%) WorldPay
5 27 (3.46%) Salesforce.com
6 25 (3.20%) Bloomberg
6 25 (3.20%) Cisco
7 21 (2.69%) Reuters
8 20 (2.56%) Apple
8 20 (2.56%) Avaya
9 17 (2.18%) Blue Prism
9 17 (2.18%) Xceptor
10 16 (2.05%) Informatica
11 15 (1.92%) Alteryx
11 15 (1.92%) SAP
12 13 (1.66%) Google
12 13 (1.66%) IBM
13 12 (1.54%) Citrix
14 11 (1.41%) Anaplan
15 10 (1.28%) Databricks