Period
to 21 September 2018

The following table provides summary statistics for contract job vacancies advertised in the South West with a requirement for VBA skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited VBA over the 6 months to 21 September 2018 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Microsoft Visual Basic for Applications (VBA)
England > South West
6 months to
21 Sep 2018
Same period 2017 Same period 2016
Rank 180 151 169
Rank change year-on-year -29 +18 -26
Contract jobs citing VBA 38 57 40
As % of all contract IT jobs advertised in the South West 0.65% 1.04% 0.68%
As % of the Programming Languages category 1.63% 2.77% 1.70%
Number of daily rates quoted 24 32 24
South West median daily rate £400 £375 £369
Median daily rate % change year-on-year +6.67% +1.69% -7.81%
10th Percentile £230 £318 £284
90th Percentile £568 £438 £502
England median daily rate £425 £425 £375
% change year-on-year - +13.33% -6.25%
Number of hourly rates quoted 0 1 3
South West median hourly rate - £29.50 £13.00
Median hourly rate % change year-on-year - +126.92% -68.48%
England median hourly rate £18.00 £22.50 £19.00
% change year-on-year -20.00% +18.42% -15.56%

VBA is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in the South West with a requirement for coding skills.

All Programming Languages
South West
Contract vacancies with a requirement for coding skills 2,338 2,059 2,358
As % of all contract IT jobs advertised in the South West 39.84% 37.44% 40.14%
Number of daily rates quoted 1,472 1,253 1,521
South West median daily rate £415 £375 £350
Median daily rate % change year-on-year +10.67% +7.14% -6.67%
10th Percentile £281 £275 £263
90th Percentile £563 £513 £488
England median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +6.25%
Number of hourly rates quoted 116 102 159
South West median hourly rate £42.50 £43.25 £40.00
Median hourly rate % change year-on-year -1.73% +8.13% +3.90%
10th Percentile £29.00 £17.28 £21.50
90th Percentile £48.13 £53.75 £51.50
England median hourly rate £42.13 £40.00 £37.50
% change year-on-year +5.31% +6.67% +2.74%

VBA
Job Vacancy Trend in the South West

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

Job vacancy trend for VBA in the South West

VBA
Contractor Daily Rate Trend in the South West

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing VBA in the South West.

Contractor daily rate trend for VBA in the South West

VBA
Contractor Daily Rate Histogram in the South West

The daily rate distribution of IT jobs citing VBA in the South West over the 6 months to 21 September 2018.

Contractor daily rate histogram for VBA in the South West

VBA
Contractor Hourly Rate Trend in the South West

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing VBA in the South West.

Contractor hourly rate trend for VBA in the South West

VBA
Contract Job Locations in the South West

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing VBA within the South West region over the 6 months to 21 September 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Bristol -23 27 £408 +8.67% 3
Gloucestershire -2 4 £375 -11.76% 2
Somerset -3 2 - -
Wiltshire -3 2 £325 -43.48% 2
Dorset +1 1 - - 3
VBA
England

For the 6 months to 21 September 2018, IT contractor 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 contract job ads across the South West region with a requirement for VBA.

1 24 (63.16%) Microsoft Excel
2 20 (52.63%) SQL
2 20 (52.63%) SQL Server
3 19 (50.00%) Finance
4 17 (44.74%) MS Access
5 12 (31.58%) T-SQL
6 10 (26.32%) Microsoft
7 8 (21.05%) SQL Server Integration Services
8 7 (18.42%) Banking
8 7 (18.42%) Data Analysis
8 7 (18.42%) Analytical Skills
9 6 (15.79%) SQL Server Management Studio (SSMS)
9 6 (15.79%) Agile Software Development
9 6 (15.79%) Microsoft Office
10 5 (13.16%) Data Modelling
11 4 (10.53%) VB
11 4 (10.53%) Validation
11 4 (10.53%) Teradata
11 4 (10.53%) SDLC
11 4 (10.53%) Problem-Solving
12 3 (7.89%) Systems Analysis
12 3 (7.89%) SQL Server Reporting Services
12 3 (7.89%) Stakeholder Management
12 3 (7.89%) IBM
12 3 (7.89%) .NET
12 3 (7.89%) C#
12 3 (7.89%) HTML
12 3 (7.89%) ADO
12 3 (7.89%) Windows
12 3 (7.89%) XML

