Period
to 28 May 2020

The following table provides summary statistics for contract job vacancies 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 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)
UK
6 months to
28 May 2020
Same period 2019 Same period 2018
Rank 342 411 347
Rank change year-on-year +69 -64 -16
Contract jobs citing VBA 301 530 739
As % of all contract jobs advertised in the UK 0.64% 0.58% 0.73%
As % of the Programming Languages category 1.57% 1.36% 1.70%
Number of daily rates quoted 198 365 507
Median daily rate £400 £400 £400
10th Percentile £198 £300 £275
90th Percentile £663 £600 £575
UK excluding London median daily rate £300 £393 £351
% change year-on-year -23.57% +11.74% -6.33%
Number of hourly rates quoted 15 17 18
Median hourly rate £21.32 £21.00 £20.00
Median hourly rate % change year-on-year +1.52% +5.00% -49.97%
10th Percentile £17.78 £16.50 £16.40
90th Percentile £64.75 £26.60 £42.13
UK excluding London median hourly rate £21.14 £18.15 £20.00
% change year-on-year +16.45% -9.25% -52.91%

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

All Programming Languages
UK
Contract vacancies with a requirement for coding skills 19,198 38,866 43,428
As % of all contract IT jobs advertised in the UK 40.99% 42.83% 43.07%
Number of daily rates quoted 12,905 26,907 30,332
Median daily rate £488 £475 £463
Median daily rate % change year-on-year +2.63% +2.70% +7.56%
10th Percentile £325 £325 £313
90th Percentile £664 £650 £638
UK excluding London median daily rate £450 £425 £403
% change year-on-year +5.88% +5.59% +3.87%
Number of hourly rates quoted 421 681 788
Median hourly rate £35.00 £42.50 £40.00
Median hourly rate % change year-on-year -17.65% +6.25% -3.61%
10th Percentile £18.25 £18.00 £17.00
90th Percentile £56.00 £55.00 £52.50
Median hourly rate £35.00 £43.00 £40.00
% change year-on-year -18.60% +7.50% -2.74%

VBA
Job Vacancy Trend

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

Job vacancy trend for VBA in the UK

VBA
Contractor Daily Rate Trend

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

Daily rate trend for VBA in the UK

VBA
Daily Rate Histogram

Daily rate distribution for jobs citing VBA over the 6 months to 28 May 2020.

Daily rate histogram for VBA in the UK

VBA
Contractor Hourly Rate Trend

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

Hourly rate trend for VBA in the UK

VBA
Hourly Rate Histogram

Hourly rate distribution of jobs citing VBA over the 6 months to 28 May 2020.

Hourly rate histogram for VBA in the UK

VBA
Top 17 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing VBA within the UK over the 6 months to 28 May 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
England +68 269 £413 +3.13% 32
London +52 168 £500 +17.65% 21
UK excluding London +113 133 £300 -23.57% 11
North of England +75 32 £271 -27.67% 1
Scotland +51 28 £300 -27.27% 1
East of England +73 23 £243 -42.94% 2
South East +111 21 £275 -26.67%
South West +41 19 £288 -32.35% 4
North West +32 11 £200 -46.67% 1
North East +27 11 £280 +23.08%
Yorkshire +61 10 £413 +3.45%
Midlands +44 7 £400 - 3
West Midlands +39 6 £344 -13.99% 3
Work from Home +10 5 £425 -1.16%
Northern Ireland +18 3 £342 -
East Midlands +35 1 £400 +1.27%
Wales +27 1 - -

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

1 203 (67.44%) SQL
2 198 (65.78%) Microsoft Excel
3 132 (43.85%) Finance
4 90 (29.90%) C#
5 85 (28.24%) Microsoft
6 81 (26.91%) .NET
7 79 (26.25%) Python
8 73 (24.25%) SQL Server
9 70 (23.26%) Data Analysis
10 65 (21.59%) Business Intelligence
11 63 (20.93%) Banking
12 59 (19.60%) Agile Software Development
13 56 (18.60%) Front Office
14 52 (17.28%) Oracle
15 50 (16.61%) Analytical Skills
16 46 (15.28%) Migration
17 45 (14.95%) Analytics
18 43 (14.29%) Windows
19 42 (13.95%) Power BI
19 42 (13.95%) Power Platform
20 41 (13.62%) Microsoft Office
21 40 (13.29%) Asset Management
21 40 (13.29%) Degree
22 37 (12.29%) Problem-Solving
23 35 (11.63%) HTML
24 33 (10.96%) Fixed Income
25 31 (10.30%) Derivative
26 30 (9.97%) Scrum
27 29 (9.63%) JavaScript
27 29 (9.63%) CSS

