Period
to 14 April 2021

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 14 April 2021 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
14 Apr 2021
Same period 2020 Same period 2019
Rank 387 386 390
Rank change year-on-year -1 +4 -63
Contract jobs citing VBA 277 344 603
As % of all contract jobs advertised in the UK 0.53% 0.58% 0.63%
As % of the Programming Languages category 1.30% 1.43% 1.45%
Number of daily rates quoted 201 234 423
10th Percentile £230 £218 £282
25th Percentile £313 £300 £325
Median daily rate (50th Percentile) £425 £400 £400
Median % change year-on-year +6.25% - -5.88%
75th Percentile £500 £538 £491
90th Percentile £600 £638 £588
UK excluding London median daily rate £425 £342 £388
% change year-on-year +24.45% -11.87% +10.71%
Number of hourly rates quoted 4 14 12
10th Percentile £16.65 £17.83 "
25th Percentile £18.48 £19.78 £16.50
Median hourly rate £22.32 £21.91 £19.56
Median % change year-on-year +1.87% +12.04% +0.28%
75th Percentile £25.48 £28.94 £21.00
90th Percentile £26.99 £49.15 £34.05
UK excluding London median hourly rate £22.32 £21.32 £17.81
% change year-on-year +4.69% +19.74% -10.98%

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 21,379 24,116 41,546
As % of all contract IT jobs advertised in the UK 40.55% 40.53% 43.08%
Number of daily rates quoted 15,062 16,967 29,372
10th Percentile £325 £325 £323
25th Percentile £400 £400 £394
Median daily rate (50th Percentile) £500 £482 £475
Median % change year-on-year +3.69% +1.52% +2.70%
75th Percentile £588 £575 £575
90th Percentile £675 £650 £650
UK excluding London median daily rate £425 £445 £425
% change year-on-year -4.49% +4.71% +6.25%
Number of hourly rates quoted 461 461 635
10th Percentile £15.46 £17.25 £17.03
25th Percentile £25.00 £22.50 £24.38
Median hourly rate £42.50 £43.50 £42.50
Median % change year-on-year -2.30% +2.35% +6.25%
75th Percentile £50.00 £50.00 £48.75
90th Percentile £61.00 £56.50 £53.75
UK excluding London median hourly rate £40.00 £42.50 £42.81
% change year-on-year -5.88% -0.72% +7.02%

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 14 April 2021.

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
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 14 April 2021. 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 +25 236 £425 +3.03% 59
London -4 146 £425 -10.53% 28
UK excluding London +24 86 £425 +24.45% 32
Work from Home -190 68 £444 -1.39% 9
North of England +56 41 £425 +9.68% 6
North West +33 20 £305 -23.75% 2
North East +38 17 £438 +56.25%
South East +58 16 £450 +60.00% 7
Midlands +28 8 £358 +3.92% 8
South West +45 7 £463 +54.17% 5
Scotland -24 6 £425 +21.43% 1
West Midlands +23 5 £263 -23.70% 6
East of England +18 5 £210 -20.75% 4
Yorkshire +38 4 £396 -3.94% 4
Wales +22 3 £251 - 1
East Midlands - 3 £358 - 2

