Period
to 7 April 2020

The following table provides summary statistics for contract job vacancies advertised in England 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 7 April 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 > England
6 months to
7 Apr 2020
Same period 2019 Same period 2018
Rank 368 399 307
Rank change year-on-year +31 -92 +32
Contract jobs citing VBA 317 561 793
As % of all contract jobs advertised in England 0.58% 0.63% 0.85%
As % of the Programming Languages category 1.42% 1.46% 1.97%
Number of daily rates quoted 214 398 557
Median daily rate £413 £400 £425
Median daily rate % change year-on-year +3.12% -5.82% +3.03%
10th Percentile £208 £300 £275
90th Percentile £646 £588 £625
UK median daily rate £413 £400 £425
% change year-on-year +3.13% -5.88% +6.25%
Number of hourly rates quoted 14 10 16
Median hourly rate £24.27 £21.00 £20.00
Median hourly rate % change year-on-year +15.58% +5.00% -49.97%
10th Percentile £18.37 £16.50 £16.00
90th Percentile £35.00 £36.13 £46.88
UK median hourly rate £22.50 £19.56 £20.00
% change year-on-year +15.06% -2.23% -49.97%

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

All Programming Languages
England
Contract vacancies with a requirement for coding skills 22,384 38,501 40,322
As % of all contract IT jobs advertised in England 40.95% 43.44% 43.19%
Number of daily rates quoted 15,304 27,139 28,420
Median daily rate £500 £480 £475
Median daily rate % change year-on-year +4.17% +1.05% +8.57%
10th Percentile £325 £325 £313
90th Percentile £656 £650 £638
UK median daily rate £485 £475 £463
% change year-on-year +2.11% +2.70% +8.82%
Number of hourly rates quoted 500 613 729
Median hourly rate £40.00 £42.50 £40.00
Median hourly rate % change year-on-year -5.88% +6.25% -
10th Percentile £17.83 £18.00 £17.39
90th Percentile £55.10 £53.75 £51.05
Median hourly rate £40.00 £42.50 £40.00
% change year-on-year -5.88% +6.25% -

VBA
Job Vacancy Trend in England

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

Job vacancy trend for VBA in England

VBA
Contractor Daily Rate Trend in England

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

Daily rate trend for VBA in England

VBA
Daily Rate Histogram in England

Daily rate distribution for jobs citing VBA in England over the 6 months to 7 April 2020.

Daily rate histogram for VBA in England

VBA
Contractor Hourly Rate Trend in England

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

Hourly rate trend for VBA in England

VBA
Hourly Rate Histogram in England

Hourly rate distribution of jobs citing VBA in England over the 6 months to 7 April 2020.

Hourly rate histogram for VBA in England

VBA
Contract Job Locations in England

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing VBA within the England region over the 6 months to 7 April 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
London -13 188 £475 +11.76% 27
North of England +68 50 £388 -0.64% 3
North West +36 28 £400 - 2
South West +34 26 £344 -19.12% 7
East of England +49 24 £265 -33.83% 3
South East +89 23 £378 +0.67% 10
North East +37 12 £280 +36.59%
Yorkshire +46 10 £413 +1.85% 1
West Midlands +43 7 £344 -11.22% 4
Midlands +38 7 £344 -12.91% 4
VBA
UK

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

1 209 (65.93%) Microsoft Excel
2 207 (65.30%) SQL
3 121 (38.17%) Finance
4 106 (33.44%) C#
5 105 (33.12%) .NET
6 91 (28.71%) SQL Server
7 72 (22.71%) Python
8 71 (22.40%) Analytical Skills
9 65 (20.50%) Microsoft
10 63 (19.87%) Business Intelligence
11 59 (18.61%) Banking
12 48 (15.14%) Data Analysis
13 45 (14.20%) Power BI
13 45 (14.20%) Power Platform
14 44 (13.88%) Agile Software Development
15 43 (13.56%) Oracle
16 42 (13.25%) Front Office
17 41 (12.93%) HTML
18 38 (11.99%) Degree
19 37 (11.67%) MS Access
20 35 (11.04%) Windows
21 33 (10.41%) Analytics
22 31 (9.78%) CSS
23 30 (9.46%) ASP.NET
23 30 (9.46%) Microsoft Office
23 30 (9.46%) VB
23 30 (9.46%) Azure
24 29 (9.15%) JavaScript
24 29 (9.15%) Asset Management
25 28 (8.83%) SQL Server Reporting Services

