The following table provides summary statistics for contract job vacancies with a requirement for Star Schema skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Star Schema over the 3 months to 23 March 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

3 months to
23 Mar 2017
Same period 2016 Same period 2015
Star Schema
UK
Rank 554 571 542
Rank change year-on-year +17 -29  
Contract jobs citing Star Schema 45 57 79
As % of all contract IT jobs advertised in the UK 0.10% 0.11% 0.15%
As % of the Database & Business Intelligence category 0.44% 0.49% 0.67%
Number of daily rates quoted 24 45 44
Median daily rate £438 £500 £461
Median daily rate % change year-on-year -12.50% +8.40%  
90% offered a daily rate of more than £200 £369 £361
10% offered a daily rate of more than £572 £665 £543
UK excluding London median daily rate £325 £464 £423
% change year-on-year -29.91% +9.76%  
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate - - -

Star Schema is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies with a requirement for database and business intelligence skills.

Contract Database & Business Intelligence Skills
UK
Contract job vacancies with a requirement for database and business intelligence skills 10154 11722 11724
As % of all contract IT job vacancies advertised in the UK 22.70% 22.19% 22.39%
Number of daily rates quoted 6869 7857 7471
Median daily rate £438 £425 £400
Median daily rate % change year-on-year +2.94% +6.25%  
90% offered a daily rate of more than £300 £300 £275
10% offered a daily rate of more than £600 £600 £550
UK excluding London median daily rate £400 £388 £375
% change year-on-year +3.22% +3.33%  
Number of hourly rates quoted 127 190 155
Median hourly rate £31.00 £34.00 £32.10
Median hourly rate % change year-on-year -8.82% +5.91%  
90% offered a hourly rate of more than £12.00 £15.00 £16.00
10% offered a hourly rate of more than £47.00 £60.62 £47.50
UK excluding London median hourly rate £31.75 £32.50 £32.50
% change year-on-year -2.30% -  

Star Schema
Job Vacancy Trend

The job posting trend of jobs advertised citing Star Schema as a proportion of all contract or permanent IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for Star Schema in the UK

Star Schema
Contractor Daily Rate Trend

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

Contractor daily rate trend for Star Schema in the UK

Star Schema
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing Star Schema over the 3 months to 23 March 2017.

Contractor daily rate histogram for Star Schema in the UK

Star Schema
Contractor Hourly Rate Trend

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

Contractor hourly rate trend for Star Schema in the UK

Star Schema
Top 21 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 23 March 2017. 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 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 +27 41 £457 -10.78% 7
London +1 21 £464 -11.61% 1
South East +27 11 £488 +39.28% 1
Hampshire - 6 £488 -
Berkshire - 5 £650 -
Basingstoke - 3 £403 -
Yorkshire +9 2 £413 -
West Yorkshire +5 2 £413 +10.00%
Havant - 2 £488 -
Bath - 2 £325 - 1
East of England - 2 - - 1
Somerset - 2 £325 - 1
South West - 2 £325 - 2
Suffolk - 2 - - 1
North West +14 1 - - 1
Leeds +5 1 - -
City of London -5 1 £475 -24.00%
Canary Wharf - 1 £505 -
Maidenhead - 1 £650 -
Merseyside - 1 - -
Huddersfield - 1 £413 -

Star Schema
Top 30 Related IT Skills

