Period
to 19 November 2017

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 November 2017 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 424 399 305
Rank change year-on-year -25 -94 -8
Permanent jobs citing VBA 1297 1454 2328
As % of all permanent IT jobs advertised in the UK 0.73% 0.77% 1.07%
As % of the Programming Languages category 1.31% 1.46% 2.06%
Number of salaries quoted 1102 1194 1903
UK median annual salary £45,000 £45,000 £45,000
10th Percentile £26,250 £27,500 £26,250
90th Percentile £77,375 £75,000 £75,000
UK excluding London median annual salary £35,000 £37,500 £35,000
% change year-on-year -6.67% +7.14% +7.69%

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 98643 99721 112937
As % of all permanent IT jobs advertised in the UK 55.34% 52.86% 51.67%
Number of salaries quoted 81151 86001 96555
UK median annual salary £49,500 £47,500 £45,000
Median salary % change year-on-year +4.21% +5.56% +2.27%
10th Percentile £29,000 £28,500 £27,500
90th Percentile £77,500 £76,250 £75,000
UK excluding London median annual salary £42,500 £41,500 £40,000
% change year-on-year +2.41% +3.75% +1.27%

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 November 2017.

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 November 2017. 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 1253 £45,000 - 60
London +7 716 £55,000 - 38
UK excluding London -36 570 £35,000 -6.67% 27
North of England -40 173 £32,500 -13.33% 6
South East +20 121 £36,000 -10.00% 5
Midlands +28 104 £35,000 +7.69% 3
North West -37 94 £32,500 -13.33% 2
East of England -22 85 £40,000 - 8
Yorkshire +1 66 £35,000 - 4
West Midlands +13 65 £39,000 +24.80% 2
South West +14 54 £40,000 +23.08%
East Midlands +30 39 £31,000 -22.50% 1
Scotland -16 15 £27,000 -32.50% 1
Wales +19 13 £32,000 +13.67% 2
North East +12 13 £30,000 -25.00%
Northern Ireland - 5 £29,000 - 2

For the 6 months to 19 November 2017, IT jobs citing VBA also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for VBA.

