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

Microsoft Visual Basic for Applications (VBA)
England / West Midlands
3 months to
23 Apr 2017
Same period 2016 Same period 2015
Rank 192 222 177
Rank change year-on-year +30 -45  
Permanent jobs citing VBA 32 26 52
As % of all permanent IT jobs advertised in the West Midlands 0.65% 0.42% 0.98%
As % of the Programming Languages category 1.30% 0.96% 1.97%
Number of salaries quoted 28 22 43
Median salary £26,750 £33,750 £29,500
Median salary % change year-on-year -20.74% +14.40%  
90% offered a salary of more than £23,300 £26,000 £25,600
10% offered a salary of more than £42,300 £40,000 £42,500
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 West Midlands with a requirement for programming language skills.

Programming Language Skills
West Midlands
Permanent job vacancies with a requirement for programming language skills 2462 2701 2642
As % of all permanent IT job vacancies advertised in the West Midlands 50.10% 43.22% 49.73%
Number of salaries quoted 2123 2350 2370
Median salary £40,000 £40,000 £37,500
Median salary % change year-on-year - +6.66%  
90% offered a salary of more than £26,000 £25,000 £25,000
10% offered a salary of more than £52,500 £52,500 £57,500
UK excluding London median salary £41,500 £41,000 £40,000
% change year-on-year +1.21% +2.50%  

VBA
Job Vacancy Trend in the West Midlands

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

VBA
Salary Trend in the West Midlands

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

Salary trend for VBA in the West Midlands

VBA
Salary Histogram in the West Midlands

The salary distribution of IT jobs citing VBA in the West Midlands over the 3 months to 23 April 2017.

Salary histogram for VBA in the West Midlands

VBA
Job Locations in the West Midlands

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing VBA within the West Midlands region over the 3 months to 23 April 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
Birmingham +23 11 £25,000 -3.84% 2
Warwickshire +22 6 £36,500 +4.28%
Staffordshire +16 4 £26,625 +2.40% 1
Solihull -16 4 £37,250 +14.61% 2
Coventry +2 2 - -
Worcestershire - 2 £35,500 -
West Bromwich - 1 £21,500 - 1
VBA
England

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

1 48 (76.19%) Microsoft Excel
2 42 (66.67%) SQL
3 27 (42.86%) Analytical Skills
4 26 (41.27%) Finance
5 22 (34.92%) Analytics
6 18 (28.57%) SQL Server
7 17 (26.98%) SAS
8 15 (23.81%) Microsoft
8 15 (23.81%) SQL Server Reporting Services
9 14 (22.22%) C#
9 14 (22.22%) Marketing
10 13 (20.63%) VB
10 13 (20.63%) Business Intelligence
11 11 (17.46%) SQL Server Integration Services
11 11 (17.46%) Oracle
12 10 (15.87%) .NET
12 10 (15.87%) Microsoft Office
12 10 (15.87%) ITIL
12 10 (15.87%) Statistical Analysis
12 10 (15.87%) SAS Enterprise Guide
12 10 (15.87%) Customer Analytics
13 9 (14.29%) Degree
13 9 (14.29%) Stakeholder Management
14 8 (12.70%) Windows
14 8 (12.70%) Project Management
15 7 (11.11%) PRINCE2
15 7 (11.11%) Data Analysis
15 7 (11.11%) Agile Software Development
15 7 (11.11%) QA
15 7 (11.11%) PowerShell

