Period
to 19 August 2018

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 19 August 2018 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
19 Aug 2018
Same period 2017 Same period 2016
Rank 383 304 320
Rank change year-on-year -79 +16 -92
Contract jobs citing VBA 660 801 870
As % of all contract IT jobs advertised in the UK 0.65% 0.83% 0.80%
As % of the Programming Languages category 1.46% 1.98% 2.04%
Number of daily rates quoted 423 502 622
UK median daily rate £425 £425 £375
Median daily rate % change year-on-year - +13.33% -5.06%
10th Percentile £263 £268 £225
90th Percentile £638 £600 £575
UK excluding London median daily rate £350 £375 £345
% change year-on-year -6.67% +8.70% +6.15%
Number of hourly rates quoted 17 21 23
UK median hourly rate £18.09 £24.49 £19.61
Median hourly rate % change year-on-year -26.14% +24.86% -12.84%
10th Percentile £14.65 £17.50 £11.42
90th Percentile £37.10 £44.95 £27.00
UK excluding London median hourly rate £20.00 £31.33 £21.25
% change year-on-year -36.17% +47.45% -5.56%

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 45,280 40,533 42,557
As % of all contract IT jobs advertised in the UK 44.30% 42.02% 39.22%
Number of daily rates quoted 31,757 27,866 29,249
UK median daily rate £463 £450 £425
Median daily rate % change year-on-year +2.78% +5.88% +6.25%
10th Percentile £313 £300 £280
90th Percentile £638 £625 £588
UK excluding London median daily rate £413 £400 £375
% change year-on-year +3.13% +6.67% +7.14%
Number of hourly rates quoted 737 779 909
UK median hourly rate £41.50 £40.00 £37.50
Median hourly rate % change year-on-year +3.75% +6.67% +7.14%
10th Percentile £16.25 £16.00 £13.46
90th Percentile £52.50 £53.75 £51.00
UK excluding London median hourly rate £41.50 £40.50 £37.50
% change year-on-year +2.47% +8.00% +4.17%

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 19 August 2018.

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 19 August 2018.

Contractor 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 19 August 2018. 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 -75 603 £425 - 160
London -63 404 £475 +5.56% 57
UK excluding London -56 245 £350 -6.67% 118
South East -6 78 £375 +29.31% 31
Scotland -36 36 £270 -30.32% 5
North of England -46 35 £353 -6.00% 25
Midlands -25 32 £351 -17.35% 28
South West -37 29 £375 - 11
East of England +2 23 £295 -27.16% 8
East Midlands 0 20 £345 -21.14% 9
North West -18 17 £306 -18.40% 14
Yorkshire -18 15 £355 -6.58% 8
West Midlands -38 12 £390 +4.00% 19
Northern Ireland +32 8 £388 -6.06% 1
Wales -12 5 £400 +14.29% 8
North East -12 3 £288 -23.33% 3

