Period
to 17 February 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 February 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 Feb 2018
Same period 2017 Same period 2016
Rank 218 269 197
Rank change year-on-year +51 -72 -35
Contract jobs citing VBA 577 385 600
As % of all contract IT jobs advertised in London 1.24% 0.93% 1.35%
As % of the Programming Languages category 2.60% 2.05% 3.13%
Number of daily rates quoted 436 280 420
London median daily rate £450 £413 £438
Median daily rate % change year-on-year +9.09% -5.71% -2.78%
10th Percentile £299 £272 £263
90th Percentile £681 £600 £638
England median daily rate £425 £400 £400
% change year-on-year +6.25% - +1.59%
Number of hourly rates quoted 0 1 5
London median hourly rate - £11.40 £20.00
Median hourly rate % change year-on-year - -43.00% -23.81%
England median hourly rate £26.50 £19.50 £19.50
% change year-on-year +35.90% - -13.33%

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,225 18,745 19,182
As % of all contract IT jobs advertised in London 47.73% 45.38% 43.16%
Number of daily rates quoted 17,060 14,011 14,408
London median daily rate £500 £475 £450
Median daily rate % change year-on-year +5.26% +5.56% +2.74%
10th Percentile £350 £325 £306
90th Percentile £675 £638 £638
England median daily rate £475 £425 £420
% change year-on-year +11.76% +1.19% +5.00%
Number of hourly rates quoted 172 124 126
London median hourly rate £33.27 £42.00 £29.32
Median hourly rate % change year-on-year -20.79% +43.25% +1.98%
10th Percentile £17.75 £16.74 £14.06
90th Percentile £50.50 £65.00 £55.00
England median hourly rate £40.00 £40.00 £37.50
% change year-on-year - +6.67% +13.64%

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 February 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 17 February 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 +46 150 £450 +12.50% 31
South London -22 23 £388 +34.78% 3
East London +4 16 £400 -23.81% 2
West London -31 10 £265 -11.67% 15
VBA
England

