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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
15 Dec 2018
Same period 2017 Same period 2016
Rank 417 443 415
Rank change year-on-year +26 -28 -102
Permanent jobs citing VBA 1,120 1,268 1,352
As % of all permanent IT jobs advertised in the UK 0.71% 0.71% 0.73%
As % of the Programming Languages category 1.29% 1.28% 1.37%
Number of salaries quoted 957 1,072 1,113
UK median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% -2.30%
10th Percentile £27,500 £26,275 £26,800
90th Percentile £75,000 £75,000 £75,000
UK excluding London median annual salary £37,500 £36,000 £37,500
% change year-on-year +4.17% -4.00% +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 86,885 99,197 98,436
As % of all permanent IT jobs advertised in the UK 54.96% 55.28% 53.13%
Number of salaries quoted 72,050 81,939 84,735
UK median annual salary £51,500 £50,000 £47,500
Median salary % change year-on-year +3.00% +5.26% +5.56%
10th Percentile £31,250 £29,250 £28,750
90th Percentile £85,000 £77,500 £76,250
UK excluding London median annual salary £45,000 £42,500 £42,500
% 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 15 December 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 15 December 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 +12 1,039 £47,500 +5.56% 123
London -4 592 £55,000 - 60
UK excluding London +7 506 £37,500 +4.17% 69
North of England +1 145 £37,500 +15.38% 19
South East +7 99 £37,500 -6.25% 9
East of England +30 92 £42,500 +3.66% 17
Midlands +26 82 £32,500 -12.75% 13
North West -12 70 £35,000 +7.69% 10
Yorkshire +46 67 £37,500 +7.14% 9
West Midlands +18 45 £32,000 -14.67% 7
East Midlands +32 37 £37,500 +15.38% 6
Wales +21 37 £35,000 +7.69% 3
South West -4 30 £32,500 -18.75% 5
Scotland +14 21 £37,500 +20.97% 3
North East -7 8 £33,000 +10.00%
Northern Ireland -9 2 - -
Channel Islands - 1 £85,000 -

