Period
to 26 June 2019

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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
26 Jun 2019
Same period 2018 Same period 2017
Rank 419 385 390
Rank change year-on-year -34 +5 -37
Permanent jobs citing VBA 1,065 1,431 1,421
As % of all permanent IT jobs advertised in the UK 0.74% 0.82% 0.82%
As % of the Programming Languages category 1.37% 1.46% 1.48%
Number of salaries quoted 881 1,197 1,217
UK median annual salary £45,500 £45,000 £45,000
Median salary % change year-on-year +1.11% - -
10th Percentile £25,250 £27,000 £26,250
90th Percentile £81,250 £73,750 £75,000
UK excluding London median annual salary £33,500 £37,500 £35,000
% change year-on-year -10.67% +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 77,963 97,884 95,981
As % of all permanent IT jobs advertised in the UK 53.96% 56.10% 55.28%
Number of salaries quoted 63,837 81,485 81,028
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £31,250 £30,000 £28,750
90th Percentile £85,000 £80,000 £76,250
UK excluding London median annual salary £45,000 £45,000 £42,133
% change year-on-year - +6.81% +5.33%

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 26 June 2019.

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 26 June 2019. 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 -26 1,011 £47,500 +5.56% 48
London -9 591 £57,500 +15.00% 24
UK excluding London -18 470 £33,500 -10.67% 24
South East +9 123 £32,500 -18.75% 6
North of England -22 110 £37,500 +7.14% 8
Midlands +15 75 £34,000 +2.26% 6
South West +36 60 £32,500 -7.14% 5
East of England +11 52 £30,000 -28.57%
North West -19 50 £45,000 +20.00% 7
West Midlands +30 41 £32,500 - 5
Yorkshire -5 39 £32,500 +18.18% 1
Scotland +22 38 £49,000 +8.89%
East Midlands +28 34 £34,000 - 1
North East +29 21 £28,000 -6.67%
Wales +8 10 £36,644 -0.96%
Northern Ireland -26 2 £37,500 +15.38%

