Period
to 22 October 2018

The following table provides summary statistics for contract job vacancies advertised in Scotland 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 22 October 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)
UK > Scotland
6 months to
22 Oct 2018
Same period 2017 Same period 2016
Rank 156 155 138
Rank change year-on-year -1 -17 -17
Contract jobs citing VBA 48 27 57
As % of all contract IT jobs advertised in Scotland 0.90% 0.56% 1.22%
As % of the Programming Languages category 2.20% 1.40% 3.16%
Number of daily rates quoted 23 9 30
Scotland median daily rate £325 £350 £305
Median daily rate % change year-on-year -7.14% +14.75% -6.87%
10th Percentile £208 £175 £261
90th Percentile £394 £475 £438
UK median daily rate £400 £425 £375
% change year-on-year -5.88% +13.33% -6.25%
Number of hourly rates quoted 3 1 0
Scotland median hourly rate £30.00 £19.00 -
Median hourly rate % change year-on-year +57.89% - -
UK median hourly rate £18.00 £23.49 £18.25
% change year-on-year -23.38% +28.73% -18.89%

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

All Programming Languages
Scotland
Contract vacancies with a requirement for coding skills 2,179 1,922 1,806
As % of all contract IT jobs advertised in Scotland 40.64% 39.98% 38.76%
Number of daily rates quoted 1,237 1,142 1,079
Scotland median daily rate £400 £388 £350
Median daily rate % change year-on-year +3.23% +10.71% -
10th Percentile £300 £281 £262
90th Percentile £538 £525 £475
UK median daily rate £475 £450 £425
% change year-on-year +5.56% +5.88% +6.25%
Number of hourly rates quoted 21 25 32
Scotland median hourly rate £30.00 £35.00 £40.00
Median hourly rate % change year-on-year -14.29% -12.50% +10.65%
10th Percentile £10.75 £15.68 £19.05
90th Percentile £44.27 £195.00 £45.70
UK median hourly rate £42.00 £40.00 £37.50
% change year-on-year +5.00% +6.67% +2.74%

VBA
Job Vacancy Trend in Scotland

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

Job vacancy trend for VBA in Scotland

VBA
Contractor Daily Rate Trend in Scotland

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

Contractor daily rate trend for VBA in Scotland

VBA
Contractor Daily Rate Histogram in Scotland

The daily rate distribution of IT jobs citing VBA in Scotland over the 6 months to 22 October 2018.

Contractor daily rate histogram for VBA in Scotland

VBA
Contractor Hourly Rate Trend in Scotland

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

Contractor hourly rate trend for VBA in Scotland

VBA
Contract Job Locations in Scotland

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing VBA within the Scotland region over the 6 months to 22 October 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
Edinburgh -5 22 £360 +6.67% 5
Glasgow -7 11 £325 -23.53% 2
West Lothian - 5 £235 -
Renfrewshire - 5 - -
Aberdeen - 3 - -
VBA
UK

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

1 33 (68.75%) Microsoft Excel
2 29 (60.42%) SQL
3 22 (45.83%) Finance
4 15 (31.25%) Microsoft
5 13 (27.08%) SQL Server
6 11 (22.92%) Banking
7 10 (20.83%) .NET
7 10 (20.83%) Self-Motivation
8 9 (18.75%) Microsoft Office
8 9 (18.75%) MS Access
9 8 (16.67%) C#
10 7 (14.58%) VB
10 7 (14.58%) SharePoint
11 6 (12.50%) ETL
11 6 (12.50%) Project Management
11 6 (12.50%) Web Development
11 6 (12.50%) User Acceptance Testing
11 6 (12.50%) Problem-Solving
11 6 (12.50%) Office 365
12 5 (10.42%) BusinessObjects
12 5 (10.42%) Java
13 4 (8.33%) SAS
13 4 (8.33%) SAP
13 4 (8.33%) Windows
13 4 (8.33%) Data Analysis
13 4 (8.33%) Analytical Skills
14 3 (6.25%) Windows 10
14 3 (6.25%) Software Engineering
14 3 (6.25%) Agile Software Development
14 3 (6.25%) SQL Server Integration Services

