Period
to 8 August 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 8 August 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
8 Aug 2020
Same period 2019 Same period 2018
Rank 301 390 384
Rank change year-on-year +89 -6 -80
Contract jobs citing VBA 231 503 611
As % of all contract jobs advertised in England 0.74% 0.61% 0.65%
As % of the Programming Languages category 1.77% 1.42% 1.47%
Number of daily rates quoted 142 351 398
Median daily rate £475 £425 £430
Median daily rate % change year-on-year +11.76% -1.16% +1.18%
10th Percentile £250 £288 £288
90th Percentile £668 £625 £650
UK median daily rate £438 £425 £425
% change year-on-year +2.94% - -
Number of hourly rates quoted 15 22 12
Median hourly rate £20.95 £21.00 £18.09
Median hourly rate % change year-on-year -0.24% +16.12% -26.14%
10th Percentile £15.50 £16.50 £14.98
90th Percentile £56.75 £33.60 £45.08
UK median hourly rate £20.65 £21.00 £18.48
% change year-on-year -1.65% +13.65% -27.38%

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 13,025 35,468 41,640
As % of all contract IT jobs advertised in England 41.69% 42.68% 44.44%
Number of daily rates quoted 8,751 24,791 29,464
Median daily rate £500 £478 £475
Median daily rate % change year-on-year +4.71% +0.53% +5.56%
10th Percentile £325 £325 £313
90th Percentile £688 £650 £638
UK median daily rate £495 £475 £463
% change year-on-year +4.21% +2.70% +2.78%
Number of hourly rates quoted 325 622 701
Median hourly rate £37.00 £45.00 £41.50
Median hourly rate % change year-on-year -17.78% +8.43% +2.47%
10th Percentile £17.75 £20.54 £17.50
90th Percentile £57.50 £55.45 £52.50
Median hourly rate £35.25 £44.00 £40.50
% change year-on-year -19.89% +8.64% +1.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 8 August 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 8 August 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 8 August 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 +90 175 £500 +5.26% 20
North of England +95 20 £202 -47.06% 4
South East +124 14 £190 -52.80% 3
North West +66 12 £191 -45.45% 2
South West +82 9 £288 -17.86% 3
Midlands +61 9 £400 - 6
West Midlands +39 7 £425 +6.25% 3
Yorkshire +63 6 £270 -34.20% 2
East of England +79 4 £504 +11.94% 1
East Midlands +48 2 £383 -6.71% 3
North East +33 2 £303 -28.82%
VBA
UK

