Period
to 12 December 2019

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 12 December 2019 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
12 Dec 2019
Same period 2018 Same period 2017
Rank 394 385 323
Rank change year-on-year -9 -62 +15
Contract jobs citing VBA 474 687 838
As % of all contract IT jobs advertised in the UK 0.59% 0.65% 0.81%
As % of the Programming Languages category 1.44% 1.46% 1.93%
Number of daily rates quoted 316 462 573
UK median daily rate £450 £400 £450
Median daily rate % change year-on-year +12.50% -11.11% +20.00%
10th Percentile £263 £253 £275
90th Percentile £625 £650 £675
UK excluding London median daily rate £400 £360 £355
% change year-on-year +11.11% +1.41% +1.43%
Number of hourly rates quoted 26 11 16
UK median hourly rate £21.00 £18.00 £25.49
Median hourly rate % change year-on-year +16.67% -29.39% +53.06%
10th Percentile £14.75 £14.50 £17.75
90th Percentile £36.50 £30.00 £41.04
UK excluding London median hourly rate £20.50 £17.75 £26.50
% change year-on-year +15.49% -33.02% +35.90%

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 32,965 47,118 43,396
As % of all contract IT jobs advertised in the UK 41.19% 44.74% 41.99%
Number of daily rates quoted 22,676 33,185 30,443
UK median daily rate £475 £475 £450
Median daily rate % change year-on-year - +5.56% +5.88%
10th Percentile £323 £319 £308
90th Percentile £650 £644 £638
UK excluding London median daily rate £425 £425 £400
% change year-on-year - +6.25% +6.67%
Number of hourly rates quoted 673 694 782
UK median hourly rate £43.00 £42.00 £40.00
Median hourly rate % change year-on-year +2.38% +5.00% +1.98%
10th Percentile £17.30 £16.37 £16.25
90th Percentile £55.00 £52.50 £52.23
UK excluding London median hourly rate £42.50 £42.50 £40.00
% change year-on-year - +6.25% +1.43%

VBA
Job Vacancy Trend

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

Job vacancy trend for VBA in the UK

VBA
Contractor Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing VBA.

Contractor daily rate trend for VBA in the UK

VBA
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing VBA over the 6 months to 12 December 2019.

Contractor daily rate histogram for VBA in the UK

VBA
Contractor Hourly Rate Trend

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing VBA.

Contractor hourly rate trend for VBA in the UK

VBA
Contractor Hourly Rate Histogram

The hourly rate distribution of IT jobs citing VBA over the 6 months to 12 December 2019.

Contractor hourly rate histogram for VBA in the UK

VBA
Top 15 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 12 December 2019. 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 +14 446 £449 +5.59% 128
London +6 248 £488 +8.33% 56
UK excluding London +30 220 £400 +11.11% 81
North of England +57 66 £400 +12.68% 19
South East +44 62 £363 -2.03% 17
North West +45 52 £400 +9.59% 10
Midlands +53 30 £388 +3.33% 13
West Midlands +51 24 £350 -6.67% 10
South West -25 23 £408 -2.69% 16
Scotland -4 18 £450 +38.46% 6
East of England +44 17 £250 -37.58% 7
Yorkshire +26 11 £425 +19.72% 9
East Midlands +21 6 £425 +26.39% 3
North East +19 4 £425 +103.59%
Wales +13 4 £375 +11.11% 3