VBA
Co-occurring IT Skills 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 26 (8.64%) SharePoint
2 10 (3.32%) SAS
3 7 (2.33%) IIS
4 6 (1.99%) Confluence
5 5 (1.66%) NetWeaver
6 3 (1.00%) MS Exchange
7 2 (0.66%) Apache Spark
7 2 (0.66%) IBM Notes
7 2 (0.66%) WebSphere
8 1 (0.33%) Apache
8 1 (0.33%) Apache Solr
8 1 (0.33%) Elasticsearch
8 1 (0.33%) WordPress
Applications
1 198 (65.78%) Microsoft Excel
2 41 (13.62%) Microsoft Office
3 19 (6.31%) Microsoft PowerPoint
4 7 (2.33%) Spreadsheet
5 3 (1.00%) MS Visio
6 2 (0.66%) Microsoft Project
Business Applications
1 7 (2.33%) Distributed Ledger
2 6 (1.99%) SAP BPC
3 4 (1.33%) Cognos TM1
4 1 (0.33%) assyst
4 1 (0.33%) Dynamics CRM
4 1 (0.33%) HFM
4 1 (0.33%) Magento
4 1 (0.33%) Markit EDM
4 1 (0.33%) NetSuite
4 1 (0.33%) PolarLake
4 1 (0.33%) Primavera
4 1 (0.33%) ProductWriter
4 1 (0.33%) SAP S/4HANA
Cloud Services
1 42 (13.95%) Power Platform
2 21 (6.98%) Azure
2 21 (6.98%) Office 365
3 12 (3.99%) OneDrive
4 8 (2.66%) AWS
5 5 (1.66%) Azure Functions
5 5 (1.66%) Serverless
6 4 (1.33%) AWS Lambda
7 3 (1.00%) OpenShift
8 2 (0.66%) Azure Data Factory
8 2 (0.66%) GitHub
8 2 (0.66%) IaaS
8 2 (0.66%) PaaS
9 1 (0.33%) Amazon EMR
9 1 (0.33%) Amazon S3
9 1 (0.33%) GCP
9 1 (0.33%) Mimecast
9 1 (0.33%) Power Automate
9 1 (0.33%) PowerApps
9 1 (0.33%) SuccessFactors
Communications & Networking
1 3 (1.00%) TCP/IP
2 2 (0.66%) Ethernet
2 2 (0.66%) IP Telephony
2 2 (0.66%) VoIP
3 1 (0.33%) DNS
3 1 (0.33%) Firewall
3 1 (0.33%) Intranet
3 1 (0.33%) LAN
3 1 (0.33%) PuTTY
3 1 (0.33%) Skype
Database & Business Intelligence
1 73 (24.25%) SQL Server
2 42 (13.95%) Power BI
3 27 (8.97%) MS Access
4 24 (7.97%) SQL Server Reporting Services
5 23 (7.64%) SQL Server Integration Services
6 20 (6.64%) Data Warehouse
7 18 (5.98%) Relational Database
8 15 (4.98%) BusinessObjects
9 10 (3.32%) OLAP
9 10 (3.32%) QlikView
10 9 (2.99%) RDBMS
11 8 (2.66%) Oracle Database
11 8 (2.66%) Spotfire
12 7 (2.33%) SAP BW
13 6 (1.99%) Big Data
14 5 (1.66%) Hadoop
14 5 (1.66%) SQL Server 2008
14 5 (1.66%) SQL Server 2014
14 5 (1.66%) SQL Server Analysis Services
15 4 (1.33%) BusinessObjects Web Intelligence
Development Applications
1 14 (4.65%) JIRA
2 13 (4.32%) Git (software)
3 8 (2.66%) Subversion
4 7 (2.33%) Visual Studio
5 6 (1.99%) Team Foundation Server
6 5 (1.66%) Selenium
7 4 (1.33%) Jenkins
7 4 (1.33%) SoapUI
8 3 (1.00%) JUnit
9 2 (0.66%) Cucumber
9 2 (0.66%) JMeter
9 2 (0.66%) Postman
9 2 (0.66%) Rational DOORS
9 2 (0.66%) Redmine
9 2 (0.66%) Sonatype Nexus
9 2 (0.66%) SQL Server Management Studio (SSMS)
10 1 (0.33%) Liquibase
10 1 (0.33%) Moq
10 1 (0.33%) Octopus Deploy
10 1 (0.33%) TeamCity
General
1 132 (43.85%) Finance
2 63 (20.93%) Banking
3 56 (18.60%) Front Office
4 16 (5.32%) Investment Banking
4 16 (5.32%) Public Sector
5 10 (3.32%) Back Office
5 10 (3.32%) Retail
6 6 (1.99%) Legal
7 4 (1.33%) Manufacturing
7 4 (1.33%) Marketing
8 3 (1.00%) Local Government
8 3 (1.00%) Pharmaceutical
9 2 (0.66%) Housing Association
9 2 (0.66%) International Banking
9 2 (0.66%) Law
9 2 (0.66%) Multimedia
10 1 (0.33%) Police
10 1 (0.33%) Prime Brokerage
10 1 (0.33%) Retail Banking
10 1 (0.33%) Social Science
Job Titles
1 134 (44.52%) Developer
2 101 (33.55%) Analyst
3 41 (13.62%) Data Analyst
3 41 (13.62%) VBA Developer
4 39 (12.96%) C# Developer
5 28 (9.30%) .NET Developer
6 22 (7.31%) C# .NET Developer
6 22 (7.31%) SQL Developer
7 20 (6.64%) Junior
8 18 (5.98%) Consultant
8 18 (5.98%) Python Developer
9 17 (5.65%) SQL Analyst
10 13 (4.32%) Excel Developer
11 12 (3.99%) Business Analyst
11 12 (3.99%) Excel VBA Developer
12 11 (3.65%) Technical Consultant
13 10 (3.32%) Financial Analyst
13 10 (3.32%) Full Stack Developer
13 10 (3.32%) Junior Analyst
13 10 (3.32%) Senior Analyst
Libraries, Frameworks & Software Standards
1 81 (26.91%) .NET
2 35 (11.63%) HTML
3 29 (9.63%) CSS
4 28 (9.30%) ASP.NET
5 17 (5.65%) XML
6 16 (5.32%) AngularJS
7 14 (4.65%) WinForms
8 11 (3.65%) JSON
8 11 (3.65%) React
9 10 (3.32%) .NET Framework
10 9 (2.99%) WPF
11 8 (2.66%) .NET Core
12 7 (2.33%) HTML5
12 7 (2.33%) RESTful
12 7 (2.33%) Smart Contracts
13 5 (1.66%) ODBC
14 4 (1.33%) ASP.NET MVC
14 4 (1.33%) FpML
14 4 (1.33%) jQuery
14 4 (1.33%) WCF
Miscellaneous
1 50 (16.61%) Analytical Skills
2 33 (10.96%) Fixed Income
3 31 (10.30%) Derivative
4 23 (7.64%) OTC Derivatives
5 19 (6.31%) Hedge funds
6 14 (4.65%) Self-Motivation
7 12 (3.99%) Foreign Exchange (FX)
8 9 (2.99%) Credit Risk
9 7 (2.33%) Management Information System
9 7 (2.33%) NHS
10 5 (1.66%) Clustering
10 5 (1.66%) User Experience
11 4 (1.33%) Algorithms
11 4 (1.33%) Analytical Mindset
12 3 (1.00%) Data Centre
12 3 (1.00%) Fat Client
12 3 (1.00%) Mainframe
12 3 (1.00%) Thin Client
13 2 (0.66%) Equity Derivative
13 2 (0.66%) Graphic Design
Operating Systems
1 43 (14.29%) Windows
2 21 (6.98%) Windows 10
3 12 (3.99%) Windows 7
4 4 (1.33%) Windows Server
4 4 (1.33%) Windows Server 2008
4 4 (1.33%) Windows XP
5 3 (1.00%) Linux
6 2 (0.66%) Apple iOS
7 1 (0.33%) CentOS
7 1 (0.33%) Unix
7 1 (0.33%) Windows Server 2012
Processes & Methodologies
1 70 (23.26%) Data Analysis
2 65 (21.59%) Business Intelligence
3 59 (19.60%) Agile Software Development
4 46 (15.28%) Migration
5 45 (14.95%) Analytics
6 40 (13.29%) Asset Management
7 37 (12.29%) Problem-Solving
8 30 (9.97%) Scrum
9 25 (8.31%) Business Analysis
10 24 (7.97%) Data Modelling
10 24 (7.97%) Mathematics
11 23 (7.64%) Visualisation
12 22 (7.31%) ETL
12 22 (7.31%) Performance Attribution
13 19 (6.31%) Investment Management
13 19 (6.31%) Machine Learning
13 19 (6.31%) Risk Analysis
14 18 (5.98%) ITIL
15 17 (5.65%) Collaborative Working
16 16 (5.32%) Change Management
Programming Languages
1 203 (67.44%) SQL
2 90 (29.90%) C#
3 79 (26.25%) Python
4 29 (9.63%) JavaScript
4 29 (9.63%) R
5 28 (9.30%) VB
6 24 (7.97%) VB.NET
7 23 (7.64%) PowerShell
7 23 (7.64%) T-SQL
8 19 (6.31%) Java
8 19 (6.31%) MATLAB
9 15 (4.98%) C++
10 7 (2.33%) PL/SQL
11 6 (1.99%) C
11 6 (1.99%) TypeScript
12 5 (1.66%) ABAP
13 3 (1.00%) Java 8
13 3 (1.00%) VBScript
14 2 (0.66%) Perl
14 2 (0.66%) PHP
Qualifications
1 40 (13.29%) Degree
2 9 (2.99%) Security Cleared
3 7 (2.33%) SC Cleared
4 5 (1.66%) Numerate Degree
5 4 (1.33%) ITIL Certification
5 4 (1.33%) SAP Certification
6 3 (1.00%) Oracle Certification
6 3 (1.00%) PhD
7 2 (0.66%) Computer Science Degree
7 2 (0.66%) ISEB
7 2 (0.66%) ISEB Practitioner
7 2 (0.66%) Master's Degree
8 1 (0.33%) HND
8 1 (0.33%) ISTQB
8 1 (0.33%) ISTQB Foundation Certification
8 1 (0.33%) MBA
8 1 (0.33%) Six Sigma Yellow Belt
Quality Assurance & Compliance
1 20 (6.64%) QA
2 15 (4.98%) GDPR
3 14 (4.65%) Data Quality
4 9 (2.99%) SLA
5 3 (1.00%) PMO
6 1 (0.33%) Basel II
System Software
1 5 (1.66%) VMware Infrastructure
1 5 (1.66%) vSphere
2 4 (1.33%) Citrix Hypervisor
2 4 (1.33%) XenApp
2 4 (1.33%) XenDesktop
3 2 (0.66%) Active Directory
3 2 (0.66%) Microsoft App-V
4 1 (0.33%) Docker
Systems Management
1 8 (2.66%) SCCM
2 4 (1.33%) Kubernetes
3 2 (0.66%) Netcool
4 1 (0.33%) cPanel
4 1 (0.33%) HP ALM
4 1 (0.33%) SafeCom
Vendors
1 85 (28.24%) Microsoft
2 52 (17.28%) Oracle
3 28 (9.30%) Tableau
4 23 (7.64%) Bloomberg
5 15 (4.98%) SAP
6 13 (4.32%) Cognos
7 5 (1.66%) Atlassian
7 5 (1.66%) IBM
7 5 (1.66%) VMware
8 4 (1.33%) Alteryx
8 4 (1.33%) Citrix
9 3 (1.00%) PeopleSoft
9 3 (1.00%) Sybase
10 2 (0.66%) Apple
10 2 (0.66%) HP
10 2 (0.66%) Informatica
10 2 (0.66%) Lotus
10 2 (0.66%) Micro Focus
10 2 (0.66%) Remedy
10 2 (0.66%) Teradata