Period
to 30 October 2020

The following table provides summary statistics for contract job vacancies with a requirement for VBA skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited VBA over the 6 months to 30 October 2020 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
30 Oct 2020
Same period 2019 Same period 2018
Rank 330 401 395
Rank change year-on-year +71 -6 -93
Contract jobs citing VBA 214 488 656
As % of all contract jobs advertised in the UK 0.65% 0.57% 0.63%
As % of the Programming Languages category 1.55% 1.37% 1.42%
Number of daily rates quoted 152 328 442
Median daily rate £450 £450 £400
Median daily rate % change year-on-year - +12.50% -9.09%
10th Percentile £250 £285 £263
90th Percentile £650 £614 £662
UK excluding London median daily rate £425 £400 £360
% change year-on-year +6.25% +11.11% +2.86%
Number of hourly rates quoted 11 26 12
Median hourly rate £21.80 £20.50 £18.00
Median hourly rate % change year-on-year +6.34% +13.89% -23.38%
10th Percentile £14.00 £14.75 £14.75
90th Percentile £35.00 £36.50 £30.00
UK excluding London median hourly rate £19.25 £19.31 £19.50
% change year-on-year -0.31% -0.97% -13.33%

VBA is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies with a requirement for coding skills.

All Programming Languages
UK
Contract vacancies with a requirement for coding skills 13,815 35,603 46,124
As % of all contract IT jobs advertised in the UK 42.09% 41.95% 44.54%
Number of daily rates quoted 9,062 24,658 32,460
Median daily rate £475 £475 £475
10th Percentile £309 £321 £315
90th Percentile £675 £650 £638
UK excluding London median daily rate £425 £425 £420
% change year-on-year - +1.19% +5.00%
Number of hourly rates quoted 375 695 700
Median hourly rate £35.00 £44.00 £41.81
Median hourly rate % change year-on-year -20.45% +5.25% +4.51%
10th Percentile £13.00 £19.60 £16.25
90th Percentile £55.00 £55.00 £52.50
Median hourly rate £35.00 £43.50 £42.00
% change year-on-year -19.54% +3.57% +3.70%

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
Contractor Daily Rate Trend

3-month moving average daily rate quoted in jobs citing VBA.

Daily rate trend for VBA in the UK

VBA
Daily Rate Histogram

Daily rate distribution for jobs citing VBA over the 6 months to 30 October 2020.

Daily rate histogram for VBA in the UK

VBA
Contractor Hourly Rate Trend

3-month moving average hourly rates quoted in jobs citing VBA.

Hourly rate trend for VBA in the UK

VBA
Hourly Rate Histogram

Hourly rate distribution of jobs citing VBA over the 6 months to 30 October 2020.

Hourly rate histogram for VBA in the UK

VBA
Top 16 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing VBA within the UK over the 6 months to 30 October 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +101 202 £450 - 47
London +79 136 £500 +5.26% 19
UK excluding London +128 63 £425 +6.25% 28
North of England +91 37 £425 +6.25% 7
Work from Home -80 34 £413 -8.33% 3
North West +56 20 £400 - 2
North East +47 11 £438 +2.94% 1
Midlands +60 8 £450 +16.13% 3
Yorkshire +72 6 £375 -11.76% 4
South East +124 5 £270 -33.33% 12
South West +90 5 £500 +21.21% 2
East of England +86 4 £288 -3.99% 2
West Midlands +45 4 £450 +12.50% 2
East Midlands +44 4 £463 +23.33% 1
Scotland +67 3 £319 -28.17% 1
Wales +38 1 - - 1

For the 6 months to 30 October 2020, IT contractor 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 contract job ads with a requirement for VBA.

