The table below looks at the statistics for VBA skills in IT contracts advertised for the West Midlands region. Included is a guide to the average contractor rates offered in IT contracts that have cited VBA over the 3 months to 19 December 2014 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.

Location
3 months to
19 Dec 2014
Same period 2013 Same period 2012
Microsoft Visual Basic for Applications (VBA)
Rank 81 64 98
Rank change year-on-year
-17 +34
Contract jobs citing VBA 33 35 10
As % of all contract IT jobs located in the West Midlands 1.42% 1.64% 0.49%
As % of the Programming Languages category 4.61% 4.56% 1.35%
Number of daily rates quoted 16 21 2
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£200 £300 £331
Average daily rate % change year-on-year
-33.33% -9.43%
90% offered a daily rate of more than £150 £185 £326
10% offered a daily rate of more than £286 £374 £336
UK excluding London average daily rate £350 £290 £275
% change year-on-year
+20.68% +5.45%
Number of hourly rates quoted 9 4 2
Average hourly rate £22.35 £24.25 £13.25
Average hourly rate % change year-on-year
-7.83% +83.01%
90% offered a hourly rate of more than £16.85 £23.50 £9.85
10% offered a hourly rate of more than £35.90 £26.40 £16.65
UK excluding London average hourly rate £25.00 £24.25 £18.00
% change year-on-year
+3.09% +34.72%
VBA
England

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

Programming Languages Category
West Midlands
Contract IT job ads with a match in the
Programming Languages category
716 767 740
As % of all contract IT jobs located in the West Midlands 30.77% 35.96% 36.58%
Number of daily rates quoted 448 446 378
Average daily rate £350 £310 £315
Average daily rate % change year-on-year
+12.90% -1.58%
90% offered a daily rate of more than £230 £225 £240
10% offered a daily rate of more than £450 £435 £400
UK excluding London average daily rate £350 £325 £325
% change year-on-year
+7.69% -
Number of hourly rates quoted 42 27 39
Average hourly rate £28.69 £27.50 £31.00
Average hourly rate % change year-on-year
+4.32% -11.29%
90% offered a hourly rate of more than £16.85 £16.50 £16.08
10% offered a hourly rate of more than £37.50 £35.00 £36.25
UK excluding London average hourly rate £35.50 £33.00 £35.00
% change year-on-year
+7.57% -5.71%

VBA
Jobs Demand Trend in the West Midlands

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

VBA Jobs Demand Trend in the West Midlands

VBA
Daily Rate Trend in the West Midlands

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

VBA Daily Rate Trend in the West Midlands

VBA
Daily Rate Histogram in the West Midlands

This chart provides a histogram of daily rates quoted in contract IT jobs citing VBA across the West Midlands region over the 3 months to 19 December 2014.

VBA Daily Rate Histogram in the West Midlands

VBA
Hourly Rate Trend in the West Midlands

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

VBA Hourly Rate Trend in the West Midlands

VBA
Hourly Rate Histogram in the West Midlands

This chart provides a histogram of hourly rates quoted in contract IT jobs citing VBA across the West Midlands region over the 3 months to 19 December 2014.

VBA Hourly Rate Histogram in the West Midlands

VBA
Contract Job Locations in the West Midlands

The table below looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing VBA within the West Midlands region over the 3 months to 19 December 2014. 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
(Use links below to see detailed
statistics and historical trends)
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
Live
Job
Vacancies
Coventry +4 11 £235 +67.85% 1
Birmingham +2 10 £155 -34.73% 1
Warwickshire -15 5 £225 -39.18% 1
Wolverhampton - 1 £273 -
Herefordshire - - - -
Shropshire - - - -
Staffordshire - - - - 2
Solihull - - - -
VBA
England

VBA
Top 30 Related IT Skills in the West Midlands

