The table below looks at the statistics for Star Schema skills in IT contracts advertised across the UK. Included is a guide to the contractor rates offered in IT contracts that have cited Star Schema over the 3 months to 2 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
2 Jul 2016
Same period 2015 Same period 2014
Star Schema
Rank 565 603 566
Rank change year-on-year
+38 -37
Contract jobs citing Star Schema 72 46 68
As % of all contract IT jobs located in the UK 0.13% 0.082% 0.13%
As % of the Database & Business Intelligence category 0.61% 0.35% 0.57%
Number of daily rates quoted 46 32 44
Median daily rate £438 £413 £408
Median daily rate % change year-on-year
+6.06% +1.22%
90% offered a daily rate of more than £370 £341 £258
10% offered a daily rate of more than £613 £460 £488
UK excluding London median daily rate £413 £250 £305
% change year-on-year
+65.00% -18.03%
Number of hourly rates quoted 0 1 0
Median hourly rate - £57.75 -
UK excluding London median hourly rate - £57.75 -

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

Database & Business Intelligence Category
UK
Contract IT job ads with a match in the
Database & Business Intelligence category
11712 13188 11972
As % of all contract IT jobs located in the UK 21.91% 23.55% 22.22%
Number of daily rates quoted 7899 8577 7450
Median daily rate £425 £400 £400
Median daily rate % change year-on-year
+6.25% -
90% offered a daily rate of more than £300 £275 £270
10% offered a daily rate of more than £575 £550 £550
UK excluding London median daily rate £375 £353 £350
% change year-on-year
+6.38% +0.71%
Number of hourly rates quoted 204 195 202
Median hourly rate £31.27 £27.78 £27.50
Median hourly rate % change year-on-year
+12.56% +1.01%
90% offered a hourly rate of more than £12.00 £16.00 £13.50
10% offered a hourly rate of more than £47.50 £52.17 £52.50
UK excluding London median hourly rate £31.59 £28.13 £28.50
% change year-on-year
+12.30% -1.31%

Star Schema
Jobs Demand Trend

The demand trend of contract jobs 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 the UK

Star Schema
Daily Rate Trend

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

Star Schema Daily Rate Trend in the UK

Star Schema
Daily Rate Histogram

This chart provides a histogram of daily rates quoted in contract IT jobs citing Star Schema within the UK over the 3 months to 2 July 2016.

Star Schema Daily Rate Histogram in the UK

Star Schema
Hourly Rate Trend

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

Star Schema Hourly Rate Trend in the UK

Star Schema
Top 28 Contract Locations

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 UK over the 3 months to 2 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
England +26 69 £450 +9.09% 6
London -9 27 £506 +22.72% 3
Yorkshire - 18 £400 - 1
South West +9 13 £639 +64.83%
Leeds - 11 £400 -
West Yorkshire - 11 £400 -
Wiltshire - 8 £638 -
North West 0 7 £450 +4.04% 1
North Yorkshire - 6 £388 - 1
Corsham - 6 £675 -
York - 6 £388 - 1
Manchester - 4 £450 -
Cardiff - 3 £375 -
Cheshire - 3 £506 -
Macclesfield - 3 £506 -
South Wales - 3 £375 -
Wales - 3 £375 -
City of London +38 2 £481 +14.92%
South East -2 2 £406 +103.12%
North East - 2 £325 -
Bradford - 2 - -
West Sussex - 2 £406 -
Gloucestershire -3 1 £638 +64.51%
Durham - 1 £325 -
South Yorkshire - 1 £288 -
Croydon - 1 - -
Doncaster - 1 £288 -
Crawley - 1 £388 -

Star Schema
Top 30 Related IT Skills

For the 6 months to 2 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 with a requirement for Star Schema.

1 88 (67.69%) Data Warehouse
2 83 (63.85%) Data Modelling
3 58 (44.62%) SQL
4 56 (43.08%) Finance
5 53 (40.77%) ETL
6 51 (39.23%) Agile Software Development
7 43 (33.08%) Business Intelligence
8 35 (26.92%) SQL Server
8 35 (26.92%) SQL Server Integration Services
9 33 (25.38%) Oracle
9 33 (25.38%) Kimball Methodology
10 23 (17.69%) SQL Server Reporting Services
11 22 (16.92%) SOA
11 22 (16.92%) BusinessObjects
12 21 (16.15%) Data Analysis
13 20 (15.38%) Scrum
14 19 (14.62%) Microsoft
14 19 (14.62%) Analytics
14 19 (14.62%) Data Structures
15 18 (13.85%) Logical Data Model
15 18 (13.85%) Migration
15 18 (13.85%) Banking
16 17 (13.08%) Data Quality
17 16 (12.31%) Data Management
17 16 (12.31%) Data Integration
17 16 (12.31%) Java
18 15 (11.54%) IBM
18 15 (11.54%) Amazon AWS
18 15 (11.54%) Amazon Redshift
18 15 (11.54%) Mentoring

