The table below looks at the statistics for Star Schema skills in IT jobs advertised for the England region. Included is a guide to the average salaries offered in IT jobs that have cited Star Schema over the 3 months to 24 October 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
24 Oct 2014
Same period 2013 Same period 2012
Star Schema
Rank 757 759 773
Rank change year-on-year
+2 +14
Permanent jobs citing Star Schema 119 107 94
As % of all permanent IT jobs located in England 0.11% 0.11% 0.088%
As % of the Database & Business Intelligence category 0.37% 0.33% 0.28%
Number of salaries quoted 103 89 78
Average salary £50,000 £52,500 £43,500
Average salary % change year-on-year
-4.76% +20.68%
90% offered a salary of more than £37,500 £37,500 £35,000
10% offered a salary of more than £70,000 £80,000 £85,000
UK excluding London average salary £48,000 £45,000 £43,500
% change year-on-year
+6.66% +3.44%
Star Schema
UK

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the England region.

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
32302 32637 33818
As % of all permanent IT jobs located in England 30.22% 32.11% 31.72%
Number of salaries quoted 27501 28589 29980
Average salary £45,000 £45,000 £42,500
Average salary % change year-on-year
- +5.88%
90% offered a salary of more than £30,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £67,500
UK excluding London average salary £40,000 £40,000 £40,000

Star Schema
Jobs Demand Trend in England

This chart provides a 3-month moving total of permanent IT 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
Salary Trend in England

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

Star Schema Salary Trend in England

Star Schema
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing Star Schema across the England region over the 3 months to 24 October 2014.

Star Schema Salary Histogram in England

Star Schema
Job Locations in England

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing Star Schema within the England region over the 3 months to 24 October 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
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
London -5 43 £55,000 -4.34% 6
South East +6 40 £48,000 -4.00% 3
South West - 13 £57,500 - 1
East of England -9 11 £50,000 +5.26% 1
West Midlands -11 11 £27,850 -14.30%
North West -20 2 £70,000 +55.55% 1
East Midlands -1 1 £42,500 +13.33% 1
Star Schema
UK

Star Schema
Top 30 Related IT Skills in England

For the 6 months to 24 October 2014, IT 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 IT job ads sampled that cited Star Schema.

1 204 (80.31%) Business Intelligence
2 173 (68.11%) SQL Server
3 163 (64.17%) SQL
4 157 (61.81%) Data Warehouse
5 155 (61.02%) SQL Server Integration Services
6 148 (58.27%) ETL
7 130 (51.18%) Data Modelling
8 108 (42.52%) Oracle
9 89 (35.04%) SQL Server Reporting Services
10 79 (31.10%) Kimball Methodology
11 78 (30.71%) T-SQL
11 78 (30.71%) Finance
12 71 (27.95%) SQL Server Analysis Services
13 69 (27.17%) Microsoft
14 64 (25.20%) SQL Server 2008
15 62 (24.41%) Cognos
16 60 (23.62%) Relational Database
17 59 (23.23%) IBM
18 54 (21.26%) OLAP
19 53 (20.87%) MS Excel
20 52 (20.47%) Data Mart
21 48 (18.90%) Cognos Framework Manager
22 47 (18.50%) Dimensional Modelling
23 46 (18.11%) Agile Software Development
24 41 (16.14%) Cognos Business Intelligence
24 41 (16.14%) Cognos Report Studio
25 34 (13.39%) Oracle BI EE
26 32 (12.60%) RDBMS
27 31 (12.20%) Cognos Metric Studio
27 31 (12.20%) Inmon Methodology

Star Schema
Top Related IT Skills in England by Category

For the 6 months to 24 October 2014, IT 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 IT job ads sampled that cited Star Schema. Up to 20 skills are shown per category.