For the 6 months to 19 December 2014, IT contractor jobs across the West Midlands 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 40 (61.54%) SQL
2 27 (41.54%) MS Excel
3 20 (30.77%) Microsoft
4 18 (27.69%) VB
4 18 (27.69%) Spreadsheet
5 17 (26.15%) Analytical Skills
6 14 (21.54%) .NET
6 14 (21.54%) MS Office
7 13 (20.00%) OO
7 13 (20.00%) Software Engineering
8 12 (18.46%) SQL Server
8 12 (18.46%) VBScript
9 11 (16.92%) VB.NET
10 10 (15.38%) MS Visio
10 10 (15.38%) Stakeholder Management
11 9 (13.85%) Data Modelling
11 9 (13.85%) Data Entry
11 9 (13.85%) MS PowerPoint
11 9 (13.85%) Unit Testing
11 9 (13.85%) Test Scripting
12 8 (12.31%) Analytics
12 8 (12.31%) Windows
13 7 (10.77%) MS Access
13 7 (10.77%) TCP/IP
13 7 (10.77%) Business Intelligence
13 7 (10.77%) SharePoint
13 7 (10.77%) Finance
13 7 (10.77%) Mathematics
13 7 (10.77%) Statistics
14 6 (9.23%) Degree

VBA
Top Related IT Skills in the West Midlands by Category

