The table below looks at the statistics 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 4 September 2015 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
4 Sep 2015
Same period 2014 Same period 2013
Star Schema
Rank 383 379 377
Rank change year-on-year
-4 -2
Contract jobs citing Star Schema 30 41 51
As % of all contract IT jobs located in London 0.13% 0.17% 0.21%
As % of the Database & Business Intelligence category 0.53% 0.74% 0.89%
Number of daily rates quoted 24 34 34
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£425 £423 £399
Average daily rate % change year-on-year
+0.59% +5.95%
90% offered a daily rate of more than £329 £375 £324
10% offered a daily rate of more than £519 £488 £500
UK excluding London average daily rate £369 £305 £394
% change year-on-year
+20.90% -22.53%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate £57.75 - -
Star Schema
England

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in contract jobs advertised in the London region.

Database & Business Intelligence Category
London
Contract IT job ads with a match in the
Database & Business Intelligence category
5614 5519 5725
As % of all contract IT jobs located in London 23.69% 23.05% 23.16%
Number of daily rates quoted 3974 3723 3942
Average daily rate £450 £445 £430
Average daily rate % change year-on-year
+1.12% +3.48%
90% offered a daily rate of more than £325 £300 £300
10% offered a daily rate of more than £600 £600 £575
UK excluding London average daily rate £375 £350 £350
% change year-on-year
+7.14% -
Number of hourly rates quoted 36 42 38
Average hourly rate £27.78 £29.00 £25.00
Average hourly rate % change year-on-year
-4.20% +16.00%
90% offered a hourly rate of more than £14.60 £15.00 £17.00
10% offered a hourly rate of more than £48.59 £53.00 £59.87
UK excluding London average hourly rate £33.55 £31.80 £32.50
% change year-on-year
+5.51% -2.16%

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 4 September 2015.

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 4 September 2015. 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
City of London +12 9 £418 -1.76% 2
Uxbridge +8 3 £325 -27.77% 1
Star Schema
England

Star Schema
Top 30 Related IT Skills in London

For the 6 months to 4 September 2015, 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 61 (82.43%) ETL
2 54 (72.97%) SQL
3 53 (71.62%) Data Warehouse
4 50 (67.57%) SQL Server
5 44 (59.46%) SQL Server Integration Services
6 36 (48.65%) Finance
7 34 (45.95%) Agile Software Development
8 31 (41.89%) Business Intelligence
9 29 (39.19%) Data Modelling
9 29 (39.19%) T-SQL
10 28 (37.84%) SQL Server Reporting Services
11 26 (35.14%) SQL Server Analysis Services
12 22 (29.73%) Kimball Methodology
13 19 (25.68%) Performance Tuning
13 19 (25.68%) Analytical Skills
14 15 (20.27%) Microsoft
14 15 (20.27%) MS Excel
14 15 (20.27%) SQL Server 2012
14 15 (20.27%) Greenplum
15 14 (18.92%) Unit Testing
16 13 (17.57%) SQL Server 2008
17 12 (16.22%) BusinessObjects
18 11 (14.86%) Data Mapping
19 10 (13.51%) Big Data
19 10 (13.51%) Inmon Methodology
19 10 (13.51%) XML
19 10 (13.51%) Data Analysis
19 10 (13.51%) Degree
20 9 (12.16%) MDX
20 9 (12.16%) Requirements Analysis

Star Schema
Top Related IT Skills in London by Category