Star Schema
Top Related IT Skills 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 8 (6.15%) Confluence
2 4 (3.08%) Apache Pig
2 4 (3.08%) Apache Spark
3 2 (1.54%) Apache
3 2 (1.54%) Skype for Business
4 1 (0.77%) Elasticsearch
4 1 (0.77%) Oracle Coherence
4 1 (0.77%) SAS
4 1 (0.77%) SharePoint
Applications
1 10 (7.69%) MS Excel
2 5 (3.85%) MS Office
3 3 (2.31%) Spreadsheet
4 1 (0.77%) MS PowerPoint
4 1 (0.77%) MS Visio
Business Applications
1 7 (5.38%) SAP MDM
2 4 (3.08%) SAP CRM
2 4 (3.08%) SAP hybris
3 2 (1.54%) Cognos Business Intelligence
4 1 (0.77%) CODA-Financials
4 1 (0.77%) Oracle Financials
4 1 (0.77%) SAP Oil and Gas
Cloud Services
1 15 (11.54%) Amazon AWS
2 11 (8.46%) Amazon Kinesis
2 11 (8.46%) Amazon S3
2 11 (8.46%) AWS Elastic Beanstalk
3 8 (6.15%) GitHub
4 7 (5.38%) Veeva
Database & Business Intelligence
1 88 (67.69%) Data Warehouse
2 35 (26.92%) SQL Server
2 35 (26.92%) SQL Server Integration Services
3 23 (17.69%) SQL Server Reporting Services
4 22 (16.92%) BusinessObjects
5 15 (11.54%) Amazon Redshift
6 14 (10.77%) Big Data
6 14 (10.77%) MySQL
6 14 (10.77%) PostgreSQL
7 13 (10.00%) Relational Database
7 13 (10.00%) Snowflake Schema
7 13 (10.00%) SQL Server Analysis Services
8 12 (9.23%) Oracle Database
9 10 (7.69%) OLAP
10 9 (6.92%) Hadoop
10 9 (6.92%) IBM InfoSphere
11 7 (5.38%) Oracle BI EE
11 7 (5.38%) Oracle Database 12c
12 6 (4.62%) DataStage
12 6 (4.62%) Oracle OLAP
Development Applications
1 13 (10.00%) ERwin
1 13 (10.00%) Talend Open Studio
2 11 (8.46%) Jenkins
2 11 (8.46%) JIRA
3 8 (6.15%) Maven
3 8 (6.15%) SQL Server Management Studio (SSMS)
3 8 (6.15%) Visual Studio
4 7 (5.38%) Oracle APEX
4 7 (5.38%) PowerDesigner
5 3 (2.31%) Cucumber
5 3 (2.31%) JUnit
5 3 (2.31%) PigUnit
5 3 (2.31%) PyUnit
5 3 (2.31%) RSpec
6 1 (0.77%) Team Foundation Server
General
1 56 (43.08%) Finance
2 18 (13.85%) Banking
3 7 (5.38%) Investment Banking
3 7 (5.38%) Marketing
4 6 (4.62%) Pharmaceutical
5 4 (3.08%) Law
6 3 (2.31%) Publishing
7 2 (1.54%) Front Office
7 2 (1.54%) International Banking
7 2 (1.54%) Legal
7 2 (1.54%) Retail
7 2 (1.54%) Retail Banking
8 1 (0.77%) Billing
8 1 (0.77%) Corporate Banking
8 1 (0.77%) Electronics
8 1 (0.77%) Manufacturing
8 1 (0.77%) Telecoms
Job Titles
1 57 (43.85%) Developer
2 26 (20.00%) Data Modeller
3 24 (18.46%) Architect
4 22 (16.92%) SQL Developer
5 21 (16.15%) Data Architect
6 20 (15.38%) Analyst
7 18 (13.85%) ETL Developer
8 13 (10.00%) Business Intelligence Developer
9 12 (9.23%) Data Analyst
10 11 (8.46%) Senior Developer
11 10 (7.69%) Senior Data Modeller
12 9 (6.92%) Data Warehouse Developer
12 9 (6.92%) Senior Analyst
12 9 (6.92%) Senior ETL Developer
13 8 (6.15%) SQL BI Developer
14 7 (5.38%) SSIS Developer
15 5 (3.85%) Applications Developer
15 5 (3.85%) Oracle Developer
15 5 (3.85%) Talend Developer
16 4 (3.08%) Business Analyst
Libraries, Frameworks & Software Standards
1 14 (10.77%) XML
2 13 (10.00%) Web Services
3 11 (8.46%) REST
3 11 (8.46%) WSDL
3 11 (8.46%) XSD
4 6 (4.62%) MDX
5 5 (3.85%) .NET
6 4 (3.08%) .NET Framework
6 4 (3.08%) ASP.NET
6 4 (3.08%) ASP.NET MVC
7 3 (2.31%) JSON
8 2 (1.54%) AngularJS
8 2 (1.54%) Apache Tez
8 2 (1.54%) HTML
8 2 (1.54%) RESTful
9 1 (0.77%) JDBC
9 1 (0.77%) Kafka
9 1 (0.77%) ODBC
9 1 (0.77%) XML Schema
Miscellaneous
1 19 (14.62%) Data Structures
2 16 (12.31%) Data Integration
3 11 (8.46%) Market Risk
4 10 (7.69%) Computer Science
5 9 (6.92%) Analytical Skills
5 9 (6.92%) Management Information System
6 7 (5.38%) Credit Risk
7 6 (4.62%) NHS
8 5 (3.85%) Visualisation
9 2 (1.54%) Credit Derivative
9 2 (1.54%) Derivative
9 2 (1.54%) Fixed Income
9 2 (1.54%) Freedom of Information
10 1 (0.77%) Blog
10 1 (0.77%) Clustering
10 1 (0.77%) Hedge funds
10 1 (0.77%) Mathematics
10 1 (0.77%) Ontologies
10 1 (0.77%) Statistics
Operating Systems
1 4 (3.08%) Windows
2 2 (1.54%) Linux
3 1 (0.77%) Unix
Processes & Methodologies
1 83 (63.85%) Data Modelling
2 53 (40.77%) ETL
3 51 (39.23%) Agile Software Development
4 43 (33.08%) Business Intelligence
5 33 (25.38%) Kimball Methodology
6 22 (16.92%) SOA
7 21 (16.15%) Data Analysis
8 20 (15.38%) Scrum
9 19 (14.62%) Analytics
10 18 (13.85%) Logical Data Model
10 18 (13.85%) Migration
11 16 (12.31%) Data Management
12 15 (11.54%) Mentoring
13 14 (10.77%) Business Analysis
13 14 (10.77%) Data Architecture
13 14 (10.77%) Data Migration
14 12 (9.23%) Continuous Integration
14 12 (9.23%) Data Mapping
15 11 (8.46%) Data Governance
16 10 (7.69%) Coaching
Programming Languages
1 58 (44.62%) SQL
2 16 (12.31%) Java
3 12 (9.23%) PL/SQL
4 11 (8.46%) T-SQL
5 5 (3.85%) Bash Shell
5 5 (3.85%) Python
6 4 (3.08%) C
7 3 (2.31%) VB
8 2 (1.54%) ANSI SQL
8 2 (1.54%) C#
8 2 (1.54%) JavaScript
8 2 (1.54%) R
9 1 (0.77%) Data Analysis Expressions (DAX)
9 1 (0.77%) SPARQL
9 1 (0.77%) VBA
Qualifications
1 14 (10.77%) Security Cleared
2 12 (9.23%) Degree
3 11 (8.46%) SC Cleared
4 2 (1.54%) DV Cleared
5 1 (0.77%) ISEB
5 1 (0.77%) ISTQB
5 1 (0.77%) MCITP
5 1 (0.77%) Microsoft Certification
5 1 (0.77%) PhD
Quality Assurance & Compliance
1 17 (13.08%) Data Quality
2 3 (2.31%) QA
3 1 (0.77%) Disclosure Scotland
System Software
1 11 (8.46%) Docker
2 8 (6.15%) VMware Infrastructure
2 8 (6.15%) Xen
3 2 (1.54%) HDFS
Systems Management
1 8 (6.15%) Microsoft Intune
2 2 (1.54%) Control-M
2 2 (1.54%) Oozie
3 1 (0.77%) HP Quality Center
Vendors
1 33 (25.38%) Oracle
2 19 (14.62%) Microsoft
3 15 (11.54%) IBM
4 13 (10.00%) Informatica
4 13 (10.00%) Talend
5 12 (9.23%) Cognos
5 12 (9.23%) SAP
6 8 (6.15%) Citrix
6 8 (6.15%) Tableau
6 8 (6.15%) VMware
7 7 (5.38%) Concur
7 7 (5.38%) Infor
7 7 (5.38%) Salesforce.com
7 7 (5.38%) Teradata
8 4 (3.08%) hybris
8 4 (3.08%) MicroStrategy
9 2 (1.54%) Actuate
9 2 (1.54%) Cloudera
9 2 (1.54%) Hortonworks
9 2 (1.54%) Vertica
London
ConSol Partners
Rate: £550 - £800 per annum
Posted: 15 hours ago
North London
Connectus
Rate: £500 per day
Posted: 23 hours ago
York
Rural Payments Agency
Posted: 3 days ago