The table below looks at the statistics for Star Schema skills in IT contracts advertised for the England region. Included is a guide to the average contractor rates offered in IT contracts that have cited Star Schema over the 3 months to 22 December 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
22 Dec 2014
Same period 2013 Same period 2012
Star Schema
Rank 514 504 478
Rank change year-on-year
-10 -26
Contract jobs citing Star Schema 71 51 62
As % of all contract IT jobs located in England 0.14% 0.11% 0.14%
As % of the Database & Business Intelligence category 0.68% 0.47% 0.63%
Number of daily rates quoted 38 29 27
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£413 £455 £425
Average daily rate % change year-on-year
-9.34% +7.05%
90% offered a daily rate of more than £318 £370 £350
10% offered a daily rate of more than £565 £587 £500
UK excluding London average daily rate £363 £375 £388
% change year-on-year
-3.33% -3.22%
Number of hourly rates quoted 0 2 6
Average hourly rate - £31.80 £38.25
Average hourly rate % change year-on-year
- -16.86%
UK excluding London average hourly rate - £31.80 £38.25
% change year-on-year
- -16.86%
Star Schema
UK

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 England region.

Database & Business Intelligence Category
England
Contract IT job ads with a match in the
Database & Business Intelligence category
10421 10742 9892
As % of all contract IT jobs located in England 20.90% 22.79% 22.10%
Number of daily rates quoted 7034 6750 6157
Average daily rate £400 £400 £375
Average daily rate % change year-on-year
- +6.66%
90% offered a daily rate of more than £275 £265 £250
10% offered a daily rate of more than £550 £550 £550
UK excluding London average daily rate £363 £325 £335
% change year-on-year
+11.53% -2.98%
Number of hourly rates quoted 154 248 237
Average hourly rate £35.00 £28.00 £30.50
Average hourly rate % change year-on-year
+25.00% -8.19%
90% offered a hourly rate of more than £15.57 £15.45 £19.46
10% offered a hourly rate of more than £63.40 £45.25 £45.00
UK excluding London average hourly rate £35.00 £28.00 £30.00
% change year-on-year
+25.00% -6.66%

Star Schema
Jobs Demand Trend in England

This chart provides a 3-month moving total of IT contractor jobs citing Star Schema across the England region as a proportion of the total demand within the Database & Business Intelligence category.

Star Schema Jobs Demand Trend in England

Star Schema
Daily Rate Trend in England

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

Star Schema Daily Rate Trend in England

Star Schema
Daily Rate Histogram in England

This chart provides a histogram of daily rates quoted in contract IT jobs citing Star Schema across the England region over the 3 months to 22 December 2014.

Star Schema Daily Rate Histogram in England

Star Schema
Hourly Rate Trend in England

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

Star Schema Hourly Rate Trend in England

Star Schema
Contract Job Locations in England

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 England region over the 3 months to 22 December 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
London +26 40 £427 -7.42% 5
South East -18 11 £403 -22.59%
West Midlands 0 8 £350 - 1
East of England -13 4 £375 +25.00%
South West - 3 £395 - 1
Yorkshire - - - -
Star Schema
UK

Star Schema
Top 30 Related IT Skills in England

For the 6 months to 22 December 2014, IT contractor jobs across the England region 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 89 (64.03%) Data Warehouse
2 83 (59.71%) SQL
3 79 (56.83%) ETL
4 72 (51.80%) Business Intelligence
5 59 (42.45%) Data Modelling
6 53 (38.13%) SQL Server
7 50 (35.97%) Agile Software Development
8 47 (33.81%) SQL Server Integration Services
9 44 (31.65%) Oracle
10 40 (28.78%) Kimball Methodology
11 28 (20.14%) Finance
12 26 (18.71%) Microsoft
12 26 (18.71%) Analytical Skills
13 25 (17.99%) Analytics
14 24 (17.27%) MS Excel
15 23 (16.55%) SQL Server Reporting Services
16 22 (15.83%) T-SQL
17 21 (15.11%) SQL Server Analysis Services
17 21 (15.11%) Inmon Methodology
17 21 (15.11%) Performance Tuning
18 20 (14.39%) OLAP
18 20 (14.39%) XML
18 20 (14.39%) SQL Server 2008
18 20 (14.39%) Tableau
19 18 (12.95%) PL/SQL
20 17 (12.23%) Informatica
20 17 (12.23%) Big Data
21 15 (10.79%) Data Management
22 13 (9.35%) Cognos
22 13 (9.35%) MicroStrategy

