Period
to 31 May 2020

The following table provides summary statistics for contract job vacancies advertised in the City of 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 31 May 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)
Central London > City of London
6 months to
31 May 2020
Same period 2019 Same period 2018
Rank 116 182 162
Rank change year-on-year +66 -20 -3
Contract jobs citing VBA 39 57 96
As % of all contract jobs advertised in the City of London 1.28% 0.88% 1.39%
As % of the Programming Languages category 2.63% 1.74% 2.63%
Number of daily rates quoted 29 38 75
Median daily rate £475 £513 £400
Median daily rate % change year-on-year -7.32% +28.13% +6.67%
10th Percentile £300 £305 £280
90th Percentile £655 £688 £610
Central London median daily rate £425 £475 £425
% change year-on-year -10.53% +11.76% +13.33%
Number of hourly rates quoted 0 7 0
Median hourly rate - £21.00 -
Central London median hourly rate £32.50 £21.00 -
% change year-on-year +54.76% - -

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 the City of London with a requirement for coding skills.

All Programming Languages
City of London
Contract vacancies with a requirement for coding skills 1,482 3,271 3,652
As % of all contract IT jobs advertised in the City of London 48.48% 50.51% 52.76%
Number of daily rates quoted 1,118 2,653 3,064
Median daily rate £525 £525 £525
10th Percentile £375 £406 £363
90th Percentile £688 £675 £700
Central London median daily rate £525 £525 £513
% change year-on-year - +2.44% +4.86%
Number of hourly rates quoted 18 21 21
Median hourly rate £35.00 £35.00 £21.50
Median hourly rate % change year-on-year - +62.79% -24.15%
10th Percentile £24.20 £21.00 £12.75
90th Percentile £56.80 £56.50 £48.25
Median hourly rate £35.00 £35.00 £21.50
% change year-on-year - +62.79% -24.15%

VBA
Job Vacancy Trend in the City of London

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

Job vacancy trend for VBA in the City of London

VBA
Contractor Daily Rate Trend in the City of London

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

Daily rate trend for VBA in the City of London

VBA
Daily Rate Histogram in the City of London

Daily rate distribution for jobs citing VBA in the City of London over the 6 months to 31 May 2020.

Daily rate histogram for VBA in the City of London

VBA
Contractor Hourly Rate Trend in the City of London

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

Hourly rate trend for VBA in the City of London

For the 6 months to 31 May 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 across the City of London region with a requirement for VBA.

1 32 (82.05%) Microsoft Excel
2 26 (66.67%) SQL
3 24 (61.54%) C#
3 24 (61.54%) .NET
4 20 (51.28%) Finance
5 13 (33.33%) HTML
6 12 (30.77%) CSS
7 11 (28.21%) ASP.NET
7 11 (28.21%) Oracle
8 10 (25.64%) VB.NET
9 9 (23.08%) Agile Software Development
9 9 (23.08%) Python
10 8 (20.51%) SQL Server
10 8 (20.51%) WinForms
11 7 (17.95%) Business Intelligence
11 7 (17.95%) React
12 6 (15.38%) Power BI
12 6 (15.38%) .NET Core
12 6 (15.38%) Power Platform
12 6 (15.38%) High Availability
12 6 (15.38%) Low Latency
12 6 (15.38%) AngularJS
13 5 (12.82%) Analytical Skills
13 5 (12.82%) Front Office
13 5 (12.82%) JavaScript
14 4 (10.26%) Data Modelling
14 4 (10.26%) Validation
14 4 (10.26%) Analytics
14 4 (10.26%) Degree
14 4 (10.26%) Mathematics

