The table below looks at the statistics for VBA skills in IT jobs advertised for the City of London region. Included is a guide to the salaries offered in IT jobs that have cited VBA over the 3 months to 25 June 2016 with a comparison to the same period over the previous 2 years.

3 months to
25 Jun 2016
Same period 2015 Same period 2014
Microsoft Visual Basic for Applications (VBA)
Rank 151 164 143
Rank change year-on-year
+13 -21
Permanent jobs citing VBA 111 148 263
As % of all permanent IT jobs located in the City of London 1.76% 1.43% 2.00%
As % of the Programming Languages category 3.08% 2.76% 3.79%
Number of salaries quoted 95 128 213
Median salary £51,500 £56,000 £52,500
Median salary % change year-on-year
-8.03% +6.66%
90% offered a salary of more than £40,000 £33,500 £32,800
10% offered a salary of more than £60,300 £85,900 £69,700
UK excluding London median salary £37,500 £35,000 £34,000
% change year-on-year
+7.14% +2.94%
VBA
London

The following table is for comparison with the above and provides statistics for the entire Programming Languages category in permanent jobs advertised in the City of London region.

Programming Languages Category
City of London
Permanent IT job ads with a match in the
Programming Languages category
3602 5368 6944
As % of all permanent IT jobs located in the City of London 57.24% 51.88% 52.86%
Number of salaries quoted 3300 4748 6021
Median salary £57,500 £55,000 £55,000
Median salary % change year-on-year
+4.54% -
90% offered a salary of more than £40,000 £37,500 £35,000
10% offered a salary of more than £80,300 £77,500 £80,000
UK excluding London median salary £41,000 £40,000 £40,000
% change year-on-year
+2.50% -

VBA
Jobs Demand Trend in the City of London

The demand trend of job ads across the City of London region citing VBA as a proportion of all IT jobs with a match in the Programming Languages category.

VBA Jobs Demand Trend in the City of London

VBA
Salary Trend in the City of London

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

VBA Salary Trend in the City of London

VBA
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing VBA across the City of London region over the 3 months to 25 June 2016.

VBA Salary Histogram in the City of London

VBA
Top 30 Related IT Skills in the City of London

For the 6 months to 25 June 2016, 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 across the City of London region with a requirement for VBA.

1 189 (77.14%) SQL
2 113 (46.12%) Finance
3 87 (35.51%) MS Excel
4 84 (34.29%) SQL Server
5 78 (31.84%) SQL Server Reporting Services
6 74 (30.20%) Degree
7 71 (28.98%) Analytical Skills
8 65 (26.53%) Business Intelligence
9 60 (24.49%) Microsoft
10 50 (20.41%) SQL Server Analysis Services
11 49 (20.00%) VB
12 48 (19.59%) SQL Server Integration Services
13 45 (18.37%) Cognos
13 45 (18.37%) Management Information System
14 39 (15.92%) Computer Science
15 38 (15.51%) Oracle
15 38 (15.51%) C#
16 36 (14.69%) Mathematics
16 36 (14.69%) Analytics
17 34 (13.88%) IBM
18 33 (13.47%) SAS
18 33 (13.47%) Data Analysis
18 33 (13.47%) Cognos TM1
19 32 (13.06%) XML
20 30 (12.24%) Java
20 30 (12.24%) Data Modelling
20 30 (12.24%) Banking
20 30 (12.24%) Cognos Planning
21 27 (11.02%) .NET
22 26 (10.61%) T-SQL

