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

Microsoft Visual Basic for Applications (VBA)
South West / Somerset
3 months to
26 Jun 2017
Same period 2016 Same period 2015
Rank 75 73 68
Rank change year-on-year -2 -5  
Permanent jobs citing VBA 4 3 2
As % of all permanent IT jobs advertised in Somerset 0.57% 0.46% 0.32%
As % of the Programming Languages category 0.92% 0.76% 0.57%
Number of salaries quoted 4 2 2
Median salary £52,000 £22,250 £23,750
Median salary % change year-on-year +133.70% -6.31%  
90% offered a salary of more than £38,650 £21,650 £19,950
10% offered a salary of more than £65,000 £22,850 £27,550
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 Somerset with a requirement for programming language skills.

Programming Language Skills
Somerset
Permanent job vacancies with a requirement for programming language skills 434 393 353
As % of all permanent IT job vacancies advertised in Somerset 62.00% 60.65% 56.30%
Number of salaries quoted 346 354 325
Median salary £38,500 £40,000 £35,000
Median salary % change year-on-year -3.75% +14.28%  
90% offered a salary of more than £29,000 £32,500 £26,500
10% offered a salary of more than £50,000 £47,500 £56,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 Somerset

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

VBA
Salary Trend in Somerset

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

Salary trend for VBA in Somerset

VBA
Salary Histogram in Somerset

The salary distribution of IT jobs citing VBA in Somerset over the 3 months to 26 June 2017.

Salary histogram for VBA in Somerset

VBA
Job Locations in Somerset

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing VBA within the Somerset region over the 3 months to 26 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
Taunton - 2 £65,000 -
Bath -15 1 £39,000 +75.28%
VBA
South West

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

1 6 (100.00%) SQL
1 6 (100.00%) Microsoft Excel
2 4 (66.67%) .NET
2 4 (66.67%) PHP
3 3 (50.00%) MS Access
3 3 (50.00%) SQL Server
4 2 (33.33%) T-SQL
4 2 (33.33%) C#
4 2 (33.33%) MySQL
4 2 (33.33%) XML
4 2 (33.33%) Microsoft
4 2 (33.33%) Finance
4 2 (33.33%) Planning and Forecasting
4 2 (33.33%) Data Strategy
4 2 (33.33%) Microsoft Azure
4 2 (33.33%) SQL Server Reporting Services
4 2 (33.33%) jQuery
4 2 (33.33%) Continuous Improvement
4 2 (33.33%) Data Quality
4 2 (33.33%) Big Data
4 2 (33.33%) Analytics
4 2 (33.33%) Data Transformation
5 1 (16.67%) Infrastructure Management
5 1 (16.67%) SDLC
5 1 (16.67%) Front End Development
5 1 (16.67%) Ajax
5 1 (16.67%) Web Development
5 1 (16.67%) Cognos Planning
5 1 (16.67%) Computer Science
5 1 (16.67%) HTML5

VBA
Co-occurring IT Skills in Somerset 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:

Applications
1 6 (100.00%) Microsoft Excel
2 1 (16.67%) Microsoft Office
Business Applications
1 1 (16.67%) Cognos Planning
Cloud Services
1 2 (33.33%) Microsoft Azure
Communications & Networking
1 1 (16.67%) VPN
Database & Business Intelligence
1 3 (50.00%) MS Access
1 3 (50.00%) SQL Server
2 2 (33.33%) Big Data
2 2 (33.33%) MySQL
2 2 (33.33%) SQL Server Reporting Services
General
1 2 (33.33%) Finance
2 1 (16.67%) Billing
Job Titles
1 2 (33.33%) Analyst
1 2 (33.33%) Financial Analyst
1 2 (33.33%) Head of Development
2 1 (16.67%) Business Intelligence Lead
2 1 (16.67%) Business Intelligence Manager
2 1 (16.67%) Cost Analyst
2 1 (16.67%) Developer
2 1 (16.67%) Development Manager
2 1 (16.67%) Finance Modeller
2 1 (16.67%) Finance Systems Analyst
2 1 (16.67%) Information Analyst
2 1 (16.67%) IT Development Manager
2 1 (16.67%) IT Manager
2 1 (16.67%) Junior
2 1 (16.67%) Junior Developer
2 1 (16.67%) Junior SQL Developer
2 1 (16.67%) SQL Developer
2 1 (16.67%) Systems Analyst
Libraries, Frameworks & Software Standards
1 4 (66.67%) .NET
2 2 (33.33%) jQuery
2 2 (33.33%) XML
3 1 (16.67%) Ajax
3 1 (16.67%) ASP.NET
3 1 (16.67%) CSS
3 1 (16.67%) CSS3
3 1 (16.67%) HTML
3 1 (16.67%) HTML5
3 1 (16.67%) ODBC
Miscellaneous
1 1 (16.67%) Computer Science
Processes & Methodologies
1 2 (33.33%) Analytics
1 2 (33.33%) Continuous Improvement
1 2 (33.33%) Data Strategy
1 2 (33.33%) Data Transformation
1 2 (33.33%) Planning and Forecasting
2 1 (16.67%) Agile Software Development
2 1 (16.67%) Business Intelligence
2 1 (16.67%) CRM
2 1 (16.67%) ETL
2 1 (16.67%) Front End Development
2 1 (16.67%) Infrastructure Management
2 1 (16.67%) Migration
2 1 (16.67%) Programme Management
2 1 (16.67%) Risk Management
2 1 (16.67%) SDLC
2 1 (16.67%) Stakeholder Management
2 1 (16.67%) Web Development
Programming Languages
1 6 (100.00%) SQL
2 4 (66.67%) PHP
3 2 (33.33%) C#
3 2 (33.33%) T-SQL
4 1 (16.67%) JavaScript
Quality Assurance & Compliance
1 2 (33.33%) Data Quality
Systems Management
1 1 (16.67%) Systems Management Server (SMS)
Vendors
1 2 (33.33%) Microsoft
2 1 (16.67%) CODA
2 1 (16.67%) Cognos
2 1 (16.67%) SAP