The first table below looks at the demand for Star Schema skills in IT contracts advertised for the London region. Included is a guide to the average contractor rates offered in IT contracts that have cited Star Schema over the 3 months to 18 April 2014 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 Database & Business Intelligence category for the London 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
18 Apr 2014
Same period 2013 Same period 2012
Star Schema
Rank 370 355 402
Rank change year-on-year
-15 +47
Contract jobs citing Star Schema 42 34 21
As % of all contract IT jobs located in London 0.17% 0.16% 0.075%
As % of the Database & Business Intelligence category 0.77% 0.71% 0.38%
Number of daily rates quoted 28 23 13
Average daily rate £410 £425 £500
Average daily rate % change year-on-year
-3.52% -15.00%
UK excluding London average daily rate £350 £370 £425
% change year-on-year
-5.40% -12.94%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate - - -
Database & Business Intelligence Category
London
Contract IT job ads with a match in the
Database & Business Intelligence category
5469 4756 5465
As % of all contract IT jobs located in London 22.60% 22.01% 19.50%
Number of daily rates quoted 3851 3335 3553
Average daily rate £425 £450 £425
Average daily rate % change year-on-year
-5.55% +5.88%
90% offered a daily rate of more than £295 £300 £300
10% offered a daily rate of more than £575 £575 £550
UK excluding London average daily rate £350 £330 £338
% change year-on-year
+6.06% -2.22%
Number of hourly rates quoted 25 28 30
Average hourly rate £31.00 £23.20 £29.50
Average hourly rate % change year-on-year
+33.62% -21.35%
90% offered a hourly rate of more than £22.35 £17.30 £16.74
10% offered a hourly rate of more than £78.25 £52.50 £49.02
UK excluding London average hourly rate £35.00 £28.00 £28.50
% change year-on-year
+25.00% -1.75%
Star Schema
England

Star Schema
Jobs Demand Trend in London

This chart provides a 3-month moving total of IT contractor jobs citing Star Schema across the London region as a proportion of the total demand within the Database & Business Intelligence category.

Star Schema Jobs Demand Trend in London

Star Schema
Daily Rate Trend in London

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

Star Schema Daily Rate Trend in London

Star Schema
Daily Rate Histogram in London

This chart provides a histogram of daily rates quoted in contract IT jobs citing Star Schema across the London region over the 3 months to 18 April 2014.

Star Schema Daily Rate Histogram in London

Star Schema
Hourly Rate Trend in London

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

Star Schema Hourly Rate Trend in London

Star Schema
Contract Job Locations in London

