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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
19 Apr 2018
Same period 2017 Same period 2016
Rank 377 399 360
Rank change year-on-year +22 -39 -46
Permanent jobs citing VBA 1,414 1,316 1,870
As % of all permanent IT jobs advertised in the UK 0.80% 0.77% 0.91%
As % of the Programming Languages category 1.42% 1.40% 1.75%
Number of salaries quoted 1,212 1,112 1,578
UK median annual salary £45,000 £42,500 £42,500
Median salary % change year-on-year +5.88% - -
10th Percentile £27,500 £27,000 £26,250
90th Percentile £70,000 £71,750 £66,250
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 99,433 93,828 106,577
As % of all permanent IT jobs advertised in the UK 56.08% 54.55% 52.00%
Number of salaries quoted 83,625 80,109 91,971
UK median annual salary £50,000 £47,500 £46,000
Median salary % change year-on-year +5.26% +3.26% +2.22%
10th Percentile £30,000 £28,750 £28,000
90th Percentile £78,750 £76,250 £75,000
UK excluding London median annual salary £44,000 £42,500 £40,000
% change year-on-year +3.53% +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 19 April 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 April 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 +28 1,344 £45,000 +5.88% 157
London +37 755 £52,500 - 76
UK excluding London -7 647 £37,500 +7.14% 93
North of England +1 200 £35,000 - 12
East of England +64 135 £42,000 +18.31% 14
North West +7 130 £37,500 +10.29% 6
South East -43 126 £42,500 +21.43% 22
Midlands -10 94 £32,500 - 28
West Midlands -7 66 £35,000 -4.11% 14
Yorkshire -20 56 £30,000 -14.29% 6
South West -53 37 £42,500 +21.43% 5
East Midlands -13 28 £32,250 +5.74% 14
Scotland -41 26 £45,000 +55.17% 9
Wales +14 22 £35,000 +22.81% 2
North East -14 14 £30,000 -25.00%
Northern Ireland +11 9 £29,000 +48.72% 1

