Period
to 20 May 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 20 May 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
20 May 2018
Same period 2017 Same period 2016
Rank 331 331 289
Rank change year-on-year 0 -42 -67
Contract jobs citing VBA 748 674 909
As % of all contract IT jobs advertised in the UK 0.74% 0.74% 0.86%
As % of the Programming Languages category 1.73% 1.80% 2.24%
Number of daily rates quoted 506 431 619
UK median daily rate £400 £415 £375
Median daily rate % change year-on-year -3.61% +10.67% -4.46%
10th Percentile £274 £266 £221
90th Percentile £578 £588 £613
UK excluding London median daily rate £350 £389 £338
% change year-on-year -10.03% +15.26% -3.57%
Number of hourly rates quoted 18 14 17
UK median hourly rate £20.00 £39.98 £19.61
Median hourly rate % change year-on-year -49.97% +103.85% -12.84%
10th Percentile £16.40 £17.45 £13.83
90th Percentile £42.13 £44.95 £27.00
UK excluding London median hourly rate £20.00 £42.48 £20.31
% change year-on-year -52.91% +109.18% -9.76%

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 43,330 37,518 40,502
As % of all contract IT jobs advertised in the UK 43.02% 41.32% 38.37%
Number of daily rates quoted 30,280 25,712 27,694
UK median daily rate £463 £425 £420
Median daily rate % change year-on-year +8.82% +1.19% +5.00%
10th Percentile £313 £300 £275
90th Percentile £638 £613 £600
UK excluding London median daily rate £405 £388 £375
% change year-on-year +4.52% +3.33% +7.14%
Number of hourly rates quoted 776 816 955
UK median hourly rate £40.00 £41.50 £38.50
Median hourly rate % change year-on-year -3.61% +7.79% +10.00%
10th Percentile £16.93 £16.50 £14.13
90th Percentile £52.50 £55.63 £52.25
UK excluding London median hourly rate £40.00 £41.00 £38.50
% change year-on-year -2.44% +6.49% +10.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 20 May 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 20 May 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 20 May 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 -10 709 £400 -5.88% 146
London -12 485 £450 - 71
UK excluding London -18 255 £350 -10.03% 80
South East -5 80 £400 +2.56% 16
Midlands -20 49 £325 -24.64% 18
North of England -31 38 £375 - 18
South West +15 33 £319 -12.07% 16
West Midlands -15 26 £350 -11.11% 12
Scotland -31 26 £350 -9.68% 4
East of England +6 24 £295 -34.44% 6
East Midlands -8 23 £300 -31.43% 6
North West -20 18 £369 -7.81% 6
Yorkshire -28 18 £400 +14.29% 7
Northern Ireland +14 7 £388 -6.06%
North East +8 3 - - 5
Wales -1 2 £300 -14.29% 2