The table below looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing Star Schema within the London region over the 3 months to 18 April 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
(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
Find
Job
Vacancies
City of London -10 11 £438 +2.94% 1
Star Schema
England

Star Schema
Top 30 Related IT Skills in London

For the 6 months to 18 April 2014, IT contractor jobs across the London region citing Star Schema 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 Star Schema.

1 50 (79.37%) Data Warehouse
2 44 (69.84%) Business Intelligence
3 37 (58.73%) ETL
4 35 (55.56%) SQL
5 34 (53.97%) Oracle
6 32 (50.79%) Kimball Methodology
7 31 (49.21%) SQL Server
8 27 (42.86%) Data Modelling
9 25 (39.68%) SQL Server Analysis Services
10 24 (38.10%) Analytics
11 22 (34.92%) Inmon Methodology
11 22 (34.92%) SQL Server Integration Services
11 22 (34.92%) Agile Software Development
12 21 (33.33%) SQL Server 2008
13 20 (31.75%) Performance Tuning
14 18 (28.57%) SQL Server Reporting Services
14 18 (28.57%) Finance
15 17 (26.98%) Microsoft
16 16 (25.40%) T-SQL
17 15 (23.81%) Business Objects
17 15 (23.81%) Big Data
18 14 (22.22%) Oracle Database
18 14 (22.22%) OLAP
19 13 (20.63%) PL/SQL
19 13 (20.63%) MS Excel
19 13 (20.63%) Degree
20 12 (19.05%) Oracle Database 11g
21 10 (15.87%) Unit Testing
21 10 (15.87%) XML
22 9 (14.29%) Informatica

Star Schema
Top Related IT Skills in London by Category

For the 6 months to 18 April 2014, IT contractor jobs across the London region citing Star Schema 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 Star Schema. Up to 20 skills are shown per category.

Application Platforms
1 5 (7.94%) SharePoint
2 3 (4.76%) SharePoint 2010
3 1 (1.59%) WebLogic
Applications
1 13 (20.63%) MS Excel
2 8 (12.70%) PowerPivot
3 2 (3.17%) MS Office
Business Applications
1 1 (1.59%) Oracle EBS
1 1 (1.59%) Google Analytics
1 1 (1.59%) Oracle EBS R12
Communications & Networking
1 7 (11.11%) SAN
Database & Business Intelligence
1 50 (79.37%) Data Warehouse
2 31 (49.21%) SQL Server
3 25 (39.68%) SQL Server Analysis Services
4 22 (34.92%) SQL Server Integration Services
5 21 (33.33%) SQL Server 2008
6 18 (28.57%) SQL Server Reporting Services
7 15 (23.81%) Big Data
8 14 (22.22%) Oracle Database
8 14 (22.22%) OLAP
9 12 (19.05%) Oracle Database 11g
10 8 (12.70%) SQL Server 2012
10 8 (12.70%) Oracle OLAP
10 8 (12.70%) Microsoft Analysis Services
11 7 (11.11%) ProClarity
12 6 (9.52%) BusinessObjects XI
12 6 (9.52%) Data Mining
13 4 (6.35%) Relational Database
13 4 (6.35%) Oracle BI EE
13 4 (6.35%) Oracle Reports
13 4 (6.35%) RDBMS
Development Applications
1 5 (7.94%) ClearCase
2 4 (6.35%) Talend Open Studio
3 1 (1.59%) ERwin
3 1 (1.59%) Visual Studio
3 1 (1.59%) Team Foundation Server
3 1 (1.59%) Rational DOORS
General
1 18 (28.57%) Finance
2 7 (11.11%) Banking
3 5 (7.94%) Investment Banking
4 2 (3.17%) Marketing
4 2 (3.17%) Retail
4 2 (3.17%) Automotive
5 1 (1.59%) Telecoms
5 1 (1.59%) Manufacturing
5 1 (1.59%) Advertising
5 1 (1.59%) Financial Institution
5 1 (1.59%) Games
Job Titles
1 41 (65.08%) Developer
2 13 (20.63%) Business Intelligence Developer
3 10 (15.87%) Oracle Developer
4 9 (14.29%) ETL Developer
5 8 (12.70%) Architect
6 7 (11.11%) Business Developer
7 6 (9.52%) Analyst
7 6 (9.52%) Senior Developer
8 5 (7.94%) Consultant
8 5 (7.94%) SQL Developer
8 5 (7.94%) Microsoft Developer
9 4 (6.35%) Front-End Developer
9 4 (6.35%) Business Test Analyst
9 4 (6.35%) Business Intelligence Analyst
9 4 (6.35%) PL/SQL Developer
9 4 (6.35%) Test Analyst
9 4 (6.35%) Business Analyst
10 3 (4.76%) Business Objects Developer
10 3 (4.76%) Data Consultant
10 3 (4.76%) ETL Architect
Libraries, Frameworks & Software Standards
1 10 (15.87%) XML
2 7 (11.11%) MDX
3 6 (9.52%) .NET
4 3 (4.76%) SOAP
4 3 (4.76%) ASP.NET
5 1 (1.59%) Web Services
5 1 (1.59%) CSS
5 1 (1.59%) HTML
Miscellaneous
1 9 (14.29%) Computer Science
1 9 (14.29%) Data Integration
2 3 (4.76%) Freedom of Information
2 3 (4.76%) Data Protection Act
2 3 (4.76%) Freedom of Information Act
3 2 (3.17%) FMCG
4 1 (1.59%) Management Information System
4 1 (1.59%) Online Games
4 1 (1.59%) Reference Data
4 1 (1.59%) Data Conversion
4 1 (1.59%) Digital Media
Operating Systems
1 7 (11.11%) UNIX
2 5 (7.94%) Solaris
2 5 (7.94%) Linux
Processes & Methodologies
1 44 (69.84%) Business Intelligence
2 37 (58.73%) ETL
3 32 (50.79%) Kimball Methodology
4 27 (42.86%) Data Modelling
5 24 (38.10%) Analytics
6 22 (34.92%) Inmon Methodology
6 22 (34.92%) Agile Software Development
7 20 (31.75%) Performance Tuning
8 10 (15.87%) Unit Testing
9 9 (14.29%) Dimensional Modelling
10 6 (9.52%) Stakeholder Engagement
10 6 (9.52%) Migration
11 5 (7.94%) Data Architecture
12 4 (6.35%) Data Governance
12 4 (6.35%) Test Strategy
12 4 (6.35%) Waterfall
12 4 (6.35%) Data Protection
12 4 (6.35%) V-Model
12 4 (6.35%) Data Mapping
12 4 (6.35%) Database Tuning
Programming Languages
1 35 (55.56%) SQL
2 16 (25.40%) T-SQL
3 13 (20.63%) PL/SQL
4 3 (4.76%) Perl
4 3 (4.76%) VB.NET
5 1 (1.59%) Shell Script
5 1 (1.59%) C#
5 1 (1.59%) Java
5 1 (1.59%) Data Mining Extensions (DMX)
5 1 (1.59%) Data Analysis Expressions (DAX)
Qualifications
1 13 (20.63%) Degree
2 4 (6.35%) ISTQB
2 4 (6.35%) ISEB
Quality Assurance & Compliance
1 5 (7.94%) Data Quality
2 4 (6.35%) QA
3 1 (1.59%) PCI DSS
System Software
1 7 (11.11%) Active Directory
2 1 (1.59%) Oracle RAC
Systems Management
1 3 (4.76%) Control-M
Vendors
1 34 (53.97%) Oracle
2 17 (26.98%) Microsoft
3 15 (23.81%) Business Objects
4 9 (14.29%) Informatica
5 7 (11.11%) Lattice Semiconductor
6 6 (9.52%) Teradata
7 5 (7.94%) Cognos
8 4 (6.35%) Talend
9 3 (4.76%) Perforce
10 2 (3.17%) Greenplum
10 2 (3.17%) Ab Initio
10 2 (3.17%) Siebel
10 2 (3.17%) IBM
10 2 (3.17%) MicroStrategy
11 1 (1.59%) Mercator
11 1 (1.59%) Kalido
11 1 (1.59%) Google
11 1 (1.59%) Facebook