City of London VBA Contracts

The table below looks at the demand for Microsoft Visual Basic for Applications (VBA) skills within the City of London region with a comparison to our Programming Languages category. Included is a guide to the contractor rates offered in IT jobs that have cited VBA over the 3 months to 8 October 2008 with a comparison to the same period last year.

Microsoft Visual Basic for Applications (VBA)
Location Aberdeen Alderley Edge Basildon Basingstoke Bath Berkshire Birmingham Blackpool Bradford Brighton Bristol Bromley Buckinghamshire Cambridge Cambridgeshire Canary Wharf Canterbury Cardiff Cheshire City of London Clapham Derby Derbyshire Docklands, London Dorchester Dorset Ealing East Midlands East of England East Sussex Edinburgh England Essex Glamorgan Glasgow Gloucestershire Hampshire Hertfordshire High Wycombe Home Counties Horsham Huntingdon Kent Lancashire Leeds Leek Liverpool London M4 Corridor Macclesfield Manchester Merseyside Middlesex Midlands Milton Keynes North East North Lanarkshire North West North Yorkshire Northampton Northamptonshire Nottingham Nottinghamshire Oxfordshire Peterborough Portsmouth Preston Reading Rickmansworth Scotland Shropshire Slough Solihull Somerset South East South Wales South West South Yorkshire Southampton Southend-on-Sea Staffordshire Staines Surrey Sussex Swindon Tamworth Teddington Telford Thames Valley Tonbridge Twickenham UK Wales Warwickshire Welwyn Garden City West Midlands West Sussex West Yorkshire Wiltshire Windsor Worthing York Yorkshire	3 months to 8 Oct 2008	Same period last year
Rank	48	30
Rank change on same period last year	-18
Matching contract IT job ads	259	378
As % of all UK contract IT job ads sampled	0.363 %	0.388 %
As % of the category below	8.160 %	11.63 %
Daily rates quoted	126	164
Average minimum daily rate	£385	£458
Average daily rate	£422	£485
% change on same period last year	-12.93 %
Average maximum daily rate	£459	£511
UK excluding London average daily rate	£245	£336
% change on same period last year	-27.25 %
Hourly rates quoted	2	5
Average minimum hourly rate	£22.50	£26.60
Average hourly rate	£26.25	£29.30
% change on same period last year	-10.40 %
Average maximum hourly rate	£30.00	£32.00
UK excluding London average hourly rate	£23.61	£28.29
% change on same period last year	-16.55 %
Programming Languages City of London
Matching contract IT job ads	3174	3250
As % of all UK contract IT job ads sampled	4.445 %	3.334 %
Daily rates quoted	1795	1432
Average minimum daily rate	£409	£460
Average daily rate	£445	£489
% change on same period last year	-9.01 %
Average maximum daily rate	£482	£518
UK excluding London average daily rate	£324	£334
% change on same period last year	-3.16 %
Hourly rates quoted	85	52
Average minimum hourly rate	£26.69	£30.26
Average hourly rate	£29.43	£31.96
% change on same period last year	-7.92 %
Average maximum hourly rate	£32.18	£33.67
UK excluding London average hourly rate	£32.27	£32.75
% change on same period last year	-1.44 %
VBA London

We calculate average IT contractor rates directly from the figures quoted and do not attempt to derive hourly rates from daily rates or vice versa.

VBA
Demand Trend

The chart provides a 3-month moving total beginning in 2004 of IT contractor jobs citing VBA across the City of London region as a proportion of the total demand within the Programming Languages category.

VBA
Daily Rate Trend

The chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing VBA across the City of London region.

VBA
Daily Rate Histogram

The chart provides a histogram of daily rates quoted in contract IT jobs citing VBA across the City of London region over the 3 months to 8 October 2008.

VBA
Hourly Rate Trend

The chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing VBA across the City of London region.

VBA
Hourly Rate Histogram