For the 6 months to 19 April 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 979 (69.24%) SQL
2 857 (60.61%) Microsoft Excel
3 655 (46.32%) Finance
4 558 (39.46%) SQL Server
5 425 (30.06%) Microsoft
6 399 (28.22%) .NET
7 374 (26.45%) C#
8 359 (25.39%) Business Intelligence
9 319 (22.56%) Analytical Skills
10 291 (20.58%) Degree
11 280 (19.80%) SQL Server Reporting Services
12 277 (19.59%) Agile Software Development
13 270 (19.09%) Analytics
14 259 (18.32%) T-SQL
15 213 (15.06%) Oracle
16 212 (14.99%) Problem-Solving
17 193 (13.65%) Python
18 190 (13.44%) SQL Server Integration Services
19 184 (13.01%) Windows
20 179 (12.66%) Microsoft Office
21 174 (12.31%) Tableau
22 171 (12.09%) VB
23 165 (11.67%) XML
24 162 (11.46%) Banking
25 158 (11.17%) Data Analysis
26 147 (10.40%) HTML
27 141 (9.97%) MS Access
28 140 (9.90%) Data Modelling
28 140 (9.90%) JavaScript
29 136 (9.62%) Visualisation

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 106 (7.50%) SAS
2 75 (5.30%) SharePoint
3 66 (4.67%) IIS
4 54 (3.82%) Confluence
5 20 (1.41%) Oracle Workflow
6 19 (1.34%) Apache Spark
7 12 (0.85%) Apache
8 11 (0.78%) CMS
9 9 (0.64%) WordPress
10 8 (0.57%) Exchange Server 2013
11 7 (0.50%) Elasticsearch
11 7 (0.50%) MS Project Server
12 6 (0.42%) Apache Pig
12 6 (0.42%) DataSynapse
13 5 (0.35%) BizTalk Server
13 5 (0.35%) SharePoint Server
14 3 (0.21%) MS Exchange
14 3 (0.21%) SharePoint 2013
14 3 (0.21%) Tomcat
15 2 (0.14%) WebLogic
Applications
1 857 (60.61%) Microsoft Excel
2 179 (12.66%) Microsoft Office
3 66 (4.67%) Spreadsheet
4 61 (4.31%) Microsoft PowerPoint
5 34 (2.40%) SPSS
6 31 (2.19%) MS Visio
7 27 (1.91%) Microsoft Project
8 4 (0.28%) EViews
9 3 (0.21%) AutoCAD
9 3 (0.21%) XMetaL
10 1 (0.071%) Abaqus
10 1 (0.071%) Adobe Illustrator
10 1 (0.071%) CATIA
10 1 (0.071%) Photoshop
10 1 (0.071%) Siemens NX
10 1 (0.071%) Stata
Business Applications
1 30 (2.12%) Elite 3E
2 16 (1.13%) Infor SunSystems
3 15 (1.06%) Workfront
4 14 (0.99%) Cognos TM1
4 14 (0.99%) Dynamics CRM
5 11 (0.78%) Dynamics GP
5 11 (0.78%) Oracle Financials
5 11 (0.78%) SAP InfiniteInsight
6 10 (0.71%) HFM
7 9 (0.64%) CA PPM
7 9 (0.64%) SAP ERP
7 9 (0.64%) SimCorp Dimension
7 9 (0.64%) Unica
8 8 (0.57%) Adobe Campaign
8 8 (0.57%) Summit
9 7 (0.50%) SAP Business One
10 6 (0.42%) Oracle EBS
11 5 (0.35%) SAP BPC
12 4 (0.28%) Cognos Business Intelligence
12 4 (0.28%) Markit EDM
Cloud Services
1 71 (5.02%) Microsoft Azure
2 37 (2.62%) Amazon AWS
3 22 (1.56%) SaaS
4 20 (1.41%) Cloud Computing
5 17 (1.20%) Google Analytics
6 15 (1.06%) Salesforce Sales Cloud
6 15 (1.06%) Salesforce Service Cloud
7 13 (0.92%) Office 365
8 7 (0.50%) Google Cloud Platform
9 6 (0.42%) Azure Data Factory
10 4 (0.28%) Adobe Analytics
10 4 (0.28%) Bluemix
10 4 (0.28%) IBM Cloud
11 2 (0.14%) Amazon S3
11 2 (0.14%) Slack
12 1 (0.071%) AdWords
12 1 (0.071%) Azure Active Directory
12 1 (0.071%) Google Tag Manager
Communications & Networking
1 24 (1.70%) Firewall
1 24 (1.70%) VPN
2 18 (1.27%) Intranet
3 16 (1.13%) Intrusion Detection
4 8 (0.57%) SMS
5 7 (0.50%) DNS
5 7 (0.50%) Wireshark
6 6 (0.42%) Telnet
7 5 (0.35%) FTP
7 5 (0.35%) Remote Desktop
8 4 (0.28%) Extranet
8 4 (0.28%) WAN
9 3 (0.21%) LAN
10 2 (0.14%) HTTP
10 2 (0.14%) Internet
10 2 (0.14%) TCP/IP
11 1 (0.071%) ADSL
11 1 (0.071%) Broadband
11 1 (0.071%) SMTP
11 1 (0.071%) WLAN
Database & Business Intelligence
1 558 (39.46%) SQL Server
2 280 (19.80%) SQL Server Reporting Services
3 190 (13.44%) SQL Server Integration Services
4 141 (9.97%) MS Access
5 136 (9.62%) Power BI
6 121 (8.56%) Data Warehouse
7 89 (6.29%) SQL Server Analysis Services
8 83 (5.87%) Crystal Reports
9 80 (5.66%) SQL Server 2008
10 78 (5.52%) Relational Database
11 70 (4.95%) MySQL
12 69 (4.88%) NoSQL
13 67 (4.74%) QlikView
14 59 (4.17%) BusinessObjects
15 52 (3.68%) SQL Server 2012
16 42 (2.97%) Big Data
16 42 (2.97%) Oracle Reports
17 33 (2.33%) MongoDB
17 33 (2.33%) SQL Server 2016
18 31 (2.19%) Qlik Sense
Development Applications
1 102 (7.21%) Team Foundation Server
2 88 (6.22%) JIRA
3 62 (4.38%) Visual Studio
4 55 (3.89%) Git (software)
5 36 (2.55%) Visual Studio Tools for Office
6 31 (2.19%) Subversion
7 14 (0.99%) SQL Server Management Studio (SSMS)
8 12 (0.85%) Eclipse
8 12 (0.85%) Jenkins
9 9 (0.64%) Axure RP
9 9 (0.64%) SpecFlow
10 6 (0.42%) Bitbucket
10 6 (0.42%) NUnit
10 6 (0.42%) SonarQube
10 6 (0.42%) Visual Studio Team System
11 4 (0.28%) Artifactory
11 4 (0.28%) RStudio
12 2 (0.14%) dotCover
12 2 (0.14%) dotTrace
12 2 (0.14%) ReSharper
General
1 655 (46.32%) Finance
2 162 (11.46%) Banking
3 125 (8.84%) Front Office
4 100 (7.07%) Marketing
5 64 (4.53%) Retail
6 45 (3.18%) Legal
7 40 (2.83%) Investment Banking
8 36 (2.55%) Law
9 31 (2.19%) Back Office
10 25 (1.77%) Advertising
11 18 (1.27%) Financial Institution
12 14 (0.99%) Local Government
13 12 (0.85%) French Language
13 12 (0.85%) Telecoms
14 11 (0.78%) Italian Language
14 11 (0.78%) Spanish Language
15 9 (0.64%) Retail Banking
16 8 (0.57%) German Language
17 7 (0.50%) Billing
17 7 (0.50%) Manufacturing
Job Titles
1 621 (43.92%) Developer
2 483 (34.16%) Analyst
3 157 (11.10%) Data Analyst
4 150 (10.61%) C# Developer
5 135 (9.55%) SQL Developer
6 98 (6.93%) VBA Developer
7 94 (6.65%) .NET Developer
7 94 (6.65%) Consultant
8 92 (6.51%) Business Intelligence Developer
9 75 (5.30%) SQL Analyst
10 74 (5.23%) Junior
11 66 (4.67%) Software Developer
12 61 (4.31%) Business Intelligence Analyst
13 57 (4.03%) Excel Developer
14 55 (3.89%) Report Analyst
15 53 (3.75%) Applications Support
15 53 (3.75%) Systems Developer
16 51 (3.61%) C# .NET Developer
17 46 (3.25%) Junior Developer
18 45 (3.18%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 399 (28.22%) .NET
2 165 (11.67%) XML
3 147 (10.40%) HTML
4 105 (7.43%) .NET Framework
4 105 (7.43%) ASP.NET
5 95 (6.72%) CSS
6 73 (5.16%) AngularJS
7 68 (4.81%) WPF
8 59 (4.17%) JSON
8 59 (4.17%) Web Services
9 50 (3.54%) WCF
10 46 (3.25%) WinForms
11 35 (2.48%) jQuery
12 31 (2.19%) REST
13 30 (2.12%) EDI
14 29 (2.05%) HTML5
15 27 (1.91%) ASP.NET MVC
16 25 (1.77%) D3.js
17 23 (1.63%) ASP.NET Web API
18 22 (1.56%) Twitter Bootstrap
Miscellaneous
1 319 (22.56%) Analytical Skills
2 127 (8.98%) Computer Science
3 105 (7.43%) Management Information System
4 61 (4.31%) Self-Motivation
5 53 (3.75%) Equities
6 43 (3.04%) Fixed Income
7 42 (2.97%) Derivative
8 30 (2.12%) Data Structures
9 28 (1.98%) Enterprise Software
10 27 (1.91%) Foreign Exchange (FX)
11 23 (1.63%) Fintech
11 23 (1.63%) User Experience
12 21 (1.49%) Greenfield Project
13 20 (1.41%) Hedge funds
14 19 (1.34%) Mobile App
14 19 (1.34%) Reinsurance
15 18 (1.27%) Cybercrime
16 17 (1.20%) Algorithms
17 16 (1.13%) Virtual Team
18 15 (1.06%) Driving Licence
Operating Systems
1 184 (13.01%) Windows
2 99 (7.00%) Linux
3 85 (6.01%) Windows Server
4 79 (5.59%) Unix
5 22 (1.56%) Windows Server 2008
5 22 (1.56%) Windows Server 2012
6 20 (1.41%) Windows 7
7 14 (0.99%) Android
8 11 (0.78%) Apple iOS
9 7 (0.50%) Windows 10
10 4 (0.28%) Mac OS X
11 3 (0.21%) CentOS
11 3 (0.21%) OS/400
12 1 (0.071%) HPUX
12 1 (0.071%) Windows Embedded Compact
Processes & Methodologies
1 359 (25.39%) Business Intelligence
2 277 (19.59%) Agile Software Development
3 270 (19.09%) Analytics
4 212 (14.99%) Problem-Solving
5 158 (11.17%) Data Analysis
6 140 (9.90%) Data Modelling
7 136 (9.62%) Visualisation
8 118 (8.35%) CRM
8 118 (8.35%) Scrum
9 110 (7.78%) Project Management
10 108 (7.64%) Mathematics
11 106 (7.50%) Continuous Improvement
12 100 (7.07%) ETL
13 95 (6.72%) SDLC
14 88 (6.22%) Asset Management
14 88 (6.22%) ERP
15 85 (6.01%) Data Analytics
16 77 (5.45%) Data Management
17 76 (5.37%) OO
18 73 (5.16%) Risk Management
Programming Languages
1 979 (69.24%) SQL
2 374 (26.45%) C#
3 259 (18.32%) T-SQL
4 193 (13.65%) Python
5 171 (12.09%) VB
6 140 (9.90%) JavaScript
7 131 (9.26%) VB.NET
8 129 (9.12%) Java
9 110 (7.78%) R
10 105 (7.43%) PowerShell
11 87 (6.15%) C++
11 87 (6.15%) PHP
12 64 (4.53%) C
13 52 (3.68%) Perl
13 52 (3.68%) PL/SQL
14 23 (1.63%) MATLAB
15 18 (1.27%) VB6
16 17 (1.20%) VBScript
17 15 (1.06%) Apex Code
18 9 (0.64%) Bash Shell
Qualifications
1 291 (20.58%) Degree
2 54 (3.82%) Computer Science Degree
3 38 (2.69%) Microsoft Certification
4 33 (2.33%) Master's Degree
5 28 (1.98%) MCP
5 28 (1.98%) MCSE
6 23 (1.63%) Security Cleared
7 22 (1.56%) MCSA
7 22 (1.56%) PhD
8 18 (1.27%) CCNA
8 18 (1.27%) CCNP
8 18 (1.27%) Cisco Certification
9 15 (1.06%) SC Cleared
10 13 (0.92%) ACCA
11 11 (0.78%) CIMA
11 11 (0.78%) PMP
12 10 (0.71%) Numerate Degree
13 9 (0.64%) PMI Certification
14 7 (0.50%) CBAP
15 6 (0.42%) CFA
Quality Assurance & Compliance
1 94 (6.65%) Data Quality
2 44 (3.11%) QA
3 16 (1.13%) GDPR
3 16 (1.13%) Solvency II
4 12 (0.85%) PMO
5 10 (0.71%) SLA
6 5 (0.35%) MiFID
7 3 (0.21%) EMIR
7 3 (0.21%) ISO 9001
7 3 (0.21%) ISO/IEC 27001
8 2 (0.14%) GAAP
9 1 (0.071%) Actionable Recommendations
9 1 (0.071%) Disclosure Scotland
9 1 (0.071%) ISAE 3402
9 1 (0.071%) ISO/IEC 20000
9 1 (0.071%) Sarbanes-Oxley
System Software
1 70 (4.95%) Active Directory
2 18 (1.27%) Virtual Machines
3 8 (0.57%) Docker
4 6 (0.42%) Virtual Desktop
5 5 (0.35%) HDFS
6 3 (0.21%) VMware Infrastructure
7 1 (0.071%) Microsoft Virtual Server
7 1 (0.071%) Virtual Servers
Systems Management
1 13 (0.92%) Systems Management Server (SMS)
2 7 (0.50%) Control-M
3 5 (0.35%) SCCM
4 3 (0.21%) Kubernetes
5 2 (0.14%) EnCase
5 2 (0.14%) FTK
5 2 (0.14%) WMI
6 1 (0.071%) Forefront Identity Manager
6 1 (0.071%) Graylog
6 1 (0.071%) Kibana
6 1 (0.071%) Nagios
6 1 (0.071%) Oracle Identity Management
Vendors
1 425 (30.06%) Microsoft
2 213 (15.06%) Oracle
3 174 (12.31%) Tableau
4 71 (5.02%) SAP
5 63 (4.46%) Cognos
6 51 (3.61%) Citrix
7 39 (2.76%) Capita
8 38 (2.69%) Informatica
9 36 (2.55%) VMware
10 35 (2.48%) Google
11 33 (2.33%) IBM
12 31 (2.19%) Salesforce.com
13 23 (1.63%) Reuters
14 22 (1.56%) Intapp
15 21 (1.49%) Alteryx
15 21 (1.49%) Veeam
16 18 (1.27%) Infor
16 18 (1.27%) Xamarin
17 16 (1.13%) Bloomberg
17 16 (1.13%) TOWER Software