VBA
Co-occurring IT Skills in the South West 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 (7.89%) SharePoint
2 2 (5.26%) Confluence
3 1 (2.63%) IIS
3 1 (2.63%) Joomla!
3 1 (2.63%) SAS
3 1 (2.63%) WordPress
Applications
1 24 (63.16%) Microsoft Excel
2 6 (15.79%) Microsoft Office
3 1 (2.63%) Microsoft PowerPoint
Communications & Networking
1 2 (5.26%) 4G
1 2 (5.26%) Radio Access Network
2 1 (2.63%) 3G
2 1 (2.63%) 3GPP
2 1 (2.63%) 5G
2 1 (2.63%) Ethernet
2 1 (2.63%) Firewall
2 1 (2.63%) SMS
2 1 (2.63%) Wireless
Database & Business Intelligence
1 20 (52.63%) SQL Server
2 17 (44.74%) MS Access
3 8 (21.05%) SQL Server Integration Services
4 3 (7.89%) Data Warehouse
4 3 (7.89%) SQL Server Reporting Services
5 2 (5.26%) BusinessObjects
5 2 (5.26%) Relational Database
6 1 (2.63%) BusinessObjects Business Intelligence
6 1 (2.63%) Oracle Database
6 1 (2.63%) QlikView
Development Applications
1 6 (15.79%) SQL Server Management Studio (SSMS)
2 2 (5.26%) JIRA
3 1 (2.63%) Dreamweaver
3 1 (2.63%) Oracle Forms
3 1 (2.63%) Rational DOORS
General
1 19 (50.00%) Finance
2 7 (18.42%) Banking
3 2 (5.26%) Corporate Banking
3 2 (5.26%) Telecoms
4 1 (2.63%) Financial Institution
4 1 (2.63%) Marketing
Job Titles
1 24 (63.16%) Developer
2 15 (39.47%) VBA Developer
3 9 (23.68%) Access Developer
3 9 (23.68%) Analyst
3 9 (23.68%) SQL Developer
4 7 (18.42%) Access VBA Developer
5 4 (10.53%) Data Analyst
5 4 (10.53%) Microsoft Developer
5 4 (10.53%) Teradata Analyst
6 3 (7.89%) Excel Developer
6 3 (7.89%) Excel VBA Developer
6 3 (7.89%) SQL Server Developer
7 2 (5.26%) Analyst Developer
7 2 (5.26%) Applications Developer
7 2 (5.26%) SSRS Developer
7 2 (5.26%) T-SQL Developer
8 1 (2.63%) Infrastructure Analyst
8 1 (2.63%) Lead Developer
8 1 (2.63%) Support Analyst
8 1 (2.63%) Systems Engineer
Libraries, Frameworks & Software Standards
1 3 (7.89%) .NET
1 3 (7.89%) ADO
1 3 (7.89%) HTML
1 3 (7.89%) XML
2 2 (5.26%) .NET Framework
2 2 (5.26%) ODBC
2 2 (5.26%) Twitter Bootstrap
3 1 (2.63%) ActiveX
3 1 (2.63%) Ajax
3 1 (2.63%) AngularJS
3 1 (2.63%) ASP.NET
3 1 (2.63%) ASP.NET MVC
3 1 (2.63%) CSS
3 1 (2.63%) CSS3
3 1 (2.63%) HTML5
3 1 (2.63%) jQuery
3 1 (2.63%) LDAP
3 1 (2.63%) REST
Miscellaneous
1 7 (18.42%) Analytical Skills
2 2 (5.26%) Enterprise Software
2 2 (5.26%) Robotics
3 1 (2.63%) Data Structures
3 1 (2.63%) Linux Command Line
3 1 (2.63%) Management Information System
Operating Systems
1 3 (7.89%) Windows
2 1 (2.63%) Android
2 1 (2.63%) Apple iOS
2 1 (2.63%) Linux
2 1 (2.63%) Windows 10
2 1 (2.63%) Windows Server
Processes & Methodologies
1 7 (18.42%) Data Analysis
2 6 (15.79%) Agile Software Development
3 5 (13.16%) Data Modelling
4 4 (10.53%) Problem-Solving
4 4 (10.53%) SDLC
4 4 (10.53%) Validation
5 3 (7.89%) Stakeholder Management
5 3 (7.89%) Systems Analysis
6 2 (5.26%) Analytics
6 2 (5.26%) Business Intelligence
6 2 (5.26%) IT Governance
6 2 (5.26%) Mentoring
6 2 (5.26%) Robotic Process Automation
6 2 (5.26%) Software Architecture
6 2 (5.26%) Time Management
7 1 (2.63%) Change Control
7 1 (2.63%) Functional Testing
7 1 (2.63%) High Availability
7 1 (2.63%) Trend Analysis
7 1 (2.63%) Waterfall
Programming Languages
1 20 (52.63%) SQL
2 12 (31.58%) T-SQL
3 4 (10.53%) VB
4 3 (7.89%) C#
4 3 (7.89%) JavaScript
5 1 (2.63%) Java
5 1 (2.63%) PowerShell
5 1 (2.63%) Python
5 1 (2.63%) XPath
5 1 (2.63%) XQuery
Qualifications
1 1 (2.63%) BPSS Clearance
1 1 (2.63%) Security Cleared
Quality Assurance & Compliance
1 1 (2.63%) Data Quality
1 1 (2.63%) QA
System Software
1 1 (2.63%) Active Directory
Vendors
1 10 (26.32%) Microsoft
2 4 (10.53%) Teradata
3 3 (7.89%) IBM
4 2 (5.26%) Cognizant
4 2 (5.26%) Oracle
4 2 (5.26%) Pega
4 2 (5.26%) Tableau
5 1 (2.63%) Anaplan
5 1 (2.63%) Huawei
5 1 (2.63%) Nokia
5 1 (2.63%) VMware