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 average contractor rates offered in IT contracts that have cited VBA over the 3 months to 28 July 2015 with a comparison to the same period in 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.

Location
3 months to
28 Jul 2015
Same period 2014 Same period 2013
Microsoft Visual Basic for Applications (VBA)
Rank 79 102 73
Rank change year-on-year
+23 -29
Contract jobs citing VBA 146 103 204
As % of all contract IT jobs located in the City of London 2.46% 1.75% 2.87%
As % of the Programming Languages category 5.53% 4.13% 6.52%
Number of daily rates quoted 120 75 140
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£450 £450 £475
Average daily rate % change year-on-year
- -5.26%
90% offered a daily rate of more than £275 £244 £315
10% offered a daily rate of more than £625 £650 £600
UK excluding London average daily rate £325 £333 £310
% change year-on-year
-2.25% +7.25%
Number of hourly rates quoted 0 1 6
Average hourly rate - £14.50 £31.00
Average hourly rate % change year-on-year
- -53.22%
UK excluding London average hourly rate £19.00 £28.50 £25.75
% change year-on-year
-33.33% +10.67%
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
2638 2494 3130
As % of all contract IT jobs located in the City of London 44.46% 42.39% 44.05%
Number of daily rates quoted 2174 1931 2412
Average daily rate £475 £453 £450
Average daily rate % change year-on-year
+4.97% +0.55%
90% offered a daily rate of more than £325 £310 £300
10% offered a daily rate of more than £625 £625 £600
UK excluding London average daily rate £351 £350 £325
% change year-on-year
+0.14% +7.69%
Number of hourly rates quoted 18 14 33
Average hourly rate £23.75 £29.74 £41.50
Average hourly rate % change year-on-year
-20.14% -28.33%
90% offered a hourly rate of more than £18.37 £14.58 £22.50
10% offered a hourly rate of more than £99.00 £67.64 £52.50
UK excluding London average hourly rate £37.50 £35.00 £35.00
% change year-on-year
+7.14% -

VBA
Jobs Demand Trend in the City of London

This chart provides a 3-month moving total of IT contractor jobs citing VBA across the City of London region as a proportion of the total demand within 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 28 July 2015.

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 28 July 2015, IT contractor jobs across the City of London region citing VBA also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited VBA.

1 168 (65.12%) SQL
2 121 (46.90%) Finance
3 86 (33.33%) SQL Server
4 84 (32.56%) Banking
5 81 (31.40%) MS Excel
6 69 (26.74%) .NET
7 68 (26.36%) C#
8 49 (18.99%) Front Office
9 41 (15.89%) Microsoft
9 41 (15.89%) SQL Server Reporting Services
10 40 (15.50%) Oracle
11 37 (14.34%) Investment Banking
11 37 (14.34%) Agile Software Development
12 35 (13.57%) SQL Server 2008
13 34 (13.18%) ETL
14 33 (12.79%) MS Access
14 33 (12.79%) Data Warehouse
15 32 (12.40%) Fixed Income
16 30 (11.63%) T-SQL
17 29 (11.24%) RAD
17 29 (11.24%) Degree
18 28 (10.85%) Analytical Skills
19 26 (10.08%) SharePoint
19 26 (10.08%) Risk Management
20 25 (9.69%) Business Intelligence
21 22 (8.53%) Data Analysis
21 22 (8.53%) Derivative
21 22 (8.53%) Tableau
21 22 (8.53%) Analytics
22 21 (8.14%) Relational Database

VBA
Top Related IT Skills in the City of London by Category

For the 6 months to 28 July 2015, IT contractor jobs across the City of London region citing VBA also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited VBA. Up to 20 skills are shown per category.