VBA
Co-occurring IT Skills in the City of 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 3 (7.69%) SAS
2 1 (2.56%) NetWeaver
Applications
1 32 (82.05%) Microsoft Excel
2 2 (5.13%) Spreadsheet
Business Applications
1 1 (2.56%) Dynamics CRM
1 1 (2.56%) Magento
1 1 (2.56%) SAP BPC
Cloud Services
1 6 (15.38%) Power Platform
2 1 (2.56%) Azure
2 1 (2.56%) Azure Data Factory
2 1 (2.56%) SuccessFactors
Database & Business Intelligence
1 8 (20.51%) SQL Server
2 6 (15.38%) Power BI
3 3 (7.69%) Data Warehouse
3 3 (7.69%) OLAP
3 3 (7.69%) SQL Server Integration Services
3 3 (7.69%) SQL Server Reporting Services
4 2 (5.13%) SAS EBI
5 1 (2.56%) BusinessObjects
5 1 (2.56%) MySQL
5 1 (2.56%) PostgreSQL
5 1 (2.56%) RDBMS
5 1 (2.56%) Relational Database
5 1 (2.56%) SAP BW
5 1 (2.56%) SQL Server Analysis Services
Development Applications
1 1 (2.56%) Visual Studio
General
1 20 (51.28%) Finance
2 5 (12.82%) Front Office
3 3 (7.69%) Banking
4 2 (5.13%) International Banking
5 1 (2.56%) Financial Institution
5 1 (2.56%) Public Sector
Job Titles
1 26 (66.67%) Developer
2 11 (28.21%) C# Developer
3 10 (25.64%) .NET Developer
3 10 (25.64%) C# .NET Developer
4 7 (17.95%) Full Stack Developer
5 6 (15.38%) Analyst
5 6 (15.38%) Angular Developer
5 6 (15.38%) Applications Developer
6 3 (7.69%) SQL Developer
6 3 (7.69%) VBA Developer
7 2 (5.13%) Consultant
7 2 (5.13%) Data Analyst
7 2 (5.13%) Data Scientist
7 2 (5.13%) Excel Developer
7 2 (5.13%) Excel VBA Developer
7 2 (5.13%) Junior
7 2 (5.13%) Junior Developer
7 2 (5.13%) RAD Developer
8 1 (2.56%) Software Developer
8 1 (2.56%) Systems Analyst
Libraries, Frameworks & Software Standards
1 24 (61.54%) .NET
2 13 (33.33%) HTML
3 12 (30.77%) CSS
4 11 (28.21%) ASP.NET
5 8 (20.51%) WinForms
6 7 (17.95%) React
7 6 (15.38%) .NET Core
7 6 (15.38%) AngularJS
8 1 (2.56%) .NET Framework
8 1 (2.56%) ASP.NET Core
8 1 (2.56%) cXML
8 1 (2.56%) Redux
8 1 (2.56%) SignalR
8 1 (2.56%) XML
Miscellaneous
1 5 (12.82%) Analytical Skills
2 2 (5.13%) Derivative
2 2 (5.13%) Fixed Income
3 1 (2.56%) Data Structures
3 1 (2.56%) Enterprise Software
3 1 (2.56%) Management Information System
3 1 (2.56%) Self-Motivation
Operating Systems
1 1 (2.56%) Windows
Processes & Methodologies
1 9 (23.08%) Agile Software Development
2 7 (17.95%) Business Intelligence
3 6 (15.38%) High Availability
3 6 (15.38%) Low Latency
4 4 (10.26%) Analytics
4 4 (10.26%) Data Modelling
4 4 (10.26%) Mathematics
4 4 (10.26%) Validation
5 3 (7.69%) Business Analysis
5 3 (7.69%) Computer Science
5 3 (7.69%) GAP Analysis
5 3 (7.69%) Physics
5 3 (7.69%) RAD
5 3 (7.69%) Visualisation
6 2 (5.13%) Data Architecture
6 2 (5.13%) Data Mapping
6 2 (5.13%) Data Validation
6 2 (5.13%) Migration
6 2 (5.13%) Software Engineering
6 2 (5.13%) Stakeholder Management
Programming Languages
1 26 (66.67%) SQL
2 24 (61.54%) C#
3 10 (25.64%) VB.NET
4 9 (23.08%) Python
5 5 (12.82%) JavaScript
6 2 (5.13%) C++
6 2 (5.13%) R
7 1 (2.56%) ABAP
7 1 (2.56%) C
7 1 (2.56%) PHP
7 1 (2.56%) T-SQL
7 1 (2.56%) VB
7 1 (2.56%) VC++
Qualifications
1 4 (10.26%) Degree
2 1 (2.56%) ITIL Certification
2 1 (2.56%) SAP Certification
Quality Assurance & Compliance
1 4 (10.26%) QA
2 2 (5.13%) Data Quality
Vendors
1 11 (28.21%) Oracle
2 3 (7.69%) Cognos
2 3 (7.69%) Microsoft
3 1 (2.56%) Adobe
3 1 (2.56%) Alteryx
3 1 (2.56%) SAP