The table below looks at the statistics for VBA skills in IT contracts advertised for the City of London region. Included is a guide to the contractor rates offered in IT contracts that have cited VBA over the 3 months to 29 September 2016 with a comparison to the same period over the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

3 months to
29 Sep 2016
Same period 2015 Same period 2014
Microsoft Visual Basic for Applications (VBA)
Rank 132 91 128
Rank change year-on-year
-41 +37
Contract jobs citing VBA 41 102 88
As % of all contract IT jobs located in the City of London 1.20% 2.20% 1.49%
As % of the Programming Languages category 2.40% 4.63% 3.48%
Number of daily rates quoted 30 82 65
Median daily rate £425 £454 £475
Median daily rate % change year-on-year
-6.33% -4.47%
90% offered a daily rate of more than £325 £275 £300
10% offered a daily rate of more than £528 £665 £550
UK excluding London median daily rate £330 £326 £325
% change year-on-year
+1.22% +0.30%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £16.00 £40.00 £20.50
% change year-on-year
-60.00% +95.12%
VBA
London

The following table is for comparison with the above and provides statistics for the entire Programming Languages category in contract jobs advertised in the City of London region.

Programming Languages Category
City of London
Contract IT job ads with a match in the
Programming Languages category
1708 2205 2530
As % of all contract IT jobs located in the City of London 49.93% 47.50% 42.87%
Number of daily rates quoted 1441 1841 1983
Median daily rate £475 £475 £450
Median daily rate % change year-on-year
- +5.55%
90% offered a daily rate of more than £350 £325 £300
10% offered a daily rate of more than £625 £625 £600
UK excluding London median daily rate £375 £375 £350
% change year-on-year
- +7.14%
Number of hourly rates quoted 10 11 9
Median hourly rate £27.50 £35.00 £45.00
Median hourly rate % change year-on-year
-21.42% -22.22%
90% offered a hourly rate of more than £17.25 £23.75 £15.95
10% offered a hourly rate of more than £54.25 £37.50 £129.00
UK excluding London median hourly rate £41.25 £39.00 £35.00
% change year-on-year
+5.76% +11.42%

VBA
Jobs Demand Trend in the City of London

The demand trend of contract jobs across the City of London region citing VBA as a proportion of all IT contracts with a match in the Programming Languages category.

VBA Jobs Demand Trend in the City of London

VBA
Daily Rate Trend in the City of London

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

VBA Daily Rate Trend in the City of London

VBA
Daily Rate Histogram in the City of London

This chart provides a histogram of daily rates quoted in contract IT jobs citing VBA across the City of London region over the 3 months to 29 September 2016.

VBA Daily Rate Histogram in the City of London

VBA
Hourly Rate Trend in the City of London

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

VBA Hourly Rate Trend in the City of London

VBA
Top 30 Related IT Skills in the City of London

For the 6 months to 29 September 2016, 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 City of London region with a requirement for VBA.

1 57 (67.06%) SQL
2 43 (50.59%) Finance
3 33 (38.82%) Banking
4 31 (36.47%) MS Excel
5 28 (32.94%) SQL Server
6 26 (30.59%) C#
7 23 (27.06%) .NET
8 20 (23.53%) Oracle
9 18 (21.18%) Microsoft
10 17 (20.00%) VB
11 16 (18.82%) Front Office
12 13 (15.29%) MS Access
12 13 (15.29%) Investment Banking
13 12 (14.12%) SQL Server Integration Services
13 12 (14.12%) .NET Framework
13 12 (14.12%) SQL Server 2008
13 12 (14.12%) T-SQL
14 11 (12.94%) Analytical Skills
15 10 (11.76%) Java
15 10 (11.76%) Python
16 9 (10.59%) WinForms
16 9 (10.59%) Analytics
17 8 (9.41%) SQL Server Reporting Services
17 8 (9.41%) Data Analysis
17 8 (9.41%) Fixed Income
17 8 (9.41%) Business Intelligence
17 8 (9.41%) C
18 7 (8.24%) VB.NET
18 7 (8.24%) MS Office
18 7 (8.24%) Agile Software Development

