Period
to 23 April 2021

The following table provides summary statistics for contract job vacancies advertised in England 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 23 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 > England
6 months to
23 Apr 2021
Same period 2020 Same period 2019
Rank 377 364 404
Rank change year-on-year -13 +40 -85
Contract jobs citing VBA 225 303 546
As % of all contract jobs advertised in England 0.52% 0.60% 0.63%
As % of the Programming Languages category 1.27% 1.46% 1.45%
Number of daily rates quoted 157 205 388
10th Percentile £225 £207 £300
25th Percentile £313 £310 £337
Median daily rate (50th Percentile) £425 £400 £403
Median % change year-on-year +6.25% -0.68% -5.24%
75th Percentile £506 £550 £500
90th Percentile £600 £650 £600
UK median daily rate £425 £400 £400
% change year-on-year +6.25% - -5.88%
Number of hourly rates quoted 5 11 12
10th Percentile " £17.83 £16.50
25th Percentile £15.10 £20.26 £16.69
Median hourly rate £20.00 £22.55 £21.00
Median % change year-on-year -11.29% +7.36% +7.69%
75th Percentile £24.64 £32.26 "
90th Percentile £26.66 £55.00 £34.05
UK median hourly rate £18.26 £21.91 £21.00
% change year-on-year -16.65% +4.33% +7.69%

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 advertised in England with a requirement for coding skills.

All Programming Languages
England
Contract vacancies with a requirement for coding skills 17,659 20,692 37,606
As % of all contract IT jobs advertised in England 41.11% 40.99% 43.13%
Number of daily rates quoted 12,594 14,703 26,801
10th Percentile £325 £325 £325
25th Percentile £405 £405 £400
Median daily rate (50th Percentile) £500 £500 £483
Median % change year-on-year - +3.63% +1.58%
75th Percentile £600 £580 £575
90th Percentile £688 £663 £650
UK median daily rate £500 £485 £475
% change year-on-year +3.09% +2.11% +2.70%
Number of hourly rates quoted 370 370 571
10th Percentile £18.25 £17.19 £17.66
25th Percentile £25.00 £21.59 £25.83
Median hourly rate £42.50 £43.25 £42.50
Median % change year-on-year -1.73% +1.76% +6.25%
75th Percentile £51.88 £50.00 £49.50
90th Percentile £58.75 £57.50 £53.75
UK median hourly rate £42.50 £43.00 £42.50
% change year-on-year -1.16% +1.18% +6.25%

VBA
Job Vacancy Trend in England

Job postings citing VBA as a proportion of all IT jobs advertised in England.

Job vacancy trend for VBA in England

VBA
Contractor Daily Rate Trend in England

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

Daily rate trend for VBA in England

VBA
Daily Rate Histogram in England

Daily rate distribution for jobs citing VBA in England over the 6 months to 23 April 2021.

Daily rate histogram for VBA in England

VBA
Contractor Hourly Rate Trend in England

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

Hourly rate trend for VBA in England

VBA
Contract Job Locations in England

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing VBA within the England region over the 6 months to 23 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
London -22 143 £425 -10.53% 29
North of England +44 30 £375 +1.01% 5
South East +65 19 £426 +55.00% 9
North West +24 18 £303 -23.17% 2
Midlands +31 10 £358 +3.92% 6
North East +29 8 £438 +56.25%
West Midlands +24 7 £263 -23.70% 4
South West +23 7 £463 +54.17% 7
Yorkshire +32 4 £396 -3.94% 3
East of England +12 4 £210 -20.75% 7
East Midlands - 3 £358 - 2
VBA
UK

For the 6 months to 23 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 across the England region with a requirement for VBA.

