Period
to 27 May 2018

The following table provides summary statistics for contract job vacancies advertised in London 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 27 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)
England > London
6 months to
27 May 2018
Same period 2017 Same period 2016
Rank 263 233 208
Rank change year-on-year -30 -25 -47
Contract jobs citing VBA 478 437 531
As % of all contract IT jobs advertised in London 1.05% 1.10% 1.22%
As % of the Programming Languages category 2.16% 2.37% 2.85%
Number of daily rates quoted 356 283 385
London median daily rate £450 £450 £425
Median daily rate % change year-on-year - +5.88% -5.56%
10th Percentile £300 £290 £235
90th Percentile £598 £600 £638
England median daily rate £400 £415 £380
% change year-on-year -3.61% +9.21% -5.00%
Number of hourly rates quoted 3 3 3
London median hourly rate £18.09 £19.82 £19.00
Median hourly rate % change year-on-year -8.75% +4.32% +5.56%
10th Percentile £17.11 £19.82 £16.70
90th Percentile £19.84 £21.56 £23.10
England median hourly rate £20.00 £39.98 £21.00
% change year-on-year -49.97% +90.36% -

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 advertised in London with a requirement for coding skills.

All Programming Languages
London
Contract vacancies with a requirement for coding skills 22,167 18,440 18,644
As % of all contract IT jobs advertised in London 48.62% 46.39% 42.97%
Number of daily rates quoted 16,899 13,722 14,033
London median daily rate £500 £485 £450
Median daily rate % change year-on-year +3.09% +7.78% -
10th Percentile £356 £325 £306
90th Percentile £675 £650 £638
England median daily rate £475 £448 £425
% change year-on-year +6.15% +5.29% +6.25%
Number of hourly rates quoted 206 130 106
London median hourly rate £42.02 £42.50 £30.00
Median hourly rate % change year-on-year -1.14% +41.67% +4.35%
10th Percentile £17.85 £17.73 £14.31
90th Percentile £57.94 £54.54 £54.38
England median hourly rate £41.00 £41.50 £38.75
% change year-on-year -1.20% +7.10% +10.71%

VBA
Job Vacancy Trend in London

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

Job vacancy trend for VBA in London

VBA
Contractor Daily Rate Trend in London

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

Contractor daily rate trend for VBA in London

VBA
Contractor Daily Rate Histogram in London

The daily rate distribution of IT jobs citing VBA in London over the 6 months to 27 May 2018.

Contractor daily rate histogram for VBA in London

VBA
Contractor Hourly Rate Trend in London

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

Contractor hourly rate trend for VBA in London

VBA
Contract Job Locations in London

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing VBA within the London region over the 6 months to 27 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
Central London -7 114 £425 +13.33% 31
South London -26 25 £375 +42.86% 2
West London -27 18 £200 -29.20% 12
East London -7 15 £400 -3.03% 3
VBA
England

For the 6 months to 27 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 across the London region with a requirement for VBA.

1 367 (76.78%) Microsoft Excel
2 267 (55.86%) SQL
3 259 (54.18%) Finance
4 166 (34.73%) C#
5 149 (31.17%) SQL Server
6 120 (25.10%) Banking
7 111 (23.22%) .NET
8 99 (20.71%) Microsoft
9 85 (17.78%) Oracle
10 81 (16.95%) Front Office
11 77 (16.11%) Python
11 77 (16.11%) Business Intelligence
12 76 (15.90%) Problem-Solving
13 74 (15.48%) Analytics
14 73 (15.27%) Agile Software Development
15 72 (15.06%) Analytical Skills
16 61 (12.76%) Java
17 52 (10.88%) Derivative
17 52 (10.88%) Degree
18 50 (10.46%) Risk Management
19 45 (9.41%) VB
19 45 (9.41%) R
19 45 (9.41%) Tableau
20 43 (9.00%) Windows
21 42 (8.79%) T-SQL
21 42 (8.79%) SQL Server Reporting Services
22 41 (8.58%) Spreadsheet
23 39 (8.16%) Mathematics
23 39 (8.16%) MS Access
24 38 (7.95%) C++

