Period
to 24 November 2017

The following table provides summary statistics for contract job vacancies advertised in England 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 24 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)
UK > England
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 295 320 233
Rank change year-on-year +25 -87 -28
Contract jobs citing VBA 818 722 1096
As % of all contract IT jobs advertised in England 0.86% 0.74% 1.05%
As % of the Programming Languages category 2.05% 1.83% 2.70%
Number of daily rates quoted 562 510 775
England median daily rate £450 £380 £400
Median daily rate % change year-on-year +18.42% -5.00% +2.56%
10th Percentile £275 £213 £219
90th Percentile £675 £575 £602
UK median daily rate £450 £375 £400
% change year-on-year +20.00% -6.25% +6.67%
Number of hourly rates quoted 17 23 28
England median hourly rate £24.49 £16.66 £22.00
Median hourly rate % change year-on-year +47.01% -24.30% -2.22%
10th Percentile £17.30 £11.08 £14.76
90th Percentile £49.75 £23.75 £41.47
UK median hourly rate £24.49 £16.66 £22.50
% change year-on-year +47.01% -25.98% -

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 England with a requirement for coding skills.

All Programming Languages
England
Contract vacancies with a requirement for coding skills 39942 39529 40557
As % of all contract IT jobs advertised in England 42.13% 40.53% 38.75%
Number of daily rates quoted 28155 27378 27763
England median daily rate £463 £425 £413
Median daily rate % change year-on-year +8.82% +3.03% +3.13%
10th Percentile £310 £288 £275
90th Percentile £638 £594 £600
UK median daily rate £450 £425 £400
% change year-on-year +5.88% +6.25% -
Number of hourly rates quoted 747 822 957
England median hourly rate £40.00 £37.50 £37.45
Median hourly rate % change year-on-year +6.67% +0.13% +21.79%
10th Percentile £16.25 £14.56 £14.13
90th Percentile £52.50 £51.25 £50.00
UK median hourly rate £40.00 £37.50 £37.45
% change year-on-year +6.67% +0.13% +20.81%

VBA
Job Vacancy Trend in England

Job postings citing VBA as a percentage of all IT jobs advertised in England.

Job vacancy trend for VBA in England

VBA
Contractor Daily Rate Trend in England

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing VBA in England.

Contractor daily rate trend for VBA in England

VBA
Contractor Daily Rate Histogram in England

The daily rate distribution of IT jobs citing VBA in England over the 6 months to 24 November 2017.

Contractor daily rate histogram for VBA in England

VBA
Contractor Hourly Rate Trend in England

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing VBA in England.

Contractor hourly rate trend for VBA in England

VBA
Contractor Hourly Rate Histogram in England

The hourly rate distribution of IT jobs citing VBA in England over the 6 months to 24 November 2017.

Contractor hourly rate histogram for VBA in England

VBA
Contract Job Locations in England

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing VBA within the England region over the 6 months to 24 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
London +53 602 £500 +21.95% 48
South East -35 65 £313 -16.67% 8
South West +19 59 £375 -6.25% 1
North of England +31 41 £375 +2.74% 22
Midlands +26 39 £333 -21.76% 4
North West +42 28 £375 +15.38% 14
West Midlands +34 28 £325 -16.67% 3
East of England -30 14 £270 -10.00% 7
East Midlands -19 11 £345 -18.82% 1
North East +64 7 £325 -35.64% 1
Yorkshire -14 6 £320 -10.49% 7
VBA
UK

For the 6 months to 24 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 England region with a requirement for VBA.

1 575 (70.29%) Microsoft Excel
2 415 (50.73%) SQL
3 347 (42.42%) Finance
4 267 (32.64%) SQL Server
5 254 (31.05%) Banking
6 210 (25.67%) C#
7 192 (23.47%) Front Office
8 173 (21.15%) .NET
9 167 (20.42%) Microsoft
10 153 (18.70%) Python
11 127 (15.53%) Agile Software Development
12 125 (15.28%) Oracle
13 123 (15.04%) Analytical Skills
14 110 (13.45%) Java
15 103 (12.59%) Data Analysis
16 97 (11.86%) Derivative
16 97 (11.86%) Business Intelligence
17 96 (11.74%) Analytics
18 89 (10.88%) Investment Banking
19 88 (10.76%) C++
20 86 (10.51%) MS Access
21 75 (9.17%) Fixed Income
22 74 (9.05%) VB
23 72 (8.80%) Degree
24 71 (8.68%) RAD
24 71 (8.68%) Risk Management
24 71 (8.68%) SDLC
25 65 (7.95%) Spreadsheet
26 64 (7.82%) Asset Management
26 64 (7.82%) SQL Server Integration Services

