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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
21 Oct 2019
Same period 2018 Same period 2017
Rank 451 417 425
Rank change year-on-year -34 +8 -47
Permanent jobs citing VBA 906 1,242 1,301
As % of all permanent IT jobs advertised in the UK 0.66% 0.76% 0.75%
As % of the Programming Languages category 1.24% 1.37% 1.35%
Number of salaries quoted 791 1,056 1,099
UK median annual salary £47,500 £45,000 £45,000
Median salary % change year-on-year +5.56% - -
10th Percentile £28,500 £27,500 £26,250
90th Percentile £75,000 £75,000 £78,750
UK excluding London median annual salary £39,000 £37,500 £35,000
% change year-on-year +4.00% +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 73,254 90,879 96,300
As % of all permanent IT jobs advertised in the UK 53.48% 55.56% 55.27%
Number of salaries quoted 60,089 75,617 78,941
UK median annual salary £52,500 £50,000 £48,500
Median salary % change year-on-year +5.00% +3.09% +2.11%
10th Percentile £31,250 £31,250 £29,000
90th Percentile £86,250 £82,500 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% +3.66%

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 21 October 2019.

Salary histogram for VBA in the UK

VBA
Top 15 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 21 October 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 -4 877 £47,500 +5.56% 138
London +19 545 £55,000 +4.76% 55
UK excluding London -69 353 £39,000 +4.00% 91
North of England -5 127 £39,000 +11.43% 15
North West +54 82 £39,500 +12.86% 11
South East -31 78 £38,500 +2.67% 38
East of England +13 45 £45,000 +5.88% 3
Midlands -18 42 £34,000 +0.74% 20
South West +13 39 £35,000 +7.69% 11
Yorkshire -31 31 £35,000 -9.68% 4
West Midlands +4 24 £35,000 +16.67% 13
East Midlands +10 18 £30,000 -20.00% 7
North East +20 14 £28,000 -11.11%
Scotland +8 14 £87,500 +133.33% 5
Wales -24 8 £35,000 - 2

