Period
to 20 November 2017

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 20 November 2017 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
20 Nov 2017
Same period 2016 Same period 2015
Rank 213 261 175
Rank change year-on-year +48 -86 +9
Contract jobs citing VBA 601 426 679
As % of all contract IT jobs advertised in London 1.29% 0.96% 1.45%
As % of the Programming Languages category 2.65% 2.14% 3.33%
Number of daily rates quoted 446 330 491
London median daily rate £500 £400 £450
Median daily rate % change year-on-year +25.00% -11.11% +2.27%
10th Percentile £300 £213 £263
90th Percentile £688 £575 £638
England median daily rate £450 £380 £400
% change year-on-year +18.42% -5.00% +3.23%
Number of hourly rates quoted 1 4 5
London median hourly rate £24.49 £13.76 £20.00
Median hourly rate % change year-on-year +77.94% -31.20% -11.11%
10th Percentile £23.11 £11.40 £12.13
90th Percentile £25.86 £17.42 £25.70
England median hourly rate £24.49 £16.66 £21.50
% change year-on-year +47.01% -22.53% -4.44%

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 22710 19885 20374
As % of all contract IT jobs advertised in London 48.66% 44.61% 43.44%
Number of daily rates quoted 17204 14874 15199
London median daily rate £500 £468 £450
Median daily rate % change year-on-year +6.95% +3.89% +5.88%
10th Percentile £350 £313 £305
90th Percentile £669 £633 £638
England median daily rate £460 £425 £410
% change year-on-year +8.24% +3.66% +2.50%
Number of hourly rates quoted 155 113 144
London median hourly rate £35.00 £35.00 £25.00
Median hourly rate % change year-on-year - +40.00% -14.50%
10th Percentile £18.02 £16.70 £13.65
90th Percentile £52.30 £57.38 £52.17
England median hourly rate £40.00 £37.50 £37.50
% change year-on-year +6.67% - +25.00%

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 20 November 2017.

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 20 November 2017. 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 +44 145 £538 +26.47% 16
East London -2 14 £425 +8.97% 1
South London -32 8 £688 +129.17% 1
West London -26 5 £325 +2.77% 3
VBA
England

For the 6 months to 20 November 2017, IT contractor jobs citing VBA also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the London region with a requirement for VBA.