1 116 (54.21%) Microsoft Excel
2 114 (53.27%) SQL
3 86 (40.19%) Python
4 79 (36.92%) Finance
5 52 (24.30%) Banking
6 46 (21.50%) Microsoft
7 41 (19.16%) Front Office
8 36 (16.82%) Agile Software Development
8 36 (16.82%) C#
9 33 (15.42%) Analytical Skills
10 32 (14.95%) Data Analysis
11 29 (13.55%) JavaScript
11 29 (13.55%) Analytics
12 28 (13.08%) Windows
13 27 (12.62%) MS Access
13 27 (12.62%) Problem-Solving
14 26 (12.15%) SQL Server
14 26 (12.15%) Derivative
15 25 (11.68%) .NET
16 24 (11.21%) Migration
16 24 (11.21%) C++
17 23 (10.75%) Oracle
17 23 (10.75%) Scrum
17 23 (10.75%) Azure
18 22 (10.28%) Visualisation
18 22 (10.28%) Fixed Income
19 21 (9.81%) Business Analysis
19 21 (9.81%) Java
20 20 (9.35%) Business Intelligence
20 20 (9.35%) AWS

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 7 (3.27%) SAS
1 7 (3.27%) SharePoint
2 5 (2.34%) Elasticsearch
2 5 (2.34%) JBoss
2 5 (2.34%) MS Exchange
2 5 (2.34%) Tomcat
3 4 (1.87%) Confluence
3 4 (1.87%) Jetty
3 4 (1.87%) MQSeries
3 4 (1.87%) Oracle Self-Service HR
3 4 (1.87%) Red Hat Fuse
3 4 (1.87%) WebLogic
4 3 (1.40%) Moodle
5 2 (0.93%) IIS
6 1 (0.47%) WebSphere
6 1 (0.47%) WebSphere Application Server
Applications
1 116 (54.21%) Microsoft Excel
2 10 (4.67%) Microsoft Office
3 5 (2.34%) Microsoft PowerPoint
3 5 (2.34%) Spreadsheet
4 2 (0.93%) Microsoft Project
4 2 (0.93%) SPSS
5 1 (0.47%) MS Visio
5 1 (0.47%) Stata
Business Applications
1 4 (1.87%) Sentinel
1 4 (1.87%) Sparx Enterprise Architect
1 4 (1.87%) thinkFolio
2 2 (0.93%) Aligne
2 2 (0.93%) Endur
2 2 (0.93%) Orchestrade
3 1 (0.47%) assyst
3 1 (0.47%) Cognos Business Intelligence
3 1 (0.47%) Dynamics AX
3 1 (0.47%) Findur
3 1 (0.47%) Markit EDM
3 1 (0.47%) Maximo
3 1 (0.47%) Oracle EBS R12
3 1 (0.47%) Oracle Financials
Cloud Services
1 23 (10.75%) Azure
2 20 (9.35%) AWS
3 19 (8.88%) Power Platform
4 14 (6.54%) AWS Lambda
4 14 (6.54%) Azure Functions
4 14 (6.54%) Serverless
5 5 (2.34%) Azure Stack
5 5 (2.34%) Office 365
6 3 (1.40%) OpenShift
7 2 (0.93%) PowerApps
8 1 (0.47%) Amazon EC2
8 1 (0.47%) Azure Data Factory
8 1 (0.47%) Data Lake Analytics
8 1 (0.47%) Dynamics 365
8 1 (0.47%) GitHub
8 1 (0.47%) IaaS
8 1 (0.47%) OneDrive
8 1 (0.47%) PaaS
8 1 (0.47%) Power Automate
8 1 (0.47%) SaaS
Communications & Networking
1 8 (3.74%) F5 BIG-IP GTM
2 5 (2.34%) IP Telephony
2 5 (2.34%) VoIP
3 4 (1.87%) SSH
4 1 (0.47%) 2G
4 1 (0.47%) 3G
4 1 (0.47%) 4G
4 1 (0.47%) 5G
4 1 (0.47%) DNS
4 1 (0.47%) HTTP
4 1 (0.47%) Network Security
4 1 (0.47%) Radio Access Network
4 1 (0.47%) SSL
4 1 (0.47%) UTRAN
Database & Business Intelligence
1 27 (12.62%) MS Access
2 26 (12.15%) SQL Server
3 18 (8.41%) Power BI
4 17 (7.94%) Spotfire
5 14 (6.54%) BusinessObjects
6 11 (5.14%) SQL Server Reporting Services
7 10 (4.67%) Oracle Database
8 9 (4.21%) Data Warehouse
9 8 (3.74%) Qlik Sense
10 6 (2.80%) OLAP
10 6 (2.80%) Tableau
11 5 (2.34%) Hadoop
11 5 (2.34%) PostgreSQL
11 5 (2.34%) SQL Server Integration Services
12 4 (1.87%) MongoDB
12 4 (1.87%) MySQL
12 4 (1.87%) Oracle Reports
12 4 (1.87%) PowerPivot
13 3 (1.40%) Oracle Discoverer
14 2 (0.93%) Snowflake Schema
Development Applications
1 9 (4.21%) Git (software)
2 8 (3.74%) Jenkins
3 6 (2.80%) JIRA
3 6 (2.80%) Subversion
4 5 (2.34%) Selenium
5 4 (1.87%) Ant
5 4 (1.87%) Atlassian Bamboo
5 4 (1.87%) ClearCase
5 4 (1.87%) Cucumber
5 4 (1.87%) Eclipse
5 4 (1.87%) FishEye
5 4 (1.87%) Gradle
5 4 (1.87%) Hudson
5 4 (1.87%) IntelliJ
5 4 (1.87%) JUnit
5 4 (1.87%) Leiningen
5 4 (1.87%) Maven
5 4 (1.87%) Mercurial
5 4 (1.87%) Poseidon for UML
5 4 (1.87%) Vagrant
General
1 79 (36.92%) Finance
2 52 (24.30%) Banking
3 41 (19.16%) Front Office
4 15 (7.01%) Public Sector
5 10 (4.67%) Investment Banking
6 7 (3.27%) Retail
7 6 (2.80%) Financial Institution
8 3 (1.40%) Local Government
8 3 (1.40%) Pharmaceutical
9 2 (0.93%) Billing
9 2 (0.93%) Electronics
9 2 (0.93%) French Language
9 2 (0.93%) International Banking
9 2 (0.93%) Manufacturing
9 2 (0.93%) Marketing
9 2 (0.93%) Telecoms
10 1 (0.47%) Advertising
10 1 (0.47%) Back Office
10 1 (0.47%) Law
10 1 (0.47%) Military
Job Titles
1 83 (38.79%) Developer
2 61 (28.50%) Analyst
3 25 (11.68%) Python Developer
4 23 (10.75%) VBA Developer
5 17 (7.94%) Data Analyst
6 16 (7.48%) Business Analyst
6 16 (7.48%) C# Developer
7 12 (5.61%) Data Engineer
7 12 (5.61%) Data Manager
8 11 (5.14%) Azure Developer
9 10 (4.67%) Consultant
10 9 (4.21%) Access Developer
10 9 (4.21%) Front Office Developer
11 8 (3.74%) Qualitative Analyst
11 8 (3.74%) Quantitative Analyst
11 8 (3.74%) SQL Developer
12 7 (3.27%) Access VBA Developer
12 7 (3.27%) Applications Developer
12 7 (3.27%) Excel Developer
12 7 (3.27%) Java Developer
Libraries, Frameworks & Software Standards
1 25 (11.68%) .NET
2 16 (7.48%) HTML
3 12 (5.61%) JSON
4 10 (4.67%) XML
5 9 (4.21%) ASP.NET
5 9 (4.21%) CSS
6 7 (3.27%) AngularJS
6 7 (3.27%) Spring
7 6 (2.80%) .NET Framework
7 6 (2.80%) React
7 6 (2.80%) WinForms
8 5 (2.34%) HTML5
8 5 (2.34%) Spring Boot
8 5 (2.34%) WPF
9 4 (1.87%) Apache Camel
9 4 (1.87%) Node.js
9 4 (1.87%) Play Framework
9 4 (1.87%) RabbitMQ
9 4 (1.87%) REST
9 4 (1.87%) RESTful
Miscellaneous
1 33 (15.42%) Analytical Skills
2 26 (12.15%) Derivative
3 22 (10.28%) Fixed Income
4 14 (6.54%) Foreign Exchange (FX)
5 11 (5.14%) OTC Derivatives
5 11 (5.14%) User Experience
6 10 (4.67%) Hedge funds
7 7 (3.27%) Market Risk
8 6 (2.80%) Equities
9 5 (2.34%) Cloud Native
9 5 (2.34%) Grid Computing
9 5 (2.34%) Mainframe
9 5 (2.34%) Management Information System
10 4 (1.87%) Algorithms
11 3 (1.40%) Data Centre
11 3 (1.40%) NHS
12 2 (0.93%) Blackberry
12 2 (0.93%) Credit Risk
12 2 (0.93%) Reference Data
12 2 (0.93%) Smartphone
Operating Systems
1 28 (13.08%) Windows
2 14 (6.54%) Unix
3 11 (5.14%) AIX
4 9 (4.21%) Apple iOS
5 7 (3.27%) Windows 10
6 5 (2.34%) Linux
6 5 (2.34%) Windows Server
7 4 (1.87%) Android
7 4 (1.87%) CentOS
7 4 (1.87%) Debian
7 4 (1.87%) Mac OS X
7 4 (1.87%) Red Hat Enterprise Linux
7 4 (1.87%) Ubuntu
8 3 (1.40%) Windows 7
9 1 (0.47%) Solaris
9 1 (0.47%) Windows Server 2008
Processes & Methodologies
1 36 (16.82%) Agile Software Development
2 32 (14.95%) Data Analysis
3 29 (13.55%) Analytics
4 27 (12.62%) Problem-Solving
5 24 (11.21%) Migration
6 23 (10.75%) Scrum
7 22 (10.28%) Visualisation
8 21 (9.81%) Business Analysis
9 20 (9.35%) Business Intelligence
9 20 (9.35%) DevOps
10 19 (8.88%) Asset Management
11 18 (8.41%) Continuous Improvement
11 18 (8.41%) Test Automation
12 17 (7.94%) Data Modelling
13 16 (7.48%) Mathematics
14 14 (6.54%) Investment Management
15 13 (6.07%) Machine Learning
16 12 (5.61%) Data Management
16 12 (5.61%) Open Source
16 12 (5.61%) Stakeholder Management
Programming Languages
1 114 (53.27%) SQL
2 86 (40.19%) Python
3 36 (16.82%) C#
4 29 (13.55%) JavaScript
5 24 (11.21%) C++
6 21 (9.81%) Java
7 17 (7.94%) R
8 16 (7.48%) VB
9 12 (5.61%) PowerShell
10 10 (4.67%) MATLAB
11 9 (4.21%) T-SQL
12 5 (2.34%) Bash Shell
12 5 (2.34%) C
12 5 (2.34%) PL/SQL
13 4 (1.87%) Clojure
13 4 (1.87%) ClojureScript
13 4 (1.87%) Groovy
13 4 (1.87%) Perl
13 4 (1.87%) Ruby
13 4 (1.87%) Scala
Qualifications
1 18 (8.41%) Degree
1 18 (8.41%) Security Cleared
2 15 (7.01%) SC Cleared
3 5 (2.34%) Oracle Certification
4 4 (1.87%) DV Cleared
5 3 (1.40%) PhD
6 2 (0.93%) BPSS Clearance
6 2 (0.93%) Master's Degree
6 2 (0.93%) Microsoft Certification
7 1 (0.47%) CFA
7 1 (0.47%) HNC
7 1 (0.47%) HND
7 1 (0.47%) MBA
Quality Assurance & Compliance
1 14 (6.54%) QA
2 6 (2.80%) Data Quality
3 5 (2.34%) GDPR
4 4 (1.87%) PMO
5 1 (0.47%) CRD IV
5 1 (0.47%) IFRS
5 1 (0.47%) IFRS 9
5 1 (0.47%) SLA
System Software
1 2 (0.93%) VMware Infrastructure
1 2 (0.93%) XenApp
1 2 (0.93%) XenDesktop
2 1 (0.47%) Active Directory
2 1 (0.47%) Citrix Hypervisor
2 1 (0.47%) Docker
2 1 (0.47%) Hyper-V
2 1 (0.47%) Microsoft App-V
2 1 (0.47%) Virtual Machines
2 1 (0.47%) VMware Workstation
Systems Management
1 9 (4.21%) Ansible
2 5 (2.34%) Puppet
3 4 (1.87%) Salt
4 3 (1.40%) Kubernetes
4 3 (1.40%) SafeCom
4 3 (1.40%) SCCM
5 2 (0.93%) Kibana
6 1 (0.47%) Control-M
6 1 (0.47%) Failover Clustering
6 1 (0.47%) HP Quality Center
6 1 (0.47%) Opscode Chef
Vendors
1 46 (21.50%) Microsoft
2 23 (10.75%) Oracle
3 19 (8.88%) Bloomberg
4 9 (4.21%) Cognos
5 8 (3.74%) F5
5 8 (3.74%) Infoblox
5 8 (3.74%) Informatica
6 5 (2.34%) Apple
6 5 (2.34%) Red Hat
7 4 (1.87%) Alteryx
7 4 (1.87%) Axway
7 4 (1.87%) Capita
7 4 (1.87%) Charles River
7 4 (1.87%) Cloudera
7 4 (1.87%) Hortonworks
7 4 (1.87%) HP
7 4 (1.87%) MuleSoft
7 4 (1.87%) SAP
7 4 (1.87%) SimCorp
7 4 (1.87%) Sybase