Period
to 18 October 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 18 October 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
18 Oct 2017
Same period 2016 Same period 2015
Rank 296 315 231
Rank change year-on-year +19 -84 -22
Contract jobs citing VBA 827 818 1225
As % of all contract IT jobs advertised in the UK 0.83% 0.77% 1.08%
As % of the Programming Languages category 1.99% 1.91% 2.84%
Number of daily rates quoted 533 580 863
UK median daily rate £425 £375 £400
Median daily rate % change year-on-year +13.33% -6.25% +6.67%
10th Percentile £269 £224 £225
90th Percentile £675 £566 £600
UK excluding London median daily rate £351 £350 £326
% change year-on-year +0.29% +7.36% +0.31%
Number of hourly rates quoted 20 26 45
UK median hourly rate £23.49 £18.25 £22.50
Median hourly rate % change year-on-year +28.73% -18.89% +11.11%
10th Percentile £17.00 £11.20 £15.34
90th Percentile £49.00 £27.00 £41.24
UK excluding London median hourly rate £22.50 £21.50 £22.50
% change year-on-year +4.65% -4.44% +2.27%

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

All Programming Languages
UK
Contract vacancies with a requirement for coding skills 41633 42750 43158
As % of all contract IT jobs advertised in the UK 41.90% 40.13% 38.12%
Number of daily rates quoted 28899 29383 29187
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% +2.56%
10th Percentile £306 £280 £264
90th Percentile £625 £588 £588
UK excluding London median daily rate £400 £375 £363
% change year-on-year +6.67% +3.45% +3.57%
Number of hourly rates quoted 784 915 976
UK median hourly rate £40.00 £37.50 £36.50
Median hourly rate % change year-on-year +6.67% +2.74% +12.31%
10th Percentile £16.08 £14.13 £15.00
90th Percentile £53.00 £53.75 £51.25
UK excluding London median hourly rate £40.50 £37.50 £37.00
% change year-on-year +8.00% +1.35% +13.85%

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 18 October 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 18 October 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 18 October 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 +30 785 £425 +13.33% 136
London +44 550 £475 +18.75% 75
UK excluding London -39 270 £351 +0.29% 66
South East -25 71 £290 -20.55% 11
South West +25 62 £375 +3.45% 6
North of England +45 46 £335 -8.22% 21
Midlands +29 45 £363 -14.71% 7
West Midlands +41 29 £350 -11.39% 6
Scotland -15 27 £350 +11.11% 1
North West +36 24 £335 -4.29% 13
East Midlands -2 16 £450 +5.88% 1
Yorkshire -7 15 £409 +11.99% 6
East of England -43 15 £405 +35.00% 15
North East +75 7 £325 -35.64% 2
Wales +3 6 £350 +7.69% 2
Northern Ireland -49 2 £413 - 3

