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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
18 Oct 2017
Same period 2016 Same period 2015
Rank 411 363 312
Rank change year-on-year -48 -51 -16
Permanent jobs citing VBA 1302 1585 2284
As % of all permanent IT jobs advertised in the UK 0.75% 0.83% 1.05%
As % of the Programming Languages category 1.35% 1.57% 2.03%
Number of salaries quoted 1101 1289 1859
UK median annual salary £45,000 £45,000 £44,000
Median salary % change year-on-year - +2.27% +3.53%
10th Percentile £26,250 £26,950 £26,250
90th Percentile £78,750 £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 96623 101053 112280
As % of all permanent IT jobs advertised in the UK 55.33% 52.72% 51.55%
Number of salaries quoted 79250 87166 95901
UK median annual salary £48,500 £47,500 £45,000
Median salary % change year-on-year +2.11% +5.56% +1.12%
10th Percentile £29,000 £28,500 £27,500
90th Percentile £77,500 £76,250 £73,750
UK excluding London median annual salary £42,500 £41,000 £40,000
% change year-on-year +3.66% +2.50% +2.56%

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 18 October 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 18 October 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 -27 1258 £45,000 - 135
London -24 718 £55,000 - 75
UK excluding London -34 570 £35,000 -6.67% 63
North of England -17 172 £32,500 -8.45% 21
South East +23 135 £35,000 -9.09% 11
North West -40 94 £31,500 -16.00% 14
East of England -24 87 £40,000 - 16
Midlands +4 86 £32,500 - 5
Yorkshire +11 69 £35,000 +9.38% 5
South West +8 61 £40,000 +23.08% 6
West Midlands 0 51 £37,500 +17.19% 5
East Midlands +43 35 £30,500 -18.67%
Scotland -26 17 £30,000 -29.41% 1
Wales +19 13 £32,000 +13.67%
North East +20 9 £30,000 -22.58% 2
Northern Ireland - 1 £40,000 - 3

