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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
24 Jun 2018
Same period 2017 Same period 2016
Rank 381 386 351
Rank change year-on-year +5 -35 -20
Permanent jobs citing VBA 1,425 1,415 1,868
As % of all permanent IT jobs advertised in the UK 0.82% 0.82% 0.93%
As % of the Programming Languages category 1.46% 1.48% 1.78%
Number of salaries quoted 1,194 1,211 1,562
UK median annual salary £45,000 £45,000 £45,000
10th Percentile £27,000 £26,250 £27,500
90th Percentile £73,675 £75,000 £70,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 97,501 95,648 105,066
As % of all permanent IT jobs advertised in the UK 56.09% 55.26% 52.16%
Number of salaries quoted 81,144 80,730 90,761
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £30,000 £28,750 £28,000
90th Percentile £80,000 £76,250 £75,000
UK excluding London median annual salary £45,000 £42,133 £40,000
% change year-on-year +6.81% +5.33% -

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 24 June 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 24 June 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 +8 1,360 £45,000 - 149
London +13 794 £50,000 -9.09% 62
UK excluding London -11 608 £37,500 +7.14% 101
North of England +14 167 £35,000 - 23
South East -18 138 £40,000 +23.08% 26
East of England +60 126 £42,000 +5.00% 13
North West +26 104 £37,500 +15.38% 10
Midlands -12 85 £33,250 +9.02% 14
Yorkshire -9 52 £27,500 -21.43% 9
South West -37 48 £35,000 - 11
East Midlands +2 43 £34,000 +11.48% 5
West Midlands -4 42 £32,500 -9.09% 9
Scotland -44 26 £45,000 +55.17% 8
Wales +24 16 £36,750 +25.64% 5
North East -10 11 £30,000 -4.76% 4
Northern Ireland +10 3 £32,500 +66.67% 1

