VBA Jobs in the City of London

The following table provides summary statistics for permanent job vacancies advertised in the City of London with a requirement for VBA skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited VBA over the 3 months to 24 June 2017 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA) London / City of London
Location	3 months to 24 Jun 2017	Same period 2016	Same period 2015
Rank	162	154	175
Rank change year-on-year	-8	+21
Permanent jobs citing VBA	74	113	147
As % of all permanent IT jobs advertised in the City of London	1.44%	1.78%	1.42%
As % of the Programming Languages category	2.55%	3.11%	2.73%
Number of salaries quoted	65	97	128
Median salary	£55,000	£51,500	£55,000
Median salary % change year-on-year	+6.79%	-6.36%
90% offered a salary of more than	£40,000	£40,000	£33,500
10% offered a salary of more than	£77,500	£60,200	£85,000
UK excluding London median salary	£35,000	£37,500	£35,000
% change year-on-year	-6.66%	+7.14%

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 advertised in the City of London with a requirement for programming language skills.

Programming Language Skills City of London
Permanent job vacancies with a requirement for programming language skills	2904	3639	5387
As % of all permanent IT job vacancies advertised in the City of London	56.42%	57.32%	51.86%
Number of salaries quoted	2600	3334	4774
Median salary	£60,000	£57,500	£55,000
Median salary % change year-on-year	+4.34%	+4.54%
90% offered a salary of more than	£40,000	£40,000	£37,500
10% offered a salary of more than	£90,000	£77,500	£80,000
UK excluding London median salary	£42,500	£41,000	£40,000
% change year-on-year	+3.65%	+2.50%

VBA
Job Vacancy Trend in the City of London

The job posting trend of jobs advertised in the City of London citing VBA as a proportion of all permanent or contract IT jobs with a match in the Programming Languages category.

Job vacancy trend for VBA 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 in the City of London.

Salary trend for VBA in the City of London

VBA
Salary Histogram in the City of London

The salary distribution of IT jobs citing VBA in the City of London over the 3 months to 24 June 2017.

Salary histogram for VBA in the City of London

VBA
Top 30 Co-occurring IT Skills in the City of London

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

1	117 (83.57%)	Microsoft Excel
2	94 (67.14%)	SQL
3	74 (52.86%)	SQL Server
4	67 (47.86%)	Finance
5	59 (42.14%)	C#
6	54 (38.57%)	Degree
7	53 (37.86%)	.NET
8	40 (28.57%)	XML
9	36 (25.71%)	Front Office
10	35 (25.00%)	JavaScript
11	33 (23.57%)	T-SQL
12	31 (22.14%)	Banking
13	30 (21.43%)	ASP.NET
13	30 (21.43%)	SharePoint
14	28 (20.00%)	CRM

14	28 (20.00%)	MVC
15	27 (19.29%)	SQL Server 2012
15	27 (19.29%)	SharePoint 2013
15	27 (19.29%)	Analytical Skills
16	26 (18.57%)	Team Foundation Server
16	26 (18.57%)	CSS
16	26 (18.57%)	Visual Studio
16	26 (18.57%)	Agile Software Development
17	25 (17.86%)	Computer Science
17	25 (17.86%)	Web Services
17	25 (17.86%)	Microsoft
17	25 (17.86%)	Twitter Bootstrap
17	25 (17.86%)	AngularJS
18	24 (17.14%)	Computer Science Degree
19	23 (16.43%)	Microsoft Azure

VBA
Co-occurring 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
Applications
Business Applications
Cloud Services
Communications & Networking
Database & Business Intelligence
Development Applications
General
Job Titles
Libraries, Frameworks & Software Standards
Miscellaneous
Operating Systems
Processes & Methodologies
Programming Languages
Qualifications
Quality Assurance & Compliance
System Software
Systems Management
Vendors

Application Platforms
1	30 (21.43%)	SharePoint
2	27 (19.29%)	SharePoint 2013
3	4 (2.86%)	CMS
3	4 (2.86%)	IBM Domino
3	4 (2.86%)	IIS
3	4 (2.86%)	SAS
3	4 (2.86%)	Sitefinity
3	4 (2.86%)	Umbraco
4	3 (2.14%)	SharePoint 2010
5	1 (0.71%)	Blackberry Enterprise Server
5	1 (0.71%)	Oracle SOA Suite

Applications
1	117 (83.57%)	Microsoft Excel
2	11 (7.86%)	Spreadsheet
3	5 (3.57%)	Microsoft Office
4	4 (2.86%)	Microsoft PowerPoint
5	2 (1.43%)	MS Visio
6	1 (0.71%)	SPSS
6	1 (0.71%)	XMetaL

