The first table below looks at the demand for VBA skills in IT contracts advertised for the Scotland region. Included is a guide to the average contractor rates offered in IT contracts that have cited VBA over the 3 months to 17 May 2013 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Programming Languages category for the Scotland region.

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.

Location
3 months to
17 May 2013
Same period 2012 Same period 2011
Microsoft Visual Basic for Applications (VBA)
Rank 78 76 81
Rank change year-on-year
-2 +5
Contract jobs citing VBA 42 30 33
As % of all contract IT jobs located in Scotland 1.722% 1.133% 1.176%
As % of the Programming Languages category 4.015% 4.622% 3.952%
Number of daily rates quoted 24 14 13
Average daily rate £275 £325 £225
Average daily rate % change year-on-year
-15.38% +44.44%
90% offered a daily rate of more than £235 £208 £177
10% offered a daily rate of more than £450 £418 £370
UK excluding London average daily rate £290 £300 £300
% change year-on-year
-3.33% -
Number of hourly rates quoted 0 1 0
Average hourly rate - £11.00 -
UK excluding London average hourly rate £37.80 £25.00 £25.00
% change year-on-year
+51.20% -
All Programming Languages
Scotland
Contract IT job ads with a match in the
Programming Languages category
1046 649 835
As % of all contract IT jobs located in Scotland 42.89% 24.50% 29.77%
Number of daily rates quoted 514 302 421
Average daily rate £355 £313 £341
Average daily rate % change year-on-year
+13.60% -8.35%
90% offered a daily rate of more than £250 £225 £239
10% offered a daily rate of more than £475 £400 £450
UK excluding London average daily rate £325 £325 £325
Number of hourly rates quoted 19 29 21
Average hourly rate £30.00 £27.50 £31.44
Average hourly rate % change year-on-year
+9.09% -12.53%
90% offered a hourly rate of more than £12.42 £16.00 £14.95
10% offered a hourly rate of more than £44.00 £32.50 £40.00
UK excluding London average hourly rate £35.00 £35.00 £35.00
VBA
UK

VBA
Jobs Demand Trend

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

Scotland VBA Jobs Demand Trend

VBA
Daily Rate Trend

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

Scotland VBA Daily Rate Trend

VBA
Daily Rate Histogram

This chart provides a histogram of daily rates quoted in contract IT jobs citing VBA across the Scotland region over the 3 months to 17 May 2013.

Scotland VBA Daily Rate Histogram

VBA
Hourly Rate Trend

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

Scotland VBA Hourly Rate Trend

VBA
Contract Locations

The table below looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing VBA within the Scotland region over the 3 months to 17 May 2013. 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
(Click each for more statistics)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Average
Daily Rate
Last 3 Months
Average Daily Rate
% Change
on Same Period
Last Year
Glasgow +5 32 £275 +4.76%
Aberdeen +2 3 £250 -
Edinburgh -5 3 £288 -16.05%
Dundee - 2 - -
Stirling -10 1 - -
VBA
UK

VBA
Top 30 Related IT Skills

For the 6 months to 17 May 2013, IT contractor jobs across the Scotland 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 38 (52.78%) Finance
2 30 (41.67%) Banking
3 25 (34.72%) SQL
4 17 (23.61%) SQL Server
5 15 (20.83%) MS Excel
6 13 (18.06%) Data Analysis
6 13 (18.06%) MS Access
7 12 (16.67%) Investment Banking
8 11 (15.28%) VB
9 10 (13.89%) SQL Server Integration Services
9 10 (13.89%) Credit Risk
10 8 (11.11%) QlikView
10 8 (11.11%) Sybase
10 8 (11.11%) Windows
10 8 (11.11%) Business Intelligence
11 7 (9.722%) UNIX
11 7 (9.722%) Linux
11 7 (9.722%) .NET
11 7 (9.722%) Oracle
11 7 (9.722%) Information Security
11 7 (9.722%) Risk Management
11 7 (9.722%) Stakeholder Management
11 7 (9.722%) SQL Server 2005
12 6 (8.333%) MS PowerPoint
12 6 (8.333%) COBIT
12 6 (8.333%) Business Objects
12 6 (8.333%) C#
12 6 (8.333%) Java
12 6 (8.333%) Solaris
12 6 (8.333%) XML

VBA
Top Related IT Skills by Category

