City of London Datawarehouse Contracts

This section looks at the demand for Data Warehouse (Data Warehousing) skills within the City of London region with a comparison to our Database & Business Intelligence category. Included is a guide to the contractor rates offered in IT job ads that have cited Datawarehouse over the 3 months to 4 July 2008 with a comparison to the same period last year.

Data Warehouse (Data Warehousing)
Location Basildon Belfast Berkshire Birmingham Bolton Bootle Bournemouth Bracknell Bradford Brentwood Bristol Buckinghamshire Camberley Cambridge Cambridgeshire Canary Wharf Cardiff Chatham Cheshire Chester Chesterfield City of London County Antrim Coventry Croydon Darlington Derby Derbyshire Docklands, London Dorset Dudley Durham East Anglia East Midlands East of England East Sussex Edinburgh England Essex Farnborough Feltham Folkestone Glasgow Gloucestershire Guildford Halifax Hammersmith Hampshire Hertfordshire High Wycombe Ipswich Johnstone Kent Lancashire Leeds Leicestershire Lincoln Lincolnshire London Maidenhead Manchester Merseyside Middlesex Midlands Milton Keynes Newcastle Newcastle Upon Tyne Newton-le-Willows Norfolk North East North West North Yorkshire Northampton Northamptonshire Northern Ireland Norwich Nottingham Nottinghamshire Oldham Oxford Oxfordshire Peterborough Preston Reading Renfrewshire Salisbury Scotland Sheffield Slough South Coast South East South Wales South West South Yorkshire Southampton Southwark Stafford Staffordshire Staines Strathclyde Suffolk Sunderland Surrey Swansea Swindon Tadworth Thames Valley Trowbridge Tyne and Wear UK Uxbridge Wales Walton-on-Thames Warwick Warwickshire Watford West Midlands West Sussex West Wales West Yorkshire Westminster Weybridge Wiltshire Wirral Wymondham Yorkshire	3 months to 4 Jul 2008	Same period last year
Rank	71	50
Rank change on same period last year	-21
Matching contract IT job ads	193	226
As % of all UK contract IT job ads sampled	0.254 %	0.240 %
As % of the category below	10.80 %	16.14 %
Daily rates quoted	119	105
Average minimum daily rate	£450	£450
Average daily rate	£492	£479
% change on same period last year	+2.75 %
Average maximum daily rate	£534	£507
UK excluding London average daily rate	£386	£388
% change on same period last year	-0.68 %
Hourly rates quoted	0	1
Average minimum hourly rate	-	£42.00
Average hourly rate	-	£46.00
% change on same period last year	-
Average maximum hourly rate	-	£50.00
UK excluding London average hourly rate	£34.74	£33.09
% change on same period last year	+4.99 %
Database & Business Intelligence City of London
Matching contract IT job ads	1787	1400
As % of all UK contract IT job ads sampled	2.356 %	1.485 %
Daily rates quoted	1007	648
Average minimum daily rate	£405	£428
Average daily rate	£439	£462
% change on same period last year	-4.97 %
Average maximum daily rate	£472	£495
UK excluding London average daily rate	£350	£354
% change on same period last year	-1.12 %
Hourly rates quoted	45	29
Average minimum hourly rate	£31.39	£22.13
Average hourly rate	£33.72	£24.16
% change on same period last year	+39.57 %
Average maximum hourly rate	£36.05	£26.19
UK excluding London average hourly rate	£32.43	£30.86
% change on same period last year	+5.09 %
Datawarehouse 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.

Datawarehouse
Demand Trend

The chart provides a 3-month moving total beginning in 2004 of IT contractor jobs citing Datawarehouse across the City of London region as a proportion of the total demand within the Database & Business Intelligence category.

Datawarehouse
Daily Rate Trend

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

Datawarehouse
Daily Rate Histogram

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

Datawarehouse
Hourly Rate Trend

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

Datawarehouse
Top 30 Related IT Skills

For the 6 months to 4 July 2008, IT contractor jobs across the City of London region citing Datawarehouse 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 Datawarehouse.