For the 6 months to 4 September 2015, 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 3 (4.05%) SharePoint
2 2 (2.70%) SAS
Applications
1 15 (20.27%) MS Excel
2 7 (9.46%) PowerPivot
3 3 (4.05%) MS Visio
3 3 (4.05%) MS PowerPoint
4 2 (2.70%) MS Office
Business Applications
1 2 (2.70%) Dynamics NAV
1 2 (2.70%) Dynamics CRM
2 1 (1.35%) Oracle Financials
Database & Business Intelligence
1 53 (71.62%) Data Warehouse
2 50 (67.57%) SQL Server
3 44 (59.46%) SQL Server Integration Services
4 28 (37.84%) SQL Server Reporting Services
5 26 (35.14%) SQL Server Analysis Services
6 15 (20.27%) SQL Server 2012
7 13 (17.57%) SQL Server 2008
8 12 (16.22%) BusinessObjects
9 10 (13.51%) Big Data
10 9 (12.16%) Data Mart
10 9 (12.16%) OLAP
10 9 (12.16%) Relational Database
11 8 (10.81%) Crystal Reports
11 8 (10.81%) BusinessObjects XI
12 7 (9.46%) RDBMS
12 7 (9.46%) Microsoft Power View
13 6 (8.11%) BusinessObjects Web Intelligence
13 6 (8.11%) QlikView
14 5 (6.76%) SAP Data Services
14 5 (6.76%) MOLAP
Development Applications
1 5 (6.76%) JIRA
1 5 (6.76%) Team Foundation Server
2 3 (4.05%) TestDirector
3 1 (1.35%) ProC
3 1 (1.35%) Subversion
3 1 (1.35%) SQL Server Management Studio (SSMS)
3 1 (1.35%) Visual Studio
General
1 36 (48.65%) Finance
2 6 (8.11%) Banking
3 5 (6.76%) Retail
4 3 (4.05%) Law
4 3 (4.05%) Marketing
5 2 (2.70%) Advertising
5 2 (2.70%) Publishing
6 1 (1.35%) Billing
6 1 (1.35%) Investment Banking
6 1 (1.35%) German Language
6 1 (1.35%) Financial Institution
Job Titles
1 47 (63.51%) Developer
2 18 (24.32%) Analyst
2 18 (24.32%) ETL Developer
3 13 (17.57%) SQL Developer
4 11 (14.86%) Architect
5 10 (13.51%) Data Architect
6 9 (12.16%) Business Intelligence Developer
7 6 (8.11%) Consultant
8 5 (6.76%) Senior Developer
8 5 (6.76%) Microsoft Developer
8 5 (6.76%) Business Objects Developer
8 5 (6.76%) Analyst Developer
9 4 (5.41%) Data Analyst
9 4 (5.41%) Business Developer
10 3 (4.05%) Test Analyst
10 3 (4.05%) Data Warehouse Architect
10 3 (4.05%) MI Analyst
10 3 (4.05%) ETL Consultant
10 3 (4.05%) Designer
10 3 (4.05%) QlikView Developer
Libraries, Frameworks & Software Standards
1 10 (13.51%) XML
2 9 (12.16%) MDX
3 8 (10.81%) .NET
4 2 (2.70%) Middleware
5 1 (1.35%) WinForms
5 1 (1.35%) Web Services
5 1 (1.35%) WCF
Miscellaneous
1 19 (25.68%) Analytical Skills
2 9 (12.16%) Computer Science
3 3 (4.05%) Data Integration
3 3 (4.05%) Management Information System
4 2 (2.70%) Tandem
5 1 (1.35%) Economics
5 1 (1.35%) Statistics
5 1 (1.35%) Mathematics
5 1 (1.35%) Applied Mathematics
5 1 (1.35%) FMCG
5 1 (1.35%) Visualisation
5 1 (1.35%) Digital Media
5 1 (1.35%) Data Structures
5 1 (1.35%) Algorithms
Operating Systems
1 2 (2.70%) UNIX
2 1 (1.35%) Windows
Processes & Methodologies
1 61 (82.43%) ETL
2 34 (45.95%) Agile Software Development
3 31 (41.89%) Business Intelligence
4 29 (39.19%) Data Modelling
5 22 (29.73%) Kimball Methodology
6 19 (25.68%) Performance Tuning
7 14 (18.92%) Unit Testing
8 11 (14.86%) Data Mapping
9 10 (13.51%) Data Analysis
9 10 (13.51%) Inmon Methodology
10 9 (12.16%) ETL Development
10 9 (12.16%) Requirements Analysis
11 7 (9.46%) Data Management
12 6 (8.11%) Regression Testing
12 6 (8.11%) Technical Analysis
12 6 (8.11%) Master Data Management
13 5 (6.76%) Analytics
13 5 (6.76%) Logical Data Model
13 5 (6.76%) Physical Data Model
13 5 (6.76%) Configuration Management
Programming Languages
1 54 (72.97%) SQL
2 29 (39.19%) T-SQL
3 9 (12.16%) Python
4 4 (5.41%) Data Analysis Expressions (DAX)
5 3 (4.05%) C#
6 2 (2.70%) PL/SQL
6 2 (2.70%) Shell Script
7 1 (1.35%) Bash Shell
7 1 (1.35%) VB
7 1 (1.35%) VB.NET
7 1 (1.35%) ANSI SQL
Qualifications
1 10 (13.51%) Degree
2 9 (12.16%) SC Cleared
2 9 (12.16%) Security Cleared
3 4 (5.41%) DV Cleared
4 3 (4.05%) ISEB
4 3 (4.05%) ISTQB
4 3 (4.05%) ISTQB Foundation Certification
5 1 (1.35%) PhD
Quality Assurance & Compliance
1 3 (4.05%) QA
1 3 (4.05%) Data Quality
Vendors
1 15 (20.27%) Microsoft
1 15 (20.27%) Greenplum
2 7 (9.46%) Teradata
2 7 (9.46%) Netezza
3 6 (8.11%) Oracle
3 6 (8.11%) Cognos
3 6 (8.11%) Vertica
4 5 (6.76%) Informatica
5 3 (4.05%) IBM
6 1 (1.35%) Sun
6 1 (1.35%) Google
6 1 (1.35%) Nintex
6 1 (1.35%) WorldPay
6 1 (1.35%) Tableau
London
Hydrogen Group
Rate: £500.00 - £600.00 per day
Posted: 2 days ago
City of London
Venturi
Rate: £400 - £435 per day
Posted: 10 days ago
Uxbridge
Ampersand Consulting
Rate: £300 per day
Posted: 17 days ago
London
Lawrence Harvey
Rate: £0.00 - £1 per day + Negotiable
Posted: 18 days ago
London
Ampersand Consulting
Rate: £380 - £500 per day
Posted: 24 days ago