The table below looks at the statistics for Star Schema skills in IT contracts advertised across the UK. Included is a guide to the average contractor rates offered in IT contracts that have cited Star Schema over the 3 months to 29 August 2014 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
29 Aug 2014
Same period 2013 Same period 2012
Star Schema
Rank 524 494 502
Rank change year-on-year
-30 +8
Contract jobs citing Star Schema 82 85 89
As % of all contract IT jobs located in the UK 0.14% 0.16% 0.15%
As % of the Database & Business Intelligence category 0.68% 0.74% 0.73%
Number of daily rates quoted 57 57 39
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£375 £400 £420
Average daily rate % change year-on-year
-6.25% -4.76%
90% offered a daily rate of more than £265 £337 £300
10% offered a daily rate of more than £488 £525 £550
UK excluding London average daily rate £305 £394 £395
% change year-on-year
-22.53% -0.31%
Number of hourly rates quoted 0 0 2
Average hourly rate - - £40.75
UK excluding London average hourly rate - - £40.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
12018 11544 12124
As % of all contract IT jobs located in the UK 21.25% 21.91% 20.95%
Number of daily rates quoted 7443 7141 7010
Average daily rate £400 £388 £375
Average daily rate % change year-on-year
+3.22% +3.33%
90% offered a daily rate of more than £265 £250 £260
10% offered a daily rate of more than £550 £550 £550
UK excluding London average daily rate £350 £350 £325
% change year-on-year
- +7.69%
Number of hourly rates quoted 178 199 306
Average hourly rate £30.00 £31.00 £27.60
Average hourly rate % change year-on-year
-3.22% +12.31%
90% offered a hourly rate of more than £13.50 £17.00 £15.25
10% offered a hourly rate of more than £67.00 £50.00 £45.00
UK excluding London average hourly rate £31.00 £32.50 £30.00
% change year-on-year
-4.61% +8.33%

Star Schema
Jobs Demand Trend

This chart provides the 3-month moving total of IT contractor jobs citing Star Schema within the UK as a proportion of the total demand within 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 29 August 2014.

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 30 Contract Locations

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 UK over the 3 months to 29 August 2014. 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
England -32 69 £375 -6.25% 15
London +7 40 £416 -3.19% 9
Yorkshire - 18 £288 -
West Yorkshire - 17 £288 -
Leeds - 15 £289 -
Scotland -11 6 £229 -37.80%
City of London +8 5 £425 -10.52% 3
South Wales - 5 £325 - 2
Wales - 5 £325 - 2
Edinburgh -7 4 £220 -45.08%
Berkshire +4 3 £425 -32.80% 1
South East -23 3 £425 -32.40% 1
Cardiff - 3 £325 - 2
South West -47 2 £425 +11.98%
Manchester - 2 £331 -
North West - 2 £331 - 1
Reading +3 1 £425 -34.48% 1
East Midlands -3 1 - - 2
West Midlands -13 1 £250 -39.39% 2
Hertfordshire -15 1 - -
East of England -25 1 - -
Warwickshire - 1 £250 - 1
West Sussex - - - -
Merseyside - - - -
Nottinghamshire - - - -
Somerset - - - -
Surrey - - - -
Cumbria - - - - 1
Derbyshire - - - - 2
Hampshire - - - -

Star Schema
Top 30 Related IT Skills

For the 6 months to 29 August 2014, IT contractor jobs within the UK 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 94 (66.20%) SQL
2 90 (63.38%) Business Intelligence
3 85 (59.86%) ETL
4 77 (54.23%) Data Warehouse
4 77 (54.23%) SQL Server
5 69 (48.59%) SQL Server Integration Services
6 58 (40.85%) SQL Server Reporting Services
7 53 (37.32%) Oracle
8 42 (29.58%) Kimball Methodology
9 40 (28.17%) SQL Server Analysis Services
10 39 (27.46%) SQL Server 2008
11 37 (26.06%) Microsoft
12 36 (25.35%) Data Modelling
13 34 (23.94%) Agile Software Development
14 31 (21.83%) Finance
15 28 (19.72%) Business Objects
16 27 (19.01%) MS Excel
17 26 (18.31%) T-SQL
17 26 (18.31%) XML
17 26 (18.31%) Inmon Methodology
18 24 (16.90%) Dimensional Modelling
18 24 (16.90%) PL/SQL
19 23 (16.20%) Analytics
20 21 (14.79%) OLAP
21 20 (14.08%) Performance Tuning
21 20 (14.08%) Big Data
22 19 (13.38%) C#
22 19 (13.38%) Relational Database
23 17 (11.97%) UNIX
23 17 (11.97%) Informatica