For the 6 months to 19 August 2018, 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 475 (71.97%) Microsoft Excel
2 395 (59.85%) SQL
3 292 (44.24%) Finance
4 229 (34.70%) SQL Server
5 180 (27.27%) C#
6 175 (26.52%) Microsoft
7 134 (20.30%) .NET
8 111 (16.82%) Python
9 107 (16.21%) Business Intelligence
10 105 (15.91%) Analytics
11 99 (15.00%) Banking
12 95 (14.39%) Oracle
13 94 (14.24%) Agile Software Development
14 90 (13.64%) Front Office
15 86 (13.03%) Analytical Skills
16 85 (12.88%) T-SQL
16 85 (12.88%) MS Access
17 79 (11.97%) Java
18 78 (11.82%) Problem-Solving
19 70 (10.61%) SQL Server Reporting Services
19 70 (10.61%) SQL Server Integration Services
20 65 (9.85%) VB
21 63 (9.55%) Data Analysis
22 59 (8.94%) Tableau
23 56 (8.48%) Derivative
23 56 (8.48%) Degree
23 56 (8.48%) Microsoft Office
24 53 (8.03%) Power BI
25 52 (7.88%) R
26 51 (7.73%) Spreadsheet

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 40 (6.06%) SharePoint
2 18 (2.73%) SAS
3 12 (1.82%) IIS
4 10 (1.52%) Confluence
5 7 (1.06%) Tomcat
6 5 (0.76%) Apache Spark
6 5 (0.76%) SharePoint 2013
7 4 (0.61%) Apache
7 4 (0.61%) JBoss
8 3 (0.45%) Elasticsearch
8 3 (0.45%) Jetty
8 3 (0.45%) Oracle Self-Service HR
8 3 (0.45%) WebLogic
8 3 (0.45%) WordPress
9 2 (0.30%) MQSeries
9 2 (0.30%) SharePoint Server
10 1 (0.15%) ArcGIS
10 1 (0.15%) Documentum
10 1 (0.15%) MS Exchange
10 1 (0.15%) OpenEdge
Applications
1 475 (71.97%) Microsoft Excel
2 56 (8.48%) Microsoft Office
3 51 (7.73%) Spreadsheet
4 22 (3.33%) Microsoft PowerPoint
5 7 (1.06%) MS Visio
6 3 (0.45%) Microsoft Project
6 3 (0.45%) SPSS
7 2 (0.30%) Photoshop
8 1 (0.15%) Adobe Illustrator
8 1 (0.15%) Stata
Business Applications
1 8 (1.21%) Dynamics AX
2 7 (1.06%) Dynamics CRM
3 5 (0.76%) Sage 200
4 4 (0.61%) Oracle EBS
5 3 (0.45%) Bloomberg AIM
5 3 (0.45%) CSG Singleview
5 3 (0.45%) HFM
5 3 (0.45%) Oracle EBS R12
5 3 (0.45%) Oracle Payables
5 3 (0.45%) Oracle Receivables
5 3 (0.45%) SAP R/3
5 3 (0.45%) SimCorp Dimension
6 2 (0.30%) Line 500
6 2 (0.30%) Magento
6 2 (0.30%) Oracle ASCP
6 2 (0.30%) Oracle Procure-to-Pay
6 2 (0.30%) Remedy ITSM
6 2 (0.30%) Retail-J
6 2 (0.30%) SAP Oil and Gas
6 2 (0.30%) thinkFolio
Cloud Services
1 26 (3.94%) Microsoft Azure
2 20 (3.03%) Office 365
3 15 (2.27%) Amazon AWS
4 9 (1.36%) GitHub
5 7 (1.06%) Cloud Computing
5 7 (1.06%) Google Analytics
6 6 (0.91%) Dynamics 365
7 2 (0.30%) Amazon EMR
7 2 (0.30%) Amazon S3
7 2 (0.30%) Google Tag Manager
7 2 (0.30%) Slack
8 1 (0.15%) Google Cloud Platform
8 1 (0.15%) IaaS
8 1 (0.15%) SaaS
Communications & Networking
1 11 (1.67%) SMS
2 8 (1.21%) Internet
2 8 (1.21%) TCP/IP
3 5 (0.76%) Wireless
4 4 (0.61%) Firewall
4 4 (0.61%) Intranet
4 4 (0.61%) LAN
4 4 (0.61%) SSH
5 3 (0.45%) BIG-IP
5 3 (0.45%) VPN
6 2 (0.30%) DNS
6 2 (0.30%) DSL
6 2 (0.30%) NAS
6 2 (0.30%) WAN
6 2 (0.30%) Wi-Fi
7 1 (0.15%) Broadband
7 1 (0.15%) HTTP
7 1 (0.15%) POP3
7 1 (0.15%) SMTP
7 1 (0.15%) SSL
Database & Business Intelligence
1 229 (34.70%) SQL Server
2 85 (12.88%) MS Access
3 70 (10.61%) SQL Server Integration Services
3 70 (10.61%) SQL Server Reporting Services
4 53 (8.03%) Power BI
5 51 (7.73%) Data Warehouse
6 45 (6.82%) Relational Database
7 35 (5.30%) SQL Server 2016
8 31 (4.70%) MongoDB
9 29 (4.39%) SQL Server 2012
10 24 (3.64%) SQL Server 2014
10 24 (3.64%) SQL Server Analysis Services
11 23 (3.48%) Crystal Reports
11 23 (3.48%) Oracle Database
12 19 (2.88%) MySQL
13 17 (2.58%) Big Data
13 17 (2.58%) BusinessObjects
14 16 (2.42%) RDBMS
15 12 (1.82%) QlikView
16 11 (1.67%) OLAP
Development Applications
1 25 (3.79%) JIRA
2 23 (3.48%) Visual Studio
3 18 (2.73%) Cucumber
3 18 (2.73%) SQL Server Management Studio (SSMS)
3 18 (2.73%) Team Foundation Server
4 15 (2.27%) Jenkins
5 14 (2.12%) Selenium
6 13 (1.97%) Git (software)
6 13 (1.97%) RStudio
7 12 (1.82%) Subversion
8 11 (1.67%) SpecFlow
9 10 (1.52%) Maven
10 9 (1.36%) Toad
11 5 (0.76%) Eclipse
11 5 (0.76%) JUnit
11 5 (0.76%) SoapUI
12 4 (0.61%) Selendroid
12 4 (0.61%) StarTeam
12 4 (0.61%) Visual Studio Team System
13 3 (0.45%) Poseidon for UML
General
1 292 (44.24%) Finance
2 99 (15.00%) Banking
3 90 (13.64%) Front Office
4 21 (3.18%) Investment Banking
5 19 (2.88%) Retail
6 17 (2.58%) Financial Institution
7 16 (2.42%) Marketing
8 15 (2.27%) Telecoms
9 14 (2.12%) Advertising
9 14 (2.12%) Manufacturing
10 10 (1.52%) Legal
11 8 (1.21%) Back Office
11 8 (1.21%) Mandarin Language
12 6 (0.91%) Law
13 4 (0.61%) Billing
13 4 (0.61%) French Language
14 2 (0.30%) Corporate Banking
14 2 (0.30%) Electronics
14 2 (0.30%) Multimedia
14 2 (0.30%) Publishing
Job Titles
1 320 (48.48%) Developer
2 199 (30.15%) Analyst
3 139 (21.06%) VBA Developer
4 72 (10.91%) SQL Developer
5 64 (9.70%) Excel Developer
6 61 (9.24%) Excel VBA Developer
7 59 (8.94%) Data Analyst
8 51 (7.73%) C# Developer
9 44 (6.67%) .NET Developer
10 29 (4.39%) Access Developer
11 26 (3.94%) C# .NET Developer
11 26 (3.94%) Python Developer
12 25 (3.79%) Access VBA Developer
12 25 (3.79%) Senior Developer
13 24 (3.64%) Consultant
14 22 (3.33%) Excel Analyst
14 22 (3.33%) Front Office Developer
14 22 (3.33%) SQL Analyst
15 21 (3.18%) Business Intelligence Developer
16 20 (3.03%) Financial Analyst
Libraries, Frameworks & Software Standards
1 134 (20.30%) .NET
2 35 (5.30%) XML
3 33 (5.00%) HTML
4 21 (3.18%) JSON
4 21 (3.18%) Web Services
5 20 (3.03%) REST
6 19 (2.88%) WPF
7 17 (2.58%) CSS
8 16 (2.42%) .NET Framework
9 11 (1.67%) WCF
10 9 (1.36%) Gherkin
11 7 (1.06%) Classic ASP
11 7 (1.06%) Hibernate
11 7 (1.06%) jQuery
11 7 (1.06%) MDX
11 7 (1.06%) Node.js
11 7 (1.06%) Pandas
11 7 (1.06%) RabbitMQ
11 7 (1.06%) Spring
12 6 (0.91%) HTML5
Miscellaneous
1 86 (13.03%) Analytical Skills
2 56 (8.48%) Derivative
3 35 (5.30%) Fixed Income
3 35 (5.30%) Self-Motivation
4 22 (3.33%) Computer Science
4 22 (3.33%) Market Risk
5 16 (2.42%) Equities
5 16 (2.42%) Greenfield Project
5 16 (2.42%) Management Information System
6 12 (1.82%) Data Structures
7 11 (1.67%) Robotics
8 10 (1.52%) Foreign Exchange (FX)
8 10 (1.52%) Reference Data
9 9 (1.36%) Credit Risk
9 9 (1.36%) Fintech
10 8 (1.21%) Equity Derivative
11 6 (0.91%) FMCG
11 6 (0.91%) Reinsurance
12 5 (0.76%) Taxonomies
12 5 (0.76%) User Experience
Operating Systems
1 45 (6.82%) Windows
2 17 (2.58%) Windows 10
3 14 (2.12%) Android
4 13 (1.97%) Windows Server
5 10 (1.52%) Linux
6 8 (1.21%) Apple iOS
6 8 (1.21%) Unix
7 6 (0.91%) Red Hat Enterprise Linux
7 6 (0.91%) Windows 7
8 5 (0.76%) Windows Server 2012
9 4 (0.61%) Ubuntu
10 3 (0.45%) CentOS
10 3 (0.45%) Debian
10 3 (0.45%) Mac OS X
10 3 (0.45%) Windows Server 2008
11 1 (0.15%) Oracle Linux
11 1 (0.15%) Windows Embedded Compact
Processes & Methodologies
1 107 (16.21%) Business Intelligence
2 105 (15.91%) Analytics
3 94 (14.24%) Agile Software Development
4 78 (11.82%) Problem-Solving
5 63 (9.55%) Data Analysis
6 46 (6.97%) Data Modelling
7 41 (6.21%) ETL
7 41 (6.21%) Test Automation
8 39 (5.91%) Stakeholder Management
9 38 (5.76%) Migration
10 37 (5.61%) Data Analytics
11 36 (5.45%) Validation
12 35 (5.30%) Mathematics
13 34 (5.15%) Asset Management
13 34 (5.15%) OO
13 34 (5.15%) TDD
14 32 (4.85%) SDLC
15 30 (4.55%) Business Analysis
15 30 (4.55%) Project Management
16 29 (4.39%) Scrum
Programming Languages
1 395 (59.85%) SQL
2 180 (27.27%) C#
3 111 (16.82%) Python
4 85 (12.88%) T-SQL
5 79 (11.97%) Java
6 65 (9.85%) VB
7 52 (7.88%) R
8 44 (6.67%) VB.NET
9 37 (5.61%) JavaScript
10 32 (4.85%) PL/SQL
11 28 (4.24%) PowerShell
12 25 (3.79%) C++
13 13 (1.97%) C
13 13 (1.97%) MATLAB
14 10 (1.52%) Ruby
15 9 (1.36%) VBScript
16 8 (1.21%) PHP
16 8 (1.21%) Scala
16 8 (1.21%) VB6
17 7 (1.06%) Perl
Qualifications
1 56 (8.48%) Degree
2 14 (2.12%) Security Cleared
3 12 (1.82%) SC Cleared
4 5 (0.76%) Microsoft Certification
5 4 (0.61%) Computer Science Degree
5 4 (0.61%) MCDST
5 4 (0.61%) MCSE
5 4 (0.61%) Numerate Degree
6 3 (0.45%) ACCA
6 3 (0.45%) CIMA
6 3 (0.45%) DBS Check
7 2 (0.30%) CCNA
7 2 (0.30%) CCNP
7 2 (0.30%) Cisco Certification
7 2 (0.30%) DV Cleared
8 1 (0.15%) ISTQB
8 1 (0.15%) MBA
8 1 (0.15%) MCP
8 1 (0.15%) PhD
8 1 (0.15%) Postgraduate
Quality Assurance & Compliance
1 32 (4.85%) Data Quality
2 26 (3.94%) QA
3 10 (1.52%) PMO
4 8 (1.21%) GDPR
5 7 (1.06%) SLA
6 6 (0.91%) Solvency II
7 4 (0.61%) IFRS
8 3 (0.45%) MiFID
9 2 (0.30%) Basel II
9 2 (0.30%) ISO/IEC 20000
10 1 (0.15%) ISO 9001
System Software
1 11 (1.67%) Active Directory
2 10 (1.52%) Docker
3 6 (0.91%) Microsoft App-V
4 2 (0.30%) DFS Replication
4 2 (0.30%) HDFS
4 2 (0.30%) Virtual Desktop
4 2 (0.30%) VMware ESXi
4 2 (0.30%) VMware Infrastructure
4 2 (0.30%) XenApp
4 2 (0.30%) XenDesktop
5 1 (0.15%) Virtual Machines
Systems Management
1 8 (1.21%) SCCM
2 6 (0.91%) MOM
3 5 (0.76%) Systems Management Server (SMS)
4 4 (0.61%) Ansible
4 4 (0.61%) Puppet
5 3 (0.45%) Control-M
5 3 (0.45%) ITRS Geneos
5 3 (0.45%) Salt
6 2 (0.30%) McAfee ePO
6 2 (0.30%) QRadar
6 2 (0.30%) SafeCom
6 2 (0.30%) SCOM
6 2 (0.30%) SCOrch
6 2 (0.30%) XenMobile
7 1 (0.15%) CSIRT
7 1 (0.15%) HP ALM
7 1 (0.15%) HP Quality Center
7 1 (0.15%) Opscode Chef
7 1 (0.15%) Symantec Enterprise Vault
Vendors
1 175 (26.52%) Microsoft
2 95 (14.39%) Oracle
3 59 (8.94%) Tableau
4 41 (6.21%) SAP
5 29 (4.39%) Bloomberg
6 21 (3.18%) Reuters
7 11 (1.67%) Blue Prism
7 11 (1.67%) Citrix
7 11 (1.67%) Cognos
7 11 (1.67%) UiPath
8 10 (1.52%) Teradata
9 9 (1.36%) Automation Anywhere
10 8 (1.21%) Google
10 8 (1.21%) Sage
11 7 (1.06%) Calypso
11 7 (1.06%) Capita
12 6 (0.91%) Adobe
12 6 (0.91%) Ivanti
12 6 (0.91%) RedGate
12 6 (0.91%) Salesforce.com