VBA
Co-occurring IT Skills in the West 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 17 (26.98%) SAS
2 6 (9.52%) FormScape
3 3 (4.76%) CMS
4 2 (3.17%) Apache
4 2 (3.17%) IIS
4 2 (3.17%) MS Exchange
4 2 (3.17%) Umbraco
4 2 (3.17%) WordPress
5 1 (1.59%) Exchange Server 2010
5 1 (1.59%) SharePoint
Applications
1 48 (76.19%) Microsoft Excel
2 10 (15.87%) Microsoft Office
3 3 (4.76%) SPSS
4 1 (1.59%) MS Visio
4 1 (1.59%) Spreadsheet
Business Applications
1 6 (9.52%) Dynamics NAV
2 3 (4.76%) Dynamics AX
3 2 (3.17%) Dynamics CRM
4 1 (1.59%) Infor SunSystems
4 1 (1.59%) Unit4 Business World
Communications & Networking
1 3 (4.76%) DHCP
1 3 (4.76%) DNS
1 3 (4.76%) TCP/IP
2 2 (3.17%) Cisco IOS
2 2 (3.17%) Firewall
2 2 (3.17%) Softphone
3 1 (1.59%) LAN
3 1 (1.59%) NAS
3 1 (1.59%) SAN
3 1 (1.59%) VoIP
3 1 (1.59%) VPN
3 1 (1.59%) WAN
3 1 (1.59%) Wi-Fi
Database & Business Intelligence
1 18 (28.57%) SQL Server
2 15 (23.81%) SQL Server Reporting Services
3 11 (17.46%) SQL Server Integration Services
4 10 (15.87%) SAS Enterprise Guide
5 6 (9.52%) MS Access
6 4 (6.35%) DTS
6 4 (6.35%) Oracle Database
6 4 (6.35%) SAS Enterprise Miner
7 3 (4.76%) BusinessObjects
7 3 (4.76%) QlikView
7 3 (4.76%) SQL Server 2008
7 3 (4.76%) SQL Server 2012
7 3 (4.76%) SQL Server Analysis Services
8 2 (3.17%) Data Mining
9 1 (1.59%) BusinessObjects XI
9 1 (1.59%) Data Warehouse
9 1 (1.59%) DataStage
9 1 (1.59%) IBM InfoSphere
9 1 (1.59%) PostgreSQL
9 1 (1.59%) Spotfire
Development Applications
1 1 (1.59%) Visual Studio
General
1 26 (41.27%) Finance
2 14 (22.22%) Marketing
3 5 (7.94%) Manufacturing
4 4 (6.35%) Retail
5 3 (4.76%) Banking
6 2 (3.17%) Automotive
6 2 (3.17%) Telecoms
7 1 (1.59%) Back Office
Job Titles
1 32 (50.79%) Analyst
2 12 (19.05%) Developer
3 10 (15.87%) Data Analyst
4 7 (11.11%) Junior
4 7 (11.11%) Team Leader
5 6 (9.52%) Junior Analyst
5 6 (9.52%) Statistical Analyst
6 4 (6.35%) Analytics Manager
6 4 (6.35%) IT Support
6 4 (6.35%) SQL Analyst
6 4 (6.35%) SQL Data Analyst
6 4 (6.35%) Systems Manager
6 4 (6.35%) Technical Leader
6 4 (6.35%) Technical Team Leader
7 3 (4.76%) Graduate
7 3 (4.76%) Graduate Developer
7 3 (4.76%) Junior Data Analyst
7 3 (4.76%) Senior Manager
7 3 (4.76%) SQL Developer
7 3 (4.76%) Technical Manager
Libraries, Frameworks & Software Standards
1 10 (15.87%) .NET
2 6 (9.52%) ASP.NET
3 4 (6.35%) CGI
4 3 (4.76%) EDI
5 2 (3.17%) ASP.NET MVC
5 2 (3.17%) ASP.NET Web API
5 2 (3.17%) COM
5 2 (3.17%) CSS
5 2 (3.17%) HTML
5 2 (3.17%) jQuery
5 2 (3.17%) LESS
5 2 (3.17%) LINQ to SQL
5 2 (3.17%) RESTful
Miscellaneous
1 27 (42.86%) Analytical Skills
2 4 (6.35%) Management Information System
2 4 (6.35%) Virtual Team
3 2 (3.17%) Computer Science
3 2 (3.17%) Life Science
4 1 (1.59%) CCTV
4 1 (1.59%) Data Structures
4 1 (1.59%) EPoS
Operating Systems
1 8 (12.70%) Windows
2 4 (6.35%) Windows 7
2 4 (6.35%) Windows Server
3 3 (4.76%) Windows 10
3 3 (4.76%) Windows Server 2008
4 1 (1.59%) Linux
4 1 (1.59%) Unix
4 1 (1.59%) Windows 8
4 1 (1.59%) Windows Server 2012
Processes & Methodologies
1 22 (34.92%) Analytics
2 13 (20.63%) Business Intelligence
3 10 (15.87%) Customer Analytics
3 10 (15.87%) ITIL
3 10 (15.87%) Statistical Analysis
4 9 (14.29%) Stakeholder Management
5 8 (12.70%) Project Management
6 7 (11.11%) Agile Software Development
6 7 (11.11%) Data Analysis
6 7 (11.11%) PRINCE2
7 6 (9.52%) ERP
8 5 (7.94%) Stakeholder Engagement
8 5 (7.94%) Validation
9 4 (6.35%) Continuous Improvement
9 4 (6.35%) Customer Insight
9 4 (6.35%) Escalation Management
9 4 (6.35%) Regression Analysis
9 4 (6.35%) SQL Optimisation
9 4 (6.35%) Statistics
9 4 (6.35%) Virtual Team Management
Programming Languages
1 42 (66.67%) SQL
2 14 (22.22%) C#
3 13 (20.63%) VB
4 7 (11.11%) PowerShell
5 6 (9.52%) VBScript
6 5 (7.94%) C++
6 5 (7.94%) Java
6 5 (7.94%) T-SQL
7 4 (6.35%) PHP
8 3 (4.76%) JavaScript
9 2 (3.17%) Python
10 1 (1.59%) R
10 1 (1.59%) VB.NET
Qualifications
1 9 (14.29%) Degree
2 2 (3.17%) CCNA
2 2 (3.17%) Cisco Certification
3 1 (1.59%) MCSE
3 1 (1.59%) Microsoft Certification
Quality Assurance & Compliance
1 7 (11.11%) QA
2 4 (6.35%) Data Quality
3 3 (4.76%) SLA
4 1 (1.59%) ISO/IEC 27001
4 1 (1.59%) PCI DSS
System Software
1 3 (4.76%) Active Directory
2 1 (1.59%) vSphere
Vendors
1 15 (23.81%) Microsoft
2 11 (17.46%) Oracle
3 6 (9.52%) JD Edwards
4 4 (6.35%) IFS
5 3 (4.76%) Cisco
5 3 (4.76%) CODA
5 3 (4.76%) Tableau
6 2 (3.17%) MobileIron
7 1 (1.59%) Alteryx
7 1 (1.59%) Google
7 1 (1.59%) IBM
7 1 (1.59%) MicroStrategy
7 1 (1.59%) NetApp
7 1 (1.59%) SAP
7 1 (1.59%) Sun
7 1 (1.59%) VMware
Solihull, West Midlands (County)
BARCLAY ANDERSON LIMITED
Salary: From £25,000 to £30,000 per annum
Posted: 5 days ago
Birmingham, West Midlands (County)
Hydrogen Group
Posted: 5 days ago
West Bromwich
Hays Specialist Recruitment Ltd
Salary: £18000.00 - £25000.00 per annum
Posted: 10 days ago
Birmingham, West Midlands (County)
Lewis Paige
Salary: £30000 - £40000 per annum + Company Car
Posted: 5 days ago
Solihull
Applause IT Ltd
Salary: £25000 - £30000 per annum + benefits
Posted: 13 days ago