1 215 (57.18 %) Oracle 2 193 (51.33 %) SQL 3 159 (42.29 %) Banking 4 143 (38.03 %) Finance 5 104 (27.66 %) Investment Banking 6 84 (22.34 %) Business Objects 6 84 (22.34 %) BusinessObjects 7 82 (21.81 %) PL/SQL 8 76 (20.21 %) ETL 9 71 (18.88 %) SQL Server 10 67 (17.82 %) Oracle 10g 11 60 (15.96 %) Data Modelling 12 59 (15.69 %) Business Intelligence 13 52 (13.83 %) Sybase 13 52 (13.83 %) Unix

14 44 (11.70 %) Oracle Reports 15 43 (11.44 %) Oracle 9i 16 40 (10.64 %) Oracle OWB 17 34 (9.043 %) Migration 17 34 (9.043 %) Cognos 18 32 (8.511 %) Informatica 18 32 (8.511 %) SQL Server 2005 19 29 (7.713 %) XML 20 28 (7.447 %) Java 20 28 (7.447 %) Front Office 21 24 (6.383 %) VBA 21 24 (6.383 %) .NET 22 23 (6.117 %) Transact-SQL 22 23 (6.117 %) Oracle Discoverer 22 23 (6.117 %) SQL Server 2000

Datawarehouse
Top Related IT Skills by Category

For the 6 months to 4 July 2008, IT contractor jobs across the City of London region citing Datawarehouse 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 Datawarehouse. Up to 20 skills are shown per category.

