Period
to 29 July 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 29 July 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
29 Jul 2021
Same period 2020 Same period 2019
Rank 340 221 314
Rank change year-on-year -119 +93 -24
Contract jobs citing VBA 197 179 315
As % of all contract jobs advertised in London 0.66% 1.13% 0.78%
As % of the Programming Languages category 1.40% 2.25% 1.64%
Number of daily rates quoted 129 123 228
10th Percentile £274 £314 £312
25th Percentile £346 £345 £360
Median daily rate (50th Percentile) £475 £500 £450
Median % change year-on-year -5.00% +11.11% -5.26%
75th Percentile £578 £613 £538
90th Percentile £650 £674 £658
England median daily rate £450 £475 £425
% change year-on-year -5.26% +11.76% -
Number of hourly rates quoted 0 3 13
Median hourly rate - £33.68 £21.00
Median % change year-on-year - +60.36% +16.12%
England median hourly rate £19.50 £20.53 £20.50
% change year-on-year -5.02% +0.15% +13.35%

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 14,101 7,958 19,168
As % of all contract IT jobs advertised in London 46.90% 50.14% 47.50%
Number of daily rates quoted 10,520 5,908 14,595
10th Percentile £388 £363 £363
25th Percentile £463 £450 £425
Median daily rate (50th Percentile) £550 £525 £525
Median % change year-on-year +4.76% - +2.44%
75th Percentile £650 £638 £613
90th Percentile £725 £725 £688
England median daily rate £518 £500 £480
% change year-on-year +3.53% +4.17% +1.05%
Number of hourly rates quoted 78 68 105
10th Percentile £21.50 £22.35 £16.50
25th Percentile £34.91 £31.69 £21.25
Median hourly rate £44.75 £46.46 £44.57
Median % change year-on-year -3.68% +4.25% +12.82%
75th Percentile £61.50 £58.13 £52.50
90th Percentile £68.51 £64.99 £56.50
England median hourly rate £42.81 £42.50 £45.00
% change year-on-year +0.73% -5.56% +9.76%

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 29 July 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 29 July 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 -17 55 £450 +9.09% 17
South London +24 4 £550 +8.91% 1
North London +7 3 £150 - 1
West London +3 1 - - 3
VBA
England