For the 6 months to 26 June 2019, 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 742 (69.67%) SQL
2 574 (53.90%) Microsoft Excel
3 457 (42.91%) Finance
4 361 (33.90%) C#
4 361 (33.90%) SQL Server
5 349 (32.77%) Microsoft
6 284 (26.67%) .NET
7 282 (26.48%) Business Intelligence
8 239 (22.44%) Analytical Skills
9 211 (19.81%) Python
10 208 (19.53%) Degree
11 207 (19.44%) SQL Server Reporting Services
12 190 (17.84%) Agile Software Development
13 170 (15.96%) SQL Server Integration Services
14 167 (15.68%) Analytics
15 163 (15.31%) Power BI
15 163 (15.31%) Power Platform
16 162 (15.21%) T-SQL
16 162 (15.21%) Java
17 154 (14.46%) VB
18 147 (13.80%) Microsoft Office
19 143 (13.43%) Problem-Solving
20 140 (13.15%) Microsoft Azure
21 138 (12.96%) HTML
22 136 (12.77%) Tableau
23 133 (12.49%) Data Warehouse
24 129 (12.11%) Data Analysis
25 128 (12.02%) JavaScript
26 124 (11.64%) Visualisation
27 123 (11.55%) Banking

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 102 (9.58%) SharePoint
2 59 (5.54%) SAS
3 12 (1.13%) Apache Spark
4 11 (1.03%) Confluence
5 9 (0.85%) IIS
6 8 (0.75%) MS Exchange
7 6 (0.56%) Tomcat
8 3 (0.28%) Apache
8 3 (0.28%) ArcGIS
8 3 (0.28%) Oracle Workflow
9 2 (0.19%) Apache Airflow
9 2 (0.19%) Oracle Coherence
9 2 (0.19%) WordPress
10 1 (0.094%) CMS
10 1 (0.094%) Exchange Server 2003
10 1 (0.094%) Exchange Server 2010
10 1 (0.094%) Exchange Server 2013
10 1 (0.094%) Umbraco
10 1 (0.094%) WebSphere
10 1 (0.094%) WebSphere Application Server
Applications
1 574 (53.90%) Microsoft Excel
2 147 (13.80%) Microsoft Office
3 29 (2.72%) Microsoft PowerPoint
4 21 (1.97%) Spreadsheet
5 20 (1.88%) Chatbot
6 18 (1.69%) SPSS
7 11 (1.03%) MS Visio
8 7 (0.66%) Microsoft Project
9 6 (0.56%) Stata
10 4 (0.38%) InfoPath
11 1 (0.094%) EViews
11 1 (0.094%) Photoshop
Business Applications
1 16 (1.50%) Dynamics CRM
2 13 (1.22%) Temenos T24
3 6 (0.56%) Cognos TM1
3 6 (0.56%) SAP GTS
4 5 (0.47%) SAP BPC
5 4 (0.38%) Hyperion Planning
5 4 (0.38%) Markit EDM
5 4 (0.38%) Oracle Financials
5 4 (0.38%) Payment Gateway
5 4 (0.38%) thinkFolio
5 4 (0.38%) Workday HCM
6 3 (0.28%) Cognos Controller
6 3 (0.28%) Dynamics NAV
6 3 (0.28%) HFM
6 3 (0.28%) Oracle EBS
7 2 (0.19%) Dynamics AX
7 2 (0.19%) Endur
7 2 (0.19%) SAP InfiniteInsight
7 2 (0.19%) SAP Oil and Gas
7 2 (0.19%) Unit4 Business World
Cloud Services
1 163 (15.31%) Power Platform
2 140 (13.15%) Microsoft Azure
3 52 (4.88%) Amazon AWS
4 22 (2.07%) Office 365
5 20 (1.88%) Cloud Computing
6 16 (1.50%) GitHub
6 16 (1.50%) PaaS
7 13 (1.22%) Azure Functions
7 13 (1.22%) Google Cloud Platform
7 13 (1.22%) Serverless
8 11 (1.03%) SaaS
9 8 (0.75%) Azure Data Factory
10 7 (0.66%) FinancialForce
11 6 (0.56%) OneDrive
12 4 (0.38%) MailChimp
13 3 (0.28%) Google Analytics
13 3 (0.28%) Salesforce Sales Cloud
13 3 (0.28%) Salesforce Service Cloud
14 2 (0.19%) Dynamics 365
14 2 (0.19%) Heroku
Communications & Networking
1 15 (1.41%) VPN
2 14 (1.31%) DNS
3 13 (1.22%) DHCP
4 12 (1.13%) Firewall
5 9 (0.85%) VLAN
6 7 (0.66%) Intranet
6 7 (0.66%) Remote Desktop
7 5 (0.47%) Internet
7 5 (0.47%) LAN
7 5 (0.47%) TCP/IP
8 4 (0.38%) WAN
9 3 (0.28%) HTTP
9 3 (0.28%) HTTPS
9 3 (0.28%) NetScaler
9 3 (0.28%) Wi-Fi
10 2 (0.19%) Cisco ASA
10 2 (0.19%) FIX Connectivity
10 2 (0.19%) IP Telephony
10 2 (0.19%) SMTP
10 2 (0.19%) SNMP
Database & Business Intelligence
1 361 (33.90%) SQL Server
2 207 (19.44%) SQL Server Reporting Services
3 170 (15.96%) SQL Server Integration Services
4 163 (15.31%) Power BI
5 133 (12.49%) Data Warehouse
6 94 (8.83%) SQL Server Analysis Services
7 82 (7.70%) QlikView
8 54 (5.07%) MS Access
9 51 (4.79%) Relational Database
10 50 (4.69%) MySQL
11 47 (4.41%) SQL Server 2012
12 41 (3.85%) Crystal Reports
13 37 (3.47%) BusinessObjects
14 35 (3.29%) SQL Server 2008
15 33 (3.10%) Qlik Sense
16 24 (2.25%) Data Mining
17 23 (2.16%) Hadoop
18 21 (1.97%) OLAP
19 19 (1.78%) Azure SQL Database
19 19 (1.78%) Data Lake
Development Applications
1 37 (3.47%) Git (software)
1 37 (3.47%) Team Foundation Server
2 36 (3.38%) Subversion
3 27 (2.54%) Eclipse
4 21 (1.97%) JIRA
5 19 (1.78%) Visual Studio
6 16 (1.50%) Visual Studio Team System
7 12 (1.13%) IBM UrbanCode
8 8 (0.75%) SQL Server Management Studio (SSMS)
9 7 (0.66%) Toad
10 6 (0.56%) Hudson
11 5 (0.47%) Jenkins
12 4 (0.38%) Bitbucket
13 3 (0.28%) Maven
13 3 (0.28%) Octopus Deploy
13 3 (0.28%) Sonatype Nexus
13 3 (0.28%) TeamCity
14 2 (0.19%) Ant
14 2 (0.19%) Gerrit
14 2 (0.19%) Selenium
General
1 457 (42.91%) Finance
2 123 (11.55%) Banking
3 72 (6.76%) Front Office
4 65 (6.10%) Back Office
5 56 (5.26%) Retail
6 35 (3.29%) Investment Banking
7 33 (3.10%) Law
8 29 (2.72%) Marketing
9 23 (2.16%) French Language
9 23 (2.16%) Legal
10 21 (1.97%) Financial Institution
11 18 (1.69%) Manufacturing
12 15 (1.41%) Telecoms
13 11 (1.03%) Advertising
14 7 (0.66%) Games
14 7 (0.66%) German Language
14 7 (0.66%) Italian Language
14 7 (0.66%) Spanish Language
15 4 (0.38%) Aerospace
15 4 (0.38%) Billing
Job Titles
1 427 (40.09%) Analyst
2 403 (37.84%) Developer
3 154 (14.46%) Data Analyst
4 95 (8.92%) C# Developer
5 91 (8.54%) SQL Developer
6 66 (6.20%) .NET Developer
7 56 (5.26%) Business Intelligence Developer
8 55 (5.16%) SQL Analyst
8 55 (5.16%) VBA Developer
9 53 (4.98%) Junior
10 50 (4.69%) Software Developer
11 49 (4.60%) C# .NET Developer
12 43 (4.04%) Business Intelligence Analyst
13 39 (3.66%) Applications Support
13 39 (3.66%) Risk Analyst
14 37 (3.47%) Report Analyst
15 32 (3.00%) Support Analyst
15 32 (3.00%) Systems Developer
16 31 (2.91%) Graduate
16 31 (2.91%) Quantitative Analyst
Libraries, Frameworks & Software Standards
1 284 (26.67%) .NET
2 138 (12.96%) HTML
3 84 (7.89%) XML
4 67 (6.29%) ASP.NET
5 58 (5.45%) .NET Framework
6 45 (4.23%) CSS
7 37 (3.47%) jQuery
8 36 (3.38%) JSON
9 33 (3.10%) WPF
10 29 (2.72%) Natural Language Processing
11 28 (2.63%) AngularJS
12 23 (2.16%) HTML5
12 23 (2.16%) WCF
12 23 (2.16%) Web Services
13 13 (1.22%) React
13 13 (1.22%) WinForms
14 12 (1.13%) ASP.NET Web API
15 11 (1.03%) ASP.NET MVC
15 11 (1.03%) ODBC
15 11 (1.03%) Twitter Bootstrap
Miscellaneous
1 239 (22.44%) Analytical Skills
2 70 (6.57%) Management Information System
3 63 (5.92%) Derivative
4 51 (4.79%) Self-Motivation
5 34 (3.19%) Data Structures
6 33 (3.10%) Credit Risk
7 32 (3.00%) Robotics
8 23 (2.16%) Hedge funds
9 21 (1.97%) Market Risk
10 20 (1.88%) Fixed Income
11 18 (1.69%) Foreign Exchange (FX)
12 17 (1.60%) Equities
13 14 (1.31%) Greenfield Project
13 14 (1.31%) OTC Derivatives
14 13 (1.22%) Data Protection Act
14 13 (1.22%) Reinsurance
15 12 (1.13%) Algorithms
15 12 (1.13%) Reference Data
16 10 (0.94%) Driving Licence
17 7 (0.66%) EPoS
Operating Systems
1 78 (7.32%) Windows
2 28 (2.63%) Windows Server
3 23 (2.16%) Linux
4 17 (1.60%) Windows 10
4 17 (1.60%) Windows 7
5 15 (1.41%) Unix
6 7 (0.66%) Windows Server 2008
6 7 (0.66%) Windows Server 2012
7 6 (0.56%) Windows 2000
8 3 (0.28%) Mac OS X
8 3 (0.28%) VMS
9 2 (0.19%) AIX
9 2 (0.19%) Ubuntu
9 2 (0.19%) Windows 8
9 2 (0.19%) Windows Server 2003
10 1 (0.094%) OS/2
Processes & Methodologies
1 282 (26.48%) Business Intelligence
2 190 (17.84%) Agile Software Development
3 167 (15.68%) Analytics
4 143 (13.43%) Problem-Solving
5 129 (12.11%) Data Analysis
6 124 (11.64%) Visualisation
7 109 (10.23%) ETL
8 104 (9.77%) Project Management
9 92 (8.64%) Mathematics
10 84 (7.89%) Computer Science
10 84 (7.89%) Risk Management
11 80 (7.51%) Data Visualisation
12 75 (7.04%) SDLC
13 74 (6.95%) Data Management
14 69 (6.48%) Data Analytics
14 69 (6.48%) Machine Learning
15 67 (6.29%) Data Modelling
15 67 (6.29%) Stakeholder Management
16 66 (6.20%) Test Automation
17 60 (5.63%) Asset Management
Programming Languages
1 742 (69.67%) SQL
2 361 (33.90%) C#
3 211 (19.81%) Python
4 162 (15.21%) Java
4 162 (15.21%) T-SQL
5 154 (14.46%) VB
6 128 (12.02%) JavaScript
7 88 (8.26%) R
7 88 (8.26%) VB.NET
8 78 (7.32%) PowerShell
9 69 (6.48%) C++
10 53 (4.98%) MATLAB
11 35 (3.29%) PHP
12 29 (2.72%) C
13 20 (1.88%) Data Analysis Expressions (DAX)
14 17 (1.60%) PL/SQL
14 17 (1.60%) VBScript
15 14 (1.31%) Perl
16 5 (0.47%) F#
16 5 (0.47%) VB6
Qualifications
1 208 (19.53%) Degree
2 42 (3.94%) Computer Science Degree
3 30 (2.82%) PhD
4 26 (2.44%) CFA
5 17 (1.60%) Microsoft Certification
5 17 (1.60%) Security Cleared
6 15 (1.41%) Numerate Degree
7 12 (1.13%) SC Cleared
8 11 (1.03%) Master's Degree
9 10 (0.94%) HND
10 6 (0.56%) ACCA
10 6 (0.56%) CIMA
11 4 (0.38%) MCSE
12 3 (0.28%) ISEB
13 2 (0.19%) CISA
13 2 (0.19%) HNC
13 2 (0.19%) OCA
13 2 (0.19%) Oracle Certification
14 1 (0.094%) ISEB Practitioner
14 1 (0.094%) ISTQB
Quality Assurance & Compliance
1 87 (8.17%) Data Quality
2 31 (2.91%) QA
3 17 (1.60%) IFRS
4 15 (1.41%) IFRS 9
5 12 (1.13%) CRD IV
6 11 (1.03%) GDPR
7 8 (0.75%) PMO
8 6 (0.56%) SLA
9 4 (0.38%) COBIT
9 4 (0.38%) Solvency II
10 3 (0.28%) MiFID
11 2 (0.19%) EMIR
11 2 (0.19%) ISO/IEC 27001
12 1 (0.094%) PSD2
System Software
1 48 (4.51%) Active Directory
2 15 (1.41%) Hyper-V
3 12 (1.13%) Tivoli Workload Scheduler
4 9 (0.85%) Virtual Machines
4 9 (0.85%) VMware Infrastructure
5 2 (0.19%) Docker
6 1 (0.094%) Cronacle
Systems Management
1 12 (1.13%) Tivoli
2 8 (0.75%) WSUS
3 6 (0.56%) SCCM
4 5 (0.47%) SCVMM
5 4 (0.38%) Kubernetes
6 3 (0.28%) Ansible
6 3 (0.28%) Norton AntiVirus
7 1 (0.094%) AirWatch
7 1 (0.094%) Control-M
7 1 (0.094%) ITRS Geneos
Vendors
1 349 (32.77%) Microsoft
2 136 (12.77%) Tableau
3 110 (10.33%) Oracle
4 43 (4.04%) Blue Prism
5 34 (3.19%) Salesforce.com
6 33 (3.10%) Google
7 32 (3.00%) IBM
8 28 (2.63%) SAP
9 26 (2.44%) Automation Anywhere
9 26 (2.44%) UiPath
10 20 (1.88%) Citrix
11 18 (1.69%) Alteryx
12 11 (1.03%) Sage
12 11 (1.03%) Workday
13 10 (0.94%) Confirmit
13 10 (0.94%) VMware
14 9 (0.85%) Cognos
14 9 (0.85%) iManage
14 9 (0.85%) Informatica
15 8 (0.75%) Hyperion