VBA
Co-occurring IT Skills in England 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 47 (5.75%) SAS
2 35 (4.28%) SharePoint
3 10 (1.22%) CMS
3 10 (1.22%) Confluence
4 6 (0.73%) IIS
5 5 (0.61%) Apache Spark
5 5 (0.61%) Oracle Workflow
6 4 (0.49%) Apache
6 4 (0.49%) Documentum
6 4 (0.49%) SharePoint 2010
7 2 (0.24%) BizTalk Server
7 2 (0.24%) MQSeries
7 2 (0.24%) ThingWorx
7 2 (0.24%) WebSphere
8 1 (0.12%) EPiServer
8 1 (0.12%) Kentico
8 1 (0.12%) OpenEdge
8 1 (0.12%) SharePoint 2013
8 1 (0.12%) Skype for Business
8 1 (0.12%) Umbraco
Applications
1 575 (70.29%) Microsoft Excel
2 65 (7.95%) Spreadsheet
3 61 (7.46%) Microsoft Office
4 47 (5.75%) Microsoft PowerPoint
5 15 (1.83%) MS Visio
6 12 (1.47%) Microsoft Project
7 7 (0.86%) InfoPath
8 1 (0.12%) Doxygen
8 1 (0.12%) SPSS
Business Applications
1 5 (0.61%) Cognos TM1
1 5 (0.61%) Dynamics CRM
2 4 (0.49%) Maximo
2 4 (0.49%) RMDS
3 3 (0.37%) Global One
3 3 (0.37%) Oracle Financials
4 2 (0.24%) Cognos Business Intelligence
4 2 (0.24%) Dynamics AX
4 2 (0.24%) Orchestrade
4 2 (0.24%) SAP ERP
4 2 (0.24%) Summit
5 1 (0.12%) Dynamics GP
5 1 (0.12%) FINCAD Analytics
5 1 (0.12%) FRx
5 1 (0.12%) HFM
5 1 (0.12%) Hyperion Planning
5 1 (0.12%) ION MarketView
5 1 (0.12%) Oracle General Ledger
5 1 (0.12%) SAP FI-GL
5 1 (0.12%) SimCorp Dimension
Cloud Services
1 8 (0.98%) G Suite
2 7 (0.86%) Amazon AWS
2 7 (0.86%) Microsoft Azure
3 5 (0.61%) Google Cloud Platform
4 4 (0.49%) Adobe Analytics
4 4 (0.49%) Google Analytics
4 4 (0.49%) Slack
5 3 (0.37%) Office 365
6 2 (0.24%) Azure Data Factory
7 1 (0.12%) AdWords
7 1 (0.12%) Google Tag Manager
Communications & Networking
1 7 (0.86%) SMS
2 6 (0.73%) LAN
2 6 (0.73%) WAN
3 5 (0.61%) Firewall
4 4 (0.49%) Internet
5 3 (0.37%) DNS
5 3 (0.37%) Radio Access Network
6 2 (0.24%) 3G
6 2 (0.24%) 4G
6 2 (0.24%) Intranet
6 2 (0.24%) LDAP
6 2 (0.24%) SAN
7 1 (0.12%) 2G
7 1 (0.12%) 3GPP
7 1 (0.12%) 5G
7 1 (0.12%) DMZ
7 1 (0.12%) Skype
7 1 (0.12%) VLAN
7 1 (0.12%) VPN
Database & Business Intelligence
1 267 (32.64%) SQL Server
2 86 (10.51%) MS Access
3 64 (7.82%) SQL Server Integration Services
4 55 (6.72%) Relational Database
5 42 (5.13%) Power BI
6 39 (4.77%) SQL Server Reporting Services
7 35 (4.28%) RDBMS
8 33 (4.03%) Data Warehouse
9 30 (3.67%) Oracle Database
10 22 (2.69%) SQL Server 2008
11 21 (2.57%) BusinessObjects
12 19 (2.32%) Oracle Database 11g
12 19 (2.32%) QlikView
13 18 (2.20%) Big Data
13 18 (2.20%) SAS EBI
14 17 (2.08%) SQL Server Analysis Services
15 11 (1.34%) PowerPivot
16 10 (1.22%) PostgreSQL
16 10 (1.22%) SQL Server 2012
16 10 (1.22%) SQL Server 2014
Development Applications
1 24 (2.93%) JIRA
2 21 (2.57%) Cucumber
2 21 (2.57%) Visual Studio
3 20 (2.44%) Selenium
3 20 (2.44%) Team Foundation Server
4 17 (2.08%) SpecFlow
4 17 (2.08%) Subversion
5 11 (1.34%) Jenkins
6 7 (0.86%) Git (software)
7 5 (0.61%) JMeter
7 5 (0.61%) SQL Server Management Studio (SSMS)
8 4 (0.49%) ClearCase
8 4 (0.49%) Jasmine
8 4 (0.49%) JUnit
8 4 (0.49%) TeamCity
9 3 (0.37%) Ant
9 3 (0.37%) Atlassian Bamboo
9 3 (0.37%) Maven
9 3 (0.37%) NUnit
9 3 (0.37%) Toad
General
1 347 (42.42%) Finance
2 254 (31.05%) Banking
3 192 (23.47%) Front Office
4 89 (10.88%) Investment Banking
5 18 (2.20%) Retail
6 16 (1.96%) Financial Institution
6 16 (1.96%) Marketing
7 13 (1.59%) Back Office
8 12 (1.47%) Legal
8 12 (1.47%) Manufacturing
9 8 (0.98%) Automotive
9 8 (0.98%) Telecoms
10 7 (0.86%) French Language
11 6 (0.73%) Local Government
11 6 (0.73%) Pharmaceutical
11 6 (0.73%) Retail Banking
12 4 (0.49%) Japanese Language
13 3 (0.37%) Billing
13 3 (0.37%) Corporate Banking
13 3 (0.37%) General Ledger
Job Titles
1 423 (51.71%) Developer
2 280 (34.23%) Analyst
3 142 (17.36%) VBA Developer
4 92 (11.25%) Data Analyst
5 73 (8.92%) C# Developer
5 73 (8.92%) Excel Developer
6 67 (8.19%) SQL Developer
7 66 (8.07%) .NET Developer
8 64 (7.82%) Excel VBA Developer
9 61 (7.46%) Business Analyst
10 60 (7.33%) Python Developer
11 58 (7.09%) RAD Developer
12 54 (6.60%) Front Office Developer
13 47 (5.75%) SQL Analyst
14 42 (5.13%) C# .NET Developer
15 35 (4.28%) Access Developer
16 34 (4.16%) Analyst Developer
17 32 (3.91%) Senior Developer
18 27 (3.30%) Banking Analyst
18 27 (3.30%) Risk Analyst
Libraries, Frameworks & Software Standards
1 173 (21.15%) .NET
2 55 (6.72%) .NET Framework
3 46 (5.62%) HTML
4 37 (4.52%) XML
5 26 (3.18%) CSS
6 23 (2.81%) Web Services
6 23 (2.81%) WinForms
7 21 (2.57%) ASP.NET
8 15 (1.83%) Entity Framework
9 14 (1.71%) WPF
10 11 (1.34%) REST
11 10 (1.22%) HTML5
11 10 (1.22%) XML Messaging
12 9 (1.10%) WCF
13 8 (0.98%) ActiveX
13 8 (0.98%) jQuery
14 7 (0.86%) MDX
15 6 (0.73%) Middleware
16 5 (0.61%) ASP.NET MVC
16 5 (0.61%) Node.js
Miscellaneous
1 123 (15.04%) Analytical Skills
2 97 (11.86%) Derivative
3 75 (9.17%) Fixed Income
4 61 (7.46%) Foreign Exchange (FX)
5 37 (4.52%) Equities
6 36 (4.40%) Credit Risk
7 34 (4.16%) Computer Science
8 33 (4.03%) Management Information System
9 27 (3.30%) Market Risk
10 15 (1.83%) Equity Derivative
11 8 (0.98%) NHS
12 7 (0.86%) Data Structures
12 7 (0.86%) Hedge funds
12 7 (0.86%) Virtual Team
13 6 (0.73%) Interest Rate Derivative
14 5 (0.61%) Robotics
14 5 (0.61%) User Experience
15 4 (0.49%) Algorithms
15 4 (0.49%) Credit Derivative
15 4 (0.49%) Reference Data
Operating Systems
1 50 (6.11%) Windows
2 31 (3.79%) Unix
3 19 (2.32%) Linux
4 4 (0.49%) Red Hat Enterprise Linux
4 4 (0.49%) Windows Server
5 3 (0.37%) Android
5 3 (0.37%) Apple iOS
5 3 (0.37%) Windows Server 2008
5 3 (0.37%) Windows Server 2012
6 2 (0.24%) Windows 10
6 2 (0.24%) Windows 7
7 1 (0.12%) Windows 2000 Server
7 1 (0.12%) Windows Server 2003
7 1 (0.12%) zOS
Processes & Methodologies
1 127 (15.53%) Agile Software Development
2 103 (12.59%) Data Analysis
3 97 (11.86%) Business Intelligence
4 96 (11.74%) Analytics
5 71 (8.68%) RAD
5 71 (8.68%) Risk Management
5 71 (8.68%) SDLC
6 64 (7.82%) Asset Management
7 57 (6.97%) Mathematics
7 57 (6.97%) Project Management
7 57 (6.97%) Stakeholder Management
8 47 (5.75%) Data Modelling
9 41 (5.01%) Visualisation
10 40 (4.89%) Workflow
11 39 (4.77%) Unit Testing
12 38 (4.65%) Migration
13 32 (3.91%) Data Management
14 31 (3.79%) Data Analytics
14 31 (3.79%) Scrum
15 30 (3.67%) Business Analysis
Programming Languages
1 415 (50.73%) SQL
2 210 (25.67%) C#
3 153 (18.70%) Python
4 110 (13.45%) Java
5 88 (10.76%) C++
6 74 (9.05%) VB
7 55 (6.72%) VB.NET
8 51 (6.23%) R
9 50 (6.11%) JavaScript
10 37 (4.52%) PL/SQL
11 35 (4.28%) PowerShell
12 32 (3.91%) T-SQL
13 28 (3.42%) Perl
14 14 (1.71%) C
14 14 (1.71%) PHP
15 11 (1.34%) VBScript
16 8 (0.98%) Google Apps Script
16 8 (0.98%) Shell Script
17 7 (0.86%) MATLAB
18 4 (0.49%) Korn
Qualifications
1 72 (8.80%) Degree
2 27 (3.30%) Security Cleared
3 24 (2.93%) SC Cleared
4 14 (1.71%) Computer Science Degree
4 14 (1.71%) Numerate Degree
5 11 (1.34%) Master's Degree
5 11 (1.34%) PMP
6 8 (0.98%) PMI Certification
7 7 (0.86%) Postgraduate
8 5 (0.61%) MOS
9 3 (0.37%) BPSS Clearance
9 3 (0.37%) Microsoft Certification
9 3 (0.37%) PRINCE2 Practitioner
10 2 (0.24%) ACCA
10 2 (0.24%) CIMA
10 2 (0.24%) PhD
11 1 (0.12%) MCSA
11 1 (0.12%) MCSD
11 1 (0.12%) MCSE
11 1 (0.12%) Network+ Certification
Quality Assurance & Compliance
1 41 (5.01%) QA
2 29 (3.55%) Data Quality
3 9 (1.10%) GDPR
4 8 (0.98%) Basel II
4 8 (0.98%) MiFID
4 8 (0.98%) PMO
5 3 (0.37%) Sarbanes-Oxley
5 3 (0.37%) SLA
6 2 (0.24%) Disclosure Scotland
6 2 (0.24%) Dodd-Frank
6 2 (0.24%) EMIR
6 2 (0.24%) IFRS
7 1 (0.12%) FINREP
7 1 (0.12%) Solvency II
System Software
1 4 (0.49%) Docker
2 3 (0.37%) Cronacle
3 2 (0.24%) Active Directory
4 1 (0.12%) Hyper-V
4 1 (0.12%) RACF
4 1 (0.12%) VMware Infrastructure
4 1 (0.12%) VMware Workstation
Systems Management
1 7 (0.86%) Control-M
2 2 (0.24%) ITRS Geneos
3 1 (0.12%) FortiGate
3 1 (0.12%) HP Quality Center
3 1 (0.12%) SCCM
3 1 (0.12%) Systems Management Server (SMS)
Vendors
1 167 (20.42%) Microsoft
2 125 (15.28%) Oracle
3 44 (5.38%) Tableau
4 24 (2.93%) Cognos
5 22 (2.69%) Bloomberg
6 20 (2.44%) SAP
7 17 (2.08%) Reuters
7 17 (2.08%) Teradata
8 14 (1.71%) Google
9 12 (1.47%) Blue Prism
10 10 (1.22%) Citrix
11 9 (1.10%) Calypso
12 6 (0.73%) Charles River
12 6 (0.73%) Sybase
13 5 (0.61%) Adobe
13 5 (0.61%) IBM
13 5 (0.61%) MicroStrategy
13 5 (0.61%) Red Hat
14 4 (0.49%) Omniture
14 4 (0.49%) Sun