Period
to 22 April 2018

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

Microsoft Visual Basic for Applications (VBA)
Wales > South Wales
6 months to
22 Apr 2018
Same period 2017 Same period 2016
Rank 89 119 127
Rank change year-on-year +30 +8 +14
Permanent jobs citing VBA 20 2 18
As % of all permanent IT jobs advertised in South Wales 1.44% 0.12% 0.79%
As % of the Programming Languages category 2.65% 0.21% 1.60%
Number of salaries quoted 17 2 18
South Wales median annual salary £35,200 £34,750 £32,500
Median salary % change year-on-year +1.29% +6.92% -
10th Percentile £28,460 £28,175 £22,500
90th Percentile £44,410 £41,125 £37,657
Wales median annual salary £35,000 £28,500 £31,000
% change year-on-year +22.81% -8.06% -4.62%

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

All Programming Languages
South Wales
Permanent vacancies with a requirement for coding skills 755 934 1,126
As % of all permanent IT jobs advertised in South Wales 54.39% 53.71% 49.13%
Number of salaries quoted 662 828 965
South Wales median annual salary £39,000 £37,500 £36,500
Median salary % change year-on-year +4.00% +2.74% +4.29%
10th Percentile £26,250 £25,675 £22,500
90th Percentile £55,000 £55,000 £50,000
Wales median annual salary £39,500 £37,500 £36,000
% change year-on-year +5.33% +4.17% +2.86%

VBA
Job Vacancy Trend in South Wales

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

Job vacancy trend for VBA in South Wales

VBA
Salary Trend in South Wales

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

Salary trend for VBA in South Wales

VBA
Salary Histogram in South Wales

The salary distribution of IT jobs citing VBA in South Wales over the 6 months to 22 April 2018.

Salary histogram for VBA in South Wales

VBA
Job Locations in South Wales

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing VBA within the South Wales region over the 6 months to 22 April 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Cardiff +20 12 £37,500 +7.91% 1
Newport - 3 £23,500 -
Bridgend - 2 £35,000 -
Gwent - 1 £34,000 -
VBA
Wales

For the 6 months to 22 April 2018, IT jobs citing VBA also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the South Wales region with a requirement for VBA.

1 18 (90.00%) SQL
2 9 (45.00%) Finance
3 8 (40.00%) Business Intelligence
4 7 (35.00%) Microsoft Excel
4 7 (35.00%) MS Access
4 7 (35.00%) Analytical Skills
5 6 (30.00%) VB
5 6 (30.00%) SQL Server
6 5 (25.00%) T-SQL
6 5 (25.00%) C#
6 5 (25.00%) Microsoft Office
6 5 (25.00%) Project Management
6 5 (25.00%) SQL Server Reporting Services
6 5 (25.00%) SQL Server Integration Services
7 4 (20.00%) Degree
7 4 (20.00%) Team Foundation Server
7 4 (20.00%) ERP
7 4 (20.00%) BusinessObjects
7 4 (20.00%) SAP
8 3 (15.00%) DB2
8 3 (15.00%) C
8 3 (15.00%) SharePoint
8 3 (15.00%) Manufacturing
8 3 (15.00%) Service Delivery
8 3 (15.00%) Management Information System
8 3 (15.00%) Continuous Improvement
8 3 (15.00%) Change Control
8 3 (15.00%) Mentoring
8 3 (15.00%) Test Automation
8 3 (15.00%) PowerShell

