Period
to 18 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Edinburgh 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 18 November 2017 with a comparison to the same period in the previous 2 years.

Microsoft Visual Basic for Applications (VBA)
Scotland > Edinburgh
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 139 121 135
Rank change year-on-year -18 +14 -1
Permanent jobs citing VBA 11 17 22
As % of all permanent IT jobs advertised in Edinburgh 0.41% 0.73% 0.72%
As % of the Programming Languages category 0.68% 1.50% 1.69%
Number of salaries quoted 7 4 14
Edinburgh median annual salary £35,000 £45,000 £41,250
Median salary % change year-on-year -22.22% +9.09% +50.00%
10th Percentile £27,000 £30,000 £21,575
90th Percentile £45,800 £50,875 £58,400
Scotland median annual salary £27,000 £40,000 £40,000
% change year-on-year -32.50% - +23.08%

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 Edinburgh with a requirement for coding skills.

All Programming Languages
Edinburgh
Permanent vacancies with a requirement for coding skills 1628 1130 1304
As % of all permanent IT jobs advertised in Edinburgh 60.36% 48.79% 42.68%
Number of salaries quoted 1018 791 857
Edinburgh median annual salary £40,000 £45,000 £40,000
Median salary % change year-on-year -11.11% +12.50% -
10th Percentile £27,500 £29,750 £26,250
90th Percentile £61,250 £60,000 £59,850
Scotland median annual salary £42,500 £42,000 £40,000
% change year-on-year +1.19% +5.00% -

VBA
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for VBA in Edinburgh

VBA
Salary Trend in Edinburgh

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

Salary trend for VBA in Edinburgh

VBA
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing VBA in Edinburgh over the 6 months to 18 November 2017.

Salary histogram for VBA in Edinburgh

For the 6 months to 18 November 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 Edinburgh region with a requirement for VBA.

1 10 (90.91%) SQL
2 8 (72.73%) Microsoft Excel
3 7 (63.64%) Finance
3 7 (63.64%) Analytical Skills
4 6 (54.55%) Microsoft Office
5 5 (45.45%) Microsoft
5 5 (45.45%) Collaborative Working
6 4 (36.36%) HTML
6 4 (36.36%) Tableau
7 3 (27.27%) Minitab
7 3 (27.27%) Statistical Analysis
7 3 (27.27%) Data Governance
7 3 (27.27%) Time Management
7 3 (27.27%) Demand Management
7 3 (27.27%) Data Transformation
7 3 (27.27%) SharePoint
7 3 (27.27%) Validation
7 3 (27.27%) Stakeholder Management
7 3 (27.27%) Service Delivery
7 3 (27.27%) Management Information System
8 2 (18.18%) FileNet
8 2 (18.18%) MS Access
8 2 (18.18%) CRM
8 2 (18.18%) BusinessObjects
8 2 (18.18%) SAS
8 2 (18.18%) Business Intelligence
8 2 (18.18%) SLA
8 2 (18.18%) JavaScript
8 2 (18.18%) PHP
8 2 (18.18%) C#

VBA
Co-occurring IT Skills in Edinburgh 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 3 (27.27%) SharePoint
2 2 (18.18%) FileNet
2 2 (18.18%) SAS
Applications
1 8 (72.73%) Microsoft Excel
2 6 (54.55%) Microsoft Office
3 2 (18.18%) Microsoft PowerPoint
Business Applications
1 2 (18.18%) Dynamics CRM
Cloud Services
1 2 (18.18%) Oracle Service Cloud
Database & Business Intelligence
1 2 (18.18%) BusinessObjects
1 2 (18.18%) MS Access
1 2 (18.18%) Relational Database
1 2 (18.18%) SQL Server
2 1 (9.09%) QlikView
Development Applications
1 2 (18.18%) JIRA
General
1 7 (63.64%) Finance
2 1 (9.09%) Banking
2 1 (9.09%) Retail Banking
Job Titles
1 4 (36.36%) Analyst
1 4 (36.36%) Data Analyst
1 4 (36.36%) Developer
2 2 (18.18%) Consultant
2 2 (18.18%) Data Scientist
2 2 (18.18%) Database Developer
3 1 (9.09%) Applications Consultant
3 1 (9.09%) C# Developer
3 1 (9.09%) CRM Consultant
3 1 (9.09%) Graduate
3 1 (9.09%) Graduate Consultant
3 1 (9.09%) Junior
3 1 (9.09%) Junior Consultant
3 1 (9.09%) Oracle Consultant
3 1 (9.09%) Qualitative Analyst
3 1 (9.09%) Quantitative Analyst
Libraries, Frameworks & Software Standards
1 4 (36.36%) HTML
2 2 (18.18%) CSS
2 2 (18.18%) Web Services
Miscellaneous
1 7 (63.64%) Analytical Skills
2 3 (27.27%) Management Information System
3 2 (18.18%) Data Structures
4 1 (9.09%) Computer Science
Processes & Methodologies
1 5 (45.45%) Collaborative Working
2 3 (27.27%) Data Governance
2 3 (27.27%) Data Transformation
2 3 (27.27%) Demand Management
2 3 (27.27%) Service Delivery
2 3 (27.27%) Stakeholder Management
2 3 (27.27%) Statistical Analysis
2 3 (27.27%) Time Management
2 3 (27.27%) Validation
3 2 (18.18%) Analytics
3 2 (18.18%) Business Intelligence
3 2 (18.18%) Change Control
3 2 (18.18%) CRM
3 2 (18.18%) Data Management
3 2 (18.18%) Data Protection
3 2 (18.18%) Data Reconciliation
3 2 (18.18%) Process Management
3 2 (18.18%) Robotic Process Automation
3 2 (18.18%) Task Automation
3 2 (18.18%) User Acceptance Testing
Programming Languages
1 10 (90.91%) SQL
2 2 (18.18%) C#
2 2 (18.18%) JavaScript
2 2 (18.18%) PHP
2 2 (18.18%) Python
2 2 (18.18%) T-SQL
2 2 (18.18%) VB
3 1 (9.09%) MATLAB
3 1 (9.09%) R
Qualifications
1 1 (9.09%) Degree
1 1 (9.09%) Numerate Degree
Quality Assurance & Compliance
1 2 (18.18%) Data Quality
1 2 (18.18%) QA
1 2 (18.18%) SLA
Vendors
1 5 (45.45%) Microsoft
2 4 (36.36%) Tableau
3 3 (27.27%) Minitab
4 2 (18.18%) Oracle