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 31 July 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
31 Jul 2016
Same period 2015 Same period 2014
Star Schema
Rank 396 408 405
Rank change year-on-year
+12 -3
Contract jobs citing Star Schema 38 24 35
As % of all contract IT jobs located in London 0.17% 0.10% 0.15%
As % of the Database & Business Intelligence category 0.76% 0.43% 0.63%
Number of daily rates quoted 28 17 30
Median daily rate £500 £415 £425
Median daily rate % change year-on-year
+20.48% -2.35%
90% offered a daily rate of more than £374 £380 £350
10% offered a daily rate of more than £650 £463 £488
UK excluding London median daily rate £400 £388 £305
% change year-on-year
+3.22% +27.04%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median 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
5009 5535 5522
As % of all contract IT jobs located in London 22.62% 23.58% 23.47%
Number of daily rates quoted 3614 3857 3740
Median daily rate £475 £450 £438
Median daily rate % change year-on-year
+5.55% +2.85%
90% offered a daily rate of more than £330 £308 £300
10% offered a daily rate of more than £615 £600 £600
UK excluding London median daily rate £375 £363 £350
% change year-on-year
+3.44% +3.57%
Number of hourly rates quoted 15 58 36
Median hourly rate £29.88 £27.78 £27.50
Median hourly rate % change year-on-year
+7.55% +1.01%
90% offered a hourly rate of more than £20.12 £16.50 £15.00
10% offered a hourly rate of more than £180.90 £52.17 £125.00
UK excluding London median hourly rate £28.50 £28.13 £28.50
% change year-on-year
+1.33% -1.31%

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 31 July 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 31 July 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 +37 2 £481 +16.66%
Croydon - 1 - -
Star Schema
England

Star Schema
Top 30 Related IT Skills in London

