Period
to 21 November 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 21 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
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 297 318 233
Rank change year-on-year +21 -85 -32
Contract jobs citing VBA 875 802 1206
As % of all contract IT jobs advertised in the UK 0.85% 0.77% 1.06%
As % of the Programming Languages category 2.02% 1.90% 2.77%
Number of daily rates quoted 586 559 844
UK median daily rate £450 £375 £400
Median daily rate % change year-on-year +20.00% -6.25% +6.67%
10th Percentile £271 £213 £213
90th Percentile £675 £550 £600
UK excluding London median daily rate £350 £350 £325
% change year-on-year - +7.69% -1.52%
Number of hourly rates quoted 19 23 38
UK median hourly rate £24.49 £16.66 £22.50
Median hourly rate % change year-on-year +47.01% -25.98% -
10th Percentile £17.40 £11.08 £15.71
90th Percentile £49.25 £23.75 £41.24
UK excluding London median hourly rate £22.50 £19.50 £22.50
% change year-on-year +15.38% -13.33% -13.46%

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 43314 42222 43547
As % of all contract IT jobs advertised in the UK 42.00% 40.32% 38.34%
Number of daily rates quoted 30261 28989 29461
UK median daily rate £450 £425 £400
Median daily rate % change year-on-year +5.88% +6.25% -
10th Percentile £308 £281 £269
90th Percentile £638 £588 £588
UK excluding London median daily rate £400 £375 £369
% change year-on-year +6.67% +1.76% +5.29%
Number of hourly rates quoted 805 881 1045
UK median hourly rate £40.00 £37.50 £37.45
Median hourly rate % change year-on-year +6.67% +0.13% +20.81%
10th Percentile £16.18 £14.34 £14.13
90th Percentile £52.50 £52.50 £50.00
UK excluding London median hourly rate £40.00 £37.50 £37.50
% change year-on-year +6.67% - +19.05%

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 21 November 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 21 November 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 21 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
England +31 833 £450 +18.42% 95
London +54 607 £500 +25.00% 55
UK excluding London -62 260 £350 - 47
South East -38 69 £300 -20.00% 5
South West +13 59 £375 -3.23% 1
Midlands +19 44 £340 -20.00% 4
North of England +28 42 £375 +2.74% 21
West Midlands +38 30 £333 -14.74% 2
North West +35 27 £375 +15.38% 12
Scotland -42 24 £350 +16.67% 2
East Midlands -16 14 £345 -18.82% 2
East of England -34 14 £270 -10.00% 9
Wales +16 9 £325 - 3
Yorkshire -15 8 £363 +1.40% 9
North East +66 7 £325 -35.64%
Northern Ireland - 1 - - 2

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

