Period
to 19 October 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 19 October 2018 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
19 Oct 2018
Same period 2017 Same period 2016
Rank 397 422 376
Rank change year-on-year +25 -46 -59
Permanent jobs citing VBA 1,257 1,305 1,583
As % of all permanent IT jobs advertised in the UK 0.76% 0.75% 0.83%
As % of the Programming Languages category 1.37% 1.35% 1.57%
Number of salaries quoted 1,069 1,100 1,286
UK median annual salary £45,000 £45,000 £45,000
10th Percentile £27,000 £26,250 £26,500
90th Percentile £75,000 £78,750 £75,000
UK excluding London median annual salary £37,500 £35,000 £37,500
% change year-on-year +7.14% -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 91,556 96,643 100,918
As % of all permanent IT jobs advertised in the UK 55.57% 55.29% 52.75%
Number of salaries quoted 76,173 79,233 87,041
UK median annual salary £50,000 £48,500 £47,500
Median salary % change year-on-year +3.09% +2.11% +5.56%
10th Percentile £31,250 £29,000 £28,500
90th Percentile £82,500 £77,500 £76,250
UK excluding London median annual salary £45,000 £42,500 £41,000
% change year-on-year +5.88% +3.66% +2.50%

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 19 October 2018.

Salary histogram for VBA in the UK

VBA
Top 16 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 19 October 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 +7 1,174 £45,000 - 161
London +5 662 £52,500 -4.55% 69
UK excluding London +28 567 £37,500 +7.14% 111
North of England +1 150 £35,000 +7.69% 36
South East -6 133 £37,500 +7.14% 18
East of England +36 97 £42,500 +6.25% 5
Midlands +14 88 £33,750 +3.85% 25
North West -16 71 £35,000 +11.11% 19
Yorkshire +22 66 £38,750 +10.71% 17
West Midlands +30 49 £30,000 -20.00% 20
South West -20 43 £32,500 -18.75% 9
East Midlands -2 39 £37,500 +22.95% 5
Wales +29 38 £35,000 +9.38% 7
Scotland +3 20 £37,500 +25.00% 8
North East -4 13 £31,500 +5.00%
Channel Islands - 1 £85,000 -

