Period
to 22 February 2018

The following table provides summary statistics for permanent job vacancies advertised in London 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 22 February 2018 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA)
England > London
6 months to
22 Feb 2018
Same period 2017 Same period 2016
Rank 321 343 283
Rank change year-on-year +22 -60 -41
Permanent jobs citing VBA 685 649 1,051
As % of all permanent IT jobs advertised in London 0.98% 0.93% 1.23%
As % of the Programming Languages category 1.76% 1.70% 2.27%
Number of salaries quoted 553 539 894
London median annual salary £52,500 £52,500 £50,000
Median salary % change year-on-year - +5.00% -4.76%
10th Percentile £35,750 £29,250 £32,500
90th Percentile £83,750 £78,750 £80,000
England median annual salary £45,000 £42,500 £43,500
% change year-on-year +5.88% -2.30% +2.35%

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 advertised in London with a requirement for coding skills.

All Programming Languages
London
Permanent vacancies with a requirement for coding skills 38,873 38,216 46,242
As % of all permanent IT jobs advertised in London 55.44% 54.66% 54.11%
Number of salaries quoted 32,494 33,304 40,261
London median annual salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.35% +4.55% -
10th Percentile £37,500 £35,000 £34,750
90th Percentile £90,000 £87,500 £85,000
England median annual salary £50,000 £47,500 £46,000
% change year-on-year +5.26% +3.26% +2.22%

VBA
Job Vacancy Trend in London

Job postings citing VBA as a percentage of all IT jobs advertised in London.

Job vacancy trend for VBA in London

VBA
Salary Trend in London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing VBA in London.

Salary trend for VBA in London

VBA
Salary Histogram in London

The salary distribution of IT jobs citing VBA in London over the 6 months to 22 February 2018.

Salary histogram for VBA in London

VBA
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing VBA within the London region over the 6 months to 22 February 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
Central London +29 191 £47,500 -13.64% 21
South London +6 20 £38,694 +3.18% 3
East London 0 13 £52,500 -8.70% 3
West London +11 9 £35,000 -6.67% 16
North London +4 1 £33,500 -
VBA
England

For the 6 months to 22 February 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 across the London region with a requirement for VBA.

1 507 (74.01%) SQL
2 464 (67.74%) Microsoft Excel
3 403 (58.83%) Finance
4 225 (32.85%) SQL Server
5 176 (25.69%) C#
6 169 (24.67%) Analytics
7 147 (21.46%) Microsoft
8 141 (20.58%) .NET
8 141 (20.58%) Oracle
9 134 (19.56%) Degree
10 121 (17.66%) Tableau
11 120 (17.52%) Analytical Skills
12 119 (17.37%) Python
12 119 (17.37%) Banking
13 118 (17.23%) Business Intelligence
14 114 (16.64%) T-SQL
15 110 (16.06%) Agile Software Development
15 110 (16.06%) Front Office
16 104 (15.18%) SQL Server Reporting Services
17 92 (13.43%) Mathematics
18 89 (12.99%) Data Modelling
19 86 (12.55%) SQL Server Integration Services
20 85 (12.41%) VB
21 82 (11.97%) Data Analysis
22 80 (11.68%) R
23 79 (11.53%) Visualisation
24 76 (11.09%) Asset Management
24 76 (11.09%) Marketing
25 73 (10.66%) JavaScript
26 71 (10.36%) HTML

