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 contractor rates offered in IT contracts that have cited Star Schema over the 3 months to 25 May 2016 with a comparison to the same period over 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.

3 months to
25 May 2016
Same period 2015 Same period 2014
Star Schema
Rank 393 366 373
Rank change year-on-year
-27 +7
Contract jobs citing Star Schema 24 51 43
As % of all contract IT jobs located in London 0.11% 0.23% 0.19%
As % of the Database & Business Intelligence category 0.47% 0.96% 0.82%
Number of daily rates quoted 20 31 29
Median daily rate £550 £425 £413
Median daily rate % change year-on-year
+29.41% +3.03%
90% offered a daily rate of more than £397 £398 £350
10% offered a daily rate of more than £675 £500 £453
UK excluding London median daily rate £425 £355 £375
% change year-on-year
+19.71% -5.33%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate - - -
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
5063 5297 5248
As % of all contract IT jobs located in London 23.30% 23.89% 23.18%
Number of daily rates quoted 3681 3697 3724
Median daily rate £475 £450 £425
Median daily rate % change year-on-year
+5.55% +5.88%
90% offered a daily rate of more than £325 £305 £300
10% offered a daily rate of more than £625 £600 £575
UK excluding London median daily rate £388 £370 £350
% change year-on-year
+4.72% +5.71%
Number of hourly rates quoted 30 43 26
Median hourly rate £27.50 £22.83 £27.50
Median hourly rate % change year-on-year
+20.45% -16.98%
90% offered a hourly rate of more than £17.43 £16.27 £11.20
10% offered a hourly rate of more than £59.40 £60.00 £125.00
UK excluding London median hourly rate £34.50 £25.00 £32.50
% change year-on-year
+38.00% -23.07%

Star Schema
Jobs Demand Trend in London

The demand trend of contract jobs across the London region citing Star Schema as a proportion of all IT contracts with a match in 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 25 May 2016.

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 median contractor rates quoted in IT jobs citing Star Schema within the London region over the 3 months to 25 May 2016. 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 see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
City of London +43 7 £625 +47.05% 4
Croydon - 1 £365 -
Star Schema
England

Star Schema
Top 30 Related IT Skills in London

For the 6 months to 25 May 2016, IT contractor jobs citing Star Schema also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the London region with a requirement for Star Schema.

1 41 (68.33%) SQL
1 41 (68.33%) Data Warehouse
2 37 (61.67%) Data Modelling
3 32 (53.33%) Finance
4 28 (46.67%) Business Intelligence
5 22 (36.67%) Agile Software Development
6 20 (33.33%) ETL
7 19 (31.67%) SQL Server
8 18 (30.00%) SQL Server Integration Services
9 13 (21.67%) Kimball Methodology
10 12 (20.00%) Logical Data Model
10 12 (20.00%) Banking
11 11 (18.33%) Market Risk
12 10 (16.67%) Snowflake Schema
12 10 (16.67%) Analytics
13 9 (15.00%) Big Data
13 9 (15.00%) Relational Database
14 8 (13.33%) Cognos
14 8 (13.33%) Oracle
14 8 (13.33%) SQL Server Reporting Services
15 7 (11.67%) Investment Banking
15 7 (11.67%) OLAP
15 7 (11.67%) PowerDesigner
15 7 (11.67%) SQL Server Analysis Services
16 6 (10.00%) Visualisation
16 6 (10.00%) Credit Risk
16 6 (10.00%) Analytical Skills
16 6 (10.00%) Microsoft
16 6 (10.00%) Requirements Analysis
16 6 (10.00%) Marketing

