Period
to 18 August 2019

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 18 August 2019 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
18 Aug 2019
Same period 2018 Same period 2017
Rank 305 287 225
Rank change year-on-year -18 -62 +21
Contract jobs citing VBA 321 405 507
As % of all contract IT jobs advertised in London 0.81% 0.88% 1.18%
As % of the Programming Languages category 1.71% 1.77% 2.46%
Number of daily rates quoted 230 278 349
London median daily rate £464 £475 £450
Median daily rate % change year-on-year -2.37% +5.56% +5.88%
10th Percentile £313 £323 £288
90th Percentile £653 £675 £638
England median daily rate £425 £425 £425
Number of hourly rates quoted 14 7 4
London median hourly rate £21.00 £18.09 £20.91
Median hourly rate % change year-on-year +16.12% -13.51% +25.55%
England median hourly rate £21.00 £18.09 £23.24
% change year-on-year +16.12% -22.19% +14.47%

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 18,727 22,935 20,626
As % of all contract IT jobs advertised in London 47.20% 50.00% 47.88%
Number of daily rates quoted 14,157 17,509 15,345
London median daily rate £525 £520 £500
Median daily rate % change year-on-year +0.96% +4.00% +11.11%
10th Percentile £363 £363 £331
90th Percentile £688 £675 £650
England median daily rate £475 £475 £450
% change year-on-year - +5.56% +5.88%
Number of hourly rates quoted 113 170 153
London median hourly rate £42.50 £39.00 £40.00
Median hourly rate % change year-on-year +8.97% -2.50% +46.71%
10th Percentile £20.43 £18.00 £17.30
90th Percentile £61.15 £62.63 £52.40
England median hourly rate £45.00 £42.00 £40.00
% change year-on-year +7.14% +5.00% +6.67%

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 18 August 2019.

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 18 August 2019.

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 18 August 2019. 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 -10 76 £513 +1.23% 13
South London +38 20 £400 +6.67%
West London +15 7 £360 +5.49% 4
East London +4 7 £425 -5.56% 2
VBA
England

