Period
to 18 October 2018

The following table provides summary statistics for contract job vacancies advertised in the City of 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 18 October 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)
Central London > City of London
6 months to
18 Oct 2018
Same period 2017 Same period 2016
Rank 157 138 160
Rank change year-on-year -19 +22 -58
Contract jobs citing VBA 108 110 87
As % of all contract IT jobs advertised in the City of London 1.54% 1.60% 1.30%
As % of the Programming Languages category 2.86% 3.09% 2.61%
Number of daily rates quoted 74 71 71
City of London median daily rate £475 £550 £425
Median daily rate % change year-on-year -13.64% +29.41% -5.56%
10th Percentile £310 £313 £308
90th Percentile £713 £688 £550
Central London median daily rate £475 £545 £425
% change year-on-year -12.84% +28.24% -5.56%
Number of hourly rates quoted 0 1 0
City of London median hourly rate - £24.49 -
Central London median hourly rate - £24.49 -

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 the City of London with a requirement for coding skills.

All Programming Languages
City of London
Contract vacancies with a requirement for coding skills 3,778 3,558 3,329
As % of all contract IT jobs advertised in the City of London 53.89% 51.90% 49.84%
Number of daily rates quoted 3,142 2,896 2,808
City of London median daily rate £525 £525 £475
Median daily rate % change year-on-year - +10.53% -
10th Percentile £375 £363 £319
90th Percentile £688 £675 £650
Central London median daily rate £525 £500 £470
% change year-on-year +5.00% +6.38% +1.62%
Number of hourly rates quoted 12 11 12
City of London median hourly rate £29.55 £21.50 £27.50
Median hourly rate % change year-on-year +37.42% -21.82% +15.79%
10th Percentile £13.12 £13.30 £16.66
90th Percentile £60.47 £30.00 £56.68
Central London median hourly rate £22.00 £21.50 £27.50
% change year-on-year +2.33% -21.82% +15.79%

VBA
Job Vacancy Trend in the City of London

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

Job vacancy trend for VBA in the City of London

VBA
Contractor Daily Rate Trend in the City of London

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

Contractor daily rate trend for VBA in the City of London

VBA
Contractor Daily Rate Histogram in the City of London

The daily rate distribution of IT jobs citing VBA in the City of London over the 6 months to 18 October 2018.

Contractor daily rate histogram for VBA in the City of London

VBA
Contractor Hourly Rate Trend in the City of London

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

Contractor hourly rate trend for VBA in the City of London

For the 6 months to 18 October 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 City of London region with a requirement for VBA.

1 83 (76.85%) Microsoft Excel
2 70 (64.81%) SQL
3 54 (50.00%) Finance
4 39 (36.11%) C#
5 36 (33.33%) SQL Server
6 28 (25.93%) .NET
7 27 (25.00%) Analytics
8 25 (23.15%) Python
9 24 (22.22%) Front Office
10 23 (21.30%) T-SQL
11 22 (20.37%) Microsoft
11 22 (20.37%) SQL Server Reporting Services
12 19 (17.59%) Business Intelligence
13 18 (16.67%) Agile Software Development
14 17 (15.74%) R
15 16 (14.81%) SQL Server Integration Services
15 16 (14.81%) Banking
16 15 (13.89%) Data Warehouse
16 15 (13.89%) VB.NET
16 15 (13.89%) Windows
17 14 (12.96%) Derivative
18 13 (12.04%) Spreadsheet
18 13 (12.04%) MS Access
18 13 (12.04%) Self-Motivation
19 12 (11.11%) Relational Database
20 11 (10.19%) Asset Management
20 11 (10.19%) Migration
20 11 (10.19%) XML
20 11 (10.19%) Investment Management
20 11 (10.19%) Data Analytics