Business Applications
1	8 (5.71%)	SAP BPC
2	2 (1.43%)	Endur
3	1 (0.71%)	Markit EDM

Cloud Services
1	23 (16.43%)	Microsoft Azure
2	21 (15.00%)	Cloud Computing
3	4 (2.86%)	Basecamp
3	4 (2.86%)	GitHub
4	3 (2.14%)	Adobe Analytics
4	3 (2.14%)	Google Analytics
4	3 (2.14%)	Office 365
4	3 (2.14%)	SaaS

Communications & Networking
1	4 (2.86%)	HTTP
2	3 (2.14%)	DHCP
2	3 (2.14%)	DNS

Database & Business Intelligence
1	74 (52.86%)	SQL Server
2	27 (19.29%)	SQL Server 2012
3	23 (16.43%)	SQL Server Integration Services
4	22 (15.71%)	SQL Server Reporting Services
5	21 (15.00%)	SQL Server 2016
6	15 (10.71%)	SQL Server Analysis Services
7	13 (9.29%)	Power BI
8	12 (8.57%)	BusinessObjects
8	12 (8.57%)	QlikView
9	10 (7.14%)	SQL Server 2008
10	8 (5.71%)	BusinessObjects Business Intelligence
10	8 (5.71%)	Relational Database
10	8 (5.71%)	SAP BW
11	6 (4.29%)	Data Warehouse
11	6 (4.29%)	MS Access
12	4 (2.86%)	NoSQL
12	4 (2.86%)	Qlik Sense
12	4 (2.86%)	SQL Server 2014
13	3 (2.14%)	Data Mining
13	3 (2.14%)	Oracle BI EE

Development Applications
1	26 (18.57%)	Team Foundation Server
1	26 (18.57%)	Visual Studio
2	5 (3.57%)	JIRA
3	4 (2.86%)	CruiseControl
3	4 (2.86%)	NCover
3	4 (2.86%)	NDoc
3	4 (2.86%)	NUnit
3	4 (2.86%)	Talend Open Studio
3	4 (2.86%)	TeamCity
4	3 (2.14%)	InstallShield
5	2 (1.43%)	Eclipse
5	2 (1.43%)	SQL Server Management Studio (SSMS)
6	1 (0.71%)	Axure RP
6	1 (0.71%)	ERwin

General
1	67 (47.86%)	Finance
2	36 (25.71%)	Front Office
3	31 (22.14%)	Banking
4	18 (12.86%)	Investment Banking
5	15 (10.71%)	Advertising
6	7 (5.00%)	Back Office
7	5 (3.57%)	French Language
7	5 (3.57%)	German Language
8	4 (2.86%)	Corporate Banking
8	4 (2.86%)	Marketing
9	3 (2.14%)	Law
10	2 (1.43%)	Retail
11	1 (0.71%)	Games
11	1 (0.71%)	Hungarian Language
11	1 (0.71%)	Italian Language
11	1 (0.71%)	Legal
11	1 (0.71%)	Norwegian Language
11	1 (0.71%)	Polish Language
11	1 (0.71%)	Publishing
11	1 (0.71%)	Telecoms

Job Titles
1	54 (38.57%)	Analyst
2	35 (25.00%)	Developer
3	21 (15.00%)	Architect
3	21 (15.00%)	Technical Architect
4	18 (12.86%)	Data Analyst
5	14 (10.00%)	Business Analyst
6	13 (9.29%)	Technical Analyst
7	11 (7.86%)	Business Intelligence Developer
7	11 (7.86%)	Support Analyst
8	10 (7.14%)	SQL Analyst
9	9 (6.43%)	Applications Architect
9	9 (6.43%)	Banking Analyst
9	9 (6.43%)	Investment Banking Business Analyst
9	9 (6.43%)	Technical Business Analyst
10	8 (5.71%)	Front Office Developer
10	8 (5.71%)	SAP Manager
10	8 (5.71%)	Solutions Architect
10	8 (5.71%)	Systems Manager
10	8 (5.71%)	Technical Solutions Architect
11	7 (5.00%)	Business Developer

Libraries, Frameworks & Software Standards
1	53 (37.86%)	.NET
2	40 (28.57%)	XML
3	30 (21.43%)	ASP.NET
4	26 (18.57%)	CSS
5	25 (17.86%)	AngularJS
5	25 (17.86%)	Twitter Bootstrap
5	25 (17.86%)	Web Services
6	22 (15.71%)	jQuery
6	22 (15.71%)	WCF
6	22 (15.71%)	WPF
7	21 (15.00%)	ASP.NET Web API
8	11 (7.86%)	HTML
9	10 (7.14%)	.NET Framework
10	5 (3.57%)	JSON
10	5 (3.57%)	XSLT
11	4 (2.86%)	Ajax
11	4 (2.86%)	Microsoft Enterprise Library
11	4 (2.86%)	REST
11	4 (2.86%)	SOAP
12	3 (2.14%)	Entity Framework