For the 6 months to 21 October 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 655 (72.30%) SQL
2 507 (55.96%) Microsoft Excel
3 401 (44.26%) Finance
4 318 (35.10%) SQL Server
5 310 (34.22%) C#
6 285 (31.46%) Business Intelligence
7 253 (27.92%) .NET
8 220 (24.28%) Microsoft
9 204 (22.52%) SQL Server Integration Services
10 201 (22.19%) T-SQL
11 199 (21.96%) SQL Server Reporting Services
12 188 (20.75%) Analytical Skills
13 176 (19.43%) Python
14 171 (18.87%) Power Platform
15 164 (18.10%) Power BI
16 150 (16.56%) Data Warehouse
16 150 (16.56%) VB
17 146 (16.11%) Banking
18 144 (15.89%) ETL
19 142 (15.67%) Degree
20 141 (15.56%) Visualisation
21 138 (15.23%) Analytics
22 130 (14.35%) Tableau
23 113 (12.47%) Oracle
24 112 (12.36%) Agile Software Development
24 112 (12.36%) Problem-Solving
25 111 (12.25%) Microsoft Office
26 104 (11.48%) Data Analysis
27 102 (11.26%) ASP.NET
28 93 (10.26%) Java

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 74 (8.17%) SharePoint
2 48 (5.30%) SAS
3 23 (2.54%) IIS
4 6 (0.66%) ArcGIS
4 6 (0.66%) Confluence
4 6 (0.66%) MS Exchange
4 6 (0.66%) WordPress
5 4 (0.44%) Apache Spark
5 4 (0.44%) Jupyter
5 4 (0.44%) nginx
6 3 (0.33%) Tomcat
7 2 (0.22%) CMS
7 2 (0.22%) Oracle Coherence
7 2 (0.22%) Oracle Workflow
7 2 (0.22%) SharePoint 2010
8 1 (0.11%) Apache Airflow
8 1 (0.11%) Exchange Server 2010
8 1 (0.11%) SharePoint 2013
Applications
1 507 (55.96%) Microsoft Excel
2 111 (12.25%) Microsoft Office
3 36 (3.97%) Spreadsheet
4 24 (2.65%) Microsoft PowerPoint
5 17 (1.88%) MS Visio
6 10 (1.10%) SPSS
7 9 (0.99%) Microsoft Project
8 6 (0.66%) Chatbot
9 5 (0.55%) InfoPath
10 4 (0.44%) Stata
11 3 (0.33%) SPSS Modeler
12 2 (0.22%) CPLEX
13 1 (0.11%) EViews
13 1 (0.11%) PTC Creo
13 1 (0.11%) Windchill
Business Applications
1 16 (1.77%) Dynamics CRM
2 11 (1.21%) Oracle EBS
3 10 (1.10%) Temenos T24
4 9 (0.99%) Payment Gateway
5 4 (0.44%) Oracle Financials
5 4 (0.44%) SAP GTS
6 3 (0.33%) Cognos TM1
6 3 (0.33%) Hyperion Planning
6 3 (0.33%) NetSuite
7 2 (0.22%) Dynamics AX
7 2 (0.22%) HFM
7 2 (0.22%) Magento
7 2 (0.22%) Markit EDM
7 2 (0.22%) SAP Oil and Gas
7 2 (0.22%) thinkFolio
8 1 (0.11%) CODA-Financials
8 1 (0.11%) Dynamics GP
8 1 (0.11%) Dynamics NAV
8 1 (0.11%) LatentZero
8 1 (0.11%) LongView
Cloud Services
1 171 (18.87%) Power Platform
2 85 (9.38%) Azure
3 33 (3.64%) Office 365
4 21 (2.32%) AWS
5 20 (2.21%) Salesforce Sales Cloud
5 20 (2.21%) Salesforce Service Cloud
6 10 (1.10%) SaaS
7 7 (0.77%) Microsoft Flow
8 6 (0.66%) Serverless
9 5 (0.55%) Dynamics 365
10 4 (0.44%) Azure Data Factory
10 4 (0.44%) Azure Functions
10 4 (0.44%) PaaS
11 3 (0.33%) Google Analytics
11 3 (0.33%) Heroku
11 3 (0.33%) IaaS
11 3 (0.33%) PowerApps
12 2 (0.22%) AWS Lambda
12 2 (0.22%) FinancialForce
12 2 (0.22%) GCP
Communications & Networking
1 12 (1.32%) Cisco IOS
2 7 (0.77%) Intranet
3 5 (0.55%) Firewall
4 4 (0.44%) DNS
4 4 (0.44%) FTP
5 3 (0.33%) TCP/IP
6 2 (0.22%) DHCP
6 2 (0.22%) Ethernet
6 2 (0.22%) Extranet
6 2 (0.22%) HTTP
6 2 (0.22%) HTTPS
6 2 (0.22%) Modbus
6 2 (0.22%) NetScaler
6 2 (0.22%) SMTP
6 2 (0.22%) SNMP
7 1 (0.11%) FIX Connectivity
7 1 (0.11%) ICMP
7 1 (0.11%) Remote Desktop
7 1 (0.11%) Telnet
7 1 (0.11%) Wireless
Database & Business Intelligence
1 318 (35.10%) SQL Server
2 204 (22.52%) SQL Server Integration Services
3 199 (21.96%) SQL Server Reporting Services
4 164 (18.10%) Power BI
5 150 (16.56%) Data Warehouse
6 90 (9.93%) SQL Server Analysis Services
7 60 (6.62%) MS Access
8 51 (5.63%) MySQL
9 49 (5.41%) BusinessObjects
10 40 (4.42%) Relational Database
11 33 (3.64%) QlikView
12 30 (3.31%) OLAP
12 30 (3.31%) SQL Server 2012
13 28 (3.09%) SQL Server 2016
14 27 (2.98%) Oracle Database
15 25 (2.76%) Data Lake
16 24 (2.65%) Crystal Reports
17 23 (2.54%) Azure SQL Data Warehouse
17 23 (2.54%) PowerPivot
18 18 (1.99%) Data Mining
Development Applications
1 53 (5.85%) Git (software)
2 34 (3.75%) Subversion
3 31 (3.42%) Team Foundation Server
4 27 (2.98%) IBM UrbanCode
5 26 (2.87%) Eclipse
6 23 (2.54%) JIRA
7 19 (2.10%) Visual Studio
8 12 (1.32%) Selenium
9 10 (1.10%) Oracle Forms
10 7 (0.77%) SQL Server Management Studio (SSMS)
10 7 (0.77%) WebDriver
11 6 (0.66%) NUnit
12 5 (0.55%) SpecFlow
12 5 (0.55%) Visual Studio Team System
13 4 (0.44%) Hudson
13 4 (0.44%) Redmine
14 3 (0.33%) Bitbucket
14 3 (0.33%) Jenkins
15 2 (0.22%) Moq
15 2 (0.22%) TeamCity
General
1 401 (44.26%) Finance
2 146 (16.11%) Banking
3 69 (7.62%) Front Office
4 56 (6.18%) Back Office
5 48 (5.30%) Retail
6 47 (5.19%) Investment Banking
7 36 (3.97%) Marketing
8 27 (2.98%) Law
9 18 (1.99%) Financial Institution
10 17 (1.88%) Legal
11 14 (1.55%) Manufacturing
12 11 (1.21%) Advertising
12 11 (1.21%) Public Sector
13 10 (1.10%) Billing
14 7 (0.77%) Telecoms
15 3 (0.33%) Automotive
15 3 (0.33%) Games
15 3 (0.33%) Police
15 3 (0.33%) Publishing
16 2 (0.22%) Electronics
Job Titles
1 369 (40.73%) Developer
2 357 (39.40%) Analyst
3 108 (11.92%) Data Analyst
4 103 (11.37%) SQL Developer
5 81 (8.94%) C# Developer
6 61 (6.73%) VBA Developer
7 55 (6.07%) .NET Developer
8 52 (5.74%) Business Intelligence Analyst
9 47 (5.19%) Python Developer
10 46 (5.08%) Business Intelligence Developer
11 45 (4.97%) Junior
12 44 (4.86%) Systems Developer
13 38 (4.19%) C# .NET Developer
13 38 (4.19%) Software Developer
14 35 (3.86%) SSRS Developer
15 34 (3.75%) Software Engineer
16 33 (3.64%) Report Analyst
17 31 (3.42%) Senior Analyst
18 30 (3.31%) Applications Support
19 29 (3.20%) Java Developer
Libraries, Frameworks & Software Standards
1 253 (27.92%) .NET
2 102 (11.26%) ASP.NET
3 91 (10.04%) HTML
4 69 (7.62%) XML
5 54 (5.96%) WPF
6 37 (4.08%) WCF
7 34 (3.75%) CSS
8 29 (3.20%) Web Services
9 24 (2.65%) WinForms
10 23 (2.54%) Visualforce
11 22 (2.43%) jQuery
12 21 (2.32%) JSON
13 20 (2.21%) .NET Framework
13 20 (2.21%) Apache Flex
14 14 (1.55%) AngularJS
14 14 (1.55%) ASP.NET Web Forms
14 14 (1.55%) D3.js
14 14 (1.55%) Google Chart
14 14 (1.55%) Node.js
15 13 (1.43%) HTML5
Miscellaneous
1 188 (20.75%) Analytical Skills
2 55 (6.07%) Management Information System
3 34 (3.75%) Derivative
4 25 (2.76%) Algorithms
4 25 (2.76%) Self-Motivation
5 23 (2.54%) Fixed Income
5 23 (2.54%) Hedge funds
6 21 (2.32%) Robotics
7 20 (2.21%) Reinsurance
8 18 (1.99%) Credit Risk
9 17 (1.88%) Equities
10 13 (1.43%) Market Risk
11 11 (1.21%) Data Structures
11 11 (1.21%) Foreign Exchange (FX)
11 11 (1.21%) User Experience
12 9 (0.99%) Analytical Mindset
13 8 (0.88%) Video Conferencing
14 7 (0.77%) Greenfield Project
15 6 (0.66%) Data Protection Act
16 5 (0.55%) Reference Data
Operating Systems
1 86 (9.49%) Windows
2 25 (2.76%) Linux
3 22 (2.43%) Windows Server
4 18 (1.99%) Windows 7
5 14 (1.55%) Windows Server 2012
6 10 (1.10%) Windows 10
7 7 (0.77%) Unix
8 4 (0.44%) Windows Server 2008
9 3 (0.33%) VMS
10 2 (0.22%) Windows 8
11 1 (0.11%) Android
11 1 (0.11%) OS/2
11 1 (0.11%) Windows Server 2003
11 1 (0.11%) Windows XP
Processes & Methodologies
1 285 (31.46%) Business Intelligence
2 144 (15.89%) ETL
3 141 (15.56%) Visualisation
4 138 (15.23%) Analytics
5 112 (12.36%) Agile Software Development
5 112 (12.36%) Problem-Solving
6 104 (11.48%) Data Analysis
7 86 (9.49%) Project Management
8 74 (8.17%) Data Visualisation
9 73 (8.06%) Data Modelling
10 66 (7.28%) CRM
11 65 (7.17%) SDLC
12 64 (7.06%) Data Management
13 61 (6.73%) Mathematics
14 60 (6.62%) Coaching
15 57 (6.29%) Computer Science
16 56 (6.18%) Test Automation
17 54 (5.96%) Software Engineering
18 50 (5.52%) Stakeholder Management
19 48 (5.30%) Mentoring
Programming Languages
1 655 (72.30%) SQL
2 310 (34.22%) C#
3 201 (22.19%) T-SQL
4 176 (19.43%) Python
5 150 (16.56%) VB
6 93 (10.26%) Java
7 81 (8.94%) R
8 78 (8.61%) JavaScript
9 68 (7.51%) PowerShell
10 65 (7.17%) VB.NET
11 48 (5.30%) C++
12 45 (4.97%) PHP
13 36 (3.97%) PL/SQL
14 28 (3.09%) MATLAB
15 27 (2.98%) Data Analysis Expressions (DAX)
16 23 (2.54%) Apex Code
17 21 (2.32%) C
18 18 (1.99%) VBScript
19 10 (1.10%) TypeScript
20 7 (0.77%) Ruby
Qualifications
1 142 (15.67%) Degree
2 32 (3.53%) Computer Science Degree
3 20 (2.21%) Microsoft Certification
4 18 (1.99%) Master's Degree
5 16 (1.77%) PhD
6 13 (1.43%) CFA
7 12 (1.32%) MCSE
8 7 (0.77%) Numerate Degree
9 6 (0.66%) ISEB
9 6 (0.66%) ISTQB
10 5 (0.55%) Security Cleared
11 4 (0.44%) SC Cleared
12 3 (0.33%) ITIL Foundation Certificate
12 3 (0.33%) MBA
13 2 (0.22%) OCA
13 2 (0.22%) Oracle Certification
14 1 (0.11%) ISEB Practitioner
14 1 (0.11%) ITIL Certification
14 1 (0.11%) MCP
14 1 (0.11%) Six Sigma Black Belt
Quality Assurance & Compliance
1 57 (6.29%) Data Quality
2 35 (3.86%) QA
3 9 (0.99%) CRD IV
3 9 (0.99%) GDPR
4 6 (0.66%) EMIR
4 6 (0.66%) IFRS
4 6 (0.66%) MiFID
5 5 (0.55%) IFRS 9
6 3 (0.33%) COBIT
6 3 (0.33%) PMO
7 2 (0.22%) ISO/IEC 27001
7 2 (0.22%) SLA
8 1 (0.11%) P3O
8 1 (0.11%) PSD2
System Software
1 37 (4.08%) Active Directory
2 27 (2.98%) Tivoli Workload Scheduler
3 9 (0.99%) Hyper-V
4 7 (0.77%) VMware Infrastructure
5 4 (0.44%) Virtual Machines
Systems Management
1 27 (2.98%) Tivoli
2 7 (0.77%) SCCM
3 6 (0.66%) WSUS
4 4 (0.44%) Icinga
4 4 (0.44%) Prometheus
4 4 (0.44%) SCVMM
5 1 (0.11%) Ansible
5 1 (0.11%) Backup Exec
5 1 (0.11%) Control-M
5 1 (0.11%) Kubernetes
5 1 (0.11%) WMI
Vendors
1 220 (24.28%) Microsoft
2 130 (14.35%) Tableau
3 113 (12.47%) Oracle
4 44 (4.86%) Salesforce.com
5 42 (4.64%) IBM
6 21 (2.32%) Alteryx
7 17 (1.88%) Google
7 17 (1.88%) WorldPay
8 16 (1.77%) Bloomberg
9 15 (1.66%) Citrix
10 14 (1.55%) SAP
11 12 (1.32%) Cisco
11 12 (1.32%) Databricks
11 12 (1.32%) VMware
12 11 (1.21%) Informatica
12 11 (1.21%) Reuters
13 10 (1.10%) Automation Anywhere
13 10 (1.10%) Blue Prism
13 10 (1.10%) UiPath
14 9 (0.99%) Confirmit