1 140 (62.22%) Microsoft Excel
2 112 (49.78%) SQL
3 79 (35.11%) Finance
4 54 (24.00%) Python
5 40 (17.78%) Front Office
6 39 (17.33%) Business Intelligence
7 34 (15.11%) Banking
7 34 (15.11%) Microsoft
8 33 (14.67%) Analytics
9 32 (14.22%) SQL Server
10 30 (13.33%) C#
11 29 (12.89%) Analytical Skills
12 27 (12.00%) Power Platform
13 25 (11.11%) Data Analysis
13 25 (11.11%) Power BI
14 24 (10.67%) .NET
14 24 (10.67%) VB
14 24 (10.67%) MS Access
15 22 (9.78%) Oracle
15 22 (9.78%) Degree
16 20 (8.89%) Agile Software Development
16 20 (8.89%) Security Cleared
17 18 (8.00%) R
17 18 (8.00%) Data Management
17 18 (8.00%) Migration
17 18 (8.00%) Microsoft Office
17 18 (8.00%) Decision-Making
18 17 (7.56%) Windows
18 17 (7.56%) Statistical Analysis
19 16 (7.11%) Fixed Income

VBA
Co-occurring IT Skills in England 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 12 (5.33%) SAS
2 11 (4.89%) SharePoint
3 8 (3.56%) Jupyter
4 5 (2.22%) Confluence
5 1 (0.44%) Apache
5 1 (0.44%) Apache Spark
5 1 (0.44%) ArcGIS
5 1 (0.44%) BizTalk Server
5 1 (0.44%) Documentum
5 1 (0.44%) MS Exchange
Applications
1 140 (62.22%) Microsoft Excel
2 18 (8.00%) Microsoft Office
3 9 (4.00%) Microsoft PowerPoint
3 9 (4.00%) Spreadsheet
4 3 (1.33%) MS Visio
5 1 (0.44%) Microsoft Project
Business Applications
1 4 (1.78%) thinkFolio
2 3 (1.33%) Markit EDM
2 3 (1.33%) SAP S/4HANA
3 2 (0.89%) Dynamics GP
3 2 (0.89%) Eagle PACE
3 2 (0.89%) LatentZero
3 2 (0.89%) LongView
3 2 (0.89%) Oracle EBS
4 1 (0.44%) Cognos Controller
4 1 (0.44%) Cognos TM1
4 1 (0.44%) Dynamics AX
4 1 (0.44%) Dynamics CRM
4 1 (0.44%) Dynamics NAV
4 1 (0.44%) Maximo
4 1 (0.44%) Sage 200
4 1 (0.44%) SAP Oil and Gas
4 1 (0.44%) SAP PM
4 1 (0.44%) Sentinel
Cloud Services
1 27 (12.00%) Power Platform
2 16 (7.11%) Azure
3 10 (4.44%) AWS
4 4 (1.78%) PowerApps
4 4 (1.78%) SuccessFactors
5 3 (1.33%) Google Sheets
5 3 (1.33%) Power Automate
6 2 (0.89%) AWS Lambda
6 2 (0.89%) Azure Functions
6 2 (0.89%) Azure Stack
6 2 (0.89%) Dynamics 365
6 2 (0.89%) GCP
6 2 (0.89%) Microsoft 365
6 2 (0.89%) Serverless
6 2 (0.89%) Taleo
7 1 (0.44%) Akamai
7 1 (0.44%) GitHub
Communications & Networking
1 2 (0.89%) DNS
1 2 (0.89%) F5 BIG-IP GTM
1 2 (0.89%) Firewall
1 2 (0.89%) Internet
2 1 (0.44%) Cisco Firepower
2 1 (0.44%) DHCP
2 1 (0.44%) Network Security
2 1 (0.44%) SSH
2 1 (0.44%) SSL
2 1 (0.44%) TACACS
2 1 (0.44%) VLAN
2 1 (0.44%) Wi-Fi
Database & Business Intelligence
1 32 (14.22%) SQL Server
2 25 (11.11%) Power BI
3 24 (10.67%) MS Access
4 14 (6.22%) Data Warehouse
5 12 (5.33%) Relational Database
6 11 (4.89%) QlikView
6 11 (4.89%) SQL Server Reporting Services
7 10 (4.44%) SQL Server Integration Services
7 10 (4.44%) Tableau
8 7 (3.11%) BusinessObjects
9 6 (2.67%) RDBMS
9 6 (2.67%) Spotfire
10 5 (2.22%) Data Mining
11 4 (1.78%) Apache Hive
11 4 (1.78%) Big Data
11 4 (1.78%) Hadoop
11 4 (1.78%) Qlik Sense
11 4 (1.78%) SAS Enterprise Guide
12 3 (1.33%) Pentaho
12 3 (1.33%) PowerPivot
Development Applications
1 10 (4.44%) JIRA
2 3 (1.33%) Bitbucket
2 3 (1.33%) Eclipse
2 3 (1.33%) Git (software)
2 3 (1.33%) Jenkins
2 3 (1.33%) ScriptRunner
3 2 (0.89%) SQL Server Management Studio (SSMS)
3 2 (0.89%) Visual Studio
4 1 (0.44%) LSMW
4 1 (0.44%) Oracle APEX
General
1 79 (35.11%) Finance
2 40 (17.78%) Front Office
3 34 (15.11%) Banking
4 13 (5.78%) Public Sector
5 8 (3.56%) Investment Banking
6 5 (2.22%) Legal
6 5 (2.22%) Retail
7 4 (1.78%) Marketing
8 3 (1.33%) Pharmaceutical
8 3 (1.33%) Publishing
9 1 (0.44%) Automotive
9 1 (0.44%) Billing
9 1 (0.44%) Electronics
9 1 (0.44%) Financial Institution
9 1 (0.44%) Law
9 1 (0.44%) Local Government
9 1 (0.44%) Manufacturing
9 1 (0.44%) Telecoms
Job Titles
1 77 (34.22%) Developer
2 72 (32.00%) Analyst
3 37 (16.44%) Data Analyst
4 27 (12.00%) VBA Developer
5 18 (8.00%) Consultant
6 14 (6.22%) Data Engineer
7 12 (5.33%) Excel Developer
8 11 (4.89%) Business Analyst
9 10 (4.44%) Business Intelligence Developer
10 9 (4.00%) C# Developer
10 9 (4.00%) SQL Analyst
11 7 (3.11%) .NET Developer
11 7 (3.11%) Excel Analyst
11 7 (3.11%) Excel VBA Developer
11 7 (3.11%) Python Developer
11 7 (3.11%) Qualitative Analyst
11 7 (3.11%) Quantitative Analyst
11 7 (3.11%) Risk Analyst
11 7 (3.11%) SQL Developer
12 6 (2.67%) Report Analyst
Libraries, Frameworks & Software Standards
1 24 (10.67%) .NET
2 13 (5.78%) XML
3 11 (4.89%) HTML
4 6 (2.67%) Flash
5 5 (2.22%) .NET Framework
5 5 (2.22%) CSS
5 5 (2.22%) NumPy
5 5 (2.22%) Pandas
5 5 (2.22%) scikit-learn
5 5 (2.22%) SciPy
6 4 (1.78%) JSON
6 4 (1.78%) MDX
6 4 (1.78%) Web Services
6 4 (1.78%) WinForms
7 3 (1.33%) .NET Core
7 3 (1.33%) Ajax
7 3 (1.33%) ASP.NET Web API
7 3 (1.33%) D3.js
7 3 (1.33%) Razor View Engine
7 3 (1.33%) Shiny
Miscellaneous
1 29 (12.89%) Analytical Skills
2 16 (7.11%) Fixed Income
3 13 (5.78%) Credit Risk
4 12 (5.33%) Derivative
4 12 (5.33%) Organisational Skills
5 10 (4.44%) Equities
6 9 (4.00%) Market Risk
7 6 (2.67%) Management Information System
7 6 (2.67%) NHS
8 5 (2.22%) Foreign Exchange (FX)
8 5 (2.22%) Swaptions
9 4 (1.78%) Self-Motivation
9 4 (1.78%) User Experience
10 3 (1.33%) Algorithms
10 3 (1.33%) Reference Data
10 3 (1.33%) Reinsurance
10 3 (1.33%) Social Media
11 2 (0.89%) Cloud Native
11 2 (0.89%) Equity Derivative
12 1 (0.44%) Linux Command Line
Operating Systems
1 17 (7.56%) Windows
2 10 (4.44%) Unix
3 7 (3.11%) Linux
4 5 (2.22%) AIX
5 2 (0.89%) Windows Server
6 1 (0.44%) CentOS
6 1 (0.44%) Red Hat Enterprise Linux
6 1 (0.44%) Solaris
6 1 (0.44%) Windows 10
6 1 (0.44%) Windows 7
6 1 (0.44%) Windows Server 2008
6 1 (0.44%) Windows Server 2012
Processes & Methodologies
1 39 (17.33%) Business Intelligence
2 33 (14.67%) Analytics
3 25 (11.11%) Data Analysis
4 20 (8.89%) Agile Software Development
5 18 (8.00%) Data Management
5 18 (8.00%) Decision-Making
5 18 (8.00%) Migration
6 17 (7.56%) Statistical Analysis
7 16 (7.11%) Visualisation
8 14 (6.22%) Data Modelling
8 14 (6.22%) Requirements Gathering
9 13 (5.78%) Data Migration
9 13 (5.78%) ETL
9 13 (5.78%) Problem-Solving
9 13 (5.78%) Test Automation
9 13 (5.78%) Validation
10 12 (5.33%) Asset Management
10 12 (5.33%) Data Extraction
10 12 (5.33%) Statistics
11 11 (4.89%) User Acceptance Testing
Programming Languages
1 112 (49.78%) SQL
2 54 (24.00%) Python
3 30 (13.33%) C#
4 24 (10.67%) VB
5 18 (8.00%) R
6 14 (6.22%) C++
7 12 (5.33%) JavaScript
7 12 (5.33%) PowerShell
8 10 (4.44%) PL/SQL
9 9 (4.00%) Java
10 7 (3.11%) Perl
10 7 (3.11%) T-SQL
10 7 (3.11%) VBScript
11 4 (1.78%) Data Analysis Expressions (DAX)
12 3 (1.33%) HiveQL
12 3 (1.33%) Scala
12 3 (1.33%) Shell Script
12 3 (1.33%) VB.NET
13 2 (0.89%) C
14 1 (0.44%) PHP
Qualifications
1 22 (9.78%) Degree
2 20 (8.89%) Security Cleared
3 16 (7.11%) SC Cleared
4 2 (0.89%) AAT
4 2 (0.89%) BPSS Clearance
4 2 (0.89%) CFA
4 2 (0.89%) Microsoft Certification
4 2 (0.89%) Numerate Degree
5 1 (0.44%) ACCA
5 1 (0.44%) CIMA
5 1 (0.44%) DV Cleared
5 1 (0.44%) Master's Degree
5 1 (0.44%) PhD
Quality Assurance & Compliance
1 12 (5.33%) Data Quality
2 10 (4.44%) QA
3 4 (1.78%) Basel III
3 4 (1.78%) GDPR
4 3 (1.33%) Basel II
4 3 (1.33%) IFRS
5 2 (0.89%) CRD IV
5 2 (0.89%) IFRS 9
6 1 (0.44%) COREP
6 1 (0.44%) Disclosure Scotland
6 1 (0.44%) MiFID
6 1 (0.44%) PMO
System Software
1 3 (1.33%) HDFS
2 1 (0.44%) Active Directory
2 1 (0.44%) KVM
2 1 (0.44%) Snort
2 1 (0.44%) Virtual Machines
Systems Management
1 4 (1.78%) Ansible
2 2 (0.89%) Control-M
3 1 (0.44%) FreeIPA
3 1 (0.44%) NetBackup
3 1 (0.44%) ZABBIX
Vendors
1 34 (15.11%) Microsoft
2 22 (9.78%) Oracle
3 16 (7.11%) SAP
4 8 (3.56%) Alteryx
5 7 (3.11%) Google
5 7 (3.11%) Informatica
6 6 (2.67%) Dataiku
7 4 (1.78%) Citrix
7 4 (1.78%) Salesforce.com
8 3 (1.33%) Bloomberg
8 3 (1.33%) Charles River
8 3 (1.33%) Infoblox
8 3 (1.33%) QAD
8 3 (1.33%) Refinitiv
8 3 (1.33%) Talend
8 3 (1.33%) UiPath
8 3 (1.33%) Workday
9 2 (0.89%) Databricks
9 2 (0.89%) F5
9 2 (0.89%) Tagetik