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

Microsoft Visual Basic for Applications (VBA)
England / East Midlands
3 months to
28 Jun 2017
Same period 2016 Same period 2015
Rank 133 145 166
Rank change year-on-year +12 +21  
Permanent jobs citing VBA 25 40 23
As % of all permanent IT jobs advertised in the East Midlands 0.94% 1.21% 0.63%
As % of the Programming Languages category 1.77% 2.34% 1.25%
Number of salaries quoted 23 20 10
Median salary £30,000 £35,000 £36,000
Median salary % change year-on-year -14.28% -2.77%  
90% offered a salary of more than £27,500 £23,000 £33,960
10% offered a salary of more than £38,800 £40,500 £45,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 East Midlands with a requirement for programming language skills.

Programming Language Skills
East Midlands
Permanent job vacancies with a requirement for programming language skills 1411 1712 1837
As % of all permanent IT job vacancies advertised in the East Midlands 52.99% 51.71% 49.97%
Number of salaries quoted 1237 1434 1596
Median salary £40,000 £40,000 £40,000
90% offered a salary of more than £27,500 £27,500 £25,500
10% offered a salary of more than £55,000 £47,500 £52,500
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 East Midlands

The job posting trend of jobs advertised in the East Midlands 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 East Midlands

VBA
Salary Trend in the East Midlands

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

Salary trend for VBA in the East Midlands

VBA
Salary Histogram in the East Midlands

The salary distribution of IT jobs citing VBA in the East Midlands over the 3 months to 28 June 2017.

Salary histogram for VBA in the East Midlands

VBA
Job Locations in the East Midlands

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing VBA within the East Midlands region over the 3 months to 28 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Northamptonshire +1 15 £29,000 -17.14%
Leicestershire +11 5 £32,500 -7.14%
Nottinghamshire +3 4 £58,750 +193.75%
Derbyshire +5 1 £32,500 +9.70%
VBA
England

For the 6 months to 28 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 East Midlands region with a requirement for VBA.

1 41 (85.42%) SQL
2 22 (45.83%) Analytical Skills
3 19 (39.58%) Microsoft Excel
4 16 (33.33%) SQL Server
5 14 (29.17%) HTML
5 14 (29.17%) Data Analysis
6 12 (25.00%) Statistical Analysis
6 12 (25.00%) Business Intelligence
6 12 (25.00%) R
7 11 (22.92%) Degree
8 10 (20.83%) Finance
9 9 (18.75%) Change Management
9 9 (18.75%) VB
9 9 (18.75%) Data Mining
10 8 (16.67%) BusinessObjects
10 8 (16.67%) SQL Server Management Studio (SSMS)
11 7 (14.58%) Process Improvement
11 7 (14.58%) SQL Server Reporting Services
12 6 (12.50%) Mathematics
12 6 (12.50%) Microsoft
12 6 (12.50%) Microsoft Office
12 6 (12.50%) Tableau
13 5 (10.42%) Analytics
13 5 (10.42%) Business Forecasting
13 5 (10.42%) CRM
13 5 (10.42%) WAN
13 5 (10.42%) Computer Science
13 5 (10.42%) Statistics
13 5 (10.42%) Credit Risk
13 5 (10.42%) Workflow

