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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
20 Jan 2018
Same period 2017 Same period 2016
Rank 416 412 330
Rank change year-on-year -4 -82 -36
Permanent jobs citing VBA 1,214 1,295 2,066
As % of all permanent IT jobs advertised in the UK 0.70% 0.73% 0.99%
As % of the Programming Languages category 1.26% 1.38% 1.91%
Number of salaries quoted 1,032 1,051 1,671
UK median annual salary £45,000 £42,500 £42,500
Median salary % change year-on-year +5.88% - -
10th Percentile £27,500 £26,250 £26,875
90th Percentile £75,000 £73,750 £68,750
UK excluding London median annual salary £37,500 £37,500 £35,000
% change year-on-year - +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 96,144 94,160 108,413
As % of all permanent IT jobs advertised in the UK 55.54% 53.19% 51.96%
Number of salaries quoted 80,171 80,867 93,191
UK median annual salary £50,000 £47,500 £45,000
Median salary % change year-on-year +5.26% +5.56% -
10th Percentile £29,750 £28,750 £27,750
90th Percentile £77,500 £76,250 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,000
% change year-on-year - +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 20 January 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 20 January 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,160 £45,000 +5.88% 226
London +14 654 £55,000 +4.76% 116
UK excluding London -31 553 £37,500 - 118
North of England -39 170 £32,500 -13.33% 30
North West -23 115 £35,000 -6.67% 18
South East +17 109 £41,750 -1.76% 28
East of England +32 107 £42,500 +3.03% 18
Midlands -5 86 £35,000 +1.45% 21
West Midlands +14 69 £37,500 +15.38% 15
Yorkshire -40 38 £35,000 - 10
South West -34 36 £40,000 +23.08% 13
Wales +29 24 £32,500 +14.04% 2
East Midlands +4 17 £32,500 -13.33% 6
North East -7 17 £30,000 -25.00% 2
Scotland -38 15 £30,750 -18.00% 6
Northern Ireland -14 7 £29,000 +48.72%