For the 6 months to 20 May 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 553 (73.93%) Microsoft Excel
2 423 (56.55%) SQL
3 330 (44.12%) Finance
4 214 (28.61%) SQL Server
5 204 (27.27%) C#
6 186 (24.87%) Microsoft
7 153 (20.45%) Banking
8 150 (20.05%) .NET
9 132 (17.65%) Oracle
10 129 (17.25%) Analytical Skills
11 124 (16.58%) Business Intelligence
12 102 (13.64%) Problem-Solving
13 93 (12.43%) Analytics
14 89 (11.90%) Front Office
15 87 (11.63%) Python
15 87 (11.63%) Agile Software Development
16 84 (11.23%) Java
17 82 (10.96%) VB
18 80 (10.70%) Degree
19 73 (9.76%) Microsoft Office
20 72 (9.63%) MS Access
21 69 (9.22%) SQL Server Reporting Services
22 67 (8.96%) Spreadsheet
23 66 (8.82%) Tableau
24 64 (8.56%) T-SQL
25 63 (8.42%) Risk Management
25 63 (8.42%) Data Analysis
26 62 (8.29%) Derivative
27 58 (7.75%) SAP
28 57 (7.62%) Windows

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 52 (6.95%) SharePoint
2 41 (5.48%) SAS
3 11 (1.47%) IIS
4 10 (1.34%) Confluence
5 9 (1.20%) MS Exchange
6 6 (0.80%) Exchange Server 2010
6 6 (0.80%) Exchange Server 2013
6 6 (0.80%) Tomcat
6 6 (0.80%) WebLogic
7 4 (0.53%) Apache Spark
7 4 (0.53%) JBoss
8 3 (0.40%) Elasticsearch
8 3 (0.40%) Exchange Server 2003
8 3 (0.40%) Exchange Server 2007
8 3 (0.40%) Jetty
8 3 (0.40%) MQSeries
8 3 (0.40%) Mule
8 3 (0.40%) Oracle Self-Service HR
8 3 (0.40%) SharePoint 2013
8 3 (0.40%) SharePoint Server
Applications
1 553 (73.93%) Microsoft Excel
2 73 (9.76%) Microsoft Office
3 67 (8.96%) Spreadsheet
4 42 (5.61%) Microsoft PowerPoint
5 15 (2.01%) Microsoft Project
5 15 (2.01%) MS Visio
6 4 (0.53%) InfoPath
7 2 (0.27%) Acrobat
7 2 (0.27%) Photoshop
8 1 (0.13%) Adobe Illustrator
8 1 (0.13%) SPSS
Business Applications
1 9 (1.20%) Summit
2 7 (0.94%) SimCorp Dimension
3 5 (0.67%) Dynamics CRM
3 5 (0.67%) SAP R/3
4 4 (0.53%) Oracle Financials
4 4 (0.53%) Sage 200
4 4 (0.53%) SAP SD
5 3 (0.40%) Endur
5 3 (0.40%) Orchestrade
5 3 (0.40%) RMDS
6 2 (0.27%) Demantra
6 2 (0.27%) Dynamics AX
6 2 (0.27%) Dynamics NAV
6 2 (0.27%) Oracle EBS
6 2 (0.27%) Oracle Procure-to-Pay
6 2 (0.27%) Oracle Retail
6 2 (0.27%) Remedy ITSM
6 2 (0.27%) Retail-J
7 1 (0.13%) Oracle General Ledger
7 1 (0.13%) thinkFolio
Cloud Services
1 21 (2.81%) Microsoft Azure
2 18 (2.41%) Office 365
3 11 (1.47%) Amazon AWS
4 8 (1.07%) Google Analytics
5 5 (0.67%) Dynamics 365
6 4 (0.53%) Cloud Computing
7 3 (0.40%) GitHub
7 3 (0.40%) Slack
8 2 (0.27%) Adobe Analytics
8 2 (0.27%) Google Tag Manager
9 1 (0.13%) Amazon EMR
9 1 (0.13%) Amazon S3
9 1 (0.13%) G Suite
9 1 (0.13%) Google Cloud Platform
9 1 (0.13%) SaaS
Communications & Networking
1 10 (1.34%) SMS
2 9 (1.20%) Firewall
2 9 (1.20%) LAN
2 9 (1.20%) TCP/IP
3 7 (0.94%) WAN
4 6 (0.80%) IMAP
4 6 (0.80%) Internet
4 6 (0.80%) POP3
4 6 (0.80%) SMTP
4 6 (0.80%) SSH
4 6 (0.80%) VLAN
5 3 (0.40%) BIG-IP
5 3 (0.40%) Intranet
5 3 (0.40%) VPN
6 2 (0.27%) DNS
6 2 (0.27%) DSL
6 2 (0.27%) HTTP
6 2 (0.27%) NAS
6 2 (0.27%) Wi-Fi
7 1 (0.13%) MPLS
Database & Business Intelligence
1 214 (28.61%) SQL Server
2 72 (9.63%) MS Access
3 69 (9.22%) SQL Server Reporting Services
4 52 (6.95%) SQL Server Integration Services
5 46 (6.15%) Power BI
6 40 (5.35%) Data Warehouse
7 37 (4.95%) Relational Database
8 36 (4.81%) Oracle Database
9 33 (4.41%) BusinessObjects
10 31 (4.14%) SQL Server 2016
11 29 (3.88%) MongoDB
12 28 (3.74%) SQL Server 2012
13 26 (3.48%) Big Data
14 23 (3.07%) SQL Server 2014
14 23 (3.07%) SQL Server Analysis Services
15 21 (2.81%) Crystal Reports
15 21 (2.81%) SQL Server 2008
16 19 (2.54%) QlikView
17 15 (2.01%) Oracle Database 11g
18 14 (1.87%) OLAP
Development Applications
1 34 (4.55%) JIRA
2 27 (3.61%) Visual Studio
3 21 (2.81%) Cucumber
4 19 (2.54%) Jenkins
5 18 (2.41%) Git (software)
6 16 (2.14%) Selenium
7 13 (1.74%) Subversion
8 12 (1.60%) RStudio
9 10 (1.34%) Team Foundation Server
10 8 (1.07%) Maven
10 8 (1.07%) SpecFlow
10 8 (1.07%) SQL Server Management Studio (SSMS)
11 7 (0.94%) Toad
12 6 (0.80%) JUnit
13 5 (0.67%) Selendroid
14 4 (0.53%) Ant
14 4 (0.53%) ClearCase
14 4 (0.53%) Gradle
14 4 (0.53%) StarTeam
15 3 (0.40%) Jasmine
General
1 330 (44.12%) Finance
2 153 (20.45%) Banking
3 89 (11.90%) Front Office
4 41 (5.48%) Investment Banking
5 25 (3.34%) Retail
6 20 (2.67%) Marketing
7 19 (2.54%) Legal
8 16 (2.14%) Financial Institution
9 15 (2.01%) Manufacturing
10 14 (1.87%) Advertising
11 10 (1.34%) Back Office
11 10 (1.34%) Telecoms
12 6 (0.80%) French Language
13 5 (0.67%) Law
14 4 (0.53%) Retail Banking
15 3 (0.40%) Mandarin Language
16 2 (0.27%) Automotive
16 2 (0.27%) Billing
16 2 (0.27%) General Ledger
16 2 (0.27%) Multimedia
Job Titles
1 339 (45.32%) Developer
2 276 (36.90%) Analyst
3 133 (17.78%) VBA Developer
4 77 (10.29%) Data Analyst
5 71 (9.49%) Excel Developer
6 69 (9.22%) Excel VBA Developer
6 69 (9.22%) SQL Developer
7 64 (8.56%) C# Developer
8 50 (6.68%) .NET Developer
9 47 (6.28%) Business Analyst
10 31 (4.14%) Consultant
10 31 (4.14%) Excel Analyst
11 30 (4.01%) Risk Analyst
11 30 (4.01%) SQL Analyst
12 29 (3.88%) C# .NET Developer
13 27 (3.61%) Analyst Developer
14 23 (3.07%) Quantitative Developer
15 22 (2.94%) Access Developer
15 22 (2.94%) RAD Developer
16 21 (2.81%) Applications Support
Libraries, Frameworks & Software Standards
1 150 (20.05%) .NET
2 44 (5.88%) HTML
3 29 (3.88%) XML
4 27 (3.61%) .NET Framework
4 27 (3.61%) Web Services
5 22 (2.94%) CSS
5 22 (2.94%) REST
6 19 (2.54%) JSON
6 19 (2.54%) WPF
7 18 (2.41%) WCF
8 13 (1.74%) AngularJS
9 10 (1.34%) WinForms
10 9 (1.20%) ASP.NET
10 9 (1.20%) Hibernate
10 9 (1.20%) Node.js
11 8 (1.07%) RabbitMQ
12 7 (0.94%) Gherkin
12 7 (0.94%) Spring
12 7 (0.94%) Task Parallel Library
13 6 (0.80%) J2EE
Miscellaneous
1 129 (17.25%) Analytical Skills
2 62 (8.29%) Derivative
3 40 (5.35%) Fixed Income
4 38 (5.08%) Self-Motivation
5 37 (4.95%) Management Information System
6 31 (4.14%) Computer Science
7 30 (4.01%) Market Risk
8 26 (3.48%) Credit Risk
9 17 (2.27%) Data Structures
10 16 (2.14%) Foreign Exchange (FX)
11 15 (2.01%) Equities
12 13 (1.74%) Greenfield Project
13 11 (1.47%) Reinsurance
14 10 (1.34%) Equity Derivative
15 9 (1.20%) Robotics
16 8 (1.07%) Clustering
17 6 (0.80%) User Experience
18 5 (0.67%) Enterprise Software
18 5 (0.67%) LIMS
19 4 (0.53%) Swaptions
Operating Systems
1 57 (7.62%) Windows
2 23 (3.07%) Unix
3 21 (2.81%) Linux
4 13 (1.74%) Android
4 13 (1.74%) Windows 10
5 11 (1.47%) Windows Server
6 9 (1.20%) Windows 7
6 9 (1.20%) Windows Server 2012
7 8 (1.07%) Apple iOS
8 7 (0.94%) Red Hat Enterprise Linux
9 6 (0.80%) Windows Server 2008
10 5 (0.67%) Ubuntu
11 3 (0.40%) CentOS
11 3 (0.40%) Debian
11 3 (0.40%) Mac OS X
12 1 (0.13%) Windows Embedded Compact
12 1 (0.13%) zOS
Processes & Methodologies
1 124 (16.58%) Business Intelligence
2 102 (13.64%) Problem-Solving
3 93 (12.43%) Analytics
4 87 (11.63%) Agile Software Development
5 63 (8.42%) Data Analysis
5 63 (8.42%) Risk Management
6 51 (6.82%) Stakeholder Management
7 50 (6.68%) Business Analysis
8 47 (6.28%) Mathematics
9 46 (6.15%) Migration
10 45 (6.02%) Validation
11 44 (5.88%) Data Modelling
12 38 (5.08%) Project Management
13 35 (4.68%) Visualisation
13 35 (4.68%) Waterfall
14 34 (4.55%) RAD
14 34 (4.55%) SDLC
15 33 (4.41%) Data Management
15 33 (4.41%) Time Management
16 30 (4.01%) Test Automation
Programming Languages
1 423 (56.55%) SQL
2 204 (27.27%) C#
3 87 (11.63%) Python
4 84 (11.23%) Java
5 82 (10.96%) VB
6 64 (8.56%) T-SQL
7 54 (7.22%) R
8 47 (6.28%) JavaScript
8 47 (6.28%) VB.NET
9 44 (5.88%) C++
10 37 (4.95%) PowerShell
11 25 (3.34%) PL/SQL
12 14 (1.87%) VBScript
13 13 (1.74%) C
13 13 (1.74%) VB6
14 11 (1.47%) Perl
15 10 (1.34%) MATLAB
15 10 (1.34%) Shell Script
16 9 (1.20%) Ruby
16 9 (1.20%) Scala
Qualifications
1 80 (10.70%) Degree
2 28 (3.74%) Security Cleared
3 21 (2.81%) SC Cleared
4 9 (1.20%) Computer Science Degree
4 9 (1.20%) Microsoft Certification
5 6 (0.80%) MCP
6 5 (0.67%) DBS Check
6 5 (0.67%) Numerate Degree
7 4 (0.53%) PhD
8 3 (0.40%) MCSE
9 2 (0.27%) CCNA
9 2 (0.27%) CCNP
9 2 (0.27%) Cisco Certification
9 2 (0.27%) DV Cleared
9 2 (0.27%) Postgraduate
10 1 (0.13%) A+ Certification
10 1 (0.13%) ACCA
10 1 (0.13%) CTC Cleared
10 1 (0.13%) Master's Degree
10 1 (0.13%) MCSA
Quality Assurance & Compliance
1 38 (5.08%) Data Quality
2 28 (3.74%) QA
3 19 (2.54%) PMO
4 11 (1.47%) Solvency II
5 9 (1.20%) Sarbanes-Oxley
6 8 (1.07%) IFRS
6 8 (1.07%) SLA
7 6 (0.80%) Basel II
7 6 (0.80%) GDPR
8 5 (0.67%) IFRS 9
9 4 (0.53%) Basel III
10 3 (0.40%) Disclosure Scotland
10 3 (0.40%) EMIR
10 3 (0.40%) FATCA
10 3 (0.40%) MiFID
11 2 (0.27%) ISO/IEC 20000
12 1 (0.13%) CRD IV
12 1 (0.13%) ISO 9001
System Software
1 13 (1.74%) Active Directory
2 12 (1.60%) Docker
3 6 (0.80%) Virtual Desktop
4 2 (0.27%) Virtual Machines
5 1 (0.13%) RACF
Systems Management
1 6 (0.80%) Ansible
1 6 (0.80%) MOM
1 6 (0.80%) Puppet
2 5 (0.67%) Symantec Enterprise Vault
3 3 (0.40%) Control-M
3 3 (0.40%) HP ALM
3 3 (0.40%) HP Quality Center
3 3 (0.40%) ITRS Geneos
3 3 (0.40%) Microsoft Clustering
3 3 (0.40%) Opscode Chef
3 3 (0.40%) Salt
4 2 (0.27%) QRadar
5 1 (0.13%) CSIRT
5 1 (0.13%) Single Sign-On
Vendors
1 186 (24.87%) Microsoft
2 132 (17.65%) Oracle
3 66 (8.82%) Tableau
4 58 (7.75%) SAP
5 28 (3.74%) Bloomberg
6 25 (3.34%) Reuters
7 18 (2.41%) Cognos
8 12 (1.60%) Sybase
9 11 (1.47%) Blue Prism
10 9 (1.20%) Calypso
10 9 (1.20%) Google
11 8 (1.07%) SimCorp
12 7 (0.94%) Citrix
13 6 (0.80%) Automation Anywhere
13 6 (0.80%) HP
13 6 (0.80%) Red Hat
14 5 (0.67%) Adobe
14 5 (0.67%) JD Edwards
14 5 (0.67%) OpenLink
14 5 (0.67%) Symantec