Period
to 21 August 2018

The following table provides summary statistics for permanent job vacancies with a requirement for VBA skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited VBA over the 6 months to 21 August 2018 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
21 Aug 2018
Same period 2017 Same period 2016
Rank 374 404 362
Rank change year-on-year +30 -42 -23
Permanent jobs citing VBA 1,396 1,373 1,701
As % of all permanent IT jobs advertised in the UK 0.83% 0.78% 0.86%
As % of the Programming Languages category 1.48% 1.40% 1.65%
Number of salaries quoted 1,169 1,174 1,435
UK median annual salary £45,000 £45,000 £45,000
10th Percentile £26,250 £26,250 £27,500
90th Percentile £75,000 £78,750 £72,500
UK excluding London median annual salary £37,000 £35,000 £37,500
% change year-on-year +5.71% -6.67% +7.14%

VBA is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for coding skills.

All Programming Languages
UK
Permanent vacancies with a requirement for coding skills 94,322 97,925 103,267
As % of all permanent IT jobs advertised in the UK 55.82% 55.56% 52.40%
Number of salaries quoted 78,325 80,918 89,393
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,000 £28,750 £28,250
90th Percentile £81,250 £77,500 £75,000
UK excluding London median annual salary £45,000 £42,500 £40,000
% change year-on-year +5.88% +6.25% -

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
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing VBA.

Salary trend for VBA in the UK

VBA
Salary Histogram

The salary distribution of IT jobs citing VBA over the 6 months to 21 August 2018.

Salary histogram for VBA in the UK

VBA
Top 17 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing VBA within the UK over the 6 months to 21 August 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +16 1,321 £45,000 - 156
London +16 752 £52,500 -4.55% 55
UK excluding London +2 619 £37,000 +5.71% 114
North of England +23 178 £35,000 - 26
South East -7 140 £36,250 +3.57% 30
East of England +61 113 £40,000 +6.67% 8
North West +27 93 £35,072 +11.34% 14
Midlands +2 90 £34,000 +11.48% 27
Yorkshire +9 74 £35,000 - 9
East Midlands +8 46 £36,250 +18.85% 8
South West -15 46 £35,000 - 10
West Midlands +16 44 £32,000 -12.33% 19
Wales +27 26 £37,500 +15.38% 8
Scotland -9 25 £37,500 +19.05% 4
North East -10 11 £31,000 -1.59% 3
Northern Ireland - 2 £32,500 - 1
Channel Islands - 1 £85,000 -

For the 6 months to 21 August 2018, IT 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 permanent job ads with a requirement for VBA.

