Period
to 17 November 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 17 November 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
17 Nov 2018
Same period 2017 Same period 2016
Rank 299 216 271
Rank change year-on-year -83 +55 -100
Contract jobs citing VBA 384 598 428
As % of all contract IT jobs advertised in London 0.84% 1.28% 0.94%
As % of the Programming Languages category 1.66% 2.63% 2.11%
Number of daily rates quoted 269 443 333
London median daily rate £450 £500 £400
Median daily rate % change year-on-year -10.00% +25.00% -11.11%
10th Percentile £313 £300 £213
90th Percentile £713 £688 £575
England median daily rate £420 £450 £380
% change year-on-year -6.67% +18.42% -5.00%
Number of hourly rates quoted 4 1 4
London median hourly rate £18.00 £24.49 £13.76
Median hourly rate % change year-on-year -26.49% +77.94% -31.20%
England median hourly rate £18.00 £24.49 £16.66
% change year-on-year -26.49% +47.01% -24.30%

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 23,139 22,730 20,266
As % of all contract IT jobs advertised in London 50.36% 48.53% 44.74%
Number of daily rates quoted 17,638 17,221 15,150
London median daily rate £525 £500 £465
Median daily rate % change year-on-year +5.00% +7.53% +3.33%
10th Percentile £363 £350 £313
90th Percentile £675 £668 £633
England median daily rate £475 £455 £425
% change year-on-year +4.40% +7.06% +3.66%
Number of hourly rates quoted 115 154 115
London median hourly rate £37.09 £35.91 £35.27
Median hourly rate % change year-on-year +3.30% +1.81% +41.06%
10th Percentile £18.20 £18.02 £16.32
90th Percentile £61.27 £52.35 £62.00
England median hourly rate £42.00 £40.00 £37.50
% change year-on-year +5.00% +6.67% +1.35%

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 17 November 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
Contractor Hourly Rate Histogram in London

The hourly rate distribution of IT jobs citing VBA in London over the 6 months to 17 November 2018.

Contractor hourly rate histogram 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 17 November 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 -47 117 £475 -10.59% 23
West London -3 10 £375 +15.38% 12
East London -25 7 £450 +5.88% 6
South London -25 4 £375 -46.43% 2
VBA
England