For the 6 months to 18 October 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 567 (68.56%) Microsoft Excel
2 406 (49.09%) SQL
3 348 (42.08%) Finance
4 253 (30.59%) SQL Server
5 244 (29.50%) Banking
6 200 (24.18%) C#
7 190 (22.97%) Microsoft
8 159 (19.23%) Front Office
9 156 (18.86%) .NET
10 134 (16.20%) Agile Software Development
11 115 (13.91%) Python
12 106 (12.82%) Oracle
13 101 (12.21%) Analytical Skills
14 98 (11.85%) Analytics
15 95 (11.49%) MS Access
16 92 (11.12%) Java
16 92 (11.12%) Data Analysis
17 91 (11.00%) Degree
18 85 (10.28%) Business Intelligence
19 82 (9.92%) Derivative
20 81 (9.79%) Investment Banking
21 80 (9.67%) Microsoft Office
22 79 (9.55%) VB
23 78 (9.43%) C++
24 71 (8.59%) Mathematics
25 66 (7.98%) Windows
25 66 (7.98%) SDLC
26 63 (7.62%) Asset Management
27 62 (7.50%) Project Management
28 61 (7.38%) Risk 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 46 (5.56%) SAS
2 34 (4.11%) SharePoint
3 10 (1.21%) CMS
4 6 (0.73%) Confluence
5 5 (0.60%) IIS
6 4 (0.48%) Apache Spark
6 4 (0.48%) Documentum
6 4 (0.48%) ThingWorx
7 3 (0.36%) MQSeries
7 3 (0.36%) SharePoint 2013
8 2 (0.24%) Apache
8 2 (0.24%) BizTalk Server
8 2 (0.24%) SharePoint 2010
8 2 (0.24%) WebSphere
9 1 (0.12%) EPiServer
9 1 (0.12%) Kentico
9 1 (0.12%) OpenEdge
9 1 (0.12%) Oracle Workflow
9 1 (0.12%) Skype for Business
9 1 (0.12%) Umbraco
Applications
1 567 (68.56%) Microsoft Excel
2 80 (9.67%) Microsoft Office
3 56 (6.77%) Spreadsheet
4 48 (5.80%) Microsoft PowerPoint
5 24 (2.90%) MS Visio
6 13 (1.57%) Microsoft Project
7 7 (0.85%) InfoPath
8 3 (0.36%) SPSS
9 1 (0.12%) Doxygen
Business Applications
1 6 (0.73%) Summit
2 5 (0.60%) Cognos TM1
2 5 (0.60%) Dynamics CRM
3 4 (0.48%) Maximo
4 3 (0.36%) Global One
4 3 (0.36%) RMDS
5 2 (0.24%) Cognos Business Intelligence
5 2 (0.24%) SAP IS-U
6 1 (0.12%) Dynamics GP
6 1 (0.12%) Front Arena
6 1 (0.12%) FRx
6 1 (0.12%) HFM
6 1 (0.12%) Hyperion Planning
6 1 (0.12%) Oracle Financials
6 1 (0.12%) Orchestrade
6 1 (0.12%) SAP BPC
6 1 (0.12%) SAP CO
6 1 (0.12%) SAP FI-GL
6 1 (0.12%) SimCorp Dimension
6 1 (0.12%) Temenos Globus
Cloud Services
1 8 (0.97%) Amazon AWS
2 7 (0.85%) Office 365
3 6 (0.73%) Microsoft Azure
4 4 (0.48%) G Suite
4 4 (0.48%) Google Analytics
4 4 (0.48%) Google Cloud Platform
5 1 (0.12%) AdWords
5 1 (0.12%) Amazon EC2
5 1 (0.12%) Google Tag Manager
Communications & Networking
1 7 (0.85%) SMS
2 6 (0.73%) Internet
2 6 (0.73%) LAN
2 6 (0.73%) WAN
3 5 (0.60%) Firewall
4 3 (0.36%) DNS
4 3 (0.36%) Radio Access Network
5 2 (0.24%) Intranet
5 2 (0.24%) SAN
6 1 (0.12%) 3G
6 1 (0.12%) 3GPP
6 1 (0.12%) 4G
6 1 (0.12%) 5G
6 1 (0.12%) DMZ
6 1 (0.12%) HTTP
6 1 (0.12%) LDAP
6 1 (0.12%) Skype
6 1 (0.12%) UTRAN
6 1 (0.12%) VLAN
6 1 (0.12%) VPN
Database & Business Intelligence
1 253 (30.59%) SQL Server
2 95 (11.49%) MS Access
3 60 (7.26%) SQL Server Integration Services
4 58 (7.01%) Relational Database
5 48 (5.80%) SQL Server Reporting Services
6 35 (4.23%) RDBMS
7 29 (3.51%) Data Warehouse
7 29 (3.51%) Oracle Database
8 26 (3.14%) BusinessObjects
8 26 (3.14%) Power BI
8 26 (3.14%) SQL Server 2008
9 18 (2.18%) Big Data
10 17 (2.06%) SQL Server Analysis Services
11 15 (1.81%) Oracle Database 11g
12 12 (1.45%) PowerPivot
12 12 (1.45%) QlikView
13 11 (1.33%) SQL Server 2012
14 10 (1.21%) Data Mining
14 10 (1.21%) SAS EBI
15 8 (0.97%) SAS Enterprise Guide
Development Applications
1 32 (3.87%) Visual Studio
2 24 (2.90%) JIRA
3 20 (2.42%) Selenium
3 20 (2.42%) Subversion
4 18 (2.18%) Team Foundation Server
5 17 (2.06%) Cucumber
5 17 (2.06%) SpecFlow
6 12 (1.45%) NUnit
7 10 (1.21%) Visual Studio Tools for Office
8 9 (1.09%) Jenkins
8 9 (1.09%) Toad
9 6 (0.73%) Ant
9 6 (0.73%) ClearCase
9 6 (0.73%) Maven
10 5 (0.60%) JMeter
10 5 (0.60%) Oracle APEX
10 5 (0.60%) Oracle Forms
11 4 (0.48%) Git (software)
11 4 (0.48%) TeamCity
12 3 (0.36%) Atlassian Bamboo
General
1 348 (42.08%) Finance
2 244 (29.50%) Banking
3 159 (19.23%) Front Office
4 81 (9.79%) Investment Banking
5 19 (2.30%) Retail
6 17 (2.06%) Back Office
7 13 (1.57%) Marketing
8 12 (1.45%) Legal
8 12 (1.45%) Manufacturing
9 10 (1.21%) Automotive
9 10 (1.21%) Financial Institution
10 9 (1.09%) Pharmaceutical
10 9 (1.09%) Telecoms
11 8 (0.97%) Billing
12 7 (0.85%) Retail Banking
13 6 (0.73%) Local Government
14 4 (0.48%) French Language
14 4 (0.48%) Japanese Language
15 3 (0.36%) Corporate Banking
15 3 (0.36%) General Ledger
Job Titles
1 417 (50.42%) Developer
2 286 (34.58%) Analyst
3 124 (14.99%) VBA Developer
4 88 (10.64%) Data Analyst
5 68 (8.22%) Excel Developer
6 66 (7.98%) Business Analyst
7 61 (7.38%) C# Developer
7 61 (7.38%) SQL Developer
8 60 (7.26%) .NET Developer
9 54 (6.53%) Excel VBA Developer
10 49 (5.93%) SQL Analyst
11 47 (5.68%) Python Developer
12 44 (5.32%) Access Developer
13 42 (5.08%) RAD Developer
14 41 (4.96%) Front Office Developer
15 37 (4.47%) C# .NET Developer
16 35 (4.23%) Analyst Developer
17 33 (3.99%) Excel Analyst
18 32 (3.87%) Access VBA Developer
19 29 (3.51%) Technical Analyst
Libraries, Frameworks & Software Standards
1 156 (18.86%) .NET
2 51 (6.17%) .NET Framework
3 37 (4.47%) XML
4 34 (4.11%) HTML
5 21 (2.54%) Web Services
6 20 (2.42%) WinForms
7 19 (2.30%) CSS
8 18 (2.18%) ASP.NET
9 15 (1.81%) Entity Framework
10 13 (1.57%) WCF
10 13 (1.57%) WPF
11 10 (1.21%) HTML5
11 10 (1.21%) XML Messaging
12 8 (0.97%) ActiveX
12 8 (0.97%) WF
13 7 (0.85%) jQuery
14 5 (0.60%) ASP.NET MVC
14 5 (0.60%) Gherkin
14 5 (0.60%) Middleware
15 4 (0.48%) Spring
Miscellaneous
1 101 (12.21%) Analytical Skills
2 82 (9.92%) Derivative
3 61 (7.38%) Foreign Exchange (FX)
4 54 (6.53%) Fixed Income
5 40 (4.84%) Computer Science
6 38 (4.59%) Market Risk
7 37 (4.47%) Credit Risk
8 34 (4.11%) Management Information System
9 32 (3.87%) Equities
10 11 (1.33%) Hedge funds
11 8 (0.97%) Data Structures
11 8 (0.97%) NHS
12 7 (0.85%) Equity Derivative
12 7 (0.85%) Interest Rate Derivative
12 7 (0.85%) Virtual Team
13 6 (0.73%) User Experience
14 5 (0.60%) Greenfield Project
15 4 (0.48%) Algorithms
15 4 (0.48%) Robotics
15 4 (0.48%) SCADA
Operating Systems
1 66 (7.98%) Windows
2 35 (4.23%) Unix
3 18 (2.18%) Linux
4 6 (0.73%) Windows 10
4 6 (0.73%) Windows Server 2008
5 5 (0.60%) Windows Server
6 3 (0.36%) Android
6 3 (0.36%) Apple iOS
6 3 (0.36%) Windows Server 2012
7 1 (0.12%) Windows 2000 Server
7 1 (0.12%) Windows 7
7 1 (0.12%) Windows Phone
7 1 (0.12%) Windows Server 2003
Processes & Methodologies
1 134 (16.20%) Agile Software Development
2 98 (11.85%) Analytics
3 92 (11.12%) Data Analysis
4 85 (10.28%) Business Intelligence
5 71 (8.59%) Mathematics
6 66 (7.98%) SDLC
7 63 (7.62%) Asset Management
8 62 (7.50%) Project Management
9 61 (7.38%) Risk Management
10 53 (6.41%) Stakeholder Management
11 48 (5.80%) RAD
12 45 (5.44%) Data Modelling
12 45 (5.44%) Workflow
13 41 (4.96%) Scrum
14 40 (4.84%) Migration
15 39 (4.72%) Unit Testing
16 33 (3.99%) Visualisation
17 32 (3.87%) Data Analytics
18 30 (3.63%) TDD
19 27 (3.26%) Business Analysis
Programming Languages
1 406 (49.09%) SQL
2 200 (24.18%) C#
3 115 (13.91%) Python
4 92 (11.12%) Java
5 79 (9.55%) VB
6 78 (9.43%) C++
7 50 (6.05%) VB.NET
8 45 (5.44%) R
9 43 (5.20%) JavaScript
10 39 (4.72%) PowerShell
11 35 (4.23%) PL/SQL
12 33 (3.99%) Perl
12 33 (3.99%) T-SQL
13 17 (2.06%) VBScript
14 16 (1.93%) C
15 11 (1.33%) Shell Script
16 10 (1.21%) PHP
17 9 (1.09%) MATLAB
18 5 (0.60%) VB6
19 4 (0.48%) Korn
Qualifications
1 91 (11.00%) Degree
2 31 (3.75%) Security Cleared
3 22 (2.66%) SC Cleared
4 21 (2.54%) Numerate Degree
5 19 (2.30%) Computer Science Degree
6 14 (1.69%) PMP
7 12 (1.45%) Master's Degree
8 11 (1.33%) PMI Certification
9 9 (1.09%) Postgraduate
10 8 (0.97%) PRINCE2 Practitioner
11 6 (0.73%) BPSS Clearance
11 6 (0.73%) DV Cleared
12 5 (0.60%) MOS
13 4 (0.48%) Microsoft Certification
14 3 (0.36%) CFA
14 3 (0.36%) PhD
15 2 (0.24%) ACCA
15 2 (0.24%) CIMA
16 1 (0.12%) Network+ Certification
16 1 (0.12%) OCP
Quality Assurance & Compliance
1 35 (4.23%) QA
2 23 (2.78%) Data Quality
3 11 (1.33%) PMO
4 9 (1.09%) Basel II
5 8 (0.97%) MiFID
6 4 (0.48%) GDPR
7 3 (0.36%) Disclosure Scotland
7 3 (0.36%) SLA
8 2 (0.24%) Dodd-Frank
8 2 (0.24%) EMIR
8 2 (0.24%) IFRS
8 2 (0.24%) Sarbanes-Oxley
8 2 (0.24%) Solvency II
9 1 (0.12%) FINREP
9 1 (0.12%) P3O
System Software
1 3 (0.36%) Cronacle
2 2 (0.24%) Active Directory
3 1 (0.12%) Docker
3 1 (0.12%) Hyper-V
3 1 (0.12%) VMware Infrastructure
3 1 (0.12%) VMware Workstation
Systems Management
1 7 (0.85%) Control-M
2 2 (0.24%) ITRS Geneos
2 2 (0.24%) Oozie
2 2 (0.24%) Systems Management Server (SMS)
3 1 (0.12%) FortiGate
3 1 (0.12%) SCCM
Vendors
1 190 (22.97%) Microsoft
2 106 (12.82%) Oracle
3 39 (4.72%) Tableau
4 28 (3.39%) SAP
5 25 (3.02%) Bloomberg
6 23 (2.78%) Cognos
7 18 (2.18%) Reuters
8 15 (1.81%) Sybase
9 12 (1.45%) Citrix
9 12 (1.45%) Google
10 11 (1.33%) Blue Prism
11 9 (1.09%) Calypso
11 9 (1.09%) Teradata
12 6 (0.73%) Charles River
13 5 (0.60%) Alteryx
14 4 (0.48%) Advent
14 4 (0.48%) SimCorp
14 4 (0.48%) Yardi
15 3 (0.36%) BISAM
15 3 (0.36%) Perforce