Period
to 28 July 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 28 July 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
28 Jul 2021
Same period 2020 Same period 2019
Rank 404 323 412
Rank change year-on-year -81 +89 -20
Contract jobs citing VBA 403 261 539
As % of all contract jobs advertised in the UK 0.56% 0.71% 0.59%
As % of the Programming Languages category 1.40% 1.71% 1.38%
Number of daily rates quoted 282 166 369
10th Percentile £210 £250 £285
25th Percentile £313 £318 £350
Median daily rate (50th Percentile) £425 £429 £425
Median % change year-on-year -0.87% +0.88% -
75th Percentile £538 £594 £519
90th Percentile £599 £663 £625
UK excluding London median daily rate £413 £289 £388
% change year-on-year +42.86% -25.48% +10.71%
Number of hourly rates quoted 5 14 19
10th Percentile " £17.75 £16.50
25th Percentile £15.10 £17.83 £16.63
Median hourly rate £19.50 £20.36 £20.50
Median % change year-on-year -4.20% -0.71% +8.64%
75th Percentile £24.64 £31.85 £21.00
90th Percentile £26.66 £60.53 "
UK excluding London median hourly rate £19.50 £20.11 £19.31
% change year-on-year -3.03% +4.14% +1.63%

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 28,808 15,258 39,039
As % of all contract IT jobs advertised in the UK 40.25% 41.23% 42.58%
Number of daily rates quoted 20,398 10,752 27,304
10th Percentile £350 £325 £323
25th Percentile £413 £406 £400
Median daily rate (50th Percentile) £500 £500 £475
Median % change year-on-year - +5.26% +2.70%
75th Percentile £606 £588 £575
90th Percentile £700 £675 £650
UK excluding London median daily rate £450 £450 £425
% change year-on-year - +5.88% +3.03%
Number of hourly rates quoted 472 274 660
10th Percentile £16.15 £16.08 £20.30
25th Percentile £25.00 £21.68 £33.81
Median hourly rate £42.50 £42.50 £44.74
Median % change year-on-year - -5.01% +9.46%
75th Percentile £55.00 £50.00 £51.00
90th Percentile £65.25 £59.40 £55.00
UK excluding London median hourly rate £42.00 £42.50 £45.00
% change year-on-year -1.18% -5.56% +10.77%

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 28 July 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 28 July 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 -61 339 £450 -5.26% 104
London -112 200 £450 -10.00% 50
UK excluding London -29 137 £413 +42.86% 57
Work from Home -189 104 £450 +5.88% 8
North of England -16 41 £225 -0.80% 12
Midlands -18 33 £495 +23.75% 14
North West -10 27 £213 +6.25% 8
West Midlands -15 25 £495 +16.47% 12
South East -41 22 £425 +123.68% 15
East of England 0 15 £325 -35.48% 7
Scotland -66 13 £400 +33.33% 2
South West -19 12 £500 +73.91% 6
North East +6 10 £425 +61.90%
East Midlands -7 8 £458 +14.38% 2
Yorkshire -18 4 £566 +109.88% 4
Wales - 1 £358 - 1

