Period
to 17 January 2021

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 17 January 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)
UK
6 months to
17 Jan 2021
Same period 2020 Same period 2019
Rank 370 393 390
Rank change year-on-year +23 -3 -58
Contract jobs citing VBA 227 417 657
As % of all contract jobs advertised in the UK 0.56% 0.57% 0.66%
As % of the Programming Languages category 1.35% 1.40% 1.49%
Number of daily rates quoted 188 279 468
Median daily rate £426 £450 £400
Median daily rate % change year-on-year -5.28% +12.50% -5.88%
10th Percentile £250 £281 £254
90th Percentile £600 £628 £613
UK excluding London median daily rate £425 £400 £375
% change year-on-year +6.25% +6.67% +5.63%
Number of hourly rates quoted 8 23 11
Median hourly rate £20.90 £21.00 £18.00
Median hourly rate % change year-on-year -0.48% +16.67% -36.84%
10th Percentile £15.43 £13.52 £17.00
90th Percentile £27.51 £37.40 £35.50
UK excluding London median hourly rate £19.25 £21.91 £18.11
% change year-on-year -12.14% +20.98% -36.46%

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 16,798 29,731 44,092
As % of all contract IT jobs advertised in the UK 41.47% 40.81% 44.34%
Number of daily rates quoted 11,677 20,805 31,314
Median daily rate £475 £475 £475
10th Percentile £313 £325 £319
90th Percentile £663 £650 £650
UK excluding London median daily rate £425 £430 £425
% change year-on-year -1.16% +1.18% +6.25%
Number of hourly rates quoted 397 546 640
Median hourly rate £42.50 £43.50 £42.19
Median hourly rate % change year-on-year -2.30% +3.11% +5.48%
10th Percentile £13.32 £16.53 £16.96
90th Percentile £58.75 £55.00 £51.25
Median hourly rate £42.00 £42.50 £42.50
% change year-on-year -1.18% - +6.25%

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 17 January 2021.

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 17 January 2021.

Hourly rate histogram for VBA in the UK

VBA
Top 16 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 17 January 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
England +48 198 £425 -5.56% 55
London +37 126 £435 -13.00% 25
UK excluding London +66 71 £425 +6.25% 32
Work from Home -140 49 £425 -9.57% 3
North of England +81 39 £425 +6.25% 4
North West +48 22 £400 - 3
North East +43 11 £438 +2.94%
South East +101 9 £450 +32.35% 13
Midlands +45 8 £445 -1.11% 3
South West +71 6 £500 +16.96% 4
Yorkshire +47 6 £375 -9.09% 1
East Midlands +42 4 £525 +61.54% 1
West Midlands +37 4 £238 -56.82% 2
Scotland +34 4 £400 -8.57% 1
Wales +32 3 £145 -
East of England +44 2 £288 +15.22% 6

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

