Period
to 20 February 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 20 February 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
20 Feb 2018
Same period 2017 Same period 2016
Rank 302 344 251
Rank change year-on-year +42 -93 -55
Contract jobs citing VBA 836 649 1,045
As % of all contract IT jobs advertised in the UK 0.82% 0.68% 0.98%
As % of the Programming Languages category 1.96% 1.67% 2.53%
Number of daily rates quoted 583 437 704
UK median daily rate £425 £400 £391
Median daily rate % change year-on-year +6.25% +2.24% -0.32%
10th Percentile £263 £250 £219
90th Percentile £650 £575 £604
UK excluding London median daily rate £350 £375 £325
% change year-on-year -6.67% +15.38% -7.14%
Number of hourly rates quoted 16 12 31
UK median hourly rate £24.50 £19.50 £21.00
Median hourly rate % change year-on-year +25.64% -7.14% -6.67%
10th Percentile £17.00 £8.85 £14.88
90th Percentile £50.00 £43.71 £41.24
UK excluding London median hourly rate £24.50 £21.00 £19.50
% change year-on-year +16.67% +7.69% -9.30%

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 42,619 38,747 41,249
As % of all contract IT jobs advertised in the UK 41.97% 40.66% 38.51%
Number of daily rates quoted 29,960 26,646 28,068
UK median daily rate £456 £425 £413
Median daily rate % change year-on-year +7.18% +3.03% +3.13%
10th Percentile £310 £288 £275
90th Percentile £638 £600 £600
UK excluding London median daily rate £400 £380 £375
% change year-on-year +5.26% +1.33% +7.14%
Number of hourly rates quoted 787 864 1,052
UK median hourly rate £40.00 £40.00 £37.50
Median hourly rate % change year-on-year - +6.67% +13.64%
10th Percentile £16.61 £15.00 £14.13
90th Percentile £52.50 £52.50 £52.45
UK excluding London median hourly rate £40.00 £40.00 £37.50
% change year-on-year - +6.67% +11.94%

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 February 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 20 February 2018.

Contractor hourly rate histogram for VBA in the UK

VBA
Top 15 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 February 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 +41 806 £425 +6.25% 204
London +67 589 £450 +9.09% 96
UK excluding London -22 241 £350 -6.67% 120
South East -29 68 £400 - 20
Midlands +8 50 £300 -25.29% 17
South West +26 43 £359 -10.38% 14
North of England +21 42 £375 +7.14% 34
West Midlands +27 37 £315 -30.00% 11
North West +22 25 £375 - 19
Scotland -31 20 £425 +43.34% 11
East of England -10 15 £263 -12.50% 23
Yorkshire -23 14 £388 +10.71% 13
East Midlands -12 13 £225 -38.36% 6
Wales -2 7 £300 -14.29%
North East +48 4 - - 2