VBA
Co-occurring IT Skills in Scotland 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 7 (14.58%) SharePoint
2 4 (8.33%) SAS
3 2 (4.17%) WebSphere
4 1 (2.08%) SharePoint 2013
Applications
1 33 (68.75%) Microsoft Excel
2 9 (18.75%) Microsoft Office
3 2 (4.17%) Spreadsheet
4 1 (2.08%) Microsoft PowerPoint
Business Applications
1 2 (4.17%) Magento
2 1 (2.08%) Cognos Business Intelligence
2 1 (2.08%) Cognos TM1
Cloud Services
1 6 (12.50%) Office 365
Communications & Networking
1 1 (2.08%) Broadband
Database & Business Intelligence
1 13 (27.08%) SQL Server
2 9 (18.75%) MS Access
3 5 (10.42%) BusinessObjects
4 3 (6.25%) SQL Server Integration Services
5 2 (4.17%) Data Warehouse
5 2 (4.17%) DB2
5 2 (4.17%) MySQL
6 1 (2.08%) Base SAS
6 1 (2.08%) BusinessObjects Web Intelligence
6 1 (2.08%) OLAP
6 1 (2.08%) Oracle Database
6 1 (2.08%) SAS EBI
6 1 (2.08%) SQL Server Reporting Services
6 1 (2.08%) Star Schema
Development Applications
1 1 (2.08%) Git (software)
1 1 (2.08%) JIRA
1 1 (2.08%) Visual Studio
General
1 22 (45.83%) Finance
2 11 (22.92%) Banking
3 1 (2.08%) Billing
3 1 (2.08%) Front Office
3 1 (2.08%) Telecoms
Job Titles
1 18 (37.50%) Analyst
2 13 (27.08%) Developer
3 6 (12.50%) SQL Analyst
3 6 (12.50%) VBA Developer
4 5 (10.42%) Data Analyst
5 4 (8.33%) Excel Analyst
6 3 (6.25%) Analyst Developer
6 3 (6.25%) Database Designer
6 3 (6.25%) Designer
6 3 (6.25%) Report Analyst
6 3 (6.25%) Software Engineer
6 3 (6.25%) SQL Data Analyst
6 3 (6.25%) Systems Designer
7 2 (4.17%) .NET Developer
7 2 (4.17%) 2nd Line Support
7 2 (4.17%) Consultant
7 2 (4.17%) Lead Developer
7 2 (4.17%) Service Desk Support
7 2 (4.17%) Tester
7 2 (4.17%) VB Developer
Libraries, Frameworks & Software Standards
1 10 (20.83%) .NET
2 3 (6.25%) LDAP
3 2 (4.17%) .NET Framework
4 1 (2.08%) ActiveX
4 1 (2.08%) ATL
Miscellaneous
1 10 (20.83%) Self-Motivation
2 4 (8.33%) Analytical Skills
3 2 (4.17%) FMCG
4 1 (2.08%) Blog
4 1 (2.08%) Credit Risk
4 1 (2.08%) Enterprise Software
4 1 (2.08%) Market Risk
Operating Systems
1 4 (8.33%) Windows
2 3 (6.25%) Windows 10
3 2 (4.17%) Windows Server 2008
Processes & Methodologies
1 6 (12.50%) ETL
1 6 (12.50%) Problem-Solving
1 6 (12.50%) Project Management
1 6 (12.50%) User Acceptance Testing
1 6 (12.50%) Web Development
2 4 (8.33%) Data Analysis
3 3 (6.25%) Agile Software Development
3 3 (6.25%) ITIL
3 3 (6.25%) Software Engineering
4 2 (4.17%) Analytics
4 2 (4.17%) Business Intelligence
4 2 (4.17%) Configuration Management
4 2 (4.17%) E-Commerce
4 2 (4.17%) Migration
4 2 (4.17%) OO
4 2 (4.17%) Scenario Testing
4 2 (4.17%) Stakeholder Management
4 2 (4.17%) Test Automation
4 2 (4.17%) Time Management
4 2 (4.17%) Validation
Programming Languages
1 29 (60.42%) SQL
2 8 (16.67%) C#
3 7 (14.58%) VB
4 5 (10.42%) Java
5 3 (6.25%) PL/SQL
6 2 (4.17%) C++
6 2 (4.17%) PHP
6 2 (4.17%) PowerShell
6 2 (4.17%) T-SQL
6 2 (4.17%) VB.NET
6 2 (4.17%) VB6
7 1 (2.08%) C
7 1 (2.08%) Python
7 1 (2.08%) SAS Macro
Qualifications
1 1 (2.08%) Degree
1 1 (2.08%) SC Cleared
1 1 (2.08%) Security Cleared
Quality Assurance & Compliance
1 2 (4.17%) IFRS
1 2 (4.17%) IFRS 9
2 1 (2.08%) Data Quality
2 1 (2.08%) Disclosure Scotland
2 1 (2.08%) QA
System Software
1 2 (4.17%) Active Directory
Systems Management
1 2 (4.17%) SCCM
Vendors
1 15 (31.25%) Microsoft
2 4 (8.33%) SAP
3 3 (6.25%) IBM
4 2 (4.17%) Citrix
4 2 (4.17%) Oracle
4 2 (4.17%) Tableau
4 2 (4.17%) Twitter
5 1 (2.08%) Automation Anywhere
5 1 (2.08%) Cognos
5 1 (2.08%) ServiceNow