Period
to 17 August 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 17 August 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
17 Aug 2019
Same period 2018 Same period 2017
Rank 398 390 306
Rank change year-on-year -8 -84 +12
Contract jobs citing VBA 531 662 797
As % of all contract IT jobs advertised in the UK 0.58% 0.64% 0.83%
As % of the Programming Languages category 1.38% 1.45% 1.98%
Number of daily rates quoted 355 425 498
UK median daily rate £425 £425 £425
10th Percentile £291 £263 £268
90th Percentile £625 £638 £600
UK excluding London median daily rate £396 £350 £375
% change year-on-year +13.21% -6.67% +7.14%
Number of hourly rates quoted 23 17 21
UK median hourly rate £21.00 £18.09 £24.49
Median hourly rate % change year-on-year +16.12% -26.14% +20.59%
10th Percentile £16.50 £14.65 £17.50
90th Percentile £32.20 £37.10 £44.95
UK excluding London median hourly rate £19.31 £20.00 £31.33
% change year-on-year -3.45% -36.17% +45.73%

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 38,615 45,607 40,208
As % of all contract IT jobs advertised in the UK 42.38% 44.26% 42.00%
Number of daily rates quoted 26,749 32,001 27,638
UK median daily rate £475 £463 £450
Median daily rate % change year-on-year +2.70% +2.78% +5.88%
10th Percentile £322 £313 £300
90th Percentile £650 £638 £625
UK excluding London median daily rate £425 £413 £400
% change year-on-year +3.03% +3.13% +6.67%
Number of hourly rates quoted 698 743 781
UK median hourly rate £44.00 £41.50 £40.00
Median hourly rate % change year-on-year +6.02% +3.75% +6.67%
10th Percentile £20.50 £16.25 £16.00
90th Percentile £55.50 £52.50 £53.75
UK excluding London median hourly rate £44.00 £41.50 £40.50
% change year-on-year +6.02% +2.47% +8.00%

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 17 August 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 17 August 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 17 August 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 -13 500 £425 - 120
London -13 323 £464 -2.37% 50
UK excluding London -6 199 £396 +13.21% 77
South East +9 64 £405 +8.00% 17
North of England +40 45 £381 +8.16% 16
Midlands +36 38 £400 +14.29% 13
West Midlands +39 32 £394 +6.42% 9
North West +19 24 £363 +18.46% 11
South West -27 22 £350 -6.67% 8
Yorkshire +19 18 £405 +14.08% 4
Scotland +16 17 £450 +66.67% 2
East Midlands +12 7 £425 +23.19% 4
Wales +10 7 £425 +6.25% 5
East of England +3 6 £475 +61.02% 16
North East +24 4 £425 +47.83% 1

