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

Location
3 months to
23 Oct 2014
Same period 2013 Same period 2012
Star Schema
Rank 765 757 783
Rank change year-on-year
-8 +26
Permanent jobs citing Star Schema 131 114 103
As % of all permanent IT jobs located in the UK 0.11% 0.11% 0.091%
As % of the Database & Business Intelligence category 0.38% 0.33% 0.29%
Number of salaries quoted 109 90 86
Average salary £48,000 £52,500 £43,500
Average salary % change year-on-year
-8.57% +20.68%
90% offered a salary of more than £33,000 £37,500 £35,000
10% offered a salary of more than £70,000 £80,000 £85,000
UK excluding London average salary £48,000 £46,250 £43,500
% change year-on-year
+3.78% +6.32%

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

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
34403 34352 35571
As % of all permanent IT jobs located in the UK 30.15% 32.07% 31.47%
Number of salaries quoted 29019 29712 31311
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 £67,500 £65,000 £67,500
UK excluding London average salary £40,000 £40,000 £40,000

Star Schema
Jobs Demand Trend

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

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

Star Schema Salary Trend in the UK

Star Schema
Salary Histogram

This chart provides a salary histogram for IT jobs citing Star Schema over the 3 months to 23 October 2014 within the UK.

Star Schema Salary Histogram in the UK

Star Schema
Top 30 Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing Star Schema within the UK over the 3 months to 23 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
England +2 119 £50,000 -9.09% 14
London -31 42 £55,000 -4.34% 6
South East +3 41 £48,000 -4.00% 3
Hampshire +9 25 £45,000 +5.88%
City of London +10 16 £53,750 -6.52%
South West - 13 £57,500 - 1
East of England -4 11 £50,000 +5.26% 1
Hertfordshire -10 11 £50,000 +5.26%
West Midlands -16 11 £27,850 -14.30%
Bournemouth - 11 £57,500 -
Dorset - 11 £57,500 -
Warwickshire +8 9 £27,850 -14.30%
Nuneaton +2 9 £27,850 -14.30%
Berkshire +4 8 £52,500 -30.00%
Reading -5 8 £60,000 -20.00%
Scotland -6 6 - -
Glasgow -1 5 - -
St Albans - 3 £50,000 -
Wales - 3 £29,000 - 1
South Wales - 3 £29,000 - 1
North West -25 2 £70,000 +55.55% 1
West Sussex - 2 £60,000 -
Worcestershire - 2 £42,250 -
Borehamwood - 2 - -
Redditch - 2 £42,250 -
Caerphilly - 2 £29,000 - 1
Crawley - 2 £60,000 -
East Midlands +3 1 £42,500 +13.33% 2
Manchester -8 1 - - 1
Surrey -15 1 £52,500 +5.00%

Star Schema
Top 30 Related IT Skills

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

1 215 (79.04%) Business Intelligence
2 182 (66.91%) SQL Server
3 177 (65.07%) SQL
4 169 (62.13%) SQL Server Integration Services
5 168 (61.76%) Data Warehouse
6 161 (59.19%) ETL
7 137 (50.37%) Data Modelling
8 114 (41.91%) Oracle
9 102 (37.50%) SQL Server Reporting Services
10 84 (30.88%) Kimball Methodology
11 82 (30.15%) SQL Server Analysis Services
11 82 (30.15%) Finance
12 80 (29.41%) T-SQL
13 78 (28.68%) Microsoft
14 69 (25.37%) SQL Server 2008
15 66 (24.26%) Cognos
16 65 (23.90%) OLAP
16 65 (23.90%) Relational Database
17 60 (22.06%) IBM
18 57 (20.96%) Data Mart
19 56 (20.59%) MS Excel
20 55 (20.22%) Agile Software Development
21 49 (18.01%) Dimensional Modelling
21 49 (18.01%) Cognos Framework Manager
22 42 (15.44%) Cognos Business Intelligence
22 42 (15.44%) Cognos Report Studio
23 36 (13.24%) RDBMS
24 34 (12.50%) Oracle BI EE
25 32 (11.76%) Inmon Methodology
26 31 (11.40%) Cognos Metric Studio

Star Schema
Top Related IT Skills by Category

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