VBA
Co-occurring IT Skills in London 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 30 (6.28%) SharePoint
2 22 (4.60%) SAS
3 9 (1.88%) IIS
4 6 (1.26%) Confluence
4 6 (1.26%) Tomcat
5 4 (0.84%) Apache Spark
5 4 (0.84%) JBoss
6 3 (0.63%) Elasticsearch
6 3 (0.63%) Jetty
6 3 (0.63%) Oracle Self-Service HR
6 3 (0.63%) WebLogic
7 2 (0.42%) Apache Airflow
7 2 (0.42%) SharePoint Server
8 1 (0.21%) OpenEdge
8 1 (0.21%) WebSphere
Applications
1 367 (76.78%) Microsoft Excel
2 41 (8.58%) Spreadsheet
3 37 (7.74%) Microsoft Office
4 22 (4.60%) Microsoft PowerPoint
5 14 (2.93%) MS Visio
6 10 (2.09%) Microsoft Project
7 4 (0.84%) InfoPath
Business Applications
1 9 (1.88%) Summit
2 7 (1.46%) SimCorp Dimension
3 4 (0.84%) Dynamics AX
3 4 (0.84%) Dynamics CRM
3 4 (0.84%) SAP R/3
4 3 (0.63%) Orchestrade
4 3 (0.63%) RMDS
4 3 (0.63%) SAP SD
5 2 (0.42%) Dynamics NAV
5 2 (0.42%) Oracle EBS
5 2 (0.42%) Oracle Procure-to-Pay
6 1 (0.21%) Cognos TM1
6 1 (0.21%) Global One
6 1 (0.21%) MoSes
6 1 (0.21%) PolarLake
6 1 (0.21%) SAP CO
6 1 (0.21%) SAP FI
6 1 (0.21%) SAP FI/CO
6 1 (0.21%) SAP HR
6 1 (0.21%) thinkFolio
Cloud Services
1 19 (3.97%) Microsoft Azure
2 13 (2.72%) Office 365
3 11 (2.30%) Amazon AWS
4 8 (1.67%) Google Analytics
5 6 (1.26%) Dynamics 365
6 3 (0.63%) GitHub
7 2 (0.42%) Adobe Analytics
7 2 (0.42%) Google Tag Manager
8 1 (0.21%) Amazon EMR
8 1 (0.21%) Amazon S3
Communications & Networking
1 9 (1.88%) SMS
2 6 (1.26%) SSH
3 4 (0.84%) Internet
4 3 (0.63%) BIG-IP
4 3 (0.63%) Firewall
4 3 (0.63%) LAN
4 3 (0.63%) TCP/IP
4 3 (0.63%) VPN
5 2 (0.42%) DNS
5 2 (0.42%) DSL
5 2 (0.42%) HTTP
5 2 (0.42%) NAS
5 2 (0.42%) Wi-Fi
6 1 (0.21%) MPLS
6 1 (0.21%) SAN
6 1 (0.21%) SSL
6 1 (0.21%) WAN
Database & Business Intelligence
1 149 (31.17%) SQL Server
2 42 (8.79%) SQL Server Reporting Services
3 39 (8.16%) MS Access
4 31 (6.49%) SQL Server Integration Services
5 29 (6.07%) Power BI
6 27 (5.65%) Relational Database
7 22 (4.60%) Oracle Database
7 22 (4.60%) SQL Server 2016
8 21 (4.39%) MongoDB
9 20 (4.18%) Data Warehouse
10 19 (3.97%) SQL Server 2014
11 16 (3.35%) SQL Server 2012
12 14 (2.93%) BusinessObjects
13 12 (2.51%) Oracle Database 11g
14 11 (2.30%) Base SAS
14 11 (2.30%) SQL Server Analysis Services
15 10 (2.09%) Crystal Reports
15 10 (2.09%) OLAP
15 10 (2.09%) QlikView
15 10 (2.09%) SQL Server 2008
Development Applications
1 28 (5.86%) JIRA
2 17 (3.56%) Visual Studio
3 15 (3.14%) Cucumber
3 15 (3.14%) Git (software)
4 13 (2.72%) Jenkins
4 13 (2.72%) Selenium
5 12 (2.51%) RStudio
6 10 (2.09%) Subversion
7 8 (1.67%) Maven
7 8 (1.67%) SpecFlow
8 5 (1.05%) Selendroid
9 4 (0.84%) Ant
9 4 (0.84%) Gradle
9 4 (0.84%) Team Foundation Server
10 3 (0.63%) ClearCase
10 3 (0.63%) Eclipse
10 3 (0.63%) IntelliJ
10 3 (0.63%) Mercurial
10 3 (0.63%) Poseidon for UML
10 3 (0.63%) SoapUI
General
1 259 (54.18%) Finance
2 120 (25.10%) Banking
3 81 (16.95%) Front Office
4 36 (7.53%) Investment Banking
5 18 (3.77%) Marketing
6 14 (2.93%) Financial Institution
6 14 (2.93%) Retail
7 13 (2.72%) Legal
8 11 (2.30%) Advertising
9 6 (1.26%) Law
10 5 (1.05%) French Language
11 4 (0.84%) Back Office
12 3 (0.63%) Manufacturing
12 3 (0.63%) Telecoms
13 2 (0.42%) Electronics
13 2 (0.42%) Multimedia
13 2 (0.42%) Retail Banking
14 1 (0.21%) Billing
14 1 (0.21%) German Language
14 1 (0.21%) Wholesale Banking
Job Titles
1 242 (50.63%) Developer
2 166 (34.73%) Analyst
3 92 (19.25%) VBA Developer
4 62 (12.97%) Excel Developer
4 62 (12.97%) Excel VBA Developer
5 61 (12.76%) C# Developer
6 50 (10.46%) SQL Developer
7 46 (9.62%) .NET Developer
8 43 (9.00%) Data Analyst
9 30 (6.28%) Business Analyst
10 29 (6.07%) C# .NET Developer
11 25 (5.23%) Risk Analyst
12 23 (4.81%) Quantitative Developer
13 20 (4.18%) Analyst Developer
13 20 (4.18%) Consultant
13 20 (4.18%) Senior Developer
14 19 (3.97%) SQL Analyst
15 17 (3.56%) Excel Analyst
15 17 (3.56%) RAD Developer
16 16 (3.35%) Access Developer
Libraries, Frameworks & Software Standards
1 111 (23.22%) .NET
2 23 (4.81%) Web Services
3 22 (4.60%) .NET Framework
4 21 (4.39%) HTML
5 18 (3.77%) WPF
6 16 (3.35%) JSON
7 15 (3.14%) WCF
7 15 (3.14%) XML
8 14 (2.93%) REST
9 11 (2.30%) CSS
10 9 (1.88%) WinForms
11 8 (1.67%) AngularJS
11 8 (1.67%) RabbitMQ
12 7 (1.46%) Spring
12 7 (1.46%) Task Parallel Library
13 6 (1.26%) ASP.NET
13 6 (1.26%) Gherkin
13 6 (1.26%) Hibernate
13 6 (1.26%) Node.js
13 6 (1.26%) React
Miscellaneous
1 72 (15.06%) Analytical Skills
2 52 (10.88%) Derivative
3 36 (7.53%) Fixed Income
4 29 (6.07%) Market Risk
5 26 (5.44%) Self-Motivation
6 22 (4.60%) Computer Science
7 21 (4.39%) Credit Risk
7 21 (4.39%) Management Information System
8 15 (3.14%) Data Structures
9 14 (2.93%) Equities
9 14 (2.93%) Foreign Exchange (FX)
10 13 (2.72%) Greenfield Project
11 11 (2.30%) Reinsurance
12 9 (1.88%) Equity Derivative
13 5 (1.05%) Robotics
14 4 (0.84%) Swaptions
14 4 (0.84%) User Experience
15 3 (0.63%) Hedge funds
15 3 (0.63%) Reference Data
15 3 (0.63%) Wiki
Operating Systems
1 43 (9.00%) Windows
2 14 (2.93%) Linux
3 12 (2.51%) Windows 10
4 10 (2.09%) Android
5 9 (1.88%) Unix
6 8 (1.67%) Windows 7
6 8 (1.67%) Windows Server
7 5 (1.05%) Apple iOS
7 5 (1.05%) Ubuntu
8 4 (0.84%) Red Hat Enterprise Linux
9 3 (0.63%) CentOS
9 3 (0.63%) Debian
9 3 (0.63%) Mac OS X
9 3 (0.63%) Windows Server 2012
Processes & Methodologies
1 77 (16.11%) Business Intelligence
2 76 (15.90%) Problem-Solving
3 74 (15.48%) Analytics
4 73 (15.27%) Agile Software Development
5 50 (10.46%) Risk Management
6 39 (8.16%) Mathematics
7 38 (7.95%) Business Analysis
8 36 (7.53%) Data Analysis
8 36 (7.53%) Validation
9 33 (6.90%) Migration
10 31 (6.49%) Waterfall
11 30 (6.28%) Data Analytics
12 29 (6.07%) Data Modelling
12 29 (6.07%) RAD
13 28 (5.86%) SDLC
13 28 (5.86%) Stakeholder Management
14 26 (5.44%) Project Management
15 25 (5.23%) OO
15 25 (5.23%) TDD
16 23 (4.81%) Time Management
Programming Languages
1 267 (55.86%) SQL
2 166 (34.73%) C#
3 77 (16.11%) Python
4 61 (12.76%) Java
5 45 (9.41%) R
5 45 (9.41%) VB
6 42 (8.79%) T-SQL
7 38 (7.95%) C++
8 37 (7.74%) VB.NET
9 28 (5.86%) PowerShell
10 22 (4.60%) JavaScript
11 14 (2.93%) PL/SQL
12 11 (2.30%) VBScript
13 9 (1.88%) MATLAB
13 9 (1.88%) Ruby
14 8 (1.67%) C
14 8 (1.67%) Perl
14 8 (1.67%) Scala
15 7 (1.46%) Shell Script
16 4 (0.84%) PHP
Qualifications
1 52 (10.88%) Degree
2 13 (2.72%) Security Cleared
3 7 (1.46%) Computer Science Degree
4 6 (1.26%) SC Cleared
5 4 (0.84%) PhD
6 3 (0.63%) MCSE
6 3 (0.63%) Microsoft Certification
7 2 (0.42%) CCNA
7 2 (0.42%) CCNP
7 2 (0.42%) Cisco Certification
7 2 (0.42%) DV Cleared
7 2 (0.42%) Numerate Degree
8 1 (0.21%) CFA
8 1 (0.21%) CTC Cleared
8 1 (0.21%) Master's Degree
8 1 (0.21%) MBA
8 1 (0.21%) MCP
8 1 (0.21%) MCSA
8 1 (0.21%) Postgraduate
Quality Assurance & Compliance
1 24 (5.02%) Data Quality
2 23 (4.81%) QA
3 15 (3.14%) PMO
4 10 (2.09%) Solvency II
5 8 (1.67%) IFRS
6 6 (1.26%) Basel II
7 5 (1.05%) IFRS 9
8 4 (0.84%) Basel III
8 4 (0.84%) GDPR
9 3 (0.63%) Disclosure Scotland
9 3 (0.63%) EMIR
9 3 (0.63%) FATCA
9 3 (0.63%) MiFID
9 3 (0.63%) Sarbanes-Oxley
10 1 (0.21%) CRD IV
10 1 (0.21%) SLA
System Software
1 12 (2.51%) Docker
2 6 (1.26%) Virtual Desktop
3 2 (0.42%) Virtual Machines
4 1 (0.21%) Active Directory
Systems Management
1 6 (1.26%) MOM
2 3 (0.63%) Ansible
2 3 (0.63%) Control-M
2 3 (0.63%) ITRS Geneos
2 3 (0.63%) Puppet
2 3 (0.63%) Salt
3 2 (0.42%) QRadar
4 1 (0.21%) CSIRT
Vendors
1 99 (20.71%) Microsoft
2 85 (17.78%) Oracle
3 45 (9.41%) Tableau
4 28 (5.86%) Bloomberg
5 25 (5.23%) Reuters
6 24 (5.02%) SAP
7 12 (2.51%) Cognos
7 12 (2.51%) Sybase
8 9 (1.88%) Calypso
9 8 (1.67%) Google
9 8 (1.67%) SimCorp
10 7 (1.46%) Citrix
11 5 (1.05%) Blue Prism
11 5 (1.05%) Wallstreet Suite
12 4 (0.84%) Capita
12 4 (0.84%) RedGate
12 4 (0.84%) Solace
13 3 (0.63%) Atlassian
13 3 (0.63%) F5
13 3 (0.63%) Murex