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

Microsoft Visual Basic for Applications (VBA)
UK
6 months to
21 Aug 2017
Same period 2016 Same period 2015
Rank 394 357 334
Rank change year-on-year -37 -23 -31
Permanent jobs citing VBA 1373 1701 2172
As % of all permanent IT jobs advertised in the UK 0.78% 0.86% 1.00%
As % of the Programming Languages category 1.40% 1.65% 1.94%
Number of salaries quoted 1174 1435 1782
UK median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% -
10th Percentile £26,250 £27,500 £26,250
90th Percentile £78,750 £72,500 £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 language skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for programming language skills.

Programming Language Skills
UK
Permanent job vacancies with a requirement for programming language skills 97871 103266 111784
As % of all permanent IT job vacancies advertised in the UK 55.60% 52.40% 51.21%
Number of salaries quoted 80870 89392 95202
UK median annual salary £47,500 £47,500 £45,000
Median salary % change year-on-year - +5.56% +3.45%
10th Percentile £28,750 £28,250 £27,500
90th Percentile £77,500 £75,000 £72,500
UK excluding London median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +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 21 August 2017.

Salary histogram for VBA in the UK

VBA
Top 15 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 21 August 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 -20 1332 £45,000 - 70
London -5 764 £55,000 +1.85% 37
UK excluding London -25 599 £35,000 -6.67% 37
North of England -19 191 £35,000 -1.41% 8
South East +15 147 £35,000 -10.26% 10
Yorkshire +61 101 £35,000 - 2
Midlands -5 96 £30,500 -6.15% 1
North West -61 86 £31,500 -16.00% 6
East of England -46 74 £37,500 -6.25% 7
South West +28 68 £35,000 +7.69% 7
West Midlands +4 58 £36,500 +12.31%
East Midlands +1 38 £30,500 -10.29% 1
Scotland -22 24 £31,500 -29.01% 2
Wales +10 7 £32,500 +4.84% 2
North East +6 4 £31,500 +14.55%

