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 January 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
23 Jan 2015
Same period 2014 Same period 2013
Star Schema
Rank 801 764 759
Rank change year-on-year
-37 -5
Permanent jobs citing Star Schema 85 108 116
As % of all permanent IT jobs located in the UK 0.080% 0.10% 0.11%
As % of the Database & Business Intelligence category 0.27% 0.33% 0.32%
Number of salaries quoted 73 81 105
Average salary £44,000 £47,500 £45,000
Average salary % change year-on-year
-7.36% +5.55%
90% offered a salary of more than £31,000 £37,500 £35,000
10% offered a salary of more than £55,000 £65,000 £65,000
UK excluding London average salary £48,000 £42,500 £37,500
% change year-on-year
+12.94% +13.33%

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
31598 33122 36009
As % of all permanent IT jobs located in the UK 29.91% 31.87% 33.04%
Number of salaries quoted 27175 28145 32046
Average salary £45,000 £45,000 £42,500
Average salary % change year-on-year
- +5.88%
90% offered a salary of more than £31,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £70,000
UK excluding London average salary £40,000 £40,000 £38,500
% change year-on-year
- +3.89%

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 January 2015 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 January 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
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -1 80 £44,000 -2.22% 14
London -13 40 £44,000 -20.00% 14
South East -30 19 £48,000 +22.29%
City of London +5 13 £43,000 -26.80% 7
Hampshire -6 10 £48,000 +15.66%
West Yorkshire -5 7 £30,000 -22.07%
Yorkshire -10 7 £30,000 -22.07%
West Midlands -20 7 £39,175 +7.32%
Leeds - 7 £30,000 -
East Sussex - 6 £55,000 -
Uxbridge - 6 £44,000 - 1
Brighton - 6 £55,000 -
Wales - 5 £35,000 -
Warwickshire -4 4 £39,175 +20.53%
South Wales - 4 £35,000 -
South West - 4 £65,000 -
Cardiff - 4 £35,000 -
Guildford - 3 £42,500 -
Surrey - 3 £42,500 -
East Midlands +25 2 £42,500 +16.43%
Nuneaton -2 2 £27,850 -14.30%
Warwick - 2 £50,500 -
Dorset - 2 £65,000 -
Bournemouth - 2 £65,000 -
Nottingham - 2 £42,500 -
Croydon - 2 £37,500 -
Nottinghamshire - 2 £42,500 -
East of England -12 1 £50,000 -
Hertfordshire -13 1 £50,000 -
St Albans - 1 £50,000 -

Star Schema
Top 30 Related IT Skills

For the 6 months to 23 January 2015, 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 151 (69.91%) SQL
2 146 (67.59%) ETL
3 145 (67.13%) Business Intelligence
4 141 (65.28%) SQL Server
5 140 (64.81%) SQL Server Integration Services
6 128 (59.26%) Data Warehouse
7 94 (43.52%) Data Modelling
8 90 (41.67%) SQL Server Analysis Services
9 88 (40.74%) Oracle
10 77 (35.65%) Microsoft
10 77 (35.65%) Finance
11 76 (35.19%) T-SQL
12 73 (33.80%) SQL Server Reporting Services
13 56 (25.93%) IBM
14 50 (23.15%) MS Excel
14 50 (23.15%) Cognos
14 50 (23.15%) SQL Server 2008
15 48 (22.22%) Kimball Methodology
15 48 (22.22%) Relational Database
16 45 (20.83%) OLAP
17 44 (20.37%) Cognos Report Studio
18 41 (18.98%) Data Mart
19 40 (18.52%) Cognos Business Intelligence
19 40 (18.52%) Cognos Framework Manager
20 39 (18.06%) Agile Software Development
21 37 (17.13%) Data Integration
22 36 (16.67%) SQL Server 2005
23 35 (16.20%) Cognos Metric Studio
24 33 (15.28%) Dimensional Modelling
25 30 (13.89%) Analytical Skills

Star Schema
Top Related IT Skills by Category