For the 6 months to 12 December 2019, 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 289 (60.97%) Microsoft Excel
2 288 (60.76%) SQL
3 165 (34.81%) Finance
4 120 (25.32%) .NET
5 119 (25.11%) C#
6 114 (24.05%) Microsoft
7 104 (21.94%) SQL Server
8 92 (19.41%) Python
9 79 (16.67%) Business Intelligence
10 78 (16.46%) Analytical Skills
11 72 (15.19%) Banking
12 70 (14.77%) Windows
13 68 (14.35%) Agile Software Development
14 63 (13.29%) MS Access
15 49 (10.34%) Oracle
15 49 (10.34%) Power Platform
16 48 (10.13%) Power BI
17 47 (9.92%) JavaScript
18 46 (9.70%) Data Analysis
19 44 (9.28%) Problem-Solving
20 43 (9.07%) Azure
20 43 (9.07%) MS Visio
21 42 (8.86%) Front Office
22 41 (8.65%) Analytics
23 40 (8.44%) PowerShell
24 39 (8.23%) SQL Server Integration Services
25 38 (8.02%) SQL Server Reporting Services
25 38 (8.02%) MongoDB
25 38 (8.02%) NoSQL
26 37 (7.81%) Visualisation

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 31 (6.54%) SharePoint
2 15 (3.16%) Confluence
2 15 (3.16%) SAS
3 7 (1.48%) IIS
4 6 (1.27%) MS Exchange
5 5 (1.05%) Captiva
5 5 (1.05%) Documentum
5 5 (1.05%) Elasticsearch
5 5 (1.05%) Tomcat
6 4 (0.84%) JBoss
6 4 (0.84%) Jetty
6 4 (0.84%) Oracle Self-Service HR
6 4 (0.84%) WebLogic
7 3 (0.63%) Apache Spark
8 2 (0.42%) Exchange Server 2003
8 2 (0.42%) Exchange Server 2010
8 2 (0.42%) MQSeries
8 2 (0.42%) NetWeaver
8 2 (0.42%) Skype for Business
9 1 (0.21%) Apache Solr
Applications
1 289 (60.97%) Microsoft Excel
2 43 (9.07%) MS Visio
3 32 (6.75%) Microsoft Office
4 19 (4.01%) Microsoft PowerPoint
5 17 (3.59%) Spreadsheet
6 7 (1.48%) Microsoft Project
7 4 (0.84%) SPSS
8 2 (0.42%) InfoPath
8 2 (0.42%) PTC Creo
8 2 (0.42%) Windchill
Business Applications
1 8 (1.69%) Dynamics CRM
2 6 (1.27%) Misys Opics
3 5 (1.05%) SAP BPC
4 4 (0.84%) Cognos TM1
4 4 (0.84%) HFM
5 3 (0.63%) SAP ERP
6 2 (0.42%) Infor SunSystems
6 2 (0.42%) SAP Oil and Gas
7 1 (0.21%) Eagle PACE
7 1 (0.21%) LatentZero
7 1 (0.21%) LongView
7 1 (0.21%) Magento
7 1 (0.21%) Markit EDM
7 1 (0.21%) Sparx Enterprise Architect
7 1 (0.21%) thinkFolio
Cloud Services
1 49 (10.34%) Power Platform
2 43 (9.07%) Azure
3 23 (4.85%) AWS
4 17 (3.59%) Office 365
5 12 (2.53%) AWS Lambda
5 12 (2.53%) Azure Functions
5 12 (2.53%) Serverless
6 11 (2.32%) SaaS
7 5 (1.05%) SuccessFactors
8 3 (0.63%) Adobe Analytics
9 2 (0.42%) GCP
9 2 (0.42%) GitHub
9 2 (0.42%) OneDrive
9 2 (0.42%) Trello
10 1 (0.21%) Azure Active Directory
10 1 (0.21%) Azure Data Factory
10 1 (0.21%) Dynamics 365
10 1 (0.21%) OpenShift
10 1 (0.21%) PaaS
10 1 (0.21%) PowerApps
Communications & Networking
1 11 (2.32%) ICMP
1 11 (2.32%) SNMP
1 11 (2.32%) Telnet
2 5 (1.05%) Firewall
3 4 (0.84%) SSH
4 3 (0.63%) DNS
4 3 (0.63%) Intranet
5 2 (0.42%) Ethernet
5 2 (0.42%) Internet
5 2 (0.42%) PuTTY
5 2 (0.42%) Radio Access Network
5 2 (0.42%) VPN
6 1 (0.21%) GPRS
6 1 (0.21%) GSM
6 1 (0.21%) HTTP
6 1 (0.21%) LAN
6 1 (0.21%) Skype
6 1 (0.21%) TCP/IP
6 1 (0.21%) UMTS
6 1 (0.21%) VoIP
Database & Business Intelligence
1 104 (21.94%) SQL Server
2 63 (13.29%) MS Access
3 48 (10.13%) Power BI
4 39 (8.23%) SQL Server Integration Services
5 38 (8.02%) MongoDB
5 38 (8.02%) NoSQL
5 38 (8.02%) SQL Server Reporting Services
6 33 (6.96%) Data Warehouse
7 22 (4.64%) Relational Database
8 19 (4.01%) Oracle Database
8 19 (4.01%) SQL Server Analysis Services
9 14 (2.95%) Spotfire
10 12 (2.53%) Crystal Reports
11 11 (2.32%) BusinessObjects
11 11 (2.32%) MySQL
11 11 (2.32%) Oracle Reports
12 8 (1.69%) Data Mining
13 6 (1.27%) Oracle Database 10g
13 6 (1.27%) PostgreSQL
13 6 (1.27%) SQL Server 2005
Development Applications
1 27 (5.70%) NUnit
2 18 (3.80%) JIRA
3 17 (3.59%) Git (software)
4 11 (2.32%) Team Foundation Server
5 9 (1.90%) Subversion
6 7 (1.48%) Cucumber
7 6 (1.27%) Selenium
7 6 (1.27%) Visual Studio
8 5 (1.05%) Jenkins
8 5 (1.05%) TeamCity
9 4 (0.84%) Atlassian Bamboo
9 4 (0.84%) FishEye
9 4 (0.84%) Gradle
9 4 (0.84%) Hudson
9 4 (0.84%) IBM UrbanCode
9 4 (0.84%) Leiningen
9 4 (0.84%) Mercurial
9 4 (0.84%) Poseidon for UML
9 4 (0.84%) Sourcetree
9 4 (0.84%) Vagrant
General
1 165 (34.81%) Finance
2 72 (15.19%) Banking
3 42 (8.86%) Front Office
4 21 (4.43%) Public Sector
5 16 (3.38%) Publishing
6 14 (2.95%) Legal
6 14 (2.95%) Manufacturing
7 10 (2.11%) Investment Banking
7 10 (2.11%) Military
8 9 (1.90%) Financial Institution
8 9 (1.90%) Telecoms
9 8 (1.69%) Back Office
10 7 (1.48%) Retail
11 5 (1.05%) Law
11 5 (1.05%) Marketing
12 4 (0.84%) Retail Banking
13 3 (0.63%) Games
13 3 (0.63%) Local Government
14 2 (0.42%) Automotive
14 2 (0.42%) Electronics
Job Titles
1 210 (44.30%) Developer
2 126 (26.58%) Analyst
3 63 (13.29%) VBA Developer
4 56 (11.81%) .NET Developer
5 47 (9.92%) Data Analyst
5 47 (9.92%) SQL Developer
6 37 (7.81%) C# Developer
7 26 (5.49%) Excel Developer
8 24 (5.06%) Excel VBA Developer
9 21 (4.43%) C# .NET Developer
10 18 (3.80%) Senior Developer
11 17 (3.59%) Business Analyst
11 17 (3.59%) Python Developer
12 16 (3.38%) SQL Analyst
13 15 (3.16%) Access Developer
13 15 (3.16%) Architect
14 14 (2.95%) Senior .NET Developer
15 12 (2.53%) Applications Support
15 12 (2.53%) Excel Analyst
15 12 (2.53%) Financial Analyst
Libraries, Frameworks & Software Standards
1 120 (25.32%) .NET
2 36 (7.59%) ASP.NET
3 34 (7.17%) HTML
4 26 (5.49%) XML
5 17 (3.59%) JSON
6 15 (3.16%) CSS
6 15 (3.16%) React
7 14 (2.95%) .NET Framework
7 14 (2.95%) AngularJS
8 12 (2.53%) WinForms
9 11 (2.32%) WPF
10 6 (1.27%) jQuery
10 6 (1.27%) SignalR
11 5 (1.05%) ASP.NET Core
11 5 (1.05%) ASP.NET MVC
11 5 (1.05%) ASP.NET Web API
11 5 (1.05%) HTML5
11 5 (1.05%) JPA
11 5 (1.05%) Node.js
11 5 (1.05%) Pandas
Miscellaneous
1 78 (16.46%) Analytical Skills
2 16 (3.38%) Derivative
2 16 (3.38%) Self-Motivation
3 10 (2.11%) Fixed Income
4 8 (1.69%) Foreign Exchange (FX)
4 8 (1.69%) Management Information System
5 6 (1.27%) Data Structures
5 6 (1.27%) NHS
5 6 (1.27%) User Experience
6 5 (1.05%) AS400
6 5 (1.05%) Equities
6 5 (1.05%) Greenfield Project
6 5 (1.05%) Smartphone
7 4 (0.84%) Credit Risk
7 4 (0.84%) Hedge funds
7 4 (0.84%) OTC Derivatives
8 3 (0.63%) Market Risk
8 3 (0.63%) Swaptions
9 2 (0.42%) Enterprise Software
9 2 (0.42%) Robotics
Operating Systems
1 70 (14.77%) Windows
2 27 (5.70%) Windows 10
3 24 (5.06%) Linux
4 18 (3.80%) Windows 7
5 16 (3.38%) Windows Server
6 11 (2.32%) Android
7 9 (1.90%) Unix
8 7 (1.48%) Apple iOS
9 5 (1.05%) CentOS
9 5 (1.05%) Windows Mobile
10 4 (0.84%) Debian
10 4 (0.84%) Mac OS X
10 4 (0.84%) Red Hat Enterprise Linux
10 4 (0.84%) Ubuntu
11 3 (0.63%) VMS
11 3 (0.63%) Windows Server 2003
11 3 (0.63%) Windows Server 2008
11 3 (0.63%) Windows Server 2012
12 1 (0.21%) OpenVMS
12 1 (0.21%) Windows XP
Processes & Methodologies
1 79 (16.67%) Business Intelligence
2 68 (14.35%) Agile Software Development
3 46 (9.70%) Data Analysis
4 44 (9.28%) Problem-Solving
5 41 (8.65%) Analytics
6 37 (7.81%) Visualisation
7 36 (7.59%) MVC
8 35 (7.38%) Migration
9 33 (6.96%) Stakeholder Management
10 31 (6.54%) Unit Testing
11 28 (5.91%) Project Management
12 26 (5.49%) ETL
13 25 (5.27%) ITIL
14 23 (4.85%) Asset Management
15 22 (4.64%) Scrum
16 21 (4.43%) Mathematics
16 21 (4.43%) Sprint Planning
16 21 (4.43%) Statistics
16 21 (4.43%) Validation
17 20 (4.22%) DevOps
Programming Languages
1 288 (60.76%) SQL
2 119 (25.11%) C#
3 92 (19.41%) Python
4 47 (9.92%) JavaScript
5 40 (8.44%) PowerShell
6 37 (7.81%) T-SQL
7 35 (7.38%) VB
8 34 (7.17%) VB.NET
9 27 (5.70%) Java
10 23 (4.85%) C++
10 23 (4.85%) PL/SQL
11 21 (4.43%) R
12 19 (4.01%) C
13 10 (2.11%) MATLAB
14 8 (1.69%) Perl
15 7 (1.48%) VBScript
16 6 (1.27%) Bash Shell
16 6 (1.27%) Clojure
16 6 (1.27%) Ruby
17 4 (0.84%) Scala
Qualifications
1 36 (7.59%) Security Cleared
2 26 (5.49%) SC Cleared
3 25 (5.27%) Degree
4 3 (0.63%) ACCA
4 3 (0.63%) CIMA
4 3 (0.63%) Oracle Certification
5 2 (0.42%) BPSS Clearance
5 2 (0.42%) DV Cleared
5 2 (0.42%) Master's Degree
5 2 (0.42%) PhD
6 1 (0.21%) BC Cleared
6 1 (0.21%) Computer Science Degree
6 1 (0.21%) DBS Check
6 1 (0.21%) EnCE
6 1 (0.21%) GCFA
6 1 (0.21%) GCFE
6 1 (0.21%) GREM
6 1 (0.21%) PMI Certification
6 1 (0.21%) PMP
6 1 (0.21%) Postgraduate
Quality Assurance & Compliance
1 31 (6.54%) QA
2 14 (2.95%) Data Quality
3 11 (2.32%) SLA
4 10 (2.11%) ISO/IEC 27001
5 4 (0.84%) PMO
6 2 (0.42%) COREP
6 2 (0.42%) CRD IV
6 2 (0.42%) IFRS
6 2 (0.42%) MiFID
6 2 (0.42%) Solvency II
7 1 (0.21%) Disclosure Scotland
7 1 (0.21%) GDPR
7 1 (0.21%) JSP 440
7 1 (0.21%) SNOMED CT
System Software
1 12 (2.53%) Active Directory
2 3 (0.63%) Citrix Hypervisor
2 3 (0.63%) XenApp
2 3 (0.63%) XenDesktop
3 2 (0.42%) Docker
3 2 (0.42%) Microsoft App-V
3 2 (0.42%) Terminal Services
3 2 (0.42%) Virtual Desktop
4 1 (0.21%) Hyper-V
4 1 (0.21%) Virtual Machines
4 1 (0.21%) VMware Infrastructure
4 1 (0.21%) VMware Server
Systems Management
1 12 (2.53%) SCCM
2 11 (2.32%) WMI
3 6 (1.27%) Puppet
4 5 (1.05%) CSIRT
4 5 (1.05%) EnCase
4 5 (1.05%) FTK
5 4 (0.84%) QRadar
5 4 (0.84%) Salt
6 2 (0.42%) Kubernetes
7 1 (0.21%) Ansible
7 1 (0.21%) Cisco CUCM
7 1 (0.21%) Control-M
7 1 (0.21%) cPanel
7 1 (0.21%) Host Intrusion Detection System
7 1 (0.21%) Netcool
7 1 (0.21%) Network Intrusion Detection System
7 1 (0.21%) NSN NetAct
7 1 (0.21%) Opscode Chef
7 1 (0.21%) SCOM
7 1 (0.21%) WSUS
Vendors
1 114 (24.05%) Microsoft
2 49 (10.34%) Oracle
3 35 (7.38%) Tableau
4 18 (3.80%) SAP
5 11 (2.32%) Bloomberg
6 9 (1.90%) Citrix
7 8 (1.69%) Sun
7 8 (1.69%) Trayport
8 7 (1.48%) Automation Anywhere
8 7 (1.48%) Google
8 7 (1.48%) UiPath
9 6 (1.27%) Alteryx
9 6 (1.27%) Dell
9 6 (1.27%) Infor
9 6 (1.27%) MicroStrategy
9 6 (1.27%) Misys
10 5 (1.05%) HP
10 5 (1.05%) IBM
10 5 (1.05%) Micro Focus
10 5 (1.05%) OpenText