Period
to 28 September 2020

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 28 September 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)
England > London
6 months to
28 Sep 2020
Same period 2019 Same period 2018
Rank 218 307 315
Rank change year-on-year +89 +8 -92
Contract jobs citing VBA 137 291 363
As % of all contract jobs advertised in London 1.03% 0.76% 0.79%
As % of the Programming Languages category 2.04% 1.61% 1.58%
Number of daily rates quoted 84 217 246
Median daily rate £525 £475 £450
Median daily rate % change year-on-year +10.53% +5.56% -5.26%
10th Percentile £336 £315 £313
90th Percentile £728 £675 £688
England median daily rate £500 £450 £406
% change year-on-year +11.11% +10.77% -4.41%
Number of hourly rates quoted 3 11 4
Median hourly rate £34.53 £21.00 £18.00
Median hourly rate % change year-on-year +64.43% +16.67% -13.92%
England median hourly rate £22.00 £19.91 £18.00
% change year-on-year +10.52% +10.58% -19.10%

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 6,713 18,063 23,022
As % of all contract IT jobs advertised in London 50.45% 47.48% 50.29%
Number of daily rates quoted 4,660 13,662 17,534
Median daily rate £525 £525 £525
10th Percentile £350 £363 £363
90th Percentile £740 £688 £675
England median daily rate £500 £485 £475
% change year-on-year +3.20% +2.00% +5.56%
Number of hourly rates quoted 70 114 142
Median hourly rate £35.00 £45.00 £39.00
Median hourly rate % change year-on-year -22.22% +15.38% +8.62%
10th Percentile £22.45 £20.92 £18.06
90th Percentile £50.52 £60.38 £62.90
Median hourly rate £35.00 £44.53 £42.27
% change year-on-year -21.41% +5.36% +5.66%

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 28 September 2020.

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
Hourly Rate Histogram in London

Hourly rate distribution of jobs citing VBA in London over the 6 months to 28 September 2020.

Hourly rate histogram 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 28 September 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
Central London +96 17 £475 -9.52% 5
North London - 2 - - 1
East London +49 1 - - 3
South London +34 1 - -
VBA
England

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