Miscellaneous
1	27 (19.29%)	Analytical Skills
2	25 (17.86%)	Computer Science
3	21 (15.00%)	Client/Server
3	21 (15.00%)	N-Tier
4	13 (9.29%)	Management Information System
5	12 (8.57%)	Derivative
6	9 (6.43%)	Market Risk
7	7 (5.00%)	Data Structures
8	6 (4.29%)	Fat Client
8	6 (4.29%)	Foreign Exchange (FX)
8	6 (4.29%)	Thin Client
8	6 (4.29%)	User Experience
9	5 (3.57%)	OTC Derivatives
9	5 (3.57%)	Swaptions
10	4 (2.86%)	Credit Risk
11	3 (2.14%)	Fixed Income
12	2 (1.43%)	Equities
12	2 (1.43%)	NHS
13	1 (0.71%)	Blackberry
13	1 (0.71%)	Semantic Web

Operating Systems
1	13 (9.29%)	Windows
2	10 (7.14%)	Windows Server 2012
3	6 (4.29%)	Windows Server 2008
4	4 (2.86%)	Windows 7
5	2 (1.43%)	Linux
6	1 (0.71%)	Unix
6	1 (0.71%)	Windows 10

Processes & Methodologies
1	28 (20.00%)	CRM
1	28 (20.00%)	MVC
2	26 (18.57%)	Agile Software Development
3	23 (16.43%)	Business Intelligence
4	22 (15.71%)	SOA
5	21 (15.00%)	Continuous Integration
5	21 (15.00%)	Software Architecture
5	21 (15.00%)	System Testing
5	21 (15.00%)	Technical Architecture
5	21 (15.00%)	Test Automation
5	21 (15.00%)	TOGAF
5	21 (15.00%)	Zachman Framework
6	18 (12.86%)	BPR
6	18 (12.86%)	Mathematics
6	18 (12.86%)	SOLID
6	18 (12.86%)	Systems Analysis
7	17 (12.14%)	Analytics
8	15 (10.71%)	RAD
9	12 (8.57%)	Stakeholder Management
10	10 (7.14%)	ETL

Programming Languages
1	94 (67.14%)	SQL
2	59 (42.14%)	C#
3	35 (25.00%)	JavaScript
4	33 (23.57%)	T-SQL
5	12 (8.57%)	Python
6	10 (7.14%)	VB
7	7 (5.00%)	C
8	6 (4.29%)	C++
9	5 (3.57%)	F#
9	5 (3.57%)	Java
10	4 (2.86%)	MATLAB
10	4 (2.86%)	PowerShell
10	4 (2.86%)	R
11	3 (2.14%)	Perl
12	2 (1.43%)	Haskell
12	2 (1.43%)	PHP
12	2 (1.43%)	Scala
12	2 (1.43%)	VB.NET
13	1 (0.71%)	Shell Script
13	1 (0.71%)	VBScript

Qualifications
1	54 (38.57%)	Degree
2	24 (17.14%)	Computer Science Degree
3	4 (2.86%)	MCP
4	1 (0.71%)	ACCA
4	1 (0.71%)	CIMA
4	1 (0.71%)	Numerate Degree
4	1 (0.71%)	PhD

Quality Assurance & Compliance
1	9 (6.43%)	Data Quality
2	8 (5.71%)	QA
3	2 (1.43%)	PMO
3	2 (1.43%)	SLA
4	1 (0.71%)	ISO 9001
4	1 (0.71%)	Sarbanes-Oxley

System Software
1	9 (6.43%)	Active Directory
2	6 (4.29%)	XenApp
2	6 (4.29%)	XenDesktop
3	3 (2.14%)	XenServer
4	1 (0.71%)	Virtual Servers

Systems Management
1	3 (2.14%)	SCCM

Vendors
1	25 (17.86%)	Microsoft
2	17 (12.14%)	Tableau
3	16 (11.43%)	Oracle
4	11 (7.86%)	Bloomberg
5	10 (7.14%)	SAP
6	9 (6.43%)	Siebel
7	6 (4.29%)	Citrix
7	6 (4.29%)	Reuters
8	4 (2.86%)	Cisco
8	4 (2.86%)	Cognos
8	4 (2.86%)	FactSet
8	4 (2.86%)	Hyperion
8	4 (2.86%)	Talend
9	3 (2.14%)	Adobe
9	3 (2.14%)	EMC
9	3 (2.14%)	Google
9	3 (2.14%)	HP
9	3 (2.14%)	IBM
9	3 (2.14%)	Mitel
10	2 (1.43%)	Coremetrics