For the 6 months to 23 January 2015, 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 (6.94%) SharePoint
2 8 (3.70%) SAS
3 4 (1.85%) MQSeries
4 3 (1.39%) Apache
Applications
1 50 (23.15%) MS Excel
2 11 (5.09%) MS Office
2 11 (5.09%) Spreadsheet
3 5 (2.31%) SPSS
3 5 (2.31%) PowerPivot
Business Applications
1 40 (18.52%) Cognos Business Intelligence
2 20 (9.26%) Oracle EBS
3 9 (4.17%) Cognos TM1
4 2 (0.93%) Cognos Controller
Communications & Networking
1 4 (1.85%) HTTP
2 1 (0.46%) FTP
Database & Business Intelligence
1 141 (65.28%) SQL Server
2 140 (64.81%) SQL Server Integration Services
3 128 (59.26%) Data Warehouse
4 90 (41.67%) SQL Server Analysis Services
5 73 (33.80%) SQL Server Reporting Services
6 50 (23.15%) SQL Server 2008
7 48 (22.22%) Relational Database
8 45 (20.83%) OLAP
9 44 (20.37%) Cognos Report Studio
10 41 (18.98%) Data Mart
11 40 (18.52%) Cognos Framework Manager
12 36 (16.67%) SQL Server 2005
13 35 (16.20%) Cognos Metric Studio
14 26 (12.04%) Oracle ODI
15 25 (11.57%) Oracle BI EE
16 21 (9.72%) QlikView
17 20 (9.26%) RDBMS
17 20 (9.26%) OLAP Cube
18 19 (8.80%) Cognos Query Studio
18 19 (8.80%) Cognos Analysis Studio
Development Applications
1 19 (8.80%) Team Foundation Server
2 11 (5.09%) ERwin
3 7 (3.24%) Visual Studio
4 6 (2.78%) SQL Server Management Studio (SSMS)
4 6 (2.78%) JIRA
5 4 (1.85%) Subversion
5 4 (1.85%) VSS/SourceSafe
6 2 (0.93%) MagicDraw
7 1 (0.46%) QuickTest Pro
7 1 (0.46%) Talend Open Studio
7 1 (0.46%) Visual Studio Team System
7 1 (0.46%) FitNesse
General
1 77 (35.65%) Finance
2 17 (7.87%) Banking
3 10 (4.63%) Telecoms
4 8 (3.70%) Marketing
4 8 (3.70%) Pharmaceutical
5 5 (2.31%) Retail
5 5 (2.31%) Online Betting
6 3 (1.39%) Financial Institution
7 2 (0.93%) Law
7 2 (0.93%) Legal
8 1 (0.46%) Front Office
Job Titles
1 149 (68.98%) Developer
2 49 (22.69%) Analyst
3 46 (21.30%) Business Intelligence Developer
4 39 (18.06%) Cognos Developer
5 35 (16.20%) Data Warehouse Developer
5 35 (16.20%) Cognos BI Developer
6 31 (14.35%) Data Analyst
7 28 (12.96%) Developer Analyst
8 19 (8.80%) Architect
9 18 (8.33%) ETL Developer
10 16 (7.41%) Data Architect
11 15 (6.94%) Data Warehouse Analyst
11 15 (6.94%) SQL Developer
12 13 (6.02%) Consultant
13 11 (5.09%) SQL Data Analyst
14 9 (4.17%) MI Analyst
15 8 (3.70%) Business Analyst
15 8 (3.70%) Business Intelligence Consultant
16 7 (3.24%) Oracle Developer
16 7 (3.24%) .NET Developer
Libraries, Frameworks & Software Standards
1 26 (12.04%) .NET
2 20 (9.26%) XML
3 9 (4.17%) ASP.NET
4 8 (3.70%) ASP.NET MVC
4 8 (3.70%) NHibernate
4 8 (3.70%) .NET Framework
4 8 (3.70%) WCF
4 8 (3.70%) ADO.NET
4 8 (3.70%) Web Services
5 6 (2.78%) SOAP
6 5 (2.31%) HTML
6 5 (2.31%) LINQ
7 4 (1.85%) HTML5
7 4 (1.85%) ASP.NET MVC 2
7 4 (1.85%) ADO.NET Entity Framework
7 4 (1.85%) REST
7 4 (1.85%) AngularJS
7 4 (1.85%) ASP.NET MVC 4
7 4 (1.85%) Kendo UI
7 4 (1.85%) WPF
Miscellaneous
1 37 (17.13%) Data Integration
2 30 (13.89%) Analytical Skills
3 13 (6.02%) Data Structures
4 12 (5.56%) Computer Science
5 10 (4.63%) Mathematics
6 7 (3.24%) Management Information System
6 7 (3.24%) Replication
6 7 (3.24%) Visualisation
7 4 (1.85%) FMCG
7 4 (1.85%) Derivative
7 4 (1.85%) Client/Server
7 4 (1.85%) Clustering
8 3 (1.39%) Statistics
9 2 (0.93%) Hedge funds
9 2 (0.93%) Performance Metrics
9 2 (0.93%) Taxonomies
9 2 (0.93%) Ontologies
9 2 (0.93%) Freedom of Information
10 1 (0.46%) NHS
10 1 (0.46%) iSeries
Operating Systems
1 13 (6.02%) UNIX
2 10 (4.63%) Windows
3 7 (3.24%) Linux
4 2 (0.93%) Windows Server 2008
4 2 (0.93%) Windows Server 2003
Processes & Methodologies
1 146 (67.59%) ETL
2 145 (67.13%) Business Intelligence
3 94 (43.52%) Data Modelling
4 48 (22.22%) Kimball Methodology
5 39 (18.06%) Agile Software Development
6 33 (15.28%) Dimensional Modelling
7 23 (10.65%) Scrum
8 20 (9.26%) Release Management
9 17 (7.87%) Data Analysis
10 15 (6.94%) Performance Tuning
11 14 (6.48%) Data Architecture
11 14 (6.48%) Analytics
11 14 (6.48%) Data Cleansing
12 13 (6.02%) Refactoring
13 12 (5.56%) Data Management
13 12 (5.56%) Logical Data Model
14 11 (5.09%) ITIL
14 11 (5.09%) Time Management
15 10 (4.63%) Performance Management
16 9 (4.17%) Requirements Analysis
Programming Languages
1 151 (69.91%) SQL
2 76 (35.19%) T-SQL
3 22 (10.19%) C#
4 16 (7.41%) PL/SQL
5 12 (5.56%) VBA
6 8 (3.70%) Python
7 6 (2.78%) Shell Script
8 4 (1.85%) VB.NET
9 3 (1.39%) Java
9 3 (1.39%) R
10 1 (0.46%) Embedded C
10 1 (0.46%) Perl
10 1 (0.46%) C++
10 1 (0.46%) C
10 1 (0.46%) PowerShell
Qualifications
1 22 (10.19%) Degree
2 6 (2.78%) Microsoft Certification
3 4 (1.85%) Security Cleared
3 4 (1.85%) MCP
4 2 (0.93%) Six Sigma Green Belt
4 2 (0.93%) ISTQB
4 2 (0.93%) MCSA
4 2 (0.93%) ISEB
5 1 (0.46%) PMP
5 1 (0.46%) PMI Certification
Quality Assurance & Compliance
1 8 (3.70%) Solvency II
2 4 (1.85%) Data Quality
3 2 (0.93%) QA
System Software
1 1 (0.46%) Oracle RAC
Systems Management
1 6 (2.78%) Oracle EDQ
Vendors
1 88 (40.74%) Oracle
2 77 (35.65%) Microsoft
3 56 (25.93%) IBM
4 50 (23.15%) Cognos
5 14 (6.48%) Business Objects
6 13 (6.02%) Tableau
7 12 (5.56%) Informatica
7 12 (5.56%) Teradata
8 10 (4.63%) SAP
9 4 (1.85%) Netezza
9 4 (1.85%) Sybase
10 2 (0.93%) Red Gate
11 1 (0.46%) MicroStrategy
11 1 (0.46%) Greenplum
11 1 (0.46%) Vertica
11 1 (0.46%) Talend
11 1 (0.46%) Cloudera
North West London
Vadis People
Salary: £45,000-£50,000
Posted: 2 days ago
City, London
Parallel Consulting
Salary: £38000 - £48000 per annum + Bonus
Posted: 2 days ago
London
Bridge Noble
Salary: £50000 - £55000 per annum + Benefits
Posted: 3 days ago
City, London
Ashdown IT
Salary: £45000 - £55000 per annum + bonus & benefits
Posted: 5 days ago
Uxbridge
Ampersand Consulting
Salary: £40000 - £48000 per annum + Benefits
Posted: 6 days ago
City of London
NFP Group Ltd
Salary: £55000 - £75000 per annum
Posted: 19 days ago
East London
Coral Racing Ltd
Salary: From £50,000 to £65,000 per annum (experience dependent) + bonus + ben
Posted: 23 days ago