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 24 April 2015 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
24 Apr 2015
Same period 2014 Same period 2013
Star Schema
Rank 524 527 504
Rank change year-on-year
+3 -23
Contract jobs citing Star Schema 70 73 55
As % of all contract IT jobs located in the UK 0.13% 0.13% 0.11%
As % of the Database & Business Intelligence category 0.58% 0.61% 0.53%
Number of daily rates quoted 42 36 38
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£427 £408 £409
Average daily rate % change year-on-year
+4.78% -0.30%
90% offered a daily rate of more than £378 £313 £346
10% offered a daily rate of more than £511 £475 £475
UK excluding London average daily rate £420 £350 £370
% change year-on-year
+20.00% -5.40%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate - - -

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
12153 12063 10426
As % of all contract IT jobs located in the UK 21.81% 21.85% 21.50%
Number of daily rates quoted 7883 7600 6299
Average daily rate £400 £388 £378
Average daily rate % change year-on-year
+3.22% +2.51%
90% offered a daily rate of more than £285 £263 £265
10% offered a daily rate of more than £550 £540 £550
UK excluding London average daily rate £375 £350 £330
% change year-on-year
+7.14% +6.06%
Number of hourly rates quoted 146 195 209
Average hourly rate £32.50 £35.00 £27.50
Average hourly rate % change year-on-year
-7.14% +27.27%
90% offered a hourly rate of more than £15.32 £16.75 £15.00
10% offered a hourly rate of more than £46.55 £55.00 £44.50
UK excluding London average hourly rate £32.50 £35.00 £28.00
% change year-on-year
-7.14% +25.00%

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 24 April 2015.

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 23 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 24 April 2015. 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 +7 70 £427 +4.78% 20
London +19 53 £440 +7.97% 15
City of London +18 11 £465 +6.28% 3
South East -1 11 £400 -11.11% 3
Berkshire -2 5 £400 -5.88% 1
Reading +3 4 £325 -23.52%
Feltham - 4 £473 - 2
Surrey - 4 £356 - 2
East of England +23 2 - -
Hertfordshire +6 2 - -
South West +3 2 £490 -
Hampshire -10 2 £423 -13.77%
Dorset - 2 £490 -
St Albans - 2 - -
Uxbridge - 2 £388 -
Bournemouth - 2 £490 -
Croydon - 2 £500 - 1
Redhill - 2 - - 1
West Midlands -11 1 - -
North West - 1 - -
Southampton - 1 £420 -
Hounslow - 1 £340 -
Birmingham - 1 - -

Star Schema
Top 30 Related IT Skills

For the 6 months to 24 April 2015, 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 104 (77.61%) Data Warehouse
2 89 (66.42%) ETL
3 75 (55.97%) SQL
4 68 (50.75%) Data Modelling
5 67 (50.00%) Business Intelligence
6 50 (37.31%) SQL Server
7 45 (33.58%) Agile Software Development
7 45 (33.58%) SQL Server Integration Services
8 41 (30.60%) Finance
9 38 (28.36%) Kimball Methodology
10 37 (27.61%) Oracle
11 33 (24.63%) Microsoft
12 31 (23.13%) SQL Server Reporting Services
13 30 (22.39%) Performance Tuning
13 30 (22.39%) Analytical Skills
14 25 (18.66%) PL/SQL
15 24 (17.91%) SQL Server Analysis Services
16 23 (17.16%) Informatica
16 23 (17.16%) MS Excel
17 20 (14.93%) T-SQL
17 20 (14.93%) XML
17 20 (14.93%) UNIX
17 20 (14.93%) Data Mapping
17 20 (14.93%) Analytics
18 19 (14.18%) Tableau
18 19 (14.18%) Big Data
18 19 (14.18%) Linux
19 18 (13.43%) OLAP
19 18 (13.43%) Banking
19 18 (13.43%) Data Analysis

Star Schema
Top Related IT Skills by Category

