Period
to 22 April 2021

The following table provides summary statistics for contract job vacancies advertised in London 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 22 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)
England > London
6 months to
22 Apr 2021
Same period 2020 Same period 2019
Rank 307 283 290
Rank change year-on-year -24 +7 -47
Contract jobs citing VBA 142 175 375
As % of all contract jobs advertised in London 0.64% 0.76% 0.89%
As % of the Programming Languages category 1.34% 1.58% 1.87%
Number of daily rates quoted 95 126 266
10th Percentile £286 £313 £305
25th Percentile £330 £343 £350
Median daily rate (50th Percentile) £425 £475 £425
Median % change year-on-year -10.53% +11.76% -5.56%
75th Percentile £563 £600 £538
90th Percentile £638 £663 £625
England median daily rate £425 £400 £403
% change year-on-year +6.25% -0.68% -5.24%
Number of hourly rates quoted 0 1 10
Median hourly rate - £33.68 £21.00
Median % change year-on-year - +60.36% +16.12%
England median hourly rate £20.00 £22.55 £21.00
% change year-on-year -11.29% +7.36% +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 London with a requirement for coding skills.

All Programming Languages
London
Contract vacancies with a requirement for coding skills 10,620 11,068 20,068
As % of all contract IT jobs advertised in London 47.70% 47.90% 47.70%
Number of daily rates quoted 7,918 8,265 15,247
10th Percentile £363 £369 £363
25th Percentile £438 £438 £425
Median daily rate (50th Percentile) £525 £525 £525
75th Percentile £638 £616 £613
90th Percentile £713 £700 £675
England median daily rate £500 £500 £483
% change year-on-year - +3.63% +1.58%
Number of hourly rates quoted 69 82 109
10th Percentile £20.90 £18.30 £18.43
25th Percentile £28.00 £28.06 £21.14
Median hourly rate £44.50 £47.83 £36.00
Median % change year-on-year -6.96% +32.86% +7.46%
75th Percentile £62.00 £61.19 £47.50
90th Percentile £68.07 £69.10 £53.75
England median hourly rate £42.50 £43.25 £42.50
% change year-on-year -1.73% +1.76% +6.25%

VBA
Job Vacancy Trend in London

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

Job vacancy trend for VBA in London

VBA
Contractor Daily Rate Trend in London

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

Daily rate trend for VBA in London

VBA
Daily Rate Histogram in London

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

Daily rate histogram for VBA in London

VBA
Contractor Hourly Rate Trend in London

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

Hourly rate trend for VBA in London

VBA
Contract Job Locations in London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing VBA within the London region over the 6 months to 22 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
Central London +16 22 £463 +12.12% 9
West London +26 2 £400 -8.57% 1
South London - 2 £488 - 1
East London +24 1 £405 -1.82% 3
VBA
England

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

1 87 (61.27%) Microsoft Excel
2 73 (51.41%) SQL
3 62 (43.66%) Finance
4 42 (29.58%) Python
5 40 (28.17%) Front Office
6 34 (23.94%) Banking
7 28 (19.72%) C#
8 23 (16.20%) Analytics
9 22 (15.49%) SQL Server
10 21 (14.79%) Business Intelligence
11 20 (14.08%) .NET
12 19 (13.38%) VB
13 17 (11.97%) Agile Software Development
13 17 (11.97%) Data Analysis
13 17 (11.97%) Degree
13 17 (11.97%) Power Platform
14 16 (11.27%) Microsoft
14 16 (11.27%) Fixed Income
15 15 (10.56%) Power BI
15 15 (10.56%) Visualisation
16 14 (9.86%) R
16 14 (9.86%) C++
16 14 (9.86%) Oracle
17 13 (9.15%) Azure
18 12 (8.45%) Relational Database
18 12 (8.45%) Analytical Skills
18 12 (8.45%) Windows
18 12 (8.45%) Derivative
19 11 (7.75%) Credit Risk
19 11 (7.75%) Microsoft Office