For the 6 months to 19 October 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 857 (68.18%) SQL
2 763 (60.70%) Microsoft Excel
3 572 (45.51%) Finance
4 538 (42.80%) SQL Server
5 425 (33.81%) C#
6 349 (27.76%) Microsoft
7 335 (26.65%) Business Intelligence
8 325 (25.86%) .NET
9 323 (25.70%) T-SQL
10 279 (22.20%) Analytical Skills
11 253 (20.13%) Degree
11 253 (20.13%) SQL Server Reporting Services
12 242 (19.25%) Agile Software Development
13 220 (17.50%) Analytics
14 211 (16.79%) Problem-Solving
15 207 (16.47%) Banking
16 197 (15.67%) Python
17 187 (14.88%) VB
18 185 (14.72%) SQL Server Integration Services
19 176 (14.00%) Oracle
20 167 (13.29%) VB.NET
21 166 (13.21%) Microsoft Office
22 161 (12.81%) Front Office
23 159 (12.65%) JavaScript
23 159 (12.65%) Power BI
24 153 (12.17%) HTML
25 138 (10.98%) XML
25 138 (10.98%) Tableau
26 137 (10.90%) Data Warehouse
27 135 (10.74%) Data Analysis

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 88 (7.00%) SharePoint
2 68 (5.41%) SAS
3 54 (4.30%) IIS
4 9 (0.72%) Apache
4 9 (0.72%) Apache Spark
4 9 (0.72%) Oracle Workflow
5 7 (0.56%) Exchange Server 2013
6 6 (0.48%) CMS
6 6 (0.48%) WordPress
7 5 (0.40%) IBM Notes
8 4 (0.32%) Exchange Server 2010
8 4 (0.32%) MS Exchange
8 4 (0.32%) SharePoint 2013
9 3 (0.24%) Confluence
9 3 (0.24%) Tomcat
9 3 (0.24%) WebLogic
9 3 (0.24%) WebSphere
10 2 (0.16%) BizTalk Server
10 2 (0.16%) Elasticsearch
10 2 (0.16%) SharePoint Server
Applications
1 763 (60.70%) Microsoft Excel
2 166 (13.21%) Microsoft Office
3 35 (2.78%) Microsoft PowerPoint
3 35 (2.78%) Spreadsheet
4 26 (2.07%) SPSS
5 8 (0.64%) Chatbot
6 5 (0.40%) MS Visio
7 4 (0.32%) Microsoft Project
7 4 (0.32%) Photoshop
8 3 (0.24%) LibreOffice
9 2 (0.16%) Adobe Illustrator
10 1 (0.080%) EPLAN
10 1 (0.080%) Simulink
10 1 (0.080%) Stateflow
10 1 (0.080%) XMetaL
Business Applications
1 37 (2.94%) Cognos TM1
2 28 (2.23%) Cognos Business Intelligence
3 19 (1.51%) SimCorp Dimension
4 18 (1.43%) Dynamics CRM
5 9 (0.72%) Oracle CRM
6 8 (0.64%) Infor SunSystems
7 5 (0.40%) SAP S/4HANA
8 4 (0.32%) Markit EDM
8 4 (0.32%) SunGard GMI
9 3 (0.24%) Elite 3E
10 2 (0.16%) Bloomberg TOMS
10 2 (0.16%) Dynamics AX
10 2 (0.16%) FastStats
10 2 (0.16%) Oracle EBS
10 2 (0.16%) Sage 200
10 2 (0.16%) SAP BPC
10 2 (0.16%) SAP CO
10 2 (0.16%) SAP FI
10 2 (0.16%) SAP FI/CO
10 2 (0.16%) SAP InfiniteInsight
Cloud Services
1 71 (5.65%) Microsoft Azure
2 24 (1.91%) Office 365
3 21 (1.67%) SaaS
4 20 (1.59%) Amazon AWS
5 15 (1.19%) Dynamics 365
6 13 (1.03%) Cloud Computing
7 10 (0.80%) Google Analytics
8 8 (0.64%) Salesforce Sales Cloud
9 4 (0.32%) Google Cloud Platform
10 3 (0.24%) Adobe Analytics
10 3 (0.24%) GitHub
11 2 (0.16%) Amazon SageMaker
12 1 (0.080%) Azure Data Factory
12 1 (0.080%) Azure Machine Learning
12 1 (0.080%) G Suite
12 1 (0.080%) Google Tag Manager
12 1 (0.080%) IaaS
12 1 (0.080%) Slack
12 1 (0.080%) SuccessFactors
Communications & Networking
1 19 (1.51%) HTTP
2 16 (1.27%) Firewall
2 16 (1.27%) TCP/IP
3 14 (1.11%) DNS
4 12 (0.95%) VPN
5 11 (0.88%) MPLS
5 11 (0.88%) SSL
6 10 (0.80%) Intranet
7 9 (0.72%) Remote Desktop
7 9 (0.72%) SMS
8 5 (0.40%) HTTPS
8 5 (0.40%) Internet
8 5 (0.40%) Intrusion Detection
8 5 (0.40%) VLAN
8 5 (0.40%) WebEx
9 3 (0.24%) LAN
9 3 (0.24%) WAN
10 2 (0.16%) IMAP
10 2 (0.16%) POP3
10 2 (0.16%) SMTP
Database & Business Intelligence
1 538 (42.80%) SQL Server
2 253 (20.13%) SQL Server Reporting Services
3 185 (14.72%) SQL Server Integration Services
4 159 (12.65%) Power BI
5 137 (10.90%) Data Warehouse
6 125 (9.94%) SQL Server Analysis Services
7 106 (8.43%) MS Access
8 82 (6.52%) Crystal Reports
9 69 (5.49%) Relational Database
10 59 (4.69%) BusinessObjects
11 53 (4.22%) MySQL
12 50 (3.98%) SQL Server 2008
12 50 (3.98%) SQL Server 2012
13 47 (3.74%) NoSQL
14 43 (3.42%) QlikView
15 36 (2.86%) Data Mining
16 27 (2.15%) Qlik Sense
17 25 (1.99%) Big Data
17 25 (1.99%) Couchbase
17 25 (1.99%) Microsoft Analysis Services
Development Applications
1 76 (6.05%) Team Foundation Server
2 62 (4.93%) Visual Studio
3 40 (3.18%) Git (software)
4 31 (2.47%) Subversion
5 19 (1.51%) Eclipse
6 11 (0.88%) TeamCity
7 9 (0.72%) Jenkins
7 9 (0.72%) Octopus Deploy
7 9 (0.72%) SQL Server Management Studio (SSMS)
7 9 (0.72%) Visual Studio Team System
7 9 (0.72%) Visual Studio Tools for Office
8 8 (0.64%) JIRA
9 7 (0.56%) SonarQube
10 5 (0.40%) Maven
11 4 (0.32%) Atlassian Bamboo
11 4 (0.32%) NUnit
11 4 (0.32%) Xcode
12 3 (0.24%) SpecFlow
13 2 (0.16%) Artifactory
13 2 (0.16%) RStudio
General
1 572 (45.51%) Finance
2 207 (16.47%) Banking
3 161 (12.81%) Front Office
4 55 (4.38%) Marketing
5 50 (3.98%) Investment Banking
5 50 (3.98%) Retail
6 39 (3.10%) Law
7 27 (2.15%) Back Office
8 22 (1.75%) Legal
9 19 (1.51%) Advertising
10 13 (1.03%) Financial Institution
11 12 (0.95%) French Language
12 10 (0.80%) Italian Language
12 10 (0.80%) Manufacturing
12 10 (0.80%) Publishing
12 10 (0.80%) Spanish Language
13 6 (0.48%) Telecoms
14 4 (0.32%) Local Government
15 3 (0.24%) Billing
15 3 (0.24%) Games
Job Titles
1 543 (43.20%) Developer
2 439 (34.92%) Analyst
3 134 (10.66%) Data Analyst
4 132 (10.50%) C# Developer
5 123 (9.79%) SQL Developer
6 115 (9.15%) VBA Developer
7 93 (7.40%) .NET Developer
8 78 (6.21%) C# .NET Developer
9 73 (5.81%) SQL Analyst
10 71 (5.65%) Applications Support
11 63 (5.01%) Business Intelligence Developer
12 58 (4.61%) Junior
13 54 (4.30%) Excel Developer
13 54 (4.30%) Software Developer
14 51 (4.06%) Consultant
15 47 (3.74%) Senior Developer
16 46 (3.66%) Front Office Developer
16 46 (3.66%) Support Analyst
17 45 (3.58%) Analyst Developer
18 39 (3.10%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 325 (25.86%) .NET
2 153 (12.17%) HTML
3 138 (10.98%) XML
4 97 (7.72%) CSS
5 83 (6.60%) ASP.NET
6 82 (6.52%) .NET Framework
7 51 (4.06%) REST
8 43 (3.42%) ASP.NET MVC
9 42 (3.34%) WCF
10 39 (3.10%) SOAP
11 30 (2.39%) jQuery
11 30 (2.39%) Web Services
12 22 (1.75%) JSON
12 22 (1.75%) WPF
13 21 (1.67%) Entity Framework
14 20 (1.59%) AngularJS
15 19 (1.51%) MDX
16 17 (1.35%) WinForms
17 14 (1.11%) ADO.NET
17 14 (1.11%) HTML5
Miscellaneous
1 279 (22.20%) Analytical Skills
2 116 (9.23%) Computer Science
3 83 (6.60%) Management Information System
4 81 (6.44%) Equities
5 72 (5.73%) Derivative
6 52 (4.14%) Data Structures
7 47 (3.74%) Self-Motivation
8 38 (3.02%) Foreign Exchange (FX)
9 35 (2.78%) Algorithms
10 32 (2.55%) Fixed Income
11 30 (2.39%) Equity Derivative
12 21 (1.67%) Hedge funds
13 18 (1.43%) Credit Risk
14 16 (1.27%) User Experience
15 13 (1.03%) Fintech
16 12 (0.95%) Enterprise Software
16 12 (0.95%) Market Risk
16 12 (0.95%) Reference Data
16 12 (0.95%) Virtual Team
17 11 (0.88%) Robotics
Operating Systems
1 125 (9.94%) Windows
2 58 (4.61%) Windows Server
3 37 (2.94%) Windows 7
4 33 (2.63%) Linux
5 20 (1.59%) Unix
6 12 (0.95%) Windows 10
6 12 (0.95%) Windows Server 2008
7 11 (0.88%) Windows Server 2012
8 7 (0.56%) Android
8 7 (0.56%) Red Hat Enterprise Linux
9 6 (0.48%) Apple iOS
10 4 (0.32%) HPUX
11 3 (0.24%) Mac OS X
11 3 (0.24%) Windows 2000
11 3 (0.24%) Windows Embedded Compact
11 3 (0.24%) Windows XP
12 2 (0.16%) Ubuntu
12 2 (0.16%) Windows 8
13 1 (0.080%) Mac OS
13 1 (0.080%) Solaris
Processes & Methodologies
1 335 (26.65%) Business Intelligence
2 242 (19.25%) Agile Software Development
3 220 (17.50%) Analytics
4 211 (16.79%) Problem-Solving
5 135 (10.74%) Data Analysis
6 126 (10.02%) Scrum
7 120 (9.55%) ETL
7 120 (9.55%) Project Management
8 109 (8.67%) Mathematics
9 108 (8.59%) Visualisation
10 104 (8.27%) TDD
11 98 (7.80%) Asset Management
11 98 (7.80%) MVC
12 93 (7.40%) CRM
13 87 (6.92%) Data Modelling
14 84 (6.68%) Business Analysis
15 83 (6.60%) OO
16 79 (6.28%) Change Management
17 76 (6.05%) SDLC
18 72 (5.73%) Continuous Improvement
Programming Languages
1 857 (68.18%) SQL
2 425 (33.81%) C#
3 323 (25.70%) T-SQL
4 197 (15.67%) Python
5 187 (14.88%) VB
6 167 (13.29%) VB.NET
7 159 (12.65%) JavaScript
8 129 (10.26%) C++
9 110 (8.75%) Java
10 79 (6.28%) PL/SQL
11 74 (5.89%) PowerShell
12 71 (5.65%) R
13 57 (4.53%) PHP
14 42 (3.34%) C
15 33 (2.63%) Perl
16 26 (2.07%) F#
17 24 (1.91%) Haskell
18 23 (1.83%) MATLAB
19 18 (1.43%) VB6
19 18 (1.43%) VBScript
Qualifications
1 253 (20.13%) Degree
2 43 (3.42%) Computer Science Degree
3 18 (1.43%) PhD
4 16 (1.27%) Numerate Degree
5 15 (1.19%) CCNA
5 15 (1.19%) Cisco Certification
6 11 (0.88%) Microsoft Certification
7 10 (0.80%) CFA
7 10 (0.80%) Master's Degree
8 9 (0.72%) CEH
8 9 (0.72%) CompTIA Security+
8 9 (0.72%) GCIA
8 9 (0.72%) MCSE
9 8 (0.64%) HND
10 7 (0.56%) SC Cleared
10 7 (0.56%) Security Cleared
11 6 (0.48%) CCNP
11 6 (0.48%) ITIL Certification
12 4 (0.32%) MOS
12 4 (0.32%) PRINCE2 Certification
Quality Assurance & Compliance
1 47 (3.74%) QA
2 44 (3.50%) Data Quality
3 30 (2.39%) GDPR
4 20 (1.59%) SLA
5 10 (0.80%) MiFID
6 4 (0.32%) EMIR
6 4 (0.32%) FATCA
6 4 (0.32%) PMO
7 3 (0.24%) ISO/IEC 27001
7 3 (0.24%) PCI DSS
8 2 (0.16%) IFRS
8 2 (0.16%) IFRS 9
8 2 (0.16%) ISO 9001
8 2 (0.16%) Solvency II
9 1 (0.080%) Actionable Recommendations
9 1 (0.080%) Basel II
9 1 (0.080%) IAS 39
9 1 (0.080%) ISAE 3402
9 1 (0.080%) Sarbanes-Oxley
System Software
1 47 (3.74%) Active Directory
2 12 (0.95%) Docker
3 5 (0.40%) Virtual Machines
4 4 (0.32%) Virtual Desktop
5 3 (0.24%) XenApp
6 2 (0.16%) VMware Infrastructure
7 1 (0.080%) Hyper-V
Systems Management
1 10 (0.80%) Systems Management Server (SMS)
2 9 (0.72%) QRadar
3 6 (0.48%) Kubernetes
4 5 (0.40%) CSIRT
5 4 (0.32%) Control-M
6 3 (0.24%) SCCM
6 3 (0.24%) WSUS
7 1 (0.080%) HP Quality Center
7 1 (0.080%) Single Sign-On
7 1 (0.080%) Symantec Enterprise Vault
Vendors
1 349 (27.76%) Microsoft
2 176 (14.00%) Oracle
3 138 (10.98%) Tableau
4 86 (6.84%) Cognos
5 48 (3.82%) Salesforce.com
6 45 (3.58%) Citrix
7 41 (3.26%) SAP
8 24 (1.91%) Alteryx
9 22 (1.75%) IBM
10 20 (1.59%) Google
11 19 (1.51%) SimCorp
12 17 (1.35%) Blue Prism
13 15 (1.19%) Sybase
14 14 (1.11%) Adobe
15 12 (0.95%) Anaplan
15 12 (0.95%) MicroStrategy
16 11 (0.88%) Bloomberg
16 11 (0.88%) Fidessa
16 11 (0.88%) Informatica
17 10 (0.80%) VMware