For the 6 months to 23 March 2017, 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 57 (68.67%) Business Intelligence
2 52 (62.65%) SQL
3 47 (56.63%) Data Warehouse
4 46 (55.42%) ETL
5 43 (51.81%) Data Modelling
6 42 (50.60%) Oracle
7 40 (48.19%) Finance
8 37 (44.58%) SQL Server
9 30 (36.14%) SQL Server Integration Services
10 25 (30.12%) Agile Software Development
11 23 (27.71%) Analytics
12 21 (25.30%) Kimball Methodology
13 19 (22.89%) Oracle Database
13 19 (22.89%) SQL Server Reporting Services
13 19 (22.89%) Dimensional Modelling
14 17 (20.48%) SQL Server Analysis Services
15 16 (19.28%) Migration
16 14 (16.87%) Banking
16 14 (16.87%) SQL Server 2012
16 14 (16.87%) PL/SQL
16 14 (16.87%) Oracle Reports
16 14 (16.87%) Cognos
17 13 (15.66%) Oracle BI EE
18 12 (14.46%) Data Integration
18 12 (14.46%) Performance Tuning
18 12 (14.46%) Analytical Skills
19 11 (13.25%) Relational Database
19 11 (13.25%) Informatica
19 11 (13.25%) Data Architecture
19 11 (13.25%) Talend Open Studio

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 5 (6.02%) Oracle Workflow
2 4 (4.82%) Adobe Experience Manager
2 4 (4.82%) SharePoint
2 4 (4.82%) Tomcat
3 3 (3.61%) SAS
4 1 (1.20%) Apache Spark
Applications
1 9 (10.84%) MS Excel
2 8 (9.64%) MS Visio
3 6 (7.23%) MS Office
4 4 (4.82%) MS Project
5 3 (3.61%) S-PLUS
6 2 (2.41%) SPSS
Business Applications
1 7 (8.43%) Oracle Applications
2 4 (4.82%) Adobe Campaign
2 4 (4.82%) Demantra
2 4 (4.82%) Oracle 11i
2 4 (4.82%) SnowdropKCS
3 2 (2.41%) Oracle EBS
3 2 (2.41%) SAP Oil and Gas
4 1 (1.20%) Oracle Receivables
Cloud Services
1 10 (12.05%) Amazon AWS
2 5 (6.02%) Cloud Computing
3 4 (4.82%) Adobe Analytics
4 2 (2.41%) Google Analytics
5 1 (1.20%) Microsoft Azure
Communications & Networking
1 3 (3.61%) TCP/IP
2 1 (1.20%) Internet
Database & Business Intelligence
1 47 (56.63%) Data Warehouse
2 37 (44.58%) SQL Server
3 30 (36.14%) SQL Server Integration Services
4 19 (22.89%) Oracle Database
4 19 (22.89%) SQL Server Reporting Services
5 17 (20.48%) SQL Server Analysis Services
6 14 (16.87%) Oracle Reports
6 14 (16.87%) SQL Server 2012
7 13 (15.66%) Oracle BI EE
8 11 (13.25%) Data Mart
8 11 (13.25%) Relational Database
9 10 (12.05%) Amazon Redshift
9 10 (12.05%) OLAP
10 9 (10.84%) Big Data
11 8 (9.64%) Power BI
12 7 (8.43%) DataStage
12 7 (8.43%) QlikView
12 7 (8.43%) SQL Server 2008
13 6 (7.23%) Data Mining
13 6 (7.23%) SQL Server 2005
Development Applications
1 11 (13.25%) Talend Open Studio
2 9 (10.84%) ERwin
3 4 (4.82%) JDeveloper
3 4 (4.82%) Oracle Forms
3 4 (4.82%) Team Foundation Server
4 3 (3.61%) Git (software)
4 3 (3.61%) PowerBuilder
4 3 (3.61%) Toad
5 1 (1.20%) SpecFlow
General
1 40 (48.19%) Finance
2 14 (16.87%) Banking
3 11 (13.25%) Marketing
3 11 (13.25%) Retail
4 6 (7.23%) Investment Banking
4 6 (7.23%) Manufacturing
5 4 (4.82%) Legal
5 4 (4.82%) Publishing
5 4 (4.82%) Telecoms
6 3 (3.61%) Front Office
7 2 (2.41%) Advertising
7 2 (2.41%) Electronics
7 2 (2.41%) German Language
8 1 (1.20%) Back Office
8 1 (1.20%) Pharmaceutical
Job Titles
1 41 (49.40%) Developer
2 15 (18.07%) Business Intelligence Developer
3 12 (14.46%) Analyst
3 12 (14.46%) Architect
3 12 (14.46%) Data Architect
4 9 (10.84%) SQL Developer
5 7 (8.43%) OBIEE Developer
6 5 (6.02%) Business Intelligence Architect
6 5 (6.02%) Cloud Specialist
6 5 (6.02%) Data Warehouse Architect
6 5 (6.02%) ETL Developer
6 5 (6.02%) Security Specialist
7 4 (4.82%) Applications Support Analyst
7 4 (4.82%) Business Intelligence Manager
7 4 (4.82%) Data Warehouse Developer
7 4 (4.82%) Development Analyst
7 4 (4.82%) Development Support Analyst
7 4 (4.82%) Redshift Developer
7 4 (4.82%) SSIS Developer
7 4 (4.82%) Support Analyst
Libraries, Frameworks & Software Standards
1 7 (8.43%) MDX
1 7 (8.43%) XML
2 6 (7.23%) .NET
3 3 (3.61%) SOAP
4 2 (2.41%) Software Packaging
5 1 (1.20%) Web Services
Miscellaneous
1 12 (14.46%) Analytical Skills
2 6 (7.23%) Management Information System
3 5 (6.02%) CESG
3 5 (6.02%) Public Cloud
4 3 (3.61%) Computer Science
4 3 (3.61%) Data Structures
4 3 (3.61%) Foreign Exchange (FX)
5 2 (2.41%) Data Protection Act
5 2 (2.41%) Freedom of Information
5 2 (2.41%) Freedom of Information Act
6 1 (1.20%) Derivative
6 1 (1.20%) Enterprise Software
6 1 (1.20%) Reference Data
Operating Systems
1 7 (8.43%) Linux
2 4 (4.82%) HPUX
2 4 (4.82%) Unix
2 4 (4.82%) Windows
2 4 (4.82%) Windows 7
2 4 (4.82%) Windows Server 2003
2 4 (4.82%) Windows Server 2008
2 4 (4.82%) Windows Server 2012
Processes & Methodologies
1 57 (68.67%) Business Intelligence
2 46 (55.42%) ETL
3 43 (51.81%) Data Modelling
4 25 (30.12%) Agile Software Development
5 23 (27.71%) Analytics
6 21 (25.30%) Kimball Methodology
7 19 (22.89%) Dimensional Modelling
8 16 (19.28%) Migration
9 12 (14.46%) Data Integration
9 12 (14.46%) Performance Tuning
10 11 (13.25%) Data Architecture
11 9 (10.84%) Scrum
11 9 (10.84%) Stakeholder Management
12 8 (9.64%) Dashboard Development
12 8 (9.64%) Data Analysis
12 8 (9.64%) Data Migration
13 7 (8.43%) Business Analysis
13 7 (8.43%) Data Governance
13 7 (8.43%) Performance Monitoring
13 7 (8.43%) Test Scripting
Programming Languages
1 52 (62.65%) SQL
2 14 (16.87%) PL/SQL
3 9 (10.84%) R
3 9 (10.84%) T-SQL
4 8 (9.64%) C#
5 4 (4.82%) Java
5 4 (4.82%) JavaScript
6 3 (3.61%) Data Analysis Expressions (DAX)
6 3 (3.61%) MATLAB
7 1 (1.20%) C
7 1 (1.20%) Python
Qualifications
1 10 (12.05%) Security Cleared
2 7 (8.43%) Degree
3 5 (6.02%) (ISC)2 CCSP
3 5 (6.02%) CCSP
3 5 (6.02%) Cisco Certification
3 5 (6.02%) CISM
3 5 (6.02%) CISSP
3 5 (6.02%) SC Cleared
Quality Assurance & Compliance
1 5 (6.02%) COBIT
1 5 (6.02%) ISO/IEC 27001
2 4 (4.82%) Data Quality
2 4 (4.82%) ISO22301
2 4 (4.82%) QA
3 2 (2.41%) ISO 9001
3 2 (2.41%) PCI DSS
Systems Management
1 3 (3.61%) Control-M
Vendors
1 42 (50.60%) Oracle
2 14 (16.87%) Cognos
3 11 (13.25%) Informatica
3 11 (13.25%) Talend
4 9 (10.84%) Microsoft
4 9 (10.84%) Tableau
5 7 (8.43%) IBM
5 7 (8.43%) SAP
6 5 (6.02%) MicroStrategy
7 4 (4.82%) Adobe
7 4 (4.82%) Cisco
7 4 (4.82%) Hyperion
8 3 (3.61%) BMC
8 3 (3.61%) Embarcadero
8 3 (3.61%) Lavastorm
8 3 (3.61%) Teradata
9 2 (2.41%) Google
10 1 (1.20%) Cloudera
10 1 (1.20%) Netezza
10 1 (1.20%) Salesforce.com
Durham, County Durham
Sopra Steria Recruitment
Posted: 11 hours ago
Corsham, Wiltshire
People Source Consulting
Rate: £540 - £560 per day
Posted: 17 hours ago
Macclesfield, Cheshire
Spring Technology
Rate: £550.00 per day
Posted: 3 days ago
London
OHO Group Ltd.
Rate: £500 - £750 per day
Posted: 9 days ago
Bath
People Source Consulting
Rate: £280 - £370 per day
Posted: 23 days ago