Application Development 1 29 (7.713 %) XML 2 24 (6.383 %) .NET 3 20 (5.319 %) HTML 4 13 (3.457 %) ASP.NET 5 8 (2.128 %) ASP 5 8 (2.128 %) XSL 6 7 (1.862 %) MDX 7 5 (1.330 %) XSLT 8 4 (1.064 %) J2EE 9 3 (0.798 %) CSS 9 3 (0.798 %) WebSphere 9 3 (0.798 %) Spring 10 2 (0.532 %) Hibernate 10 2 (0.532 %) WinForms 10 2 (0.532 %) ASP.NET 2.0 10 2 (0.532 %) WebServices 10 2 (0.532 %) JSP 10 2 (0.532 %) JMS 10 2 (0.532 %) XSD 10 2 (0.532 %) Middleware	Application Platforms 1 7 (1.862 %) WebLogic 2 4 (1.064 %) SAS 3 3 (0.798 %) Tomcat 3 3 (0.798 %) Oracle Workflow 4 2 (0.532 %) Mule 4 2 (0.532 %) SharePoint 5 1 (0.266 %) NetWeaver 5 1 (0.266 %) Lotus Notes 5 1 (0.266 %) Lotus Domino 5 1 (0.266 %) Apache 5 1 (0.266 %) Oracle Spatial 5 1 (0.266 %) Oracle BPEL
Applications 1 11 (2.926 %) MS Office 1 11 (2.926 %) MS Excel 2 9 (2.394 %) MS Visio 3 1 (0.266 %) MS Project	Business Applications 1 4 (1.064 %) Oracle Applications 1 4 (1.064 %) Loan IQ 1 4 (1.064 %) Cognos Business Intelligence 2 2 (0.532 %) Siebel Analytics 2 2 (0.532 %) Oracle Financials 3 1 (0.266 %) HiPortfolio 3 1 (0.266 %) Cognos Planning 3 1 (0.266 %) Unica Affinium
Communications & Networking 1 4 (1.064 %) Internet 2 3 (0.798 %) Intranet 3 2 (0.532 %) SAN 3 2 (0.532 %) LDAP 4 1 (0.266 %) LAN 4 1 (0.266 %) SMS 4 1 (0.266 %) VoIP 4 1 (0.266 %) WAN 4 1 (0.266 %) DHCP 4 1 (0.266 %) DNS	Database & Business Intelligence 1 84 (22.34 %) BusinessObjects 2 76 (20.21 %) ETL 3 71 (18.88 %) SQL Server 4 67 (17.82 %) Oracle 10g 5 44 (11.70 %) Oracle Reports 6 43 (11.44 %) Oracle 9i 7 40 (10.64 %) Oracle OWB 8 32 (8.511 %) SQL Server 2005 9 23 (6.117 %) SQL Server 2000 9 23 (6.117 %) Oracle Discoverer 10 22 (5.851 %) OLAP 10 22 (5.851 %) SQL Server Analysis Services 11 20 (5.319 %) Star Schema 12 19 (5.053 %) RDBMS 13 17 (4.521 %) Microsoft Analysis Services 14 14 (3.723 %) Oracle 8/8i 14 14 (3.723 %) Oracle OLAP 14 14 (3.723 %) BusinessObjects XI 15 12 (3.191 %) BusinessObjects Web Intelligence 15 12 (3.191 %) DTS
Development Applications 1 11 (2.926 %) ERwin 2 8 (2.128 %) QuickTest Pro 3 7 (1.862 %) TestDirector 4 4 (1.064 %) Oracle Forms 4 4 (1.064 %) AllFusion 4 4 (1.064 %) Oracle APEX 5 3 (0.798 %) ClearQuest 5 3 (0.798 %) LoadRunner 6 2 (0.532 %) WinRunner 6 2 (0.532 %) JUnit 6 2 (0.532 %) VSS/SourceSafe 6 2 (0.532 %) CruiseControl 6 2 (0.532 %) Subversion 6 2 (0.532 %) PowerDesigner 7 1 (0.266 %) PowerBuilder 7 1 (0.266 %) Ant	General 1 159 (42.29 %) Banking 2 143 (38.03 %) Finance 3 104 (27.66 %) Investment Banking 4 28 (7.447 %) Front Office 5 23 (6.117 %) Insurance 6 11 (2.926 %) General Ledger 7 7 (1.862 %) Back Office 7 7 (1.862 %) Telecoms 8 6 (1.596 %) Retail 8 6 (1.596 %) Corporate Banking 9 5 (1.330 %) Government 10 4 (1.064 %) Financial Institution 11 3 (0.798 %) Marketing 11 3 (0.798 %) Legal 12 1 (0.266 %) Publishing 12 1 (0.266 %) Pensions 12 1 (0.266 %) Wholesale Banking 12 1 (0.266 %) Retail Banking 12 1 (0.266 %) Multimedia 12 1 (0.266 %) Billing
Job Titles 1 174 (46.28 %) Developer 2 113 (30.05 %) Analyst 3 62 (16.49 %) Oracle Developer 4 56 (14.89 %) Business Analyst 5 42 (11.17 %) Architect 6 32 (8.511 %) SQL Developer 7 23 (6.117 %) Datawarehouse Developer 8 17 (4.521 %) SQL Server Developer 8 17 (4.521 %) Cognos Developer 9 16 (4.255 %) Data Analyst 10 15 (3.989 %) Project Manager 11 14 (3.723 %) DBA 11 14 (3.723 %) Analyst Developer 11 14 (3.723 %) Datawarehouse Analyst 12 13 (3.457 %) Business Intelligence Developer 12 13 (3.457 %) Test Analyst 13 12 (3.191 %) Database Developer 14 11 (2.926 %) Senior Developer 15 10 (2.660 %) Business Developer 16 9 (2.394 %) Consultant	Miscellaneous 1 21 (5.585 %) Management Information System 2 17 (4.521 %) Credit Risk 3 15 (3.989 %) Derivative 4 14 (3.723 %) Asset Management 5 12 (3.191 %) Fixed Income 6 10 (2.660 %) Equities 6 10 (2.660 %) Data Integration 7 9 (2.394 %) Market Risk 8 7 (1.862 %) Equity Derivative 8 7 (1.862 %) Foreign Exchange (FX) 9 5 (1.330 %) Interest Rate Derivative 10 2 (0.532 %) Replication 10 2 (0.532 %) Computer Science 11 1 (0.266 %) French Language 11 1 (0.266 %) Fund Management 11 1 (0.266 %) Fat Client 11 1 (0.266 %) Data Conversion 11 1 (0.266 %) Clustering 11 1 (0.266 %) NHS 11 1 (0.266 %) Thin Client
Operating Systems 1 52 (13.83 %) Unix 2 14 (3.723 %) Windows 3 9 (2.394 %) Linux 4 3 (0.798 %) AIX 4 3 (0.798 %) Solaris 5 2 (0.532 %) Windows NT 6 1 (0.266 %) Windows XP 6 1 (0.266 %) MVS 6 1 (0.266 %) Windows Server 2003 6 1 (0.266 %) Windows 2000	Processes & Methodologies 1 60 (15.96 %) Data Modelling 2 59 (15.69 %) Business Intelligence 3 34 (9.043 %) Migration 4 21 (5.585 %) Data Analysis 5 20 (5.319 %) Project Management 5 20 (5.319 %) UML 6 18 (4.787 %) Business Analysis 7 17 (4.521 %) Data Migration 8 11 (2.926 %) System Testing 8 11 (2.926 %) Risk Management 9 9 (2.394 %) Agile Software Development 10 8 (2.128 %) Workflow 10 8 (2.128 %) Investment Management 10 8 (2.128 %) Web Development 10 8 (2.128 %) Load Balancing 11 7 (1.862 %) Test Management 11 7 (1.862 %) Dimensional Modelling 11 7 (1.862 %) CRM 11 7 (1.862 %) PRINCE2 12 6 (1.596 %) Data Mapping
Programming Languages 1 193 (51.33 %) SQL 2 82 (21.81 %) PL/SQL 3 28 (7.447 %) Java 4 24 (6.383 %) VBA 5 23 (6.117 %) Transact-SQL 6 21 (5.585 %) C# 7 14 (3.723 %) VB 7 14 (3.723 %) Shell Script 8 13 (3.457 %) Perl 9 5 (1.330 %) JavaScript 10 4 (1.064 %) DHTML 11 3 (0.798 %) C++ 11 3 (0.798 %) VB.NET 11 3 (0.798 %) VBScript 12 2 (0.532 %) Jython 12 2 (0.532 %) C 12 2 (0.532 %) VB6 13 1 (0.266 %) XPath 13 1 (0.266 %) Lingo 13 1 (0.266 %) MapBasic	Qualifications 1 8 (2.128 %) Degree 2 6 (1.596 %) ISEB 3 4 (1.064 %) ISTQB 4 2 (0.532 %) PRINCE2 Practitioner 5 1 (0.266 %) PRINCE2 Certification
Quality Assurance & Compliance 1 8 (2.128 %) Basel II 2 6 (1.596 %) QA 3 1 (0.266 %) IAS 39	System Software 1 12 (3.191 %) Oracle RAC 2 3 (0.798 %) Active Directory 3 1 (0.266 %) Backup Exec 3 1 (0.266 %) Oracle RMAN
Systems Management 1 9 (2.394 %) AutoSys 2 2 (0.532 %) Oracle Enterprise Manager	Vendors 1 215 (57.18 %) Oracle 2 84 (22.34 %) Business Objects 3 52 (13.83 %) Sybase 4 34 (9.043 %) Cognos 5 32 (8.511 %) Informatica 6 19 (5.053 %) Microsoft 7 11 (2.926 %) SAP 8 6 (1.596 %) Hyperion 9 4 (1.064 %) Siebel 9 4 (1.064 %) BEA 9 4 (1.064 %) Ascential 9 4 (1.064 %) Teradata 10 3 (0.798 %) Bloomberg 10 3 (0.798 %) ProClarity 11 2 (0.532 %) Remedy 11 2 (0.532 %) Actuate 11 2 (0.532 %) IBM 11 2 (0.532 %) Sun 11 2 (0.532 %) MicroStrategy 11 2 (0.532 %) Sagent