1 612 (69.94%) Microsoft Excel
2 441 (50.40%) SQL
3 368 (42.06%) Finance
4 281 (32.11%) SQL Server
5 270 (30.86%) Banking
6 217 (24.80%) C#
7 195 (22.29%) Front Office
8 177 (20.23%) .NET
9 176 (20.11%) Microsoft
10 157 (17.94%) Python
11 135 (15.43%) Agile Software Development
12 130 (14.86%) Oracle
13 124 (14.17%) Analytical Skills
14 117 (13.37%) Java
15 109 (12.46%) Data Analysis
16 107 (12.23%) Business Intelligence
17 103 (11.77%) Analytics
18 98 (11.20%) Derivative
19 97 (11.09%) MS Access
20 90 (10.29%) C++
21 89 (10.17%) Investment Banking
22 83 (9.49%) VB
23 77 (8.80%) Degree
24 75 (8.57%) Fixed Income
24 75 (8.57%) SDLC
25 74 (8.46%) Risk Management
26 71 (8.11%) RAD
27 68 (7.77%) Microsoft Office
28 67 (7.66%) Asset Management
28 67 (7.66%) Spreadsheet

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 50 (5.71%) SAS
2 35 (4.00%) SharePoint
3 10 (1.14%) CMS
4 9 (1.03%) Confluence
5 7 (0.80%) Apache Spark
5 7 (0.80%) IIS
6 4 (0.46%) Apache
6 4 (0.46%) Documentum
6 4 (0.46%) Oracle Workflow
6 4 (0.46%) SharePoint 2010
7 3 (0.34%) MQSeries
8 2 (0.23%) BizTalk Server
8 2 (0.23%) ThingWorx
8 2 (0.23%) WebSphere
9 1 (0.11%) ArcGIS
9 1 (0.11%) EPiServer
9 1 (0.11%) Kentico
9 1 (0.11%) SharePoint 2013
9 1 (0.11%) Skype for Business
9 1 (0.11%) Umbraco
Applications
1 612 (69.94%) Microsoft Excel
2 68 (7.77%) Microsoft Office
3 67 (7.66%) Spreadsheet
4 51 (5.83%) Microsoft PowerPoint
5 15 (1.71%) MS Visio
6 11 (1.26%) Microsoft Project
7 7 (0.80%) InfoPath
8 2 (0.23%) SPSS
9 1 (0.11%) Doxygen
Business Applications
1 5 (0.57%) Cognos TM1
1 5 (0.57%) Dynamics CRM
2 4 (0.46%) Maximo
2 4 (0.46%) RMDS
3 3 (0.34%) Global One
3 3 (0.34%) Summit
4 2 (0.23%) Cognos Business Intelligence
4 2 (0.23%) Dynamics AX
4 2 (0.23%) Orchestrade
4 2 (0.23%) SAP ERP
5 1 (0.11%) Dynamics GP
5 1 (0.11%) FINCAD Analytics
5 1 (0.11%) FRx
5 1 (0.11%) HFM
5 1 (0.11%) Hyperion Planning
5 1 (0.11%) ION MarketView
5 1 (0.11%) SAP CO
5 1 (0.11%) SAP FI/CO
5 1 (0.11%) SAP FI-GL
5 1 (0.11%) SimCorp Dimension
Cloud Services
1 8 (0.91%) G Suite
1 8 (0.91%) Microsoft Azure
2 7 (0.80%) Amazon AWS
3 5 (0.57%) Google Cloud Platform
4 4 (0.46%) Adobe Analytics
4 4 (0.46%) Google Analytics
5 3 (0.34%) Office 365
5 3 (0.34%) Slack
6 2 (0.23%) Azure Data Factory
7 1 (0.11%) AdWords
7 1 (0.11%) Google Tag Manager
Communications & Networking
1 7 (0.80%) SMS
2 6 (0.69%) LAN
2 6 (0.69%) WAN
3 5 (0.57%) Firewall
3 5 (0.57%) Internet
4 3 (0.34%) DNS
4 3 (0.34%) Radio Access Network
5 2 (0.23%) 3G
5 2 (0.23%) 4G
5 2 (0.23%) Intranet
5 2 (0.23%) LDAP
5 2 (0.23%) SAN
6 1 (0.11%) 2G
6 1 (0.11%) 3GPP
6 1 (0.11%) 5G
6 1 (0.11%) DMZ
6 1 (0.11%) Skype
6 1 (0.11%) VLAN
6 1 (0.11%) VPN
Database & Business Intelligence
1 281 (32.11%) SQL Server
2 97 (11.09%) MS Access
3 66 (7.54%) SQL Server Integration Services
4 59 (6.74%) Relational Database
5 50 (5.71%) Power BI
6 45 (5.14%) SQL Server Reporting Services
7 38 (4.34%) RDBMS
8 35 (4.00%) Data Warehouse
9 33 (3.77%) Oracle Database
10 22 (2.51%) QlikView
10 22 (2.51%) SQL Server 2008
11 21 (2.40%) Big Data
11 21 (2.40%) BusinessObjects
12 20 (2.29%) Oracle Database 11g
12 20 (2.29%) SQL Server Analysis Services
13 18 (2.06%) PowerPivot
13 18 (2.06%) SAS EBI
14 10 (1.14%) SQL Server 2012
14 10 (1.14%) SQL Server 2014
15 9 (1.03%) Data Mining
Development Applications
1 24 (2.74%) JIRA
2 23 (2.63%) Visual Studio
3 21 (2.40%) Team Foundation Server
4 20 (2.29%) Cucumber
4 20 (2.29%) Selenium
5 19 (2.17%) Subversion
6 17 (1.94%) SpecFlow
7 12 (1.37%) Jenkins
8 8 (0.91%) SQL Server Management Studio (SSMS)
9 6 (0.69%) ClearCase
9 6 (0.69%) Git (software)
9 6 (0.69%) JUnit
10 5 (0.57%) Ant
10 5 (0.57%) JMeter
10 5 (0.57%) Maven
11 4 (0.46%) TeamCity
12 3 (0.34%) Atlassian Bamboo
12 3 (0.34%) Jasmine
12 3 (0.34%) NUnit
12 3 (0.34%) Oracle APEX
General
1 368 (42.06%) Finance
2 270 (30.86%) Banking
3 195 (22.29%) Front Office
4 89 (10.17%) Investment Banking
5 20 (2.29%) Retail
6 17 (1.94%) Marketing
7 15 (1.71%) Back Office
7 15 (1.71%) Financial Institution
8 12 (1.37%) Legal
8 12 (1.37%) Manufacturing
9 9 (1.03%) Retail Banking
10 8 (0.91%) Automotive
10 8 (0.91%) Telecoms
11 7 (0.80%) French Language
12 6 (0.69%) Local Government
12 6 (0.69%) Pharmaceutical
13 4 (0.46%) Japanese Language
14 3 (0.34%) Billing
14 3 (0.34%) Corporate Banking
15 2 (0.23%) Multimedia
Job Titles
1 448 (51.20%) Developer
2 304 (34.74%) Analyst
3 146 (16.69%) VBA Developer
4 98 (11.20%) Data Analyst
5 76 (8.69%) Excel Developer
6 74 (8.46%) C# Developer
7 69 (7.89%) .NET Developer
8 67 (7.66%) SQL Developer
9 66 (7.54%) Excel VBA Developer
10 65 (7.43%) Business Analyst
11 60 (6.86%) Python Developer
12 58 (6.63%) RAD Developer
13 54 (6.17%) Front Office Developer
14 49 (5.60%) SQL Analyst
15 43 (4.91%) C# .NET Developer
16 38 (4.34%) Access Developer
17 36 (4.11%) Analyst Developer
18 32 (3.66%) Senior Developer
19 29 (3.31%) Risk Analyst
20 27 (3.09%) Banking Analyst
Libraries, Frameworks & Software Standards
1 177 (20.23%) .NET
2 58 (6.63%) .NET Framework
3 45 (5.14%) HTML
4 36 (4.11%) XML
5 25 (2.86%) CSS
5 25 (2.86%) WinForms
6 24 (2.74%) Web Services
7 21 (2.40%) ASP.NET
8 15 (1.71%) Entity Framework
9 14 (1.60%) WPF
10 11 (1.26%) WCF
11 10 (1.14%) HTML5
11 10 (1.14%) REST
11 10 (1.14%) XML Messaging
12 8 (0.91%) ActiveX
12 8 (0.91%) jQuery
12 8 (0.91%) MDX
13 5 (0.57%) ASP.NET MVC
13 5 (0.57%) Gherkin
13 5 (0.57%) Middleware
Miscellaneous
1 124 (14.17%) Analytical Skills
2 98 (11.20%) Derivative
3 75 (8.57%) Fixed Income
4 62 (7.09%) Foreign Exchange (FX)
5 38 (4.34%) Computer Science
6 37 (4.23%) Credit Risk
6 37 (4.23%) Equities
7 35 (4.00%) Market Risk
8 33 (3.77%) Management Information System
9 17 (1.94%) Equity Derivative
10 10 (1.14%) Data Structures
11 8 (0.91%) NHS
12 7 (0.80%) Hedge funds
12 7 (0.80%) Virtual Team
13 6 (0.69%) Interest Rate Derivative
14 5 (0.57%) Robotics
14 5 (0.57%) User Experience
15 4 (0.46%) Algorithms
15 4 (0.46%) Credit Derivative
15 4 (0.46%) Reference Data
Operating Systems
1 57 (6.51%) Windows
2 35 (4.00%) Unix
3 22 (2.51%) Linux
4 6 (0.69%) Windows Server 2008
5 5 (0.57%) Windows 10
6 4 (0.46%) Windows Server
7 3 (0.34%) Android
7 3 (0.34%) Apple iOS
7 3 (0.34%) Red Hat Enterprise Linux
7 3 (0.34%) Windows Server 2012
8 2 (0.23%) Windows 7
9 1 (0.11%) Windows 2000 Server
9 1 (0.11%) Windows Server 2003
9 1 (0.11%) zOS
Processes & Methodologies
1 135 (15.43%) Agile Software Development
2 109 (12.46%) Data Analysis
3 107 (12.23%) Business Intelligence
4 103 (11.77%) Analytics
5 75 (8.57%) SDLC
6 74 (8.46%) Risk Management
7 71 (8.11%) RAD
8 67 (7.66%) Asset Management
9 63 (7.20%) Mathematics
10 59 (6.74%) Project Management
10 59 (6.74%) Stakeholder Management
11 49 (5.60%) Data Modelling
12 48 (5.49%) Visualisation
13 43 (4.91%) Workflow
14 41 (4.69%) Unit Testing
15 38 (4.34%) Migration
16 33 (3.77%) Data Management
16 33 (3.77%) Scrum
17 32 (3.66%) Business Analysis
17 32 (3.66%) Data Analytics
Programming Languages
1 441 (50.40%) SQL
2 217 (24.80%) C#
3 157 (17.94%) Python
4 117 (13.37%) Java
5 90 (10.29%) C++
6 83 (9.49%) VB
7 56 (6.40%) R
7 56 (6.40%) VB.NET
8 49 (5.60%) JavaScript
9 38 (4.34%) PL/SQL
10 37 (4.23%) PowerShell
11 31 (3.54%) Perl
11 31 (3.54%) T-SQL
12 16 (1.83%) VBScript
13 15 (1.71%) C
14 14 (1.60%) PHP
15 9 (1.03%) MATLAB
16 8 (0.91%) Google Apps Script
16 8 (0.91%) Shell Script
17 4 (0.46%) Korn
Qualifications
1 77 (8.80%) Degree
2 29 (3.31%) Security Cleared
3 26 (2.97%) SC Cleared
4 15 (1.71%) Numerate Degree
5 14 (1.60%) Computer Science Degree
6 12 (1.37%) Master's Degree
7 11 (1.26%) PMP
8 8 (0.91%) PMI Certification
9 7 (0.80%) Postgraduate
10 5 (0.57%) BPSS Clearance
10 5 (0.57%) MOS
11 3 (0.34%) Microsoft Certification
11 3 (0.34%) PRINCE2 Practitioner
12 2 (0.23%) ACCA
12 2 (0.23%) CFA
12 2 (0.23%) CIMA
12 2 (0.23%) PhD
13 1 (0.11%) MCSA
13 1 (0.11%) MCSE
13 1 (0.11%) Network+ Certification
Quality Assurance & Compliance
1 43 (4.91%) QA
2 29 (3.31%) Data Quality
3 9 (1.03%) Basel II
3 9 (1.03%) GDPR
3 9 (1.03%) PMO
4 8 (0.91%) MiFID
5 3 (0.34%) Dodd-Frank
5 3 (0.34%) Sarbanes-Oxley
5 3 (0.34%) SLA
6 2 (0.23%) Disclosure Scotland
6 2 (0.23%) EMIR
6 2 (0.23%) IFRS
7 1 (0.11%) FINREP
7 1 (0.11%) Solvency II
System Software
1 4 (0.46%) Docker
2 3 (0.34%) Cronacle
3 2 (0.23%) Active Directory
4 1 (0.11%) Hyper-V
4 1 (0.11%) RACF
4 1 (0.11%) VMware Infrastructure
4 1 (0.11%) VMware Workstation
Systems Management
1 7 (0.80%) Control-M
2 2 (0.23%) ITRS Geneos
2 2 (0.23%) Oozie
2 2 (0.23%) Systems Management Server (SMS)
3 1 (0.11%) FortiGate
3 1 (0.11%) HP Quality Center
3 1 (0.11%) SCCM
Vendors
1 176 (20.11%) Microsoft
2 130 (14.86%) Oracle
3 49 (5.60%) Tableau
4 27 (3.09%) Cognos
5 24 (2.74%) Bloomberg
6 21 (2.40%) SAP
7 17 (1.94%) Reuters
7 17 (1.94%) Teradata
8 14 (1.60%) Google
9 13 (1.49%) Citrix
10 12 (1.37%) Blue Prism
11 11 (1.26%) Sybase
12 9 (1.03%) Calypso
13 6 (0.69%) Charles River
14 5 (0.57%) Adobe
14 5 (0.57%) IBM
14 5 (0.57%) MicroStrategy
15 4 (0.46%) Red Hat
15 4 (0.46%) SimCorp
15 4 (0.46%) Sun