Application Platforms
1 26 (10.08%) SharePoint
2 10 (3.88%) SAS
3 4 (1.55%) SharePoint 2010
4 2 (0.78%) IIS
5 1 (0.39%) SharePoint 2013
5 1 (0.39%) IPython
5 1 (0.39%) CMS
Applications
1 81 (31.40%) MS Excel
2 15 (5.81%) MS Office
3 11 (4.26%) MS PowerPoint
4 9 (3.49%) Spreadsheet
4 9 (3.49%) MS Visio
5 5 (1.94%) MS Project
6 1 (0.39%) SPSS
Business Applications
1 9 (3.49%) Hyperion Planning
2 4 (1.55%) CODA-Financials
3 3 (1.16%) Oracle General Ledger
3 3 (1.16%) Global One
3 3 (1.16%) Maximo
3 3 (1.16%) SAP FI
4 1 (0.39%) HFM
4 1 (0.39%) Cognos TM1
4 1 (0.39%) Dynamics NAV
4 1 (0.39%) Remedy ITSM
4 1 (0.39%) Endur
Cloud Services
1 1 (0.39%) Office 365
Database & Business Intelligence
1 86 (33.33%) SQL Server
2 41 (15.89%) SQL Server Reporting Services
3 35 (13.57%) SQL Server 2008
4 33 (12.79%) MS Access
4 33 (12.79%) Data Warehouse
5 21 (8.14%) Relational Database
6 20 (7.75%) SQL Server 2005
7 16 (6.20%) QlikView
8 15 (5.81%) SQL Server Integration Services
9 10 (3.88%) SQL Server Analysis Services
10 9 (3.49%) Hyperion Smart View
10 9 (3.49%) BusinessObjects
10 9 (3.49%) Essbase
10 9 (3.49%) Data Mining
10 9 (3.49%) SQL Server 2012
11 7 (2.71%) Microsoft Analysis Services
12 5 (1.94%) Crystal Reports
13 4 (1.55%) Spotfire
14 3 (1.16%) Oracle BI EE
14 3 (1.16%) Oracle Reports
Development Applications
1 7 (2.71%) Visual Studio
2 5 (1.94%) PowerBuilder
3 3 (1.16%) Subversion
4 2 (0.78%) JIRA
4 2 (0.78%) Selenium
4 2 (0.78%) Git (software)
4 2 (0.78%) SQL Server Management Studio (SSMS)
5 1 (0.39%) Zephyr
5 1 (0.39%) Visual Studio Tools for Office
5 1 (0.39%) JUnit
5 1 (0.39%) jMock
5 1 (0.39%) TestComplete
5 1 (0.39%) TeamCity
5 1 (0.39%) NUnit
5 1 (0.39%) HP UFT
General
1 121 (46.90%) Finance
2 84 (32.56%) Banking
3 49 (18.99%) Front Office
4 37 (14.34%) Investment Banking
5 8 (3.10%) Financial Institution
6 7 (2.71%) Telecoms
6 7 (2.71%) Retail
7 5 (1.94%) Corporate Banking
7 5 (1.94%) Back Office
8 4 (1.55%) Legal
8 4 (1.55%) Spanish Language
9 3 (1.16%) Turkish Language
9 3 (1.16%) General Ledger
9 3 (1.16%) Retail Banking
9 3 (1.16%) Advertising
10 1 (0.39%) Publishing
10 1 (0.39%) Marketing
Job Titles
1 130 (50.39%) Developer
2 101 (39.15%) Analyst
3 40 (15.50%) VBA Developer
4 26 (10.08%) Excel Developer
5 25 (9.69%) Data Analyst
6 20 (7.75%) Business Analyst
6 20 (7.75%) SQL Developer
7 18 (6.98%) C# Developer
7 18 (6.98%) Excel VBA Developer
8 14 (5.43%) Senior Analyst
8 14 (5.43%) Information Analyst
9 13 (5.04%) RAD Developer
10 12 (4.65%) Technical Analyst
10 12 (4.65%) Senior Developer
11 11 (4.26%) .NET Developer
11 11 (4.26%) NHS Information Analyst
12 9 (3.49%) Senior Information Analyst
12 9 (3.49%) Support Analyst
13 8 (3.10%) Project Manager
13 8 (3.10%) WPF Developer
Libraries, Frameworks & Software Standards
1 69 (26.74%) .NET
2 19 (7.36%) WPF
3 16 (6.20%) ASP.NET
4 11 (4.26%) XML
5 10 (3.88%) WinForms
6 9 (3.49%) WCF
7 8 (3.10%) HTML
8 6 (2.33%) CSS
9 5 (1.94%) Web Services
9 5 (1.94%) Task Parallel Library
10 4 (1.55%) ASP.NET Web Forms
10 4 (1.55%) DOM
10 4 (1.55%) .NET Framework
11 3 (1.16%) jQuery
12 2 (0.78%) ASP.NET Web API
12 2 (0.78%) REST
12 2 (0.78%) KnockoutJS
12 2 (0.78%) Silverlight
12 2 (0.78%) JSON
12 2 (0.78%) XSL
Miscellaneous
1 32 (12.40%) Fixed Income
2 28 (10.85%) Analytical Skills
3 22 (8.53%) Derivative
4 19 (7.36%) NHS
5 16 (6.20%) Mathematics
6 14 (5.43%) Market Risk
7 13 (5.04%) Foreign Exchange (FX)
8 12 (4.65%) Interest Rate Derivative
8 12 (4.65%) Data Extraction
9 10 (3.88%) Equity Derivative
9 10 (3.88%) Statistics
9 10 (3.88%) Equities
10 8 (3.10%) Credit Risk
11 6 (2.33%) Visualisation
12 5 (1.94%) Swaptions
12 5 (1.94%) Credit Derivative
13 4 (1.55%) Management Information System
13 4 (1.55%) Computer Science
14 3 (1.16%) Hedge funds
14 3 (1.16%) Enterprise Software
Operating Systems
1 12 (4.65%) Windows
2 10 (3.88%) UNIX
3 3 (1.16%) Linux
4 2 (0.78%) Windows 7
5 1 (0.39%) Apple iOS
5 1 (0.39%) Windows 8
5 1 (0.39%) Windows XP
5 1 (0.39%) Mac OS X
5 1 (0.39%) Windows Server 2008
Processes & Methodologies
1 37 (14.34%) Agile Software Development
2 34 (13.18%) ETL
3 29 (11.24%) RAD
4 26 (10.08%) Risk Management
5 25 (9.69%) Business Intelligence
6 22 (8.53%) Data Analysis
6 22 (8.53%) Analytics
7 18 (6.98%) Business Analysis
8 17 (6.59%) Data Management
9 16 (6.20%) Data Modelling
10 15 (5.81%) TDD
10 15 (5.81%) Stakeholder Management
11 14 (5.43%) Project Management
11 14 (5.43%) Asset Management
12 12 (4.65%) Migration
13 11 (4.26%) Scrum
14 10 (3.88%) OO
14 10 (3.88%) User Acceptance Testing
15 9 (3.49%) DRM
15 9 (3.49%) SDLC
Programming Languages
1 168 (65.12%) SQL
2 68 (26.36%) C#
3 30 (11.63%) T-SQL
4 20 (7.75%) Python
5 17 (6.59%) VB.NET
6 13 (5.04%) Java
7 9 (3.49%) C++
7 9 (3.49%) VB
8 7 (2.71%) PL/SQL
8 7 (2.71%) JavaScript
9 5 (1.94%) Perl
10 4 (1.55%) VBScript
10 4 (1.55%) MATLAB
11 3 (1.16%) PowerShell
11 3 (1.16%) Scala
11 3 (1.16%) R
12 2 (0.78%) Cython
12 2 (0.78%) PHP
12 2 (0.78%) C
13 1 (0.39%) UniBasic
Qualifications
1 29 (11.24%) Degree
2 3 (1.16%) Security Cleared
3 2 (0.78%) CTC Cleared
4 1 (0.39%) ISTQB Foundation Certification
4 1 (0.39%) SC Cleared
4 1 (0.39%) Microsoft Certification
4 1 (0.39%) PMI Certification
4 1 (0.39%) CFA
4 1 (0.39%) ISTQB
Quality Assurance & Compliance
1 10 (3.88%) QA
2 5 (1.94%) Solvency II
2 5 (1.94%) Data Quality
3 3 (1.16%) SLA
4 2 (0.78%) Basel II
5 1 (0.39%) CRD IV
5 1 (0.39%) COREP
System Software
1 4 (1.55%) Active Directory
2 1 (0.39%) Tivoli Workload Scheduler
Systems Management
1 2 (0.78%) Control-M
2 1 (0.39%) Nagios
2 1 (0.39%) HP Quality Center
2 1 (0.39%) ITRS Geneos
2 1 (0.39%) Tivoli
Vendors
1 41 (15.89%) Microsoft
2 40 (15.50%) Oracle
3 22 (8.53%) Tableau
4 11 (4.26%) Hyperion
5 5 (1.94%) SAP
5 5 (1.94%) Alteryx
5 5 (1.94%) WorldPay
6 4 (1.55%) CODA
6 4 (1.55%) Cognos
7 3 (1.16%) Sybase
7 3 (1.16%) Sun
7 3 (1.16%) Informatica
7 3 (1.16%) MicroStrategy
7 3 (1.16%) Reuters
7 3 (1.16%) Bloomberg
7 3 (1.16%) IBM
8 2 (0.78%) TIBCO
8 2 (0.78%) Syncfusion
8 2 (0.78%) DevExpress
8 2 (0.78%) SunGard
City, London
Networking People
Rate: £800 - £1000 per day + ++ Neg
Posted: 6 hours ago
City, London
Venturi
Rate: £250 - £300 per day + DOE
Posted: 6 days ago
City of London
Huxley Banking & Financial Services
Rate: £308 - £408 per day + competitive
Posted: 19 days ago
City of London
Orgtel
Rate: £550 - £575 per day
Posted: 22 days ago