For the 6 months to 21 August 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 1023 (74.51%) SQL
2 922 (67.15%) Microsoft Excel
3 627 (45.67%) Finance
4 511 (37.22%) SQL Server
5 382 (27.82%) C#
6 368 (26.80%) Microsoft
7 355 (25.86%) Degree
8 331 (24.11%) .NET
9 310 (22.58%) Analytics
10 290 (21.12%) Analytical Skills
11 288 (20.98%) Business Intelligence
12 226 (16.46%) Oracle
13 208 (15.15%) SQL Server Reporting Services
14 200 (14.57%) Front Office
15 191 (13.91%) Python
16 180 (13.11%) Windows
17 179 (13.04%) VB
17 179 (13.04%) MS Access
18 173 (12.60%) T-SQL
19 164 (11.94%) Mathematics
20 160 (11.65%) JavaScript
21 158 (11.51%) XML
22 156 (11.36%) SQL Server Integration Services
23 152 (11.07%) HTML
24 151 (11.00%) Banking
25 145 (10.56%) Data Analysis
26 144 (10.49%) Tableau
27 134 (9.76%) Computer Science
28 127 (9.25%) Agile Software Development
29 123 (8.96%) Java

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 122 (8.89%) SAS
2 74 (5.39%) SharePoint
3 36 (2.62%) IIS
4 32 (2.33%) SharePoint 2013
5 27 (1.97%) MS Exchange
6 24 (1.75%) Oracle SOA Suite
7 22 (1.60%) Apache
8 17 (1.24%) Alfresco
9 16 (1.17%) CMS
9 16 (1.17%) WebLogic
10 15 (1.09%) JBoss
10 15 (1.09%) Joomla!
10 15 (1.09%) SharePoint 2010
10 15 (1.09%) WebSphere
11 14 (1.02%) Apache Spark
11 14 (1.02%) Exchange Server 2010
12 10 (0.73%) Exchange Server 2013
13 9 (0.66%) Exchange Server 2007
14 8 (0.58%) Confluence
15 6 (0.44%) IBM Domino
Applications
1 922 (67.15%) Microsoft Excel
2 115 (8.38%) Microsoft Office
3 63 (4.59%) Spreadsheet
4 58 (4.22%) SPSS
5 46 (3.35%) Microsoft PowerPoint
6 32 (2.33%) MS Visio
7 10 (0.73%) Microsoft Project
8 5 (0.36%) XMetaL
9 3 (0.22%) Photoshop
10 2 (0.15%) S-PLUS
11 1 (0.073%) Acrobat
11 1 (0.073%) Doxygen
11 1 (0.073%) LaTeX
11 1 (0.073%) SPSS Modeler
11 1 (0.073%) Stata
Business Applications
1 21 (1.53%) SAP InfiniteInsight
2 16 (1.17%) Endur
3 15 (1.09%) Dynamics CRM
4 12 (0.87%) Cognos TM1
5 11 (0.80%) SAP BPC
6 10 (0.73%) Visualfiles
7 6 (0.44%) Dynamics GP
8 5 (0.36%) Infor SunSystems
9 4 (0.29%) Dynamics AX
9 4 (0.29%) Dynamics NAV
9 4 (0.29%) HFM
9 4 (0.29%) SAP ERP
10 3 (0.22%) Aligne
10 3 (0.22%) Misys Opics
10 3 (0.22%) SAP FI
10 3 (0.22%) Softmar
11 2 (0.15%) Bloomberg TOMS
11 2 (0.15%) Cognos Business Intelligence
11 2 (0.15%) Markit EDM
11 2 (0.15%) ResourceLink
Cloud Services
1 63 (4.59%) Microsoft Azure
2 35 (2.55%) Amazon AWS
3 25 (1.82%) Google Analytics
4 24 (1.75%) Cloud Computing
4 24 (1.75%) GitHub
4 24 (1.75%) Office 365
5 14 (1.02%) Adobe Analytics
6 13 (0.95%) SaaS
7 5 (0.36%) PaaS
8 4 (0.29%) Basecamp
9 3 (0.22%) Mimecast
10 2 (0.15%) Dynamics 365
10 2 (0.15%) Google Tag Manager
11 1 (0.073%) Amazon EC2
11 1 (0.073%) Amazon EMR
11 1 (0.073%) Amazon S3
11 1 (0.073%) AWS Lambda
11 1 (0.073%) Heroku
11 1 (0.073%) IaaS
Communications & Networking
1 29 (2.11%) Intranet
2 12 (0.87%) DNS
2 12 (0.87%) TCP/IP
3 10 (0.73%) DHCP
3 10 (0.73%) Firewall
4 7 (0.51%) VPN
4 7 (0.51%) WebEx
5 5 (0.36%) HTTP
5 5 (0.36%) Internet
5 5 (0.36%) LAN
5 5 (0.36%) Wi-Fi
6 4 (0.29%) Cisco IOS
6 4 (0.29%) FTP
6 4 (0.29%) Softphone
7 3 (0.22%) DSL
7 3 (0.22%) NAS
7 3 (0.22%) Remote Desktop
7 3 (0.22%) SAN
8 2 (0.15%) SMS
8 2 (0.15%) VoIP
Database & Business Intelligence
1 511 (37.22%) SQL Server
2 208 (15.15%) SQL Server Reporting Services
3 179 (13.04%) MS Access
4 156 (11.36%) SQL Server Integration Services
5 122 (8.89%) Data Warehouse
6 89 (6.48%) Power BI
7 86 (6.26%) SQL Server Analysis Services
8 82 (5.97%) QlikView
9 81 (5.90%) MySQL
10 78 (5.68%) BusinessObjects
11 65 (4.73%) Data Mining
12 57 (4.15%) Relational Database
13 52 (3.79%) SQL Server 2008
14 48 (3.50%) SQL Server 2012
15 47 (3.42%) Hadoop
16 43 (3.13%) NoSQL
17 33 (2.40%) MongoDB
18 30 (2.18%) Spotfire
19 27 (1.97%) Crystal Reports
20 26 (1.89%) Apache Hive
Development Applications
1 61 (4.44%) Visual Studio
2 46 (3.35%) Team Foundation Server
3 41 (2.99%) Subversion
4 38 (2.77%) Eclipse
5 32 (2.33%) Git (software)
6 24 (1.75%) Jenkins
7 23 (1.68%) JIRA
8 19 (1.38%) Oracle Forms
9 15 (1.09%) Maven
9 15 (1.09%) NUnit
10 14 (1.02%) SQL Server Management Studio (SSMS)
11 9 (0.66%) Bitbucket
12 8 (0.58%) TeamCity
13 7 (0.51%) MSI
13 7 (0.51%) Selenium
14 5 (0.36%) Artifactory
14 5 (0.36%) HP UFT
14 5 (0.36%) InstallShield
14 5 (0.36%) PowerBuilder
15 4 (0.29%) NDoc
General
1 627 (45.67%) Finance
2 200 (14.57%) Front Office
3 151 (11.00%) Banking
4 107 (7.79%) Marketing
5 58 (4.22%) Legal
6 56 (4.08%) Investment Banking
7 40 (2.91%) Retail
8 39 (2.84%) Law
9 33 (2.40%) Manufacturing
10 30 (2.18%) Advertising
11 26 (1.89%) Billing
12 25 (1.82%) Back Office
13 15 (1.09%) Financial Institution
13 15 (1.09%) Telecoms
14 13 (0.95%) Publishing
15 12 (0.87%) Games
16 10 (0.73%) Electronics
16 10 (0.73%) French Language
16 10 (0.73%) German Language
17 9 (0.66%) Automotive
Job Titles
1 566 (41.22%) Analyst
2 526 (38.31%) Developer
3 167 (12.16%) SQL Developer
4 164 (11.94%) Data Analyst
5 118 (8.59%) C# Developer
6 115 (8.38%) SQL Analyst
7 108 (7.87%) Support Analyst
8 106 (7.72%) .NET Developer
9 90 (6.55%) VBA Developer
10 88 (6.41%) Applications Support
11 68 (4.95%) Consultant
12 62 (4.52%) Applications Support Analyst
13 59 (4.30%) Business Intelligence Analyst
14 58 (4.22%) Business Intelligence Developer
15 56 (4.08%) Junior
16 47 (3.42%) Software Developer
17 45 (3.28%) Excel Analyst
18 41 (2.99%) Business Analyst
18 41 (2.99%) Python Developer
18 41 (2.99%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 331 (24.11%) .NET
2 158 (11.51%) XML
3 152 (11.07%) HTML
4 99 (7.21%) ASP.NET
5 96 (6.99%) CSS
6 88 (6.41%) Web Services
7 79 (5.75%) AngularJS
8 77 (5.61%) .NET Framework
9 44 (3.20%) jQuery
10 42 (3.06%) WPF
11 41 (2.99%) WCF
12 35 (2.55%) Entity Framework
13 34 (2.48%) React
14 33 (2.40%) ASP.NET MVC
15 31 (2.26%) Ajax
15 31 (2.26%) Twitter Bootstrap
16 26 (1.89%) REST
17 25 (1.82%) J2EE
17 25 (1.82%) WinForms
18 24 (1.75%) SOAP
Miscellaneous
1 290 (21.12%) Analytical Skills
2 134 (9.76%) Computer Science
3 112 (8.16%) Management Information System
4 83 (6.05%) Fixed Income
5 67 (4.88%) Derivative
6 61 (4.44%) Foreign Exchange (FX)
7 43 (3.13%) Credit Risk
7 43 (3.13%) Equities
8 28 (2.04%) Data Structures
9 19 (1.38%) Reinsurance
10 18 (1.31%) Client/Server
11 17 (1.24%) Hedge funds
11 17 (1.24%) NHS
11 17 (1.24%) N-Tier
12 15 (1.09%) AS400
12 15 (1.09%) User Experience
13 14 (1.02%) iSeries
13 14 (1.02%) Market Risk
14 13 (0.95%) Algorithms
15 12 (0.87%) Driving Licence
Operating Systems
1 180 (13.11%) Windows
2 96 (6.99%) Linux
3 69 (5.03%) Windows Server
4 58 (4.22%) Unix
5 45 (3.28%) Windows Server 2008
6 41 (2.99%) Windows Server 2012
7 20 (1.46%) Android
8 17 (1.24%) Windows 7
9 15 (1.09%) Apple iOS
9 15 (1.09%) Windows 10
10 7 (0.51%) Red Hat Enterprise Linux
11 5 (0.36%) Solaris
12 4 (0.29%) openSUSE
12 4 (0.29%) SUSE
12 4 (0.29%) Windows Vista
13 3 (0.22%) CentOS
14 1 (0.073%) Mac OS
14 1 (0.073%) Windows 8
14 1 (0.073%) Windows Server 2003
Processes & Methodologies
1 310 (22.58%) Analytics
2 288 (20.98%) Business Intelligence
3 164 (11.94%) Mathematics
4 145 (10.56%) Data Analysis
5 127 (9.25%) Agile Software Development
6 101 (7.36%) MVC
7 95 (6.92%) Data Modelling
8 91 (6.63%) Statistics
9 90 (6.55%) Asset Management
9 90 (6.55%) ETL
10 77 (5.61%) Data Analytics
11 73 (5.32%) Visualisation
12 72 (5.24%) SDLC
13 70 (5.10%) CRM
14 66 (4.81%) Project Management
14 66 (4.81%) Stakeholder Management
15 61 (4.44%) Data Management
16 59 (4.30%) Test Automation
17 57 (4.15%) OO
18 56 (4.08%) Continuous Improvement
Programming Languages
1 1023 (74.51%) SQL
2 382 (27.82%) C#
3 191 (13.91%) Python
4 179 (13.04%) VB
5 173 (12.60%) T-SQL
6 160 (11.65%) JavaScript
7 123 (8.96%) Java
8 97 (7.06%) C++
9 92 (6.70%) R
10 90 (6.55%) PHP
11 84 (6.12%) PowerShell
12 68 (4.95%) VB.NET
13 38 (2.77%) PL/SQL
14 34 (2.48%) MATLAB
15 31 (2.26%) Perl
16 19 (1.38%) VBScript
17 16 (1.17%) Bash Shell
17 16 (1.17%) Delphi
18 15 (1.09%) Pascal
18 15 (1.09%) RPG
Qualifications
1 355 (25.86%) Degree
2 71 (5.17%) Computer Science Degree
3 39 (2.84%) Numerate Degree
4 36 (2.62%) Security Cleared
5 24 (1.75%) Master's Degree
5 24 (1.75%) PhD
5 24 (1.75%) SC Cleared
6 13 (0.95%) ACCA
7 7 (0.51%) Microsoft Certification
8 6 (0.44%) A+ Certification
9 5 (0.36%) MCSE
9 5 (0.36%) PMI Certification
10 4 (0.29%) CIMA
10 4 (0.29%) ISEB
10 4 (0.29%) ISTQB
10 4 (0.29%) MCP
10 4 (0.29%) PMP
10 4 (0.29%) Postgraduate
11 3 (0.22%) CFA
12 2 (0.15%) MCDST
Quality Assurance & Compliance
1 71 (5.17%) Data Quality
2 33 (2.40%) QA
3 16 (1.17%) SLA
4 7 (0.51%) PMO
5 6 (0.44%) Actionable Recommendations
6 5 (0.36%) Basel III
7 4 (0.29%) ISO/IEC 20000
8 2 (0.15%) GDPR
8 2 (0.15%) MiFID
8 2 (0.15%) Sarbanes-Oxley
9 1 (0.073%) EMIR
9 1 (0.073%) ISO 9001
System Software
1 58 (4.22%) Active Directory
2 7 (0.51%) Microsoft App-V
3 6 (0.44%) XenApp
4 5 (0.36%) VMware Infrastructure
4 5 (0.36%) XenDesktop
4 5 (0.36%) XenServer
5 4 (0.29%) Tivoli Workload Scheduler
6 2 (0.15%) Hyper-V
6 2 (0.15%) Virtual Machines
7 1 (0.073%) VirtualBox
Systems Management
1 17 (1.24%) SCCM
2 15 (1.09%) Nagios
3 7 (0.51%) SCOM
4 6 (0.44%) Systems Management Server (SMS)
5 5 (0.36%) EMC NetWorker
6 4 (0.29%) Control-M
6 4 (0.29%) Grafana
6 4 (0.29%) Graphite
6 4 (0.29%) Graylog
6 4 (0.29%) HP SiteScope
6 4 (0.29%) Tivoli
7 3 (0.22%) Ansible
7 3 (0.22%) Opscode Chef
7 3 (0.22%) Puppet
8 2 (0.15%) ITRS Geneos
8 2 (0.15%) WSUS
Vendors
1 368 (26.80%) Microsoft
2 226 (16.46%) Oracle
3 144 (10.49%) Tableau
4 80 (5.83%) SAP
5 57 (4.15%) IBM
6 42 (3.06%) Cognos
7 30 (2.18%) Google
8 28 (2.04%) Atlassian
9 23 (1.68%) Bloomberg
10 22 (1.60%) Cisco
10 22 (1.60%) OpenLink
11 19 (1.38%) VMware
12 18 (1.31%) Adobe
12 18 (1.31%) Citrix
13 16 (1.17%) iManage
13 16 (1.17%) MicroStrategy
14 15 (1.09%) Vertica
15 14 (1.02%) HP
15 14 (1.02%) Sybase
16 12 (0.87%) Siebel