Application Platforms
1 10 (3.94%) SharePoint
1 10 (3.94%) SAS
2 5 (1.97%) MQSeries
3 3 (1.18%) Apache
Applications
1 53 (20.87%) MS Excel
2 5 (1.97%) PowerPivot
3 4 (1.57%) MS Office
4 3 (1.18%) SPSS
5 1 (0.39%) MS PowerPoint
Business Applications
1 41 (16.14%) Cognos Business Intelligence
2 25 (9.84%) Oracle EBS
3 4 (1.57%) Cognos TM1
4 2 (0.79%) Cognos Controller
5 1 (0.39%) SAP ERP
Cloud Services
1 1 (0.39%) Amazon AWS
Communications & Networking
1 2 (0.79%) TCP/IP
Database & Business Intelligence
1 173 (68.11%) SQL Server
2 157 (61.81%) Data Warehouse
3 155 (61.02%) SQL Server Integration Services
4 89 (35.04%) SQL Server Reporting Services
5 71 (27.95%) SQL Server Analysis Services
6 64 (25.20%) SQL Server 2008
7 60 (23.62%) Relational Database
8 54 (21.26%) OLAP
9 52 (20.47%) Data Mart
10 48 (18.90%) Cognos Framework Manager
11 41 (16.14%) Cognos Report Studio
12 34 (13.39%) Oracle BI EE
13 32 (12.60%) RDBMS
14 31 (12.20%) Cognos Metric Studio
15 30 (11.81%) SQL Server 2005
16 29 (11.42%) Oracle Database
17 27 (10.63%) Oracle ODI
18 25 (9.84%) Oracle Reports
19 23 (9.06%) Cognos Analysis Studio
20 22 (8.66%) Data Mining
Development Applications
1 17 (6.69%) ERwin
2 8 (3.15%) Team Foundation Server
3 4 (1.57%) SQL Server Management Studio (SSMS)
3 4 (1.57%) Subversion
3 4 (1.57%) VSS/SourceSafe
4 2 (0.79%) MagicDraw
5 1 (0.39%) Oracle Forms
5 1 (0.39%) Visual Studio
General
1 78 (30.71%) Finance
2 23 (9.06%) Banking
3 14 (5.51%) Telecoms
4 10 (3.94%) Marketing
4 10 (3.94%) Pharmaceutical
5 5 (1.97%) Legal
6 4 (1.57%) Online Betting
7 3 (1.18%) Manufacturing
7 3 (1.18%) Aerospace
8 2 (0.79%) Automotive
8 2 (0.79%) Law
9 1 (0.39%) Advertising
9 1 (0.39%) Publishing
9 1 (0.39%) German Language
9 1 (0.39%) Financial Institution
9 1 (0.39%) Back Office
9 1 (0.39%) Retail
9 1 (0.39%) Investment Banking
Job Titles
1 160 (62.99%) Developer
2 71 (27.95%) Business Intelligence Developer
3 43 (16.93%) Cognos Developer
4 40 (15.75%) Analyst
5 35 (13.78%) Cognos BI Developer
6 27 (10.63%) SQL Developer
7 26 (10.24%) Consultant
8 21 (8.27%) Architect
8 21 (8.27%) Business Intelligence Consultant
9 20 (7.87%) Business Developer
10 18 (7.09%) Data Analyst
11 17 (6.69%) Data Architect
12 16 (6.30%) Data Warehouse Developer
12 16 (6.30%) Developer Analyst
12 16 (6.30%) ETL Developer
13 14 (5.51%) Data Modeller
13 14 (5.51%) Report Developer
14 13 (5.12%) Data Manager
14 13 (5.12%) Oracle Developer
15 12 (4.72%) Senior Developer
Libraries, Frameworks & Software Standards
1 21 (8.27%) XML
2 20 (7.87%) .NET
3 12 (4.72%) MDX
4 9 (3.54%) SOAP
5 7 (2.76%) HTML
5 7 (2.76%) CSS
6 2 (0.79%) XSLT
6 2 (0.79%) XML Schema
6 2 (0.79%) WCF
7 1 (0.39%) WPF
7 1 (0.39%) WF
7 1 (0.39%) Silverlight
7 1 (0.39%) ASP.NET MVC
7 1 (0.39%) ASP.NET MVC 2
7 1 (0.39%) ADO.NET Entity Framework
7 1 (0.39%) DAO
7 1 (0.39%) NHibernate
7 1 (0.39%) .NET Framework
7 1 (0.39%) ADO.NET
7 1 (0.39%) ASP.NET
Miscellaneous
1 26 (10.24%) Data Integration
2 25 (9.84%) Analytical Skills
3 18 (7.09%) Management Information System
4 15 (5.91%) Computer Science
5 9 (3.54%) Data Structures
6 6 (2.36%) Replication
6 6 (2.36%) Client/Server
7 5 (1.97%) Derivative
7 5 (1.97%) Mathematics
8 4 (1.57%) Hedge funds
9 3 (1.18%) Visualisation
9 3 (1.18%) Data Extraction
10 2 (0.79%) FMCG
10 2 (0.79%) Open Source
10 2 (0.79%) Statistics
10 2 (0.79%) Taxonomies
10 2 (0.79%) Ontologies
10 2 (0.79%) Freedom of Information
11 1 (0.39%) NHS
11 1 (0.39%) Enterprise Software
Operating Systems
1 9 (3.54%) Windows
2 8 (3.15%) Linux
2 8 (3.15%) UNIX
Processes & Methodologies
1 204 (80.31%) Business Intelligence
2 148 (58.27%) ETL
3 130 (51.18%) Data Modelling
4 79 (31.10%) Kimball Methodology
5 47 (18.50%) Dimensional Modelling
6 46 (18.11%) Agile Software Development
7 31 (12.20%) Inmon Methodology
8 24 (9.45%) Data Architecture
8 24 (9.45%) Release Management
8 24 (9.45%) Data Management
9 20 (7.87%) Data Analysis
10 19 (7.48%) Time Management
11 18 (7.09%) Data Mapping
12 16 (6.30%) Scrum
12 16 (6.30%) Performance Tuning
13 15 (5.91%) Disaster Recovery
13 15 (5.91%) Refactoring
14 13 (5.12%) Continuous Improvement
15 12 (4.72%) Analytics
15 12 (4.72%) Master Data Management
Programming Languages
1 163 (64.17%) SQL
2 78 (30.71%) T-SQL
3 27 (10.63%) PL/SQL
4 21 (8.27%) C#
5 7 (2.76%) JavaScript
5 7 (2.76%) Shell Script
6 6 (2.36%) Java
7 4 (1.57%) C
7 4 (1.57%) PowerShell
7 4 (1.57%) Data Analysis Expressions (DAX)
8 3 (1.18%) Python
9 2 (0.79%) XPath
10 1 (0.39%) Embedded C
10 1 (0.39%) C++
10 1 (0.39%) VB
Qualifications
1 22 (8.66%) Degree
2 3 (1.18%) NVQ Level 3
3 1 (0.39%) MCP
3 1 (0.39%) Microsoft Certification
Quality Assurance & Compliance
1 6 (2.36%) Solvency II
2 3 (1.18%) QA
3 2 (0.79%) Data Quality
Systems Management
1 4 (1.57%) Oracle EDQ
Vendors
1 108 (42.52%) Oracle
2 69 (27.17%) Microsoft
3 62 (24.41%) Cognos
4 59 (23.23%) IBM
5 19 (7.48%) Business Objects
6 18 (7.09%) SAP
7 13 (5.12%) Teradata
8 10 (3.94%) Netezza
8 10 (3.94%) Tableau
8 10 (3.94%) Informatica
9 4 (1.57%) MicroStrategy
10 3 (1.18%) Sybase
10 3 (1.18%) Logi Analytics
11 2 (0.79%) Ab Initio
12 1 (0.39%) Trillium
Essex
Oscar Associates (UK) Ltd
Salary: £30000 - £45000 per annum
Posted: Yesterday
Bristol
iKonnect
Salary: £30000 - £40000 per annum + Excellent Benefits
Posted: 3 days ago
London
Real Staffing
Salary: £30000 - £32000 per annum + competitive
Posted: 4 days ago
Central London / West End
Ampersand Consulting
Salary: £40000 - £48000 per annum + Benefits
Posted: 4 days ago
East London
Coral Racing Ltd
Salary: Up to £55,000 per annum
Posted: 12 days ago