Star Schema
Top Related IT Skills by Category

For the 6 months to 29 August 2014, IT contractor jobs within the UK 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 12 (8.45%) SharePoint
2 4 (2.82%) SharePoint 2010
3 3 (2.11%) SAS
Applications
1 27 (19.01%) MS Excel
2 7 (4.93%) PowerPivot
3 2 (1.41%) Spreadsheet
Business Applications
1 2 (1.41%) Dynamics CRM
1 2 (1.41%) Cognos Business Intelligence
2 1 (0.70%) Demantra
2 1 (0.70%) JDE World
2 1 (0.70%) Oracle Payables
2 1 (0.70%) Oracle Financials
2 1 (0.70%) Oracle Applications
2 1 (0.70%) Dynamics NAV
Cloud Services
1 3 (2.11%) Office 365
Communications & Networking
1 5 (3.52%) FTP
1 5 (3.52%) SAN
2 2 (1.41%) PuTTY
Database & Business Intelligence
1 77 (54.23%) SQL Server
1 77 (54.23%) Data Warehouse
2 69 (48.59%) SQL Server Integration Services
3 58 (40.85%) SQL Server Reporting Services
4 40 (28.17%) SQL Server Analysis Services
5 39 (27.46%) SQL Server 2008
6 21 (14.79%) OLAP
7 20 (14.08%) Big Data
8 19 (13.38%) Relational Database
9 17 (11.97%) Oracle Database
10 15 (10.56%) SQL Server 2005
11 14 (9.86%) Oracle Database 11g
12 12 (8.45%) Oracle OLAP
12 12 (8.45%) SQL Server 2012
13 9 (6.34%) Data Mart
13 9 (6.34%) RDBMS
14 8 (5.63%) Microsoft Analysis Services
15 6 (4.23%) BusinessObjects XI
15 6 (4.23%) DataStage
16 5 (3.52%) Oracle Discoverer
Development Applications
1 5 (3.52%) ClearCase
2 2 (1.41%) Toad
2 2 (1.41%) QuickTest Pro
2 2 (1.41%) JMeter
2 2 (1.41%) Selenium
2 2 (1.41%) WebDriver
2 2 (1.41%) SoapUI
2 2 (1.41%) LoadUI
3 1 (0.70%) Visual Studio
3 1 (0.70%) Talend Open Studio
3 1 (0.70%) Team Foundation Server
3 1 (0.70%) ERwin
General
1 31 (21.83%) Finance
2 8 (5.63%) Banking
3 4 (2.82%) Investment Banking
4 2 (1.41%) Marketing
4 2 (1.41%) Games
5 1 (0.70%) French Language
5 1 (0.70%) Retail Banking
5 1 (0.70%) Retail
5 1 (0.70%) Publishing
5 1 (0.70%) Pharmaceutical
5 1 (0.70%) Financial Institution
5 1 (0.70%) Telecoms
Job Titles
1 98 (69.01%) Developer
2 23 (16.20%) Business Intelligence Developer
3 22 (15.49%) ETL Developer
4 21 (14.79%) SQL Developer
5 17 (11.97%) Analyst
6 13 (9.15%) Test Analyst
6 13 (9.15%) Business Developer
6 13 (9.15%) Microstrategy Developer
7 9 (6.34%) Oracle Developer
8 8 (5.63%) SQL Server Developer
8 8 (5.63%) Architect
9 7 (4.93%) Business Intelligence Analyst
10 6 (4.23%) Coordinator
10 6 (4.23%) Business Analyst
10 6 (4.23%) Senior Developer
11 5 (3.52%) Data Analyst
11 5 (3.52%) Tester
11 5 (3.52%) Consultant
11 5 (3.52%) Technical Leader
12 4 (2.82%) Business Test Analyst
Libraries, Frameworks & Software Standards
1 26 (18.31%) XML
2 15 (10.56%) MDX
3 10 (7.04%) .NET
4 6 (4.23%) CSS
4 6 (4.23%) XHTML
4 6 (4.23%) HTML
5 5 (3.52%) Web Services
5 5 (3.52%) Ajax
6 3 (2.11%) SOAP
6 3 (2.11%) ASP.NET
7 2 (1.41%) JSON
8 1 (0.70%) Spring Batch
Miscellaneous
1 11 (7.75%) Computer Science
2 6 (4.23%) CMDB
2 6 (4.23%) Data Integration
3 5 (3.52%) Visualisation
4 4 (2.82%) Freedom of Information
4 4 (2.82%) Data Protection Act
4 4 (2.82%) Freedom of Information Act
5 3 (2.11%) NHS
5 3 (2.11%) Management Information System
5 3 (2.11%) Reference Data
5 3 (2.11%) Data Conversion
6 2 (1.41%) Data Extraction
6 2 (1.41%) Online Games
6 2 (1.41%) Enterprise Software
7 1 (0.70%) Hedge funds
7 1 (0.70%) FMCG
7 1 (0.70%) Credit Risk
Operating Systems
1 17 (11.97%) UNIX
2 5 (3.52%) Solaris
2 5 (3.52%) Linux
3 1 (0.70%) Windows
Processes & Methodologies
1 90 (63.38%) Business Intelligence
2 85 (59.86%) ETL
3 42 (29.58%) Kimball Methodology
4 36 (25.35%) Data Modelling
5 34 (23.94%) Agile Software Development
6 26 (18.31%) Inmon Methodology
7 24 (16.90%) Dimensional Modelling
8 23 (16.20%) Analytics
9 20 (14.08%) Performance Tuning
10 12 (8.45%) Data Mapping
11 11 (7.75%) Continuous Integration
11 11 (7.75%) Performance Improvement
12 10 (7.04%) Migration
13 8 (5.63%) Data Management
14 7 (4.93%) Project Management
14 7 (4.93%) Data Migration
14 7 (4.93%) Waterfall
15 6 (4.23%) System Testing
15 6 (4.23%) Master Data Management
15 6 (4.23%) User Acceptance Testing
Programming Languages
1 94 (66.20%) SQL
2 26 (18.31%) T-SQL
3 24 (16.90%) PL/SQL
4 19 (13.38%) C#
5 8 (5.63%) VBA
6 6 (4.23%) JavaScript
7 3 (2.11%) Perl
8 2 (1.41%) Java
8 2 (1.41%) PowerShell
8 2 (1.41%) Data Analysis Expressions (DAX)
8 2 (1.41%) VB
9 1 (0.70%) Data Mining Extensions (DMX)
Qualifications
1 15 (10.56%) Degree
2 10 (7.04%) ISTQB
2 10 (7.04%) ISEB
3 3 (2.11%) ISTQB Foundation Certification
4 2 (1.41%) HNC
4 2 (1.41%) HND
5 1 (0.70%) MCDBA
5 1 (0.70%) Microsoft Certification
5 1 (0.70%) MCITP
5 1 (0.70%) SC Cleared
5 1 (0.70%) Security Cleared
Quality Assurance & Compliance
1 5 (3.52%) QA
2 2 (1.41%) Data Quality
System Software
1 5 (3.52%) Active Directory
Systems Management
1 3 (2.11%) Control-M
2 2 (1.41%) Oracle EDQ
3 1 (0.70%) HP Quality Center
Vendors
1 53 (37.32%) Oracle
2 37 (26.06%) Microsoft
3 28 (19.72%) Business Objects
4 17 (11.97%) Informatica
5 15 (10.56%) Cognos
6 14 (9.86%) MicroStrategy
7 6 (4.23%) Teradata
7 6 (4.23%) Netezza
8 5 (3.52%) Lattice Semiconductor
9 4 (2.82%) Tableau
9 4 (2.82%) IBM
10 3 (2.11%) Greenplum
10 3 (2.11%) Perforce
10 3 (2.11%) Ab Initio
11 2 (1.41%) Hyperion
11 2 (1.41%) SAP
12 1 (0.70%) Siebel
12 1 (0.70%) JD Edwards
12 1 (0.70%) Talend
12 1 (0.70%) Red Gate
City, London
HAYS INFORMATION TECHNOLOGY
Rate: £400.00 - £470.00 per day
Posted: Yesterday
Reading, Berkshire
Coal IT Services
Rate: Up to £380 per day
Posted: 2 days ago
London
Experis Ltd
Posted: 3 days ago