1 123 (54.19%) Microsoft Excel
2 109 (48.02%) SQL
3 72 (31.72%) Python
3 72 (31.72%) Finance
4 48 (21.15%) Banking
5 41 (18.06%) Front Office
5 41 (18.06%) SQL Server
6 38 (16.74%) Microsoft
7 35 (15.42%) Windows
8 34 (14.98%) MS Access
9 33 (14.54%) Analytical Skills
10 29 (12.78%) Data Modelling
11 28 (12.33%) C#
11 28 (12.33%) Business Intelligence
12 27 (11.89%) VB
12 27 (11.89%) Agile Software Development
13 26 (11.45%) JavaScript
14 25 (11.01%) Oracle
14 25 (11.01%) Analytics
14 25 (11.01%) Security Cleared
14 25 (11.01%) Power Platform
15 23 (10.13%) Data Analysis
16 22 (9.69%) Azure
16 22 (9.69%) Power BI
16 22 (9.69%) Public Sector
17 20 (8.81%) C++
17 20 (8.81%) .NET
18 18 (7.93%) SC Cleared
19 17 (7.49%) Unix
19 17 (7.49%) Fixed Income

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 11 (4.85%) SAS
2 8 (3.52%) Confluence
2 8 (3.52%) SharePoint
3 6 (2.64%) JBoss
3 6 (2.64%) Tomcat
4 5 (2.20%) Elasticsearch
4 5 (2.20%) Jetty
4 5 (2.20%) MQSeries
4 5 (2.20%) Oracle Self-Service HR
4 5 (2.20%) Red Hat Fuse
4 5 (2.20%) WebLogic
5 4 (1.76%) Jupyter
6 3 (1.32%) Moodle
7 2 (0.88%) MS Exchange
8 1 (0.44%) ArcGIS
8 1 (0.44%) IIS
8 1 (0.44%) WebSphere
8 1 (0.44%) WebSphere Application Server
Applications
1 123 (54.19%) Microsoft Excel
2 14 (6.17%) Microsoft Office
3 10 (4.41%) Spreadsheet
4 5 (2.20%) Microsoft PowerPoint
5 2 (0.88%) MS Visio
5 2 (0.88%) SPSS
6 1 (0.44%) Microsoft Project
6 1 (0.44%) Stata
Business Applications
1 5 (2.20%) Sparx Enterprise Architect
2 2 (0.88%) Dynamics GP
2 2 (0.88%) Endur
3 1 (0.44%) Cognos Business Intelligence
3 1 (0.44%) Dynamics AX
3 1 (0.44%) Dynamics CRM
3 1 (0.44%) Dynamics NAV
3 1 (0.44%) Findur
3 1 (0.44%) Markit EDM
3 1 (0.44%) Oracle EBS R12
3 1 (0.44%) Oracle Financials
3 1 (0.44%) Sage 200
3 1 (0.44%) Sentinel
3 1 (0.44%) thinkFolio
Cloud Services
1 25 (11.01%) Power Platform
2 22 (9.69%) Azure
3 14 (6.17%) AWS
4 5 (2.20%) AWS Lambda
4 5 (2.20%) Azure Functions
4 5 (2.20%) Serverless
5 4 (1.76%) PowerApps
6 3 (1.32%) Power Automate
7 2 (0.88%) Azure Stack
7 2 (0.88%) Dynamics 365
7 2 (0.88%) Office 365
7 2 (0.88%) SuccessFactors
7 2 (0.88%) Taleo
8 1 (0.44%) Azure Data Factory
8 1 (0.44%) Data Lake Analytics
8 1 (0.44%) GitHub
8 1 (0.44%) IaaS
8 1 (0.44%) PaaS
8 1 (0.44%) SaaS
Communications & Networking
1 8 (3.52%) F5 BIG-IP GTM
2 5 (2.20%) SSH
3 4 (1.76%) Firewall
4 2 (0.88%) IP Telephony
4 2 (0.88%) VoIP
5 1 (0.44%) DNS
5 1 (0.44%) HTTP
5 1 (0.44%) SSL
Database & Business Intelligence
1 41 (18.06%) SQL Server
2 34 (14.98%) MS Access
3 22 (9.69%) Power BI
4 15 (6.61%) BusinessObjects
5 11 (4.85%) SQL Server Reporting Services
6 10 (4.41%) Tableau
7 9 (3.96%) Hadoop
8 8 (3.52%) MySQL
8 8 (3.52%) Oracle Database
8 8 (3.52%) Qlik Sense
9 7 (3.08%) Data Warehouse
9 7 (3.08%) Spotfire
10 6 (2.64%) SQL Server Integration Services
11 5 (2.20%) DB2
11 5 (2.20%) MongoDB
11 5 (2.20%) PostgreSQL
12 4 (1.76%) Big Data
12 4 (1.76%) RDBMS
12 4 (1.76%) Relational Database
12 4 (1.76%) SAP Data Services
Development Applications
1 12 (5.29%) JIRA
2 10 (4.41%) Git (software)
3 9 (3.96%) Jenkins
4 7 (3.08%) Subversion
5 6 (2.64%) Selenium
6 5 (2.20%) Ant
6 5 (2.20%) Atlassian Bamboo
6 5 (2.20%) ClearCase
6 5 (2.20%) Cucumber
6 5 (2.20%) Eclipse
6 5 (2.20%) FishEye
6 5 (2.20%) Gradle
6 5 (2.20%) Hudson
6 5 (2.20%) IntelliJ
6 5 (2.20%) Leiningen
6 5 (2.20%) Maven
6 5 (2.20%) Mercurial
6 5 (2.20%) Poseidon for UML
6 5 (2.20%) Vagrant
7 3 (1.32%) Bitbucket
General
1 72 (31.72%) Finance
2 48 (21.15%) Banking
3 41 (18.06%) Front Office
4 22 (9.69%) Public Sector
5 12 (5.29%) Investment Banking
6 7 (3.08%) Retail
7 5 (2.20%) Financial Institution
8 3 (1.32%) Local Government
8 3 (1.32%) Pharmaceutical
9 2 (0.88%) Electronics
9 2 (0.88%) Legal
9 2 (0.88%) Manufacturing
9 2 (0.88%) Marketing
9 2 (0.88%) Telecoms
10 1 (0.44%) Advertising
10 1 (0.44%) Law
10 1 (0.44%) Military
Job Titles
1 81 (35.68%) Developer
2 61 (26.87%) Analyst
3 27 (11.89%) VBA Developer
4 25 (11.01%) Data Analyst
5 20 (8.81%) Data Engineer
6 19 (8.37%) Consultant
7 14 (6.17%) Business Analyst
7 14 (6.17%) C# Developer
8 13 (5.73%) Excel Developer
8 13 (5.73%) Python Developer
9 12 (5.29%) Data Manager
10 11 (4.85%) Front Office Developer
10 11 (4.85%) SQL Developer
11 10 (4.41%) Excel VBA Developer
12 8 (3.52%) .NET Developer
12 8 (3.52%) Access Developer
12 8 (3.52%) Qualitative Analyst
12 8 (3.52%) Quantitative Analyst
13 6 (2.64%) RAD Developer
13 6 (2.64%) VB Developer
Libraries, Frameworks & Software Standards
1 20 (8.81%) .NET
2 15 (6.61%) XML
3 13 (5.73%) HTML
3 13 (5.73%) JSON
4 7 (3.08%) Flash
4 7 (3.08%) HTML5
4 7 (3.08%) WinForms
5 6 (2.64%) .NET Framework
5 6 (2.64%) AngularJS
5 6 (2.64%) CSS
5 6 (2.64%) jQuery
5 6 (2.64%) React
6 5 (2.20%) Apache Camel
6 5 (2.20%) GWT
6 5 (2.20%) Node.js
6 5 (2.20%) NumPy
6 5 (2.20%) Pandas
6 5 (2.20%) Play Framework
6 5 (2.20%) RabbitMQ
6 5 (2.20%) SciPy
Miscellaneous
1 33 (14.54%) Analytical Skills
2 17 (7.49%) Fixed Income
3 11 (4.85%) Derivative
3 11 (4.85%) Foreign Exchange (FX)
4 8 (3.52%) Equities
4 8 (3.52%) User Experience
5 6 (2.64%) Market Risk
5 6 (2.64%) NHS
6 5 (2.20%) Grid Computing
6 5 (2.20%) Management Information System
7 3 (1.32%) Credit Risk
7 3 (1.32%) Data Centre
7 3 (1.32%) Data Structures
7 3 (1.32%) Self-Motivation
8 2 (0.88%) Cloud Native
8 2 (0.88%) Mainframe
8 2 (0.88%) Reference Data
9 1 (0.44%) Blackberry
9 1 (0.44%) Client/Server
9 1 (0.44%) FMCG
Operating Systems
1 35 (15.42%) Windows
2 17 (7.49%) Unix
3 13 (5.73%) Linux
4 11 (4.85%) AIX
5 7 (3.08%) Apple iOS
6 5 (2.20%) Android
6 5 (2.20%) CentOS
6 5 (2.20%) Debian
6 5 (2.20%) Mac OS X
6 5 (2.20%) Red Hat Enterprise Linux
6 5 (2.20%) Ubuntu
7 4 (1.76%) Windows 10
7 4 (1.76%) Windows Server
8 1 (0.44%) Solaris
8 1 (0.44%) Windows Server 2012
Processes & Methodologies
1 29 (12.78%) Data Modelling
2 28 (12.33%) Business Intelligence
3 27 (11.89%) Agile Software Development
4 25 (11.01%) Analytics
5 23 (10.13%) Data Analysis
6 16 (7.05%) Problem-Solving
6 16 (7.05%) Stakeholder Management
6 16 (7.05%) Test Automation
7 15 (6.61%) Continuous Improvement
7 15 (6.61%) Data Management
7 15 (6.61%) Migration
7 15 (6.61%) Visualisation
8 14 (6.17%) Decision-Making
8 14 (6.17%) ETL
8 14 (6.17%) Scrum
9 13 (5.73%) DevOps
9 13 (5.73%) Validation
10 11 (4.85%) Data Engineering
11 10 (4.41%) Business Analysis
11 10 (4.41%) Project Management
Programming Languages
1 109 (48.02%) SQL
2 72 (31.72%) Python
3 28 (12.33%) C#
4 27 (11.89%) VB
5 26 (11.45%) JavaScript
6 20 (8.81%) C++
7 16 (7.05%) Java
8 12 (5.29%) Perl
9 10 (4.41%) T-SQL
10 9 (3.96%) PL/SQL
10 9 (3.96%) PowerShell
11 8 (3.52%) Bash Shell
11 8 (3.52%) Scala
12 7 (3.08%) VBScript
13 6 (2.64%) R
14 5 (2.20%) Clojure
14 5 (2.20%) ClojureScript
14 5 (2.20%) Groovy
14 5 (2.20%) Ruby
14 5 (2.20%) VB.NET
Qualifications
1 25 (11.01%) Security Cleared
2 18 (7.93%) SC Cleared
3 15 (6.61%) Degree
4 7 (3.08%) DV Cleared
5 3 (1.32%) BPSS Clearance
6 2 (0.88%) CFA
6 2 (0.88%) Microsoft Certification
6 2 (0.88%) Oracle Certification
7 1 (0.44%) AAT
7 1 (0.44%) Master's Degree
7 1 (0.44%) PhD
Quality Assurance & Compliance
1 11 (4.85%) QA
2 8 (3.52%) GDPR
3 6 (2.64%) Data Quality
4 5 (2.20%) PMO
5 2 (0.88%) CRD IV
5 2 (0.88%) IFRS
5 2 (0.88%) IFRS 9
6 1 (0.44%) Basel II
6 1 (0.44%) Basel III
6 1 (0.44%) COREP
System Software
1 3 (1.32%) HDFS
2 1 (0.44%) Docker
2 1 (0.44%) Microsoft App-V
2 1 (0.44%) Virtual Machines
2 1 (0.44%) VMware Infrastructure
Systems Management
1 9 (3.96%) Ansible
2 6 (2.64%) Puppet
3 5 (2.20%) Salt
4 2 (0.88%) SCCM
5 1 (0.44%) Control-M
5 1 (0.44%) HP Quality Center
5 1 (0.44%) Kibana
5 1 (0.44%) Opscode Chef
5 1 (0.44%) SafeCom
Vendors
1 38 (16.74%) Microsoft
2 25 (11.01%) Oracle
3 11 (4.85%) Informatica
3 11 (4.85%) SAP
4 8 (3.52%) F5
4 8 (3.52%) Infoblox
5 7 (3.08%) Alteryx
6 6 (2.64%) Bloomberg
6 6 (2.64%) Red Hat
6 6 (2.64%) Sybase
7 5 (2.20%) Axway
7 5 (2.20%) Cloudera
7 5 (2.20%) Cognos
7 5 (2.20%) Hortonworks
7 5 (2.20%) MuleSoft
7 5 (2.20%) Sparx
7 5 (2.20%) Splunk
8 4 (1.76%) Dataiku
9 3 (1.32%) Talend
9 3 (1.32%) Workday