Star Schema
Top Related IT Skills in England by Category

For the 6 months to 22 December 2014, IT contractor jobs across the England region 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 5 (3.60%) SharePoint
2 4 (2.88%) Apache Pig
Applications
1 24 (17.27%) MS Excel
2 5 (3.60%) PowerPivot
3 1 (0.72%) MS Visio
3 1 (0.72%) Spreadsheet
Business Applications
1 5 (3.60%) Oracle Financials
1 5 (3.60%) Oracle Payables
2 4 (2.88%) Cognos Business Intelligence
3 2 (1.44%) Summit
4 1 (0.72%) Cognos TM1
4 1 (0.72%) Dynamics NAV
4 1 (0.72%) Dynamics CRM
Cloud Services
1 1 (0.72%) IBM Blueworks
Communications & Networking
1 5 (3.60%) SAN
2 2 (1.44%) PuTTY
Database & Business Intelligence
1 89 (64.03%) Data Warehouse
2 53 (38.13%) SQL Server
3 47 (33.81%) SQL Server Integration Services
4 23 (16.55%) SQL Server Reporting Services
5 21 (15.11%) SQL Server Analysis Services
6 20 (14.39%) OLAP
6 20 (14.39%) SQL Server 2008
7 17 (12.23%) Big Data
8 11 (7.91%) SQL Server 2012
9 10 (7.19%) Oracle Database
9 10 (7.19%) Oracle Reports
9 10 (7.19%) Data Mart
10 9 (6.47%) QlikView
10 9 (6.47%) Snowflake Schema
11 8 (5.76%) Oracle Database 11g
11 8 (5.76%) SQL Server 2005
11 8 (5.76%) Hadoop
12 7 (5.04%) Oracle BI Publisher
12 7 (5.04%) Relational Database
12 7 (5.04%) Oracle ODI
Development Applications
1 5 (3.60%) JIRA
1 5 (3.60%) Team Foundation Server
1 5 (3.60%) Toad
2 4 (2.88%) ERwin
3 3 (2.16%) PyUnit
4 2 (1.44%) QuickTest Pro
5 1 (0.72%) SQL Server Management Studio (SSMS)
General
1 28 (20.14%) Finance
2 8 (5.76%) Banking
3 5 (3.60%) Retail
4 3 (2.16%) Games
5 2 (1.44%) Investment Banking
6 1 (0.72%) Retail Banking
6 1 (0.72%) International Banking
6 1 (0.72%) Telecoms
6 1 (0.72%) Publishing
Job Titles
1 89 (64.03%) Developer
2 24 (17.27%) SQL Developer
3 14 (10.07%) ETL Developer
3 14 (10.07%) Analyst
4 13 (9.35%) Consultant
4 13 (9.35%) Microstrategy Developer
5 8 (5.76%) Business Analyst
6 7 (5.04%) Architect
6 7 (5.04%) SQL Server Developer
6 7 (5.04%) Data Warehouse Developer
7 6 (4.32%) Business Intelligence Analyst
7 6 (4.32%) Business Intelligence Developer
7 6 (4.32%) Data Consultant
8 5 (3.60%) Data Integration Consultant
8 5 (3.60%) Integration Consultant
8 5 (3.60%) Data Modeller
9 4 (2.88%) Team Leader
9 4 (2.88%) Senior Developer
9 4 (2.88%) Cognos Developer
9 4 (2.88%) DataStage Developer
Libraries, Frameworks & Software Standards
1 20 (14.39%) XML
2 9 (6.47%) MDX
3 5 (3.60%) SOAP
4 3 (2.16%) JDBC
4 3 (2.16%) J2EE
5 1 (0.72%) CSS
5 1 (0.72%) HTML
5 1 (0.72%) .NET
5 1 (0.72%) XHTML
5 1 (0.72%) Ajax
5 1 (0.72%) GWT
5 1 (0.72%) Spring Batch
Miscellaneous
1 26 (18.71%) Analytical Skills
2 11 (7.91%) Visualisation
3 8 (5.76%) Data Integration
4 7 (5.04%) Computer Science
5 6 (4.32%) Data Extraction
6 4 (2.88%) Data Protection Act
6 4 (2.88%) Freedom of Information Act
6 4 (2.88%) Hedge funds
6 4 (2.88%) Freedom of Information
6 4 (2.88%) Data Structures
7 3 (2.16%) CMDB
7 3 (2.16%) Credit Risk
7 3 (2.16%) Online Games
8 2 (1.44%) Reference Data
8 2 (1.44%) NHS
8 2 (1.44%) AS400
9 1 (0.72%) Enterprise Software
9 1 (0.72%) FMCG
9 1 (0.72%) Management Information System
9 1 (0.72%) Web 2.0
Operating Systems
1 6 (4.32%) UNIX
1 6 (4.32%) Linux
2 1 (0.72%) Windows
Processes & Methodologies
1 79 (56.83%) ETL
2 72 (51.80%) Business Intelligence
3 59 (42.45%) Data Modelling
4 50 (35.97%) Agile Software Development
5 40 (28.78%) Kimball Methodology
6 25 (17.99%) Analytics
7 21 (15.11%) Inmon Methodology
7 21 (15.11%) Performance Tuning
8 15 (10.79%) Data Management
9 12 (8.63%) Data Mapping
10 11 (7.91%) Master Data Management
11 10 (7.19%) User Acceptance Testing
11 10 (7.19%) Dimensional Modelling
12 8 (5.76%) Requirements Analysis
12 8 (5.76%) Project Management
12 8 (5.76%) Test Strategy
13 7 (5.04%) TDD
13 7 (5.04%) Migration
13 7 (5.04%) RAD
14 6 (4.32%) UML
Programming Languages
1 83 (59.71%) SQL
2 22 (15.83%) T-SQL
3 18 (12.95%) PL/SQL
4 9 (6.47%) C#
5 8 (5.76%) VBA
6 7 (5.04%) Python
6 7 (5.04%) Java
7 5 (3.60%) Perl
8 3 (2.16%) Data Mining Extensions (DMX)
9 2 (1.44%) JavaScript
9 2 (1.44%) C++
9 2 (1.44%) Shell Script
9 2 (1.44%) PowerShell
Qualifications
1 10 (7.19%) Degree
2 1 (0.72%) ISTQB Foundation Certification
2 1 (0.72%) ISEB
2 1 (0.72%) ISTQB
Quality Assurance & Compliance
1 8 (5.76%) QA
2 6 (4.32%) Data Quality
System Software
1 5 (3.60%) Active Directory
2 4 (2.88%) HDFS
3 3 (2.16%) Apache ZooKeeper
Systems Management
1 5 (3.60%) Control-M
2 3 (2.16%) HP Quality Center
3 2 (1.44%) Oracle EDQ
Vendors
1 44 (31.65%) Oracle
2 26 (18.71%) Microsoft
3 20 (14.39%) Tableau
4 17 (12.23%) Informatica
5 13 (9.35%) MicroStrategy
5 13 (9.35%) Cognos
6 10 (7.19%) Business Objects
6 10 (7.19%) SAP
7 5 (3.60%) Lattice Semiconductor
7 5 (3.60%) BMC
8 4 (2.88%) Ab Initio
9 3 (2.16%) Netezza
9 3 (2.16%) IBM
10 2 (1.44%) JD Edwards
10 2 (1.44%) Salesforce.com
10 2 (1.44%) Perforce
11 1 (0.72%) Cloudera
11 1 (0.72%) Google