Star Schema
Top Related IT Skills in London by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 3 (5.00%) Apache
1 3 (5.00%) Apache Pig
2 1 (1.67%) Apache Spark
2 1 (1.67%) SAS
2 1 (1.67%) SharePoint
Applications
1 4 (6.67%) MS Excel
2 1 (1.67%) SPSS
Business Applications
1 1 (1.67%) CODA-Financials
1 1 (1.67%) Oracle Financials
1 1 (1.67%) SAP ERP
Cloud Services
1 1 (1.67%) Amazon AWS
Database & Business Intelligence
1 41 (68.33%) Data Warehouse
2 19 (31.67%) SQL Server
3 18 (30.00%) SQL Server Integration Services
4 10 (16.67%) Snowflake Schema
5 9 (15.00%) Big Data
5 9 (15.00%) Relational Database
6 8 (13.33%) SQL Server Reporting Services
7 7 (11.67%) OLAP
7 7 (11.67%) SQL Server Analysis Services
8 5 (8.33%) Oracle Database
9 4 (6.67%) Cognos Framework Manager
9 4 (6.67%) NoSQL
10 3 (5.00%) Apache Hive
10 3 (5.00%) Hadoop
10 3 (5.00%) HBase
10 3 (5.00%) Oracle BI EE
10 3 (5.00%) Oracle Database 11g
10 3 (5.00%) PowerPivot
10 3 (5.00%) SQL Server 2008
10 3 (5.00%) SQL Server 2012
Development Applications
1 7 (11.67%) PowerDesigner
2 1 (1.67%) ERwin
2 1 (1.67%) Team Foundation Server
General
1 32 (53.33%) Finance
2 12 (20.00%) Banking
3 7 (11.67%) Investment Banking
4 6 (10.00%) Marketing
5 3 (5.00%) Billing
5 3 (5.00%) Publishing
6 2 (3.33%) Front Office
6 2 (3.33%) International Banking
7 1 (1.67%) Law
Job Titles
1 28 (46.67%) Developer
2 16 (26.67%) Data Modeller
2 16 (26.67%) SQL Developer
3 10 (16.67%) Business Intelligence Developer
4 9 (15.00%) Architect
5 6 (10.00%) ETL Developer
6 5 (8.33%) Data Architect
6 5 (8.33%) SSIS Developer
7 4 (6.67%) SQL BI Developer
7 4 (6.67%) SSRS Developer
8 3 (5.00%) Finance Modeller
8 3 (5.00%) Microsoft Developer
8 3 (5.00%) Senior Data Modeller
8 3 (5.00%) SQL Server Developer
9 2 (3.33%) Analyst
9 2 (3.33%) Applications Architect
9 2 (3.33%) Business Developer
9 2 (3.33%) Data Warehouse Developer
9 2 (3.33%) Oracle Developer
9 2 (3.33%) SAP Developer
Libraries, Frameworks & Software Standards
1 5 (8.33%) .NET
2 4 (6.67%) .NET Framework
2 4 (6.67%) ASP.NET
2 4 (6.67%) ASP.NET MVC
2 4 (6.67%) MDX
3 2 (3.33%) AngularJS
3 2 (3.33%) HTML
3 2 (3.33%) JSON
3 2 (3.33%) RESTful
4 1 (1.67%) Kafka
4 1 (1.67%) Web Services
4 1 (1.67%) XML
4 1 (1.67%) XML Schema
Miscellaneous
1 11 (18.33%) Market Risk
2 6 (10.00%) Analytical Skills
2 6 (10.00%) Credit Risk
2 6 (10.00%) Visualisation
3 4 (6.67%) Management Information System
4 3 (5.00%) Data Integration
4 3 (5.00%) Data Structures
5 2 (3.33%) Computer Science
5 2 (3.33%) Credit Derivative
5 2 (3.33%) Derivative
5 2 (3.33%) Fixed Income
5 2 (3.33%) Mainframe
6 1 (1.67%) Digital Media
6 1 (1.67%) Hedge funds
6 1 (1.67%) Mathematics
6 1 (1.67%) New Media
6 1 (1.67%) Ontologies
Operating Systems
1 4 (6.67%) Windows
2 1 (1.67%) Unix
Processes & Methodologies
1 37 (61.67%) Data Modelling
2 28 (46.67%) Business Intelligence
3 22 (36.67%) Agile Software Development
4 20 (33.33%) ETL
5 13 (21.67%) Kimball Methodology
6 12 (20.00%) Logical Data Model
7 10 (16.67%) Analytics
8 6 (10.00%) Requirements Analysis
8 6 (10.00%) Stakeholder Management
9 5 (8.33%) Data Mapping
9 5 (8.33%) Project Management
9 5 (8.33%) Risk Management
10 4 (6.67%) Business Analysis
10 4 (6.67%) Data Management
10 4 (6.67%) Data Protection
10 4 (6.67%) Inmon Methodology
10 4 (6.67%) MVC
10 4 (6.67%) SDLC
10 4 (6.67%) Workflow
11 3 (5.00%) Data Analytics
Programming Languages
1 41 (68.33%) SQL
2 4 (6.67%) R
2 4 (6.67%) T-SQL
3 2 (3.33%) C#
3 2 (3.33%) JavaScript
4 1 (1.67%) Data Analysis Expressions (DAX)
4 1 (1.67%) Java
4 1 (1.67%) PL/SQL
4 1 (1.67%) Python
4 1 (1.67%) SPARQL
Qualifications
1 3 (5.00%) Degree
2 2 (3.33%) DV Cleared
2 2 (3.33%) Security Cleared
3 1 (1.67%) ISEB
3 1 (1.67%) ISTQB
3 1 (1.67%) MCITP
3 1 (1.67%) Microsoft Certification
Quality Assurance & Compliance
1 4 (6.67%) Data Quality
2 1 (1.67%) QA
Systems Management
1 1 (1.67%) HP Quality Center
Vendors
1 8 (13.33%) Cognos
1 8 (13.33%) Oracle
2 6 (10.00%) Microsoft
3 4 (6.67%) Guidewire
3 4 (6.67%) IBM
3 4 (6.67%) SAP
3 4 (6.67%) Tableau
4 3 (5.00%) Cloudera
4 3 (5.00%) Hortonworks
4 3 (5.00%) Informatica
4 3 (5.00%) MicroStrategy
5 1 (1.67%) Ab Initio
5 1 (1.67%) CODA
5 1 (1.67%) MapR
5 1 (1.67%) Teradata
5 1 (1.67%) WorldPay
City, London
Venturi
Rate: £350 - £425 per day
Posted: 6 days ago
London
FDM Group
Posted: 7 days ago
London
Vivid Resourcing
Posted: 21 days ago