For the 6 months to 18 August 2019, 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 238 (74.14%) Microsoft Excel
2 187 (58.26%) SQL
3 134 (41.74%) Finance
4 103 (32.09%) C#
5 95 (29.60%) SQL Server
6 82 (25.55%) .NET
6 82 (25.55%) Banking
7 77 (23.99%) Python
8 63 (19.63%) Microsoft
8 63 (19.63%) Agile Software Development
9 57 (17.76%) VB
10 54 (16.82%) Oracle
11 53 (16.51%) Business Intelligence
12 51 (15.89%) Front Office
13 49 (15.26%) Data Analysis
14 48 (14.95%) MS Access
15 46 (14.33%) Windows
16 43 (13.40%) T-SQL
17 41 (12.77%) VB.NET
18 40 (12.46%) Java
19 39 (12.15%) JavaScript
19 39 (12.15%) QA
20 34 (10.59%) Analytical Skills
20 34 (10.59%) WinForms
21 33 (10.28%) Data Warehouse
21 33 (10.28%) WPF
21 33 (10.28%) SDLC
22 32 (9.97%) C++
22 32 (9.97%) Microsoft Office
23 28 (8.72%) RAD

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 19 (5.92%) IIS
2 16 (4.98%) SharePoint
3 13 (4.05%) Confluence
4 5 (1.56%) SAS
5 4 (1.25%) Elasticsearch
5 4 (1.25%) JBoss
5 4 (1.25%) Jetty
5 4 (1.25%) Oracle Self-Service HR
5 4 (1.25%) SharePoint 2010
5 4 (1.25%) Tomcat
5 4 (1.25%) WebLogic
6 3 (0.93%) Apache Spark
7 2 (0.62%) Exchange Server 2003
7 2 (0.62%) MS Exchange
Applications
1 238 (74.14%) Microsoft Excel
2 32 (9.97%) Microsoft Office
3 13 (4.05%) Microsoft PowerPoint
4 11 (3.43%) Spreadsheet
5 5 (1.56%) MS Visio
6 3 (0.93%) SPSS
7 2 (0.62%) InfoPath
7 2 (0.62%) Microsoft Project
8 1 (0.31%) Stata
Business Applications
1 5 (1.56%) Misys Opics
2 3 (0.93%) Unit4 Business World
3 2 (0.62%) Dynamics AX
3 2 (0.62%) Infor SunSystems
3 2 (0.62%) SAP ERP
4 1 (0.31%) Cognos Business Intelligence
4 1 (0.31%) Cognos TM1
4 1 (0.31%) Oracle EBS
4 1 (0.31%) Oracle EBS R12
4 1 (0.31%) Oracle Subledger Accounting
4 1 (0.31%) SAP Oil and Gas
4 1 (0.31%) Sparx Enterprise Architect
Cloud Services
1 25 (7.79%) Power Platform
2 16 (4.98%) Microsoft Azure
3 11 (3.43%) Office 365
4 7 (2.18%) Amazon AWS
5 4 (1.25%) OpenShift
6 3 (0.93%) SuccessFactors
7 1 (0.31%) Cloud Computing
7 1 (0.31%) Dynamics 365
7 1 (0.31%) PowerApps
Communications & Networking
1 4 (1.25%) SSH
2 3 (0.93%) DNS
Database & Business Intelligence
1 95 (29.60%) SQL Server
2 48 (14.95%) MS Access
3 33 (10.28%) Data Warehouse
4 27 (8.41%) SQL Server Reporting Services
5 24 (7.48%) Power BI
6 23 (7.17%) Relational Database
7 21 (6.54%) SQL Server Integration Services
8 19 (5.92%) SQL Server 2014
9 17 (5.30%) Oracle Database
10 14 (4.36%) MySQL
11 12 (3.74%) SQL Server Analysis Services
12 10 (3.12%) Oracle Reports
13 9 (2.80%) SQL Server 2008
14 7 (2.18%) Hadoop
15 6 (1.87%) BusinessObjects
15 6 (1.87%) QlikView
15 6 (1.87%) SQL Server 2012
16 5 (1.56%) Microsoft Analysis Services
16 5 (1.56%) Oracle Database 10g
16 5 (1.56%) SQL Server 2005
Development Applications
1 22 (6.85%) Git (software)
2 19 (5.92%) JIRA
3 18 (5.61%) Oracle Forms
4 15 (4.67%) Jenkins
5 9 (2.80%) Subversion
5 9 (2.80%) Team Foundation Server
6 8 (2.49%) Maven
7 7 (2.18%) Selenium
8 6 (1.87%) Cucumber
9 4 (1.25%) Atlassian Bamboo
9 4 (1.25%) Bitbucket
9 4 (1.25%) ClearCase
9 4 (1.25%) Eclipse
9 4 (1.25%) FishEye
9 4 (1.25%) Gradle
9 4 (1.25%) Hudson
9 4 (1.25%) Mercurial
9 4 (1.25%) Poseidon for UML
9 4 (1.25%) TeamCity
9 4 (1.25%) Vagrant
General
1 134 (41.74%) Finance
2 82 (25.55%) Banking
3 51 (15.89%) Front Office
4 23 (7.17%) Investment Banking
5 14 (4.36%) Public Sector
6 11 (3.43%) Financial Institution
7 10 (3.12%) Retail
8 7 (2.18%) Back Office
9 6 (1.87%) Law
9 6 (1.87%) Legal
9 6 (1.87%) Manufacturing
10 4 (1.25%) Advertising
10 4 (1.25%) Retail Banking
11 3 (0.93%) Local Government
11 3 (0.93%) Marketing
11 3 (0.93%) Private Banking
12 2 (0.62%) Pharmaceutical
13 1 (0.31%) Billing
13 1 (0.31%) Electronics
13 1 (0.31%) Publishing
Job Titles
1 184 (57.32%) Developer
2 62 (19.31%) C# Developer
3 57 (17.76%) VBA Developer
4 51 (15.89%) .NET Developer
5 50 (15.58%) Analyst
6 47 (14.64%) SQL Developer
7 41 (12.77%) C# .NET Developer
8 22 (6.85%) Excel Developer
9 21 (6.54%) Data Analyst
10 20 (6.23%) Excel VBA Developer
11 19 (5.92%) RAD Developer
11 19 (5.92%) WinForms Developer
12 17 (5.30%) Python Developer
13 15 (4.67%) SQL Analyst
14 13 (4.05%) Front Office Developer
15 12 (3.74%) Access Developer
15 12 (3.74%) C++ Developer
15 12 (3.74%) Consultant
16 11 (3.43%) Business Analyst
17 10 (3.12%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 82 (25.55%) .NET
2 34 (10.59%) WinForms
3 33 (10.28%) WPF
4 22 (6.85%) ASP.NET
5 20 (6.23%) .NET Framework
6 19 (5.92%) HTML
7 18 (5.61%) JSON
8 13 (4.05%) XML
9 12 (3.74%) HTML5
9 12 (3.74%) Web Services
10 11 (3.43%) AngularJS
11 10 (3.12%) RESTful
12 9 (2.80%) Spring
12 9 (2.80%) WCF
13 7 (2.18%) CSS
13 7 (2.18%) React
14 6 (1.87%) EDIFACT
15 5 (1.56%) jQuery
15 5 (1.56%) Node.js
15 5 (1.56%) Sass
Miscellaneous
1 34 (10.59%) Analytical Skills
2 16 (4.98%) Derivative
2 16 (4.98%) Self-Motivation
3 14 (4.36%) Data Protection Act
4 12 (3.74%) Market Risk
5 10 (3.12%) User Experience
6 8 (2.49%) Fixed Income
7 6 (1.87%) Equities
7 6 (1.87%) Foreign Exchange (FX)
7 6 (1.87%) Robotics
8 5 (1.56%) Data Structures
8 5 (1.56%) Equity Derivative
8 5 (1.56%) Management Information System
9 4 (1.25%) Enterprise Software
9 4 (1.25%) Greenfield Project
10 3 (0.93%) FMCG
11 2 (0.62%) Credit Risk
12 1 (0.31%) Life Science
12 1 (0.31%) Public Cloud
12 1 (0.31%) Reference Data
Operating Systems
1 46 (14.33%) Windows
2 23 (7.17%) Windows 10
3 14 (4.36%) Windows 7
4 12 (3.74%) Windows Server
5 10 (3.12%) Linux
6 4 (1.25%) Android
6 4 (1.25%) Apple iOS
6 4 (1.25%) CentOS
6 4 (1.25%) Debian
6 4 (1.25%) Mac OS X
6 4 (1.25%) Red Hat Enterprise Linux
6 4 (1.25%) Ubuntu
7 2 (0.62%) Unix
7 2 (0.62%) Windows Server 2003
Processes & Methodologies
1 63 (19.63%) Agile Software Development
2 53 (16.51%) Business Intelligence
3 49 (15.26%) Data Analysis
4 33 (10.28%) SDLC
5 28 (8.72%) Analytics
5 28 (8.72%) Migration
5 28 (8.72%) RAD
6 26 (8.10%) ETL
7 23 (7.17%) Scrum
8 22 (6.85%) Problem-Solving
8 22 (6.85%) Test Automation
9 21 (6.54%) Software Engineering
10 20 (6.23%) Risk Management
11 19 (5.92%) Asset Management
12 18 (5.61%) DevOps
13 17 (5.30%) OO
14 15 (4.67%) Mathematics
14 15 (4.67%) TDD
15 14 (4.36%) Data Protection
15 14 (4.36%) Project Management
Programming Languages
1 187 (58.26%) SQL
2 103 (32.09%) C#
3 77 (23.99%) Python
4 57 (17.76%) VB
5 43 (13.40%) T-SQL
6 41 (12.77%) VB.NET
7 40 (12.46%) Java
8 39 (12.15%) JavaScript
9 32 (9.97%) C++
10 24 (7.48%) PL/SQL
11 21 (6.54%) R
12 20 (6.23%) PowerShell
13 10 (3.12%) MATLAB
14 8 (2.49%) Java 8
14 8 (2.49%) VBScript
15 6 (1.87%) Bash Shell
15 6 (1.87%) Clojure
16 5 (1.56%) Perl
17 4 (1.25%) ClojureScript
17 4 (1.25%) Ruby
Qualifications
1 21 (6.54%) Degree
2 20 (6.23%) Security Cleared
3 17 (5.30%) SC Cleared
4 2 (0.62%) DV Cleared
5 1 (0.31%) ACCA
5 1 (0.31%) BPSS Clearance
5 1 (0.31%) CIMA
5 1 (0.31%) CISA
5 1 (0.31%) Master's Degree
5 1 (0.31%) PhD
5 1 (0.31%) PMI Certification
5 1 (0.31%) PMP
Quality Assurance & Compliance
1 39 (12.15%) QA
2 8 (2.49%) Data Quality
3 5 (1.56%) MiFID
3 5 (1.56%) SLA
4 4 (1.25%) IFRS
5 2 (0.62%) GDPR
5 2 (0.62%) IFRS 9
5 2 (0.62%) PMO
6 1 (0.31%) CRD IV
6 1 (0.31%) ITGC
6 1 (0.31%) Sarbanes-Oxley
System Software
1 9 (2.80%) Active Directory
2 1 (0.31%) Cronacle
2 1 (0.31%) Virtual Desktop
Systems Management
1 10 (3.12%) SCCM
2 4 (1.25%) Kubernetes
2 4 (1.25%) Puppet
2 4 (1.25%) Salt
3 1 (0.31%) Graylog
Vendors
1 63 (19.63%) Microsoft
2 54 (16.82%) Oracle
3 22 (6.85%) Tableau
4 19 (5.92%) Citrix
5 8 (2.49%) HP
5 8 (2.49%) SAP
6 7 (2.18%) Blue Prism
7 6 (1.87%) Sun
7 6 (1.87%) UiPath
8 5 (1.56%) Infor
8 5 (1.56%) Misys
8 5 (1.56%) Sybase
8 5 (1.56%) Trayport
9 4 (1.25%) Cloudera
9 4 (1.25%) Dell
9 4 (1.25%) Hortonworks
9 4 (1.25%) Red Hat
10 3 (0.93%) Atlassian
10 3 (0.93%) Bloomberg
10 3 (0.93%) Reuters