VBA
Co-occurring IT Skills in London 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 (4.93%) Jupyter
2 6 (4.23%) SAS
2 6 (4.23%) SharePoint
3 5 (3.52%) Confluence
4 1 (0.70%) Apache Spark
4 1 (0.70%) BizTalk Server
4 1 (0.70%) Documentum
4 1 (0.70%) MS Exchange
Applications
1 87 (61.27%) Microsoft Excel
2 11 (7.75%) Microsoft Office
3 9 (6.34%) Spreadsheet
4 6 (4.23%) Microsoft PowerPoint
5 2 (1.41%) MS Visio
6 1 (0.70%) Microsoft Project
Business Applications
1 4 (2.82%) thinkFolio
2 3 (2.11%) Markit EDM
3 2 (1.41%) Dynamics GP
3 2 (1.41%) Eagle PACE
3 2 (1.41%) LatentZero
3 2 (1.41%) LongView
3 2 (1.41%) SAP S/4HANA
4 1 (0.70%) Cognos Controller
4 1 (0.70%) Cognos TM1
4 1 (0.70%) Dynamics CRM
4 1 (0.70%) Dynamics NAV
4 1 (0.70%) Maximo
4 1 (0.70%) Sage 200
4 1 (0.70%) SAP Oil and Gas
4 1 (0.70%) SAP PM
4 1 (0.70%) Sentinel
Cloud Services
1 17 (11.97%) Power Platform
2 13 (9.15%) Azure
3 8 (5.63%) AWS
4 4 (2.82%) PowerApps
4 4 (2.82%) SuccessFactors
5 3 (2.11%) Google Sheets
5 3 (2.11%) Power Automate
6 2 (1.41%) AWS Lambda
6 2 (1.41%) Azure Functions
6 2 (1.41%) Azure Stack
6 2 (1.41%) Microsoft 365
6 2 (1.41%) Serverless
6 2 (1.41%) Taleo
7 1 (0.70%) Akamai
7 1 (0.70%) Dynamics 365
7 1 (0.70%) GCP
Communications & Networking
1 2 (1.41%) Firewall
2 1 (0.70%) DNS
2 1 (0.70%) F5 BIG-IP GTM
2 1 (0.70%) Internet
2 1 (0.70%) Wi-Fi
Database & Business Intelligence
1 22 (15.49%) SQL Server
2 15 (10.56%) Power BI
3 12 (8.45%) Relational Database
4 8 (5.63%) Data Warehouse
4 8 (5.63%) MS Access
4 8 (5.63%) Tableau
5 6 (4.23%) RDBMS
5 6 (4.23%) SQL Server Integration Services
6 5 (3.52%) Data Mining
7 4 (2.82%) Apache Hive
7 4 (2.82%) Big Data
7 4 (2.82%) Hadoop
7 4 (2.82%) QlikView
7 4 (2.82%) SQL Server Reporting Services
8 3 (2.11%) HBase
8 3 (2.11%) MySQL
8 3 (2.11%) Pentaho
8 3 (2.11%) PowerPivot
8 3 (2.11%) Spotfire
9 2 (1.41%) Oracle Reports
Development Applications
1 7 (4.93%) JIRA
2 3 (2.11%) Bitbucket
2 3 (2.11%) Eclipse
2 3 (2.11%) Git (software)
2 3 (2.11%) Jenkins
3 2 (1.41%) SQL Server Management Studio (SSMS)
4 1 (0.70%) LSMW
4 1 (0.70%) Visual Studio
General
1 62 (43.66%) Finance
2 40 (28.17%) Front Office
3 34 (23.94%) Banking
4 8 (5.63%) Investment Banking
5 4 (2.82%) Legal
5 4 (2.82%) Public Sector
6 3 (2.11%) Publishing
7 2 (1.41%) Marketing
7 2 (1.41%) Retail
8 1 (0.70%) Billing
8 1 (0.70%) Financial Institution
8 1 (0.70%) Pharmaceutical
Job Titles
1 61 (42.96%) Developer
2 40 (28.17%) Analyst
3 24 (16.90%) VBA Developer
4 14 (9.86%) Consultant
5 11 (7.75%) Business Analyst
5 11 (7.75%) Excel Developer
6 10 (7.04%) Data Analyst
7 9 (6.34%) C# Developer
8 7 (4.93%) Python Developer
8 7 (4.93%) Qualitative Analyst
8 7 (4.93%) Quantitative Analyst
8 7 (4.93%) Risk Analyst
9 6 (4.23%) .NET Developer
9 6 (4.23%) Data Engineer
9 6 (4.23%) Excel VBA Developer
9 6 (4.23%) Front Office Developer
9 6 (4.23%) SQL Developer
10 5 (3.52%) Business Intelligence Developer
10 5 (3.52%) Senior Developer
10 5 (3.52%) VB Developer
Libraries, Frameworks & Software Standards
1 20 (14.08%) .NET
2 9 (6.34%) HTML
2 9 (6.34%) XML
3 5 (3.52%) NumPy
3 5 (3.52%) Pandas
3 5 (3.52%) scikit-learn
3 5 (3.52%) SciPy
4 4 (2.82%) .NET Framework
4 4 (2.82%) CSS
5 3 (2.11%) .NET Core
5 3 (2.11%) Ajax
5 3 (2.11%) ASP.NET Web API
5 3 (2.11%) Razor View Engine
5 3 (2.11%) Web Services
5 3 (2.11%) WinForms
6 2 (1.41%) D3.js
6 2 (1.41%) JSON
6 2 (1.41%) Shiny
6 2 (1.41%) WPF
7 1 (0.70%) HTML5
Miscellaneous
1 16 (11.27%) Fixed Income
2 12 (8.45%) Analytical Skills
2 12 (8.45%) Derivative
3 11 (7.75%) Credit Risk
4 10 (7.04%) Equities
5 9 (6.34%) Market Risk
6 5 (3.52%) Foreign Exchange (FX)
6 5 (3.52%) Swaptions
7 4 (2.82%) User Experience
8 3 (2.11%) Reference Data
8 3 (2.11%) Reinsurance
9 2 (1.41%) Algorithms
9 2 (1.41%) Cloud Native
9 2 (1.41%) Equity Derivative
9 2 (1.41%) Management Information System
9 2 (1.41%) Self-Motivation
9 2 (1.41%) Social Media
10 1 (0.70%) Mainframe
10 1 (0.70%) NHS
10 1 (0.70%) Robotics
Operating Systems
1 12 (8.45%) Windows
2 6 (4.23%) Linux
3 4 (2.82%) Unix
4 1 (0.70%) Red Hat Enterprise Linux
4 1 (0.70%) Solaris
4 1 (0.70%) Windows 7
4 1 (0.70%) Windows Server 2008
Processes & Methodologies
1 23 (16.20%) Analytics
2 21 (14.79%) Business Intelligence
3 17 (11.97%) Agile Software Development
3 17 (11.97%) Data Analysis
4 15 (10.56%) Visualisation
5 11 (7.75%) Requirements Gathering
5 11 (7.75%) Validation
6 10 (7.04%) Continuous Integration
6 10 (7.04%) Data Management
6 10 (7.04%) Data Visualisation
6 10 (7.04%) Investment Management
6 10 (7.04%) Test Automation
7 9 (6.34%) Data Science
7 9 (6.34%) Risk Management
7 9 (6.34%) Stakeholder Management
7 9 (6.34%) Statistics
8 8 (5.63%) Asset Management
8 8 (5.63%) Migration
8 8 (5.63%) Statistical Analysis
8 8 (5.63%) User Acceptance Testing
Programming Languages
1 73 (51.41%) SQL
2 42 (29.58%) Python
3 28 (19.72%) C#
4 19 (13.38%) VB
5 14 (9.86%) C++
5 14 (9.86%) R
6 9 (6.34%) JavaScript
7 8 (5.63%) Java
8 7 (4.93%) PL/SQL
8 7 (4.93%) PowerShell
9 6 (4.23%) Perl
10 5 (3.52%) T-SQL
11 3 (2.11%) HiveQL
11 3 (2.11%) Scala
11 3 (2.11%) Shell Script
12 2 (1.41%) C
12 2 (1.41%) Data Analysis Expressions (DAX)
12 2 (1.41%) VB.NET
12 2 (1.41%) VBScript
Qualifications
1 17 (11.97%) Degree
2 2 (1.41%) CFA
2 2 (1.41%) Microsoft Certification
2 2 (1.41%) Numerate Degree
2 2 (1.41%) SC Cleared
2 2 (1.41%) Security Cleared
3 1 (0.70%) AAT
3 1 (0.70%) BPSS Clearance
3 1 (0.70%) PhD
Quality Assurance & Compliance
1 6 (4.23%) Data Quality
2 4 (2.82%) Basel III
2 4 (2.82%) QA
3 3 (2.11%) Basel II
4 2 (1.41%) CRD IV
5 1 (0.70%) COREP
5 1 (0.70%) GDPR
5 1 (0.70%) IFRS
5 1 (0.70%) MiFID
5 1 (0.70%) PMO
System Software
1 3 (2.11%) HDFS
Systems Management
1 2 (1.41%) Control-M
2 1 (0.70%) Ansible
Vendors
1 16 (11.27%) Microsoft
2 14 (9.86%) Oracle
3 7 (4.93%) Alteryx
3 7 (4.93%) SAP
4 6 (4.23%) Dataiku
5 5 (3.52%) Google
6 3 (2.11%) Bloomberg
6 3 (2.11%) Charles River
6 3 (2.11%) Citrix
6 3 (2.11%) Informatica
6 3 (2.11%) QAD
6 3 (2.11%) Refinitiv
6 3 (2.11%) Talend
6 3 (2.11%) UiPath
6 3 (2.11%) Workday
7 2 (1.41%) Databricks
7 2 (1.41%) Reuters
7 2 (1.41%) Salesforce.com
7 2 (1.41%) Splunk
8 1 (0.70%) Snow