For the 6 months to 31 July 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 48 (70.59%) Data Warehouse
2 38 (55.88%) SQL
3 32 (47.06%) Data Modelling
3 32 (47.06%) Finance
4 29 (42.65%) ETL
5 26 (38.24%) Business Intelligence
6 23 (33.82%) Agile Software Development
7 20 (29.41%) Analytics
8 17 (25.00%) SQL Server
9 16 (23.53%) SQL Server Integration Services
10 14 (20.59%) Banking
10 14 (20.59%) Oracle
11 12 (17.65%) Cognos
11 12 (17.65%) Snowflake Schema
11 12 (17.65%) Kimball Methodology
11 12 (17.65%) Big Data
11 12 (17.65%) Logical Data Model
12 11 (16.18%) Relational Database
12 11 (16.18%) Market Risk
13 10 (14.71%) Hadoop
14 9 (13.24%) Data Analytics
14 9 (13.24%) Migration
14 9 (13.24%) Teradata
14 9 (13.24%) SQL Server Reporting Services
15 8 (11.76%) DataStage
15 8 (11.76%) Microsoft
15 8 (11.76%) MS Excel
15 8 (11.76%) OLAP
16 7 (10.29%) BusinessObjects
16 7 (10.29%) PowerDesigner

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 4 (5.88%) Apache Spark
2 1 (1.47%) Apache
2 1 (1.47%) Apache Pig
2 1 (1.47%) Confluence
2 1 (1.47%) Elasticsearch
2 1 (1.47%) Oracle Coherence
2 1 (1.47%) SharePoint
Applications
1 8 (11.76%) MS Excel
2 1 (1.47%) MS Office
2 1 (1.47%) MS PowerPoint
2 1 (1.47%) MS Visio
Business Applications
1 2 (2.94%) Cognos Business Intelligence
2 1 (1.47%) CODA-Financials
Cloud Services
1 2 (2.94%) Amazon AWS
2 1 (1.47%) GitHub
Database & Business Intelligence
1 48 (70.59%) Data Warehouse
2 17 (25.00%) SQL Server
3 16 (23.53%) SQL Server Integration Services
4 12 (17.65%) Big Data
4 12 (17.65%) Snowflake Schema
5 11 (16.18%) Relational Database
6 10 (14.71%) Hadoop
7 9 (13.24%) SQL Server Reporting Services
8 8 (11.76%) DataStage
8 8 (11.76%) OLAP
9 7 (10.29%) BusinessObjects
9 7 (10.29%) QlikView
9 7 (10.29%) SQL Server Analysis Services
10 6 (8.82%) RDBMS
11 5 (7.35%) Oracle OLAP
12 4 (5.88%) Cognos Framework Manager
12 4 (5.88%) Cognos Query Studio
12 4 (5.88%) Crystal Reports
12 4 (5.88%) MySQL
12 4 (5.88%) Oracle Database
Development Applications
1 7 (10.29%) PowerDesigner
2 3 (4.41%) Jenkins
2 3 (4.41%) Maven
2 3 (4.41%) Selenium
3 2 (2.94%) Cucumber
3 2 (2.94%) Git (software)
3 2 (2.94%) JIRA
4 1 (1.47%) Team Foundation Server
General
1 32 (47.06%) Finance
2 14 (20.59%) Banking
3 7 (10.29%) Investment Banking
4 5 (7.35%) Marketing
5 4 (5.88%) Law
6 2 (2.94%) Legal
6 2 (2.94%) Publishing
7 1 (1.47%) Back Office
7 1 (1.47%) Corporate Banking
7 1 (1.47%) Front Office
7 1 (1.47%) International Banking
Job Titles
1 29 (42.65%) Developer
2 12 (17.65%) Data Modeller
2 12 (17.65%) SQL Developer
3 11 (16.18%) Architect
4 9 (13.24%) Data Architect
5 7 (10.29%) Data Warehouse Developer
5 7 (10.29%) ETL Developer
6 6 (8.82%) Analyst
6 6 (8.82%) Business Intelligence Developer
7 4 (5.88%) Lead Developer
7 4 (5.88%) SSIS Developer
7 4 (5.88%) Tester
8 3 (4.41%) DataStage Developer
8 3 (4.41%) Finance Modeller
8 3 (4.41%) Oracle Developer
8 3 (4.41%) QA Tester
8 3 (4.41%) Senior Data Modeller
8 3 (4.41%) SQL BI Developer
8 3 (4.41%) SSRS Developer
9 2 (2.94%) MicroStrategy Developer
Libraries, Frameworks & Software Standards
1 4 (5.88%) XML
2 3 (4.41%) .NET
2 3 (4.41%) MDX
2 3 (4.41%) Web Services
3 2 (2.94%) .NET Framework
3 2 (2.94%) ASP.NET
3 2 (2.94%) ASP.NET MVC
3 2 (2.94%) JSON
4 1 (1.47%) AngularJS
4 1 (1.47%) HTML
4 1 (1.47%) JDBC
4 1 (1.47%) Kafka
4 1 (1.47%) ODBC
4 1 (1.47%) REST
4 1 (1.47%) RESTful
4 1 (1.47%) WSDL
4 1 (1.47%) XML Schema
4 1 (1.47%) XSD
Miscellaneous
1 11 (16.18%) Market Risk
2 6 (8.82%) Credit Risk
3 5 (7.35%) Data Integration
4 4 (5.88%) Analytical Skills
4 4 (5.88%) Visualisation
5 3 (4.41%) Computer Science
5 3 (4.41%) Data Structures
5 3 (4.41%) Management Information System
6 2 (2.94%) Credit Derivative
6 2 (2.94%) Derivative
6 2 (2.94%) Fixed Income
7 1 (1.47%) Blog
7 1 (1.47%) Clustering
7 1 (1.47%) Hedge funds
7 1 (1.47%) Mathematics
7 1 (1.47%) NHS
7 1 (1.47%) Ontologies
Operating Systems
1 3 (4.41%) Linux
2 2 (2.94%) Android
2 2 (2.94%) Apple iOS
2 2 (2.94%) Windows
Processes & Methodologies
1 32 (47.06%) Data Modelling
2 29 (42.65%) ETL
3 26 (38.24%) Business Intelligence
4 23 (33.82%) Agile Software Development
5 20 (29.41%) Analytics
6 12 (17.65%) Kimball Methodology
6 12 (17.65%) Logical Data Model
7 9 (13.24%) Data Analytics
7 9 (13.24%) Migration
8 6 (8.82%) Data Management
8 6 (8.82%) Requirements Analysis
8 6 (8.82%) Stakeholder Management
9 5 (7.35%) Data Architecture
9 5 (7.35%) Data Migration
9 5 (7.35%) Project Management
9 5 (7.35%) Risk Management
10 4 (5.88%) Business Analysis
10 4 (5.88%) Data Reconciliation
10 4 (5.88%) Scrum
10 4 (5.88%) Workflow
Programming Languages
1 38 (55.88%) SQL
2 6 (8.82%) Java
3 5 (7.35%) T-SQL
4 3 (4.41%) Python
5 2 (2.94%) ANSI SQL
5 2 (2.94%) Bash Shell
5 2 (2.94%) C#
5 2 (2.94%) PL/SQL
6 1 (1.47%) Data Analysis Expressions (DAX)
6 1 (1.47%) JavaScript
6 1 (1.47%) R
6 1 (1.47%) Scala
6 1 (1.47%) SPARQL
Qualifications
1 5 (7.35%) Degree
2 3 (4.41%) Security Cleared
3 2 (2.94%) DV Cleared
3 2 (2.94%) ISEB
3 2 (2.94%) ISTQB
4 1 (1.47%) MCITP
4 1 (1.47%) Microsoft Certification
4 1 (1.47%) SC Cleared
Quality Assurance & Compliance
1 5 (7.35%) Data Quality
1 5 (7.35%) QA
2 1 (1.47%) Disclosure Scotland
System Software
1 1 (1.47%) VMware Infrastructure
1 1 (1.47%) Xen
Systems Management
1 3 (4.41%) Control-M
2 1 (1.47%) HP Quality Center
2 1 (1.47%) Microsoft Intune
Vendors
1 14 (20.59%) Oracle
2 12 (17.65%) Cognos
3 9 (13.24%) Teradata
4 8 (11.76%) Microsoft
5 5 (7.35%) IBM
5 5 (7.35%) Informatica
6 4 (5.88%) Tableau
7 2 (2.94%) Actuate
7 2 (2.94%) Chordiant
7 2 (2.94%) MicroStrategy
7 2 (2.94%) Vertica
8 1 (1.47%) Citrix
8 1 (1.47%) Cloudera
8 1 (1.47%) CODA
8 1 (1.47%) Hortonworks
8 1 (1.47%) MapR
8 1 (1.47%) Remedy
8 1 (1.47%) VMware