Period
to 28 March 2020

The following table provides summary statistics for contract job vacancies advertised in Central 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 28 March 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)
London > Central London
6 months to
28 Mar 2020
Same period 2019 Same period 2018
Rank 151 184 154
Rank change year-on-year +33 -30 +32
Contract jobs citing VBA 52 108 145
As % of all contract jobs advertised in Central London 0.96% 1.21% 1.58%
As % of the Programming Languages category 1.98% 2.30% 3.01%
Number of daily rates quoted 38 76 114
Median daily rate £400 £450 £425
Median daily rate % change year-on-year -11.11% +5.88% +11.84%
10th Percentile £300 £284 £288
90th Percentile £650 £543 £638
London median daily rate £450 £425 £450
% change year-on-year +5.88% -5.56% +5.88%
Number of hourly rates quoted 3 3 0
Median hourly rate £28.00 £21.00 -
Median hourly rate % change year-on-year +33.33% - -
London median hourly rate £28.00 £21.00 £18.09
% change year-on-year +33.33% +16.12% -

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

All Programming Languages
Central London
Contract vacancies with a requirement for coding skills 2,629 4,693 4,814
As % of all contract IT jobs advertised in Central London 48.66% 52.53% 52.38%
Number of daily rates quoted 2,011 3,727 4,041
Median daily rate £525 £525 £515
Median daily rate % change year-on-year - +1.94% +8.42%
10th Percentile £375 £378 £363
90th Percentile £675 £675 £688
London median daily rate £525 £525 £500
% change year-on-year - +5.00% +5.26%
Number of hourly rates quoted 23 14 25
Median hourly rate £35.00 £35.00 £21.50
Median hourly rate % change year-on-year - +62.79% -24.15%
10th Percentile £24.50 £18.24 £17.75
90th Percentile £56.60 £65.95 £67.50
Median hourly rate £44.51 £36.00 £35.00
% change year-on-year +23.64% +2.86% -20.45%

VBA
Job Vacancy Trend in Central London

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

Job vacancy trend for VBA in Central London

VBA
Contractor Daily Rate Trend in Central London

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

Daily rate trend for VBA in Central London

VBA
Daily Rate Histogram in Central London

Daily rate distribution for jobs citing VBA in Central London over the 6 months to 28 March 2020.

Daily rate histogram for VBA in Central London

VBA
Contractor Hourly Rate Trend in Central London

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

Hourly rate trend for VBA in Central London

VBA
Contract Job Locations in Central 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 Central London region over the 6 months to 28 March 2020. 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
City of London +29 44 £425 -6.59% 12
West End of London +22 1 £550 +76.00%
City of Westminster - 1 £550 -
Kensington and Chelsea - 1 - -
VBA
London

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

1 38 (73.08%) Microsoft Excel
2 35 (67.31%) SQL
3 32 (61.54%) .NET
4 31 (59.62%) C#
5 27 (51.92%) Finance
6 17 (32.69%) HTML
7 16 (30.77%) CSS
8 15 (28.85%) ASP.NET
9 14 (26.92%) Oracle
10 13 (25.00%) SQL Server
11 12 (23.08%) QA
12 11 (21.15%) Banking
12 11 (21.15%) WinForms
13 10 (19.23%) VB.NET
13 10 (19.23%) Python
14 9 (17.31%) Data Warehouse
14 9 (17.31%) JavaScript
14 9 (17.31%) Microsoft
15 8 (15.38%) Agile Software Development
15 8 (15.38%) SQL Server Reporting Services
15 8 (15.38%) Business Analysis
15 8 (15.38%) OLAP
15 8 (15.38%) Cognos
16 7 (13.46%) Windows
16 7 (13.46%) Low Latency
17 6 (11.54%) React
17 6 (11.54%) AngularJS
17 6 (11.54%) Analytical Skills
17 6 (11.54%) High Availability
17 6 (11.54%) .NET Core

