The table below looks at the statistics for VBA skills in IT jobs advertised for the Canary Wharf region. Included is a guide to the average salaries offered in IT jobs that have cited VBA over the 3 months to 22 August 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
22 Aug 2014
Same period 2013 Same period 2012
Microsoft Visual Basic for Applications (VBA)
Rank 27 34 47
Rank change year-on-year
+7 +13
Permanent jobs citing VBA 1 1 10
As % of all permanent IT jobs located in Canary Wharf 0.65% 0.53% 2.38%
As % of the Programming Languages category 2.22% 0.75% 4.85%
Number of salaries quoted 1 1 10
Average salary £60,000 £45,000 £62,500
Average salary % change year-on-year
+33.33% -28.00%
UK excluding London average salary £32,500 £34,000 £32,500
% change year-on-year
-4.41% +4.61%
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 Canary Wharf region.

Programming Languages Category
Canary Wharf
Permanent IT job ads with a match in the
Programming Languages category
45 134 206
As % of all permanent IT jobs located in Canary Wharf 29.03% 70.90% 48.93%
Number of salaries quoted 37 121 163
Average salary £65,000 £85,000 £75,000
Average salary % change year-on-year
-23.52% +13.33%
90% offered a salary of more than £32,000 £47,500 £51,500
10% offered a salary of more than £100,000 £100,000 £110,000
UK excluding London average salary £40,000 £37,500 £37,500
% change year-on-year
+6.66% -

VBA
Jobs Demand Trend in Canary Wharf

This chart provides a 3-month moving total of permanent IT jobs citing VBA across the Canary Wharf region as a proportion of the total demand within the Programming Languages category.

VBA Jobs Demand Trend in Canary Wharf

VBA
Salary Trend in Canary Wharf

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

VBA Salary Trend in Canary Wharf

VBA
Top 26 Related IT Skills in Canary Wharf

For the 6 months to 22 August 2014, IT jobs across the Canary Wharf region citing VBA also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited VBA.

1 2 (66.67%) SQL
1 2 (66.67%) MS Excel
2 1 (33.33%) PhD
2 1 (33.33%) Data Modelling
2 1 (33.33%) Microsoft
2 1 (33.33%) Project Management
2 1 (33.33%) SQL Server
2 1 (33.33%) XML
2 1 (33.33%) Windows
2 1 (33.33%) C++
2 1 (33.33%) HTML
2 1 (33.33%) Front Office
2 1 (33.33%) Finance
2 1 (33.33%) Publishing
2 1 (33.33%) Banking
2 1 (33.33%) Investment Banking
2 1 (33.33%) Business Analysis
2 1 (33.33%) Taxonomies
2 1 (33.33%) JIRA
2 1 (33.33%) QA
2 1 (33.33%) QlikView
2 1 (33.33%) Market Risk
2 1 (33.33%) Pega
2 1 (33.33%) HP Quality Center
2 1 (33.33%) Hedge funds
2 1 (33.33%) Data Transformation

VBA
Top Related IT Skills in Canary Wharf by Category

For the 6 months to 22 August 2014, IT jobs across the Canary Wharf region citing VBA also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited VBA. Up to 20 skills are shown per category.

Applications
1 2 (66.67%) MS Excel
Database & Business Intelligence
1 1 (33.33%) SQL Server
1 1 (33.33%) QlikView
Development Applications
1 1 (33.33%) JIRA
General
1 1 (33.33%) Front Office
1 1 (33.33%) Finance
1 1 (33.33%) Publishing
1 1 (33.33%) Banking
1 1 (33.33%) Investment Banking
Job Titles
1 2 (66.67%) Developer
1 2 (66.67%) Senior Developer
2 1 (33.33%) Project Manager
2 1 (33.33%) Junior
2 1 (33.33%) Operations Manager
2 1 (33.33%) C++ Developer
2 1 (33.33%) Junior Project Manager
2 1 (33.33%) Quantitative Developer
2 1 (33.33%) Senior C++ Developer
2 1 (33.33%) Senior Quantitative Developer
2 1 (33.33%) C++ Quantitative Developer
2 1 (33.33%) QlikView Developer
2 1 (33.33%) Senior QlikView Developer
Libraries, Frameworks & Software Standards
1 1 (33.33%) XML
1 1 (33.33%) HTML
Miscellaneous
1 1 (33.33%) Taxonomies
1 1 (33.33%) Market Risk
1 1 (33.33%) Hedge funds
Operating Systems
1 1 (33.33%) Windows
Processes & Methodologies
1 1 (33.33%) Data Modelling
1 1 (33.33%) Project Management
1 1 (33.33%) Business Analysis
1 1 (33.33%) Data Transformation
Programming Languages
1 2 (66.67%) SQL
2 1 (33.33%) C++
Qualifications
1 1 (33.33%) PhD
Quality Assurance & Compliance
1 1 (33.33%) QA
Systems Management
1 1 (33.33%) HP Quality Center
Vendors
1 1 (33.33%) Microsoft
1 1 (33.33%) Pega