For the 6 months to 18 October 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 975 (74.88%) SQL
2 813 (62.44%) Microsoft Excel
3 610 (46.85%) Finance
4 483 (37.10%) SQL Server
5 383 (29.42%) Microsoft
6 310 (23.81%) C#
7 297 (22.81%) Degree
8 296 (22.73%) Analytics
9 294 (22.58%) Business Intelligence
10 274 (21.04%) .NET
11 270 (20.74%) Analytical Skills
12 200 (15.36%) SQL Server Reporting Services
13 198 (15.21%) Oracle
14 190 (14.59%) T-SQL
15 174 (13.36%) Front Office
16 173 (13.29%) Mathematics
17 172 (13.21%) Python
18 163 (12.52%) Windows
19 161 (12.37%) SQL Server Integration Services
20 157 (12.06%) VB
21 156 (11.98%) Data Analysis
22 154 (11.83%) MS Access
23 153 (11.75%) HTML
24 148 (11.37%) Java
24 148 (11.37%) JavaScript
25 143 (10.98%) Tableau
26 140 (10.75%) Microsoft Office
27 138 (10.60%) Banking
28 135 (10.37%) Marketing
29 126 (9.68%) Computer Science

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 105 (8.06%) SAS
2 58 (4.45%) SharePoint
3 28 (2.15%) IIS
4 25 (1.92%) MS Exchange
5 16 (1.23%) Apache Spark
6 14 (1.08%) BizTalk Server
6 14 (1.08%) Exchange Server 2010
6 14 (1.08%) Oracle SOA Suite
7 12 (0.92%) SharePoint 2013
8 11 (0.84%) Apache
9 10 (0.77%) Confluence
9 10 (0.77%) Exchange Server 2013
10 9 (0.69%) Exchange Server 2007
11 7 (0.54%) CMS
11 7 (0.54%) SharePoint 2010
12 6 (0.46%) Alfresco
12 6 (0.46%) JBoss
12 6 (0.46%) Joomla!
12 6 (0.46%) WebLogic
12 6 (0.46%) WebSphere
Applications
1 813 (62.44%) Microsoft Excel
2 140 (10.75%) Microsoft Office
3 50 (3.84%) Microsoft PowerPoint
3 50 (3.84%) Spreadsheet
4 44 (3.38%) SPSS
5 23 (1.77%) MS Visio
6 10 (0.77%) S-PLUS
7 8 (0.61%) Microsoft Project
8 5 (0.38%) XMetaL
9 3 (0.23%) Doxygen
10 2 (0.15%) Photoshop
11 1 (0.077%) LaTeX
11 1 (0.077%) SPSS Modeler
Business Applications
1 21 (1.61%) Dynamics CRM
2 16 (1.23%) Endur
3 14 (1.08%) SAP InfiniteInsight
4 12 (0.92%) Dynamics GP
5 10 (0.77%) SAP ERP
6 9 (0.69%) Cognos TM1
6 9 (0.69%) HFM
7 7 (0.54%) SAP BPC
7 7 (0.54%) Visualfiles
8 6 (0.46%) Dynamics NAV
9 5 (0.38%) Dynamics AX
10 3 (0.23%) Aligne
10 3 (0.23%) Misys Opics
10 3 (0.23%) ReMetrica
10 3 (0.23%) SAP Business One
10 3 (0.23%) SAP FI
10 3 (0.23%) Softmar
11 2 (0.15%) Bloomberg TOMS
11 2 (0.15%) Infor SunSystems
11 2 (0.15%) Sage 500
Cloud Services
1 41 (3.15%) Microsoft Azure
2 37 (2.84%) Office 365
3 33 (2.53%) Amazon AWS
4 24 (1.84%) SaaS
5 20 (1.54%) Google Analytics
6 11 (0.84%) GitHub
7 7 (0.54%) Adobe Analytics
8 5 (0.38%) Amazon SQS
9 4 (0.31%) PaaS
10 3 (0.23%) Mimecast
11 2 (0.15%) Dynamics 365
11 2 (0.15%) Google Tag Manager
11 2 (0.15%) Oracle Service Cloud
12 1 (0.077%) Cloud Computing
12 1 (0.077%) Google Cloud Platform
12 1 (0.077%) IaaS
Communications & Networking
1 30 (2.30%) Intranet
2 17 (1.31%) DNS
3 16 (1.23%) Firewall
4 8 (0.61%) FTP
4 8 (0.61%) VPN
5 7 (0.54%) WebEx
6 6 (0.46%) TCP/IP
7 4 (0.31%) DHCP
7 4 (0.31%) Internet
7 4 (0.31%) LAN
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%) SAN
9 2 (0.15%) Cisco IOS
9 2 (0.15%) SMS
9 2 (0.15%) Softphone
9 2 (0.15%) VoIP
10 1 (0.077%) Wireshark
Database & Business Intelligence
1 483 (37.10%) SQL Server
2 200 (15.36%) SQL Server Reporting Services
3 161 (12.37%) SQL Server Integration Services
4 154 (11.83%) MS Access
5 126 (9.68%) Power BI
6 117 (8.99%) Data Warehouse
7 103 (7.91%) QlikView
8 83 (6.37%) SQL Server Analysis Services
9 74 (5.68%) MySQL
10 60 (4.61%) BusinessObjects
11 59 (4.53%) Relational Database
12 57 (4.38%) Data Mining
13 48 (3.69%) Hadoop
14 39 (3.00%) SQL Server 2008
15 37 (2.84%) SQL Server 2014
16 35 (2.69%) SQL Server 2012
17 34 (2.61%) NoSQL
18 28 (2.15%) Apache Hive
19 26 (2.00%) Oracle Database
20 25 (1.92%) SQL Server 2016
Development Applications
1 56 (4.30%) Team Foundation Server
2 44 (3.38%) Visual Studio
3 41 (3.15%) Eclipse
4 34 (2.61%) Subversion
5 25 (1.92%) Git (software)
6 23 (1.77%) Jenkins
6 23 (1.77%) JIRA
7 19 (1.46%) SQL Server Management Studio (SSMS)
8 16 (1.23%) InstallShield
9 15 (1.15%) Artifactory
10 9 (0.69%) Oracle Forms
11 7 (0.54%) MSI
12 6 (0.46%) Maven
12 6 (0.46%) NUnit
13 4 (0.31%) IBM UrbanCode
13 4 (0.31%) LoadRunner
13 4 (0.31%) SpecFlow
13 4 (0.31%) Talend Open Studio
14 3 (0.23%) TeamCity
15 2 (0.15%) Selenium
General
1 610 (46.85%) Finance
2 174 (13.36%) Front Office
3 138 (10.60%) Banking
4 135 (10.37%) Marketing
5 55 (4.22%) Legal
6 46 (3.53%) Retail
7 44 (3.38%) Investment Banking
8 35 (2.69%) Law
9 31 (2.38%) Back Office
10 27 (2.07%) Manufacturing
11 24 (1.84%) Advertising
12 20 (1.54%) Billing
13 14 (1.08%) Publishing
14 12 (0.92%) Telecoms
15 10 (0.77%) Financial Institution
16 8 (0.61%) Automotive
17 7 (0.54%) Electronics
17 7 (0.54%) German Language
18 6 (0.46%) French Language
19 4 (0.31%) Retail Banking
Job Titles
1 549 (42.17%) Analyst
2 518 (39.78%) Developer
3 163 (12.52%) SQL Developer
4 156 (11.98%) Data Analyst
5 142 (10.91%) SQL Analyst
6 95 (7.30%) Support Analyst
7 93 (7.14%) C# Developer
8 85 (6.53%) .NET Developer
9 81 (6.22%) Applications Support
10 79 (6.07%) VBA Developer
11 78 (5.99%) Consultant
12 64 (4.92%) Business Intelligence Developer
13 59 (4.53%) Junior
14 55 (4.22%) Applications Support Analyst
15 54 (4.15%) Business Intelligence Analyst
16 48 (3.69%) Analyst Developer
16 48 (3.69%) Software Developer
16 48 (3.69%) SQL Data Analyst
16 48 (3.69%) Systems Developer
17 45 (3.46%) Report Analyst
Libraries, Frameworks & Software Standards
1 274 (21.04%) .NET
2 153 (11.75%) HTML
3 106 (8.14%) XML
4 86 (6.61%) CSS
5 82 (6.30%) ASP.NET
6 72 (5.53%) AngularJS
7 65 (4.99%) .NET Framework
8 63 (4.84%) Web Services
9 46 (3.53%) REST
10 41 (3.15%) React
11 32 (2.46%) HTML5
11 32 (2.46%) jQuery
12 28 (2.15%) Node.js
13 27 (2.07%) MDX
13 27 (2.07%) WPF
14 21 (1.61%) Ajax
14 21 (1.61%) SOAP
14 21 (1.61%) WinForms
15 20 (1.54%) ASP.NET MVC
15 20 (1.54%) EDI
Miscellaneous
1 270 (20.74%) Analytical Skills
2 126 (9.68%) Computer Science
3 87 (6.68%) Fixed Income
4 85 (6.53%) Management Information System
5 70 (5.38%) Derivative
6 65 (4.99%) Foreign Exchange (FX)
7 42 (3.23%) Equities
8 41 (3.15%) Credit Risk
9 31 (2.38%) Data Structures
10 17 (1.31%) Reinsurance
11 16 (1.23%) Hedge funds
12 15 (1.15%) Mobile App
13 13 (1.00%) Algorithms
14 12 (0.92%) NHS
15 11 (0.84%) AS400
16 10 (0.77%) iSeries
17 8 (0.61%) Driving Licence
17 8 (0.61%) Enterprise Software
17 8 (0.61%) Virtual Team
18 7 (0.54%) User Experience
Operating Systems
1 163 (12.52%) Windows
2 79 (6.07%) Linux
3 62 (4.76%) Windows Server
4 60 (4.61%) Unix
5 35 (2.69%) Windows Server 2008
6 29 (2.23%) Windows Server 2012
7 17 (1.31%) Android
8 14 (1.08%) Windows 7
9 13 (1.00%) Windows 10
10 12 (0.92%) Apple iOS
11 5 (0.38%) Windows Vista
12 4 (0.31%) openSUSE
12 4 (0.31%) Red Hat Enterprise Linux
12 4 (0.31%) Solaris
12 4 (0.31%) SUSE
12 4 (0.31%) VMS
13 2 (0.15%) CentOS
13 2 (0.15%) Windows 8
14 1 (0.077%) Mac OS
14 1 (0.077%) Windows Server 2003
Processes & Methodologies
1 296 (22.73%) Analytics
2 294 (22.58%) Business Intelligence
3 173 (13.29%) Mathematics
4 156 (11.98%) Data Analysis
5 111 (8.53%) ETL
6 110 (8.45%) Agile Software Development
7 109 (8.37%) Data Modelling
8 98 (7.53%) Visualisation
9 86 (6.61%) Data Analytics
10 78 (5.99%) ERP
11 75 (5.76%) Statistics
12 74 (5.68%) Project Management
13 71 (5.45%) Asset Management
14 69 (5.30%) Stakeholder Management
15 64 (4.92%) CRM
16 62 (4.76%) Data Management
17 56 (4.30%) SDLC
18 54 (4.15%) Continuous Improvement
19 52 (3.99%) OO
20 51 (3.92%) MVC
Programming Languages
1 975 (74.88%) SQL
2 310 (23.81%) C#
3 190 (14.59%) T-SQL
4 172 (13.21%) Python
5 157 (12.06%) VB
6 148 (11.37%) Java
6 148 (11.37%) JavaScript
7 95 (7.30%) PHP
8 94 (7.22%) C++
9 89 (6.84%) R
10 74 (5.68%) PowerShell
11 57 (4.38%) VB.NET
12 42 (3.23%) MATLAB
13 32 (2.46%) PL/SQL
14 19 (1.46%) Perl
14 19 (1.46%) VBScript
15 11 (0.84%) RPG
15 11 (0.84%) VB6
16 10 (0.77%) ActionScript 2.0
16 10 (0.77%) RPG IV
Qualifications
1 297 (22.81%) Degree
2 56 (4.30%) Computer Science Degree
3 31 (2.38%) Numerate Degree
4 19 (1.46%) Master's Degree
4 19 (1.46%) PhD
5 17 (1.31%) Security Cleared
6 15 (1.15%) SC Cleared
7 13 (1.00%) ACCA
8 11 (0.84%) Microsoft Certification
9 7 (0.54%) MCSE
10 6 (0.46%) A+ Certification
11 5 (0.38%) CIMA
11 5 (0.38%) ITIL Certification
11 5 (0.38%) MCSA
12 4 (0.31%) ISEB
12 4 (0.31%) ISTQB
12 4 (0.31%) Postgraduate
13 3 (0.23%) CFA
13 3 (0.23%) MCP
14 2 (0.15%) MCDST
Quality Assurance & Compliance
1 65 (4.99%) Data Quality
2 30 (2.30%) QA
3 18 (1.38%) GDPR
4 13 (1.00%) SLA
5 6 (0.46%) Actionable Recommendations
6 5 (0.38%) PMO
7 3 (0.23%) MiFID
7 3 (0.23%) Sarbanes-Oxley
8 2 (0.15%) EMIR
9 1 (0.077%) ISAE 3402
9 1 (0.077%) ISO 9001
9 1 (0.077%) ISO/IEC 20000
System Software
1 52 (3.99%) Active Directory
2 7 (0.54%) Microsoft App-V
2 7 (0.54%) VMware Infrastructure
3 4 (0.31%) Tivoli Workload Scheduler
4 3 (0.23%) XenApp
5 2 (0.15%) Hyper-V
5 2 (0.15%) XenDesktop
5 2 (0.15%) XenServer
6 1 (0.077%) Docker
6 1 (0.077%) Virtual Machines
Systems Management
1 28 (2.15%) SCCM
2 9 (0.69%) Control-M
3 7 (0.54%) SCOM
3 7 (0.54%) Systems Management Server (SMS)
4 6 (0.46%) Nagios
5 5 (0.38%) EMC NetWorker
6 4 (0.31%) Grafana
6 4 (0.31%) Graphite
6 4 (0.31%) HP SiteScope
6 4 (0.31%) Tivoli
7 2 (0.15%) ITRS Geneos
7 2 (0.15%) WSUS
8 1 (0.077%) Graylog
8 1 (0.077%) WMI
Vendors
1 383 (29.42%) Microsoft
2 198 (15.21%) Oracle
3 143 (10.98%) Tableau
4 79 (6.07%) SAP
5 48 (3.69%) IBM
6 47 (3.61%) Cognos
7 25 (1.92%) Google
8 22 (1.69%) Bloomberg
9 19 (1.46%) OpenLink
10 17 (1.31%) iManage
11 16 (1.23%) Atlassian
12 15 (1.15%) Remedy
12 15 (1.15%) Vertica
13 12 (0.92%) Adobe
13 12 (0.92%) MicroStrategy
13 12 (0.92%) Siebel
13 12 (0.92%) Sybase
13 12 (0.92%) VMware
14 11 (0.84%) Citrix
14 11 (0.84%) Sun