For the 6 months to 19 December 2014, IT contractor jobs across the West Midlands 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 7 (10.77%) SharePoint
2 3 (4.62%) MS Exchange
2 3 (4.62%) Apache Spark
3 2 (3.08%) Exchange Server 2003
3 2 (3.08%) SAS
3 2 (3.08%) IIS
4 1 (1.54%) SharePoint 2010
4 1 (1.54%) Exchange Server 2010
Applications
1 27 (41.54%) MS Excel
2 18 (27.69%) Spreadsheet
3 14 (21.54%) MS Office
4 10 (15.38%) MS Visio
5 9 (13.85%) MS PowerPoint
6 1 (1.54%) Photoshop
6 1 (1.54%) CATIA
6 1 (1.54%) Adobe Illustrator
Business Applications
1 1 (1.54%) Cognos TM1
1 1 (1.54%) Teamcenter
1 1 (1.54%) MoSes
1 1 (1.54%) Cognos Business Intelligence
Communications & Networking
1 7 (10.77%) TCP/IP
2 5 (7.69%) SAN
3 4 (6.15%) Firewall
4 2 (3.08%) Intranet
4 2 (3.08%) Internet
Database & Business Intelligence
1 12 (18.46%) SQL Server
2 7 (10.77%) MS Access
3 5 (7.69%) SQL Server Reporting Services
3 5 (7.69%) SQL Server Integration Services
4 4 (6.15%) Data Mining
5 3 (4.62%) Data Warehouse
5 3 (4.62%) SQL Server 2008
5 3 (4.62%) Hadoop
5 3 (4.62%) Apache Hive
5 3 (4.62%) Big Data
5 3 (4.62%) Relational Database
6 2 (3.08%) SQL Server 2012
6 2 (3.08%) MySQL
7 1 (1.54%) Cognos Powerplay
7 1 (1.54%) OLAP
7 1 (1.54%) DataStage
7 1 (1.54%) Microsoft Analysis Services
7 1 (1.54%) Cognos Framework Manager
7 1 (1.54%) SQL Server Analysis Services
General
1 7 (10.77%) Finance
2 5 (7.69%) Manufacturing
3 3 (4.62%) Automotive
3 3 (4.62%) Banking
3 3 (4.62%) Retail
4 2 (3.08%) Publishing
5 1 (1.54%) Front Office
5 1 (1.54%) Investment Banking
Job Titles
1 29 (44.62%) Analyst
2 20 (30.77%) Developer
3 12 (18.46%) Data Analyst
4 7 (10.77%) Software Developer
5 6 (9.23%) MI Analyst
6 5 (7.69%) Business Analyst
6 5 (7.69%) Report Analyst
6 5 (7.69%) Infrastructure Engineer
6 5 (7.69%) Service Analyst
6 5 (7.69%) Service Management Analyst
7 4 (6.15%) VBA Developer
7 4 (6.15%) Systems Engineer
8 3 (4.62%) Software Engineer
8 3 (4.62%) Support Analyst
8 3 (4.62%) Data Modeller
8 3 (4.62%) Excel Specialist
9 2 (3.08%) Data Analytics Manager
9 2 (3.08%) IT Support
9 2 (3.08%) Data Manager
9 2 (3.08%) IT Support Analyst
Libraries, Frameworks & Software Standards
1 14 (21.54%) .NET
2 3 (4.62%) ASP.NET
3 2 (3.08%) jQuery
3 2 (3.08%) HTML
3 2 (3.08%) CSS
4 1 (1.54%) Classic ASP
4 1 (1.54%) XML
4 1 (1.54%) HTML5
4 1 (1.54%) CSS3
4 1 (1.54%) JSON
4 1 (1.54%) MDX
Miscellaneous
1 17 (26.15%) Analytical Skills
2 7 (10.77%) Mathematics
2 7 (10.77%) Statistics
3 4 (6.15%) Reference Data
4 1 (1.54%) Management Information System
4 1 (1.54%) Data Conversion
4 1 (1.54%) Data Structures
4 1 (1.54%) Market Risk
4 1 (1.54%) Derivative
Operating Systems
1 8 (12.31%) Windows
2 5 (7.69%) Solaris
2 5 (7.69%) Linux
2 5 (7.69%) Windows Server 2003
2 5 (7.69%) UNIX
2 5 (7.69%) Windows Server 2008
2 5 (7.69%) Windows Server 2012
3 2 (3.08%) Windows Vista
3 2 (3.08%) Windows XP
Processes & Methodologies
1 13 (20.00%) OO
1 13 (20.00%) Software Engineering
2 10 (15.38%) Stakeholder Management
3 9 (13.85%) Data Modelling
3 9 (13.85%) Data Entry
3 9 (13.85%) Unit Testing
3 9 (13.85%) Test Scripting
4 8 (12.31%) Analytics
5 7 (10.77%) Business Intelligence
6 6 (9.23%) ITIL
7 5 (7.69%) ITSM
7 5 (7.69%) Service Management
7 5 (7.69%) Service Delivery
8 4 (6.15%) Data Analysis
8 4 (6.15%) ETL
8 4 (6.15%) OOP
9 3 (4.62%) Disaster Recovery
9 3 (4.62%) Project Management
9 3 (4.62%) Agile Software Development
9 3 (4.62%) Waterfall
Programming Languages
1 40 (61.54%) SQL
2 18 (27.69%) VB
3 12 (18.46%) VBScript
4 11 (16.92%) VB.NET
5 5 (7.69%) PowerShell
6 3 (4.62%) C#
6 3 (4.62%) Shell Script
7 2 (3.08%) VB6
7 2 (3.08%) JavaScript
7 2 (3.08%) C
8 1 (1.54%) PHP
8 1 (1.54%) Java
8 1 (1.54%) C++
8 1 (1.54%) Python
8 1 (1.54%) PHP5
Qualifications
1 6 (9.23%) Degree
2 5 (7.69%) ITIL Certification
3 1 (1.54%) HNC
3 1 (1.54%) HND
Quality Assurance & Compliance
1 5 (7.69%) QA
2 1 (1.54%) Data Quality
System Software
1 4 (6.15%) Active Directory
2 3 (4.62%) VMware Infrastructure
3 1 (1.54%) VMware Server
Systems Management
1 5 (7.69%) NetBackup
Vendors
1 20 (30.77%) Microsoft
2 5 (7.69%) Red Hat
2 5 (7.69%) VMware
2 5 (7.69%) ServiceNow
3 4 (6.15%) Symantec
4 3 (4.62%) IBM
4 3 (4.62%) Tableau
4 3 (4.62%) Google
5 1 (1.54%) PeopleSoft
5 1 (1.54%) Cognos
5 1 (1.54%) Business Objects
5 1 (1.54%) Siemens