For the 6 months to 20 January 2018, 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 918 (75.62%) SQL
2 720 (59.31%) Microsoft Excel
3 551 (45.39%) Finance
4 446 (36.74%) SQL Server
5 346 (28.50%) Microsoft
6 299 (24.63%) Business Intelligence
7 283 (23.31%) .NET
8 276 (22.73%) Analytical Skills
9 261 (21.50%) C#
10 251 (20.68%) Analytics
11 227 (18.70%) Degree
12 216 (17.79%) SQL Server Reporting Services
13 215 (17.71%) T-SQL
14 208 (17.13%) Oracle
15 167 (13.76%) SQL Server Integration Services
16 162 (13.34%) Agile Software Development
17 156 (12.85%) Python
18 151 (12.44%) Mathematics
19 149 (12.27%) Data Analysis
20 147 (12.11%) Tableau
21 141 (11.61%) Power BI
22 140 (11.53%) JavaScript
23 135 (11.12%) Java
24 134 (11.04%) HTML
25 132 (10.87%) Marketing
26 131 (10.79%) Microsoft Office
26 131 (10.79%) Windows
27 124 (10.21%) Banking
28 120 (9.88%) ETL
29 118 (9.72%) MS Access

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 98 (8.07%) SAS
2 74 (6.10%) SharePoint
3 33 (2.72%) Confluence
3 33 (2.72%) IIS
4 20 (1.65%) Oracle Workflow
5 16 (1.32%) Apache Spark
5 16 (1.32%) BizTalk Server
6 8 (0.66%) Apache
7 7 (0.58%) Elasticsearch
7 7 (0.58%) Exchange Server 2013
8 5 (0.41%) Apache Pig
9 4 (0.33%) MS Exchange
10 3 (0.25%) CMS
10 3 (0.25%) SharePoint Server
11 2 (0.16%) FileNet
11 2 (0.16%) Tomcat
11 2 (0.16%) WordPress
12 1 (0.082%) MQSeries
12 1 (0.082%) NetWeaver
12 1 (0.082%) WebLogic
Applications
1 720 (59.31%) Microsoft Excel
2 131 (10.79%) Microsoft Office
3 43 (3.54%) Microsoft PowerPoint
4 41 (3.38%) Spreadsheet
5 30 (2.47%) SPSS
6 16 (1.32%) Microsoft Project
7 15 (1.24%) MS Visio
8 10 (0.82%) S-PLUS
9 8 (0.66%) XMetaL
10 4 (0.33%) Doxygen
11 2 (0.16%) AutoCAD
11 2 (0.16%) Photoshop
12 1 (0.082%) Abaqus
12 1 (0.082%) CATIA
12 1 (0.082%) LaTeX
12 1 (0.082%) Siemens NX
12 1 (0.082%) Stata
Business Applications
1 21 (1.73%) Dynamics GP
2 20 (1.65%) Dynamics CRM
3 16 (1.32%) SAP InfiniteInsight
4 14 (1.15%) SAP ERP
5 13 (1.07%) HFM
6 12 (0.99%) Infor SunSystems
7 9 (0.74%) CA PPM
8 8 (0.66%) Cognos TM1
8 8 (0.66%) Oracle Financials
8 8 (0.66%) SAP Business One
9 5 (0.41%) Dynamics NAV
9 5 (0.41%) ReMetrica
9 5 (0.41%) SAP BPC
9 5 (0.41%) SAP Business ByDesign
10 4 (0.33%) Dynamics AX
11 3 (0.25%) Bloomberg TOMS
11 3 (0.25%) Cognos Business Intelligence
11 3 (0.25%) Relativity
11 3 (0.25%) Ringtail
11 3 (0.25%) Veritas eDiscovery
Cloud Services
1 31 (2.55%) Amazon AWS
2 28 (2.31%) Office 365
3 24 (1.98%) Microsoft Azure
4 20 (1.65%) SaaS
5 16 (1.32%) Google Analytics
6 5 (0.41%) Amazon SQS
6 5 (0.41%) Cloud Computing
7 3 (0.25%) Adobe Analytics
7 3 (0.25%) Google Tag Manager
8 2 (0.16%) Oracle Service Cloud
8 2 (0.16%) Slack
9 1 (0.082%) Azure Active Directory
9 1 (0.082%) GitHub
9 1 (0.082%) Google Cloud Platform
Communications & Networking
1 19 (1.57%) VPN
2 18 (1.48%) DNS
3 17 (1.40%) Firewall
4 12 (0.99%) Intranet
5 6 (0.49%) FTP
6 5 (0.41%) Internet
6 5 (0.41%) LAN
6 5 (0.41%) SMS
7 4 (0.33%) Extranet
7 4 (0.33%) TCP/IP
8 3 (0.25%) DSL
8 3 (0.25%) NAS
8 3 (0.25%) Remote Desktop
8 3 (0.25%) Wi-Fi
9 2 (0.16%) WAN
10 1 (0.082%) Broadband
10 1 (0.082%) HTTP
10 1 (0.082%) SMTP
10 1 (0.082%) Softphone
10 1 (0.082%) Wireshark
Database & Business Intelligence
1 446 (36.74%) SQL Server
2 216 (17.79%) SQL Server Reporting Services
3 167 (13.76%) SQL Server Integration Services
4 141 (11.61%) Power BI
5 118 (9.72%) MS Access
6 112 (9.23%) QlikView
7 105 (8.65%) Data Warehouse
8 69 (5.68%) SQL Server Analysis Services
9 56 (4.61%) Crystal Reports
9 56 (4.61%) Relational Database
10 51 (4.20%) BusinessObjects
11 48 (3.95%) MySQL
12 45 (3.71%) NoSQL
13 43 (3.54%) SQL Server 2012
14 37 (3.05%) SQL Server 2016
15 35 (2.88%) Hadoop
16 33 (2.72%) Oracle Reports
17 32 (2.64%) SQL Server 2014
18 31 (2.55%) Apache Hive
18 31 (2.55%) Qlik Sense
Development Applications
1 80 (6.59%) Team Foundation Server
2 48 (3.95%) JIRA
3 36 (2.97%) Visual Studio
4 32 (2.64%) Git (software)
5 27 (2.22%) SQL Server Management Studio (SSMS)
6 25 (2.06%) Eclipse
7 23 (1.89%) Jenkins
8 22 (1.81%) Subversion
9 15 (1.24%) Artifactory
9 15 (1.24%) InstallShield
10 10 (0.82%) Visual Studio Tools for Office
11 8 (0.66%) Axure RP
12 6 (0.49%) SonarQube
13 3 (0.25%) GCC
13 3 (0.25%) GDB
13 3 (0.25%) SpecFlow
13 3 (0.25%) TeamCity
13 3 (0.25%) Visual Studio Team System
14 1 (0.082%) Bitbucket
14 1 (0.082%) CA Gen
General
1 551 (45.39%) Finance
2 132 (10.87%) Marketing
3 124 (10.21%) Banking
4 109 (8.98%) Front Office
5 57 (4.70%) Retail
6 26 (2.14%) Legal
7 21 (1.73%) Back Office
7 21 (1.73%) Investment Banking
8 19 (1.57%) Telecoms
9 18 (1.48%) Financial Institution
10 16 (1.32%) Law
11 13 (1.07%) Manufacturing
12 9 (0.74%) Retail Banking
13 8 (0.66%) Advertising
13 8 (0.66%) Electronics
13 8 (0.66%) Games
13 8 (0.66%) Publishing
14 4 (0.33%) Automotive
15 2 (0.16%) French Language
15 2 (0.16%) Pharmaceutical
Job Titles
1 518 (42.67%) Developer
2 447 (36.82%) Analyst
3 148 (12.19%) Data Analyst
4 145 (11.94%) SQL Developer
5 112 (9.23%) SQL Analyst
6 96 (7.91%) Consultant
7 81 (6.67%) C# Developer
8 76 (6.26%) Business Intelligence Developer
9 70 (5.77%) VBA Developer
10 69 (5.68%) Software Developer
11 54 (4.45%) SQL Data Analyst
12 52 (4.28%) Report Analyst
13 51 (4.20%) .NET Developer
13 51 (4.20%) Junior
14 49 (4.04%) Applications Support
14 49 (4.04%) Systems Developer
15 38 (3.13%) SQL Server Developer
16 37 (3.05%) Business Intelligence Analyst
16 37 (3.05%) Support Analyst
17 36 (2.97%) Business Analyst
Libraries, Frameworks & Software Standards
1 283 (23.31%) .NET
2 134 (11.04%) HTML
3 101 (8.32%) XML
4 97 (7.99%) ASP.NET
5 88 (7.25%) CSS
6 84 (6.92%) AngularJS
7 66 (5.44%) .NET Framework
8 53 (4.37%) REST
9 51 (4.20%) Web Services
10 36 (2.97%) React
10 36 (2.97%) WPF
11 35 (2.88%) MDX
12 28 (2.31%) ASP.NET MVC
13 27 (2.22%) Node.js
14 26 (2.14%) HTML5
15 24 (1.98%) jQuery
16 21 (1.73%) EDI
16 21 (1.73%) SOAP
17 18 (1.48%) JSON
18 17 (1.40%) KnockoutJS
Miscellaneous
1 276 (22.73%) Analytical Skills
2 104 (8.57%) Computer Science
3 74 (6.10%) Management Information System
4 61 (5.02%) Fixed Income
5 43 (3.54%) Equities
6 41 (3.38%) Derivative
7 30 (2.47%) Foreign Exchange (FX)
8 29 (2.39%) Credit Risk
9 22 (1.81%) Data Structures
10 18 (1.48%) Hedge funds
11 17 (1.40%) Algorithms
12 16 (1.32%) Enterprise Software
12 16 (1.32%) Mobile App
13 14 (1.15%) Fintech
14 13 (1.07%) Greenfield Project
14 13 (1.07%) Reference Data
14 13 (1.07%) Reinsurance
15 11 (0.91%) User Experience
16 10 (0.82%) Equity Derivative
17 8 (0.66%) Semantic Web
Operating Systems
1 131 (10.79%) Windows
2 83 (6.84%) Unix
3 64 (5.27%) Linux
4 43 (3.54%) Windows Server
5 18 (1.48%) Android
6 16 (1.32%) Apple iOS
7 14 (1.15%) Windows Server 2012
8 12 (0.99%) Windows Server 2008
9 9 (0.74%) Windows 10
9 9 (0.74%) Windows 7
10 5 (0.41%) Windows Vista
11 4 (0.33%) VMS
12 2 (0.16%) openSUSE
12 2 (0.16%) OS/400
12 2 (0.16%) Red Hat Enterprise Linux
12 2 (0.16%) SUSE
13 1 (0.082%) Windows 8
Processes & Methodologies
1 299 (24.63%) Business Intelligence
2 251 (20.68%) Analytics
3 162 (13.34%) Agile Software Development
4 151 (12.44%) Mathematics
5 149 (12.27%) Data Analysis
6 120 (9.88%) ETL
7 115 (9.47%) Visualisation
8 107 (8.81%) Data Modelling
9 90 (7.41%) Data Analytics
10 81 (6.67%) ERP
11 73 (6.01%) CRM
12 70 (5.77%) Project Management
13 69 (5.68%) Asset Management
14 63 (5.19%) OO
15 62 (5.11%) Stakeholder Management
16 59 (4.86%) Risk Management
17 58 (4.78%) Data Management
18 55 (4.53%) Data Visualisation
19 53 (4.37%) Portfolio Management
19 53 (4.37%) Unit Testing
Programming Languages
1 918 (75.62%) SQL
2 261 (21.50%) C#
3 215 (17.71%) T-SQL
4 156 (12.85%) Python
5 140 (11.53%) JavaScript
6 135 (11.12%) Java
7 114 (9.39%) VB
8 89 (7.33%) VB.NET
9 87 (7.17%) R
10 78 (6.43%) PowerShell
11 73 (6.01%) PHP
12 69 (5.68%) C++
13 43 (3.54%) PL/SQL
14 32 (2.64%) Perl
15 30 (2.47%) MATLAB
16 15 (1.24%) C
16 15 (1.24%) VBScript
17 11 (0.91%) Shell Script
18 10 (0.82%) VB6
19 5 (0.41%) Bash Shell
Qualifications
1 227 (18.70%) Degree
2 47 (3.87%) Computer Science Degree
3 21 (1.73%) PhD
4 17 (1.40%) Microsoft Certification
5 15 (1.24%) Master's Degree
6 13 (1.07%) Security Cleared
7 12 (0.99%) Numerate Degree
8 11 (0.91%) ACCA
9 10 (0.82%) MCSE
9 10 (0.82%) SC Cleared
10 9 (0.74%) CIMA
10 9 (0.74%) ITIL Certification
10 9 (0.74%) MCSA
11 8 (0.66%) MCP
12 6 (0.49%) CBAP
13 4 (0.33%) A+ Certification
13 4 (0.33%) MBA
13 4 (0.33%) PMP
14 3 (0.25%) MCAD
14 3 (0.25%) MCSD
Quality Assurance & Compliance
1 73 (6.01%) Data Quality
2 37 (3.05%) QA
3 26 (2.14%) GDPR
4 14 (1.15%) PMO
5 9 (0.74%) SLA
6 8 (0.66%) Solvency II
7 5 (0.41%) MiFID
8 3 (0.25%) EMIR
8 3 (0.25%) ISO 9001
9 2 (0.16%) Actionable Recommendations
9 2 (0.16%) GAAP
9 2 (0.16%) ISAE 3402
9 2 (0.16%) Sarbanes-Oxley
10 1 (0.082%) UCITS
System Software
1 42 (3.46%) Active Directory
2 5 (0.41%) HDFS
3 4 (0.33%) VMware Infrastructure
4 2 (0.16%) Docker
5 1 (0.082%) Hyper-V
Systems Management
1 16 (1.32%) SCCM
2 10 (0.82%) Control-M
3 3 (0.25%) WMI
4 2 (0.16%) EnCase
4 2 (0.16%) FTK
4 2 (0.16%) Grafana
4 2 (0.16%) Graphite
4 2 (0.16%) Systems Management Server (SMS)
5 1 (0.082%) Forefront Identity Manager
5 1 (0.082%) HP SiteScope
5 1 (0.082%) Kibana
5 1 (0.082%) Oracle Identity Management
5 1 (0.082%) WSUS
Vendors
1 346 (28.50%) Microsoft
2 208 (17.13%) Oracle
3 147 (12.11%) Tableau
4 70 (5.77%) SAP
5 54 (4.45%) Cognos
6 30 (2.47%) IBM
6 30 (2.47%) Informatica
7 26 (2.14%) Capita
7 26 (2.14%) Google
8 23 (1.89%) Citrix
9 20 (1.65%) VMware
10 19 (1.57%) Bloomberg
11 16 (1.32%) Xamarin
12 15 (1.24%) Alteryx
12 15 (1.24%) Vertica
13 14 (1.15%) Veeam
14 12 (0.99%) Hyperion
14 12 (0.99%) Remedy
15 11 (0.91%) Sybase
15 11 (0.91%) Teradata