For the 6 months to 17 November 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 298 (77.60%) Microsoft Excel
2 212 (55.21%) SQL
3 173 (45.05%) Finance
4 128 (33.33%) SQL Server
5 119 (30.99%) C#
6 97 (25.26%) .NET
7 83 (21.61%) Python
7 83 (21.61%) Banking
8 81 (21.09%) Analytics
9 80 (20.83%) Front Office
10 72 (18.75%) Microsoft
11 61 (15.89%) Agile Software Development
12 55 (14.32%) T-SQL
13 54 (14.06%) Degree
14 50 (13.02%) Problem-Solving
15 46 (11.98%) Data Warehouse
15 46 (11.98%) Business Intelligence
15 46 (11.98%) Derivative
16 44 (11.46%) VB
17 43 (11.20%) Analytical Skills
18 42 (10.94%) Java
19 41 (10.68%) Asset Management
19 41 (10.68%) Spreadsheet
20 39 (10.16%) Continuous Integration
20 39 (10.16%) Fixed Income
21 38 (9.90%) Data Analysis
21 38 (9.90%) Mathematics
22 37 (9.64%) Windows
23 36 (9.38%) Oracle
24 34 (8.85%) SQL Server Integration Services

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 17 (4.43%) SAS
2 14 (3.65%) IIS
3 10 (2.60%) SharePoint
4 4 (1.04%) Confluence
5 2 (0.52%) Apache
5 2 (0.52%) Apache Spark
5 2 (0.52%) Elasticsearch
5 2 (0.52%) SharePoint 2013
5 2 (0.52%) WebSphere
6 1 (0.26%) CMS
6 1 (0.26%) Oracle Workflow
6 1 (0.26%) Tomcat
6 1 (0.26%) WordPress
Applications
1 298 (77.60%) Microsoft Excel
2 41 (10.68%) Spreadsheet
3 25 (6.51%) Microsoft Office
4 22 (5.73%) Microsoft PowerPoint
5 6 (1.56%) MS Visio
6 2 (0.52%) SPSS
7 1 (0.26%) Acrobat
Business Applications
1 5 (1.30%) Dynamics AX
2 3 (0.78%) Bloomberg AIM
2 3 (0.78%) HFM
2 3 (0.78%) Markit EDM
3 2 (0.52%) Cognos TM1
3 2 (0.52%) Dynamics CRM
3 2 (0.52%) Eikon
3 2 (0.52%) PolarLake
3 2 (0.52%) thinkFolio
4 1 (0.26%) Endur
4 1 (0.26%) Salesforce.com CRM
4 1 (0.26%) ScheduALL
4 1 (0.26%) Summit
Cloud Services
1 28 (7.29%) Microsoft Azure
2 27 (7.03%) Amazon AWS
3 12 (3.13%) GitHub
4 9 (2.34%) Office 365
5 2 (0.52%) Amazon EMR
5 2 (0.52%) Amazon S3
5 2 (0.52%) Google Cloud Platform
6 1 (0.26%) Dynamics 365
Communications & Networking
1 7 (1.82%) PuTTY
1 7 (1.82%) Skype
1 7 (1.82%) VPN
1 7 (1.82%) Wireshark
2 5 (1.30%) Internet
2 5 (1.30%) TCP/IP
2 5 (1.30%) Wireless
3 4 (1.04%) SMS
4 1 (0.26%) Intranet
Database & Business Intelligence
1 128 (33.33%) SQL Server
2 46 (11.98%) Data Warehouse
3 34 (8.85%) SQL Server Integration Services
4 33 (8.59%) MS Access
5 30 (7.81%) SQL Server Reporting Services
6 24 (6.25%) Relational Database
7 22 (5.73%) Power BI
8 16 (4.17%) Oracle Database
8 16 (4.17%) SQL Server 2014
9 12 (3.13%) SQL Server 2016
10 11 (2.86%) SQL Server Analysis Services
11 10 (2.60%) Oracle Database 12c
12 9 (2.34%) NoSQL
12 9 (2.34%) OLAP
12 9 (2.34%) RDBMS
12 9 (2.34%) SQL Server 2012
13 8 (2.08%) MongoDB
14 6 (1.56%) Big Data
14 6 (1.56%) Hadoop
14 6 (1.56%) SQL Server 2008
Development Applications
1 14 (3.65%) Team Foundation Server
2 13 (3.39%) JIRA
3 12 (3.13%) Subversion
4 11 (2.86%) SpecFlow
5 9 (2.34%) Cucumber
6 8 (2.08%) Selenium
7 7 (1.82%) Jenkins
7 7 (1.82%) TeamCity
7 7 (1.82%) Visual Studio
8 6 (1.56%) Eclipse
9 4 (1.04%) Maven
9 4 (1.04%) NUnit
9 4 (1.04%) Octopus Deploy
9 4 (1.04%) Visual Studio Tools for Office
10 3 (0.78%) RStudio
11 2 (0.52%) Gatling
11 2 (0.52%) MSTest
11 2 (0.52%) Selendroid
11 2 (0.52%) SQL Server Management Studio (SSMS)
11 2 (0.52%) Visual Studio Team System
General
1 173 (45.05%) Finance
2 83 (21.61%) Banking
3 80 (20.83%) Front Office
4 33 (8.59%) Investment Banking
5 22 (5.73%) Retail
6 8 (2.08%) Billing
6 8 (2.08%) Financial Institution
7 7 (1.82%) Back Office
8 5 (1.30%) Legal
9 4 (1.04%) Marketing
10 3 (0.78%) Advertising
10 3 (0.78%) Law
11 2 (0.52%) Pharmaceutical
11 2 (0.52%) Publishing
12 1 (0.26%) Electronics
12 1 (0.26%) French Language
12 1 (0.26%) Mandarin Language
12 1 (0.26%) Manufacturing
12 1 (0.26%) Retail Banking
12 1 (0.26%) Telecoms
Job Titles
1 236 (61.46%) Developer
2 104 (27.08%) VBA Developer
3 100 (26.04%) Analyst
4 70 (18.23%) Excel Developer
5 54 (14.06%) Excel VBA Developer
6 48 (12.50%) C# Developer
7 34 (8.85%) .NET Developer
8 32 (8.33%) SQL Developer
9 31 (8.07%) Python Developer
10 29 (7.55%) Access Developer
11 28 (7.29%) Data Analyst
12 25 (6.51%) Access VBA Developer
13 22 (5.73%) SQL Analyst
14 20 (5.21%) C# .NET Developer
15 19 (4.95%) Front Office Developer
16 18 (4.69%) Excel Analyst
17 17 (4.43%) Quantitative Developer
18 14 (3.65%) Senior Developer
19 13 (3.39%) C# Pricing Developer
19 13 (3.39%) C# Quant Developer
Libraries, Frameworks & Software Standards
1 97 (25.26%) .NET
2 22 (5.73%) ASP.NET
3 18 (4.69%) .NET Framework
4 16 (4.17%) WPF
5 15 (3.91%) ASP.NET Core
6 13 (3.39%) Entity Framework
7 11 (2.86%) XML
8 9 (2.34%) Pandas
9 6 (1.56%) Web Services
10 5 (1.30%) Gherkin
10 5 (1.30%) NumPy
11 4 (1.04%) MDX
11 4 (1.04%) Middleware
11 4 (1.04%) PySpark
11 4 (1.04%) SOAP
12 3 (0.78%) ASP.NET MVC
12 3 (0.78%) HTML
12 3 (0.78%) JSON
12 3 (0.78%) REST
12 3 (0.78%) WinForms
Miscellaneous
1 46 (11.98%) Derivative
2 43 (11.20%) Analytical Skills
3 39 (10.16%) Fixed Income
4 25 (6.51%) Equities
5 21 (5.47%) Reinsurance
6 19 (4.95%) Self-Motivation
7 17 (4.43%) Market Risk
8 15 (3.91%) Credit Derivative
8 15 (3.91%) Hedge funds
9 14 (3.65%) Computer Science
10 11 (2.86%) FMCG
10 11 (2.86%) Foreign Exchange (FX)
11 8 (2.08%) Data Structures
11 8 (2.08%) EPoS
12 7 (1.82%) Analytical Mindset
12 7 (1.82%) Greenfield Project
13 6 (1.56%) OTC Derivatives
14 5 (1.30%) Fintech
14 5 (1.30%) Management Information System
14 5 (1.30%) Reference Data
Operating Systems
1 37 (9.64%) Windows
2 16 (4.17%) Windows 10
3 10 (2.60%) Windows 7
4 7 (1.82%) Linux
5 6 (1.56%) Android
5 6 (1.56%) Windows Server
6 4 (1.04%) Unix
7 3 (0.78%) Apple iOS
7 3 (0.78%) Windows Server 2012
8 2 (0.52%) Oracle Linux
8 2 (0.52%) Solaris
9 1 (0.26%) Red Hat Enterprise Linux
9 1 (0.26%) Windows Server 2008
Processes & Methodologies
1 81 (21.09%) Analytics
2 61 (15.89%) Agile Software Development
3 50 (13.02%) Problem-Solving
4 46 (11.98%) Business Intelligence
5 41 (10.68%) Asset Management
6 39 (10.16%) Continuous Integration
7 38 (9.90%) Data Analysis
7 38 (9.90%) Mathematics
8 32 (8.33%) TDD
9 30 (7.81%) Test Automation
10 25 (6.51%) ETL
11 22 (5.73%) SDLC
11 22 (5.73%) Software Engineering
12 21 (5.47%) Migration
12 21 (5.47%) Scrum
13 20 (5.21%) Risk Management
14 19 (4.95%) Investment Management
14 19 (4.95%) Test Scripting
15 18 (4.69%) MVC
16 17 (4.43%) OO
Programming Languages
1 212 (55.21%) SQL
2 119 (30.99%) C#
3 83 (21.61%) Python
4 55 (14.32%) T-SQL
5 44 (11.46%) VB
6 42 (10.94%) Java
7 30 (7.81%) PowerShell
8 23 (5.99%) VB.NET
9 19 (4.95%) R
10 17 (4.43%) PL/SQL
11 16 (4.17%) C++
12 8 (2.08%) MATLAB
13 5 (1.30%) C
13 5 (1.30%) JavaScript
13 5 (1.30%) VBScript
14 3 (0.78%) Jython
14 3 (0.78%) Perl
14 3 (0.78%) PHP
14 3 (0.78%) Shell Script
14 3 (0.78%) VB6
Qualifications
1 54 (14.06%) Degree
2 23 (5.99%) Numerate Degree
3 14 (3.65%) PhD
4 5 (1.30%) MCDST
4 5 (1.30%) MCSE
4 5 (1.30%) Microsoft Certification
5 4 (1.04%) Computer Science Degree
6 3 (0.78%) Security Cleared
7 2 (0.52%) ACCA
7 2 (0.52%) BPSS Clearance
7 2 (0.52%) CFA
7 2 (0.52%) SC Cleared
8 1 (0.26%) CIMA
8 1 (0.26%) DBS Check
8 1 (0.26%) ISTQB
Quality Assurance & Compliance
1 22 (5.73%) QA
2 21 (5.47%) Data Quality
3 8 (2.08%) GDPR
4 4 (1.04%) Solvency II
5 3 (0.78%) MiFID
6 1 (0.26%) Disclosure Scotland
6 1 (0.26%) IFRS
6 1 (0.26%) PMO
System Software
1 11 (2.86%) Active Directory
2 10 (2.60%) VMware Infrastructure
3 8 (2.08%) Microsoft App-V
4 7 (1.82%) BitLocker
5 4 (1.04%) Virtual Desktop
6 3 (0.78%) DFS Replication
6 3 (0.78%) VMware ESXi
6 3 (0.78%) XenApp
6 3 (0.78%) XenDesktop
7 2 (0.52%) HDFS
8 1 (0.26%) Docker
Systems Management
1 16 (4.17%) SCCM
2 7 (1.82%) AirWatch
3 5 (1.30%) Systems Management Server (SMS)
4 3 (0.78%) McAfee ePO
4 3 (0.78%) SafeCom
4 3 (0.78%) SCOM
4 3 (0.78%) SCOrch
4 3 (0.78%) XenMobile
5 2 (0.52%) Control-M
5 2 (0.52%) RSA Archer
6 1 (0.26%) QRadar
Vendors
1 72 (18.75%) Microsoft
2 36 (9.38%) Oracle
3 30 (7.81%) Tableau
4 16 (4.17%) Bloomberg
4 16 (4.17%) Citrix
5 10 (2.60%) Reuters
5 10 (2.60%) VMware
6 9 (2.34%) Charles River
7 8 (2.08%) Ivanti
7 8 (2.08%) RedGate
8 7 (1.82%) Avaya
8 7 (1.82%) Cisco
8 7 (1.82%) Dell
8 7 (1.82%) HP
8 7 (1.82%) iManage
8 7 (1.82%) Polycom
8 7 (1.82%) ServiceNow
8 7 (1.82%) SolarWinds
9 5 (1.30%) Adobe
9 5 (1.30%) FactSet