For the 6 months to 17 August 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 339 (63.84%) Microsoft Excel
2 335 (63.09%) SQL
3 195 (36.72%) Finance
4 155 (29.19%) SQL Server
5 153 (28.81%) C#
6 133 (25.05%) Microsoft
7 128 (24.11%) .NET
8 104 (19.59%) Business Intelligence
8 104 (19.59%) Agile Software Development
9 95 (17.89%) Python
10 93 (17.51%) Banking
11 92 (17.33%) MS Access
12 86 (16.20%) VB
13 79 (14.88%) Data Analysis
14 78 (14.69%) Oracle
15 70 (13.18%) T-SQL
16 69 (12.99%) Analytical Skills
17 63 (11.86%) Java
17 63 (11.86%) Power Platform
18 61 (11.49%) Power BI
18 61 (11.49%) JavaScript
18 61 (11.49%) Windows
18 61 (11.49%) Data Warehouse
19 60 (11.30%) VB.NET
20 57 (10.73%) SQL Server Integration Services
21 54 (10.17%) Analytics
21 54 (10.17%) Problem-Solving
22 53 (9.98%) Front Office
23 49 (9.23%) Security Cleared
24 48 (9.04%) Migration

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 33 (6.21%) SharePoint
2 26 (4.90%) Confluence
3 22 (4.14%) IIS
4 9 (1.69%) SAS
5 6 (1.13%) SharePoint 2010
5 6 (1.13%) WebSphere
6 5 (0.94%) Captiva
6 5 (0.94%) Documentum
7 4 (0.75%) Elasticsearch
7 4 (0.75%) JBoss
7 4 (0.75%) Jetty
7 4 (0.75%) Oracle Self-Service HR
7 4 (0.75%) Tomcat
7 4 (0.75%) WebLogic
8 3 (0.56%) Apache Spark
8 3 (0.56%) MQSeries
8 3 (0.56%) MS Exchange
9 2 (0.38%) Exchange Server 2003
10 1 (0.19%) BizTalk Server
10 1 (0.19%) Skype for Business
Applications
1 339 (63.84%) Microsoft Excel
2 46 (8.66%) Microsoft Office
3 22 (4.14%) Microsoft PowerPoint
4 18 (3.39%) Spreadsheet
5 8 (1.51%) MS Visio
6 5 (0.94%) Microsoft Project
6 5 (0.94%) SPSS
7 3 (0.56%) InfoPath
8 1 (0.19%) Stata
Business Applications
1 9 (1.69%) Dynamics CRM
2 5 (0.94%) Misys Opics
3 3 (0.56%) Unit4 Business World
4 2 (0.38%) Cognos Business Intelligence
4 2 (0.38%) Dynamics AX
4 2 (0.38%) HFM
4 2 (0.38%) Infor SunSystems
4 2 (0.38%) Oracle EBS R12
4 2 (0.38%) SAP ERP
4 2 (0.38%) SAP Oil and Gas
4 2 (0.38%) SAP R/3
4 2 (0.38%) Workfront
5 1 (0.19%) Cognos TM1
5 1 (0.19%) CSG Singleview
5 1 (0.19%) Line 500
5 1 (0.19%) Oracle EBS
5 1 (0.19%) Oracle Payables
5 1 (0.19%) Oracle Receivables
5 1 (0.19%) Oracle Subledger Accounting
5 1 (0.19%) Sparx Enterprise Architect
Cloud Services
1 63 (11.86%) Power Platform
2 31 (5.84%) Microsoft Azure
3 15 (2.82%) Office 365
4 13 (2.45%) SaaS
5 11 (2.07%) Amazon AWS
6 6 (1.13%) PowerApps
7 5 (0.94%) OpenShift
7 5 (0.94%) SuccessFactors
8 4 (0.75%) Azure Data Factory
9 3 (0.56%) Dynamics 365
10 2 (0.38%) IaaS
10 2 (0.38%) PaaS
11 1 (0.19%) Cloud Computing
11 1 (0.19%) OneDrive
Communications & Networking
1 11 (2.07%) ICMP
1 11 (2.07%) SNMP
1 11 (2.07%) Telnet
2 4 (0.75%) SSH
3 3 (0.56%) DNS
4 2 (0.38%) HTTP
4 2 (0.38%) Internet
5 1 (0.19%) 2G
5 1 (0.19%) 3G
5 1 (0.19%) Ethernet
5 1 (0.19%) GPRS
5 1 (0.19%) GSM
5 1 (0.19%) HSPA
5 1 (0.19%) HTTPS
5 1 (0.19%) IP Telephony
5 1 (0.19%) LTE
5 1 (0.19%) PuTTY
5 1 (0.19%) Radio Access Network
5 1 (0.19%) UMTS
5 1 (0.19%) VoIP
Database & Business Intelligence
1 155 (29.19%) SQL Server
2 92 (17.33%) MS Access
3 61 (11.49%) Data Warehouse
3 61 (11.49%) Power BI
4 57 (10.73%) SQL Server Integration Services
5 43 (8.10%) SQL Server Reporting Services
6 39 (7.34%) Relational Database
7 25 (4.71%) SQL Server 2014
7 25 (4.71%) SQL Server Analysis Services
8 21 (3.95%) MySQL
9 19 (3.58%) SQL Server 2012
10 18 (3.39%) Oracle Database
11 13 (2.45%) BusinessObjects
11 13 (2.45%) SQL Server 2008
12 12 (2.26%) Oracle Reports
13 9 (1.69%) Data Mining
14 8 (1.51%) Crystal Reports
14 8 (1.51%) Microsoft Analysis Services
14 8 (1.51%) SQL Server 2016
15 7 (1.32%) Big Data
Development Applications
1 39 (7.34%) JIRA
2 30 (5.65%) Git (software)
3 18 (3.39%) Oracle Forms
4 15 (2.82%) Jenkins
5 10 (1.88%) Selenium
5 10 (1.88%) Team Foundation Server
6 9 (1.69%) Cucumber
6 9 (1.69%) Subversion
7 8 (1.51%) Maven
8 6 (1.13%) Visual Studio
9 5 (0.94%) Atlassian Bamboo
10 4 (0.75%) Ant
10 4 (0.75%) ClearCase
10 4 (0.75%) Eclipse
10 4 (0.75%) IntelliJ
10 4 (0.75%) JMeter
10 4 (0.75%) JUnit
10 4 (0.75%) Mercurial
10 4 (0.75%) Poseidon for UML
10 4 (0.75%) TeamCity
General
1 195 (36.72%) Finance
2 93 (17.51%) Banking
3 53 (9.98%) Front Office
4 23 (4.33%) Investment Banking
5 20 (3.77%) Retail
6 15 (2.82%) Legal
7 12 (2.26%) Financial Institution
8 10 (1.88%) Law
8 10 (1.88%) Military
9 9 (1.69%) Manufacturing
10 8 (1.51%) Telecoms
11 7 (1.32%) Back Office
12 6 (1.13%) Retail Banking
13 5 (0.94%) Marketing
14 4 (0.75%) Advertising
15 3 (0.56%) Billing
15 3 (0.56%) Electronics
15 3 (0.56%) Games
15 3 (0.56%) Private Banking
16 2 (0.38%) Pharmaceutical
Job Titles
1 278 (52.35%) Developer
2 119 (22.41%) Analyst
3 80 (15.07%) VBA Developer
4 76 (14.31%) SQL Developer
5 64 (12.05%) C# Developer
6 54 (10.17%) .NET Developer
7 52 (9.79%) Data Analyst
8 41 (7.72%) C# .NET Developer
9 26 (4.90%) Excel Developer
10 25 (4.71%) Access Developer
11 24 (4.52%) Business Analyst
12 23 (4.33%) Excel VBA Developer
13 20 (3.77%) Python Developer
13 20 (3.77%) WinForms Developer
14 19 (3.58%) RAD Developer
14 19 (3.58%) SQL Analyst
15 16 (3.01%) Architect
15 16 (3.01%) Consultant
16 14 (2.64%) Robotic Process Automation Developer
17 13 (2.45%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 128 (24.11%) .NET
2 46 (8.66%) ASP.NET
3 36 (6.78%) HTML
4 35 (6.59%) WinForms
5 33 (6.21%) WPF
6 29 (5.46%) JSON
7 28 (5.27%) XML
8 26 (4.90%) .NET Framework
9 16 (3.01%) CSS
10 14 (2.64%) Web Services
11 13 (2.45%) HTML5
12 12 (2.26%) AngularJS
13 11 (2.07%) RESTful
13 11 (2.07%) WCF
14 10 (1.88%) JPA
14 10 (1.88%) Spring
15 7 (1.32%) ASP.NET MVC
15 7 (1.32%) jQuery
15 7 (1.32%) React
16 6 (1.13%) ASP.NET Web API
Miscellaneous
1 69 (12.99%) Analytical Skills
2 18 (3.39%) Self-Motivation
3 16 (3.01%) Derivative
4 15 (2.82%) Data Protection Act
4 15 (2.82%) Management Information System
5 13 (2.45%) Market Risk
6 10 (1.88%) User Experience
7 8 (1.51%) Fixed Income
7 8 (1.51%) Robotics
8 7 (1.32%) Data Structures
9 6 (1.13%) Clustering
9 6 (1.13%) Enterprise Software
9 6 (1.13%) Equities
9 6 (1.13%) Equity Derivative
9 6 (1.13%) Foreign Exchange (FX)
9 6 (1.13%) Greenfield Project
10 4 (0.75%) NHS
11 3 (0.56%) Credit Risk
11 3 (0.56%) Data Centre
11 3 (0.56%) FMCG
Operating Systems
1 61 (11.49%) Windows
2 25 (4.71%) Windows 10
3 18 (3.39%) Linux
4 15 (2.82%) Windows Server
5 14 (2.64%) Windows 7
6 9 (1.69%) Android
7 6 (1.13%) Unix
8 5 (0.94%) Apple iOS
8 5 (0.94%) Windows Mobile
9 4 (0.75%) CentOS
9 4 (0.75%) Debian
9 4 (0.75%) Mac OS X
9 4 (0.75%) Red Hat Enterprise Linux
9 4 (0.75%) Ubuntu
10 3 (0.56%) Windows Server 2008
10 3 (0.56%) Windows Server 2012
11 2 (0.38%) Windows Server 2003
12 1 (0.19%) OpenVMS
12 1 (0.19%) VMS
Processes & Methodologies
1 104 (19.59%) Agile Software Development
1 104 (19.59%) Business Intelligence
2 79 (14.88%) Data Analysis
3 54 (10.17%) Analytics
3 54 (10.17%) Problem-Solving
4 48 (9.04%) Migration
5 47 (8.85%) ETL
6 42 (7.91%) SDLC
7 35 (6.59%) Stakeholder Management
8 34 (6.40%) Data Modelling
9 32 (6.03%) Visualisation
10 30 (5.65%) Project Management
11 28 (5.27%) RAD
11 28 (5.27%) Test Automation
12 27 (5.08%) DevOps
13 26 (4.90%) ITIL
14 24 (4.52%) Business Analysis
14 24 (4.52%) Configuration Management
15 23 (4.33%) Asset Management
15 23 (4.33%) Data Management
Programming Languages
1 335 (63.09%) SQL
2 153 (28.81%) C#
3 95 (17.89%) Python
4 86 (16.20%) VB
5 70 (13.18%) T-SQL
6 63 (11.86%) Java
7 61 (11.49%) JavaScript
8 60 (11.30%) VB.NET
9 37 (6.97%) C++
10 35 (6.59%) PL/SQL
11 31 (5.84%) PowerShell
12 26 (4.90%) R
13 12 (2.26%) MATLAB
13 12 (2.26%) VB6
14 9 (1.69%) C
14 9 (1.69%) VBScript
15 8 (1.51%) Java 8
16 7 (1.32%) Ruby
17 6 (1.13%) Clojure
17 6 (1.13%) Perl
Qualifications
1 49 (9.23%) Security Cleared
2 38 (7.16%) SC Cleared
3 37 (6.97%) Degree
4 5 (0.94%) BPSS Clearance
5 3 (0.56%) ACCA
5 3 (0.56%) CIMA
5 3 (0.56%) Computer Science Degree
6 2 (0.38%) DBS Check
6 2 (0.38%) DV Cleared
6 2 (0.38%) Master's Degree
6 2 (0.38%) Oracle Certification
7 1 (0.19%) BC Cleared
7 1 (0.19%) CISA
7 1 (0.19%) MBA
7 1 (0.19%) PhD
7 1 (0.19%) PMI Certification
7 1 (0.19%) PMP
Quality Assurance & Compliance
1 46 (8.66%) QA
2 16 (3.01%) Data Quality
3 10 (1.88%) ISO/IEC 27001
4 8 (1.51%) SLA
5 5 (0.94%) MiFID
6 4 (0.75%) IFRS
7 3 (0.56%) PMO
8 2 (0.38%) Disclosure Scotland
8 2 (0.38%) GDPR
8 2 (0.38%) IFRS 9
9 1 (0.19%) CRD IV
9 1 (0.19%) ITGC
9 1 (0.19%) JSP 440
9 1 (0.19%) Sarbanes-Oxley
System Software
1 12 (2.26%) Active Directory
2 3 (0.56%) Microsoft App-V
3 1 (0.19%) Cronacle
3 1 (0.19%) Docker
3 1 (0.19%) Firmware
3 1 (0.19%) Terminal Services
3 1 (0.19%) Virtual Desktop
Systems Management
1 11 (2.07%) SCCM
1 11 (2.07%) WMI
2 6 (1.13%) Puppet
3 5 (0.94%) Kubernetes
4 4 (0.75%) Salt
5 3 (0.56%) Microsoft Clustering
6 1 (0.19%) Ansible
6 1 (0.19%) Graylog
6 1 (0.19%) Host Intrusion Detection System
6 1 (0.19%) Netcool
6 1 (0.19%) Network Intrusion Detection System
6 1 (0.19%) NSN NetAct
Vendors
1 133 (25.05%) Microsoft
2 78 (14.69%) Oracle
3 36 (6.78%) Tableau
4 20 (3.77%) Citrix
5 17 (3.20%) SAP
6 13 (2.45%) UiPath
7 9 (1.69%) Blue Prism
8 8 (1.51%) Automation Anywhere
8 8 (1.51%) HP
9 6 (1.13%) IBM
9 6 (1.13%) Sun
9 6 (1.13%) Sybase
10 5 (0.94%) Infor
10 5 (0.94%) Micro Focus
10 5 (0.94%) Misys
10 5 (0.94%) OpenText
10 5 (0.94%) ServiceNow
10 5 (0.94%) Telerik
10 5 (0.94%) Trayport
11 4 (0.75%) Alteryx