For the 6 months to 24 April 2015, 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 4 (2.99%) SharePoint
2 3 (2.24%) Apache Pig
2 3 (2.24%) SAS
3 1 (0.75%) Sitecore CMS
3 1 (0.75%) CMS
3 1 (0.75%) BizTalk Server
Applications
1 23 (17.16%) MS Excel
2 9 (6.72%) MS Visio
3 5 (3.73%) PowerPivot
4 1 (0.75%) MS PowerPoint
4 1 (0.75%) MS Project
4 1 (0.75%) MS Office
4 1 (0.75%) SPSS
Business Applications
1 7 (5.22%) Oracle Payables
1 7 (5.22%) Oracle Financials
2 2 (1.49%) Summit
2 2 (1.49%) Dynamics NAV
2 2 (1.49%) Dynamics CRM
3 1 (0.75%) Cognos Business Intelligence
3 1 (0.75%) Cognos TM1
Database & Business Intelligence
1 104 (77.61%) Data Warehouse
2 50 (37.31%) SQL Server
3 45 (33.58%) SQL Server Integration Services
4 31 (23.13%) SQL Server Reporting Services
5 24 (17.91%) SQL Server Analysis Services
6 19 (14.18%) Big Data
7 18 (13.43%) OLAP
7 18 (13.43%) QlikView
8 15 (11.19%) Snowflake Schema
9 13 (9.70%) Oracle Database
10 12 (8.96%) SQL Server 2008
11 10 (7.46%) DB2
12 9 (6.72%) SQL Server 2012
13 8 (5.97%) BusinessObjects XI
13 8 (5.97%) Data Mart
14 7 (5.22%) Enterprise Data Warehouse
14 7 (5.22%) KDB
15 6 (4.48%) MySQL
15 6 (4.48%) DataStage
15 6 (4.48%) Oracle BI EE
Development Applications
1 9 (6.72%) ERwin
2 6 (4.48%) Talend Open Studio
3 4 (2.99%) SQL Server Management Studio (SSMS)
4 3 (2.24%) Visual Studio
5 2 (1.49%) PyUnit
6 1 (0.75%) JIRA
6 1 (0.75%) Team Foundation Server
6 1 (0.75%) ProC
6 1 (0.75%) Toad
6 1 (0.75%) TestDirector
General
1 41 (30.60%) Finance
2 18 (13.43%) Banking
3 8 (5.97%) Investment Banking
4 7 (5.22%) Retail
5 3 (2.24%) Marketing
5 3 (2.24%) Telecoms
6 1 (0.75%) French Language
6 1 (0.75%) International Banking
6 1 (0.75%) Financial Institution
6 1 (0.75%) Legal
6 1 (0.75%) Advertising
Job Titles
1 78 (58.21%) Developer
2 30 (22.39%) ETL Developer
3 23 (17.16%) Analyst
4 15 (11.19%) Architect
5 14 (10.45%) Consultant
6 12 (8.96%) Data Warehouse Developer
6 12 (8.96%) SQL Developer
7 11 (8.21%) Designer
7 11 (8.21%) Data Architect
8 10 (7.46%) Business Analyst
8 10 (7.46%) Business Intelligence Developer
9 9 (6.72%) Data Consultant
10 8 (5.97%) Microsoft Developer
11 7 (5.22%) Team Leader
12 6 (4.48%) Database Developer
12 6 (4.48%) Systems Analyst
13 5 (3.73%) Integration Consultant
13 5 (3.73%) Data Integration Consultant
13 5 (3.73%) Data Warehouse Consultant
14 4 (2.99%) Technical Analyst
Libraries, Frameworks & Software Standards
1 20 (14.93%) XML
2 9 (6.72%) .NET
3 7 (5.22%) MDX
4 5 (3.73%) SOAP
5 3 (2.24%) Web Services
6 2 (1.49%) JDBC
6 2 (1.49%) J2EE
7 1 (0.75%) Oracle GoldenGate
7 1 (0.75%) WCF
7 1 (0.75%) WF
7 1 (0.75%) .NET Framework
7 1 (0.75%) NHibernate
7 1 (0.75%) DAO
7 1 (0.75%) Entity Framework
7 1 (0.75%) ASP.NET MVC 2
7 1 (0.75%) ASP.NET MVC
7 1 (0.75%) Hibernate
7 1 (0.75%) ASP.NET
Miscellaneous
1 30 (22.39%) Analytical Skills
2 14 (10.45%) Computer Science
3 13 (9.70%) Visualisation
4 12 (8.96%) Data Structures
4 12 (8.96%) Data Integration
5 5 (3.73%) Derivative
5 5 (3.73%) Equity Derivative
5 5 (3.73%) Equities
5 5 (3.73%) Fixed Income
6 4 (2.99%) Reference Data
7 3 (2.24%) Data Protection Act
7 3 (2.24%) Freedom of Information Act
7 3 (2.24%) Freedom of Information
8 2 (1.49%) Management Information System
8 2 (1.49%) Data Extraction
9 1 (0.75%) Enterprise Software
9 1 (0.75%) Algorithms
9 1 (0.75%) Mathematics
9 1 (0.75%) Applied Mathematics
9 1 (0.75%) Statistics
Operating Systems
1 20 (14.93%) UNIX
2 19 (14.18%) Linux
3 7 (5.22%) Windows
4 1 (0.75%) Oracle Linux
Processes & Methodologies
1 89 (66.42%) ETL
2 68 (50.75%) Data Modelling
3 67 (50.00%) Business Intelligence
4 45 (33.58%) Agile Software Development
5 38 (28.36%) Kimball Methodology
6 30 (22.39%) Performance Tuning
7 20 (14.93%) Data Mapping
7 20 (14.93%) Analytics
8 18 (13.43%) Data Analysis
8 18 (13.43%) Inmon Methodology
9 17 (12.69%) Requirements Analysis
10 15 (11.19%) Data Management
11 13 (9.70%) Technical Analysis
12 12 (8.96%) Project Management
13 11 (8.21%) Dimensional Modelling
13 11 (8.21%) Test Strategy
14 10 (7.46%) Data Governance
15 9 (6.72%) User Acceptance Testing
15 9 (6.72%) Unit Testing
15 9 (6.72%) Stakeholder Management
Programming Languages
1 75 (55.97%) SQL
2 25 (18.66%) PL/SQL
3 20 (14.93%) T-SQL
4 13 (9.70%) Python
5 11 (8.21%) Shell Script
5 11 (8.21%) Perl
6 10 (7.46%) Java
7 4 (2.99%) C#
8 2 (1.49%) Data Analysis Expressions (DAX)
9 1 (0.75%) C++
9 1 (0.75%) C
Qualifications
1 18 (13.43%) Degree
2 11 (8.21%) Security Cleared
3 10 (7.46%) SC Cleared
4 1 (0.75%) ISTQB Foundation Certification
4 1 (0.75%) ISTQB
4 1 (0.75%) DV Cleared
4 1 (0.75%) MCP
4 1 (0.75%) PhD
4 1 (0.75%) ISEB
4 1 (0.75%) Microsoft Certification
Quality Assurance & Compliance
1 10 (7.46%) QA
2 9 (6.72%) Data Quality
3 2 (1.49%) Solvency II
System Software
1 3 (2.24%) HDFS
2 2 (1.49%) Apache ZooKeeper
3 1 (0.75%) Oracle RAC
Systems Management
1 5 (3.73%) Control-M
2 2 (1.49%) HP Quality Center
2 2 (1.49%) Oracle EDQ
3 1 (0.75%) Data Guard
Vendors
1 37 (27.61%) Oracle
2 33 (24.63%) Microsoft
3 23 (17.16%) Informatica
4 19 (14.18%) Tableau
5 16 (11.94%) Greenplum
6 13 (9.70%) Cognos
7 10 (7.46%) SAP
8 9 (6.72%) IBM
9 7 (5.22%) Netezza
9 7 (5.22%) Teradata
10 6 (4.48%) Talend
11 5 (3.73%) Business Objects
11 5 (3.73%) BMC
12 4 (2.99%) Sybase
13 3 (2.24%) Vertica
14 2 (1.49%) Sun
14 2 (1.49%) Salesforce.com
14 2 (1.49%) Nintex
15 1 (0.75%) Cloudera
15 1 (0.75%) Sitecore
Surrey
Venturi
Rate: £200 per day
Posted: Yesterday
City, London
Venturi
Rate: £350 - £450 per day
Posted: 4 days ago
Feltham, Middlesex
TEKsystems
Rate: £400 per day
Posted: 4 days ago
City of London
Interquest - ITQ Financial - Tunbridge Wells
Rate: £400 - £450 per day
Posted: 4 days ago
Feltham, Middlesex
LA International
Rate: £350 - £425 per day
Posted: 4 days ago
London
Hays IT - Uk Posting account
Rate: £400.00 - £430.00 per day
Posted: 12 days ago
City of London
Hays IT - Uk Posting account
Rate: £400.00 - £450.00 per day
Posted: 18 days ago