For the 6 months to 8 August 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 149 (64.50%) Microsoft Excel
2 146 (63.20%) SQL
3 98 (42.42%) Finance
4 90 (38.96%) Python
5 71 (30.74%) C#
6 69 (29.87%) Banking
7 63 (27.27%) Microsoft
8 62 (26.84%) .NET
9 48 (20.78%) Front Office
10 46 (19.91%) SQL Server
11 40 (17.32%) Data Analysis
12 39 (16.88%) Oracle
13 38 (16.45%) Agile Software Development
14 37 (16.02%) Analytical Skills
15 36 (15.58%) Business Intelligence
16 35 (15.15%) Analytics
16 35 (15.15%) Derivative
17 32 (13.85%) Fixed Income
17 32 (13.85%) Migration
17 32 (13.85%) HTML
18 30 (12.99%) Degree
19 29 (12.55%) JavaScript
19 29 (12.55%) Windows
20 28 (12.12%) Business Analysis
21 27 (11.69%) Asset Management
21 27 (11.69%) C++
21 27 (11.69%) Visualisation
22 26 (11.26%) Azure
22 26 (11.26%) Power BI
22 26 (11.26%) Problem-Solving

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 11 (4.76%) SAS
2 7 (3.03%) SharePoint
3 5 (2.16%) Confluence
3 5 (2.16%) Elasticsearch
3 5 (2.16%) JBoss
3 5 (2.16%) MS Exchange
3 5 (2.16%) NetWeaver
3 5 (2.16%) Tomcat
4 4 (1.73%) Jetty
4 4 (1.73%) MQSeries
4 4 (1.73%) Oracle Self-Service HR
4 4 (1.73%) Red Hat Fuse
4 4 (1.73%) WebLogic
5 3 (1.30%) IIS
6 1 (0.43%) IBM Notes
6 1 (0.43%) Moodle
6 1 (0.43%) WebSphere
6 1 (0.43%) WebSphere Application Server
Applications
1 149 (64.50%) Microsoft Excel
2 18 (7.79%) Microsoft Office
3 9 (3.90%) Spreadsheet
4 6 (2.60%) Microsoft PowerPoint
5 3 (1.30%) Microsoft Project
6 1 (0.43%) MS Visio
6 1 (0.43%) SPSS
Business Applications
1 5 (2.16%) Distributed Ledger
1 5 (2.16%) SAP BPC
2 4 (1.73%) Sentinel
2 4 (1.73%) Sparx Enterprise Architect
2 4 (1.73%) thinkFolio
3 2 (0.87%) Aligne
3 2 (0.87%) Orchestrade
4 1 (0.43%) assyst
4 1 (0.43%) Dynamics CRM
4 1 (0.43%) Maximo
4 1 (0.43%) NetSuite
4 1 (0.43%) ProductWriter
Cloud Services
1 26 (11.26%) Azure
1 26 (11.26%) Power Platform
2 22 (9.52%) AWS
3 15 (6.49%) AWS Lambda
3 15 (6.49%) Azure Functions
3 15 (6.49%) Serverless
4 4 (1.73%) Azure Stack
4 4 (1.73%) Office 365
5 3 (1.30%) Azure Data Factory
5 3 (1.30%) OpenShift
6 1 (0.43%) Amazon EC2
6 1 (0.43%) Amazon S3
6 1 (0.43%) Data Lake Analytics
6 1 (0.43%) GCP
6 1 (0.43%) GitHub
6 1 (0.43%) Mimecast
Communications & Networking
1 5 (2.16%) IP Telephony
1 5 (2.16%) VoIP
2 4 (1.73%) SSH
3 3 (1.30%) F5 BIG-IP GTM
4 2 (0.87%) Ethernet
5 1 (0.43%) 2G
5 1 (0.43%) 3G
5 1 (0.43%) 4G
5 1 (0.43%) 5G
5 1 (0.43%) DNS
5 1 (0.43%) HTTP
5 1 (0.43%) Intranet
5 1 (0.43%) LAN
5 1 (0.43%) Network Security
5 1 (0.43%) Radio Access Network
5 1 (0.43%) Skype
5 1 (0.43%) SSL
5 1 (0.43%) TCP/IP
5 1 (0.43%) UTRAN
Database & Business Intelligence
1 46 (19.91%) SQL Server
2 26 (11.26%) Power BI
3 23 (9.96%) MS Access
4 21 (9.09%) Data Warehouse
5 18 (7.79%) Spotfire
6 17 (7.36%) SQL Server Reporting Services
7 16 (6.93%) OLAP
8 12 (5.19%) Oracle Database
9 9 (3.90%) BusinessObjects
10 7 (3.03%) RDBMS
10 7 (3.03%) Relational Database
11 6 (2.60%) SQL Server Integration Services
12 5 (2.16%) Oracle Reports
12 5 (2.16%) PostgreSQL
12 5 (2.16%) SAP BW
13 4 (1.73%) Hadoop
13 4 (1.73%) MongoDB
13 4 (1.73%) MySQL
14 3 (1.30%) Oracle OLAP
14 3 (1.30%) SQL Server 2008
Development Applications
1 13 (5.63%) Git (software)
2 10 (4.33%) JIRA
3 9 (3.90%) Subversion
4 8 (3.46%) Jenkins
5 4 (1.73%) Ant
5 4 (1.73%) Atlassian Bamboo
5 4 (1.73%) ClearCase
5 4 (1.73%) Cucumber
5 4 (1.73%) Eclipse
5 4 (1.73%) FishEye
5 4 (1.73%) Gradle
5 4 (1.73%) Hudson
5 4 (1.73%) IntelliJ
5 4 (1.73%) Leiningen
5 4 (1.73%) Maven
5 4 (1.73%) Mercurial
5 4 (1.73%) Poseidon for UML
5 4 (1.73%) Selenium
5 4 (1.73%) Vagrant
6 3 (1.30%) JUnit
General
1 98 (42.42%) Finance
2 69 (29.87%) Banking
3 48 (20.78%) Front Office
4 17 (7.36%) Investment Banking
5 11 (4.76%) Public Sector
6 8 (3.46%) Back Office
7 6 (2.60%) Retail
8 4 (1.73%) International Banking
9 3 (1.30%) Financial Institution
9 3 (1.30%) Pharmaceutical
10 2 (0.87%) Billing
10 2 (0.87%) French Language
10 2 (0.87%) Law
11 1 (0.43%) Dutch Language
11 1 (0.43%) General Ledger
11 1 (0.43%) Local Government
11 1 (0.43%) Manufacturing
11 1 (0.43%) Marketing
11 1 (0.43%) Prime Brokerage
11 1 (0.43%) Social Science
Job Titles
1 118 (51.08%) Developer
2 60 (25.97%) Analyst
3 40 (17.32%) VBA Developer
4 34 (14.72%) C# Developer
5 21 (9.09%) .NET Developer
6 20 (8.66%) Python Developer
7 19 (8.23%) Data Analyst
8 18 (7.79%) Junior
9 17 (7.36%) SQL Developer
10 16 (6.93%) C# .NET Developer
10 16 (6.93%) Excel Developer
11 15 (6.49%) Excel VBA Developer
12 11 (4.76%) Business Analyst
13 10 (4.33%) Applications Developer
13 10 (4.33%) Azure Developer
14 9 (3.90%) Finance Manager
14 9 (3.90%) Junior Analyst
14 9 (3.90%) Junior Developer
14 9 (3.90%) RAD Developer
15 7 (3.03%) Access Developer
Libraries, Frameworks & Software Standards
1 62 (26.84%) .NET
2 32 (13.85%) HTML
3 21 (9.09%) CSS
4 18 (7.79%) ASP.NET
5 14 (6.06%) XML
6 12 (5.19%) JSON
7 11 (4.76%) AngularJS
8 10 (4.33%) WPF
9 9 (3.90%) WinForms
10 8 (3.46%) .NET Framework
10 8 (3.46%) HTML5
11 7 (3.03%) Spring
12 5 (2.16%) ODBC
12 5 (2.16%) React
12 5 (2.16%) REST
12 5 (2.16%) Smart Contracts
12 5 (2.16%) Spring Boot
13 4 (1.73%) Apache Camel
13 4 (1.73%) Play Framework
13 4 (1.73%) RabbitMQ
Miscellaneous
1 37 (16.02%) Analytical Skills
2 35 (15.15%) Derivative
3 32 (13.85%) Fixed Income
4 17 (7.36%) OTC Derivatives
5 13 (5.63%) Foreign Exchange (FX)
5 13 (5.63%) Hedge funds
6 9 (3.90%) Credit Risk
7 8 (3.46%) User Experience
8 6 (2.60%) Self-Motivation
9 5 (2.16%) Mainframe
9 5 (2.16%) Management Information System
10 4 (1.73%) Algorithms
10 4 (1.73%) Cloud Native
11 3 (1.30%) Analytical Mindset
11 3 (1.30%) Data Centre
11 3 (1.30%) Enterprise Software
11 3 (1.30%) Market Risk
11 3 (1.30%) NHS
12 2 (0.87%) Blackberry
12 2 (0.87%) Equity Derivative
Operating Systems
1 29 (12.55%) Windows
2 9 (3.90%) Apple iOS
3 7 (3.03%) Linux
3 7 (3.03%) Windows 10
4 5 (2.16%) Windows Server
5 4 (1.73%) Android
5 4 (1.73%) CentOS
5 4 (1.73%) Debian
5 4 (1.73%) Mac OS X
5 4 (1.73%) Red Hat Enterprise Linux
5 4 (1.73%) Ubuntu
6 3 (1.30%) Windows 7
6 3 (1.30%) Windows XP
7 1 (0.43%) Unix
Processes & Methodologies
1 40 (17.32%) Data Analysis
2 38 (16.45%) Agile Software Development
3 36 (15.58%) Business Intelligence
4 35 (15.15%) Analytics
5 32 (13.85%) Migration
6 28 (12.12%) Business Analysis
7 27 (11.69%) Asset Management
7 27 (11.69%) Visualisation
8 26 (11.26%) Problem-Solving
9 24 (10.39%) Scrum
10 19 (8.23%) Mathematics
11 17 (7.36%) DevOps
11 17 (7.36%) Investment Management
11 17 (7.36%) Risk Management
12 16 (6.93%) Machine Learning
13 14 (6.06%) ITIL
13 14 (6.06%) Performance Attribution
13 14 (6.06%) Test Automation
14 13 (5.63%) Risk Analysis
15 12 (5.19%) Fund Management
Programming Languages
1 146 (63.20%) SQL
2 90 (38.96%) Python
3 71 (30.74%) C#
4 29 (12.55%) JavaScript
5 27 (11.69%) C++
6 21 (9.09%) Java
6 21 (9.09%) R
7 19 (8.23%) VB
8 13 (5.63%) MATLAB
9 12 (5.19%) VB.NET
10 11 (4.76%) T-SQL
11 7 (3.03%) PL/SQL
12 6 (2.60%) C
12 6 (2.60%) Perl
13 5 (2.16%) ABAP
13 5 (2.16%) Bash Shell
13 5 (2.16%) PowerShell
14 4 (1.73%) Clojure
14 4 (1.73%) Groovy
14 4 (1.73%) Scala
Qualifications
1 30 (12.99%) Degree
2 9 (3.90%) Security Cleared
3 8 (3.46%) SC Cleared
4 5 (2.16%) Oracle Certification
5 4 (1.73%) ITIL Certification
5 4 (1.73%) SAP Certification
6 3 (1.30%) PhD
7 2 (0.87%) Master's Degree
7 2 (0.87%) Numerate Degree
8 1 (0.43%) CFA
8 1 (0.43%) DV Cleared
8 1 (0.43%) HNC
8 1 (0.43%) HND
8 1 (0.43%) ISTQB
8 1 (0.43%) ISTQB Foundation Certification
8 1 (0.43%) MBA
Quality Assurance & Compliance
1 20 (8.66%) QA
2 9 (3.90%) Data Quality
3 4 (1.73%) PMO
4 1 (0.43%) Basel II
4 1 (0.43%) CRD IV
4 1 (0.43%) IFRS
4 1 (0.43%) IFRS 9
4 1 (0.43%) SLA
System Software
1 3 (1.30%) VMware Infrastructure
2 1 (0.43%) Active Directory
2 1 (0.43%) Hyper-V
2 1 (0.43%) Microsoft App-V
2 1 (0.43%) Virtual Machines
2 1 (0.43%) VMware Workstation
2 1 (0.43%) vSphere
2 1 (0.43%) XenApp
2 1 (0.43%) XenDesktop
Systems Management
1 5 (2.16%) Puppet
2 4 (1.73%) Ansible
2 4 (1.73%) Salt
3 3 (1.30%) Kubernetes
3 3 (1.30%) SafeCom
4 2 (0.87%) SCCM
5 1 (0.43%) Failover Clustering
5 1 (0.43%) HP ALM
5 1 (0.43%) HP Quality Center
5 1 (0.43%) Kibana
5 1 (0.43%) Opscode Chef
Vendors
1 63 (27.27%) Microsoft
2 39 (16.88%) Oracle
3 22 (9.52%) Bloomberg
4 15 (6.49%) Cognos
5 10 (4.33%) Tableau
6 7 (3.03%) SAP
7 6 (2.60%) Sybase
8 5 (2.16%) Alteryx
8 5 (2.16%) Apple
8 5 (2.16%) HP
8 5 (2.16%) Red Hat
9 4 (1.73%) Atlassian
9 4 (1.73%) Axway
9 4 (1.73%) Charles River
9 4 (1.73%) Cloudera
9 4 (1.73%) Hortonworks
9 4 (1.73%) MuleSoft
9 4 (1.73%) SimCorp
9 4 (1.73%) Sparx
10 3 (1.30%) Infoblox