The table below looks at the statistics for VBA skills in IT contracts advertised for the Edinburgh region. Included is a guide to the average contractor rates offered in IT contracts that have cited VBA over the 3 months to 28 April 2016 with a comparison to the same period in the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

3 months to
28 Apr 2016
Same period 2015 Same period 2014
Microsoft Visual Basic for Applications (VBA)
Rank 75 55 59
Rank change year-on-year
-20 +4
Contract jobs citing VBA 19 32 22
As % of all contract IT jobs located in Edinburgh 1.25% 2.19% 1.74%
As % of the Programming Languages category 4.41% 7.90% 5.18%
Number of daily rates quoted 13 20 15
Average daily rate £400 £420 £375
Average daily rate % change year-on-year
-4.76% +12.00%
90% offered a daily rate of more than £354 £186 £225
10% offered a daily rate of more than £475 £455 £433
UK excluding London average daily rate £350 £350 £300
% change year-on-year
- +16.66%
Number of hourly rates quoted 0 0 1
Average hourly rate - - £14.25
UK excluding London average hourly rate £19.00 £22.50 £22.00
% change year-on-year
-15.55% +2.27%
VBA
Scotland

The following table is for comparison with the above and provides statistics for the entire Programming Languages category in contract jobs advertised in the Edinburgh region.

Programming Languages Category
Edinburgh
Contract IT job ads with a match in the
Programming Languages category
431 405 425
As % of all contract IT jobs located in Edinburgh 28.24% 27.76% 33.65%
Number of daily rates quoted 251 258 244
Average daily rate £400 £375 £350
Average daily rate % change year-on-year
+6.66% +7.14%
90% offered a daily rate of more than £280 £275 £235
10% offered a daily rate of more than £525 £467 £468
UK excluding London average daily rate £375 £350 £335
% change year-on-year
+7.14% +4.47%
Number of hourly rates quoted 2 3 14
Average hourly rate £26.00 £55.00 £25.00
Average hourly rate % change year-on-year
-52.72% +120.00%
90% offered a hourly rate of more than £15.60 £31.50 £20.84
10% offered a hourly rate of more than £36.40 £55.00 £32.00
UK excluding London average hourly rate £38.00 £35.50 £36.50
% change year-on-year
+7.04% -2.73%

VBA
Jobs Demand Trend in Edinburgh

This chart provides a 3-month moving total of IT contractor jobs citing VBA across the Edinburgh region as a proportion of the total demand within the Programming Languages category.

VBA Jobs Demand Trend in Edinburgh

VBA
Daily Rate Trend in Edinburgh

This chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing VBA across the Edinburgh region.

VBA Daily Rate Trend in Edinburgh

VBA
Hourly Rate Trend in Edinburgh

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

VBA Hourly Rate Trend in Edinburgh

VBA
Top 30 Related IT Skills in Edinburgh

For the 6 months to 28 April 2016, IT contractor jobs across the Edinburgh region citing VBA also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited VBA.

1 32 (82.05%) Finance
2 15 (38.46%) SQL
3 14 (35.90%) Banking
4 9 (23.08%) Java
4 9 (23.08%) Windows
4 9 (23.08%) RAD
4 9 (23.08%) MS Access
5 8 (20.51%) Solaris
5 8 (20.51%) Linux
6 7 (17.95%) Unix
6 7 (17.95%) Financial Institution
6 7 (17.95%) Stakeholder Management
6 7 (17.95%) Perl
6 7 (17.95%) Microsoft
6 7 (17.95%) Ruby
6 7 (17.95%) PowerShell
7 6 (15.38%) OAuth
7 6 (15.38%) Veritas Volume Manager
7 6 (15.38%) Veritas File System
7 6 (15.38%) Veritas Cluster Server
7 6 (15.38%) Hedge funds
7 6 (15.38%) PKI
7 6 (15.38%) Asset Management
7 6 (15.38%) Active Directory
7 6 (15.38%) Data Warehouse
7 6 (15.38%) SAS
7 6 (15.38%) Business Intelligence
7 6 (15.38%) Veritas
7 6 (15.38%) Nagios
7 6 (15.38%) MS Office

VBA
Top Related IT Skills in Edinburgh by Category

For the 6 months to 28 April 2016, IT contractor jobs across the Edinburgh region citing VBA also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited VBA. Up to 20 skills are shown per category.