VBA
Co-occurring IT Skills in the East Midlands 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 2 (4.17%) SAS
2 1 (2.08%) Exchange Server 2010
2 1 (2.08%) IIS
2 1 (2.08%) MS Exchange
2 1 (2.08%) Oracle Workflow
2 1 (2.08%) SharePoint
2 1 (2.08%) SharePoint 2013
Applications
1 19 (39.58%) Microsoft Excel
2 6 (12.50%) Microsoft Office
3 1 (2.08%) Microsoft PowerPoint
3 1 (2.08%) Microsoft Project
3 1 (2.08%) MS Visio
Business Applications
1 1 (2.08%) Oracle EBS
1 1 (2.08%) Oracle Utilities
Cloud Services
1 4 (8.33%) Amazon AWS
2 2 (4.17%) Google Cloud Platform
3 1 (2.08%) Office 365
3 1 (2.08%) SaaS
Communications & Networking
1 5 (10.42%) WAN
2 4 (8.33%) Intranet
3 1 (2.08%) Ethernet
3 1 (2.08%) LAN
3 1 (2.08%) RS-232
3 1 (2.08%) RS-485
3 1 (2.08%) Wi-Fi
Database & Business Intelligence
1 16 (33.33%) SQL Server
2 9 (18.75%) Data Mining
3 8 (16.67%) BusinessObjects
4 7 (14.58%) SQL Server Reporting Services
5 4 (8.33%) Big Data
5 4 (8.33%) BusinessObjects Business Intelligence
6 3 (6.25%) Data Warehouse
6 3 (6.25%) MS Access
6 3 (6.25%) QlikView
6 3 (6.25%) SQL Server Integration Services
7 2 (4.17%) BigQuery
7 2 (4.17%) Oracle BI Publisher
7 2 (4.17%) Oracle Reports
7 2 (4.17%) SQL Server 2008
8 1 (2.08%) MySQL
8 1 (2.08%) Oracle BI EE
8 1 (2.08%) Oracle Database
8 1 (2.08%) Oracle Database 10g
8 1 (2.08%) Oracle Discoverer
8 1 (2.08%) Oracle9i Database
Development Applications
1 8 (16.67%) SQL Server Management Studio (SSMS)
2 1 (2.08%) Git (software)
2 1 (2.08%) Oracle Forms
2 1 (2.08%) Toad
General
1 10 (20.83%) Finance
2 2 (4.17%) Marketing
3 1 (2.08%) Retail
Job Titles
1 30 (62.50%) Analyst
2 11 (22.92%) Data Analyst
3 9 (18.75%) Consultant
3 9 (18.75%) Technical Consultant
4 8 (16.67%) Credit Analyst
5 7 (14.58%) Senior Analyst
6 5 (10.42%) Business Analyst
6 5 (10.42%) Developer
6 5 (10.42%) Senior Business Analyst
7 4 (8.33%) Business Intelligence Analyst
7 4 (8.33%) Data Insight Analyst
7 4 (8.33%) Implementation Consultant
7 4 (8.33%) Insight Analyst
7 4 (8.33%) Insight Data Analyst
7 4 (8.33%) Senior Consultant
7 4 (8.33%) Senior Technical Consultant
7 4 (8.33%) Technical Implementation Consultant
8 2 (4.17%) Development Manager
8 2 (4.17%) SQL Developer
8 2 (4.17%) Technical Analyst
Libraries, Frameworks & Software Standards
1 14 (29.17%) HTML
2 4 (8.33%) Web Services
3 3 (6.25%) XML
4 1 (2.08%) .NET
4 1 (2.08%) .NET Framework
4 1 (2.08%) CSS
4 1 (2.08%) HTML5
Miscellaneous
1 22 (45.83%) Analytical Skills
2 5 (10.42%) Computer Science
2 5 (10.42%) Credit Risk
3 3 (6.25%) Data Structures
4 1 (2.08%) Management Information System
4 1 (2.08%) SCADA
4 1 (2.08%) User Experience
Operating Systems
1 1 (2.08%) Unix
1 1 (2.08%) Windows
1 1 (2.08%) Windows 7
1 1 (2.08%) Windows Server
1 1 (2.08%) Windows Server 2008
1 1 (2.08%) Windows Server 2012
Processes & Methodologies
1 14 (29.17%) Data Analysis
2 12 (25.00%) Business Intelligence
2 12 (25.00%) Statistical Analysis
3 9 (18.75%) Change Management
4 7 (14.58%) Process Improvement
5 6 (12.50%) Mathematics
6 5 (10.42%) Analytics
6 5 (10.42%) Business Forecasting
6 5 (10.42%) CRM
6 5 (10.42%) Data Management
6 5 (10.42%) Statistics
6 5 (10.42%) Workflow
7 4 (8.33%) Business Analysis
7 4 (8.33%) Business Development
7 4 (8.33%) Customer Requirements
7 4 (8.33%) Knowledge Management
7 4 (8.33%) Service Delivery
8 3 (6.25%) ETL
8 3 (6.25%) Project Management
9 2 (4.17%) Continuous Improvement
Programming Languages
1 41 (85.42%) SQL
2 12 (25.00%) R
3 9 (18.75%) VB
4 3 (6.25%) T-SQL
5 2 (4.17%) PHP
5 2 (4.17%) Python
6 1 (2.08%) C#
6 1 (2.08%) C++
6 1 (2.08%) Java
6 1 (2.08%) JavaScript
6 1 (2.08%) PL/SQL
6 1 (2.08%) Shell Script
Qualifications
1 11 (22.92%) Degree
2 4 (8.33%) Computer Science Degree
3 1 (2.08%) ACCA
3 1 (2.08%) CIMA
Quality Assurance & Compliance
1 1 (2.08%) QA
System Software
1 1 (2.08%) Active Directory
Systems Management
1 1 (2.08%) Cisco CUCM
1 1 (2.08%) McAfee ePO
Vendors
1 6 (12.50%) Microsoft
1 6 (12.50%) Tableau
2 4 (8.33%) SAP
3 3 (6.25%) Oracle
4 2 (4.17%) Google
4 2 (4.17%) Teradata
5 1 (2.08%) Cisco
5 1 (2.08%) Informatica
5 1 (2.08%) McAfee
5 1 (2.08%) Sage
5 1 (2.08%) Veeam
5 1 (2.08%) VMware