1 82 (59.85%) SQL
2 77 (56.20%) Microsoft Excel
3 74 (54.01%) Python
4 69 (50.36%) Finance
5 51 (37.23%) Banking
6 42 (30.66%) Front Office
7 34 (24.82%) Microsoft
8 32 (23.36%) C#
8 32 (23.36%) Agile Software Development
9 31 (22.63%) Data Analysis
10 29 (21.17%) Derivative
11 25 (18.25%) Fixed Income
12 24 (17.52%) .NET
12 24 (17.52%) Analytics
13 23 (16.79%) Scrum
13 23 (16.79%) Migration
13 23 (16.79%) Degree
14 22 (16.06%) Asset Management
15 21 (15.33%) Bloomberg
15 21 (15.33%) Analytical Skills
16 20 (14.60%) Azure
16 20 (14.60%) AWS
17 19 (13.87%) Visualisation
17 19 (13.87%) Business Analysis
18 18 (13.14%) C++
18 18 (13.14%) DevOps
19 17 (12.41%) Test Automation
19 17 (12.41%) JavaScript
20 16 (11.68%) HTML
20 16 (11.68%) Java

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 5 (3.65%) JBoss
1 5 (3.65%) NetWeaver
1 5 (3.65%) Tomcat
2 4 (2.92%) Confluence
2 4 (2.92%) Elasticsearch
2 4 (2.92%) Jetty
2 4 (2.92%) MQSeries
2 4 (2.92%) Oracle Self-Service HR
2 4 (2.92%) Red Hat Fuse
2 4 (2.92%) WebLogic
3 3 (2.19%) SAS
3 3 (2.19%) SharePoint
4 1 (0.73%) IIS
4 1 (0.73%) WebSphere
4 1 (0.73%) WebSphere Application Server
Applications
1 77 (56.20%) Microsoft Excel
2 5 (3.65%) Microsoft Office
3 2 (1.46%) Microsoft PowerPoint
3 2 (1.46%) Microsoft Project
3 2 (1.46%) Spreadsheet
4 1 (0.73%) MS Visio
Business Applications
1 5 (3.65%) SAP BPC
2 4 (2.92%) Distributed Ledger
2 4 (2.92%) Sentinel
2 4 (2.92%) Sparx Enterprise Architect
2 4 (2.92%) thinkFolio
3 2 (1.46%) Aligne
3 2 (1.46%) Endur
3 2 (1.46%) Orchestrade
4 1 (0.73%) Findur
4 1 (0.73%) Markit EDM
Cloud Services
1 20 (14.60%) AWS
1 20 (14.60%) Azure
2 15 (10.95%) AWS Lambda
2 15 (10.95%) Azure Functions
2 15 (10.95%) Serverless
3 10 (7.30%) Power Platform
4 4 (2.92%) Azure Stack
5 3 (2.19%) OpenShift
6 2 (1.46%) Office 365
7 1 (0.73%) Azure Data Factory
Communications & Networking
1 4 (2.92%) SSH
2 2 (1.46%) F5 BIG-IP GTM
3 1 (0.73%) DNS
3 1 (0.73%) HTTP
3 1 (0.73%) SSL
Database & Business Intelligence
1 15 (10.95%) Spotfire
2 13 (9.49%) MS Access
3 11 (8.03%) SQL Server
4 10 (7.30%) Power BI
5 8 (5.84%) Data Warehouse
6 7 (5.11%) Oracle Database
7 6 (4.38%) SQL Server Reporting Services
8 5 (3.65%) OLAP
8 5 (3.65%) SAP BW
9 4 (2.92%) BusinessObjects
9 4 (2.92%) Hadoop
9 4 (2.92%) MongoDB
9 4 (2.92%) MySQL
9 4 (2.92%) PostgreSQL
10 3 (2.19%) RDBMS
10 3 (2.19%) Relational Database
11 2 (1.46%) NoSQL
11 2 (1.46%) SQL Server Integration Services
12 1 (0.73%) GIS
12 1 (0.73%) QlikView
Development Applications
1 8 (5.84%) Git (software)
1 8 (5.84%) Jenkins
2 5 (3.65%) JIRA
2 5 (3.65%) Subversion
3 4 (2.92%) Ant
3 4 (2.92%) Atlassian Bamboo
3 4 (2.92%) ClearCase
3 4 (2.92%) Cucumber
3 4 (2.92%) Eclipse
3 4 (2.92%) FishEye
3 4 (2.92%) Gradle
3 4 (2.92%) Hudson
3 4 (2.92%) IntelliJ
3 4 (2.92%) Leiningen
3 4 (2.92%) Maven
3 4 (2.92%) Mercurial
3 4 (2.92%) Poseidon for UML
3 4 (2.92%) Selenium
3 4 (2.92%) Vagrant
4 3 (2.19%) JUnit
General
1 69 (50.36%) Finance
2 51 (37.23%) Banking
3 42 (30.66%) Front Office
4 15 (10.95%) Investment Banking
5 6 (4.38%) Back Office
6 3 (2.19%) Financial Institution
6 3 (2.19%) Public Sector
6 3 (2.19%) Retail
7 2 (1.46%) Billing
7 2 (1.46%) French Language
7 2 (1.46%) International Banking
8 1 (0.73%) Advertising
8 1 (0.73%) Dutch Language
Job Titles
1 67 (48.91%) Developer
2 36 (26.28%) Analyst
3 22 (16.06%) Python Developer
4 19 (13.87%) VBA Developer
5 12 (8.76%) Azure Developer
5 12 (8.76%) Business Analyst
6 9 (6.57%) C# Developer
6 9 (6.57%) Finance Manager
7 8 (5.84%) Data Analyst
8 7 (5.11%) Access Developer
8 7 (5.11%) Consultant
8 7 (5.11%) Senior Developer
8 7 (5.11%) Senior Python Developer
9 6 (4.38%) Applications Developer
9 6 (4.38%) Fixed Income Business Analyst
9 6 (4.38%) Quantitative Developer
10 5 (3.65%) Excel Developer
10 5 (3.65%) Front Office Developer
10 5 (3.65%) Qualitative Analyst
10 5 (3.65%) Quantitative Analyst
Libraries, Frameworks & Software Standards
1 24 (17.52%) .NET
2 16 (11.68%) HTML
3 10 (7.30%) JSON
3 10 (7.30%) XML
4 8 (5.84%) AngularJS
5 7 (5.11%) ASP.NET
5 7 (5.11%) CSS
5 7 (5.11%) Spring
6 5 (3.65%) HTML5
6 5 (3.65%) React
6 5 (3.65%) Spring Boot
7 4 (2.92%) .NET Framework
7 4 (2.92%) Apache Camel
7 4 (2.92%) GWT
7 4 (2.92%) Node.js
7 4 (2.92%) Play Framework
7 4 (2.92%) RabbitMQ
7 4 (2.92%) REST
7 4 (2.92%) Smart Contracts
7 4 (2.92%) STL
Miscellaneous
1 29 (21.17%) Derivative
2 25 (18.25%) Fixed Income
3 21 (15.33%) Analytical Skills
4 16 (11.68%) Foreign Exchange (FX)
5 14 (10.22%) OTC Derivatives
6 12 (8.76%) Hedge funds
7 8 (5.84%) User Experience
8 6 (4.38%) Credit Risk
9 5 (3.65%) Market Risk
10 4 (2.92%) Algorithms
10 4 (2.92%) Cloud Native
10 4 (2.92%) Equities
11 3 (2.19%) Grid Computing
11 3 (2.19%) Management Information System
12 2 (1.46%) Data Structures
12 2 (1.46%) Enterprise Software
12 2 (1.46%) Equity Derivative
12 2 (1.46%) Reference Data
12 2 (1.46%) Smartphone
13 1 (0.73%) NHS
Operating Systems
1 12 (8.76%) Windows
2 4 (2.92%) Android
2 4 (2.92%) Apple iOS
2 4 (2.92%) CentOS
2 4 (2.92%) Debian
2 4 (2.92%) Linux
2 4 (2.92%) Mac OS X
2 4 (2.92%) Red Hat Enterprise Linux
2 4 (2.92%) Ubuntu
2 4 (2.92%) Windows 10
3 2 (1.46%) Windows 7
4 1 (0.73%) Solaris
4 1 (0.73%) Unix
Processes & Methodologies
1 32 (23.36%) Agile Software Development
2 31 (22.63%) Data Analysis
3 24 (17.52%) Analytics
4 23 (16.79%) Migration
4 23 (16.79%) Scrum
5 22 (16.06%) Asset Management
6 19 (13.87%) Business Analysis
6 19 (13.87%) Visualisation
7 18 (13.14%) DevOps
8 17 (12.41%) Test Automation
9 15 (10.95%) Investment Management
9 15 (10.95%) Risk Management
10 14 (10.22%) Business Intelligence
11 13 (9.49%) Open Source
11 13 (9.49%) Problem-Solving
12 12 (8.76%) Fund Management
12 12 (8.76%) Performance Attribution
12 12 (8.76%) Risk Analysis
13 11 (8.03%) Microservices
14 10 (7.30%) Mathematics
Programming Languages
1 82 (59.85%) SQL
2 74 (54.01%) Python
3 32 (23.36%) C#
4 18 (13.14%) C++
5 17 (12.41%) JavaScript
6 16 (11.68%) Java
6 16 (11.68%) R
7 12 (8.76%) MATLAB
8 7 (5.11%) VB
9 6 (4.38%) Perl
9 6 (4.38%) T-SQL
10 5 (3.65%) ABAP
10 5 (3.65%) Bash Shell
11 4 (2.92%) Clojure
11 4 (2.92%) ClojureScript
11 4 (2.92%) Groovy
11 4 (2.92%) PL/SQL
11 4 (2.92%) Ruby
11 4 (2.92%) Scala
12 3 (2.19%) Java 8
Qualifications
1 23 (16.79%) Degree
2 4 (2.92%) ITIL Certification
2 4 (2.92%) SAP Certification
2 4 (2.92%) SC Cleared
2 4 (2.92%) Security Cleared
3 2 (1.46%) Master's Degree
4 1 (0.73%) CFA
4 1 (0.73%) MBA
Quality Assurance & Compliance
1 6 (4.38%) Data Quality
2 5 (3.65%) QA
3 3 (2.19%) PMO
4 1 (0.73%) CRD IV
4 1 (0.73%) IFRS
4 1 (0.73%) IFRS 9
System Software
1 1 (0.73%) Docker
1 1 (0.73%) VMware Infrastructure
Systems Management
1 5 (3.65%) Puppet
2 4 (2.92%) Salt
3 3 (2.19%) Ansible
3 3 (2.19%) Kubernetes
4 2 (1.46%) SCCM
5 1 (0.73%) Control-M
5 1 (0.73%) Opscode Chef
Vendors
1 34 (24.82%) Microsoft
2 21 (15.33%) Bloomberg
3 13 (9.49%) Oracle
4 8 (5.84%) Tableau
5 7 (5.11%) Cognos
6 6 (4.38%) Sybase
7 5 (3.65%) Alteryx
7 5 (3.65%) Red Hat
7 5 (3.65%) SAP
8 4 (2.92%) Axway
8 4 (2.92%) Charles River
8 4 (2.92%) Cloudera
8 4 (2.92%) Hortonworks
8 4 (2.92%) MuleSoft
8 4 (2.92%) SimCorp
8 4 (2.92%) Sparx
9 2 (1.46%) Blue Prism
9 2 (1.46%) Informatica
9 2 (1.46%) OpenLink
9 2 (1.46%) Refinitiv