Period
to 13 November 2018

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 13 November 2018 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
13 Nov 2018
Same period 2017 Same period 2016
Rank 384 304 331
Rank change year-on-year -80 +27 -93
Contract jobs citing VBA 667 870 799
As % of all contract IT jobs advertised in the UK 0.64% 0.85% 0.76%
As % of the Programming Languages category 1.44% 2.02% 1.89%
Number of daily rates quoted 446 583 554
UK median daily rate £400 £450 £375
Median daily rate % change year-on-year -11.11% +20.00% -6.25%
10th Percentile £263 £268 £213
90th Percentile £650 £650 £550
UK excluding London median daily rate £355 £350 £340
% change year-on-year +1.43% +2.94% +4.62%
Number of hourly rates quoted 12 20 26
UK median hourly rate £18.00 £23.49 £18.25
Median hourly rate % change year-on-year -23.38% +28.73% -18.89%
10th Percentile £14.75 £17.00 £11.20
90th Percentile £30.00 £49.00 £27.00
UK excluding London median hourly rate £19.50 £21.38 £21.00
% change year-on-year -8.77% +1.79% -6.67%

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 46,312 42,968 42,284
As % of all contract IT jobs advertised in the UK 44.65% 42.06% 40.32%
Number of daily rates quoted 32,584 29,980 29,011
UK median daily rate £475 £450 £425
Median daily rate % change year-on-year +5.56% +5.88% +6.25%
10th Percentile £315 £308 £281
90th Percentile £638 £638 £588
UK excluding London median daily rate £425 £400 £375
% change year-on-year +6.25% +6.67% +2.04%
Number of hourly rates quoted 691 801 877
UK median hourly rate £41.53 £40.00 £37.50
Median hourly rate % change year-on-year +3.83% +6.67% +1.35%
10th Percentile £16.66 £16.25 £14.25
90th Percentile £52.50 £52.50 £52.50
UK excluding London median hourly rate £42.13 £40.50 £37.50
% change year-on-year +4.03% +8.00% -

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 13 November 2018.

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 13 November 2018.

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 13 November 2018. 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 -94 596 £413 -8.33% 166
London -83 383 £450 -9.77% 78
UK excluding London -21 275 £355 +1.43% 109
South East -16 75 £375 +25.00% 15
South West -45 53 £400 +6.67% 20
Scotland +17 52 £325 -7.14% 12
North of England -12 47 £355 -5.33% 28
Yorkshire +13 24 £355 -2.07% 9
Midlands -38 22 £335 -2.19% 20
North West -10 20 £309 -17.67% 18
East of England -2 14 £330 -12.93% 5
East Midlands +6 11 £308 -10.87% 10
Wales -13 11 £400 +23.08% 6
West Midlands -43 11 £350 +2.94% 10
North East -3 3 £288 -11.54% 1
Northern Ireland +37 2 £320 -22.42% 3

For the 6 months to 13 November 2018, IT contractor jobs citing VBA also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads with a requirement for VBA.