1 977 (75.33%) SQL
2 799 (61.60%) Microsoft Excel
3 606 (46.72%) Finance
4 478 (36.85%) SQL Server
5 375 (28.91%) Microsoft
6 303 (23.36%) C#
7 293 (22.59%) Business Intelligence
8 287 (22.13%) Analytics
9 285 (21.97%) .NET
10 281 (21.67%) Degree
11 275 (21.20%) Analytical Skills
12 212 (16.35%) SQL Server Reporting Services
13 209 (16.11%) Oracle
14 187 (14.42%) T-SQL
15 176 (13.57%) Python
16 170 (13.11%) Data Analysis
17 164 (12.64%) SQL Server Integration Services
17 164 (12.64%) Mathematics
18 157 (12.10%) Front Office
19 156 (12.03%) Windows
20 155 (11.95%) Tableau
21 152 (11.72%) Java
22 142 (10.95%) HTML
23 141 (10.87%) Banking
24 140 (10.79%) MS Access
25 139 (10.72%) VB
26 138 (10.64%) JavaScript
26 138 (10.64%) Microsoft Office
26 138 (10.64%) Marketing
27 136 (10.49%) Power BI

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 101 (7.79%) SAS
2 70 (5.40%) SharePoint
3 33 (2.54%) IIS
4 19 (1.46%) Apache Spark
5 14 (1.08%) Confluence
5 14 (1.08%) MS Exchange
6 13 (1.00%) BizTalk Server
7 12 (0.93%) Oracle Workflow
8 11 (0.85%) Oracle SOA Suite
9 9 (0.69%) Apache
10 7 (0.54%) Exchange Server 2013
10 7 (0.54%) SharePoint 2013
11 6 (0.46%) Exchange Server 2010
12 5 (0.39%) CMS
13 4 (0.31%) Exchange Server 2007
13 4 (0.31%) JBoss
13 4 (0.31%) Joomla!
13 4 (0.31%) SharePoint 2010
13 4 (0.31%) WebLogic
13 4 (0.31%) WebSphere
Applications
1 799 (61.60%) Microsoft Excel
2 138 (10.64%) Microsoft Office
3 54 (4.16%) Microsoft PowerPoint
4 39 (3.01%) Spreadsheet
4 39 (3.01%) SPSS
5 22 (1.70%) MS Visio
6 11 (0.85%) Microsoft Project
7 10 (0.77%) S-PLUS
8 8 (0.62%) XMetaL
9 4 (0.31%) Doxygen
10 2 (0.15%) AutoCAD
10 2 (0.15%) Photoshop
11 1 (0.077%) LaTeX
Business Applications
1 19 (1.46%) Dynamics CRM
2 17 (1.31%) SAP InfiniteInsight
3 16 (1.23%) Dynamics GP
4 15 (1.16%) SAP ERP
5 12 (0.93%) HFM
6 9 (0.69%) Cognos TM1
7 8 (0.62%) Endur
8 6 (0.46%) SAP BPC
9 5 (0.39%) Dynamics AX
9 5 (0.39%) ReMetrica
9 5 (0.39%) SAP Business ByDesign
9 5 (0.39%) SAP Business One
10 4 (0.31%) Dynamics NAV
10 4 (0.31%) Oracle Financials
11 3 (0.23%) Aligne
11 3 (0.23%) Bloomberg TOMS
12 2 (0.15%) Misys Opics
12 2 (0.15%) SAP FI
12 2 (0.15%) thinkFolio
12 2 (0.15%) Visualfiles
Cloud Services
1 35 (2.70%) Microsoft Azure
2 34 (2.62%) Office 365
3 30 (2.31%) Amazon AWS
4 21 (1.62%) SaaS
5 17 (1.31%) Google Analytics
6 9 (0.69%) GitHub
7 5 (0.39%) Amazon SQS
8 4 (0.31%) Adobe Analytics
8 4 (0.31%) PaaS
9 3 (0.23%) Cloud Computing
10 2 (0.15%) Dynamics 365
10 2 (0.15%) Google Tag Manager
10 2 (0.15%) Oracle Service Cloud
11 1 (0.077%) Google Cloud Platform
11 1 (0.077%) Slack
Communications & Networking
1 22 (1.70%) Intranet
2 17 (1.31%) DNS
3 14 (1.08%) Firewall
4 9 (0.69%) VPN
5 8 (0.62%) FTP
6 5 (0.39%) Internet
6 5 (0.39%) LAN
6 5 (0.39%) TCP/IP
7 4 (0.31%) SMS
7 4 (0.31%) Wi-Fi
8 3 (0.23%) DSL
8 3 (0.23%) NAS
8 3 (0.23%) Remote Desktop
8 3 (0.23%) WebEx
9 2 (0.15%) Cisco IOS
9 2 (0.15%) DHCP
9 2 (0.15%) Softphone
9 2 (0.15%) VoIP
9 2 (0.15%) WAN
10 1 (0.077%) Ethernet
Database & Business Intelligence
1 478 (36.85%) SQL Server
2 212 (16.35%) SQL Server Reporting Services
3 164 (12.64%) SQL Server Integration Services
4 140 (10.79%) MS Access
5 136 (10.49%) Power BI
6 119 (9.18%) QlikView
7 108 (8.33%) Data Warehouse
8 81 (6.25%) SQL Server Analysis Services
9 60 (4.63%) MySQL
10 58 (4.47%) Relational Database
11 54 (4.16%) BusinessObjects
12 48 (3.70%) Hadoop
13 42 (3.24%) Data Mining
14 40 (3.08%) Crystal Reports
15 38 (2.93%) NoSQL
16 36 (2.78%) SQL Server 2012
17 32 (2.47%) SQL Server 2008
17 32 (2.47%) SQL Server 2014
18 31 (2.39%) Apache Hive
19 28 (2.16%) Oracle Database
Development Applications
1 59 (4.55%) Team Foundation Server
2 44 (3.39%) Visual Studio
3 38 (2.93%) Eclipse
4 30 (2.31%) Subversion
5 28 (2.16%) JIRA
6 26 (2.00%) Git (software)
7 24 (1.85%) SQL Server Management Studio (SSMS)
8 23 (1.77%) Jenkins
9 15 (1.16%) Artifactory
9 15 (1.16%) InstallShield
10 6 (0.46%) Oracle Forms
11 4 (0.31%) LoadRunner
11 4 (0.31%) Maven
11 4 (0.31%) Talend Open Studio
11 4 (0.31%) Visual Studio Tools for Office
12 3 (0.23%) GCC
12 3 (0.23%) GDB
12 3 (0.23%) NUnit
12 3 (0.23%) SpecFlow
12 3 (0.23%) TeamCity
General
1 606 (46.72%) Finance
2 157 (12.10%) Front Office
3 141 (10.87%) Banking
4 138 (10.64%) Marketing
5 54 (4.16%) Retail
6 41 (3.16%) Legal
7 37 (2.85%) Investment Banking
8 32 (2.47%) Back Office
9 24 (1.85%) Law
10 23 (1.77%) Advertising
10 23 (1.77%) Manufacturing
11 15 (1.16%) Publishing
11 15 (1.16%) Telecoms
12 14 (1.08%) Financial Institution
13 11 (0.85%) Billing
14 9 (0.69%) Games
14 9 (0.69%) Retail Banking
15 7 (0.54%) Electronics
16 6 (0.46%) French Language
16 6 (0.46%) German Language
Job Titles
1 529 (40.79%) Developer
2 514 (39.63%) Analyst
3 167 (12.88%) Data Analyst
4 159 (12.26%) SQL Developer
5 136 (10.49%) SQL Analyst
6 89 (6.86%) C# Developer
7 88 (6.78%) Consultant
8 79 (6.09%) VBA Developer
9 74 (5.71%) .NET Developer
10 69 (5.32%) Applications Support
10 69 (5.32%) Business Intelligence Developer
11 68 (5.24%) Support Analyst
12 63 (4.86%) Junior
13 60 (4.63%) Software Developer
14 56 (4.32%) SQL Data Analyst
15 47 (3.62%) Report Analyst
15 47 (3.62%) Systems Developer
16 46 (3.55%) Business Intelligence Analyst
17 42 (3.24%) Applications Support Analyst
18 41 (3.16%) Analyst Developer
Libraries, Frameworks & Software Standards
1 285 (21.97%) .NET
2 142 (10.95%) HTML
3 96 (7.40%) XML
4 83 (6.40%) ASP.NET
5 81 (6.25%) CSS
6 75 (5.78%) .NET Framework
6 75 (5.78%) AngularJS
7 57 (4.39%) REST
8 56 (4.32%) Web Services
9 44 (3.39%) React
10 34 (2.62%) HTML5
11 32 (2.47%) MDX
12 30 (2.31%) jQuery
13 29 (2.24%) Node.js
13 29 (2.24%) WPF
14 22 (1.70%) ASP.NET MVC
14 22 (1.70%) SOAP
15 19 (1.46%) Ajax
16 17 (1.31%) Classic ASP
16 17 (1.31%) FIX Protocol
Miscellaneous
1 275 (21.20%) Analytical Skills
2 121 (9.33%) Computer Science
3 84 (6.48%) Fixed Income
4 69 (5.32%) Management Information System
5 61 (4.70%) Derivative
6 59 (4.55%) Foreign Exchange (FX)
7 41 (3.16%) Equities
8 35 (2.70%) Credit Risk
9 30 (2.31%) Data Structures
10 21 (1.62%) Reinsurance
11 20 (1.54%) Algorithms
12 15 (1.16%) Hedge funds
13 13 (1.00%) Mobile App
14 11 (0.85%) Reference Data
15 10 (0.77%) Enterprise Software
15 10 (0.77%) Greenfield Project
16 8 (0.62%) Equity Derivative
16 8 (0.62%) NHS
16 8 (0.62%) Semantic Web
17 7 (0.54%) AS400
Operating Systems
1 156 (12.03%) Windows
2 78 (6.01%) Linux
3 76 (5.86%) Unix
4 52 (4.01%) Windows Server
5 21 (1.62%) Windows Server 2008
6 19 (1.46%) Windows Server 2012
7 16 (1.23%) Android
8 15 (1.16%) Apple iOS
9 12 (0.93%) Windows 7
10 10 (0.77%) Windows 10
11 5 (0.39%) Windows Vista
12 4 (0.31%) openSUSE
12 4 (0.31%) Red Hat Enterprise Linux
12 4 (0.31%) SUSE
12 4 (0.31%) VMS
13 3 (0.23%) Solaris
14 2 (0.15%) Windows 8
15 1 (0.077%) CentOS
15 1 (0.077%) Mac OS
15 1 (0.077%) Windows Server 2003
Processes & Methodologies
1 293 (22.59%) Business Intelligence
2 287 (22.13%) Analytics
3 170 (13.11%) Data Analysis
4 164 (12.64%) Mathematics
5 131 (10.10%) Agile Software Development
6 121 (9.33%) ETL
7 114 (8.79%) Data Modelling
8 104 (8.02%) Visualisation
9 92 (7.09%) Data Analytics
10 83 (6.40%) ERP
11 74 (5.71%) Stakeholder Management
12 72 (5.55%) Asset Management
13 70 (5.40%) Project Management
14 66 (5.09%) Statistics
15 60 (4.63%) CRM
16 57 (4.39%) Data Management
17 56 (4.32%) OO
18 54 (4.16%) Business Analysis
18 54 (4.16%) Data Visualisation
19 52 (4.01%) Investment Management
Programming Languages
1 977 (75.33%) SQL
2 303 (23.36%) C#
3 187 (14.42%) T-SQL
4 176 (13.57%) Python
5 152 (11.72%) Java
6 139 (10.72%) VB
7 138 (10.64%) JavaScript
8 103 (7.94%) R
9 89 (6.86%) C++
10 78 (6.01%) PHP
11 76 (5.86%) PowerShell
12 71 (5.47%) VB.NET
13 42 (3.24%) MATLAB
14 37 (2.85%) PL/SQL
15 23 (1.77%) Perl
16 20 (1.54%) VBScript
17 12 (0.93%) VB6
18 9 (0.69%) Shell Script
19 7 (0.54%) ActionScript
19 7 (0.54%) RPG
Qualifications
1 281 (21.67%) Degree
2 59 (4.55%) Computer Science Degree
3 25 (1.93%) Numerate Degree
4 20 (1.54%) PhD
5 16 (1.23%) Security Cleared
6 14 (1.08%) Master's Degree
6 14 (1.08%) Microsoft Certification
7 13 (1.00%) SC Cleared
8 10 (0.77%) ACCA
9 8 (0.62%) ITIL Certification
9 8 (0.62%) MCSE
10 7 (0.54%) CIMA
10 7 (0.54%) MCSA
11 6 (0.46%) A+ Certification
12 5 (0.39%) MCP
13 4 (0.31%) ISEB
13 4 (0.31%) ISTQB
13 4 (0.31%) MBA
14 3 (0.23%) CFA
14 3 (0.23%) PMP
Quality Assurance & Compliance
1 65 (5.01%) Data Quality
2 35 (2.70%) QA
3 18 (1.39%) GDPR
4 11 (0.85%) SLA
5 5 (0.39%) PMO
6 4 (0.31%) Actionable Recommendations
6 4 (0.31%) MiFID
7 3 (0.23%) EMIR
8 2 (0.15%) ISAE 3402
8 2 (0.15%) Sarbanes-Oxley
9 1 (0.077%) ISO 9001
9 1 (0.077%) UCITS
System Software
1 44 (3.39%) Active Directory
2 7 (0.54%) VMware Infrastructure
3 3 (0.23%) Microsoft App-V
3 3 (0.23%) Tivoli Workload Scheduler
4 1 (0.077%) Docker
4 1 (0.077%) HDFS
4 1 (0.077%) Hyper-V
4 1 (0.077%) Virtual Machines
4 1 (0.077%) XenApp
4 1 (0.077%) XenDesktop
4 1 (0.077%) XenServer
Systems Management
1 20 (1.54%) SCCM
2 11 (0.85%) Control-M
3 7 (0.54%) Systems Management Server (SMS)
4 5 (0.39%) EMC NetWorker
5 4 (0.31%) Grafana
5 4 (0.31%) Graphite
5 4 (0.31%) HP SiteScope
5 4 (0.31%) Nagios
6 3 (0.23%) SCOM
6 3 (0.23%) Tivoli
7 2 (0.15%) ITRS Geneos
7 2 (0.15%) WMI
7 2 (0.15%) WSUS
8 1 (0.077%) Oracle Identity Management
Vendors
1 375 (28.91%) Microsoft
2 209 (16.11%) Oracle
3 155 (11.95%) Tableau
4 70 (5.40%) SAP
5 53 (4.09%) Cognos
6 45 (3.47%) IBM
7 29 (2.24%) Google
8 25 (1.93%) Bloomberg
9 23 (1.77%) Informatica
10 15 (1.16%) Sybase
11 14 (1.08%) Citrix
11 14 (1.08%) Remedy
12 13 (1.00%) Atlassian
12 13 (1.00%) iManage
12 13 (1.00%) Vertica
12 13 (1.00%) VMware
13 12 (0.93%) Capita
14 11 (0.85%) Xamarin
15 10 (0.77%) Alteryx
15 10 (0.77%) Charles River