VBA
Top Related 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 5 (5.88%) SAS
2 4 (4.71%) Apache
2 4 (4.71%) SharePoint
2 4 (4.71%) WebLogic
3 1 (1.18%) CMS
3 1 (1.18%) IBM Domino
3 1 (1.18%) IBM Notes
3 1 (1.18%) SharePoint 2013
Applications
1 31 (36.47%) MS Excel
2 7 (8.24%) MS Office
3 5 (5.88%) Spreadsheet
4 2 (2.35%) MS PowerPoint
4 2 (2.35%) MS Visio
5 1 (1.18%) MS Project
Business Applications
1 3 (3.53%) Infor SunSystems
2 1 (1.18%) Dynamics CRM
2 1 (1.18%) Sophis RISQUE
Cloud Services
1 2 (2.35%) Google Analytics
2 1 (1.18%) SaaS
2 1 (1.18%) SuccessFactors
Communications & Networking
1 1 (1.18%) LAN
1 1 (1.18%) Skype
1 1 (1.18%) TCP/IP
Database & Business Intelligence
1 28 (32.94%) SQL Server
2 13 (15.29%) MS Access
3 12 (14.12%) SQL Server 2008
3 12 (14.12%) SQL Server Integration Services
4 8 (9.41%) SQL Server Reporting Services
5 7 (8.24%) Oracle Database
6 6 (7.06%) Oracle Database 11g
7 5 (5.88%) QlikView
8 4 (4.71%) BusinessObjects
9 3 (3.53%) PostgreSQL
9 3 (3.53%) Relational Database
10 2 (2.35%) Big Data
10 2 (2.35%) Data Warehouse
10 2 (2.35%) MySQL
10 2 (2.35%) Power BI
10 2 (2.35%) SQL Server 2005
10 2 (2.35%) SQL Server Analysis Services
10 2 (2.35%) Sybase ASE
11 1 (1.18%) Data Mining
11 1 (1.18%) Oracle Database 10g
Development Applications
1 5 (5.88%) JIRA
2 4 (4.71%) Atlassian Bamboo
2 4 (4.71%) ClearCase
3 2 (2.35%) SQL Server Management Studio (SSMS)
3 2 (2.35%) Team Foundation Server
4 1 (1.18%) Subversion
4 1 (1.18%) Visual Studio
4 1 (1.18%) Visual Studio Tools for Office
General
1 43 (50.59%) Finance
2 33 (38.82%) Banking
3 16 (18.82%) Front Office
4 13 (15.29%) Investment Banking
5 4 (4.71%) Legal
5 4 (4.71%) Marketing
6 3 (3.53%) Billing
7 1 (1.18%) Financial Institution
7 1 (1.18%) Games
7 1 (1.18%) Retail
Job Titles
1 43 (50.59%) Developer
2 31 (36.47%) Analyst
3 21 (24.71%) VBA Developer
4 17 (20.00%) C# Developer
5 12 (14.12%) SQL Developer
6 11 (12.94%) Excel Developer
7 10 (11.76%) .NET Developer
7 10 (11.76%) C# .NET Developer
8 9 (10.59%) Excel VBA Developer
9 8 (9.41%) Access Developer
9 8 (9.41%) Senior Developer
10 7 (8.24%) Applications Support
11 6 (7.06%) Access VBA Developer
11 6 (7.06%) Data Analyst
11 6 (7.06%) Front Office Developer
11 6 (7.06%) SQL Analyst
12 5 (5.88%) Senior C# Developer
12 5 (5.88%) Senior VBA Developer
12 5 (5.88%) SSIS Developer
12 5 (5.88%) Support Analyst
Libraries, Frameworks & Software Standards
1 23 (27.06%) .NET
2 12 (14.12%) .NET Framework
3 9 (10.59%) WinForms
4 4 (4.71%) AngularJS
4 4 (4.71%) ASP.NET
4 4 (4.71%) Django
4 4 (4.71%) Spring
4 4 (4.71%) Velocity
5 3 (3.53%) WPF
6 2 (2.35%) Classic ASP
6 2 (2.35%) jQuery
6 2 (2.35%) XML
7 1 (1.18%) ActiveX
7 1 (1.18%) FIX Protocol
7 1 (1.18%) HTML
7 1 (1.18%) HTML5
7 1 (1.18%) Node.js
7 1 (1.18%) ODBC
7 1 (1.18%) Twitter Bootstrap
7 1 (1.18%) XML Schema
Miscellaneous
1 11 (12.94%) Analytical Skills
2 8 (9.41%) Fixed Income
3 7 (8.24%) Mathematics
4 6 (7.06%) Derivative
5 3 (3.53%) Management Information System
6 2 (2.35%) Data Integration
6 2 (2.35%) Foreign Exchange (FX)
6 2 (2.35%) Visualisation
7 1 (1.18%) Algorithms
7 1 (1.18%) Credit Derivative
7 1 (1.18%) Credit Risk
7 1 (1.18%) Data Extraction
7 1 (1.18%) Equities
7 1 (1.18%) Equity Derivative
7 1 (1.18%) FMCG
7 1 (1.18%) Hedge funds
7 1 (1.18%) NHS
7 1 (1.18%) Reference Data
7 1 (1.18%) User Experience
7 1 (1.18%) Wiki
Operating Systems
1 5 (5.88%) Unix
1 5 (5.88%) Windows
2 3 (3.53%) Windows Server
2 3 (3.53%) Windows Server 2012
3 2 (2.35%) Linux
3 2 (2.35%) Red Hat Enterprise Linux
3 2 (2.35%) Windows 2000
3 2 (2.35%) Windows 8
3 2 (2.35%) Windows Server 2008
3 2 (2.35%) Windows Vista
3 2 (2.35%) Windows XP
4 1 (1.18%) VMS
4 1 (1.18%) Windows 7
4 1 (1.18%) Windows Server 2003
Processes & Methodologies
1 9 (10.59%) Analytics
2 8 (9.41%) Business Intelligence
2 8 (9.41%) Data Analysis
3 7 (8.24%) Agile Software Development
3 7 (8.24%) Asset Management
4 6 (7.06%) ETL
4 6 (7.06%) Risk Management
5 5 (5.88%) OO
5 5 (5.88%) Portfolio Management
6 4 (4.71%) Data Management
6 4 (4.71%) Database Tuning
6 4 (4.71%) Migration
6 4 (4.71%) OOP
7 3 (3.53%) Customer Insight
7 3 (3.53%) Data Analytics
7 3 (3.53%) Data Modelling
7 3 (3.53%) Stakeholder Management
7 3 (3.53%) Time Management
7 3 (3.53%) Unit Testing
7 3 (3.53%) User Acceptance Testing
Programming Languages
1 57 (67.06%) SQL
2 26 (30.59%) C#
3 17 (20.00%) VB
4 12 (14.12%) T-SQL
5 10 (11.76%) Java
5 10 (11.76%) Python
6 8 (9.41%) C
7 7 (8.24%) VB.NET
8 6 (7.06%) C++
8 6 (7.06%) PL/SQL
9 5 (5.88%) PowerShell
10 4 (4.71%) Shell Script
11 3 (3.53%) R
12 2 (2.35%) Delphi
12 2 (2.35%) JavaScript
12 2 (2.35%) Pascal
12 2 (2.35%) Perl
12 2 (2.35%) VB6
13 1 (1.18%) Korn
13 1 (1.18%) VBScript
Qualifications
1 5 (5.88%) Degree
2 3 (3.53%) AAT
2 3 (3.53%) ACCA
2 3 (3.53%) CIMA
3 2 (2.35%) Microsoft Certification
4 1 (1.18%) A+ Certification
4 1 (1.18%) MOS
4 1 (1.18%) Network+ Certification
4 1 (1.18%) PMI Certification
4 1 (1.18%) PMP
Quality Assurance & Compliance
1 5 (5.88%) Solvency II
2 2 (2.35%) QA
3 1 (1.18%) Disclosure Scotland
System Software
1 1 (1.18%) Active Directory
Systems Management
1 5 (5.88%) Control-M
2 4 (4.71%) BladeLogic
Vendors
1 20 (23.53%) Oracle
2 18 (21.18%) Microsoft
3 4 (4.71%) Atlassian
3 4 (4.71%) Remedy
4 3 (3.53%) Bloomberg
4 3 (3.53%) Infor
4 3 (3.53%) Sybase
4 3 (3.53%) Tableau
5 2 (2.35%) Google
5 2 (2.35%) HP
5 2 (2.35%) Red Hat
5 2 (2.35%) SAP
6 1 (1.18%) BMC
6 1 (1.18%) Charles River
6 1 (1.18%) Citrix
6 1 (1.18%) Dell
6 1 (1.18%) Informatica
6 1 (1.18%) Lotus
6 1 (1.18%) Sophis
6 1 (1.18%) Teradata
City, London
onezeero.
Rate: £400 - £500 per day + benefits
Posted: Yesterday