The chart provides a histogram of hourly rates quoted in contract IT jobs citing VBA across the City of London region over the 3 months to 8 October 2008.

VBA
Top 30 Related IT Skills

For the 6 months to 8 October 2008, IT contractor jobs across the City of London 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 199 (40.53 %) Banking 2 193 (39.31 %) Finance 3 169 (34.42 %) SQL 4 163 (33.20 %) Front Office 5 140 (28.51 %) Investment Banking 6 128 (26.07 %) C# 7 127 (25.87 %) Derivative 8 108 (22.00 %) VB 9 105 (21.38 %) .NET 10 82 (16.70 %) SQL Server 11 70 (14.26 %) C++ 12 66 (13.44 %) Oracle 13 65 (13.24 %) MS Excel 14 59 (12.02 %) Market Risk 15 52 (10.59 %) MS Access

16 50 (10.18 %) Fixed Income 16 50 (10.18 %) Equity Derivative 17 46 (9.369 %) Sybase 17 46 (9.369 %) Spreadsheet 18 45 (9.165 %) Degree 19 44 (8.961 %) RAD 20 42 (8.554 %) UNIX 20 42 (8.554 %) Java 21 41 (8.350 %) VB6 22 39 (7.943 %) Risk Management 23 37 (7.536 %) Microsoft 24 34 (6.925 %) Credit Derivative 25 32 (6.517 %) ASP.NET 26 28 (5.703 %) MS Office 26 28 (5.703 %) VB.NET

VBA
Top Related IT Skills by Category