For the 6 months to 29 July 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 130 (65.99%) Microsoft Excel
2 124 (62.94%) SQL
3 99 (50.25%) Finance
4 85 (43.15%) Python
5 58 (29.44%) C#
6 45 (22.84%) Analytical Skills
6 45 (22.84%) Social Skills
7 44 (22.34%) Degree
8 43 (21.83%) Banking
8 43 (21.83%) Business Intelligence
9 42 (21.32%) Front Office
10 40 (20.30%) .NET
11 38 (19.29%) Analytics
12 36 (18.27%) R
12 36 (18.27%) Data Analysis
13 34 (17.26%) SQL Server
13 34 (17.26%) Visualisation
13 34 (17.26%) Problem-Solving
14 33 (16.75%) C++
14 33 (16.75%) Mathematics
15 32 (16.24%) Data Warehouse
16 31 (15.74%) Alteryx
17 29 (14.72%) Data Science
17 29 (14.72%) Microsoft
18 27 (13.71%) Microsoft PowerPoint
18 27 (13.71%) Statistics
19 26 (13.20%) Asset Management
19 26 (13.20%) Decision-Making
20 25 (12.69%) Power Platform
20 25 (12.69%) Power BI

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 20 (10.15%) Jupyter
2 7 (3.55%) SAS
2 7 (3.55%) SharePoint
3 5 (2.54%) Confluence
4 2 (1.02%) IIS
5 1 (0.51%) Documentum
Applications
1 130 (65.99%) Microsoft Excel
2 27 (13.71%) Microsoft PowerPoint
3 15 (7.61%) Microsoft Office
4 5 (2.54%) Spreadsheet
5 1 (0.51%) MS Visio
Business Applications
1 4 (2.03%) thinkFolio
2 3 (1.52%) Markit EDM
2 3 (1.52%) SAP S/4HANA
3 2 (1.02%) Eagle PACE
3 2 (1.02%) IBM Planning Analytics
3 2 (1.02%) LatentZero
3 2 (1.02%) LongView
3 2 (1.02%) Maximo
4 1 (0.51%) Cognos Controller
4 1 (0.51%) Endur
4 1 (0.51%) Findur
4 1 (0.51%) SAP Oil and Gas
4 1 (0.51%) SAP PM
4 1 (0.51%) Sentinel
4 1 (0.51%) Workday HCM
Cloud Services
1 25 (12.69%) Power Platform
2 20 (10.15%) Azure
3 6 (3.05%) AWS
4 5 (2.54%) SaaS
5 4 (2.03%) GitHub
5 4 (2.03%) Power Automate
5 4 (2.03%) PowerApps
6 3 (1.52%) Azure Active Directory
6 3 (1.52%) Azure Data Factory
6 3 (1.52%) GCP
6 3 (1.52%) Google Sheets
6 3 (1.52%) IaaS
6 3 (1.52%) PaaS
7 2 (1.02%) Cloud Computing
7 2 (1.02%) Microsoft 365
7 2 (1.02%) SuccessFactors
8 1 (0.51%) Akamai
8 1 (0.51%) Azure Stack
8 1 (0.51%) Snowflake
Communications & Networking
1 5 (2.54%) TCP/IP
2 4 (2.03%) DNS
2 4 (2.03%) FTP
2 4 (2.03%) Kerberos
3 3 (1.52%) Internet
4 1 (0.51%) F5 BIG-IP GTM
4 1 (0.51%) Wi-Fi
Database & Business Intelligence
1 34 (17.26%) SQL Server
2 32 (16.24%) Data Warehouse
3 25 (12.69%) Power BI
4 23 (11.68%) QlikView
5 20 (10.15%) Relational Database
5 20 (10.15%) Tableau
6 11 (5.58%) SQL Server Integration Services
7 9 (4.57%) Data Mining
8 8 (4.06%) RDBMS
9 7 (3.55%) MySQL
9 7 (3.55%) SQL Server Reporting Services
10 5 (2.54%) MS Access
11 4 (2.03%) Metadata
12 3 (1.52%) Oracle Database
13 2 (1.02%) BusinessObjects
13 2 (1.02%) Data Vault
13 2 (1.02%) Oracle Reports
13 2 (1.02%) PostgreSQL
13 2 (1.02%) PowerPivot
13 2 (1.02%) SAP BW
Development Applications
1 9 (4.57%) JIRA
2 5 (2.54%) Git (software)
2 5 (2.54%) TeamCity
3 4 (2.03%) Subversion
4 3 (1.52%) Eclipse
4 3 (1.52%) SQL Server Management Studio (SSMS)
5 2 (1.02%) PowerDesigner
5 2 (1.02%) Visual Studio
6 1 (0.51%) Cypress.io
6 1 (0.51%) Jenkins
6 1 (0.51%) Octopus Deploy
6 1 (0.51%) Selenium
General
1 99 (50.25%) Finance
2 45 (22.84%) Analytical Skills
2 45 (22.84%) Social Skills
3 43 (21.83%) Banking
4 42 (21.32%) Front Office
5 19 (9.64%) Presentation Skills
6 18 (9.14%) Marketing
7 11 (5.58%) Investment Banking
8 8 (4.06%) Documentation Skills
9 7 (3.55%) Pharmaceutical
9 7 (3.55%) Retail
10 6 (3.05%) Legal
11 3 (1.52%) Organisational Skills
11 3 (1.52%) Publishing
12 2 (1.02%) Advertising
12 2 (1.02%) Billing
12 2 (1.02%) Public Sector
13 1 (0.51%) Back Office
13 1 (0.51%) International Banking
13 1 (0.51%) Retail Banking
Job Titles
1 76 (38.58%) Developer
2 57 (28.93%) Analyst
3 26 (13.20%) VBA Developer
4 21 (10.66%) Excel Developer
5 20 (10.15%) Data Analyst
6 19 (9.64%) Data Scientist
7 18 (9.14%) C# Developer
8 11 (5.58%) Excel VBA Developer
8 11 (5.58%) Front Office Developer
9 10 (5.08%) Business Analyst
9 10 (5.08%) Consultant
9 10 (5.08%) Python Developer
9 10 (5.08%) Qualitative Analyst
9 10 (5.08%) Quantitative Analyst
9 10 (5.08%) Risk Analyst
10 9 (4.57%) Robotic Process Automation Developer
11 8 (4.06%) Front Office RAD Developer
11 8 (4.06%) Quantitative Risk Analyst
11 8 (4.06%) RAD Developer
11 8 (4.06%) SQL Analyst
Libraries, Frameworks & Software Standards
1 40 (20.30%) .NET
2 20 (10.15%) .NET Framework
3 18 (9.14%) Shiny
4 17 (8.63%) D3.js
5 16 (8.12%) HTML
6 8 (4.06%) XML
7 6 (3.05%) .NET Core
7 6 (3.05%) Ajax
7 6 (3.05%) CSS
7 6 (3.05%) Razor View Engine
8 4 (2.03%) ASP.NET Web API
9 3 (1.52%) Pandas
9 3 (1.52%) REST
10 2 (1.02%) JSON
10 2 (1.02%) LDAP
10 2 (1.02%) NumPy
10 2 (1.02%) scikit-learn
10 2 (1.02%) SciPy
10 2 (1.02%) WinForms
10 2 (1.02%) WPF
Miscellaneous
1 23 (11.68%) Derivative
2 19 (9.64%) Fixed Income
3 18 (9.14%) Management Information System
4 17 (8.63%) Algorithms
4 17 (8.63%) Social Media
5 13 (6.60%) Credit Risk
6 11 (5.58%) Equities
6 11 (5.58%) Market Risk
7 8 (4.06%) Swaptions
7 8 (4.06%) User Experience
8 7 (3.55%) FMCG
8 7 (3.55%) Robotics
9 6 (3.05%) Foreign Exchange (FX)
9 6 (3.05%) Reference Data
10 3 (1.52%) Clustering
10 3 (1.52%) Data Protection Act
10 3 (1.52%) Hedge funds
10 3 (1.52%) Mainframe
10 3 (1.52%) Reinsurance
10 3 (1.52%) Replication
Operating Systems
1 15 (7.61%) Windows
2 6 (3.05%) Windows Server 2008
3 3 (1.52%) Linux
3 3 (1.52%) Unix
3 3 (1.52%) Windows 7
3 3 (1.52%) Windows Server
3 3 (1.52%) Windows Server 2012
4 2 (1.02%) Windows 10
5 1 (0.51%) Windows Server 2016
5 1 (0.51%) Windows Server 2019
Processes & Methodologies
1 43 (21.83%) Business Intelligence
2 38 (19.29%) Analytics
3 36 (18.27%) Data Analysis
4 34 (17.26%) Problem-Solving
4 34 (17.26%) Visualisation
5 33 (16.75%) Mathematics
6 29 (14.72%) Data Science
7 27 (13.71%) Statistics
8 26 (13.20%) Asset Management
8 26 (13.20%) Decision-Making
9 25 (12.69%) Machine Learning
10 24 (12.18%) Investment Management
11 23 (11.68%) Agile Software Development
12 19 (9.64%) Mentoring
13 17 (8.63%) B2B
13 17 (8.63%) Bayesian Methods
13 17 (8.63%) CRM
13 17 (8.63%) Data Sharing
13 17 (8.63%) Deep Learning
13 17 (8.63%) Digital Analytics
Programming Languages
1 124 (62.94%) SQL
2 85 (43.15%) Python
3 58 (29.44%) C#
4 36 (18.27%) R
5 33 (16.75%) C++
6 24 (12.18%) Java
7 19 (9.64%) VB
8 17 (8.63%) PowerShell
9 15 (7.61%) JavaScript
9 15 (7.61%) T-SQL
10 7 (3.55%) PL/SQL
10 7 (3.55%) VB.NET
11 4 (2.03%) MATLAB
12 3 (1.52%) VBScript
13 1 (0.51%) C
13 1 (0.51%) Shell Script
Qualifications
1 44 (22.34%) Degree
2 4 (2.03%) CISM
2 4 (2.03%) CISSP
2 4 (2.03%) Computer Science Degree
2 4 (2.03%) Security Cleared
3 2 (1.02%) Numerate Degree
3 2 (1.02%) SC Cleared
4 1 (0.51%) CFA
4 1 (0.51%) MBA
4 1 (0.51%) Tableau Certification
Quality Assurance & Compliance
1 5 (2.54%) QA
2 4 (2.03%) Data Quality
2 4 (2.03%) GDPR
3 3 (1.52%) Basel III
3 3 (1.52%) CRD IV
3 3 (1.52%) IFRS
3 3 (1.52%) Sarbanes-Oxley
4 2 (1.02%) MiFID
4 2 (1.02%) SLA
5 1 (0.51%) Accessibility
System Software
1 8 (4.06%) Active Directory
2 2 (1.02%) VMware ESXi
2 2 (1.02%) VMware Infrastructure
3 1 (0.51%) Virtual Desktop
Systems Management
1 4 (2.03%) Ansible
1 4 (2.03%) Control-M
2 3 (1.52%) CSIRT
2 3 (1.52%) EMC NetWorker
2 3 (1.52%) QRadar
2 3 (1.52%) Tivoli
2 3 (1.52%) Tivoli Storage Manager
3 2 (1.02%) Netcool
3 2 (1.02%) SCCM
4 1 (0.51%) HP Quality Center
Vendors
1 31 (15.74%) Alteryx
2 29 (14.72%) Microsoft
3 25 (12.69%) Oracle
4 17 (8.63%) Salesforce.com
5 10 (5.08%) Dataiku
5 10 (5.08%) Google
6 7 (3.55%) SAP
7 6 (3.05%) Automation Anywhere
7 6 (3.05%) Bloomberg
7 6 (3.05%) QAD
7 6 (3.05%) Refinitiv
8 5 (2.54%) Citrix
8 5 (2.54%) IBM
9 3 (1.52%) Charles River
9 3 (1.52%) Cognos
9 3 (1.52%) CyberArk
9 3 (1.52%) EMC
9 3 (1.52%) Qualys
9 3 (1.52%) Sybase
9 3 (1.52%) UiPath