For the 6 months to 15 December 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 789 (70.45%) SQL
2 681 (60.80%) Microsoft Excel
3 501 (44.73%) Finance
4 467 (41.70%) SQL Server
5 391 (34.91%) C#
6 315 (28.13%) Business Intelligence
7 298 (26.61%) .NET
8 293 (26.16%) Microsoft
9 291 (25.98%) T-SQL
10 235 (20.98%) SQL Server Reporting Services
11 229 (20.45%) Analytical Skills
12 219 (19.55%) Analytics
13 198 (17.68%) Agile Software Development
14 191 (17.05%) Python
15 188 (16.79%) Degree
16 184 (16.43%) Banking
17 180 (16.07%) Problem-Solving
18 176 (15.71%) SQL Server Integration Services
19 165 (14.73%) Oracle
20 160 (14.29%) HTML
21 151 (13.48%) JavaScript
22 146 (13.04%) VB
23 144 (12.86%) VB.NET
24 142 (12.68%) Power BI
25 140 (12.50%) Microsoft Office
26 132 (11.79%) Data Warehouse
27 128 (11.43%) C++
28 120 (10.71%) Data Analysis
29 119 (10.63%) Tableau
30 117 (10.45%) XML

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 87 (7.77%) SharePoint
2 59 (5.27%) SAS
3 51 (4.55%) IIS
4 9 (0.80%) Apache
5 7 (0.63%) Apache Spark
6 5 (0.45%) Confluence
6 5 (0.45%) IBM Notes
7 4 (0.36%) CMS
7 4 (0.36%) Oracle Workflow
8 3 (0.27%) Tomcat
8 3 (0.27%) WebLogic
8 3 (0.27%) WebSphere
8 3 (0.27%) WordPress
9 2 (0.18%) BizTalk Server
9 2 (0.18%) Elasticsearch
9 2 (0.18%) SharePoint 2013
9 2 (0.18%) SharePoint Server
10 1 (0.089%) Exchange Server 2013
10 1 (0.089%) MS Exchange
10 1 (0.089%) SharePoint 2010
Applications
1 681 (60.80%) Microsoft Excel
2 140 (12.50%) Microsoft Office
3 35 (3.13%) Microsoft PowerPoint
4 29 (2.59%) Spreadsheet
5 21 (1.88%) SPSS
6 12 (1.07%) Chatbot
7 6 (0.54%) MS Visio
8 4 (0.36%) Photoshop
9 3 (0.27%) Microsoft Project
10 2 (0.18%) Adobe Illustrator
10 2 (0.18%) LibreOffice
10 2 (0.18%) XMetaL
11 1 (0.089%) Acrobat
11 1 (0.089%) EPLAN
Business Applications
1 31 (2.77%) Cognos TM1
2 17 (1.52%) Cognos Business Intelligence
3 15 (1.34%) Dynamics CRM
4 8 (0.71%) Oracle CRM
5 6 (0.54%) SimCorp Dimension
6 5 (0.45%) Infor SunSystems
7 4 (0.36%) SAP S/4HANA
7 4 (0.36%) SunGard GMI
8 2 (0.18%) Dynamics NAV
8 2 (0.18%) Markit EDM
8 2 (0.18%) Sage 1000
8 2 (0.18%) Sage 500
8 2 (0.18%) SAP ERP
8 2 (0.18%) SAP InfiniteInsight
8 2 (0.18%) Unit4 Business World
9 1 (0.089%) Bloomberg TOMS
9 1 (0.089%) Infor M3
9 1 (0.089%) Remedy ITSM
9 1 (0.089%) Sage 200
9 1 (0.089%) SAP BPC
Cloud Services
1 70 (6.25%) Microsoft Azure
2 25 (2.23%) Office 365
3 19 (1.70%) Amazon AWS
4 16 (1.43%) SaaS
5 12 (1.07%) Dynamics 365
6 8 (0.71%) Salesforce Sales Cloud
7 7 (0.63%) Cloud Computing
7 7 (0.63%) Google Analytics
8 3 (0.27%) Adobe Analytics
8 3 (0.27%) GitHub
8 3 (0.27%) Google Cloud Platform
9 2 (0.18%) Amazon SageMaker
9 2 (0.18%) PaaS
10 1 (0.089%) AdWords
10 1 (0.089%) Azure Machine Learning
10 1 (0.089%) Google Tag Manager
10 1 (0.089%) IaaS
10 1 (0.089%) Slack
10 1 (0.089%) SuccessFactors
10 1 (0.089%) Veeva
Communications & Networking
1 16 (1.43%) HTTP
2 14 (1.25%) TCP/IP
3 13 (1.16%) DNS
4 10 (0.89%) VPN
5 9 (0.80%) MPLS
5 9 (0.80%) SSL
5 9 (0.80%) VLAN
6 8 (0.71%) Firewall
7 7 (0.63%) Internet
8 6 (0.54%) Intranet
9 5 (0.45%) HTTPS
9 5 (0.45%) Remote Desktop
9 5 (0.45%) WebEx
10 4 (0.36%) SMS
11 3 (0.27%) DHCP
11 3 (0.27%) LAN
11 3 (0.27%) WAN
12 2 (0.18%) POP3
12 2 (0.18%) SMTP
12 2 (0.18%) VoIP
Database & Business Intelligence
1 467 (41.70%) SQL Server
2 235 (20.98%) SQL Server Reporting Services
3 176 (15.71%) SQL Server Integration Services
4 142 (12.68%) Power BI
5 132 (11.79%) Data Warehouse
6 114 (10.18%) SQL Server Analysis Services
7 76 (6.79%) MS Access
8 74 (6.61%) Crystal Reports
9 63 (5.63%) QlikView
10 59 (5.27%) Relational Database
11 55 (4.91%) SQL Server 2012
12 53 (4.73%) BusinessObjects
13 45 (4.02%) SQL Server 2008
14 42 (3.75%) MySQL
15 30 (2.68%) Data Mining
16 29 (2.59%) Big Data
16 29 (2.59%) PowerPivot
16 29 (2.59%) Qlik Sense
17 26 (2.32%) NoSQL
17 26 (2.32%) PostgreSQL
Development Applications
1 48 (4.29%) Subversion
1 48 (4.29%) Visual Studio
2 42 (3.75%) Team Foundation Server
3 28 (2.50%) JIRA
4 26 (2.32%) Git (software)
5 18 (1.61%) Eclipse
6 10 (0.89%) Jenkins
7 9 (0.80%) TeamCity
8 8 (0.71%) Maven
8 8 (0.71%) Selenium
9 7 (0.63%) Octopus Deploy
9 7 (0.63%) SonarQube
9 7 (0.63%) SQL Server Management Studio (SSMS)
9 7 (0.63%) Visual Studio Team System
9 7 (0.63%) Visual Studio Tools for Office
10 4 (0.36%) Atlassian Bamboo
11 2 (0.18%) Artifactory
11 2 (0.18%) RStudio
11 2 (0.18%) Xcode
12 1 (0.089%) Oracle Forms
General
1 501 (44.73%) Finance
2 184 (16.43%) Banking
3 115 (10.27%) Front Office
4 58 (5.18%) Investment Banking
5 48 (4.29%) Retail
6 38 (3.39%) Marketing
7 30 (2.68%) Law
8 20 (1.79%) Publishing
9 17 (1.52%) Back Office
9 17 (1.52%) Financial Institution
10 15 (1.34%) Advertising
11 12 (1.07%) Legal
12 11 (0.98%) Telecoms
13 9 (0.80%) Manufacturing
14 7 (0.63%) Spanish Language
15 6 (0.54%) French Language
15 6 (0.54%) Italian Language
16 5 (0.45%) International Banking
17 4 (0.36%) Billing
17 4 (0.36%) Local Government
Job Titles
1 514 (45.89%) Developer
2 379 (33.84%) Analyst
3 126 (11.25%) C# Developer
4 119 (10.63%) SQL Developer
5 115 (10.27%) Data Analyst
6 112 (10.00%) VBA Developer
7 87 (7.77%) .NET Developer
8 75 (6.70%) C# .NET Developer
9 60 (5.36%) SQL Analyst
10 55 (4.91%) Business Intelligence Developer
11 53 (4.73%) Excel Developer
12 51 (4.55%) Senior Analyst
12 51 (4.55%) Software Developer
13 43 (3.84%) Consultant
14 41 (3.66%) Excel VBA Developer
14 41 (3.66%) Senior Developer
15 38 (3.39%) Junior
16 36 (3.21%) Applications Support
17 35 (3.13%) ASP.NET Developer
18 33 (2.95%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 298 (26.61%) .NET
2 160 (14.29%) HTML
3 117 (10.45%) XML
4 92 (8.21%) ASP.NET
5 79 (7.05%) CSS
6 77 (6.88%) .NET Framework
7 43 (3.84%) REST
8 41 (3.66%) ASP.NET MVC
9 33 (2.95%) SOAP
10 26 (2.32%) jQuery
10 26 (2.32%) JSON
11 25 (2.23%) Web Services
12 23 (2.05%) WCF
13 17 (1.52%) AngularJS
13 17 (1.52%) Boost C++ Libraries
13 17 (1.52%) Entity Framework
14 16 (1.43%) WPF
15 14 (1.25%) ADO.NET
16 10 (0.89%) MDX
16 10 (0.89%) XSD
Miscellaneous
1 229 (20.45%) Analytical Skills
2 72 (6.43%) Data Structures
3 71 (6.34%) Management Information System
4 64 (5.71%) Equities
5 53 (4.73%) Self-Motivation
6 51 (4.55%) Derivative
7 48 (4.29%) Algorithms
8 37 (3.30%) Equity Derivative
8 37 (3.30%) Fixed Income
9 27 (2.41%) Foreign Exchange (FX)
10 21 (1.88%) Reference Data
11 20 (1.79%) Credit Risk
12 14 (1.25%) Hedge funds
13 12 (1.07%) Fintech
13 12 (1.07%) User Experience
14 11 (0.98%) Greenfield Project
15 10 (0.89%) Virtual Team
16 9 (0.80%) Enterprise Software
16 9 (0.80%) Market Risk
16 9 (0.80%) Robotics
Operating Systems
1 86 (7.68%) Windows
2 53 (4.73%) Windows Server
3 31 (2.77%) Unix
4 26 (2.32%) Linux
5 15 (1.34%) Windows 7
6 6 (0.54%) Red Hat Enterprise Linux
6 6 (0.54%) Windows 10
6 6 (0.54%) Windows Server 2008
7 5 (0.45%) Android
7 5 (0.45%) Windows Server 2012
8 3 (0.27%) Apple iOS
8 3 (0.27%) Windows 2000
8 3 (0.27%) Windows XP
9 2 (0.18%) Ubuntu
9 2 (0.18%) Windows Embedded Compact
10 1 (0.089%) CentOS
10 1 (0.089%) Windows 8
Processes & Methodologies
1 315 (28.13%) Business Intelligence
2 219 (19.55%) Analytics
3 198 (17.68%) Agile Software Development
4 180 (16.07%) Problem-Solving
5 120 (10.71%) Data Analysis
6 114 (10.18%) ETL
7 95 (8.48%) Visualisation
8 89 (7.95%) Mathematics
8 89 (7.95%) Scrum
9 86 (7.68%) Computer Science
10 82 (7.32%) MVC
11 80 (7.14%) CRM
11 80 (7.14%) Project Management
12 76 (6.79%) Asset Management
12 76 (6.79%) TDD
13 70 (6.25%) Data Modelling
14 68 (6.07%) Data Management
15 66 (5.89%) OO
16 65 (5.80%) Change Management
17 57 (5.09%) Continuous Improvement
Programming Languages
1 789 (70.45%) SQL
2 391 (34.91%) C#
3 291 (25.98%) T-SQL
4 191 (17.05%) Python
5 151 (13.48%) JavaScript
6 146 (13.04%) VB
7 144 (12.86%) VB.NET
8 128 (11.43%) C++
9 80 (7.14%) PL/SQL
10 74 (6.61%) Java
11 68 (6.07%) R
12 56 (5.00%) PHP
13 45 (4.02%) PowerShell
14 32 (2.86%) F#
15 31 (2.77%) Haskell
16 29 (2.59%) Perl
17 22 (1.96%) Shell Script
18 17 (1.52%) C
18 17 (1.52%) VB6
19 15 (1.34%) VBScript
Qualifications
1 188 (16.79%) Degree
2 29 (2.59%) Computer Science Degree
3 24 (2.14%) PhD
4 15 (1.34%) Numerate Degree
5 13 (1.16%) Security Cleared
6 12 (1.07%) SC Cleared
7 10 (0.89%) CFA
7 10 (0.89%) ITIL Certification
8 8 (0.71%) CCNA
8 8 (0.71%) Cisco Certification
8 8 (0.71%) ISEB
8 8 (0.71%) PRINCE2 Certification
9 7 (0.63%) CEH
9 7 (0.63%) CompTIA Security+
9 7 (0.63%) GCIA
9 7 (0.63%) ISTQB
9 7 (0.63%) ISTQB Foundation Certification
9 7 (0.63%) Microsoft Certification
10 6 (0.54%) ACCA
10 6 (0.54%) CIMA
Quality Assurance & Compliance
1 53 (4.73%) Data Quality
2 48 (4.29%) QA
3 21 (1.88%) SLA
4 20 (1.79%) GDPR
5 9 (0.80%) Solvency II
6 4 (0.36%) EMIR
6 4 (0.36%) FATCA
6 4 (0.36%) MiFID
7 3 (0.27%) PCI DSS
8 2 (0.18%) IFRS
8 2 (0.18%) IFRS 9
8 2 (0.18%) ISO 9001
8 2 (0.18%) ISO/IEC 27001
8 2 (0.18%) PMO
9 1 (0.089%) Actionable Recommendations
9 1 (0.089%) Basel II
9 1 (0.089%) IAS 39
System Software
1 37 (3.30%) Active Directory
2 8 (0.71%) Docker
3 4 (0.36%) XenApp
4 2 (0.18%) Virtual Desktop
4 2 (0.18%) VMware Infrastructure
5 1 (0.089%) Hyper-V
Systems Management
1 8 (0.71%) Systems Management Server (SMS)
2 7 (0.63%) HP ALM
2 7 (0.63%) QRadar
3 4 (0.36%) CSIRT
3 4 (0.36%) Kubernetes
4 2 (0.18%) Control-M
4 2 (0.18%) ITRS Geneos
5 1 (0.089%) HP Quality Center
5 1 (0.089%) SCCM
5 1 (0.089%) Symantec Enterprise Vault
Vendors
1 293 (26.16%) Microsoft
2 165 (14.73%) Oracle
3 119 (10.63%) Tableau
4 71 (6.34%) Cognos
5 44 (3.93%) Salesforce.com
6 42 (3.75%) Citrix
7 36 (3.21%) SAP
8 27 (2.41%) IBM
9 23 (2.05%) Adobe
10 21 (1.88%) Alteryx
11 18 (1.61%) Google
12 15 (1.34%) Blue Prism
13 13 (1.16%) Perforce
13 13 (1.16%) UiPath
14 12 (1.07%) Informatica
15 11 (0.98%) Sybase
15 11 (0.98%) Teradata
16 10 (0.89%) MicroStrategy
16 10 (0.89%) VMware
17 9 (0.80%) HP