VBA
Co-occurring IT Skills in the City of 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 3 (2.78%) IIS
2 1 (0.93%) Apache
2 1 (0.93%) SAS
2 1 (0.93%) SharePoint
2 1 (0.93%) Tomcat
Applications
1 83 (76.85%) Microsoft Excel
2 13 (12.04%) Spreadsheet
3 7 (6.48%) Microsoft PowerPoint
4 6 (5.56%) Microsoft Office
Business Applications
1 2 (1.85%) Dynamics AX
1 2 (1.85%) Eikon
1 2 (1.85%) thinkFolio
2 1 (0.93%) Summit
Cloud Services
1 6 (5.56%) Office 365
2 3 (2.78%) Microsoft Azure
3 2 (1.85%) Google Analytics
4 1 (0.93%) Amazon AWS
Communications & Networking
1 3 (2.78%) PuTTY
1 3 (2.78%) Skype
1 3 (2.78%) VPN
1 3 (2.78%) Wireshark
Database & Business Intelligence
1 36 (33.33%) SQL Server
2 22 (20.37%) SQL Server Reporting Services
3 16 (14.81%) SQL Server Integration Services
4 15 (13.89%) Data Warehouse
5 13 (12.04%) MS Access
6 12 (11.11%) Relational Database
7 10 (9.26%) Power BI
8 9 (8.33%) RDBMS
9 5 (4.63%) Crystal Reports
10 4 (3.70%) Enterprise Data Warehouse
11 3 (2.78%) Biml
11 3 (2.78%) PostgreSQL
11 3 (2.78%) QlikView
11 3 (2.78%) SQL Server 2016
11 3 (2.78%) SQL Server Analysis Services
12 2 (1.85%) MongoDB
12 2 (1.85%) MySQL
13 1 (0.93%) DB2
13 1 (0.93%) NoSQL
13 1 (0.93%) OLAP
Development Applications
1 8 (7.41%) Subversion
2 5 (4.63%) Team Foundation Server
3 4 (3.70%) Maven
4 3 (2.78%) JIRA
4 3 (2.78%) RStudio
5 1 (0.93%) Artifactory
5 1 (0.93%) Eclipse
5 1 (0.93%) ERwin
5 1 (0.93%) Git (software)
5 1 (0.93%) Jenkins
5 1 (0.93%) MSTest
5 1 (0.93%) NUnit
5 1 (0.93%) PowerDesigner
5 1 (0.93%) SpecFlow
5 1 (0.93%) SQL Server Management Studio (SSMS)
5 1 (0.93%) Toad
5 1 (0.93%) Visual Studio
General
1 54 (50.00%) Finance
2 24 (22.22%) Front Office
3 16 (14.81%) Banking
4 4 (3.70%) Financial Institution
4 4 (3.70%) Investment Banking
5 3 (2.78%) Billing
5 3 (2.78%) Law
5 3 (2.78%) Marketing
5 3 (2.78%) Retail
6 1 (0.93%) Advertising
6 1 (0.93%) Back Office
6 1 (0.93%) Digital Economy
6 1 (0.93%) Legal
6 1 (0.93%) Retail Banking
Job Titles
1 61 (56.48%) Developer
2 33 (30.56%) VBA Developer
3 26 (24.07%) Analyst
4 19 (17.59%) Excel Developer
4 19 (17.59%) Excel VBA Developer
5 16 (14.81%) Python Developer
6 15 (13.89%) SQL Developer
7 12 (11.11%) C# Developer
8 11 (10.19%) .NET Developer
9 9 (8.33%) Front Office Developer
10 8 (7.41%) Analytics Consultant
10 8 (7.41%) Consultant
10 8 (7.41%) Data Analyst
10 8 (7.41%) Data Analytics Consultant
10 8 (7.41%) Data Consultant
10 8 (7.41%) Senior Developer
11 6 (5.56%) Access Developer
11 6 (5.56%) Business Intelligence Analyst
11 6 (5.56%) C# .NET Developer
12 5 (4.63%) Senior Python Developer
Libraries, Frameworks & Software Standards
1 28 (25.93%) .NET
2 11 (10.19%) XML
3 7 (6.48%) .NET Framework
4 5 (4.63%) Entity Framework
4 5 (4.63%) NumPy
4 5 (4.63%) Pandas
4 5 (4.63%) WPF
5 2 (1.85%) SOAP
5 2 (1.85%) Web Services
6 1 (0.93%) ActiveX
6 1 (0.93%) AngularJS
6 1 (0.93%) ASP.NET
6 1 (0.93%) CSS
6 1 (0.93%) HTML
6 1 (0.93%) JMS
6 1 (0.93%) Middleware
6 1 (0.93%) Node.js
6 1 (0.93%) REST
6 1 (0.93%) RESTful
6 1 (0.93%) WinForms
Miscellaneous
1 14 (12.96%) Derivative
2 13 (12.04%) Self-Motivation
3 10 (9.26%) Fixed Income
3 10 (9.26%) Reinsurance
4 9 (8.33%) Analytical Skills
4 9 (8.33%) Equities
5 8 (7.41%) Data Structures
6 5 (4.63%) Fintech
6 5 (4.63%) Management Information System
7 4 (3.70%) Analytical Mindset
7 4 (3.70%) Market Risk
7 4 (3.70%) Reference Data
8 3 (2.78%) Blackberry
9 2 (1.85%) Foreign Exchange (FX)
9 2 (1.85%) Greenfield Project
10 1 (0.93%) Computer Science
10 1 (0.93%) Equity Derivative
10 1 (0.93%) Podcast
10 1 (0.93%) SWIFT
10 1 (0.93%) Tandem
Operating Systems
1 15 (13.89%) Windows
2 10 (9.26%) Windows 10
3 4 (3.70%) Windows 7
4 3 (2.78%) Windows Server 2012
5 1 (0.93%) Linux
5 1 (0.93%) Windows Server
Processes & Methodologies
1 27 (25.00%) Analytics
2 19 (17.59%) Business Intelligence
3 18 (16.67%) Agile Software Development
4 11 (10.19%) Asset Management
4 11 (10.19%) Data Analytics
4 11 (10.19%) Investment Management
4 11 (10.19%) Migration
4 11 (10.19%) Problem-Solving
5 10 (9.26%) Continuous Integration
5 10 (9.26%) Data Analysis
5 10 (9.26%) Visualisation
6 9 (8.33%) Software Engineering
7 8 (7.41%) OO
7 8 (7.41%) SDLC
8 7 (6.48%) Process Improvement
8 7 (6.48%) Project Management
8 7 (6.48%) TDD
9 6 (5.56%) Business Analysis
9 6 (5.56%) ETL
10 5 (4.63%) Stakeholder Management
Programming Languages
1 70 (64.81%) SQL
2 39 (36.11%) C#
3 25 (23.15%) Python
4 23 (21.30%) T-SQL
5 17 (15.74%) R
6 15 (13.89%) VB.NET
7 9 (8.33%) Java
8 8 (7.41%) PowerShell
9 7 (6.48%) VB
10 5 (4.63%) MATLAB
11 3 (2.78%) JavaScript
11 3 (2.78%) PL/SQL
12 2 (1.85%) C
12 2 (1.85%) C++
13 1 (0.93%) Ruby
13 1 (0.93%) VBScript
Qualifications
1 11 (10.19%) Degree
2 2 (1.85%) Numerate Degree
3 1 (0.93%) CFA
3 1 (0.93%) Computer Science Degree
3 1 (0.93%) ISTQB
3 1 (0.93%) MBA
Quality Assurance & Compliance
1 4 (3.70%) QA
2 3 (2.78%) Data Quality
3 1 (0.93%) PMO
3 1 (0.93%) Solvency II
System Software
1 6 (5.56%) VMware Infrastructure
2 3 (2.78%) Active Directory
2 3 (2.78%) BitLocker
2 3 (2.78%) DFS Replication
2 3 (2.78%) Microsoft App-V
2 3 (2.78%) Virtual Desktop
2 3 (2.78%) VMware ESXi
2 3 (2.78%) XenApp
2 3 (2.78%) XenDesktop
Systems Management
1 6 (5.56%) SCCM
2 3 (2.78%) AirWatch
2 3 (2.78%) McAfee ePO
2 3 (2.78%) SafeCom
2 3 (2.78%) SCOM
2 3 (2.78%) SCOrch
2 3 (2.78%) XenMobile
3 2 (1.85%) QRadar
Vendors
1 22 (20.37%) Microsoft
2 9 (8.33%) Oracle
2 9 (8.33%) Tableau
3 6 (5.56%) Citrix
3 6 (5.56%) VMware
4 5 (4.63%) Bloomberg
4 5 (4.63%) Charles River
4 5 (4.63%) FactSet
5 4 (3.70%) Reuters
6 3 (2.78%) Avaya
6 3 (2.78%) Cisco
6 3 (2.78%) Dell
6 3 (2.78%) HP
6 3 (2.78%) iManage
6 3 (2.78%) Ivanti
6 3 (2.78%) McAfee
6 3 (2.78%) Polycom
6 3 (2.78%) ServiceNow
6 3 (2.78%) SolarWinds
7 2 (1.85%) Google