Period
to 20 August 2017

The following table provides summary statistics for contract job vacancies 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 August 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
6 months to
20 Aug 2017
Same period 2016 Same period 2015
Rank 301 313 222
Rank change year-on-year +12 -91 -28
Contract jobs citing VBA 796 871 1253
As % of all contract IT jobs advertised in the UK 0.83% 0.80% 1.11%
As % of the Programming Languages category 1.98% 2.05% 2.95%
Number of daily rates quoted 498 623 883
UK median daily rate £425 £375 £393
Median daily rate % change year-on-year +13.33% -4.46% +4.67%
10th Percentile £268 £225 £213
90th Percentile £600 £575 £575
UK excluding London median daily rate £375 £350 £325
% change year-on-year +7.14% +7.69% -
Number of hourly rates quoted 21 24 34
UK median hourly rate £24.49 £20.31 £22.50
Median hourly rate % change year-on-year +20.59% -9.76% +9.76%
10th Percentile £17.50 £11.43 £15.27
90th Percentile £44.95 £31.73 £38.98
UK excluding London median hourly rate £31.33 £21.50 £22.50
% change year-on-year +45.73% -4.44% -

VBA is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies with a requirement for programming language skills.

Contract Programming Language Skills
UK
Contract job vacancies with a requirement for programming language skills 40196 42556 42491
As % of all contract IT job vacancies advertised in the UK 42.03% 39.23% 37.70%
Number of daily rates quoted 27630 29250 28266
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% +5.26%
10th Percentile £300 £280 £263
90th Percentile £625 £588 £588
UK excluding London median daily rate £400 £375 £350
% change year-on-year +6.67% +7.14% +1.45%
Number of hourly rates quoted 769 911 906
UK median hourly rate £40.00 £37.50 £35.00
Median hourly rate % change year-on-year +6.67% +7.14% +4.48%
10th Percentile £16.00 £13.50 £15.50
90th Percentile £53.75 £51.00 £50.00
UK excluding London median hourly rate £40.50 £37.50 £36.00
% change year-on-year +8.00% +4.17% +5.88%

VBA
Job Vacancy Trend

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

Job vacancy trend for VBA in the UK

VBA
Contractor Daily Rate Trend

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

Contractor daily rate trend for VBA in the UK

VBA
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing VBA over the 6 months to 20 August 2017.

Contractor daily rate histogram for VBA in the UK

VBA
Contractor Hourly Rate Trend

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

Contractor hourly rate trend for VBA in the UK

VBA
Contractor Hourly Rate Histogram

The hourly rate distribution of IT jobs citing VBA over the 6 months to 20 August 2017.

Contractor hourly rate histogram for VBA in the UK

VBA
Top 16 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing VBA within the UK over the 6 months to 20 August 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
England +16 756 £425 +13.33% 68
London +18 504 £450 +5.88% 35
UK excluding London +9 286 £375 +7.14% 36
South East -23 69 £290 -13.43% 11
North of England +36 65 £375 +7.14% 9
South West +11 52 £375 +1.69% 5
Midlands +45 49 £425 +3.03% 1
Scotland +10 29 £388 +5.44% 2
North West +40 28 £375 +7.14% 7
Yorkshire -1 28 £380 +2.70% 2
West Midlands +56 27 £375 +11.11%
East Midlands -11 22 £438 +2.94% 1
East of England -31 21 £405 +35.00% 7
North East +57 9 £375 +20.97%
Wales +4 3 £350 +7.69% 1
Northern Ireland -46 2 £413 -

For the 6 months to 20 August 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 with a requirement for VBA.

1 532 (66.83%) Microsoft Excel
2 442 (55.53%) SQL
3 354 (44.47%) Finance
4 231 (29.02%) SQL Server
5 207 (26.01%) Banking
6 201 (25.25%) C#
7 192 (24.12%) Microsoft
8 142 (17.84%) .NET
9 124 (15.58%) Front Office
10 113 (14.20%) Analytical Skills
11 111 (13.94%) Agile Software Development
12 100 (12.56%) Data Analysis
13 97 (12.19%) Degree
13 97 (12.19%) Oracle
14 95 (11.93%) Python
15 91 (11.43%) Analytics
16 86 (10.80%) Mathematics
16 86 (10.80%) MS Access
17 83 (10.43%) Microsoft Office
18 76 (9.55%) Windows
19 73 (9.17%) Business Intelligence
20 71 (8.92%) VB
20 71 (8.92%) SQL Server Integration Services
21 69 (8.67%) Investment Banking
21 69 (8.67%) Java
22 67 (8.42%) C++
23 65 (8.17%) SQL Server Reporting Services
24 57 (7.16%) Derivative
24 57 (7.16%) SAS
25 55 (6.91%) Project Management