For the 6 months to 8 October 2008, IT contractor jobs across the City of London 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 105 (21.38 %) .NET 2 32 (6.517 %) ASP.NET 3 28 (5.703 %) XML 4 17 (3.462 %) WinForms 5 15 (3.055 %) HTML 6 11 (2.240 %) ASP 7 9 (1.833 %) FIX Protocol 8 6 (1.222 %) Middleware 8 6 (1.222 %) .NET Framework 8 6 (1.222 %) COM 9 5 (1.018 %) MFC 10 4 (0.815 %) CSS 10 4 (0.815 %) XSL 10 4 (0.815 %) Murex Flex 10 4 (0.815 %) AJAX 11 3 (0.611 %) STL 12 2 (0.407 %) WebServices 12 2 (0.407 %) XSLT 12 2 (0.407 %) ODBC 12 2 (0.407 %) CORBA	Application Platforms 1 5 (1.018 %) TIBCO EMS 2 3 (0.611 %) Rendezvous 3 1 (0.204 %) WebLogic 3 1 (0.204 %) Apache 3 1 (0.204 %) Tomcat 3 1 (0.204 %) MQSeries 3 1 (0.204 %) SharePoint 3 1 (0.204 %) BizTalk Server 3 1 (0.204 %) WebSphere MQ
Applications 1 65 (13.24 %) MS Excel 2 46 (9.369 %) Spreadsheet 3 28 (5.703 %) MS Office 4 4 (0.815 %) MS PowerPoint 5 3 (0.611 %) MS Project 6 2 (0.407 %) Open Workbench 6 2 (0.407 %) CA Clarity 6 2 (0.407 %) MS Visio 7 1 (0.204 %) SPSS 7 1 (0.204 %) MATLAB	Business Applications 1 11 (2.240 %) Sophis RISQUE 2 5 (1.018 %) Summit 3 4 (0.815 %) Endur 4 2 (0.407 %) Findur 4 2 (0.407 %) Murex MxG2000 4 2 (0.407 %) Capstone 4 2 (0.407 %) Minerva 5 1 (0.204 %) Hyperion Enterprise 5 1 (0.204 %) InvestOne 5 1 (0.204 %) Oracle General Ledger 5 1 (0.204 %) SAP HR 5 1 (0.204 %) WebTrends 5 1 (0.204 %) Oracle Applications
Communications & Networking 1 2 (0.407 %) Internet 2 1 (0.204 %) Intranet	Database & Business Intelligence 1 82 (16.70 %) SQL Server 2 52 (10.59 %) MS Access 3 14 (2.851 %) Datawarehouse 4 12 (2.444 %) DTS 5 11 (2.240 %) Oracle Reports 6 10 (2.037 %) Oracle 9i 7 9 (1.833 %) SQL Server 2000 8 8 (1.629 %) SQL Server 2005 9 7 (1.426 %) SQL Server Integration Services 10 6 (1.222 %) Oracle Discoverer 11 5 (1.018 %) Crystal Reports 11 5 (1.018 %) Oracle OWB 12 4 (0.815 %) Microsoft Analysis Services 12 4 (0.815 %) OLAP 12 4 (0.815 %) Data Mining 13 3 (0.611 %) RDBMS 13 3 (0.611 %) Data Cleansing 14 2 (0.407 %) Reference Data 14 2 (0.407 %) SQL Server Reporting Services 14 2 (0.407 %) Data Mart
Development Applications 1 13 (2.648 %) Visual Studio 2 3 (0.611 %) VSS/SourceSafe 2 3 (0.611 %) Oracle APEX 3 2 (0.407 %) NUnit 4 1 (0.204 %) Subversion 4 1 (0.204 %) TestDirector 4 1 (0.204 %) QuickTest Pro 4 1 (0.204 %) LoadRunner 4 1 (0.204 %) WebLogic Workshop	General 1 199 (40.53 %) Banking 2 193 (39.31 %) Finance 3 163 (33.20 %) Front Office 4 140 (28.51 %) Investment Banking 5 13 (2.648 %) Insurance 6 12 (2.444 %) Back Office 7 11 (2.240 %) Education 8 8 (1.629 %) Financial Institution 9 6 (1.222 %) General Ledger 10 5 (1.018 %) Marketing 10 5 (1.018 %) Telecoms 11 3 (0.611 %) Government 11 3 (0.611 %) Private Banking 12 2 (0.407 %) Legal 13 1 (0.204 %) Games 13 1 (0.204 %) Health 13 1 (0.204 %) Law 13 1 (0.204 %) Electric 13 1 (0.204 %) Online Banking 13 1 (0.204 %) Graphic Design
Job Titles 1 302 (61.51 %) Developer 2 150 (30.55 %) Analyst 3 118 (24.03 %) VBA Developer 4 113 (23.01 %) Excel Developer 5 82 (16.70 %) Excel VBA Developer 6 47 (9.572 %) Access Developer 7 38 (7.739 %) C# Developer 8 37 (7.536 %) Business Analyst 9 27 (5.499 %) Excel Specialist 10 25 (5.092 %) Risk Analyst 11 24 (4.888 %) Support Analyst 12 23 (4.684 %) Sophis Developer 13 22 (4.481 %) Investment Banking Business Analyst 13 22 (4.481 %) Market Risk Analyst 14 20 (4.073 %) Programmer 15 19 (3.870 %) Data Analyst 15 19 (3.870 %) .NET Developer 16 18 (3.666 %) Oracle Developer 17 17 (3.462 %) C++ Developer 17 17 (3.462 %) Market Analyst	Miscellaneous 1 127 (25.87 %) Derivative 2 59 (12.02 %) Market Risk 3 50 (10.18 %) Equity Derivative 3 50 (10.18 %) Fixed Income 4 34 (6.925 %) Credit Derivative 5 27 (5.499 %) Foreign Exchange (FX) 6 18 (3.666 %) Credit Risk 7 12 (2.444 %) Interest Rate Derivative 8 11 (2.240 %) Mathematics 9 8 (1.629 %) Client/Server 9 8 (1.629 %) Grid Computing 9 8 (1.629 %) Equities 10 7 (1.426 %) STB 11 6 (1.222 %) Exotic Derivative 11 6 (1.222 %) Multithreading 11 6 (1.222 %) Computer Science 12 4 (0.815 %) French Language 12 4 (0.815 %) Management Information System 13 3 (0.611 %) Economics 13 3 (0.611 %) German Language
Operating Systems 1 42 (8.554 %) UNIX 2 27 (5.499 %) Windows 3 6 (1.222 %) Solaris 4 5 (1.018 %) Windows XP 5 1 (0.204 %) Linux	Processes & Methodologies 1 44 (8.961 %) RAD 2 39 (7.943 %) Risk Management 3 24 (4.888 %) Business Analysis 4 22 (4.481 %) User Acceptance Testing 5 18 (3.666 %) OO 6 16 (3.259 %) Data Analysis 6 16 (3.259 %) Stress Testing 7 13 (2.648 %) Investment Management 8 11 (2.240 %) Monte Carlo Method 9 10 (2.037 %) Asset Management 9 10 (2.037 %) Statistical Analysis 9 10 (2.037 %) Validation 9 10 (2.037 %) Migration 9 10 (2.037 %) Project Management 10 9 (1.833 %) Workflow 11 7 (1.426 %) OOD 12 6 (1.222 %) ITIL 13 5 (1.018 %) Business Intelligence 13 5 (1.018 %) Data Modelling 13 5 (1.018 %) Fund Management
Programming Languages 1 169 (34.42 %) SQL 2 128 (26.07 %) C# 3 108 (22.00 %) VB 4 70 (14.26 %) C++ 5 42 (8.554 %) Java 6 41 (8.350 %) VB6 7 28 (5.703 %) VB.NET 8 26 (5.295 %) Perl 9 21 (4.277 %) PL/SQL 10 19 (3.870 %) Transact-SQL 11 11 (2.240 %) Shell Script 12 10 (2.037 %) JavaScript 13 7 (1.426 %) C 14 6 (1.222 %) Korn 15 3 (0.611 %) VC++ 15 3 (0.611 %) Python 15 3 (0.611 %) DHTML 16 2 (0.407 %) VBScript 17 1 (0.204 %) PHP5 17 1 (0.204 %) PHP	Qualifications 1 45 (9.165 %) Degree 2 3 (0.611 %) MCP 2 3 (0.611 %) PhD 2 3 (0.611 %) Microsoft Certification 2 3 (0.611 %) ITIL Certification 3 2 (0.407 %) CISSP 3 2 (0.407 %) CISA 3 2 (0.407 %) CISM 4 1 (0.204 %) CIMA 4 1 (0.204 %) CFA 4 1 (0.204 %) Postgraduate 4 1 (0.204 %) MCSE 4 1 (0.204 %) ACCA 4 1 (0.204 %) PRINCE2 Certification
Quality Assurance & Compliance 1 7 (1.426 %) Sarbanes-Oxley 2 4 (0.815 %) Basel II 3 2 (0.407 %) SLA 4 1 (0.204 %) ISO17799 4 1 (0.204 %) ISO27001 4 1 (0.204 %) COBIT 4 1 (0.204 %) QA	System Software 1 1 (0.204 %) Active Directory
Systems Management 1 1 (0.204 %) OpenView 1 1 (0.204 %) AutoSys 1 1 (0.204 %) OVSD	Vendors 1 66 (13.44 %) Oracle 2 46 (9.369 %) Sybase 3 37 (7.536 %) Microsoft 4 27 (5.499 %) Bloomberg 5 25 (5.092 %) Reuters 6 23 (4.684 %) Sophis 7 13 (2.648 %) Murex 7 13 (2.648 %) Calypso 8 10 (2.037 %) TIBCO 9 8 (1.629 %) Fidessa 10 6 (1.222 %) OpenLink 10 6 (1.222 %) DataSynapse 11 5 (1.018 %) HP 12 2 (0.407 %) Citrix 12 2 (0.407 %) Actuate 12 2 (0.407 %) Cognos 12 2 (0.407 %) Business Objects 12 2 (0.407 %) Niku 12 2 (0.407 %) LatentZero 13 1 (0.204 %) ESRI