Application Platforms
1 6 (15.38%) SAS
2 2 (5.13%) WebSphere
3 1 (2.56%) ArcGIS
3 1 (2.56%) SharePoint
Applications
1 6 (15.38%) MS Excel
1 6 (15.38%) MS Office
2 3 (7.69%) MS PowerPoint
3 1 (2.56%) Spreadsheet
Communications & Networking
1 6 (15.38%) LDAP
2 1 (2.56%) Intranet
Database & Business Intelligence
1 9 (23.08%) MS Access
2 6 (15.38%) Data Warehouse
3 3 (7.69%) Oracle BI EE
4 2 (5.13%) BusinessObjects
4 2 (5.13%) GIS
4 2 (5.13%) Hadoop
4 2 (5.13%) QlikView
4 2 (5.13%) Relational Database
4 2 (5.13%) SQL Server
5 1 (2.56%) Enterprise Data Warehouse
5 1 (2.56%) Oracle Reports
5 1 (2.56%) QGIS
Development Applications
1 2 (5.13%) JIRA
1 2 (5.13%) Visual Studio Tools for Office
General
1 32 (82.05%) Finance
2 14 (35.90%) Banking
3 7 (17.95%) Financial Institution
4 2 (5.13%) Marketing
5 1 (2.56%) International Banking
5 1 (2.56%) Legal
5 1 (2.56%) Retail
5 1 (2.56%) Retail Banking
Job Titles
1 15 (38.46%) Analyst
2 8 (20.51%) Developer
3 6 (15.38%) Senior Developer
4 5 (12.82%) Data Analyst
4 5 (12.82%) Excel Developer
4 5 (12.82%) Excel VBA Developer
4 5 (12.82%) VBA Developer
5 4 (10.26%) Financial Analyst
5 4 (10.26%) Senior Excel Developer
5 4 (10.26%) Senior Excel VBA Developer
5 4 (10.26%) Senior VBA Developer
6 3 (7.69%) Applications Developer
6 3 (7.69%) Business Analyst
6 3 (7.69%) Data Modeller
6 3 (7.69%) Report Analyst
6 3 (7.69%) Senior Applications Developer
7 2 (5.13%) Architect
7 2 (5.13%) Credit Analyst
7 2 (5.13%) SAS Analyst
7 2 (5.13%) Solutions Architect
Libraries, Frameworks & Software Standards
1 6 (15.38%) OAuth
1 6 (15.38%) Web Services
2 2 (5.13%) Middleware
2 2 (5.13%) TIBCO EMS
2 2 (5.13%) XML
3 1 (2.56%) HTML
Miscellaneous
1 6 (15.38%) Clustering
1 6 (15.38%) Hedge funds
1 6 (15.38%) Mainframe
1 6 (15.38%) PKI
2 5 (12.82%) Analytical Skills
2 5 (12.82%) Management Information System
3 2 (5.13%) Credit Risk
3 2 (5.13%) Data Structures
3 2 (5.13%) Visualisation
Operating Systems
1 9 (23.08%) Windows
2 8 (20.51%) Linux
2 8 (20.51%) Solaris
3 7 (17.95%) Unix
Processes & Methodologies
1 9 (23.08%) RAD
2 7 (17.95%) Stakeholder Management
3 6 (15.38%) Asset Management
3 6 (15.38%) Business Intelligence
3 6 (15.38%) Identity Management
4 5 (12.82%) Analytics
4 5 (12.82%) Data Analysis
4 5 (12.82%) Workflow
5 4 (10.26%) Data Management
5 4 (10.26%) Data Modelling
5 4 (10.26%) Investment Management
5 4 (10.26%) Risk Management
5 4 (10.26%) Translating Business Requirements
6 3 (7.69%) Business Analysis
6 3 (7.69%) ETL
6 3 (7.69%) Financial Modelling
6 3 (7.69%) Programme Management
6 3 (7.69%) Time Management
7 2 (5.13%) Release Management
7 2 (5.13%) User Acceptance Testing
Programming Languages
1 15 (38.46%) SQL
2 9 (23.08%) Java
3 7 (17.95%) Perl
3 7 (17.95%) PowerShell
3 7 (17.95%) Ruby
4 2 (5.13%) C#
4 2 (5.13%) C++
5 1 (2.56%) Python
5 1 (2.56%) VB
Qualifications
1 2 (5.13%) Degree
1 2 (5.13%) MBA
2 1 (2.56%) Six Sigma Green Belt
Quality Assurance & Compliance
1 2 (5.13%) QA
2 1 (2.56%) Data Quality
System Software
1 6 (15.38%) Active Directory
1 6 (15.38%) Veritas Cluster Server
1 6 (15.38%) Veritas File System
1 6 (15.38%) Veritas Volume Manager
Systems Management
1 6 (15.38%) Nagios
1 6 (15.38%) TADDM
Vendors
1 7 (17.95%) Microsoft
2 6 (15.38%) Veritas
3 5 (12.82%) Oracle
4 2 (5.13%) HP
4 2 (5.13%) Sybase
4 2 (5.13%) Teradata
4 2 (5.13%) TIBCO
5 1 (2.56%) Mapinfo