For the 6 months to 28 July 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 263 (65.26%) Microsoft Excel
2 231 (57.32%) SQL
3 159 (39.45%) Finance
4 142 (35.24%) Python
5 100 (24.81%) Analytical Skills
6 95 (23.57%) Social Skills
6 95 (23.57%) Microsoft
7 89 (22.08%) C#
8 78 (19.35%) Analytics
9 73 (18.11%) Business Intelligence
9 73 (18.11%) Agile Software Development
10 68 (16.87%) .NET
11 66 (16.38%) Decision-Making
12 62 (15.38%) Data Analysis
13 59 (14.64%) Oracle
14 58 (14.39%) Java
15 55 (13.65%) SQL Server
16 54 (13.40%) Azure
17 53 (13.15%) R
18 52 (12.90%) Degree
19 50 (12.41%) Banking
19 50 (12.41%) Power Platform
20 49 (12.16%) Power BI
21 48 (11.91%) Problem-Solving
21 48 (11.91%) Visualisation
22 47 (11.66%) QlikView
23 44 (10.92%) Mathematics
23 44 (10.92%) Data Warehouse
24 43 (10.67%) Front Office
25 42 (10.42%) C++

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 39 (9.68%) SharePoint
2 28 (6.95%) Jupyter
3 25 (6.20%) SAS
4 19 (4.71%) Confluence
5 3 (0.74%) IIS
6 2 (0.50%) WebSphere
7 1 (0.25%) Apache
7 1 (0.25%) Documentum
7 1 (0.25%) SharePoint 2010
Applications
1 263 (65.26%) Microsoft Excel
2 38 (9.43%) Microsoft PowerPoint
3 28 (6.95%) Microsoft Office
4 8 (1.99%) Spreadsheet
5 4 (0.99%) Microsoft Project
5 4 (0.99%) MS Visio
Business Applications
1 6 (1.49%) IBM Planning Analytics
2 4 (0.99%) Oracle EBS
2 4 (0.99%) SAP S/4HANA
2 4 (0.99%) thinkFolio
3 3 (0.74%) Markit EDM
4 2 (0.50%) Eagle PACE
4 2 (0.50%) LatentZero
4 2 (0.50%) LongView
4 2 (0.50%) Maximo
4 2 (0.50%) Oracle Applications
4 2 (0.50%) Oracle Financials
5 1 (0.25%) Cognos Controller
5 1 (0.25%) Endur
5 1 (0.25%) Findur
5 1 (0.25%) Misys Opics
5 1 (0.25%) SAP Oil and Gas
5 1 (0.25%) SAP PM
5 1 (0.25%) Sentinel
5 1 (0.25%) Workday HCM
Cloud Services
1 54 (13.40%) Azure
2 50 (12.41%) Power Platform
3 24 (5.96%) AWS
4 9 (2.23%) SaaS
5 8 (1.99%) Microsoft 365
6 7 (1.74%) IaaS
6 7 (1.74%) PaaS
7 6 (1.49%) GCP
7 6 (1.49%) GitHub
8 5 (1.24%) PowerApps
9 4 (0.99%) Cloud Computing
9 4 (0.99%) Power Automate
10 3 (0.74%) Azure Active Directory
10 3 (0.74%) Azure Data Factory
10 3 (0.74%) Google Sheets
11 2 (0.50%) SuccessFactors
12 1 (0.25%) Akamai
12 1 (0.25%) Azure Stack
12 1 (0.25%) Dynamics 365
12 1 (0.25%) Snowflake
Communications & Networking
1 5 (1.24%) DNS
1 5 (1.24%) Internet
1 5 (1.24%) TCP/IP
2 4 (0.99%) FTP
2 4 (0.99%) Kerberos
2 4 (0.99%) Skype
3 3 (0.74%) F5 BIG-IP GTM
4 2 (0.50%) Ethernet
4 2 (0.50%) Network Security
5 1 (0.25%) Cisco Firepower
5 1 (0.25%) DHCP
5 1 (0.25%) Firewall
5 1 (0.25%) SSH
5 1 (0.25%) SSL
5 1 (0.25%) TACACS
5 1 (0.25%) VLAN
5 1 (0.25%) Wi-Fi
Database & Business Intelligence
1 55 (13.65%) SQL Server
2 49 (12.16%) Power BI
3 47 (11.66%) QlikView
4 44 (10.92%) Data Warehouse
5 35 (8.68%) Relational Database
6 33 (8.19%) Tableau
7 27 (6.70%) MySQL
8 26 (6.45%) SQL Server Integration Services
9 24 (5.96%) MS Access
10 17 (4.22%) SQL Server Reporting Services
11 16 (3.97%) RDBMS
12 14 (3.47%) Apache Hive
12 14 (3.47%) Hadoop
12 14 (3.47%) HBase
12 14 (3.47%) Pentaho
13 10 (2.48%) Data Mining
14 9 (2.23%) BusinessObjects
14 9 (2.23%) Metadata
15 7 (1.74%) Qlik Sense
16 6 (1.49%) Oracle Reports
Development Applications
1 40 (9.93%) JIRA
2 29 (7.20%) Git (software)
3 21 (5.21%) Jenkins
4 14 (3.47%) Bitbucket
5 10 (2.48%) TeamCity
6 9 (2.23%) Subversion
7 7 (1.74%) Selenium
8 6 (1.49%) SQL Server Management Studio (SSMS)
8 6 (1.49%) Visual Studio
9 5 (1.24%) Cypress.io
10 3 (0.74%) Eclipse
10 3 (0.74%) PowerDesigner
11 2 (0.50%) Cucumber
11 2 (0.50%) JMeter
11 2 (0.50%) Octopus Deploy
11 2 (0.50%) Postman
11 2 (0.50%) REST Assured
11 2 (0.50%) ScriptRunner
11 2 (0.50%) Serenity BDD
11 2 (0.50%) Toad
General
1 159 (39.45%) Finance
2 100 (24.81%) Analytical Skills
3 95 (23.57%) Social Skills
4 50 (12.41%) Banking
5 43 (10.67%) Front Office
6 29 (7.20%) Public Sector
7 24 (5.96%) Presentation Skills
8 23 (5.71%) Organisational Skills
9 19 (4.71%) Marketing
10 15 (3.72%) Pharmaceutical
11 12 (2.98%) Investment Banking
12 8 (1.99%) Documentation Skills
12 8 (1.99%) Retail
13 7 (1.74%) Legal
14 6 (1.49%) Back Office
15 5 (1.24%) Influencing Skills
16 4 (0.99%) Advertising
17 3 (0.74%) Local Government
17 3 (0.74%) Publishing
17 3 (0.74%) Telecoms
Job Titles
1 132 (32.75%) Developer
2 117 (29.03%) Analyst
3 62 (15.38%) Data Analyst
4 36 (8.93%) C# Developer
5 33 (8.19%) VBA Developer
6 24 (5.96%) Data Engineer
6 24 (5.96%) Excel Developer
7 23 (5.71%) .NET Developer
8 22 (5.46%) Data Scientist
9 18 (4.47%) Excel Analyst
10 17 (4.22%) C# .NET Developer
11 16 (3.97%) Consultant
12 15 (3.72%) SQL Analyst
13 14 (3.47%) Excel VBA Developer
14 13 (3.23%) Python Developer
15 12 (2.98%) SQL Developer
16 11 (2.73%) Business Analyst
16 11 (2.73%) Front Office Developer
16 11 (2.73%) Quantitative Analyst
16 11 (2.73%) Risk Analyst
Libraries, Frameworks & Software Standards
1 68 (16.87%) .NET
2 23 (5.71%) .NET Framework
3 20 (4.96%) HTML
4 18 (4.47%) Shiny
5 17 (4.22%) D3.js
6 13 (3.23%) XML
7 11 (2.73%) Pandas
8 10 (2.48%) NumPy
8 10 (2.48%) scikit-learn
8 10 (2.48%) SciPy
9 9 (2.23%) CSS
10 7 (1.74%) .NET Core
10 7 (1.74%) ASP.NET
10 7 (1.74%) ASP.NET Web API
10 7 (1.74%) JSON
11 6 (1.49%) Ajax
11 6 (1.49%) Razor View Engine
12 5 (1.24%) Regular Expression
13 4 (0.99%) Flash
13 4 (0.99%) REST
Miscellaneous
1 23 (5.71%) Derivative
2 22 (5.46%) Management Information System
3 20 (4.96%) Fixed Income
4 19 (4.71%) Algorithms
5 18 (4.47%) Credit Risk
6 17 (4.22%) Social Media
7 14 (3.47%) FMCG
8 12 (2.98%) Equities
9 11 (2.73%) Market Risk
9 11 (2.73%) NHS
10 9 (2.23%) User Experience
11 8 (1.99%) Swaptions
12 7 (1.74%) Client/Server
12 7 (1.74%) Foreign Exchange (FX)
12 7 (1.74%) Reference Data
12 7 (1.74%) Robotics
12 7 (1.74%) Self-Motivation
13 5 (1.24%) Life Science
13 5 (1.24%) Mobile App
14 3 (0.74%) Data Protection Act
Operating Systems
1 37 (9.18%) Windows
2 25 (6.20%) Unix
3 21 (5.21%) Linux
4 7 (1.74%) AIX
5 6 (1.49%) Windows Server 2008
6 4 (0.99%) Windows Server
7 3 (0.74%) Windows 10
7 3 (0.74%) Windows 7
7 3 (0.74%) Windows Server 2012
8 1 (0.25%) Android
8 1 (0.25%) CentOS
8 1 (0.25%) Debian
8 1 (0.25%) Windows Server 2016
8 1 (0.25%) Windows Server 2019
Processes & Methodologies
1 78 (19.35%) Analytics
2 73 (18.11%) Agile Software Development
2 73 (18.11%) Business Intelligence
3 66 (16.38%) Decision-Making
4 62 (15.38%) Data Analysis
5 48 (11.91%) Problem-Solving
5 48 (11.91%) Visualisation
6 44 (10.92%) Mathematics
7 40 (9.93%) Data Science
8 37 (9.18%) Statistics
9 33 (8.19%) ETL
9 33 (8.19%) Statistical Analysis
10 30 (7.44%) DevOps
10 30 (7.44%) Scrum
11 28 (6.95%) Asset Management
11 28 (6.95%) Machine Learning
11 28 (6.95%) Migration
12 27 (6.70%) Continuous Integration
12 27 (6.70%) Mentoring
13 25 (6.20%) Data Visualisation
Programming Languages
1 231 (57.32%) SQL
2 142 (35.24%) Python
3 89 (22.08%) C#
4 58 (14.39%) Java
5 53 (13.15%) R
6 42 (10.42%) C++
7 33 (8.19%) VB
8 29 (7.20%) JavaScript
8 29 (7.20%) PowerShell
9 25 (6.20%) PL/SQL
10 22 (5.46%) T-SQL
11 20 (4.96%) Shell Script
12 19 (4.71%) VB.NET
13 16 (3.97%) Perl
14 14 (3.47%) HiveQL
14 14 (3.47%) Scala
15 8 (1.99%) VBScript
16 4 (0.99%) C
16 4 (0.99%) MATLAB
17 1 (0.25%) PHP
Qualifications
1 52 (12.90%) Degree
2 28 (6.95%) Security Cleared
3 19 (4.71%) SC Cleared
4 4 (0.99%) CISM
4 4 (0.99%) CISSP
4 4 (0.99%) Computer Science Degree
4 4 (0.99%) ISEB
5 3 (0.74%) Numerate Degree
6 2 (0.50%) BPSS Clearance
6 2 (0.50%) DV Cleared
6 2 (0.50%) ISEB Practitioner
6 2 (0.50%) ISTQB
6 2 (0.50%) ISTQB Foundation Certification
7 1 (0.25%) AAT
7 1 (0.25%) ACCA
7 1 (0.25%) CFA
7 1 (0.25%) CIMA
7 1 (0.25%) MBA
7 1 (0.25%) Tableau Certification
Quality Assurance & Compliance
1 21 (5.21%) QA
2 7 (1.74%) Data Quality
3 6 (1.49%) PMO
4 5 (1.24%) GDPR
5 4 (0.99%) IFRS
5 4 (0.99%) SLA
6 3 (0.74%) Basel III
6 3 (0.74%) CRD IV
6 3 (0.74%) Sarbanes-Oxley
7 2 (0.50%) Accessibility
7 2 (0.50%) MiFID
8 1 (0.25%) Disclosure Scotland
8 1 (0.25%) GPG13
8 1 (0.25%) IFRS 9
System Software
1 14 (3.47%) HDFS
2 11 (2.73%) Active Directory
3 3 (0.74%) VMware Infrastructure
4 2 (0.50%) VMware ESXi
5 1 (0.25%) Docker
5 1 (0.25%) Hyper-V
5 1 (0.25%) KVM
5 1 (0.25%) Snort
5 1 (0.25%) Virtual Desktop
5 1 (0.25%) Virtual Machines
Systems Management
1 8 (1.99%) Ansible
2 4 (0.99%) Control-M
2 4 (0.99%) SCCM
3 3 (0.74%) CSIRT
3 3 (0.74%) EMC NetWorker
3 3 (0.74%) QRadar
3 3 (0.74%) Tivoli
3 3 (0.74%) Tivoli Storage Manager
4 2 (0.50%) Netcool
5 1 (0.25%) FreeIPA
5 1 (0.25%) HP Quality Center
5 1 (0.25%) NetBackup
5 1 (0.25%) OpenView Configuration Management
5 1 (0.25%) SCOM
5 1 (0.25%) ZABBIX
Vendors
1 95 (23.57%) Microsoft
2 59 (14.64%) Oracle
3 41 (10.17%) Alteryx
4 21 (5.21%) Dataiku
4 21 (5.21%) Informatica
5 19 (4.71%) Salesforce.com
6 18 (4.47%) Talend
7 16 (3.97%) SAP
8 14 (3.47%) Google
9 11 (2.73%) IBM
10 8 (1.99%) Cognos
11 6 (1.49%) Automation Anywhere
11 6 (1.49%) Bloomberg
11 6 (1.49%) Citrix
11 6 (1.49%) QAD
11 6 (1.49%) Refinitiv
12 5 (1.24%) Blue Prism
13 4 (0.99%) Infoblox
14 3 (0.74%) F5
14 3 (0.74%) Splunk