For the 6 months to 24 June 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 934 (65.54%) SQL
2 857 (60.14%) Microsoft Excel
3 668 (46.88%) Finance
4 602 (42.25%) SQL Server
5 437 (30.67%) Microsoft
6 413 (28.98%) C#
7 386 (27.09%) .NET
7 386 (27.09%) Business Intelligence
8 336 (23.58%) Analytical Skills
9 335 (23.51%) Degree
10 308 (21.61%) T-SQL
11 292 (20.49%) Agile Software Development
12 289 (20.28%) SQL Server Reporting Services
13 240 (16.84%) Analytics
14 225 (15.79%) Problem-Solving
15 206 (14.46%) Python
16 204 (14.32%) Windows
17 194 (13.61%) Microsoft Office
18 190 (13.33%) SQL Server Integration Services
19 188 (13.19%) VB
20 184 (12.91%) Banking
21 181 (12.70%) XML
22 179 (12.56%) Tableau
23 177 (12.42%) Oracle
24 162 (11.37%) Data Analysis
25 156 (10.95%) Front Office
26 155 (10.88%) Visualisation
26 155 (10.88%) Computer Science
27 152 (10.67%) Java
27 152 (10.67%) Project Management

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 94 (6.60%) SAS
2 70 (4.91%) IIS
3 54 (3.79%) SharePoint
4 43 (3.02%) Confluence
5 15 (1.05%) Apache Spark
6 13 (0.91%) CMS
6 13 (0.91%) Exchange Server 2013
7 11 (0.77%) WordPress
8 8 (0.56%) Oracle Workflow
9 7 (0.49%) Apache
9 7 (0.49%) DataSynapse
10 6 (0.42%) Apache Pig
10 6 (0.42%) MS Project Server
11 5 (0.35%) SharePoint 2013
11 5 (0.35%) SharePoint Server
12 3 (0.21%) Exchange Server 2010
12 3 (0.21%) MS Exchange
13 2 (0.14%) BizTalk Server
13 2 (0.14%) Tomcat
13 2 (0.14%) WebLogic
Applications
1 857 (60.14%) Microsoft Excel
2 194 (13.61%) Microsoft Office
3 64 (4.49%) Spreadsheet
4 51 (3.58%) Microsoft PowerPoint
5 30 (2.11%) SPSS
6 27 (1.89%) Microsoft Project
7 24 (1.68%) MS Visio
8 4 (0.28%) EViews
9 2 (0.14%) LibreOffice
10 1 (0.070%) Adobe Illustrator
10 1 (0.070%) AutoCAD
10 1 (0.070%) Photoshop
10 1 (0.070%) Simulink
10 1 (0.070%) Stateflow
Business Applications
1 32 (2.25%) Elite 3E
2 24 (1.68%) Cognos TM1
3 23 (1.61%) SimCorp Dimension
4 17 (1.19%) Cognos Business Intelligence
5 15 (1.05%) Infor SunSystems
5 15 (1.05%) Workfront
6 11 (0.77%) Dynamics CRM
7 9 (0.63%) CA PPM
7 9 (0.63%) Unica
8 8 (0.56%) Adobe Campaign
8 8 (0.56%) Oracle EBS
8 8 (0.56%) Summit
9 6 (0.42%) Markit EDM
9 6 (0.42%) Oracle Financials
9 6 (0.42%) SAP BPC
10 4 (0.28%) HFM
10 4 (0.28%) Oracle ERP
10 4 (0.28%) SAP ERP
10 4 (0.28%) SAP InfiniteInsight
10 4 (0.28%) SAP Retail
Cloud Services
1 81 (5.68%) Microsoft Azure
2 35 (2.46%) Amazon AWS
3 30 (2.11%) SaaS
4 21 (1.47%) Cloud Computing
5 15 (1.05%) Salesforce Sales Cloud
5 15 (1.05%) Salesforce Service Cloud
6 14 (0.98%) Office 365
7 13 (0.91%) Google Analytics
8 8 (0.56%) Google Cloud Platform
9 7 (0.49%) Azure Data Factory
10 4 (0.28%) Dynamics 365
10 4 (0.28%) IBM Cloud
11 3 (0.21%) Adobe Analytics
12 2 (0.14%) Amazon S3
13 1 (0.070%) AdWords
13 1 (0.070%) G Suite
Communications & Networking
1 29 (2.04%) Firewall
2 22 (1.54%) VPN
3 21 (1.47%) Intrusion Detection
4 19 (1.33%) Intranet
5 10 (0.70%) SMS
6 9 (0.63%) Remote Desktop
7 8 (0.56%) DNS
8 7 (0.49%) HTTP
8 7 (0.49%) Wireshark
9 6 (0.42%) FTP
9 6 (0.42%) Telnet
10 5 (0.35%) Extranet
10 5 (0.35%) MPLS
10 5 (0.35%) TCP/IP
11 4 (0.28%) SSL
12 2 (0.14%) WAN
13 1 (0.070%) ADSL
13 1 (0.070%) Broadband
13 1 (0.070%) LAN
13 1 (0.070%) WLAN
Database & Business Intelligence
1 602 (42.25%) SQL Server
2 289 (20.28%) SQL Server Reporting Services
3 190 (13.33%) SQL Server Integration Services
4 147 (10.32%) Power BI
5 141 (9.89%) MS Access
6 121 (8.49%) Data Warehouse
7 107 (7.51%) SQL Server Analysis Services
8 101 (7.09%) SQL Server 2008
9 85 (5.96%) Relational Database
10 81 (5.68%) MySQL
11 78 (5.47%) NoSQL
12 66 (4.63%) Crystal Reports
13 58 (4.07%) SQL Server 2012
14 55 (3.86%) BusinessObjects
15 50 (3.51%) QlikView
16 38 (2.67%) Big Data
16 38 (2.67%) Couchbase
17 35 (2.46%) SQL Server 2016
18 33 (2.32%) MongoDB
19 28 (1.96%) OLAP
Development Applications
1 116 (8.14%) Team Foundation Server
2 79 (5.54%) Visual Studio
3 69 (4.84%) JIRA
4 67 (4.70%) Git (software)
5 38 (2.67%) Subversion
6 31 (2.18%) Visual Studio Tools for Office
7 15 (1.05%) Eclipse
8 11 (0.77%) SpecFlow
9 10 (0.70%) NUnit
10 9 (0.63%) SQL Server Management Studio (SSMS)
11 8 (0.56%) Jenkins
12 6 (0.42%) Bitbucket
12 6 (0.42%) Octopus Deploy
12 6 (0.42%) TeamCity
13 5 (0.35%) Artifactory
13 5 (0.35%) RStudio
13 5 (0.35%) Visual Studio Team System
14 3 (0.21%) Axure RP
14 3 (0.21%) InstallShield
14 3 (0.21%) Maven
General
1 668 (46.88%) Finance
2 184 (12.91%) Banking
3 156 (10.95%) Front Office
4 100 (7.02%) Marketing
5 62 (4.35%) Retail
6 48 (3.37%) Legal
7 44 (3.09%) Back Office
8 43 (3.02%) Law
9 41 (2.88%) Investment Banking
10 29 (2.04%) Advertising
11 17 (1.19%) French Language
12 14 (0.98%) Italian Language
12 14 (0.98%) Local Government
12 14 (0.98%) Spanish Language
13 10 (0.70%) Financial Institution
14 9 (0.63%) Billing
14 9 (0.63%) German Language
14 9 (0.63%) Manufacturing
15 6 (0.42%) Electronics
15 6 (0.42%) Telecoms
Job Titles
1 599 (42.04%) Developer
2 499 (35.02%) Analyst
3 147 (10.32%) Data Analyst
4 146 (10.25%) C# Developer
5 124 (8.70%) SQL Developer
6 95 (6.67%) VBA Developer
7 94 (6.60%) .NET Developer
8 86 (6.04%) Business Intelligence Developer
9 82 (5.75%) Junior
10 79 (5.54%) Applications Support
11 65 (4.56%) Consultant
12 64 (4.49%) SQL Analyst
13 62 (4.35%) Business Intelligence Analyst
14 58 (4.07%) Excel Developer
15 56 (3.93%) Report Analyst
15 56 (3.93%) Software Developer
16 55 (3.86%) C# .NET Developer
17 51 (3.58%) Front Office Developer
18 50 (3.51%) Systems Developer
19 48 (3.37%) Junior Developer
Libraries, Frameworks & Software Standards
1 386 (27.09%) .NET
2 181 (12.70%) XML
3 145 (10.18%) HTML
4 103 (7.23%) CSS
5 91 (6.39%) ASP.NET
6 86 (6.04%) .NET Framework
7 66 (4.63%) WCF
8 60 (4.21%) WPF
9 57 (4.00%) AngularJS
10 53 (3.72%) JSON
11 49 (3.44%) WinForms
12 45 (3.16%) Web Services
13 39 (2.74%) jQuery
14 31 (2.18%) HTML5
15 30 (2.11%) REST
16 27 (1.89%) D3.js
17 25 (1.75%) EDI
18 23 (1.61%) Twitter Bootstrap
19 22 (1.54%) ASP.NET MVC
19 22 (1.54%) Entity Framework
Miscellaneous
1 336 (23.58%) Analytical Skills
2 155 (10.88%) Computer Science
3 92 (6.46%) Management Information System
4 77 (5.40%) Derivative
4 77 (5.40%) Equities
5 42 (2.95%) Foreign Exchange (FX)
6 41 (2.88%) Fixed Income
7 33 (2.32%) Self-Motivation
8 30 (2.11%) Hedge funds
9 27 (1.89%) Data Structures
10 24 (1.68%) Enterprise Software
11 23 (1.61%) Cybercrime
12 22 (1.54%) User Experience
13 21 (1.47%) Reinsurance
14 19 (1.33%) Driving Licence
15 18 (1.26%) Greenfield Project
16 17 (1.19%) Fintech
17 16 (1.12%) Virtual Team
18 13 (0.91%) Algorithms
18 13 (0.91%) CCTV
Operating Systems
1 204 (14.32%) Windows
2 92 (6.46%) Linux
3 85 (5.96%) Windows Server
4 54 (3.79%) Unix
5 44 (3.09%) Windows 7
6 27 (1.89%) Windows Server 2008
6 27 (1.89%) Windows Server 2012
7 14 (0.98%) Windows 10
8 7 (0.49%) Android
8 7 (0.49%) Apple iOS
8 7 (0.49%) Mac OS X
9 5 (0.35%) HPUX
10 3 (0.21%) CentOS
10 3 (0.21%) OS/400
11 2 (0.14%) Red Hat Enterprise Linux
11 2 (0.14%) Windows Embedded Compact
12 1 (0.070%) Mac OS
12 1 (0.070%) Solaris
12 1 (0.070%) Windows 2000
12 1 (0.070%) Windows XP
Processes & Methodologies
1 386 (27.09%) Business Intelligence
2 292 (20.49%) Agile Software Development
3 240 (16.84%) Analytics
4 225 (15.79%) Problem-Solving
5 162 (11.37%) Data Analysis
6 155 (10.88%) Visualisation
7 152 (10.67%) Project Management
8 143 (10.04%) Scrum
9 138 (9.68%) Data Modelling
10 130 (9.12%) Continuous Improvement
11 124 (8.70%) CRM
12 122 (8.56%) SDLC
13 118 (8.28%) ETL
14 109 (7.65%) Mathematics
15 97 (6.81%) TDD
16 95 (6.67%) Asset Management
17 87 (6.11%) Change Management
18 85 (5.96%) OO
19 76 (5.33%) Business Analysis
20 75 (5.26%) ERP
Programming Languages
1 934 (65.54%) SQL
2 413 (28.98%) C#
3 308 (21.61%) T-SQL
4 206 (14.46%) Python
5 188 (13.19%) VB
6 152 (10.67%) Java
7 145 (10.18%) JavaScript
8 139 (9.75%) VB.NET
9 118 (8.28%) C++
10 115 (8.07%) PowerShell
11 106 (7.44%) R
12 88 (6.18%) C
13 86 (6.04%) PHP
14 45 (3.16%) Perl
15 36 (2.53%) MATLAB
16 31 (2.18%) PL/SQL
17 20 (1.40%) VBScript
18 17 (1.19%) VB6
19 15 (1.05%) Apex Code
20 12 (0.84%) Data Analysis Expressions (DAX)
Qualifications
1 335 (23.51%) Degree
2 66 (4.63%) Computer Science Degree
3 39 (2.74%) Microsoft Certification
4 37 (2.60%) Master's Degree
5 33 (2.32%) MCSE
6 27 (1.89%) CCNA
6 27 (1.89%) Cisco Certification
6 27 (1.89%) MCP
7 23 (1.61%) CCNP
8 21 (1.47%) MCSA
9 18 (1.26%) Security Cleared
10 14 (0.98%) PhD
11 13 (0.91%) HND
11 13 (0.91%) Numerate Degree
11 13 (0.91%) SC Cleared
12 8 (0.56%) PMI Certification
12 8 (0.56%) PMP
13 7 (0.49%) ACCA
13 7 (0.49%) CBAP
13 7 (0.49%) CFA
Quality Assurance & Compliance
1 73 (5.12%) Data Quality
2 39 (2.74%) QA
3 25 (1.75%) GDPR
4 13 (0.91%) Solvency II
5 11 (0.77%) MiFID
5 11 (0.77%) PMO
5 11 (0.77%) SLA
6 5 (0.35%) EMIR
6 5 (0.35%) ISO/IEC 27001
7 3 (0.21%) FATCA
7 3 (0.21%) ISO 9001
8 1 (0.070%) Actionable Recommendations
8 1 (0.070%) Disclosure Scotland
8 1 (0.070%) GAAP
8 1 (0.070%) IFRS
8 1 (0.070%) IFRS 9
8 1 (0.070%) ISAE 3402
8 1 (0.070%) ISO/IEC 20000
8 1 (0.070%) PCI DSS
8 1 (0.070%) Sarbanes-Oxley
System Software
1 74 (5.19%) Active Directory
2 23 (1.61%) Virtual Machines
3 13 (0.91%) Docker
4 8 (0.56%) Virtual Desktop
5 3 (0.21%) VMware Infrastructure
6 1 (0.070%) Microsoft Virtual Server
6 1 (0.070%) Virtual Servers
Systems Management
1 14 (0.98%) Systems Management Server (SMS)
2 8 (0.56%) Control-M
2 8 (0.56%) SCCM
3 5 (0.35%) Kubernetes
4 4 (0.28%) QRadar
5 3 (0.21%) WSUS
6 2 (0.14%) CSIRT
7 1 (0.070%) Graylog
7 1 (0.070%) Nagios
7 1 (0.070%) Single Sign-On
7 1 (0.070%) WMI
Vendors
1 437 (30.67%) Microsoft
2 179 (12.56%) Tableau
3 177 (12.42%) Oracle
4 70 (4.91%) Cognos
5 63 (4.42%) SAP
6 52 (3.65%) Citrix
7 39 (2.74%) Salesforce.com
8 35 (2.46%) Capita
9 29 (2.04%) IBM
10 26 (1.82%) Google
11 25 (1.75%) Reuters
11 25 (1.75%) VMware
12 24 (1.68%) SimCorp
13 22 (1.54%) Intapp
14 19 (1.33%) Infor
15 18 (1.26%) Alteryx
15 18 (1.26%) TOWER Software
16 16 (1.12%) Sage
16 16 (1.12%) Vertica
17 15 (1.05%) Veeam