VBA
Co-occurring IT Skills in London 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 50 (7.30%) SAS
2 37 (5.40%) SharePoint
3 18 (2.63%) Oracle Workflow
4 14 (2.04%) IIS
5 13 (1.90%) Confluence
6 10 (1.46%) Apache Spark
7 9 (1.31%) Apache
8 8 (1.17%) Exchange Server 2013
9 5 (0.73%) BizTalk Server
9 5 (0.73%) Elasticsearch
10 3 (0.44%) Apache Pig
10 3 (0.44%) CMS
10 3 (0.44%) MS Exchange
11 2 (0.29%) Tomcat
12 1 (0.15%) MQSeries
12 1 (0.15%) Oracle SOA Suite
12 1 (0.15%) WordPress
Applications
1 464 (67.74%) Microsoft Excel
2 61 (8.91%) Microsoft Office
3 52 (7.59%) Spreadsheet
4 24 (3.50%) SPSS
5 22 (3.21%) Microsoft PowerPoint
6 13 (1.90%) MS Visio
7 8 (1.17%) S-PLUS
8 7 (1.02%) Microsoft Project
9 3 (0.44%) AutoCAD
9 3 (0.44%) Doxygen
9 3 (0.44%) XMetaL
Business Applications
1 16 (2.34%) Infor SunSystems
2 14 (2.04%) HFM
2 14 (2.04%) SAP InfiniteInsight
3 12 (1.75%) SAP ERP
4 11 (1.61%) Oracle Financials
5 10 (1.46%) Cognos TM1
6 9 (1.31%) CA PPM
6 9 (1.31%) Elite 3E
7 5 (0.73%) ReMetrica
7 5 (0.73%) Unica
8 4 (0.58%) Adobe Campaign
8 4 (0.58%) SimCorp Dimension
8 4 (0.58%) thinkFolio
9 3 (0.44%) Dynamics NAV
9 3 (0.44%) SAP BPC
10 2 (0.29%) Dynamics CRM
10 2 (0.29%) Relativity
10 2 (0.29%) Ringtail
10 2 (0.29%) Veritas eDiscovery
11 1 (0.15%) ScheduALL
Cloud Services
1 22 (3.21%) Office 365
2 18 (2.63%) SaaS
3 17 (2.48%) Amazon AWS
4 13 (1.90%) Google Analytics
5 8 (1.17%) Microsoft Azure
6 5 (0.73%) Amazon SQS
6 5 (0.73%) Salesforce Sales Cloud
6 5 (0.73%) Salesforce Service Cloud
7 2 (0.29%) Adobe Analytics
7 2 (0.29%) Google Cloud Platform
7 2 (0.29%) Slack
8 1 (0.15%) Google Tag Manager
Communications & Networking
1 15 (2.19%) Intranet
2 4 (0.58%) Extranet
3 2 (0.29%) LAN
3 2 (0.29%) SMS
3 2 (0.29%) WAN
4 1 (0.15%) Broadband
Database & Business Intelligence
1 225 (32.85%) SQL Server
2 104 (15.18%) SQL Server Reporting Services
3 86 (12.55%) SQL Server Integration Services
4 55 (8.03%) QlikView
5 53 (7.74%) Power BI
5 53 (7.74%) Relational Database
6 48 (7.01%) NoSQL
7 45 (6.57%) MySQL
8 43 (6.28%) Crystal Reports
9 33 (4.82%) MS Access
9 33 (4.82%) Oracle Reports
10 30 (4.38%) Oracle BI EE
11 25 (3.65%) Data Warehouse
12 22 (3.21%) Apache Hive
12 22 (3.21%) BusinessObjects
13 21 (3.07%) Hadoop
13 21 (3.07%) MongoDB
13 21 (3.07%) SQL Server 2008
14 19 (2.77%) Oracle Database
15 17 (2.48%) SQL Server Analysis Services
Development Applications
1 65 (9.49%) Team Foundation Server
2 41 (5.99%) Visual Studio
3 36 (5.26%) Git (software)
4 25 (3.65%) JIRA
5 18 (2.63%) Eclipse
5 18 (2.63%) Jenkins
6 16 (2.34%) Subversion
6 16 (2.34%) Visual Studio Tools for Office
7 15 (2.19%) InstallShield
8 10 (1.46%) Artifactory
9 9 (1.31%) Axure RP
9 9 (1.31%) SQL Server Management Studio (SSMS)
10 4 (0.58%) NUnit
11 3 (0.44%) GCC
11 3 (0.44%) GDB
11 3 (0.44%) SonarQube
11 3 (0.44%) TeamCity
11 3 (0.44%) Visual Studio Team System
12 2 (0.29%) dotCover
12 2 (0.29%) dotTrace
General
1 403 (58.83%) Finance
2 119 (17.37%) Banking
3 110 (16.06%) Front Office
4 76 (11.09%) Marketing
5 29 (4.23%) Retail
6 23 (3.36%) Investment Banking
7 18 (2.63%) Legal
8 15 (2.19%) Back Office
9 13 (1.90%) Law
10 10 (1.46%) Financial Institution
11 9 (1.31%) Retail Banking
11 9 (1.31%) Telecoms
12 6 (0.88%) Games
13 3 (0.44%) Advertising
13 3 (0.44%) Billing
13 3 (0.44%) Publishing
14 1 (0.15%) French Language
14 1 (0.15%) Manufacturing
14 1 (0.15%) Private Banking
Job Titles
1 302 (44.09%) Developer
2 237 (34.60%) Analyst
3 91 (13.28%) C# Developer
4 80 (11.68%) SQL Developer
5 70 (10.22%) Data Analyst
6 63 (9.20%) SQL Analyst
7 60 (8.76%) Consultant
8 47 (6.86%) VBA Developer
9 36 (5.26%) Junior
10 34 (4.96%) Report Analyst
11 33 (4.82%) SQL Data Analyst
12 31 (4.53%) Excel Developer
12 31 (4.53%) Software Developer
13 28 (4.09%) Front Office Developer
14 27 (3.94%) Business Analyst
14 27 (3.94%) Data Consultant
15 26 (3.80%) Analyst Developer
15 26 (3.80%) Excel VBA Developer
15 26 (3.80%) Financial Analyst
16 25 (3.65%) Business Intelligence Analyst
Libraries, Frameworks & Software Standards
1 141 (20.58%) .NET
2 71 (10.36%) HTML
3 61 (8.91%) XML
4 57 (8.32%) .NET Framework
5 36 (5.26%) CSS
6 34 (4.96%) AngularJS
7 32 (4.67%) WCF
8 28 (4.09%) WPF
9 24 (3.50%) WinForms
10 23 (3.36%) jQuery
11 21 (3.07%) ASP.NET
11 21 (3.07%) Web Services
12 20 (2.92%) JSON
13 18 (2.63%) HTML5
14 16 (2.34%) REST
15 15 (2.19%) Node.js
15 15 (2.19%) React
15 15 (2.19%) Software Packaging
16 12 (1.75%) XSLT
17 9 (1.31%) FIX Protocol
Miscellaneous
1 120 (17.52%) Analytical Skills
2 71 (10.36%) Computer Science
3 48 (7.01%) Fixed Income
4 47 (6.86%) Management Information System
5 46 (6.72%) Equities
6 30 (4.38%) Derivative
7 21 (3.07%) Foreign Exchange (FX)
8 20 (2.92%) Credit Risk
9 19 (2.77%) Hedge funds
10 16 (2.34%) Fintech
11 14 (2.04%) Greenfield Project
12 11 (1.61%) Data Structures
13 10 (1.46%) Reinsurance
14 8 (1.17%) Algorithms
14 8 (1.17%) Enterprise Software
14 8 (1.17%) User Experience
15 6 (0.88%) Equity Derivative
15 6 (0.88%) Market Risk
15 6 (0.88%) NHS
16 5 (0.73%) Contract for Difference
Operating Systems
1 50 (7.30%) Windows
2 40 (5.84%) Unix
3 38 (5.55%) Linux
4 8 (1.17%) Windows Server 2008
4 8 (1.17%) Windows Server 2012
5 7 (1.02%) Windows Server
6 3 (0.44%) Mac OS X
6 3 (0.44%) Windows 7
7 2 (0.29%) Android
8 1 (0.15%) CentOS
Processes & Methodologies
1 169 (24.67%) Analytics
2 118 (17.23%) Business Intelligence
3 110 (16.06%) Agile Software Development
4 92 (13.43%) Mathematics
5 89 (12.99%) Data Modelling
6 82 (11.97%) Data Analysis
7 79 (11.53%) Visualisation
8 76 (11.09%) Asset Management
9 70 (10.22%) Data Analytics
10 63 (9.20%) Project Management
11 59 (8.61%) OO
12 52 (7.59%) SDLC
13 49 (7.15%) Risk Management
14 46 (6.72%) Business Analysis
15 45 (6.57%) Portfolio Management
16 41 (5.99%) ETL
17 40 (5.84%) Investment Management
18 39 (5.69%) Test Automation
19 36 (5.26%) Data Management
19 36 (5.26%) Scrum
Programming Languages
1 507 (74.01%) SQL
2 176 (25.69%) C#
3 119 (17.37%) Python
4 114 (16.64%) T-SQL
5 85 (12.41%) VB
6 80 (11.68%) R
7 73 (10.66%) JavaScript
8 70 (10.22%) Java
9 47 (6.86%) VB.NET
10 34 (4.96%) PowerShell
11 32 (4.67%) C++
12 28 (4.09%) MATLAB
12 28 (4.09%) PL/SQL
13 22 (3.21%) PHP
14 20 (2.92%) Perl
15 15 (2.19%) VBScript
16 9 (1.31%) C
16 9 (1.31%) XPath
17 7 (1.02%) Shell Script
18 6 (0.88%) F#
Qualifications
1 134 (19.56%) Degree
2 33 (4.82%) Computer Science Degree
3 15 (2.19%) PhD
4 13 (1.90%) ACCA
5 11 (1.61%) CIMA
6 10 (1.46%) Master's Degree
7 5 (0.73%) Numerate Degree
8 4 (0.58%) MBA
9 3 (0.44%) CFA
9 3 (0.44%) ISEB
9 3 (0.44%) ITIL Certification
9 3 (0.44%) Security Cleared
10 2 (0.29%) PMI Certification
10 2 (0.29%) PMP
11 1 (0.15%) CBAP
Quality Assurance & Compliance
1 32 (4.67%) Data Quality
2 25 (3.65%) QA
3 22 (3.21%) GDPR
4 8 (1.17%) PMO
5 4 (0.58%) MiFID
5 4 (0.58%) Solvency II
6 3 (0.44%) EMIR
7 2 (0.29%) GAAP
7 2 (0.29%) ISAE 3402
7 2 (0.29%) Sarbanes-Oxley
7 2 (0.29%) SLA
8 1 (0.15%) Actionable Recommendations
8 1 (0.15%) UCITS
System Software
1 25 (3.65%) Active Directory
2 5 (0.73%) HDFS
3 4 (0.58%) Docker
Systems Management
1 15 (2.19%) SCCM
2 8 (1.17%) Control-M
3 3 (0.44%) Systems Management Server (SMS)
4 2 (0.29%) EnCase
4 2 (0.29%) FTK
5 1 (0.15%) Kibana
5 1 (0.15%) Oracle Identity Management
Vendors
1 147 (21.46%) Microsoft
2 141 (20.58%) Oracle
3 121 (17.66%) Tableau
4 23 (3.36%) Google
5 22 (3.21%) SAP
6 20 (2.92%) Cognos
7 18 (2.63%) Bloomberg
8 17 (2.48%) Infor
9 15 (2.19%) Vertica
10 14 (2.04%) Alteryx
11 13 (1.90%) Hyperion
11 13 (1.90%) IBM
11 13 (1.90%) Informatica
12 11 (1.61%) Reuters
12 11 (1.61%) Salesforce.com
12 11 (1.61%) Sybase
13 9 (1.31%) Sun
14 8 (1.17%) Twitter
15 7 (1.02%) Adobe
15 7 (1.02%) Intapp