1 468 (70.16%) Microsoft Excel
2 385 (57.72%) SQL
3 287 (43.03%) Finance
4 220 (32.98%) SQL Server
5 174 (26.09%) C#
6 151 (22.64%) Microsoft
7 140 (20.99%) .NET
8 109 (16.34%) Banking
9 106 (15.89%) Python
10 105 (15.74%) Analytics
11 97 (14.54%) T-SQL
12 95 (14.24%) Business Intelligence
13 92 (13.79%) Agile Software Development
14 89 (13.34%) Analytical Skills
15 83 (12.44%) MS Access
16 82 (12.29%) Front Office
17 76 (11.39%) Problem-Solving
18 75 (11.24%) Data Analysis
19 73 (10.94%) SQL Server Integration Services
19 73 (10.94%) Data Warehouse
19 73 (10.94%) VB
20 71 (10.64%) Oracle
21 68 (10.19%) SQL Server Reporting Services
22 65 (9.75%) Degree
23 61 (9.15%) Java
24 55 (8.25%) Windows
25 51 (7.65%) Microsoft Office
25 51 (7.65%) Spreadsheet
26 50 (7.50%) Power BI
27 48 (7.20%) Migration

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 34 (5.10%) SharePoint
2 25 (3.75%) SAS
3 16 (2.40%) IIS
4 7 (1.05%) Confluence
5 6 (0.90%) SharePoint 2013
6 4 (0.60%) Apache
6 4 (0.60%) WebSphere
7 2 (0.30%) Apache Spark
7 2 (0.30%) Elasticsearch
7 2 (0.30%) WordPress
8 1 (0.15%) CMS
8 1 (0.15%) Documentum
8 1 (0.15%) Joomla!
8 1 (0.15%) LiveCycle
8 1 (0.15%) Mendix
8 1 (0.15%) MQSeries
8 1 (0.15%) Oracle Workflow
8 1 (0.15%) SharePoint 2010
8 1 (0.15%) Tomcat
Applications
1 468 (70.16%) Microsoft Excel
2 51 (7.65%) Microsoft Office
2 51 (7.65%) Spreadsheet
3 25 (3.75%) Microsoft PowerPoint
4 6 (0.90%) MS Visio
5 4 (0.60%) InfoPath
6 3 (0.45%) SPSS
7 1 (0.15%) Acrobat
7 1 (0.15%) Microsoft Project
7 1 (0.15%) Stata
Business Applications
1 13 (1.95%) CSG Singleview
1 13 (1.95%) Oracle EBS R12
1 13 (1.95%) Oracle Payables
1 13 (1.95%) Oracle Receivables
2 7 (1.05%) Dynamics AX
3 5 (0.75%) Cognos TM1
4 4 (0.60%) Sage 200
5 3 (0.45%) Bloomberg AIM
5 3 (0.45%) Dynamics CRM
5 3 (0.45%) HFM
5 3 (0.45%) Markit EDM
6 2 (0.30%) Eikon
6 2 (0.30%) Line 500
6 2 (0.30%) Magento
6 2 (0.30%) Oracle ASCP
6 2 (0.30%) Oracle EBS
6 2 (0.30%) PolarLake
6 2 (0.30%) SAP Oil and Gas
6 2 (0.30%) thinkFolio
7 1 (0.15%) Summit
Cloud Services
1 39 (5.85%) Microsoft Azure
2 29 (4.35%) Amazon AWS
3 18 (2.70%) Office 365
4 15 (2.25%) GitHub
5 10 (1.50%) Cloud Computing
6 8 (1.20%) SaaS
7 2 (0.30%) Amazon EMR
7 2 (0.30%) Amazon S3
7 2 (0.30%) Google Cloud Platform
8 1 (0.15%) Azure Data Factory
8 1 (0.15%) Dynamics 365
8 1 (0.15%) IaaS
8 1 (0.15%) Slack
Communications & Networking
1 8 (1.20%) PuTTY
2 7 (1.05%) Remote Desktop
2 7 (1.05%) Skype
2 7 (1.05%) VPN
2 7 (1.05%) Wireshark
3 6 (0.90%) Wireless
4 5 (0.75%) Internet
4 5 (0.75%) SMS
4 5 (0.75%) TCP/IP
5 3 (0.45%) Intranet
6 2 (0.30%) 4G
6 2 (0.30%) Radio Access Network
7 1 (0.15%) 3G
7 1 (0.15%) 3GPP
7 1 (0.15%) 5G
7 1 (0.15%) Broadband
7 1 (0.15%) Ethernet
7 1 (0.15%) Firewall
Database & Business Intelligence
1 220 (32.98%) SQL Server
2 83 (12.44%) MS Access
3 73 (10.94%) Data Warehouse
3 73 (10.94%) SQL Server Integration Services
4 68 (10.19%) SQL Server Reporting Services
5 50 (7.50%) Power BI
6 35 (5.25%) Relational Database
7 28 (4.20%) SQL Server 2016
8 19 (2.85%) Oracle Database
9 17 (2.55%) SQL Server 2012
9 17 (2.55%) SQL Server 2014
9 17 (2.55%) SQL Server Analysis Services
10 16 (2.40%) BusinessObjects
10 16 (2.40%) NoSQL
11 13 (1.95%) RDBMS
12 12 (1.80%) MongoDB
12 12 (1.80%) OLAP
13 11 (1.65%) Hadoop
13 11 (1.65%) MySQL
14 10 (1.50%) Oracle Database 12c
Development Applications
1 18 (2.70%) JIRA
2 16 (2.40%) SQL Server Management Studio (SSMS)
2 16 (2.40%) Team Foundation Server
3 12 (1.80%) Cucumber
3 12 (1.80%) Subversion
4 11 (1.65%) SpecFlow
4 11 (1.65%) Visual Studio
5 10 (1.50%) Selenium
6 8 (1.20%) Jenkins
6 8 (1.20%) TeamCity
7 6 (0.90%) Eclipse
8 5 (0.75%) Git (software)
8 5 (0.75%) Octopus Deploy
9 4 (0.60%) JUnit
9 4 (0.60%) Maven
9 4 (0.60%) NUnit
9 4 (0.60%) Visual Studio Tools for Office
10 3 (0.45%) RStudio
10 3 (0.45%) Toad
10 3 (0.45%) Visual Studio Team System
General
1 287 (43.03%) Finance
2 109 (16.34%) Banking
3 82 (12.29%) Front Office
4 33 (4.95%) Investment Banking
5 31 (4.65%) Retail
6 22 (3.30%) Billing
7 13 (1.95%) Financial Institution
8 8 (1.20%) Back Office
8 8 (1.20%) Telecoms
9 7 (1.05%) Advertising
10 5 (0.75%) Legal
10 5 (0.75%) Mandarin Language
10 5 (0.75%) Marketing
11 4 (0.60%) Law
11 4 (0.60%) Manufacturing
12 3 (0.45%) Pharmaceutical
12 3 (0.45%) Publishing
13 2 (0.30%) Corporate Banking
13 2 (0.30%) Retail Banking
14 1 (0.15%) Electronics
Job Titles
1 341 (51.12%) Developer
2 204 (30.58%) Analyst
3 147 (22.04%) VBA Developer
4 85 (12.74%) Excel Developer
5 78 (11.69%) Data Analyst
6 67 (10.04%) Excel VBA Developer
6 67 (10.04%) SQL Developer
7 49 (7.35%) C# Developer
8 47 (7.05%) Access Developer
9 41 (6.15%) Access VBA Developer
10 36 (5.40%) .NET Developer
11 31 (4.65%) SQL Analyst
12 29 (4.35%) Python Developer
13 26 (3.90%) Excel Analyst
14 22 (3.30%) Senior Developer
15 21 (3.15%) Financial Analyst
15 21 (3.15%) Front Office Developer
16 20 (3.00%) C# .NET Developer
17 19 (2.85%) Business Analyst
17 19 (2.85%) Consultant
Libraries, Frameworks & Software Standards
1 140 (20.99%) .NET
2 30 (4.50%) ASP.NET
3 23 (3.45%) .NET Framework
4 19 (2.85%) XML
5 17 (2.55%) HTML
6 15 (2.25%) ASP.NET Core
6 15 (2.25%) WPF
7 14 (2.10%) Entity Framework
8 10 (1.50%) Pandas
9 9 (1.35%) CSS
9 9 (1.35%) JSON
9 9 (1.35%) Web Services
10 7 (1.05%) ASP.NET MVC
10 7 (1.05%) Gherkin
10 7 (1.05%) SOAP
11 6 (0.90%) MDX
12 5 (0.75%) NumPy
12 5 (0.75%) PySpark
12 5 (0.75%) REST
13 4 (0.60%) jQuery
Miscellaneous
1 89 (13.34%) Analytical Skills
2 45 (6.75%) Derivative
3 39 (5.85%) Fixed Income
4 32 (4.80%) Self-Motivation
5 25 (3.75%) Equities
6 20 (3.00%) Reinsurance
7 18 (2.70%) Computer Science
7 18 (2.70%) Market Risk
8 15 (2.25%) Hedge funds
9 14 (2.10%) Credit Derivative
10 13 (1.95%) FMCG
11 11 (1.65%) Foreign Exchange (FX)
12 10 (1.50%) Data Structures
13 9 (1.35%) Reference Data
13 9 (1.35%) Robotics
14 8 (1.20%) Analytical Mindset
14 8 (1.20%) EPoS
14 8 (1.20%) Management Information System
15 7 (1.05%) Greenfield Project
16 6 (0.90%) OTC Derivatives
Operating Systems
1 55 (8.25%) Windows
2 24 (3.60%) Windows 10
3 11 (1.65%) Windows 7
3 11 (1.65%) Windows Server
4 9 (1.35%) Linux
5 7 (1.05%) Android
5 7 (1.05%) Unix
6 4 (0.60%) Apple iOS
6 4 (0.60%) Windows Server 2008
6 4 (0.60%) Windows Server 2012
7 2 (0.30%) Oracle Linux
7 2 (0.30%) Red Hat Enterprise Linux
7 2 (0.30%) Solaris
8 1 (0.15%) Windows Server 2003
8 1 (0.15%) Windows Vista
8 1 (0.15%) Windows XP
Processes & Methodologies
1 105 (15.74%) Analytics
2 95 (14.24%) Business Intelligence
3 92 (13.79%) Agile Software Development
4 76 (11.39%) Problem-Solving
5 75 (11.24%) Data Analysis
6 48 (7.20%) ETL
6 48 (7.20%) Migration
7 44 (6.60%) Mathematics
8 42 (6.30%) Asset Management
9 40 (6.00%) Data Modelling
10 39 (5.85%) Continuous Integration
11 38 (5.70%) Test Automation
12 35 (5.25%) Project Management
12 35 (5.25%) Stakeholder Management
13 34 (5.10%) TDD
14 32 (4.80%) SDLC
14 32 (4.80%) Software Engineering
15 31 (4.65%) User Acceptance Testing
16 27 (4.05%) Data Migration
17 26 (3.90%) Data Management
Programming Languages
1 385 (57.72%) SQL
2 174 (26.09%) C#
3 106 (15.89%) Python
4 97 (14.54%) T-SQL
5 73 (10.94%) VB
6 61 (9.15%) Java
7 47 (7.05%) PowerShell
8 34 (5.10%) VB.NET
9 30 (4.50%) PL/SQL
10 24 (3.60%) R
11 22 (3.30%) JavaScript
12 19 (2.85%) C++
13 11 (1.65%) MATLAB
13 11 (1.65%) Perl
14 9 (1.35%) C
15 8 (1.20%) PHP
16 7 (1.05%) VBScript
17 6 (0.90%) VB6
18 3 (0.45%) Jython
18 3 (0.45%) Shell Script
Qualifications
1 65 (9.75%) Degree
2 24 (3.60%) Numerate Degree
3 16 (2.40%) Security Cleared
4 14 (2.10%) PhD
5 8 (1.20%) SC Cleared
6 6 (0.90%) BPSS Clearance
7 5 (0.75%) MCDST
7 5 (0.75%) MCSE
7 5 (0.75%) Microsoft Certification
8 4 (0.60%) ACCA
8 4 (0.60%) Computer Science Degree
9 3 (0.45%) CIMA
10 2 (0.30%) CFA
11 1 (0.15%) DBS Check
11 1 (0.15%) ISTQB
Quality Assurance & Compliance
1 31 (4.65%) Data Quality
2 27 (4.05%) QA
3 16 (2.40%) GDPR
4 5 (0.75%) IFRS
4 5 (0.75%) Solvency II
5 4 (0.60%) PMO
6 3 (0.45%) MiFID
7 2 (0.30%) Disclosure Scotland
7 2 (0.30%) IFRS 9
8 1 (0.15%) SLA
System Software
1 23 (3.45%) Active Directory
2 10 (1.50%) VMware Infrastructure
3 8 (1.20%) Docker
3 8 (1.20%) Microsoft App-V
4 7 (1.05%) BitLocker
5 5 (0.75%) XenApp
6 4 (0.60%) Virtual Desktop
7 3 (0.45%) DFS Replication
7 3 (0.45%) VMware ESXi
7 3 (0.45%) XenDesktop
8 2 (0.30%) HDFS
Systems Management
1 18 (2.70%) SCCM
2 7 (1.05%) AirWatch
2 7 (1.05%) Kubernetes
3 6 (0.90%) Systems Management Server (SMS)
4 3 (0.45%) McAfee ePO
4 3 (0.45%) SafeCom
4 3 (0.45%) SCOM
4 3 (0.45%) SCOrch
4 3 (0.45%) XenMobile
5 2 (0.30%) Control-M
5 2 (0.30%) RSA Archer
6 1 (0.15%) QRadar
6 1 (0.15%) Wonderware InTouch
Vendors
1 151 (22.64%) Microsoft
2 71 (10.64%) Oracle
3 47 (7.05%) Tableau
4 27 (4.05%) Citrix
5 20 (3.00%) SAP
6 16 (2.40%) Bloomberg
7 11 (1.65%) VMware
8 10 (1.50%) Reuters
9 9 (1.35%) Automation Anywhere
9 9 (1.35%) Charles River
9 9 (1.35%) IBM
9 9 (1.35%) RedGate
9 9 (1.35%) UiPath
10 8 (1.20%) Alteryx
10 8 (1.20%) Cognos
10 8 (1.20%) HP
10 8 (1.20%) Ivanti
10 8 (1.20%) ServiceNow
10 8 (1.20%) Teradata
11 7 (1.05%) Cisco