VBA
Co-occurring IT Skills in England 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 22 (6.94%) SharePoint
2 13 (4.10%) SAS
3 8 (2.52%) IIS
4 7 (2.21%) NetWeaver
5 6 (1.89%) Confluence
6 3 (0.95%) MS Exchange
7 2 (0.63%) Exchange Server 2010
7 2 (0.63%) IBM Notes
8 1 (0.32%) Apache
8 1 (0.32%) Apache Solr
8 1 (0.32%) Elasticsearch
8 1 (0.32%) Oracle Workflow
8 1 (0.32%) Skype for Business
8 1 (0.32%) Tomcat
8 1 (0.32%) WordPress
Applications
1 209 (65.93%) Microsoft Excel
2 30 (9.46%) Microsoft Office
3 18 (5.68%) MS Visio
4 10 (3.15%) Microsoft PowerPoint
5 9 (2.84%) Spreadsheet
6 1 (0.32%) Microsoft Project
Business Applications
1 10 (3.15%) SAP BPC
2 5 (1.58%) Distributed Ledger
3 4 (1.26%) Cognos TM1
4 3 (0.95%) SAP ERP
5 2 (0.63%) HFM
5 2 (0.63%) Magento
6 1 (0.32%) Dynamics CRM
6 1 (0.32%) Markit EDM
6 1 (0.32%) NetSuite
6 1 (0.32%) PolarLake
6 1 (0.32%) Primavera
6 1 (0.32%) ProductWriter
6 1 (0.32%) SAP S/4HANA
Cloud Services
1 45 (14.20%) Power Platform
2 30 (9.46%) Azure
3 14 (4.42%) AWS
4 10 (3.15%) Azure Functions
4 10 (3.15%) Serverless
5 9 (2.84%) AWS Lambda
6 6 (1.89%) Office 365
7 3 (0.95%) Azure Data Factory
7 3 (0.95%) PaaS
8 2 (0.63%) GitHub
8 2 (0.63%) IaaS
8 2 (0.63%) SuccessFactors
9 1 (0.32%) Amazon EMR
9 1 (0.32%) Amazon S3
9 1 (0.32%) Azure Active Directory
9 1 (0.32%) Azure Stack
9 1 (0.32%) GCP
9 1 (0.32%) Microsoft Flow
9 1 (0.32%) Mimecast
9 1 (0.32%) PowerApps
Communications & Networking
1 4 (1.26%) TCP/IP
2 2 (0.63%) DNS
2 2 (0.63%) Ethernet
2 2 (0.63%) Firewall
2 2 (0.63%) LAN
2 2 (0.63%) VPN
3 1 (0.32%) Internet
3 1 (0.32%) Intranet
3 1 (0.32%) iSCSI
3 1 (0.32%) MPLS
3 1 (0.32%) Network Security
3 1 (0.32%) PuTTY
3 1 (0.32%) Radio Access Network
3 1 (0.32%) SAN
3 1 (0.32%) Skype
3 1 (0.32%) VLAN
3 1 (0.32%) Wireless
Database & Business Intelligence
1 91 (28.71%) SQL Server
2 45 (14.20%) Power BI
3 37 (11.67%) MS Access
4 28 (8.83%) SQL Server Reporting Services
5 23 (7.26%) Data Warehouse
6 22 (6.94%) SQL Server Integration Services
7 19 (5.99%) Relational Database
8 15 (4.73%) MongoDB
8 15 (4.73%) NoSQL
9 13 (4.10%) BusinessObjects
10 9 (2.84%) QlikView
10 9 (2.84%) Spotfire
11 8 (2.52%) OLAP
12 7 (2.21%) RDBMS
12 7 (2.21%) SAP BW
13 6 (1.89%) Big Data
13 6 (1.89%) Oracle Reports
13 6 (1.89%) SQL Server Analysis Services
14 4 (1.26%) Data Lake
14 4 (1.26%) Oracle Database
Development Applications
1 14 (4.42%) NUnit
2 12 (3.79%) JIRA
3 11 (3.47%) Git (software)
4 8 (2.52%) Subversion
5 5 (1.58%) SQL Server Management Studio (SSMS)
5 5 (1.58%) Team Foundation Server
5 5 (1.58%) Visual Studio
6 2 (0.63%) Bitbucket
6 2 (0.63%) Rational DOORS
6 2 (0.63%) Sonatype Nexus
7 1 (0.32%) HP UFT
7 1 (0.32%) Moq
7 1 (0.32%) Octopus Deploy
7 1 (0.32%) SoapUI
7 1 (0.32%) TeamCity
General
1 121 (38.17%) Finance
2 59 (18.61%) Banking
3 42 (13.25%) Front Office
4 21 (6.62%) Public Sector
5 11 (3.47%) Investment Banking
6 10 (3.15%) Legal
7 9 (2.84%) Retail
8 7 (2.21%) Back Office
8 7 (2.21%) Publishing
9 5 (1.58%) Manufacturing
9 5 (1.58%) Marketing
10 4 (1.26%) Local Government
11 2 (0.63%) Housing Association
11 2 (0.63%) International Banking
11 2 (0.63%) Law
11 2 (0.63%) Multimedia
12 1 (0.32%) Aerospace
12 1 (0.32%) Automotive
12 1 (0.32%) Pharmaceutical
12 1 (0.32%) Telecoms
Job Titles
1 152 (47.95%) Developer
2 103 (32.49%) Analyst
3 48 (15.14%) VBA Developer
4 47 (14.83%) C# Developer
5 46 (14.51%) .NET Developer
6 43 (13.56%) Data Analyst
7 26 (8.20%) SQL Developer
8 25 (7.89%) C# .NET Developer
9 22 (6.94%) Python Developer
10 16 (5.05%) Senior Developer
11 14 (4.42%) Excel Developer
11 14 (4.42%) Junior
11 14 (4.42%) SQL Analyst
12 13 (4.10%) Excel VBA Developer
12 13 (4.10%) Senior .NET Developer
13 11 (3.47%) Senior Analyst
14 9 (2.84%) Applications Developer
14 9 (2.84%) Business Intelligence Developer
14 9 (2.84%) Consultant
14 9 (2.84%) Excel Analyst
Libraries, Frameworks & Software Standards
1 105 (33.12%) .NET
2 41 (12.93%) HTML
3 31 (9.78%) CSS
4 30 (9.46%) ASP.NET
5 17 (5.36%) WinForms
6 16 (5.05%) AngularJS
7 14 (4.42%) XML
8 13 (4.10%) .NET Framework
8 13 (4.10%) React
9 10 (3.15%) WPF
10 9 (2.84%) .NET Core
11 8 (2.52%) ODBC
12 7 (2.21%) HTML5
12 7 (2.21%) SignalR
13 6 (1.89%) ASP.NET Core
14 5 (1.58%) JSON
14 5 (1.58%) Smart Contracts
15 4 (1.26%) FpML
15 4 (1.26%) Redux
16 3 (0.95%) DAO
Miscellaneous
1 71 (22.40%) Analytical Skills
2 19 (5.99%) Self-Motivation
3 18 (5.68%) Fixed Income
4 17 (5.36%) Derivative
5 11 (3.47%) Foreign Exchange (FX)
5 11 (3.47%) OTC Derivatives
6 9 (2.84%) NHS
7 8 (2.52%) Management Information System
8 7 (2.21%) Credit Risk
8 7 (2.21%) Hedge funds
9 5 (1.58%) Clustering
9 5 (1.58%) Smartphone
10 4 (1.26%) Analytical Mindset
10 4 (1.26%) Data Centre
11 3 (0.95%) AS400
11 3 (0.95%) Enterprise Software
12 2 (0.63%) Data Structures
12 2 (0.63%) Graphic Design
12 2 (0.63%) Market Risk
12 2 (0.63%) Swaptions
Operating Systems
1 35 (11.04%) Windows
2 9 (2.84%) Linux
3 8 (2.52%) Windows 10
4 7 (2.21%) Unix
5 5 (1.58%) Windows 7
6 4 (1.26%) Windows XP
7 3 (0.95%) Windows Server
8 2 (0.63%) VMS
9 1 (0.32%) CentOS
Processes & Methodologies
1 63 (19.87%) Business Intelligence
2 48 (15.14%) Data Analysis
3 44 (13.88%) Agile Software Development
4 33 (10.41%) Analytics
5 29 (9.15%) Asset Management
6 27 (8.52%) Problem-Solving
6 27 (8.52%) Visualisation
7 24 (7.57%) Migration
8 23 (7.26%) ETL
9 19 (5.99%) Data Modelling
9 19 (5.99%) Mathematics
10 17 (5.36%) Machine Learning
11 15 (4.73%) Low Latency
11 15 (4.73%) MVC
11 15 (4.73%) OO
11 15 (4.73%) Unit Testing
12 14 (4.42%) Change Management
12 14 (4.42%) Data Mapping
12 14 (4.42%) Scrum
12 14 (4.42%) Statistics
Programming Languages
1 207 (65.30%) SQL
2 106 (33.44%) C#
3 72 (22.71%) Python
4 30 (9.46%) VB
5 29 (9.15%) JavaScript
6 25 (7.89%) T-SQL
7 24 (7.57%) VB.NET
8 20 (6.31%) PowerShell
9 18 (5.68%) C++
10 14 (4.42%) R
11 8 (2.52%) C
12 7 (2.21%) ABAP
12 7 (2.21%) MATLAB
12 7 (2.21%) PL/SQL
13 6 (1.89%) TypeScript
14 4 (1.26%) Java
14 4 (1.26%) VBScript
15 3 (0.95%) PHP
16 2 (0.63%) VB6
16 2 (0.63%) VC++
Qualifications
1 38 (11.99%) Degree
2 10 (3.15%) Security Cleared
3 9 (2.84%) SC Cleared
4 5 (1.58%) Numerate Degree
5 4 (1.26%) ITIL Certification
5 4 (1.26%) SAP Certification
6 1 (0.32%) CISSP
6 1 (0.32%) EnCE
6 1 (0.32%) GCFA
6 1 (0.32%) GCFE
6 1 (0.32%) GREM
6 1 (0.32%) HND
6 1 (0.32%) ISTQB
6 1 (0.32%) ISTQB Foundation Certification
6 1 (0.32%) Master's Degree
6 1 (0.32%) Oracle Certification
6 1 (0.32%) PhD
6 1 (0.32%) Postgraduate
6 1 (0.32%) Six Sigma Yellow Belt
6 1 (0.32%) SSCP
Quality Assurance & Compliance
1 21 (6.62%) QA
2 12 (3.79%) Data Quality
3 3 (0.95%) GDPR
3 3 (0.95%) PMO
3 3 (0.95%) SLA
4 1 (0.32%) Basel II
4 1 (0.32%) SNOMED CT
System Software
1 6 (1.89%) VMware Infrastructure
2 5 (1.58%) vSphere
3 4 (1.26%) Active Directory
4 2 (0.63%) Microsoft App-V
5 1 (0.32%) Docker
5 1 (0.32%) Hyper-V
5 1 (0.32%) Virtual Desktop
5 1 (0.32%) Virtual Machines
5 1 (0.32%) VMware Server
Systems Management
1 9 (2.84%) SCCM
2 5 (1.58%) CSIRT
2 5 (1.58%) EnCase
2 5 (1.58%) FTK
3 1 (0.32%) Cisco CUCM
3 1 (0.32%) cPanel
3 1 (0.32%) HP ALM
3 1 (0.32%) Kubernetes
3 1 (0.32%) Opscode Chef
3 1 (0.32%) Puppet
3 1 (0.32%) SCOM
3 1 (0.32%) WSUS
Vendors
1 65 (20.50%) Microsoft
2 43 (13.56%) Oracle
3 26 (8.20%) Tableau
4 20 (6.31%) SAP
5 13 (4.10%) Cognos
6 12 (3.79%) Bloomberg
7 6 (1.89%) VMware
8 5 (1.58%) Atlassian
8 5 (1.58%) Google
9 4 (1.26%) Alteryx
10 3 (0.95%) MAPICS
10 3 (0.95%) PeopleSoft
11 2 (0.63%) Aderant
11 2 (0.63%) Cisco
11 2 (0.63%) IBM
11 2 (0.63%) iManage
11 2 (0.63%) Intapp
11 2 (0.63%) Lotus
11 2 (0.63%) Teradata
11 2 (0.63%) UiPath