Application Platforms
1 15 (5.51%) SharePoint
2 10 (3.68%) SAS
3 5 (1.84%) MQSeries
4 3 (1.10%) Apache
Applications
1 56 (20.59%) MS Excel
2 5 (1.84%) PowerPivot
3 4 (1.47%) MS Office
4 3 (1.10%) SPSS
5 1 (0.37%) MS PowerPoint
Business Applications
1 42 (15.44%) Cognos Business Intelligence
2 25 (9.19%) Oracle EBS
3 4 (1.47%) Cognos TM1
4 2 (0.74%) Cognos Controller
5 1 (0.37%) SAP ERP
Cloud Services
1 1 (0.37%) Amazon AWS
1 1 (0.37%) Office 365
Communications & Networking
1 2 (0.74%) FTP
1 2 (0.74%) TCP/IP
Database & Business Intelligence
1 182 (66.91%) SQL Server
2 169 (62.13%) SQL Server Integration Services
3 168 (61.76%) Data Warehouse
4 102 (37.50%) SQL Server Reporting Services
5 82 (30.15%) SQL Server Analysis Services
6 69 (25.37%) SQL Server 2008
7 65 (23.90%) OLAP
7 65 (23.90%) Relational Database
8 57 (20.96%) Data Mart
9 49 (18.01%) Cognos Framework Manager
10 42 (15.44%) Cognos Report Studio
11 36 (13.24%) RDBMS
12 34 (12.50%) Oracle BI EE
13 31 (11.40%) Cognos Metric Studio
14 30 (11.03%) SQL Server 2005
15 29 (10.66%) Snowflake Schema
15 29 (10.66%) Oracle Database
16 27 (9.93%) Oracle ODI
17 26 (9.56%) Oracle Reports
18 24 (8.82%) Cognos Analysis Studio
Development Applications
1 17 (6.25%) ERwin
2 13 (4.78%) Team Foundation Server
3 4 (1.47%) SQL Server Management Studio (SSMS)
3 4 (1.47%) Subversion
3 4 (1.47%) VSS/SourceSafe
4 2 (0.74%) MagicDraw
5 1 (0.37%) Oracle Forms
5 1 (0.37%) Visual Studio
General
1 82 (30.15%) Finance
2 29 (10.66%) Banking
3 19 (6.99%) Telecoms
4 10 (3.68%) Marketing
4 10 (3.68%) Pharmaceutical
5 6 (2.21%) Retail
6 5 (1.84%) Legal
7 4 (1.47%) Online Betting
8 3 (1.10%) Manufacturing
8 3 (1.10%) Aerospace
9 2 (0.74%) Automotive
9 2 (0.74%) Law
10 1 (0.37%) Advertising
10 1 (0.37%) Publishing
10 1 (0.37%) German Language
10 1 (0.37%) Investment Banking
10 1 (0.37%) Financial Institution
10 1 (0.37%) Back Office
Job Titles
1 175 (64.34%) Developer
2 73 (26.84%) Business Intelligence Developer
3 44 (16.18%) Cognos Developer
4 41 (15.07%) Analyst
5 35 (12.87%) Cognos BI Developer
6 27 (9.93%) SQL Developer
7 26 (9.56%) Consultant
8 23 (8.46%) Data Warehouse Developer
9 22 (8.09%) Architect
10 21 (7.72%) Business Developer
10 21 (7.72%) Business Intelligence Consultant
10 21 (7.72%) ETL Developer
11 19 (6.99%) Data Analyst
12 18 (6.62%) Data Architect
13 16 (5.88%) Developer Analyst
14 15 (5.51%) Report Developer
15 14 (5.15%) Data Modeller
16 13 (4.78%) Data Manager
16 13 (4.78%) Oracle Developer
17 12 (4.41%) Senior Developer
Libraries, Frameworks & Software Standards
1 26 (9.56%) XML
2 20 (7.35%) .NET
3 13 (4.78%) MDX
4 9 (3.31%) SOAP
5 7 (2.57%) HTML
5 7 (2.57%) CSS
6 2 (0.74%) XSLT
6 2 (0.74%) XML Schema
6 2 (0.74%) WCF
7 1 (0.37%) WPF
7 1 (0.37%) WF
7 1 (0.37%) Silverlight
7 1 (0.37%) ASP.NET MVC
7 1 (0.37%) ASP.NET MVC 2
7 1 (0.37%) ADO.NET Entity Framework
7 1 (0.37%) DAO
7 1 (0.37%) NHibernate
7 1 (0.37%) .NET Framework
7 1 (0.37%) ADO.NET
7 1 (0.37%) ASP.NET
Miscellaneous
1 31 (11.40%) Data Integration
2 25 (9.19%) Analytical Skills
3 18 (6.62%) Management Information System
4 16 (5.88%) Computer Science
5 8 (2.94%) Data Structures
6 6 (2.21%) Replication
6 6 (2.21%) Client/Server
7 5 (1.84%) Derivative
7 5 (1.84%) Mathematics
8 4 (1.47%) Hedge funds
9 3 (1.10%) Visualisation
9 3 (1.10%) Data Extraction
10 2 (0.74%) FMCG
10 2 (0.74%) Open Source
10 2 (0.74%) Statistics
10 2 (0.74%) Taxonomies
10 2 (0.74%) Ontologies
10 2 (0.74%) Freedom of Information
11 1 (0.37%) NHS
11 1 (0.37%) Enterprise Software
Operating Systems
1 12 (4.41%) UNIX
2 9 (3.31%) Windows
3 8 (2.94%) Linux
Processes & Methodologies
1 215 (79.04%) Business Intelligence
2 161 (59.19%) ETL
3 137 (50.37%) Data Modelling
4 84 (30.88%) Kimball Methodology
5 55 (20.22%) Agile Software Development
6 49 (18.01%) Dimensional Modelling
7 32 (11.76%) Inmon Methodology
8 27 (9.93%) Data Architecture
8 27 (9.93%) Data Management
9 24 (8.82%) Release Management
10 21 (7.72%) Performance Tuning
11 19 (6.99%) Time Management
11 19 (6.99%) Data Analysis
12 18 (6.62%) Scrum
12 18 (6.62%) Data Mapping
12 18 (6.62%) Analytics
13 17 (6.25%) Refactoring
14 16 (5.88%) Disaster Recovery
15 13 (4.78%) Continuous Improvement
16 12 (4.41%) Master Data Management
Programming Languages
1 177 (65.07%) SQL
2 80 (29.41%) T-SQL
3 27 (9.93%) PL/SQL
4 26 (9.56%) C#
5 8 (2.94%) Python
6 7 (2.57%) Shell Script
6 7 (2.57%) JavaScript
7 6 (2.21%) Java
8 4 (1.47%) C
8 4 (1.47%) PowerShell
8 4 (1.47%) Data Analysis Expressions (DAX)
9 2 (0.74%) XPath
10 1 (0.37%) Embedded C
10 1 (0.37%) C++
10 1 (0.37%) VB
Qualifications
1 23 (8.46%) Degree
2 4 (1.47%) Microsoft Certification
3 3 (1.10%) MCSE
3 3 (1.10%) MCSA
3 3 (1.10%) NVQ Level 3
4 2 (0.74%) ISEB
4 2 (0.74%) ISTQB
5 1 (0.37%) MCP
Quality Assurance & Compliance
1 6 (2.21%) Solvency II
2 4 (1.47%) QA
3 2 (0.74%) Data Quality
Systems Management
1 4 (1.47%) Oracle EDQ
Vendors
1 114 (41.91%) Oracle
2 78 (28.68%) Microsoft
3 66 (24.26%) Cognos
4 60 (22.06%) IBM
5 24 (8.82%) SAP
6 21 (7.72%) Business Objects
7 14 (5.15%) Teradata
8 13 (4.78%) Informatica
9 10 (3.68%) Netezza
9 10 (3.68%) Tableau
10 7 (2.57%) MicroStrategy
11 3 (1.10%) Sybase
11 3 (1.10%) Logi Analytics
12 2 (0.74%) Vertica
12 2 (0.74%) Ab Initio
13 1 (0.37%) Trillium
Bristol
iKonnect
Salary: £30000 - £40000 per annum + Excellent Benefits
Posted: Yesterday
London
Real Staffing
Salary: £30000 - £32000 per annum + competitive
Posted: 2 days ago
Central London / West End
Ampersand Consulting
Salary: £40000 - £48000 per annum + Benefits
Posted: 2 days ago
Derby, Derbyshire
Oscar Associates (UK) Ltd
Salary: £36000 - £42000 per annum + Comprehensive benefits package
Posted: 6 days ago
Essex
Oscar Associates (UK) Ltd
Salary: £30000 - £45000 per annum
Posted: 6 days ago
East London
Coral Racing Ltd
Salary: Up to £55,000 per annum
Posted: 10 days ago
Caerphilly, Mid Glamorgan
Sanderson
Salary: £28 - £30 per annum + Benefits
Posted: 13 days ago