VBA
Co-occurring IT Skills in Central 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 2 (3.85%) SAS
2 1 (1.92%) CMS
2 1 (1.92%) SharePoint
Applications
1 38 (73.08%) Microsoft Excel
2 4 (7.69%) Microsoft Office
3 2 (3.85%) Spreadsheet
Business Applications
1 1 (1.92%) Dynamics CRM
1 1 (1.92%) Magento
Cloud Services
1 5 (9.62%) Power Platform
2 3 (5.77%) Azure
3 1 (1.92%) AWS
3 1 (1.92%) AWS Lambda
3 1 (1.92%) Azure Data Factory
3 1 (1.92%) Azure Functions
3 1 (1.92%) Azure Stack
3 1 (1.92%) Serverless
3 1 (1.92%) SuccessFactors
Database & Business Intelligence
1 13 (25.00%) SQL Server
2 9 (17.31%) Data Warehouse
3 8 (15.38%) OLAP
3 8 (15.38%) SQL Server Reporting Services
4 5 (9.62%) Power BI
5 3 (5.77%) Oracle Reports
5 3 (5.77%) SQL Server Integration Services
6 1 (1.92%) Data Lake
6 1 (1.92%) Microsoft Power View
6 1 (1.92%) MySQL
6 1 (1.92%) PostgreSQL
6 1 (1.92%) PowerPivot
6 1 (1.92%) RDBMS
6 1 (1.92%) Relational Database
6 1 (1.92%) SAS EBI
6 1 (1.92%) Spotfire
6 1 (1.92%) SQL Server Analysis Services
Development Applications
1 1 (1.92%) Visual Studio
General
1 27 (51.92%) Finance
2 11 (21.15%) Banking
3 6 (11.54%) Front Office
4 4 (7.69%) Public Sector
5 2 (3.85%) International Banking
5 2 (3.85%) Law
6 1 (1.92%) Financial Institution
6 1 (1.92%) Local Government
6 1 (1.92%) Marketing
6 1 (1.92%) Social Science
Job Titles
1 38 (73.08%) Developer
2 19 (36.54%) C# Developer
3 16 (30.77%) .NET Developer
4 15 (28.85%) C# .NET Developer
5 9 (17.31%) VBA Developer
6 8 (15.38%) SQL Developer
7 7 (13.46%) Analyst
7 7 (13.46%) Full Stack Developer
7 7 (13.46%) Junior
7 7 (13.46%) Junior Developer
8 6 (11.54%) Angular Developer
8 6 (11.54%) Applications Developer
8 6 (11.54%) Junior .NET Developer
8 6 (11.54%) Junior C# .NET Developer
8 6 (11.54%) Junior C# Developer
8 6 (11.54%) Junior SQL Developer
9 4 (7.69%) Junior VBA Developer
10 3 (5.77%) Excel Developer
10 3 (5.77%) Excel VBA Developer
11 2 (3.85%) Python Developer
Libraries, Frameworks & Software Standards
1 32 (61.54%) .NET
2 17 (32.69%) HTML
3 16 (30.77%) CSS
4 15 (28.85%) ASP.NET
5 11 (21.15%) WinForms
6 6 (11.54%) .NET Core
6 6 (11.54%) AngularJS
6 6 (11.54%) React
7 4 (7.69%) .NET Framework
8 3 (5.77%) WPF
9 1 (1.92%) cXML
9 1 (1.92%) XML
Miscellaneous
1 6 (11.54%) Analytical Skills
2 4 (7.69%) Self-Motivation
3 2 (3.85%) Derivative
3 2 (3.85%) Fixed Income
4 1 (1.92%) Data Structures
4 1 (1.92%) Enterprise Software
4 1 (1.92%) Linked Data
4 1 (1.92%) Management Information System
Operating Systems
1 7 (13.46%) Windows
2 3 (5.77%) Windows 10
2 3 (5.77%) Windows 7
Processes & Methodologies
1 8 (15.38%) Agile Software Development
1 8 (15.38%) Business Analysis
2 7 (13.46%) Low Latency
3 6 (11.54%) High Availability
4 5 (9.62%) Business Intelligence
4 5 (9.62%) Mathematics
5 4 (7.69%) Change Management
5 4 (7.69%) Computer Science
5 4 (7.69%) Data Analysis
5 4 (7.69%) Physics
5 4 (7.69%) Problem-Solving
5 4 (7.69%) Visualisation
6 3 (5.77%) Analytics
6 3 (5.77%) Data Mapping
6 3 (5.77%) Data Modelling
6 3 (5.77%) Disaster Recovery
6 3 (5.77%) OO
6 3 (5.77%) OOP
6 3 (5.77%) RAD
7 2 (3.85%) GAP Analysis
Programming Languages
1 35 (67.31%) SQL
2 31 (59.62%) C#
3 10 (19.23%) Python
3 10 (19.23%) VB.NET
4 9 (17.31%) JavaScript
5 4 (7.69%) VB
6 3 (5.77%) C++
7 2 (3.85%) T-SQL
8 1 (1.92%) C
8 1 (1.92%) PHP
8 1 (1.92%) PowerShell
8 1 (1.92%) R
8 1 (1.92%) VC++
Qualifications
1 5 (9.62%) Degree
2 1 (1.92%) Numerate Degree
Quality Assurance & Compliance
1 12 (23.08%) QA
2 2 (3.85%) Data Quality
System Software
1 2 (3.85%) Active Directory
Systems Management
1 2 (3.85%) SCCM
Vendors
1 14 (26.92%) Oracle
2 9 (17.31%) Microsoft
3 8 (15.38%) Cognos
4 1 (1.92%) Adobe
4 1 (1.92%) Alteryx
4 1 (1.92%) Tableau