VBA
Top Related IT Skills in the City of 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 33 (13.47%) SAS
2 11 (4.49%) SharePoint
3 9 (3.67%) Tomcat
4 4 (1.63%) Apache Spark
4 4 (1.63%) IIS
5 3 (1.22%) SharePoint 2013
5 3 (1.22%) WebLogic
6 2 (0.82%) JBoss
6 2 (0.82%) WebSphere
7 1 (0.41%) Apache
7 1 (0.41%) Apache Solr
Applications
1 87 (35.51%) MS Excel
2 20 (8.16%) MS Office
3 7 (2.86%) MS PowerPoint
4 6 (2.45%) MS Visio
4 6 (2.45%) Spreadsheet
5 2 (0.82%) XMetaL
6 1 (0.41%) MS Project
6 1 (0.41%) SPSS
Business Applications
1 33 (13.47%) Cognos TM1
2 30 (12.24%) Cognos Planning
3 5 (2.04%) HFM
4 3 (1.22%) Hyperion Planning
4 3 (1.22%) Summit
5 2 (0.82%) Cognos Business Intelligence
5 2 (0.82%) Oracle EBS R12
5 2 (0.82%) SunGard GMI
5 2 (0.82%) Visualfiles
Cloud Services
1 4 (1.63%) Amazon AWS
2 2 (0.82%) Google Analytics
Communications & Networking
1 1 (0.41%) DHCP
1 1 (0.41%) DNS
1 1 (0.41%) Intranet
1 1 (0.41%) WebEx
Database & Business Intelligence
1 84 (34.29%) SQL Server
2 78 (31.84%) SQL Server Reporting Services
3 50 (20.41%) SQL Server Analysis Services
4 48 (19.59%) SQL Server Integration Services
5 26 (10.61%) Relational Database
6 24 (9.80%) QlikView
7 23 (9.39%) Data Warehouse
8 19 (7.76%) Crystal Reports
9 18 (7.35%) MS Access
10 17 (6.94%) SQL Server 2008
11 16 (6.53%) PowerPivot
12 11 (4.49%) Big Data
12 11 (4.49%) Hadoop
12 11 (4.49%) SQL Server 2005
13 9 (3.67%) Microsoft Analysis Services
13 9 (3.67%) Oracle Database
13 9 (3.67%) Power BI
13 9 (3.67%) SQLPlus
14 7 (2.86%) SQL Server 2012
14 7 (2.86%) SQL Server 2014
Development Applications
1 7 (2.86%) SQL Server Management Studio (SSMS)
1 7 (2.86%) Visual Studio
2 6 (2.45%) Eclipse
3 5 (2.04%) Team Foundation Server
4 3 (1.22%) Visual Studio Tools for Office
5 1 (0.41%) Atlassian Bamboo
5 1 (0.41%) ClearCase
5 1 (0.41%) JIRA
General
1 113 (46.12%) Finance
2 30 (12.24%) Banking
3 23 (9.39%) Front Office
4 21 (8.57%) Advertising
5 18 (7.35%) Legal
6 13 (5.31%) Billing
7 12 (4.90%) Investment Banking
8 8 (3.27%) Back Office
8 8 (3.27%) Law
8 8 (3.27%) Retail
9 7 (2.86%) Spanish Language
10 6 (2.45%) Telecoms
11 5 (2.04%) German Language
11 5 (2.04%) Mandarin Language
12 4 (1.63%) Marketing
12 4 (1.63%) Publishing
13 3 (1.22%) International Banking
14 2 (0.82%) Italian Language
Job Titles
1 118 (48.16%) Analyst
2 77 (31.43%) Developer
3 32 (13.06%) Systems Analyst
3 32 (13.06%) VBA Developer
4 26 (10.61%) Business Intelligence Analyst
5 25 (10.20%) Business Systems Analyst
5 25 (10.20%) Excel Developer
6 23 (9.39%) SQL Analyst
7 22 (8.98%) SQL Developer
8 21 (8.57%) Actuarial Analyst
9 20 (8.16%) Data Analyst
9 20 (8.16%) Excel VBA Developer
10 19 (7.76%) Applications Support
11 17 (6.94%) Business Analyst
12 16 (6.53%) Support Analyst
13 15 (6.12%) Applications Support Analyst
14 14 (5.71%) Consultant
14 14 (5.71%) Excel Analyst
15 12 (4.90%) TM1 Analyst
16 11 (4.49%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 32 (13.06%) XML
2 27 (11.02%) .NET
3 17 (6.94%) HTML
4 13 (5.31%) MDX
5 10 (4.08%) CSS
5 10 (4.08%) Web Services
5 10 (4.08%) XML Messaging
6 9 (3.67%) SonicMQ
7 5 (2.04%) jQuery
8 4 (1.63%) ASP.NET
8 4 (1.63%) ASP.NET Web API
8 4 (1.63%) XSL
9 3 (1.22%) PostGIS
10 2 (0.82%) FIX Protocol
10 2 (0.82%) Java EE 5
10 2 (0.82%) JBoss Seam
10 2 (0.82%) SOAP
10 2 (0.82%) XHTML
10 2 (0.82%) XML Schema
10 2 (0.82%) XSLT
Miscellaneous
1 71 (28.98%) Analytical Skills
2 45 (18.37%) Management Information System
3 39 (15.92%) Computer Science
4 36 (14.69%) Mathematics
5 18 (7.35%) Derivative
6 17 (6.94%) Fixed Income
7 14 (5.71%) Economics
7 14 (5.71%) Foreign Exchange (FX)
7 14 (5.71%) Statistics
8 10 (4.08%) Data Structures
9 9 (3.67%) OTC Derivatives
10 8 (3.27%) Equities
11 6 (2.45%) Physics
12 5 (2.04%) Algorithms
12 5 (2.04%) Data Protection Act
12 5 (2.04%) Hedge funds
12 5 (2.04%) Visualisation
13 4 (1.63%) Data Integration
13 4 (1.63%) Market Risk
13 4 (1.63%) Swaptions
Operating Systems
1 20 (8.16%) Unix
2 13 (5.31%) Linux
3 10 (4.08%) Windows
4 7 (2.86%) Windows Server
5 6 (2.45%) Windows 7
6 2 (0.82%) Solaris
Processes & Methodologies
1 65 (26.53%) Business Intelligence
2 36 (14.69%) Analytics
3 33 (13.47%) Data Analysis
4 30 (12.24%) Data Modelling
5 19 (7.76%) Data Management
5 19 (7.76%) ITIL
6 17 (6.94%) Migration
7 16 (6.53%) Risk Management
8 14 (5.71%) ETL
9 12 (4.90%) Business Analysis
9 12 (4.90%) Data Analytics
10 11 (4.49%) Data Cleansing
10 11 (4.49%) Kimball Methodology
10 11 (4.49%) UML
11 10 (4.08%) Agile Software Development
11 10 (4.08%) Project Management
11 10 (4.08%) Statistical Modelling
12 9 (3.67%) Asset Management
12 9 (3.67%) Investment Management
12 9 (3.67%) SDLC
Programming Languages
1 189 (77.14%) SQL
2 49 (20.00%) VB
3 38 (15.51%) C#
4 30 (12.24%) Java
5 26 (10.61%) Python
5 26 (10.61%) T-SQL
6 22 (8.98%) VB6
7 21 (8.57%) C++
8 19 (7.76%) JavaScript
9 15 (6.12%) VBScript
10 14 (5.71%) Perl
11 12 (4.90%) R
12 7 (2.86%) MATLAB
12 7 (2.86%) PowerShell
12 7 (2.86%) Shell Script
13 6 (2.45%) C
14 5 (2.04%) Bash Shell
15 4 (1.63%) VB.NET
16 3 (1.22%) Objective-C
17 2 (0.82%) Ruby
Qualifications
1 74 (30.20%) Degree
2 7 (2.86%) ITIL Certification
3 6 (2.45%) PhD
4 3 (1.22%) ACCA
4 3 (1.22%) CIMA
5 2 (0.82%) MOS
5 2 (0.82%) Postgraduate
6 1 (0.41%) AAT
6 1 (0.41%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 22 (8.98%) Data Quality
2 11 (4.49%) PCI DSS
3 7 (2.86%) Solvency II
4 6 (2.45%) SSAE 16
5 2 (0.82%) ISO 9001
5 2 (0.82%) QA
5 2 (0.82%) SLA
6 1 (0.41%) EMIR
6 1 (0.41%) MiFID
System Software
1 3 (1.22%) Active Directory
Systems Management
1 1 (0.41%) BladeLogic
1 1 (0.41%) Control-M
Vendors
1 60 (24.49%) Microsoft
2 45 (18.37%) Cognos
3 38 (15.51%) Oracle
4 34 (13.88%) IBM
5 25 (10.20%) Tableau
6 9 (3.67%) Bloomberg
7 7 (2.86%) Reuters
7 7 (2.86%) Trayport
8 6 (2.45%) Google
8 6 (2.45%) Hyperion
8 6 (2.45%) OpenLink
9 5 (2.04%) Sun
10 4 (1.63%) MicroStrategy
10 4 (1.63%) Omniture
10 4 (1.63%) Salesforce.com
11 3 (1.22%) Calypso
11 3 (1.22%) Mapinfo
11 3 (1.22%) Murex
11 3 (1.22%) Vermilion
11 3 (1.22%) Wall Street Systems
City, London
Quant Capital
Salary: From £50,000 to £55,000 per annum + benefits and bonus
Posted: Yesterday
City, London
Harrington Starr
Salary: £30000 - £35000 per annum
Posted: 2 days ago
City of London
CGI IT UK
Salary: £30000 - £60000 per annum + benefits
Posted: 2 days ago
City, London
Quant Capital
Salary: From £35,000 to £50,000 per annum + bonus and benefits
Posted: Yesterday
City, London
Deerfoot IT Resources Ltd
Salary: £60000 - £65000 per annum
Posted: 4 days ago
City, London
Tate and Lyle
Posted: 17 days ago
City Of London
HFG
Salary: Competitive Salary
Posted: 27 days ago
City, London
ANSON MCCADE
Salary: £40,000 - £50,000 plus exceptional benefits package
Posted: 2 days ago
City of London
Real Staffing
Salary: £40000 - £55000 per annum + BENEFITS
Posted: 22 days ago
City of London
Deerfoot IT Resources Ltd
Salary: £50000 - £65000 per annum + Bonus
Posted: 25 days ago
City of London
Real Staffing
Salary: £40000 - £60000 per annum + bens and bonus
Posted: 22 days ago
City of London
Deerfoot IT Resources Ltd
Salary: £60000 - £61000 per annum
Posted: 23 days ago