1 920 (65.90%) SQL
2 846 (60.60%) Microsoft Excel
3 627 (44.91%) Finance
4 580 (41.55%) SQL Server
5 432 (30.95%) C#
6 408 (29.23%) Microsoft
7 378 (27.08%) Business Intelligence
8 360 (25.79%) .NET
9 336 (24.07%) Degree
10 333 (23.85%) Analytical Skills
11 301 (21.56%) T-SQL
12 283 (20.27%) Agile Software Development
13 278 (19.91%) SQL Server Reporting Services
14 249 (17.84%) Analytics
15 227 (16.26%) Problem-Solving
16 220 (15.76%) Python
17 199 (14.26%) VB
17 199 (14.26%) Banking
18 191 (13.68%) SQL Server Integration Services
19 190 (13.61%) Microsoft Office
20 183 (13.11%) Oracle
21 174 (12.46%) Windows
22 172 (12.32%) Front Office
23 167 (11.96%) Tableau
24 162 (11.60%) Computer Science
25 157 (11.25%) Power BI
26 153 (10.96%) Data Analysis
26 153 (10.96%) XML
27 149 (10.67%) Visualisation
28 147 (10.53%) 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 90 (6.45%) SAS
2 83 (5.95%) SharePoint
3 65 (4.66%) IIS
4 29 (2.08%) Confluence
5 16 (1.15%) Apache Spark
6 12 (0.86%) Apache
6 12 (0.86%) CMS
6 12 (0.86%) Oracle Workflow
7 9 (0.64%) WordPress
8 7 (0.50%) Exchange Server 2013
8 7 (0.50%) SharePoint 2013
9 5 (0.36%) DataSynapse
9 5 (0.36%) IBM Notes
9 5 (0.36%) MS Project Server
9 5 (0.36%) SharePoint Server
10 4 (0.29%) Exchange Server 2010
10 4 (0.29%) MS Exchange
11 3 (0.21%) Tomcat
11 3 (0.21%) WebLogic
11 3 (0.21%) WebSphere
Applications
1 846 (60.60%) Microsoft Excel
2 190 (13.61%) Microsoft Office
3 51 (3.65%) Microsoft PowerPoint
4 42 (3.01%) Spreadsheet
5 35 (2.51%) SPSS
6 17 (1.22%) Microsoft Project
7 16 (1.15%) MS Visio
8 4 (0.29%) EViews
9 3 (0.21%) LibreOffice
10 2 (0.14%) Adobe Illustrator
10 2 (0.14%) Photoshop
11 1 (0.072%) Chatbot
11 1 (0.072%) EPLAN
11 1 (0.072%) Simulink
11 1 (0.072%) Stateflow
11 1 (0.072%) XMetaL
Business Applications
1 30 (2.15%) Cognos TM1
2 24 (1.72%) SimCorp Dimension
3 20 (1.43%) Cognos Business Intelligence
4 17 (1.22%) Dynamics CRM
4 17 (1.22%) Elite 3E
5 9 (0.64%) Workfront
6 8 (0.57%) Infor SunSystems
6 8 (0.57%) Markit EDM
6 8 (0.57%) Oracle EBS
6 8 (0.57%) Summit
7 6 (0.43%) Adobe Campaign
7 6 (0.43%) Unica
8 5 (0.36%) Oracle CRM
8 5 (0.36%) SAP S/4HANA
9 4 (0.29%) Oracle ERP
9 4 (0.29%) SAP ERP
9 4 (0.29%) SAP Forecasting and Replenishment
9 4 (0.29%) SAP InfiniteInsight
9 4 (0.29%) SAP Retail
9 4 (0.29%) SunGard GMI
Cloud Services
1 89 (6.38%) Microsoft Azure
2 36 (2.58%) Amazon AWS
3 33 (2.36%) SaaS
4 23 (1.65%) Office 365
5 17 (1.22%) Cloud Computing
6 13 (0.93%) Google Analytics
7 12 (0.86%) Dynamics 365
8 10 (0.72%) Salesforce Sales Cloud
8 10 (0.72%) Salesforce Service Cloud
9 7 (0.50%) Google Cloud Platform
10 5 (0.36%) Azure Data Factory
11 4 (0.29%) Adobe Analytics
11 4 (0.29%) IBM Cloud
12 2 (0.14%) Amazon S3
12 2 (0.14%) GitHub
13 1 (0.072%) AdWords
13 1 (0.072%) G Suite
13 1 (0.072%) Google Tag Manager
13 1 (0.072%) IaaS
13 1 (0.072%) Slack
Communications & Networking
1 31 (2.22%) Firewall
2 21 (1.50%) Intrusion Detection
3 15 (1.07%) VPN
4 14 (1.00%) Intranet
5 13 (0.93%) HTTP
5 13 (0.93%) SMS
6 12 (0.86%) TCP/IP
7 11 (0.79%) DNS
7 11 (0.79%) Remote Desktop
8 8 (0.57%) MPLS
8 8 (0.57%) Wireshark
9 7 (0.50%) SSL
10 6 (0.43%) FTP
10 6 (0.43%) Telnet
11 5 (0.36%) Internet
12 3 (0.21%) LAN
12 3 (0.21%) WAN
13 2 (0.14%) Extranet
13 2 (0.14%) POP3
13 2 (0.14%) SMTP
Database & Business Intelligence
1 580 (41.55%) SQL Server
2 278 (19.91%) SQL Server Reporting Services
3 191 (13.68%) SQL Server Integration Services
4 157 (11.25%) Power BI
5 139 (9.96%) MS Access
6 133 (9.53%) Data Warehouse
7 126 (9.03%) SQL Server Analysis Services
8 89 (6.38%) Relational Database
9 86 (6.16%) SQL Server 2008
10 78 (5.59%) Crystal Reports
11 69 (4.94%) NoSQL
12 67 (4.80%) MySQL
13 65 (4.66%) BusinessObjects
14 54 (3.87%) SQL Server 2012
15 50 (3.58%) QlikView
16 44 (3.15%) Big Data
17 35 (2.51%) Couchbase
18 33 (2.36%) Data Mining
19 30 (2.15%) Oracle Reports
20 26 (1.86%) MongoDB
Development Applications
1 115 (8.24%) Team Foundation Server
2 71 (5.09%) Visual Studio
3 60 (4.30%) Git (software)
4 48 (3.44%) JIRA
5 36 (2.58%) Subversion
6 29 (2.08%) Visual Studio Tools for Office
7 16 (1.15%) Eclipse
8 14 (1.00%) Jenkins
9 11 (0.79%) TeamCity
9 11 (0.79%) Visual Studio Team System
10 10 (0.72%) SQL Server Management Studio (SSMS)
11 9 (0.64%) Octopus Deploy
12 8 (0.57%) SpecFlow
13 6 (0.43%) Artifactory
13 6 (0.43%) NUnit
13 6 (0.43%) SonarQube
14 5 (0.36%) Bitbucket
14 5 (0.36%) Maven
15 4 (0.29%) Atlassian Bamboo
16 3 (0.21%) Xcode
General
1 627 (44.91%) Finance
2 199 (14.26%) Banking
3 172 (12.32%) Front Office
4 83 (5.95%) Marketing
5 59 (4.23%) Retail
6 54 (3.87%) Law
7 46 (3.30%) Back Office
8 39 (2.79%) Investment Banking
8 39 (2.79%) Legal
9 25 (1.79%) Advertising
10 16 (1.15%) French Language
11 14 (1.00%) Italian Language
11 14 (1.00%) Local Government
11 14 (1.00%) Spanish Language
12 10 (0.72%) Financial Institution
13 9 (0.64%) Manufacturing
14 8 (0.57%) German Language
15 6 (0.43%) Billing
16 4 (0.29%) Dutch Language
16 4 (0.29%) Retail Banking
Job Titles
1 579 (41.48%) Developer
2 501 (35.89%) Analyst
3 156 (11.17%) Data Analyst
4 137 (9.81%) C# Developer
5 124 (8.88%) SQL Developer
6 111 (7.95%) VBA Developer
7 89 (6.38%) Applications Support
8 85 (6.09%) Business Intelligence Developer
9 83 (5.95%) .NET Developer
10 75 (5.37%) Junior
10 75 (5.37%) SQL Analyst
11 68 (4.87%) C# .NET Developer
12 67 (4.80%) Consultant
13 60 (4.30%) Excel Developer
14 57 (4.08%) Front Office Developer
14 57 (4.08%) Support Analyst
15 55 (3.94%) Business Intelligence Analyst
16 50 (3.58%) Senior Developer
17 48 (3.44%) Analyst Developer
18 47 (3.37%) Software Developer
Libraries, Frameworks & Software Standards
1 360 (25.79%) .NET
2 153 (10.96%) XML
3 131 (9.38%) HTML
4 88 (6.30%) CSS
5 84 (6.02%) .NET Framework
6 73 (5.23%) ASP.NET
7 53 (3.80%) WCF
8 40 (2.87%) WPF
9 39 (2.79%) JSON
10 36 (2.58%) jQuery
10 36 (2.58%) WinForms
11 34 (2.44%) REST
12 32 (2.29%) AngularJS
13 30 (2.15%) Web Services
14 28 (2.01%) HTML5
15 24 (1.72%) ASP.NET MVC
16 20 (1.43%) MDX
17 19 (1.36%) D3.js
17 19 (1.36%) SOAP
18 18 (1.29%) Twitter Bootstrap
Miscellaneous
1 333 (23.85%) Analytical Skills
2 162 (11.60%) Computer Science
3 97 (6.95%) Management Information System
4 84 (6.02%) Equities
5 82 (5.87%) Derivative
6 53 (3.80%) Foreign Exchange (FX)
7 44 (3.15%) Self-Motivation
8 39 (2.79%) Fixed Income
9 31 (2.22%) Data Structures
10 26 (1.86%) Hedge funds
10 26 (1.86%) User Experience
11 23 (1.65%) Cybercrime
12 19 (1.36%) Reinsurance
13 17 (1.22%) Enterprise Software
14 16 (1.15%) Driving Licence
14 16 (1.15%) Fintech
15 15 (1.07%) Analytical Mindset
16 14 (1.00%) Greenfield Project
16 14 (1.00%) SCADA
17 13 (0.93%) CCTV
Operating Systems
1 174 (12.46%) Windows
2 71 (5.09%) Linux
3 70 (5.01%) Windows Server
4 50 (3.58%) Unix
4 50 (3.58%) Windows 7
5 20 (1.43%) Windows Server 2008
6 19 (1.36%) Windows Server 2012
7 15 (1.07%) Windows 10
8 7 (0.50%) Android
9 5 (0.36%) Apple iOS
9 5 (0.36%) HPUX
10 4 (0.29%) Mac OS X
11 3 (0.21%) Red Hat Enterprise Linux
11 3 (0.21%) Windows 2000
11 3 (0.21%) Windows Embedded Compact
11 3 (0.21%) Windows XP
12 2 (0.14%) CentOS
12 2 (0.14%) Windows 8
13 1 (0.072%) Mac OS
13 1 (0.072%) Solaris
Processes & Methodologies
1 378 (27.08%) Business Intelligence
2 283 (20.27%) Agile Software Development
3 249 (17.84%) Analytics
4 227 (16.26%) Problem-Solving
5 153 (10.96%) Data Analysis
6 149 (10.67%) Visualisation
7 147 (10.53%) Project Management
8 143 (10.24%) Scrum
9 134 (9.60%) ETL
10 123 (8.81%) Data Modelling
11 118 (8.45%) Continuous Improvement
12 114 (8.17%) Asset Management
13 110 (7.88%) Mathematics
14 109 (7.81%) CRM
14 109 (7.81%) TDD
15 107 (7.66%) SDLC
16 93 (6.66%) OO
17 87 (6.23%) Business Analysis
18 84 (6.02%) Change Management
18 84 (6.02%) Time Management
Programming Languages
1 920 (65.90%) SQL
2 432 (30.95%) C#
3 301 (21.56%) T-SQL
4 220 (15.76%) Python
5 199 (14.26%) VB
6 145 (10.39%) Java
7 140 (10.03%) JavaScript
7 140 (10.03%) VB.NET
8 122 (8.74%) C++
9 108 (7.74%) PowerShell
10 92 (6.59%) R
11 78 (5.59%) C
12 64 (4.58%) PHP
13 56 (4.01%) PL/SQL
14 30 (2.15%) MATLAB
15 29 (2.08%) Perl
16 23 (1.65%) VB6
17 15 (1.07%) VBScript
18 14 (1.00%) Data Analysis Expressions (DAX)
19 10 (0.72%) Shell Script
Qualifications
1 336 (24.07%) Degree
2 66 (4.73%) Computer Science Degree
3 33 (2.36%) Master's Degree
4 31 (2.22%) CCNA
4 31 (2.22%) Cisco Certification
4 31 (2.22%) Microsoft Certification
5 24 (1.72%) CCNP
5 24 (1.72%) MCSE
6 16 (1.15%) MCP
7 13 (0.93%) CFA
7 13 (0.93%) HND
7 13 (0.93%) Numerate Degree
8 11 (0.79%) MCSA
8 11 (0.79%) PhD
9 9 (0.64%) Security Cleared
10 8 (0.57%) PMI Certification
10 8 (0.57%) PMP
11 7 (0.50%) CEH
11 7 (0.50%) GCIA
11 7 (0.50%) SC Cleared
Quality Assurance & Compliance
1 54 (3.87%) Data Quality
2 42 (3.01%) QA
3 33 (2.36%) GDPR
4 19 (1.36%) SLA
5 12 (0.86%) MiFID
6 5 (0.36%) EMIR
6 5 (0.36%) ISO/IEC 27001
7 4 (0.29%) FATCA
8 3 (0.21%) PMO
9 2 (0.14%) Actionable Recommendations
9 2 (0.14%) IFRS
9 2 (0.14%) IFRS 9
9 2 (0.14%) PCI DSS
10 1 (0.072%) Basel II
10 1 (0.072%) IAS 39
10 1 (0.072%) ISAE 3402
10 1 (0.072%) ISO 9001
10 1 (0.072%) Sarbanes-Oxley
10 1 (0.072%) Solvency II
System Software
1 60 (4.30%) Active Directory
2 23 (1.65%) Virtual Machines
3 12 (0.86%) Docker
4 8 (0.57%) Virtual Desktop
5 3 (0.21%) VMware Infrastructure
6 1 (0.072%) Hyper-V
6 1 (0.072%) Microsoft Virtual Server
6 1 (0.072%) Virtual Servers
Systems Management
1 18 (1.29%) Systems Management Server (SMS)
2 9 (0.64%) Control-M
3 8 (0.57%) SCCM
4 7 (0.50%) QRadar
5 6 (0.43%) Kubernetes
6 3 (0.21%) CSIRT
6 3 (0.21%) WSUS
7 1 (0.072%) Single Sign-On
7 1 (0.072%) Symantec Enterprise Vault
Vendors
1 408 (29.23%) Microsoft
2 183 (13.11%) Oracle
3 167 (11.96%) Tableau
4 79 (5.66%) Cognos
5 62 (4.44%) SAP
6 47 (3.37%) Citrix
7 43 (3.08%) Salesforce.com
8 32 (2.29%) Capita
9 27 (1.93%) Google
10 25 (1.79%) SimCorp
11 22 (1.58%) Alteryx
12 21 (1.50%) Informatica
13 20 (1.43%) IBM
14 17 (1.22%) Anaplan
14 17 (1.22%) Reuters
14 17 (1.22%) Sage
14 17 (1.22%) VMware
15 16 (1.15%) Sybase
15 16 (1.15%) TOWER Software
16 15 (1.07%) Bloomberg