For the 6 months to 20 February 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 605 (72.37%) Microsoft Excel
2 439 (52.51%) SQL
3 345 (41.27%) Finance
4 246 (29.43%) SQL Server
5 237 (28.35%) Banking
6 219 (26.20%) C#
7 172 (20.57%) .NET
8 165 (19.74%) Front Office
9 163 (19.50%) Microsoft
10 145 (17.34%) Python
11 144 (17.22%) Oracle
12 133 (15.91%) Analytical Skills
13 127 (15.19%) Business Intelligence
14 122 (14.59%) Java
15 105 (12.56%) Agile Software Development
16 93 (11.12%) VB
17 92 (11.00%) Data Analysis
18 91 (10.89%) Risk Management
19 89 (10.65%) MS Access
19 89 (10.65%) Derivative
20 84 (10.05%) Analytics
21 81 (9.69%) Fixed Income
22 77 (9.21%) Degree
23 75 (8.97%) C++
24 74 (8.85%) Spreadsheet
25 73 (8.73%) Microsoft Office
26 72 (8.61%) Investment Banking
27 68 (8.13%) SDLC
28 65 (7.78%) Stakeholder Management
29 63 (7.54%) SQL Server Integration Services

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 58 (6.94%) SAS
2 45 (5.38%) SharePoint
3 12 (1.44%) Confluence
4 10 (1.20%) IIS
5 8 (0.96%) MS Exchange
6 5 (0.60%) Apache Spark
6 5 (0.60%) Exchange Server 2010
6 5 (0.60%) Exchange Server 2013
6 5 (0.60%) Oracle Workflow
7 4 (0.48%) CMS
8 3 (0.36%) Exchange Server 2003
8 3 (0.36%) Exchange Server 2007
8 3 (0.36%) MQSeries
8 3 (0.36%) WebLogic
9 2 (0.24%) Apache
9 2 (0.24%) Mule
9 2 (0.24%) SharePoint 2010
9 2 (0.24%) SharePoint 2013
10 1 (0.12%) Umbraco
10 1 (0.12%) WordPress
Applications
1 605 (72.37%) Microsoft Excel
2 74 (8.85%) Spreadsheet
3 73 (8.73%) Microsoft Office
4 62 (7.42%) Microsoft PowerPoint
5 19 (2.27%) Microsoft Project
6 16 (1.91%) MS Visio
7 6 (0.72%) InfoPath
8 2 (0.24%) Acrobat
9 1 (0.12%) Doxygen
Business Applications
1 8 (0.96%) Summit
2 5 (0.60%) SimCorp Dimension
3 3 (0.36%) Cognos TM1
3 3 (0.36%) Endur
3 3 (0.36%) Orchestrade
3 3 (0.36%) RMDS
3 3 (0.36%) SAP ERP
3 3 (0.36%) SAP R/3
3 3 (0.36%) SAP SD
4 2 (0.24%) Dynamics AX
4 2 (0.24%) Dynamics NAV
4 2 (0.24%) Oracle Financials
5 1 (0.12%) Dynamics CRM
5 1 (0.12%) Global One
5 1 (0.12%) SAP HR
5 1 (0.12%) SAP MDG
5 1 (0.12%) Temenos Globus
5 1 (0.12%) thinkFolio
5 1 (0.12%) WebTrends
5 1 (0.12%) Workfront
Cloud Services
1 13 (1.56%) Office 365
2 9 (1.08%) Amazon AWS
2 9 (1.08%) Microsoft Azure
3 8 (0.96%) G Suite
4 6 (0.72%) Adobe Analytics
4 6 (0.72%) Google Cloud Platform
5 4 (0.48%) Slack
6 2 (0.24%) Azure Data Factory
6 2 (0.24%) GitHub
6 2 (0.24%) Google Analytics
7 1 (0.12%) Google Tag Manager
7 1 (0.12%) SaaS
Communications & Networking
1 7 (0.84%) Firewall
1 7 (0.84%) LAN
1 7 (0.84%) SMS
1 7 (0.84%) WAN
2 6 (0.72%) VLAN
3 5 (0.60%) IMAP
3 5 (0.60%) POP3
3 5 (0.60%) SMTP
3 5 (0.60%) TCP/IP
4 3 (0.36%) Internet
4 3 (0.36%) Radio Access Network
5 2 (0.24%) 3G
5 2 (0.24%) 4G
5 2 (0.24%) SSH
6 1 (0.12%) 2G
6 1 (0.12%) DMZ
6 1 (0.12%) DNS
6 1 (0.12%) HTTP
6 1 (0.12%) Intranet
6 1 (0.12%) VPN
Database & Business Intelligence
1 246 (29.43%) SQL Server
2 89 (10.65%) MS Access
3 63 (7.54%) SQL Server Integration Services
4 57 (6.82%) Relational Database
5 55 (6.58%) Power BI
6 50 (5.98%) SQL Server Reporting Services
7 43 (5.14%) Data Warehouse
8 33 (3.95%) RDBMS
9 30 (3.59%) BusinessObjects
10 29 (3.47%) Oracle Database
11 27 (3.23%) Big Data
12 26 (3.11%) QlikView
13 22 (2.63%) SQL Server 2008
14 18 (2.15%) Oracle Database 11g
14 18 (2.15%) SQL Server Analysis Services
15 17 (2.03%) SAS EBI
15 17 (2.03%) SQL Server 2016
16 16 (1.91%) SQL Server 2014
17 15 (1.79%) SQL Server 2012
18 14 (1.67%) PowerPivot
Development Applications
1 34 (4.07%) JIRA
2 23 (2.75%) Cucumber
3 17 (2.03%) Selenium
4 16 (1.91%) Visual Studio
5 15 (1.79%) Team Foundation Server
6 13 (1.56%) Git (software)
6 13 (1.56%) Jenkins
6 13 (1.56%) Subversion
7 9 (1.08%) SQL Server Management Studio (SSMS)
8 8 (0.96%) SpecFlow
9 6 (0.72%) JUnit
10 4 (0.48%) Jasmine
10 4 (0.48%) JMeter
11 3 (0.36%) Atlassian Bamboo
11 3 (0.36%) CA Gen
11 3 (0.36%) Selendroid
12 2 (0.24%) Bitbucket
12 2 (0.24%) Cobertura
12 2 (0.24%) JBehave
12 2 (0.24%) MSBuild
General
1 345 (41.27%) Finance
2 237 (28.35%) Banking
3 165 (19.74%) Front Office
4 72 (8.61%) Investment Banking
5 19 (2.27%) Legal
5 19 (2.27%) Marketing
6 18 (2.15%) Retail
7 16 (1.91%) Financial Institution
8 15 (1.79%) Back Office
8 15 (1.79%) Manufacturing
9 9 (1.08%) Retail Banking
10 8 (0.96%) French Language
11 7 (0.84%) Automotive
11 7 (0.84%) Telecoms
12 4 (0.48%) Advertising
12 4 (0.48%) Local Government
12 4 (0.48%) Pharmaceutical
13 3 (0.36%) Corporate Banking
14 2 (0.24%) Billing
14 2 (0.24%) Law
Job Titles
1 412 (49.28%) Developer
2 314 (37.56%) Analyst
3 152 (18.18%) VBA Developer
4 99 (11.84%) Data Analyst
5 89 (10.65%) Excel Developer
6 84 (10.05%) Excel VBA Developer
7 73 (8.73%) C# Developer
8 67 (8.01%) Business Analyst
8 67 (8.01%) SQL Developer
9 60 (7.18%) .NET Developer
10 48 (5.74%) RAD Developer
11 46 (5.50%) Front Office Developer
11 46 (5.50%) Python Developer
12 39 (4.67%) Analyst Developer
13 36 (4.31%) SQL Analyst
14 35 (4.19%) C# .NET Developer
14 35 (4.19%) Risk Analyst
15 29 (3.47%) Banking Analyst
15 29 (3.47%) Senior Developer
16 24 (2.87%) Consultant
Libraries, Frameworks & Software Standards
1 172 (20.57%) .NET
2 57 (6.82%) .NET Framework
3 50 (5.98%) HTML
4 29 (3.47%) XML
5 26 (3.11%) CSS
6 20 (2.39%) Web Services
7 19 (2.27%) WinForms
8 17 (2.03%) ASP.NET
9 15 (1.79%) REST
10 14 (1.67%) Entity Framework
11 12 (1.44%) WPF
12 10 (1.20%) WCF
13 8 (0.96%) JSON
14 7 (0.84%) AngularJS
15 6 (0.72%) ASP.NET Web API
15 6 (0.72%) jQuery
15 6 (0.72%) LDAP
15 6 (0.72%) MDX
15 6 (0.72%) Node.js
15 6 (0.72%) Task Parallel Library
Miscellaneous
1 133 (15.91%) Analytical Skills
2 89 (10.65%) Derivative
3 81 (9.69%) Fixed Income
4 45 (5.38%) Management Information System
5 38 (4.55%) Credit Risk
6 34 (4.07%) Computer Science
6 34 (4.07%) Foreign Exchange (FX)
7 28 (3.35%) Market Risk
8 25 (2.99%) Equities
9 15 (1.79%) Equity Derivative
10 14 (1.67%) Data Structures
11 8 (0.96%) Clustering
11 8 (0.96%) Interest Rate Derivative
12 7 (0.84%) Robotics
13 6 (0.72%) NHS
13 6 (0.72%) Reinsurance
14 5 (0.60%) Virtual Team
15 4 (0.48%) Algorithms
15 4 (0.48%) OTC Derivatives
15 4 (0.48%) User Experience
Operating Systems
1 55 (6.58%) Windows
2 28 (3.35%) Unix
3 23 (2.75%) Linux
4 9 (1.08%) Windows 10
5 8 (0.96%) Android
6 7 (0.84%) Windows Server 2008
6 7 (0.84%) Windows Server 2012
7 6 (0.72%) Apple iOS
7 6 (0.72%) Windows 7
8 5 (0.60%) Windows Server
9 4 (0.48%) Red Hat Enterprise Linux
10 2 (0.24%) zOS
11 1 (0.12%) Ubuntu
Processes & Methodologies
1 127 (15.19%) Business Intelligence
2 105 (12.56%) Agile Software Development
3 92 (11.00%) Data Analysis
4 91 (10.89%) Risk Management
5 84 (10.05%) Analytics
6 68 (8.13%) SDLC
7 65 (7.78%) Stakeholder Management
8 60 (7.18%) RAD
9 56 (6.70%) Visualisation
10 51 (6.10%) Project Management
11 49 (5.86%) Mathematics
12 47 (5.62%) Asset Management
12 47 (5.62%) Data Management
12 47 (5.62%) Data Modelling
13 45 (5.38%) Business Analysis
14 42 (5.02%) Migration
15 39 (4.67%) Workflow
16 34 (4.07%) Unit Testing
17 31 (3.71%) Validation
18 26 (3.11%) User Acceptance Testing
Programming Languages
1 439 (52.51%) SQL
2 219 (26.20%) C#
3 145 (17.34%) Python
4 122 (14.59%) Java
5 93 (11.12%) VB
6 75 (8.97%) C++
7 53 (6.34%) JavaScript
8 48 (5.74%) R
9 46 (5.50%) VB.NET
10 45 (5.38%) PowerShell
11 37 (4.43%) T-SQL
12 32 (3.83%) PL/SQL
13 20 (2.39%) VBScript
14 15 (1.79%) PHP
15 14 (1.67%) Perl
16 13 (1.56%) MATLAB
17 12 (1.44%) C
18 10 (1.20%) VB6
19 9 (1.08%) Shell Script
20 8 (0.96%) Google Apps Script
Qualifications
1 77 (9.21%) Degree
2 39 (4.67%) Security Cleared
3 29 (3.47%) SC Cleared
4 11 (1.32%) Computer Science Degree
5 9 (1.08%) Microsoft Certification
6 6 (0.72%) Master's Degree
6 6 (0.72%) PMP
7 5 (0.60%) MCP
7 5 (0.60%) PhD
7 5 (0.60%) PMI Certification
8 4 (0.48%) BPSS Clearance
8 4 (0.48%) DBS Check
8 4 (0.48%) Numerate Degree
9 3 (0.36%) MCSE
10 2 (0.24%) MCSA
10 2 (0.24%) MOS
11 1 (0.12%) A+ Certification
11 1 (0.12%) CFA
11 1 (0.12%) MCITP
11 1 (0.12%) Postgraduate
Quality Assurance & Compliance
1 44 (5.26%) QA
2 40 (4.78%) Data Quality
3 13 (1.56%) GDPR
4 12 (1.44%) PMO
4 12 (1.44%) Sarbanes-Oxley
5 10 (1.20%) Basel II
5 10 (1.20%) MiFID
6 9 (1.08%) IFRS
6 9 (1.08%) Solvency II
7 5 (0.60%) EMIR
7 5 (0.60%) IFRS 9
8 4 (0.48%) Basel III
9 3 (0.36%) Disclosure Scotland
9 3 (0.36%) FATCA
9 3 (0.36%) SLA
10 2 (0.24%) Dodd-Frank
11 1 (0.12%) CRD IV
System Software
1 14 (1.67%) Active Directory
2 7 (0.84%) Docker
3 6 (0.72%) Virtual Desktop
4 3 (0.36%) Cronacle
5 2 (0.24%) RACF
6 1 (0.12%) Hyper-V
6 1 (0.12%) Virtual Machines
6 1 (0.12%) VMware Infrastructure
6 1 (0.12%) VMware Workstation
Systems Management
1 4 (0.48%) Symantec Enterprise Vault
2 3 (0.36%) HP Quality Center
2 3 (0.36%) Microsoft Clustering
3 2 (0.24%) Ansible
3 2 (0.24%) Control-M
3 2 (0.24%) Opscode Chef
3 2 (0.24%) Puppet
3 2 (0.24%) Single Sign-On
4 1 (0.12%) ITRS Geneos
4 1 (0.12%) QRadar
4 1 (0.12%) Systems Management Server (SMS)
Vendors
1 163 (19.50%) Microsoft
2 144 (17.22%) Oracle
3 61 (7.30%) Tableau
4 42 (5.02%) SAP
5 29 (3.47%) Cognos
6 15 (1.79%) Blue Prism
7 13 (1.56%) Bloomberg
7 13 (1.56%) Reuters
7 13 (1.56%) Sybase
8 12 (1.44%) Teradata
9 10 (1.20%) Citrix
9 10 (1.20%) Google
10 8 (0.96%) Adobe
11 6 (0.72%) Alteryx
11 6 (0.72%) MicroStrategy
11 6 (0.72%) SimCorp
12 5 (0.60%) IBM
12 5 (0.60%) Informatica
12 5 (0.60%) Omniture
12 5 (0.60%) Red Hat