For the 6 months to 14 April 2021, 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 168 (60.65%) Microsoft Excel
2 140 (50.54%) SQL
3 93 (33.57%) Finance
4 66 (23.83%) Python
5 47 (16.97%) Microsoft
6 46 (16.61%) Business Intelligence
7 43 (15.52%) SQL Server
8 42 (15.16%) Banking
9 41 (14.80%) Analytical Skills
10 40 (14.44%) Front Office
10 40 (14.44%) MS Access
11 37 (13.36%) Analytics
12 35 (12.64%) C#
12 35 (12.64%) Power Platform
13 32 (11.55%) Power BI
13 32 (11.55%) Security Cleared
14 30 (10.83%) .NET
14 30 (10.83%) VB
15 29 (10.47%) Oracle
16 28 (10.11%) Data Modelling
16 28 (10.11%) Data Analysis
17 27 (9.75%) Windows
17 27 (9.75%) SC Cleared
18 25 (9.03%) Agile Software Development
19 24 (8.66%) Data Engineering
19 24 (8.66%) Decision-Making
20 23 (8.30%) Unix
20 23 (8.30%) Degree
21 20 (7.22%) Statistical Analysis
21 20 (7.22%) 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 17 (6.14%) SharePoint
2 12 (4.33%) Jupyter
2 12 (4.33%) SAS
3 7 (2.53%) Confluence
4 2 (0.72%) Elasticsearch
4 2 (0.72%) JBoss
4 2 (0.72%) Jetty
4 2 (0.72%) MQSeries
4 2 (0.72%) Oracle Self-Service HR
4 2 (0.72%) Red Hat Fuse
4 2 (0.72%) Tomcat
4 2 (0.72%) WebLogic
5 1 (0.36%) Apache
5 1 (0.36%) Apache Spark
5 1 (0.36%) ArcGIS
5 1 (0.36%) BizTalk Server
5 1 (0.36%) Documentum
5 1 (0.36%) MS Exchange
Applications
1 168 (60.65%) Microsoft Excel
2 20 (7.22%) Microsoft Office
3 11 (3.97%) Spreadsheet
4 10 (3.61%) Microsoft PowerPoint
5 4 (1.44%) MS Visio
6 1 (0.36%) Microsoft Project
Business Applications
1 4 (1.44%) thinkFolio
2 3 (1.08%) Markit EDM
2 3 (1.08%) SAP S/4HANA
3 2 (0.72%) Cognos TM1
3 2 (0.72%) Dynamics GP
3 2 (0.72%) Eagle PACE
3 2 (0.72%) LatentZero
3 2 (0.72%) LongView
3 2 (0.72%) Oracle EBS
3 2 (0.72%) Sparx Enterprise Architect
4 1 (0.36%) Cognos Controller
4 1 (0.36%) Dynamics AX
4 1 (0.36%) Dynamics CRM
4 1 (0.36%) Dynamics NAV
4 1 (0.36%) Maximo
4 1 (0.36%) NetSuite
4 1 (0.36%) Sage 200
4 1 (0.36%) SAP Oil and Gas
4 1 (0.36%) SAP PM
4 1 (0.36%) Sentinel
Cloud Services
1 35 (12.64%) Power Platform
2 19 (6.86%) Azure
3 10 (3.61%) AWS
4 5 (1.81%) PowerApps
5 4 (1.44%) Microsoft 365
5 4 (1.44%) Power Automate
5 4 (1.44%) SuccessFactors
6 3 (1.08%) Dynamics 365
6 3 (1.08%) Google Sheets
7 2 (0.72%) AWS Lambda
7 2 (0.72%) Azure Functions
7 2 (0.72%) Azure Stack
7 2 (0.72%) GCP
7 2 (0.72%) Serverless
7 2 (0.72%) Taleo
8 1 (0.36%) Akamai
8 1 (0.36%) Azure Active Directory
8 1 (0.36%) GitHub
Communications & Networking
1 4 (1.44%) Firewall
1 4 (1.44%) Internet
2 3 (1.08%) F5 BIG-IP GTM
2 3 (1.08%) SSH
3 2 (0.72%) DNS
4 1 (0.36%) Cisco Firepower
4 1 (0.36%) DHCP
4 1 (0.36%) Network Security
4 1 (0.36%) SSL
4 1 (0.36%) TACACS
4 1 (0.36%) VLAN
4 1 (0.36%) Wi-Fi
Database & Business Intelligence
1 43 (15.52%) SQL Server
2 40 (14.44%) MS Access
3 32 (11.55%) Power BI
4 19 (6.86%) BusinessObjects
5 17 (6.14%) Relational Database
6 14 (5.05%) Qlik Sense
6 14 (5.05%) QlikView
6 14 (5.05%) Tableau
7 13 (4.69%) Data Warehouse
8 11 (3.97%) RDBMS
8 11 (3.97%) SQL Server Reporting Services
9 10 (3.61%) SQL Server Integration Services
10 6 (2.17%) Hadoop
11 5 (1.81%) Data Mining
11 5 (1.81%) MySQL
11 5 (1.81%) Spotfire
12 4 (1.44%) Big Data
12 4 (1.44%) DB2
12 4 (1.44%) Oracle Reports
12 4 (1.44%) SAS Enterprise Guide
Development Applications
1 13 (4.69%) JIRA
2 5 (1.81%) Eclipse
2 5 (1.81%) Git (software)
2 5 (1.81%) Jenkins
3 3 (1.08%) Bitbucket
3 3 (1.08%) ScriptRunner
3 3 (1.08%) SQL Server Management Studio (SSMS)
4 2 (0.72%) Atlassian Bamboo
4 2 (0.72%) ClearCase
4 2 (0.72%) Cucumber
4 2 (0.72%) FishEye
4 2 (0.72%) Gradle
4 2 (0.72%) Hudson
4 2 (0.72%) IntelliJ
4 2 (0.72%) Leiningen
4 2 (0.72%) Mercurial
4 2 (0.72%) Poseidon for UML
4 2 (0.72%) Selenium
4 2 (0.72%) Vagrant
4 2 (0.72%) Visual Studio
General
1 93 (33.57%) Finance
2 42 (15.16%) Banking
3 40 (14.44%) Front Office
4 20 (7.22%) Public Sector
5 8 (2.89%) Investment Banking
6 5 (1.81%) Legal
6 5 (1.81%) Retail
7 4 (1.44%) Marketing
8 3 (1.08%) Financial Institution
8 3 (1.08%) Pharmaceutical
8 3 (1.08%) Publishing
9 2 (0.72%) Electronics
9 2 (0.72%) Manufacturing
9 2 (0.72%) Telecoms
10 1 (0.36%) Automotive
10 1 (0.36%) Billing
10 1 (0.36%) General Ledger
10 1 (0.36%) Law
10 1 (0.36%) Local Government
Job Titles
1 85 (30.69%) Developer
2 79 (28.52%) Analyst
3 39 (14.08%) Data Analyst
4 31 (11.19%) Data Engineer
5 28 (10.11%) VBA Developer
6 20 (7.22%) Consultant
7 15 (5.42%) Business Analyst
7 15 (5.42%) C# Developer
8 14 (5.05%) Excel Developer
9 12 (4.33%) .NET Developer
10 10 (3.61%) Business Intelligence Developer
11 9 (3.25%) C# .NET Developer
11 9 (3.25%) Excel Analyst
11 9 (3.25%) Excel VBA Developer
11 9 (3.25%) SQL Analyst
11 9 (3.25%) SQL Developer
12 8 (2.89%) Data Manager
12 8 (2.89%) Python Developer
13 7 (2.53%) Quantitative Analyst
13 7 (2.53%) Risk Analyst
Libraries, Frameworks & Software Standards
1 30 (10.83%) .NET
2 15 (5.42%) XML
3 12 (4.33%) HTML
4 10 (3.61%) NumPy
4 10 (3.61%) Pandas
4 10 (3.61%) scikit-learn
4 10 (3.61%) SciPy
5 8 (2.89%) WinForms
6 7 (2.53%) .NET Framework
6 7 (2.53%) Flash
6 7 (2.53%) JSON
7 5 (1.81%) CSS
7 5 (1.81%) WPF
8 4 (1.44%) HTML5
8 4 (1.44%) MDX
8 4 (1.44%) Web Services
9 3 (1.08%) AngularJS
9 3 (1.08%) ASP.NET
9 3 (1.08%) ASP.NET Web API
9 3 (1.08%) jQuery
Miscellaneous
1 41 (14.80%) Analytical Skills
2 16 (5.78%) Fixed Income
3 13 (4.69%) Credit Risk
3 13 (4.69%) Derivative
4 10 (3.61%) Equities
5 9 (3.25%) Market Risk
6 8 (2.89%) NHS
6 8 (2.89%) User Experience
7 5 (1.81%) Foreign Exchange (FX)
7 5 (1.81%) Management Information System
7 5 (1.81%) Self-Motivation
7 5 (1.81%) Swaptions
8 3 (1.08%) Data Structures
8 3 (1.08%) Reinsurance
9 2 (0.72%) Algorithms
9 2 (0.72%) Cloud Native
9 2 (0.72%) Equity Derivative
9 2 (0.72%) Reference Data
9 2 (0.72%) Social Media
10 1 (0.36%) Video Conferencing
Operating Systems
1 27 (9.75%) Windows
2 23 (8.30%) Unix
3 18 (6.50%) AIX
4 11 (3.97%) Linux
5 3 (1.08%) CentOS
5 3 (1.08%) Red Hat Enterprise Linux
5 3 (1.08%) Windows 10
6 2 (0.72%) Android
6 2 (0.72%) Apple iOS
6 2 (0.72%) Debian
6 2 (0.72%) Mac OS X
6 2 (0.72%) Ubuntu
6 2 (0.72%) Windows Server
7 1 (0.36%) Solaris
7 1 (0.36%) Windows Server 2012
Processes & Methodologies
1 46 (16.61%) Business Intelligence
2 37 (13.36%) Analytics
3 28 (10.11%) Data Analysis
3 28 (10.11%) Data Modelling
4 25 (9.03%) Agile Software Development
5 24 (8.66%) Data Engineering
5 24 (8.66%) Decision-Making
6 20 (7.22%) Data Management
6 20 (7.22%) Statistical Analysis
6 20 (7.22%) Visualisation
7 17 (6.14%) Migration
8 16 (5.78%) Continuous Improvement
8 16 (5.78%) ETL
8 16 (5.78%) Problem-Solving
8 16 (5.78%) Statistics
8 16 (5.78%) Test Automation
9 15 (5.42%) Data Science
9 15 (5.42%) Data Visualisation
10 14 (5.05%) Requirements Gathering
10 14 (5.05%) Validation
Programming Languages
1 140 (50.54%) SQL
2 66 (23.83%) Python
3 35 (12.64%) C#
4 30 (10.83%) VB
5 16 (5.78%) R
6 15 (5.42%) C++
6 15 (5.42%) JavaScript
7 13 (4.69%) PL/SQL
7 13 (4.69%) PowerShell
8 12 (4.33%) Java
9 11 (3.97%) Perl
9 11 (3.97%) T-SQL
10 7 (2.53%) VBScript
11 6 (2.17%) VB.NET
12 5 (1.81%) Scala
13 4 (1.44%) Bash Shell
13 4 (1.44%) Data Analysis Expressions (DAX)
14 3 (1.08%) C
14 3 (1.08%) HiveQL
14 3 (1.08%) Shell Script
Qualifications
1 32 (11.55%) Security Cleared
2 27 (9.75%) SC Cleared
3 23 (8.30%) Degree
4 3 (1.08%) BPSS Clearance
4 3 (1.08%) DV Cleared
5 2 (0.72%) CFA
5 2 (0.72%) Microsoft Certification
5 2 (0.72%) Numerate Degree
6 1 (0.36%) AAT
6 1 (0.36%) Master's Degree
6 1 (0.36%) PhD
Quality Assurance & Compliance
1 18 (6.50%) QA
2 13 (4.69%) Data Quality
3 6 (2.17%) GDPR
4 3 (1.08%) Basel II
4 3 (1.08%) Basel III
4 3 (1.08%) IFRS
5 2 (0.72%) IFRS 9
6 1 (0.36%) COREP
6 1 (0.36%) CRD IV
6 1 (0.36%) Disclosure Scotland
6 1 (0.36%) MiFID
6 1 (0.36%) PMO
6 1 (0.36%) SLA
System Software
1 3 (1.08%) HDFS
2 2 (0.72%) Active Directory
3 1 (0.36%) KVM
3 1 (0.36%) Snort
3 1 (0.36%) Virtual Machines
Systems Management
1 5 (1.81%) Ansible
2 2 (0.72%) Control-M
2 2 (0.72%) Puppet
2 2 (0.72%) Salt
3 1 (0.36%) FreeIPA
3 1 (0.36%) NetBackup
3 1 (0.36%) ZABBIX
Vendors
1 47 (16.97%) Microsoft
2 29 (10.47%) Oracle
3 18 (6.50%) SAP
4 15 (5.42%) Informatica
5 13 (4.69%) Alteryx
6 11 (3.97%) Dataiku
7 7 (2.53%) Google
8 5 (1.81%) Citrix
9 4 (1.44%) Infoblox
9 4 (1.44%) Splunk
9 4 (1.44%) UiPath
10 3 (1.08%) Bloomberg
10 3 (1.08%) Charles River
10 3 (1.08%) F5
10 3 (1.08%) Red Hat
10 3 (1.08%) Sybase
10 3 (1.08%) Talend
10 3 (1.08%) Workday
11 2 (0.72%) Cognos
11 2 (0.72%) Reuters