VBA
Co-occurring IT Skills 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 57 (7.16%) SAS
2 39 (4.90%) SharePoint
3 11 (1.38%) IIS
4 7 (0.88%) Documentum
5 6 (0.75%) CMS
5 6 (0.75%) SharePoint 2010
5 6 (0.75%) SharePoint 2013
6 5 (0.63%) Apache Spark
7 4 (0.50%) ThingWorx
8 3 (0.38%) Tomcat
8 3 (0.38%) WebLogic
9 2 (0.25%) Apache
9 2 (0.25%) Apache Solr
9 2 (0.25%) BizTalk Server
9 2 (0.25%) Confluence
9 2 (0.25%) MQSeries
9 2 (0.25%) Oracle Workflow
9 2 (0.25%) WebSphere
10 1 (0.13%) EPiServer
10 1 (0.13%) OpenEdge
Applications
1 532 (66.83%) Microsoft Excel
2 83 (10.43%) Microsoft Office
3 41 (5.15%) Microsoft PowerPoint
4 38 (4.77%) Spreadsheet
5 22 (2.76%) MS Visio
6 14 (1.76%) Microsoft Project
7 6 (0.75%) SPSS
8 5 (0.63%) InfoPath
9 4 (0.50%) Stata
10 2 (0.25%) SPSS Modeler
Business Applications
1 7 (0.88%) Global One
2 6 (0.75%) Summit
3 5 (0.63%) Dynamics CRM
3 5 (0.63%) SAP CO
3 5 (0.63%) SAP FI
3 5 (0.63%) SAP FI/CO
4 4 (0.50%) Maximo
5 3 (0.38%) Cognos TM1
5 3 (0.38%) RMDS
6 2 (0.25%) Cognos Business Intelligence
6 2 (0.25%) Front Arena
6 2 (0.25%) HFM
6 2 (0.25%) Hyperion Planning
6 2 (0.25%) SAP BPC
6 2 (0.25%) SAP IS-U
7 1 (0.13%) Dynamics GP
7 1 (0.13%) FRx
7 1 (0.13%) Orchestrade
7 1 (0.13%) SAP FI-GL
7 1 (0.13%) SimCorp Dimension
Cloud Services
1 9 (1.13%) Office 365
2 4 (0.50%) Amazon AWS
2 4 (0.50%) Microsoft Azure
3 3 (0.38%) Google Analytics
4 1 (0.13%) Adobe Analytics
4 1 (0.13%) AdWords
4 1 (0.13%) Amazon EC2
4 1 (0.13%) G Suite
Communications & Networking
1 6 (0.75%) Internet
2 4 (0.50%) Firewall
2 4 (0.50%) LAN
2 4 (0.50%) SMS
2 4 (0.50%) WAN
3 3 (0.38%) PuTTY
3 3 (0.38%) WinSCP
4 2 (0.25%) DNS
4 2 (0.25%) HTTP
4 2 (0.25%) Intranet
4 2 (0.25%) SAN
5 1 (0.13%) Radio Access Network
5 1 (0.13%) UTRAN
Database & Business Intelligence
1 231 (29.02%) SQL Server
2 86 (10.80%) MS Access
3 71 (8.92%) SQL Server Integration Services
4 65 (8.17%) SQL Server Reporting Services
5 39 (4.90%) Relational Database
6 34 (4.27%) SQL Server 2008
7 33 (4.15%) BusinessObjects
8 27 (3.39%) Data Warehouse
9 26 (3.27%) Oracle Database
10 22 (2.76%) QlikView
11 21 (2.64%) SQL Server Analysis Services
12 18 (2.26%) Data Mining
12 18 (2.26%) SQL Server 2012
13 16 (2.01%) Big Data
13 16 (2.01%) Power BI
14 15 (1.88%) RDBMS
15 14 (1.76%) Oracle Database 11g
15 14 (1.76%) PowerPivot
16 11 (1.38%) MySQL
17 10 (1.26%) SAS Enterprise Guide
Development Applications
1 44 (5.53%) Visual Studio
2 20 (2.51%) NUnit
2 20 (2.51%) Selenium
3 17 (2.14%) Cucumber
4 15 (1.88%) JIRA
5 14 (1.76%) SpecFlow
6 13 (1.63%) Subversion
6 13 (1.63%) Team Foundation Server
6 13 (1.63%) Visual Studio Tools for Office
7 11 (1.38%) Jenkins
7 11 (1.38%) Toad
8 7 (0.88%) Ant
8 7 (0.88%) Maven
9 6 (0.75%) Oracle APEX
9 6 (0.75%) Oracle Forms
10 5 (0.63%) ClearCase
10 5 (0.63%) Moq
10 5 (0.63%) XMLSpy
11 4 (0.50%) Mockito
11 4 (0.50%) TeamCity
General
1 354 (44.47%) Finance
2 207 (26.01%) Banking
3 124 (15.58%) Front Office
4 69 (8.67%) Investment Banking
5 21 (2.64%) Retail
6 14 (1.76%) Back Office
7 11 (1.38%) Marketing
8 9 (1.13%) Financial Institution
8 9 (1.13%) Legal
8 9 (1.13%) Pharmaceutical
8 9 (1.13%) Retail Banking
9 8 (1.01%) Billing
10 7 (0.88%) Telecoms
11 6 (0.75%) Automotive
11 6 (0.75%) Law
11 6 (0.75%) Manufacturing
12 4 (0.50%) French Language
12 4 (0.50%) Japanese Language
13 3 (0.38%) General Ledger
14 2 (0.25%) Local Government
Job Titles
1 366 (45.98%) Developer
2 295 (37.06%) Analyst
3 100 (12.56%) VBA Developer
4 95 (11.93%) Data Analyst
5 62 (7.79%) Excel Developer
5 62 (7.79%) SQL Developer
6 57 (7.16%) SQL Analyst
7 56 (7.04%) Business Analyst
8 55 (6.91%) C# Developer
9 49 (6.16%) Excel VBA Developer
10 43 (5.40%) Access Developer
11 42 (5.28%) Excel Analyst
12 37 (4.65%) .NET Developer
13 32 (4.02%) Technical Analyst
14 31 (3.89%) Python Developer
14 31 (3.89%) RAD Developer
15 30 (3.77%) Access VBA Developer
15 30 (3.77%) Applications Support
16 29 (3.64%) Consultant
17 28 (3.52%) Analyst Developer
Libraries, Frameworks & Software Standards
1 142 (17.84%) .NET
2 34 (4.27%) .NET Framework
2 34 (4.27%) XML
3 33 (4.15%) HTML
4 30 (3.77%) Web Services
5 25 (3.14%) CSS
6 20 (2.51%) WCF
7 18 (2.26%) WinForms
8 16 (2.01%) ASP.NET
9 15 (1.88%) WPF
10 11 (1.38%) HTML5
10 11 (1.38%) WF
11 10 (1.26%) jQuery
11 10 (1.26%) Unity DI Container
12 7 (0.88%) ActiveX
12 7 (0.88%) LINQ
12 7 (0.88%) XML Messaging
13 6 (0.75%) Entity Framework
13 6 (0.75%) Middleware
13 6 (0.75%) XSLT
Miscellaneous
1 113 (14.20%) Analytical Skills
2 57 (7.16%) Derivative
3 53 (6.66%) Foreign Exchange (FX)
4 40 (5.03%) Market Risk
5 39 (4.90%) Management Information System
6 35 (4.40%) Fixed Income
7 34 (4.27%) Computer Science
8 32 (4.02%) Equities
9 29 (3.64%) Credit Risk
10 13 (1.63%) Data Protection Act
10 13 (1.63%) Hedge funds
11 11 (1.38%) Equity Derivative
12 8 (1.01%) Data Structures
12 8 (1.01%) NHS
13 6 (0.75%) Greenfield Project
13 6 (0.75%) Virtual Team
14 5 (0.63%) Interest Rate Derivative
14 5 (0.63%) User Experience
15 4 (0.50%) Data Centre
15 4 (0.50%) SCADA
Operating Systems
1 76 (9.55%) Windows
2 43 (5.40%) Unix
3 17 (2.14%) Linux
4 8 (1.01%) Windows Server
5 7 (0.88%) Windows Server 2008
6 6 (0.75%) Windows 10
7 5 (0.63%) Windows Server 2012
8 2 (0.25%) Windows 7
9 1 (0.13%) Android
9 1 (0.13%) Apple iOS
9 1 (0.13%) Windows 2000 Server
9 1 (0.13%) Windows 8
9 1 (0.13%) Windows Phone
9 1 (0.13%) Windows Server 2003
Processes & Methodologies
1 111 (13.94%) Agile Software Development
2 100 (12.56%) Data Analysis
3 91 (11.43%) Analytics
4 86 (10.80%) Mathematics
5 73 (9.17%) Business Intelligence
6 55 (6.91%) Project Management
7 50 (6.28%) Asset Management
8 44 (5.53%) Risk Management
8 44 (5.53%) Scrum
8 44 (5.53%) Stakeholder Management
9 40 (5.03%) Migration
9 40 (5.03%) RAD
10 39 (4.90%) Data Modelling
10 39 (4.90%) TDD
11 37 (4.65%) SDLC
12 36 (4.52%) Statistics
13 35 (4.40%) Workflow
14 32 (4.02%) Visualisation
15 29 (3.64%) Data Management
16 28 (3.52%) Unit Testing
Programming Languages
1 442 (55.53%) SQL
2 201 (25.25%) C#
3 95 (11.93%) Python
4 71 (8.92%) VB
5 69 (8.67%) Java
6 67 (8.42%) C++
7 50 (6.28%) T-SQL
8 46 (5.78%) R
9 44 (5.53%) VB.NET
10 43 (5.40%) JavaScript
11 39 (4.90%) PowerShell
12 30 (3.77%) Perl
12 30 (3.77%) PL/SQL
13 16 (2.01%) Shell Script
14 13 (1.63%) C
15 10 (1.26%) VBScript
16 9 (1.13%) MATLAB
16 9 (1.13%) PHP
17 8 (1.01%) VB6
18 5 (0.63%) XPath
Qualifications
1 97 (12.19%) Degree
2 26 (3.27%) Numerate Degree
2 26 (3.27%) Security Cleared
3 19 (2.39%) Computer Science Degree
4 13 (1.63%) SC Cleared
5 10 (1.26%) PMP
6 9 (1.13%) DV Cleared
6 9 (1.13%) Postgraduate
7 8 (1.01%) Master's Degree
7 8 (1.01%) PMI Certification
7 8 (1.01%) PRINCE2 Practitioner
8 6 (0.75%) CFA
9 5 (0.63%) BPSS Clearance
10 4 (0.50%) CIMA
10 4 (0.50%) MBA
10 4 (0.50%) PhD
11 3 (0.38%) Microsoft Certification
11 3 (0.38%) MOS
11 3 (0.38%) SAS Certification
12 2 (0.25%) ISTQB
Quality Assurance & Compliance
1 36 (4.52%) Data Quality
2 19 (2.39%) QA
3 15 (1.88%) PMO
4 6 (0.75%) Disclosure Scotland
5 5 (0.63%) Basel II
6 4 (0.50%) SLA
7 3 (0.38%) MiFID
7 3 (0.38%) Sarbanes-Oxley
8 2 (0.25%) Solvency II
9 1 (0.13%) Dodd-Frank
9 1 (0.13%) FINREP
9 1 (0.13%) P3O
Systems Management
1 5 (0.63%) Control-M
2 2 (0.25%) Oozie
3 1 (0.13%) FortiGate
3 1 (0.13%) HP Quality Center
3 1 (0.13%) ITRS Geneos
3 1 (0.13%) SCCM
3 1 (0.13%) Systems Management Server (SMS)
Vendors
1 192 (24.12%) Microsoft
2 97 (12.19%) Oracle
3 39 (4.90%) Tableau
4 33 (4.15%) SAP
5 28 (3.52%) Bloomberg
6 21 (2.64%) Sybase
7 14 (1.76%) Cognos
7 14 (1.76%) Reuters
8 12 (1.51%) Kofax
8 12 (1.51%) Teradata
9 11 (1.38%) Citrix
10 9 (1.13%) Calypso
11 8 (1.01%) Google
11 8 (1.01%) SimCorp
11 8 (1.01%) TOWER Software
12 5 (0.63%) Blue Prism
13 4 (0.50%) Advent
13 4 (0.50%) MicroStrategy
13 4 (0.50%) Remedy
13 4 (0.50%) Yardi