VBA
Co-occurring IT Skills in South Wales 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 (15.00%) SharePoint
2 2 (10.00%) Apache Pig
Applications
1 7 (35.00%) Microsoft Excel
2 5 (25.00%) Microsoft Office
3 1 (5.00%) Microsoft PowerPoint
Cloud Services
1 1 (5.00%) Azure Active Directory
1 1 (5.00%) Microsoft Azure
Database & Business Intelligence
1 7 (35.00%) MS Access
2 6 (30.00%) SQL Server
3 5 (25.00%) SQL Server Integration Services
3 5 (25.00%) SQL Server Reporting Services
4 4 (20.00%) BusinessObjects
5 3 (15.00%) DB2
5 3 (15.00%) SQL Server Analysis Services
6 2 (10.00%) Apache Hive
6 2 (10.00%) Data Warehouse
6 2 (10.00%) MongoDB
6 2 (10.00%) MySQL
6 2 (10.00%) NoSQL
6 2 (10.00%) Power BI
6 2 (10.00%) SQL Server 2008
6 2 (10.00%) SQL Server 2012
7 1 (5.00%) Crystal Reports
7 1 (5.00%) Oracle Reports
7 1 (5.00%) PowerPivot
7 1 (5.00%) SQL Server 2014
Development Applications
1 4 (20.00%) Team Foundation Server
2 2 (10.00%) SonarQube
2 2 (10.00%) Visual Studio
3 1 (5.00%) SQL Server Management Studio (SSMS)
General
1 9 (45.00%) Finance
2 3 (15.00%) Manufacturing
3 2 (10.00%) Law
4 1 (5.00%) Banking
Job Titles
1 9 (45.00%) Developer
2 7 (35.00%) Analyst
3 4 (20.00%) Development Analyst
3 4 (20.00%) VBA Developer
4 3 (15.00%) Data Analyst
4 3 (15.00%) SQL Developer
5 2 (10.00%) Business Analyst
5 2 (10.00%) Business Development Analyst
5 2 (10.00%) Development Support Analyst
5 2 (10.00%) Project Analyst
5 2 (10.00%) Project Controller
5 2 (10.00%) SQL Analyst
5 2 (10.00%) Support Analyst
5 2 (10.00%) Systems Analyst
5 2 (10.00%) Systems Development Analyst
5 2 (10.00%) Systems Support
5 2 (10.00%) Systems Support Analyst
6 1 (5.00%) Junior Data Analyst
6 1 (5.00%) Trainee
6 1 (5.00%) Trainee Consultant
Libraries, Frameworks & Software Standards
1 2 (10.00%) XML
2 1 (5.00%) .NET
Miscellaneous
1 7 (35.00%) Analytical Skills
2 3 (15.00%) Management Information System
3 2 (10.00%) Robotics
4 1 (5.00%) Data Centre
4 1 (5.00%) e-Learning
Processes & Methodologies
1 8 (40.00%) Business Intelligence
2 5 (25.00%) Project Management
3 4 (20.00%) ERP
4 3 (15.00%) Business Analysis
4 3 (15.00%) Change Control
4 3 (15.00%) Continuous Improvement
4 3 (15.00%) Earned Value Management
4 3 (15.00%) Mentoring
4 3 (15.00%) Problem-Solving
4 3 (15.00%) Service Delivery
4 3 (15.00%) Test Automation
5 2 (10.00%) Agile Software Development
5 2 (10.00%) CMMI
5 2 (10.00%) Data Analysis
5 2 (10.00%) MVC
5 2 (10.00%) Practice Management
5 2 (10.00%) Process Improvement
5 2 (10.00%) Scaled Agile Framework
5 2 (10.00%) Scrum
5 2 (10.00%) Waterfall
Programming Languages
1 18 (90.00%) SQL
2 6 (30.00%) VB
3 5 (25.00%) C#
3 5 (25.00%) T-SQL
4 3 (15.00%) C
4 3 (15.00%) PowerShell
5 2 (10.00%) Java
5 2 (10.00%) Perl
5 2 (10.00%) Python
5 2 (10.00%) R
6 1 (5.00%) JavaScript
6 1 (5.00%) VB.NET
Qualifications
1 4 (20.00%) Degree
2 3 (15.00%) CBAP
3 2 (10.00%) SC Cleared
3 2 (10.00%) Security Cleared
4 1 (5.00%) Microsoft Certification
Quality Assurance & Compliance
1 2 (10.00%) ISO 9001
1 2 (10.00%) QA
System Software
1 1 (5.00%) Active Directory
Systems Management
1 1 (5.00%) Forefront Identity Manager
Vendors
1 4 (20.00%) SAP
2 2 (10.00%) Blue Prism
2 2 (10.00%) Coverity
2 2 (10.00%) Microsoft
2 2 (10.00%) Oracle
3 1 (5.00%) Tableau