For the 6 months to 17 February 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 436 (75.56%) Microsoft Excel
2 297 (51.47%) SQL
3 271 (46.97%) Finance
4 199 (34.49%) Banking
5 185 (32.06%) SQL Server
6 184 (31.89%) C#
7 158 (27.38%) Front Office
8 134 (23.22%) .NET
9 129 (22.36%) Python
10 103 (17.85%) Oracle
11 95 (16.46%) Analytical Skills
12 94 (16.29%) Microsoft
13 90 (15.60%) Agile Software Development
14 89 (15.42%) Java
15 85 (14.73%) Derivative
16 78 (13.52%) Business Intelligence
17 77 (13.34%) Fixed Income
18 71 (12.31%) Risk Management
19 69 (11.96%) Investment Banking
20 68 (11.79%) C++
21 63 (10.92%) Data Analysis
22 58 (10.05%) SDLC
23 57 (9.88%) RAD
24 56 (9.71%) Analytics
25 55 (9.53%) .NET Framework
25 55 (9.53%) Spreadsheet
26 53 (9.19%) MS Access
27 48 (8.32%) VB
28 47 (8.15%) Degree
29 46 (7.97%) 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 38 (6.59%) SAS
2 26 (4.51%) SharePoint
3 9 (1.56%) IIS
4 8 (1.39%) Confluence
5 4 (0.69%) CMS
5 4 (0.69%) Oracle Workflow
6 2 (0.35%) Apache
6 2 (0.35%) SharePoint 2010
7 1 (0.17%) Apache Airflow
7 1 (0.17%) Skype for Business
Applications
1 436 (75.56%) Microsoft Excel
2 55 (9.53%) Spreadsheet
3 38 (6.59%) Microsoft PowerPoint
4 35 (6.07%) Microsoft Office
5 16 (2.77%) MS Visio
6 13 (2.25%) Microsoft Project
7 5 (0.87%) InfoPath
8 1 (0.17%) Doxygen
Business Applications
1 8 (1.39%) Summit
2 4 (0.69%) SimCorp Dimension
3 3 (0.52%) SAP R/3
3 3 (0.52%) SAP SD
4 2 (0.35%) Dynamics AX
4 2 (0.35%) Dynamics NAV
4 2 (0.35%) Oracle Financials
4 2 (0.35%) Orchestrade
4 2 (0.35%) RMDS
5 1 (0.17%) Cognos TM1
5 1 (0.17%) Dynamics CRM
5 1 (0.17%) Elite 3E
5 1 (0.17%) FINCAD Analytics
5 1 (0.17%) ION MarketView
5 1 (0.17%) Oracle General Ledger
5 1 (0.17%) SAP HR
5 1 (0.17%) Temenos Globus
5 1 (0.17%) thinkFolio
5 1 (0.17%) WebTrends
5 1 (0.17%) Workfront
Cloud Services
1 9 (1.56%) Amazon AWS
2 8 (1.39%) Microsoft Azure
3 7 (1.21%) Office 365
4 6 (1.04%) Adobe Analytics
5 3 (0.52%) G Suite
6 2 (0.35%) Azure Data Factory
6 2 (0.35%) GitHub
6 2 (0.35%) Google Analytics
7 1 (0.17%) Google Cloud Platform
7 1 (0.17%) Google Tag Manager
Communications & Networking
1 7 (1.21%) SMS
2 2 (0.35%) Firewall
2 2 (0.35%) SSH
3 1 (0.17%) DMZ
3 1 (0.17%) DNS
3 1 (0.17%) HTTP
3 1 (0.17%) Internet
3 1 (0.17%) LAN
3 1 (0.17%) Skype
3 1 (0.17%) VLAN
3 1 (0.17%) VPN
3 1 (0.17%) WAN
Database & Business Intelligence
1 185 (32.06%) SQL Server
2 53 (9.19%) MS Access
3 46 (7.97%) SQL Server Integration Services
4 42 (7.28%) Relational Database
5 41 (7.11%) Power BI
6 32 (5.55%) SQL Server Reporting Services
7 29 (5.03%) RDBMS
8 24 (4.16%) Data Warehouse
9 23 (3.99%) Oracle Database
10 17 (2.95%) SAS EBI
11 16 (2.77%) Oracle Database 11g
11 16 (2.77%) SQL Server 2008
12 15 (2.60%) Big Data
13 14 (2.43%) BusinessObjects
14 12 (2.08%) Base SAS
14 12 (2.08%) OLAP
14 12 (2.08%) SQL Server 2016
15 11 (1.91%) SQL Server 2014
15 11 (1.91%) SQL Server Analysis Services
16 10 (1.73%) QlikView
Development Applications
1 27 (4.68%) JIRA
2 13 (2.25%) Subversion
3 12 (2.08%) Cucumber
4 11 (1.91%) Team Foundation Server
4 11 (1.91%) Visual Studio
5 10 (1.73%) Selenium
6 8 (1.39%) Git (software)
6 8 (1.39%) SpecFlow
7 6 (1.04%) Jenkins
8 4 (0.69%) JMeter
9 3 (0.52%) Atlassian Bamboo
9 3 (0.52%) Selendroid
10 2 (0.35%) Bitbucket
10 2 (0.35%) MSBuild
10 2 (0.35%) NUnit
11 1 (0.17%) EasyMock
11 1 (0.17%) Maven
11 1 (0.17%) Mockito
11 1 (0.17%) Oracle APEX
11 1 (0.17%) TeamCity
General
1 271 (46.97%) Finance
2 199 (34.49%) Banking
3 158 (27.38%) Front Office
4 69 (11.96%) Investment Banking
5 18 (3.12%) Legal
6 16 (2.77%) Marketing
6 16 (2.77%) Retail
7 10 (1.73%) Financial Institution
8 9 (1.56%) Back Office
9 7 (1.21%) French Language
10 5 (0.87%) Retail Banking
11 4 (0.69%) Advertising
11 4 (0.69%) Local Government
12 2 (0.35%) Billing
12 2 (0.35%) Law
12 2 (0.35%) Telecoms
13 1 (0.17%) Corporate Banking
13 1 (0.17%) General Ledger
13 1 (0.17%) Private Banking
13 1 (0.17%) Wholesale Banking
Job Titles
1 314 (54.42%) Developer
2 193 (33.45%) Analyst
3 111 (19.24%) VBA Developer
4 74 (12.82%) Excel Developer
5 72 (12.48%) C# Developer
6 71 (12.31%) Excel VBA Developer
7 57 (9.88%) SQL Developer
8 56 (9.71%) Data Analyst
9 53 (9.19%) .NET Developer
10 47 (8.15%) Business Analyst
11 46 (7.97%) Python Developer
11 46 (7.97%) RAD Developer
12 43 (7.45%) Front Office Developer
13 34 (5.89%) C# .NET Developer
14 32 (5.55%) Risk Analyst
15 29 (5.03%) Senior Developer
16 28 (4.85%) Analyst Developer
17 27 (4.68%) SQL Analyst
18 24 (4.16%) Banking Analyst
19 23 (3.99%) Senior Python Developer
Libraries, Frameworks & Software Standards
1 134 (23.22%) .NET
2 55 (9.53%) .NET Framework
3 36 (6.24%) HTML
4 24 (4.16%) XML
5 23 (3.99%) CSS
6 19 (3.29%) WinForms
7 16 (2.77%) Web Services
8 12 (2.08%) ASP.NET
8 12 (2.08%) Entity Framework
9 11 (1.91%) WPF
10 9 (1.56%) WCF
11 6 (1.04%) ASP.NET Web API
11 6 (1.04%) JSON
11 6 (1.04%) REST
11 6 (1.04%) Task Parallel Library
12 4 (0.69%) Angular 2
12 4 (0.69%) AngularJS
12 4 (0.69%) HTML5
12 4 (0.69%) MDX
12 4 (0.69%) Spring
Miscellaneous
1 95 (16.46%) Analytical Skills
2 85 (14.73%) Derivative
3 77 (13.34%) Fixed Income
4 35 (6.07%) Credit Risk
5 33 (5.72%) Foreign Exchange (FX)
6 30 (5.20%) Management Information System
7 27 (4.68%) Market Risk
8 25 (4.33%) Equities
9 23 (3.99%) Computer Science
10 15 (2.60%) Equity Derivative
11 7 (1.21%) Data Structures
12 6 (1.04%) Interest Rate Derivative
12 6 (1.04%) NHS
12 6 (1.04%) Reinsurance
12 6 (1.04%) Robotics
13 4 (0.69%) Credit Derivative
13 4 (0.69%) OTC Derivatives
14 3 (0.52%) Clustering
14 3 (0.52%) Hedge funds
15 2 (0.35%) Reference Data
Operating Systems
1 39 (6.76%) Windows
2 12 (2.08%) Linux
2 12 (2.08%) Unix
3 7 (1.21%) Windows 10
4 6 (1.04%) Android
5 3 (0.52%) Apple iOS
5 3 (0.52%) Windows 7
5 3 (0.52%) Windows Server
6 2 (0.35%) Windows Server 2008
6 2 (0.35%) Windows Server 2012
7 1 (0.17%) Ubuntu
Processes & Methodologies
1 90 (15.60%) Agile Software Development
2 78 (13.52%) Business Intelligence
3 71 (12.31%) Risk Management
4 63 (10.92%) Data Analysis
5 58 (10.05%) SDLC
6 57 (9.88%) RAD
7 56 (9.71%) Analytics
8 45 (7.80%) Asset Management
9 43 (7.45%) Project Management
10 41 (7.11%) Stakeholder Management
11 40 (6.93%) Business Analysis
12 39 (6.76%) Mathematics
13 33 (5.72%) Data Modelling
14 32 (5.55%) Data Management
14 32 (5.55%) Visualisation
15 29 (5.03%) Migration
16 27 (4.68%) Unit Testing
17 25 (4.33%) Operations Research
18 24 (4.16%) Workflow
19 23 (3.99%) Quantitative Research
Programming Languages
1 297 (51.47%) SQL
2 184 (31.89%) C#
3 129 (22.36%) Python
4 89 (15.42%) Java
5 68 (11.79%) C++
6 48 (8.32%) VB
7 39 (6.76%) VB.NET
8 32 (5.55%) R
9 31 (5.37%) PowerShell
10 30 (5.20%) JavaScript
10 30 (5.20%) T-SQL
11 22 (3.81%) PL/SQL
12 16 (2.77%) VBScript
13 14 (2.43%) PHP
14 12 (2.08%) MATLAB
15 11 (1.91%) Perl
16 8 (1.39%) C
17 6 (1.04%) Shell Script
18 4 (0.69%) VB6
19 3 (0.52%) Google Apps Script
Qualifications
1 47 (8.15%) Degree
2 22 (3.81%) Security Cleared
3 12 (2.08%) SC Cleared
4 8 (1.39%) Computer Science Degree
5 6 (1.04%) Master's Degree
5 6 (1.04%) PMP
6 5 (0.87%) PhD
6 5 (0.87%) PMI Certification
7 4 (0.69%) Microsoft Certification
8 3 (0.52%) MCSE
9 2 (0.35%) BPSS Clearance
9 2 (0.35%) MCSA
9 2 (0.35%) MOS
10 1 (0.17%) CFA
10 1 (0.17%) CTC Cleared
10 1 (0.17%) MCP
10 1 (0.17%) Numerate Degree
10 1 (0.17%) Postgraduate
Quality Assurance & Compliance
1 40 (6.93%) QA
2 22 (3.81%) Data Quality
3 12 (2.08%) GDPR
4 10 (1.73%) Basel II
4 10 (1.73%) MiFID
5 9 (1.56%) IFRS
5 9 (1.56%) Solvency II
6 7 (1.21%) PMO
7 5 (0.87%) EMIR
7 5 (0.87%) IFRS 9
8 4 (0.69%) Basel III
8 4 (0.69%) Sarbanes-Oxley
9 3 (0.52%) Disclosure Scotland
9 3 (0.52%) FATCA
10 2 (0.35%) Dodd-Frank
11 1 (0.17%) CRD IV
System Software
1 7 (1.21%) Docker
2 6 (1.04%) Virtual Desktop
3 3 (0.52%) Cronacle
4 2 (0.35%) Active Directory
5 1 (0.17%) Hyper-V
5 1 (0.17%) Virtual Machines
5 1 (0.17%) VMware Infrastructure
5 1 (0.17%) VMware Workstation
Systems Management
1 2 (0.35%) Control-M
2 1 (0.17%) ITRS Geneos
2 1 (0.17%) QRadar
Vendors
1 103 (17.85%) Oracle
2 94 (16.29%) Microsoft
3 41 (7.11%) Tableau
4 19 (3.29%) Cognos
5 17 (2.95%) SAP
6 12 (2.08%) Bloomberg
6 12 (2.08%) Reuters
7 11 (1.91%) Sybase
8 8 (1.39%) Blue Prism
9 7 (1.21%) Citrix
10 6 (1.04%) Adobe
11 5 (0.87%) Charles River
11 5 (0.87%) Google
11 5 (0.87%) Omniture
11 5 (0.87%) SimCorp
12 4 (0.69%) Alteryx
12 4 (0.69%) Sun
13 3 (0.52%) Calypso
13 3 (0.52%) Hyperion
13 3 (0.52%) Murex