For the 6 months to 17 May 2013, IT contractor jobs across the Scotland 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 Development
1 7 (9.722%) .NET
2 6 (8.333%) XML
2 6 (8.333%) XSL
3 5 (6.944%) XSLT
4 4 (5.556%) WinForms
5 3 (4.167%) ASP.NET
6 2 (2.778%) .NET Framework
6 2 (2.778%) jQuery
7 1 (1.389%) J2EE
Application Platforms
1 4 (5.556%) SharePoint
Applications
1 15 (20.83%) MS Excel
2 6 (8.333%) MS PowerPoint
3 1 (1.389%) Spreadsheet
3 1 (1.389%) MS Visio
3 1 (1.389%) MS Office
Communications & Networking
1 1 (1.389%) IP Telephony
Database & Business Intelligence
1 17 (23.61%) SQL Server
2 13 (18.06%) MS Access
3 10 (13.89%) SQL Server Integration Services
4 8 (11.11%) QlikView
5 7 (9.722%) SQL Server 2005
6 6 (8.333%) SQL Server 2000
6 6 (8.333%) DTS
7 5 (6.944%) SQL Server Reporting Services
7 5 (6.944%) SQL Server 2008
8 3 (4.167%) Oracle 11g
8 3 (4.167%) Oracle 9i
9 2 (2.778%) Oracle 8/8i
9 2 (2.778%) RDBMS
9 2 (2.778%) Data Warehouse
10 1 (1.389%) Crystal Reports
Development Applications
1 1 (1.389%) VSS/SourceSafe
1 1 (1.389%) QuickTest Pro
1 1 (1.389%) NUnit
1 1 (1.389%) Selenium
1 1 (1.389%) MSTest
1 1 (1.389%) Cucumber
General
1 38 (52.78%) Finance
2 30 (41.67%) Banking
3 12 (16.67%) Investment Banking
4 2 (2.778%) Retail
5 1 (1.389%) Manufacturing
Job Titles
1 37 (51.39%) Analyst
2 32 (44.44%) Developer
3 14 (19.44%) VBA Developer
4 13 (18.06%) Excel Developer
5 11 (15.28%) Excel VBA Developer
6 8 (11.11%) MI Analyst
6 8 (11.11%) Risk Analyst
6 8 (11.11%) Data Analyst
7 7 (9.722%) Business Analyst
8 6 (8.333%) Programmer
9 4 (5.556%) Consultant
9 4 (5.556%) .NET Developer
9 4 (5.556%) Access Developer
10 3 (4.167%) C# Developer
10 3 (4.167%) Oracle Developer
10 3 (4.167%) SQL Developer
10 3 (4.167%) Analyst Programmer
10 3 (4.167%) Senior Analyst
10 3 (4.167%) Business Intelligence Analyst
10 3 (4.167%) Credit Risk Analyst
Miscellaneous
1 10 (13.89%) Credit Risk
2 5 (6.944%) Derivative
3 4 (5.556%) Management Information System
4 3 (4.167%) Equity Derivative
5 2 (2.778%) Data Extraction
6 1 (1.389%) Economics
6 1 (1.389%) Statistics
6 1 (1.389%) Mathematics
Operating Systems
1 8 (11.11%) Windows
2 7 (9.722%) UNIX
2 7 (9.722%) Linux
3 6 (8.333%) Solaris
Processes & Methodologies
1 13 (18.06%) Data Analysis
2 8 (11.11%) Business Intelligence
3 7 (9.722%) Risk Management
3 7 (9.722%) Stakeholder Management
3 7 (9.722%) Information Security
4 5 (6.944%) Software Testing
4 5 (6.944%) Regression Testing
4 5 (6.944%) Manual Testing
4 5 (6.944%) Test Automation
5 3 (4.167%) Financial Modelling
5 3 (4.167%) MVC
5 3 (4.167%) Migration
5 3 (4.167%) Risk Assessment
6 2 (2.778%) Analytics
6 2 (2.778%) Time Management
7 1 (1.389%) Business Analysis
7 1 (1.389%) Statistical Modelling
7 1 (1.389%) Asset Management
7 1 (1.389%) Data Management
7 1 (1.389%) Operations Research
Programming Languages
1 25 (34.72%) SQL
2 11 (15.28%) VB
3 6 (8.333%) C#
3 6 (8.333%) Java
3 6 (8.333%) Shell Script
4 5 (6.944%) Perl
5 4 (5.556%) PL/SQL
5 4 (5.556%) T-SQL
6 3 (4.167%) VBScript
6 3 (4.167%) VB.NET
7 2 (2.778%) C++
8 1 (1.389%) VB6
8 1 (1.389%) C
Qualifications
1 6 (8.333%) CISA
1 6 (8.333%) CISM
1 6 (8.333%) CRISC
2 3 (4.167%) Degree
Quality Assurance & Compliance
1 6 (8.333%) COBIT
2 5 (6.944%) QA
3 3 (4.167%) Sarbanes-Oxley
3 3 (4.167%) Basel II
4 1 (1.389%) Data Quality
Systems Management
1 4 (5.556%) Control-M
Vendors
1 8 (11.11%) Sybase
2 7 (9.722%) Oracle
3 6 (8.333%) Sun
3 6 (8.333%) Business Objects
4 3 (4.167%) Microsoft
5 2 (2.778%) MicroStrategy
6 1 (1.389%) DevExpress
6 1 (1.389%) Hyperion
6 1 (1.389%) Cognos
6 1 (1.389%) Siebel
Dundee, Angus
This role will help support the Management Information Development team deliver reporting from their new telephony system and email solution. You will assist with the database design to...
Search Consultancy
Salary: Pro Rata
Posted: 14 May 2013
Glasgow, Scotland
You will be working for a large banking client in their Supplier Security Team which manages all Information security Risks posed to the organisation by suppliers and service...
Harvey Nash Consulting (Scotland) Limited
Posted: 24 April 2013
Glasgow, Scotland
You will be working for a large banking client in their Supplier Security Team which manages all Information Security Risks posed to the organisation by suppliers and service...
Harvey Nash Consulting (Scotland) Limited
Rate: £000 - £1 per annum + TBC on discussion
Posted: 1 May 2013
Glasgow, Scotland
You will be working for a large banking client in their Supplier Security Team which manages all Information security Risks posed to the organisation by suppliers and service...
Harvey Nash Consulting (Scotland) Limited
Rate: Day Rate negotiable
Posted: 24 April 2013