1 444 (73.88%) Microsoft Excel
2 311 (51.75%) SQL
3 263 (43.76%) Finance
4 228 (37.94%) Banking
5 196 (32.61%) SQL Server
6 191 (31.78%) Front Office
7 180 (29.95%) C#
8 144 (23.96%) Python
9 134 (22.30%) .NET
10 109 (18.14%) Agile Software Development
11 96 (15.97%) Derivative
11 96 (15.97%) Microsoft
12 95 (15.81%) Java
13 94 (15.64%) Oracle
14 87 (14.48%) C++
15 84 (13.98%) Investment Banking
16 79 (13.14%) Analytical Skills
17 75 (12.48%) Data Analysis
18 74 (12.31%) Fixed Income
19 72 (11.98%) Analytics
20 67 (11.15%) Business Intelligence
21 66 (10.98%) RAD
22 62 (10.32%) Foreign Exchange (FX)
23 58 (9.65%) Risk Management
24 56 (9.32%) Spreadsheet
24 56 (9.32%) Asset Management
25 53 (8.82%) VB
26 52 (8.65%) .NET Framework
27 51 (8.49%) Degree
27 51 (8.49%) SDLC

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 26 (4.33%) SAS
2 18 (3.00%) SharePoint
3 7 (1.16%) CMS
4 6 (1.00%) Confluence
5 4 (0.67%) Apache
6 3 (0.50%) IIS
6 3 (0.50%) Oracle Workflow
7 2 (0.33%) SharePoint 2010
7 2 (0.33%) WebSphere
8 1 (0.17%) OpenEdge
8 1 (0.17%) Skype for Business
Applications
1 444 (73.88%) Microsoft Excel
2 56 (9.32%) Spreadsheet
3 38 (6.32%) Microsoft PowerPoint
4 36 (5.99%) Microsoft Office
5 10 (1.66%) MS Visio
6 9 (1.50%) Microsoft Project
7 4 (0.67%) InfoPath
8 2 (0.33%) SPSS
9 1 (0.17%) Doxygen
Business Applications
1 5 (0.83%) Dynamics CRM
2 4 (0.67%) RMDS
3 3 (0.50%) Global One
3 3 (0.50%) Summit
4 2 (0.33%) Dynamics AX
4 2 (0.33%) Orchestrade
5 1 (0.17%) Cognos TM1
5 1 (0.17%) FINCAD Analytics
5 1 (0.17%) HFM
5 1 (0.17%) Hyperion Planning
5 1 (0.17%) ION MarketView
5 1 (0.17%) SAP FI-GL
5 1 (0.17%) SimCorp Dimension
5 1 (0.17%) Temenos Globus
5 1 (0.17%) WebTrends
Cloud Services
1 7 (1.16%) Amazon AWS
2 5 (0.83%) Microsoft Azure
3 4 (0.67%) Adobe Analytics
3 4 (0.67%) G Suite
3 4 (0.67%) Google Analytics
4 2 (0.33%) Azure Data Factory
4 2 (0.33%) Office 365
5 1 (0.17%) AdWords
5 1 (0.17%) Google Cloud Platform
5 1 (0.17%) Google Tag Manager
Communications & Networking
1 4 (0.67%) SMS
2 3 (0.50%) DNS
2 3 (0.50%) Firewall
2 3 (0.50%) LAN
2 3 (0.50%) WAN
3 2 (0.33%) SAN
4 1 (0.17%) DMZ
4 1 (0.17%) Internet
4 1 (0.17%) LDAP
4 1 (0.17%) Skype
4 1 (0.17%) VLAN
4 1 (0.17%) VPN
Database & Business Intelligence
1 196 (32.61%) SQL Server
2 43 (7.15%) Relational Database
3 41 (6.82%) MS Access
4 39 (6.49%) SQL Server Integration Services
5 35 (5.82%) Power BI
6 33 (5.49%) RDBMS
7 28 (4.66%) Oracle Database
8 21 (3.49%) SQL Server Reporting Services
9 20 (3.33%) Data Warehouse
10 18 (3.00%) SQL Server 2008
11 17 (2.83%) BusinessObjects
11 17 (2.83%) Oracle Database 11g
12 14 (2.33%) Big Data
12 14 (2.33%) SAS EBI
13 10 (1.66%) SQL Server Analysis Services
14 9 (1.50%) QlikView
15 8 (1.33%) Crystal Reports
15 8 (1.33%) SQL Server 2014
16 6 (1.00%) Amazon QuickSight
16 6 (1.00%) SQL Server 2016
Development Applications
1 21 (3.49%) JIRA
2 16 (2.66%) Selenium
3 15 (2.50%) SpecFlow
3 15 (2.50%) Subversion
3 15 (2.50%) Visual Studio
4 13 (2.16%) Cucumber
4 13 (2.16%) Team Foundation Server
5 7 (1.16%) Jenkins
6 5 (0.83%) JMeter
7 4 (0.67%) TeamCity
8 3 (0.50%) Ant
8 3 (0.50%) Atlassian Bamboo
8 3 (0.50%) ClearCase
8 3 (0.50%) Git (software)
8 3 (0.50%) Maven
8 3 (0.50%) NUnit
8 3 (0.50%) Oracle APEX
8 3 (0.50%) Toad
9 2 (0.33%) Eclipse
9 2 (0.33%) WebObjects
General
1 263 (43.76%) Finance
2 228 (37.94%) Banking
3 191 (31.78%) Front Office
4 84 (13.98%) Investment Banking
5 13 (2.16%) Back Office
5 13 (2.16%) Marketing
6 10 (1.66%) Financial Institution
7 9 (1.50%) Legal
8 7 (1.16%) French Language
8 7 (1.16%) Retail
9 6 (1.00%) Local Government
9 6 (1.00%) Retail Banking
10 4 (0.67%) Japanese Language
10 4 (0.67%) Telecoms
11 2 (0.33%) Advertising
11 2 (0.33%) Billing
11 2 (0.33%) Corporate Banking
11 2 (0.33%) Multimedia
12 1 (0.17%) General Ledger
12 1 (0.17%) Private Banking
Job Titles
1 344 (57.24%) Developer
2 184 (30.62%) Analyst
3 107 (17.80%) VBA Developer
4 71 (11.81%) C# Developer
5 68 (11.31%) Excel Developer
6 61 (10.15%) .NET Developer
7 60 (9.98%) Python Developer
8 59 (9.82%) Excel VBA Developer
9 57 (9.48%) RAD Developer
10 56 (9.32%) Data Analyst
11 54 (8.99%) Front Office Developer
12 52 (8.65%) Business Analyst
12 52 (8.65%) SQL Developer
13 41 (6.82%) C# .NET Developer
14 34 (5.66%) SQL Analyst
15 32 (5.32%) Senior Developer
16 29 (4.83%) Risk Analyst
17 28 (4.66%) Analyst Developer
18 25 (4.16%) Banking Analyst
19 23 (3.83%) Access Developer
Libraries, Frameworks & Software Standards
1 134 (22.30%) .NET
2 52 (8.65%) .NET Framework
3 29 (4.83%) XML
4 28 (4.66%) HTML
5 24 (3.99%) WinForms
6 21 (3.49%) Web Services
7 17 (2.83%) CSS
8 13 (2.16%) Entity Framework
9 12 (2.00%) ASP.NET
10 10 (1.66%) WPF
10 10 (1.66%) XML Messaging
11 7 (1.16%) HTML5
12 6 (1.00%) WCF
13 5 (0.83%) MDX
13 5 (0.83%) Middleware
13 5 (0.83%) REST
14 4 (0.67%) JSON
14 4 (0.67%) Task Parallel Library
15 3 (0.50%) LINQ
15 3 (0.50%) Spring
Miscellaneous
1 96 (15.97%) Derivative
2 79 (13.14%) Analytical Skills
3 74 (12.31%) Fixed Income
4 62 (10.32%) Foreign Exchange (FX)
5 37 (6.16%) Equities
6 36 (5.99%) Credit Risk
7 31 (5.16%) Computer Science
8 28 (4.66%) Market Risk
9 21 (3.49%) Management Information System
10 14 (2.33%) Equity Derivative
11 8 (1.33%) NHS
12 7 (1.16%) Hedge funds
13 6 (1.00%) Interest Rate Derivative
14 5 (0.83%) Data Structures
14 5 (0.83%) Robotics
14 5 (0.83%) Virtual Team
15 4 (0.67%) Credit Derivative
16 3 (0.50%) Clustering
16 3 (0.50%) Data Protection Act
16 3 (0.50%) OTC Derivatives
Operating Systems
1 39 (6.49%) Windows
2 26 (4.33%) Unix
3 8 (1.33%) Linux
4 3 (0.50%) Android
4 3 (0.50%) Apple iOS
5 2 (0.33%) Windows 10
5 2 (0.33%) Windows Server 2008
6 1 (0.17%) Windows 7
6 1 (0.17%) Windows Server
6 1 (0.17%) Windows Server 2012
Processes & Methodologies
1 109 (18.14%) Agile Software Development
2 75 (12.48%) Data Analysis
3 72 (11.98%) Analytics
4 67 (11.15%) Business Intelligence
5 66 (10.98%) RAD
6 58 (9.65%) Risk Management
7 56 (9.32%) Asset Management
8 51 (8.49%) SDLC
9 49 (8.15%) Mathematics
10 45 (7.49%) Project Management
11 36 (5.99%) Unit Testing
12 33 (5.49%) Visualisation
13 32 (5.32%) Stakeholder Management
14 31 (5.16%) Data Modelling
15 26 (4.33%) Business Analysis
15 26 (4.33%) Scrum
16 25 (4.16%) Data Analytics
16 25 (4.16%) Migration
17 24 (3.99%) Quantitative Research
18 21 (3.49%) Investment Management
Programming Languages
1 311 (51.75%) SQL
2 180 (29.95%) C#
3 144 (23.96%) Python
4 95 (15.81%) Java
5 87 (14.48%) C++
6 53 (8.82%) VB
7 43 (7.15%) R
8 41 (6.82%) VB.NET
9 32 (5.32%) PL/SQL
10 31 (5.16%) JavaScript
11 27 (4.49%) Perl
12 24 (3.99%) T-SQL
13 22 (3.66%) PowerShell
14 11 (1.83%) C
14 11 (1.83%) PHP
15 7 (1.16%) MATLAB
15 7 (1.16%) Shell Script
15 7 (1.16%) VBScript
16 4 (0.67%) Google Apps Script
16 4 (0.67%) Korn
Qualifications
1 51 (8.49%) Degree
2 14 (2.33%) Security Cleared
3 12 (2.00%) Master's Degree
4 11 (1.83%) SC Cleared
5 10 (1.66%) Computer Science Degree
6 9 (1.50%) PMP
7 8 (1.33%) Numerate Degree
7 8 (1.33%) PMI Certification
8 7 (1.16%) Postgraduate
9 5 (0.83%) MOS
10 3 (0.50%) PRINCE2 Practitioner
11 2 (0.33%) BPSS Clearance
11 2 (0.33%) CFA
11 2 (0.33%) Microsoft Certification
11 2 (0.33%) PhD
12 1 (0.17%) A+ Certification
12 1 (0.17%) ACCA
12 1 (0.17%) CIMA
12 1 (0.17%) MCSA
12 1 (0.17%) Network+ Certification
Quality Assurance & Compliance
1 37 (6.16%) QA
2 19 (3.16%) Data Quality
3 9 (1.50%) Basel II
3 9 (1.50%) GDPR
4 8 (1.33%) MiFID
5 3 (0.50%) PMO
6 2 (0.33%) Disclosure Scotland
6 2 (0.33%) Dodd-Frank
6 2 (0.33%) EMIR
6 2 (0.33%) IFRS
7 1 (0.17%) FINREP
7 1 (0.17%) Sarbanes-Oxley
7 1 (0.17%) SLA
7 1 (0.17%) Solvency II
System Software
1 4 (0.67%) Docker
2 3 (0.50%) Cronacle
3 1 (0.17%) Active Directory
3 1 (0.17%) Hyper-V
3 1 (0.17%) VMware Infrastructure
3 1 (0.17%) VMware Workstation
Systems Management
1 7 (1.16%) Control-M
2 2 (0.33%) ITRS Geneos
3 1 (0.17%) SCCM
Vendors
1 96 (15.97%) Microsoft
2 94 (15.64%) Oracle
3 33 (5.49%) Tableau
4 23 (3.83%) Bloomberg
5 17 (2.83%) Reuters
6 10 (1.66%) Cognos
6 10 (1.66%) Google
7 9 (1.50%) Calypso
8 7 (1.16%) Blue Prism
8 7 (1.16%) Citrix
8 7 (1.16%) SAP
9 6 (1.00%) Charles River
9 6 (1.00%) Sybase
10 5 (0.83%) Adobe
11 4 (0.67%) Advent
11 4 (0.67%) Omniture
11 4 (0.67%) SimCorp
11 4 (0.67%) Sun
11 4 (0.67%) Yardi
12 3 (0.50%) Alteryx