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

Location
3 months to
22 Sep 2014
Same period 2013 Same period 2012
Star Schema
Rank 770 761 785
Rank change year-on-year
-9 +24
Permanent jobs citing Star Schema 124 116 105
As % of all permanent IT jobs located in the UK 0.11% 0.11% 0.089%
As % of the Database & Business Intelligence category 0.36% 0.34% 0.29%
Number of salaries quoted 102 88 82
Average salary £48,000 £50,000 £47,500
Average salary % change year-on-year
-4.00% +5.26%
90% offered a salary of more than £32,500 £37,500 £38,075
10% offered a salary of more than £70,000 £68,250 £85,000
UK excluding London average salary £47,500 £41,000 £45,000
% change year-on-year
+15.85% -8.88%

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
34758 33767 36490
As % of all permanent IT jobs located in the UK 30.44% 31.60% 31.05%
Number of salaries quoted 29205 29230 32132
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 £65,000
UK excluding London average salary £40,000 £40,000 £39,500
% change year-on-year
- +1.26%

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 22 September 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 22 September 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 +30 119 £50,000 - 19
South East +15 46 £48,000 +1.05% 6
London -21 38 £57,500 +4.54% 9
Hampshire +6 24 £47,500 +13.77% 2
City of London +2 17 £60,000 +11.62% 4
Berkshire +2 13 £60,000 -25.00% 2
Reading +1 13 £60,000 -25.00% 1
West Midlands -2 10 £27,850 -14.30% 1
Warwickshire +13 8 £27,850 -14.30% 1
East of England +2 8 - - 1
Nuneaton 0 8 £27,850 -14.30% 1
Hertfordshire -6 8 - - 1
North West -8 7 £37,500 +15.38%
East Midlands -7 6 £42,500 +6.25% 2
West Sussex - 6 £60,000 -
Crawley - 6 £60,000 -
Nottingham 0 4 £42,500 +6.25%
Nottinghamshire -2 4 £42,500 +6.25%
Manchester -4 4 £37,500 +15.38%
Derby - 3 £35,000 - 2
Derbyshire - 3 £35,000 - 2
South West -30 2 £61,250 +63.33%
West Yorkshire -40 2 £60,000 +60.00%
Yorkshire -50 2 £60,000 +60.00%
Worcestershire - 2 £42,250 -
Barrow-in-Furness - 2 £31,627 -
Borehamwood - 2 - -
Leeds - 2 £60,000 -
Redditch - 2 £42,250 -
Cumbria - 2 £31,627 -

Star Schema
Top 30 Related IT Skills

For the 6 months to 22 September 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 217 (82.20%) Business Intelligence
2 187 (70.83%) Data Warehouse
2 187 (70.83%) SQL Server
3 173 (65.53%) SQL
4 171 (64.77%) SQL Server Integration Services
5 156 (59.09%) ETL
6 129 (48.86%) Data Modelling
7 103 (39.02%) SQL Server Reporting Services
8 101 (38.26%) Kimball Methodology
9 99 (37.50%) Oracle
10 81 (30.68%) T-SQL
11 80 (30.30%) SQL Server Analysis Services
12 77 (29.17%) Microsoft
13 69 (26.14%) Finance
13 69 (26.14%) SQL Server 2008
14 66 (25.00%) OLAP
15 65 (24.62%) Relational Database
16 64 (24.24%) Cognos
17 58 (21.97%) MS Excel
18 54 (20.45%) Data Mart
18 54 (20.45%) Dimensional Modelling
19 52 (19.70%) Agile Software Development
20 50 (18.94%) IBM
21 43 (16.29%) Cognos Framework Manager
22 38 (14.39%) Inmon Methodology
23 37 (14.02%) RDBMS
24 36 (13.64%) Cognos Business Intelligence
24 36 (13.64%) Cognos Report Studio
25 30 (11.36%) Snowflake Schema
25 30 (11.36%) Data Management

Star Schema
Top Related IT Skills by Category

For the 6 months to 22 September 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 9 (3.41%) SAS
2 8 (3.03%) SharePoint
3 6 (2.27%) MQSeries
Applications
1 58 (21.97%) MS Excel
2 4 (1.52%) PowerPivot
3 3 (1.14%) MS Office
4 1 (0.38%) MS PowerPoint
Business Applications
1 36 (13.64%) Cognos Business Intelligence
2 23 (8.71%) Oracle EBS
3 4 (1.52%) Cognos TM1
4 2 (0.76%) Cognos Controller
5 1 (0.38%) SAP ERP
Cloud Services
1 2 (0.76%) Office 365
2 1 (0.38%) Amazon AWS
Communications & Networking
1 2 (0.76%) TCP/IP
2 1 (0.38%) FTP
Database & Business Intelligence
1 187 (70.83%) Data Warehouse
1 187 (70.83%) SQL Server
2 171 (64.77%) SQL Server Integration Services
3 103 (39.02%) SQL Server Reporting Services
4 80 (30.30%) SQL Server Analysis Services
5 69 (26.14%) SQL Server 2008
6 66 (25.00%) OLAP
7 65 (24.62%) Relational Database
8 54 (20.45%) Data Mart
9 43 (16.29%) Cognos Framework Manager
10 37 (14.02%) RDBMS
11 36 (13.64%) Cognos Report Studio
12 30 (11.36%) Snowflake Schema
13 29 (10.98%) Oracle Database
14 28 (10.61%) Oracle BI EE
14 28 (10.61%) Oracle Reports
15 25 (9.47%) Cognos Metric Studio
16 23 (8.71%) Crystal Reports
17 22 (8.33%) Cognos Analysis Studio
17 22 (8.33%) Data Mining
Development Applications
1 20 (7.58%) ERwin
2 9 (3.41%) Team Foundation Server
3 3 (1.14%) SQL Server Management Studio (SSMS)
3 3 (1.14%) Subversion
3 3 (1.14%) VSS/SourceSafe
4 1 (0.38%) Oracle Forms
4 1 (0.38%) Visual Studio
General
1 69 (26.14%) Finance
2 22 (8.33%) Banking
3 16 (6.06%) Telecoms
4 10 (3.79%) Marketing
5 9 (3.41%) Pharmaceutical
6 5 (1.89%) Legal
7 3 (1.14%) Retail
7 3 (1.14%) Manufacturing
7 3 (1.14%) Aerospace
8 2 (0.76%) Automotive
8 2 (0.76%) Law
8 2 (0.76%) Online Betting
9 1 (0.38%) German Language
9 1 (0.38%) Investment Banking
9 1 (0.38%) Advertising
9 1 (0.38%) Publishing
9 1 (0.38%) Back Office
Job Titles
1 172 (65.15%) Developer
2 65 (24.62%) Business Intelligence Developer
3 38 (14.39%) Cognos Developer
4 33 (12.50%) SQL Developer
5 31 (11.74%) Analyst
5 31 (11.74%) Consultant
6 27 (10.23%) Business Intelligence Consultant
6 27 (10.23%) Cognos BI Developer
7 24 (9.09%) Data Warehouse Developer
8 22 (8.33%) Business Developer
9 19 (7.20%) ETL Developer
10 18 (6.82%) Data Modeller
11 15 (5.68%) Report Developer
12 13 (4.92%) SQL Server Developer
12 13 (4.92%) Architect
12 13 (4.92%) Senior Developer
13 12 (4.55%) Oracle Developer
13 12 (4.55%) Developer Analyst
14 11 (4.17%) Data Manager
14 11 (4.17%) Data Analyst
Libraries, Frameworks & Software Standards
1 23 (8.71%) XML
2 19 (7.20%) .NET
3 13 (4.92%) MDX
4 9 (3.41%) CSS
4 9 (3.41%) SOAP
4 9 (3.41%) HTML
5 2 (0.76%) XSLT
5 2 (0.76%) WCF
6 1 (0.38%) ADO.NET Entity Framework
6 1 (0.38%) ASP.NET MVC 2
6 1 (0.38%) ASP.NET MVC
6 1 (0.38%) WPF
6 1 (0.38%) WF
6 1 (0.38%) Silverlight
6 1 (0.38%) .NET Framework
6 1 (0.38%) NHibernate
6 1 (0.38%) DAO
6 1 (0.38%) Web Services
6 1 (0.38%) ADO.NET
6 1 (0.38%) ASP.NET
Miscellaneous
1 25 (9.47%) Data Integration
2 23 (8.71%) Analytical Skills
3 17 (6.44%) Management Information System
4 15 (5.68%) Computer Science
5 8 (3.03%) Data Extraction
6 6 (2.27%) Replication
7 5 (1.89%) NHS
7 5 (1.89%) Client/Server
8 4 (1.52%) Derivative
8 4 (1.52%) Hedge funds
9 3 (1.14%) Visualisation
9 3 (1.14%) Mathematics
10 2 (0.76%) Open Source
11 1 (0.38%) Enterprise Software
11 1 (0.38%) iSeries
11 1 (0.38%) Reference Data
11 1 (0.38%) Statistics
Operating Systems
1 11 (4.17%) UNIX
2 8 (3.03%) Windows
3 7 (2.65%) Linux
Processes & Methodologies
1 217 (82.20%) Business Intelligence
2 156 (59.09%) ETL
3 129 (48.86%) Data Modelling
4 101 (38.26%) Kimball Methodology
5 54 (20.45%) Dimensional Modelling
6 52 (19.70%) Agile Software Development
7 38 (14.39%) Inmon Methodology
8 30 (11.36%) Data Management
9 25 (9.47%) Data Mapping
10 23 (8.71%) Performance Tuning
11 22 (8.33%) Release Management
12 21 (7.95%) Data Architecture
13 19 (7.20%) Time Management
14 18 (6.82%) Data Analysis
14 18 (6.82%) Master Data Management
15 16 (6.06%) Disaster Recovery
15 16 (6.06%) Refactoring
16 15 (5.68%) Scrum
17 14 (5.30%) Analytics
18 13 (4.92%) Continuous Improvement
Programming Languages
1 173 (65.53%) SQL
2 81 (30.68%) T-SQL
3 27 (10.23%) PL/SQL
4 21 (7.95%) C#
5 9 (3.41%) JavaScript
6 8 (3.03%) Java
7 6 (2.27%) C
7 6 (2.27%) Python
7 6 (2.27%) Shell Script
8 4 (1.52%) VB
8 4 (1.52%) PowerShell
8 4 (1.52%) Data Analysis Expressions (DAX)
9 2 (0.76%) XPath
10 1 (0.38%) Perl
10 1 (0.38%) C++
10 1 (0.38%) Embedded C
Qualifications
1 23 (8.71%) Degree
2 4 (1.52%) Microsoft Certification
3 3 (1.14%) NVQ Level 3
3 3 (1.14%) MCSE
3 3 (1.14%) MCSA
4 1 (0.38%) ISTQB
4 1 (0.38%) MCP
4 1 (0.38%) ISEB
Quality Assurance & Compliance
1 3 (1.14%) QA
2 2 (0.76%) Data Quality
Systems Management
1 1 (0.38%) Control-M
Vendors
1 99 (37.50%) Oracle
2 77 (29.17%) Microsoft
3 64 (24.24%) Cognos
4 50 (18.94%) IBM
5 22 (8.33%) Business Objects
6 21 (7.95%) SAP
7 15 (5.68%) Teradata
7 15 (5.68%) Informatica
8 10 (3.79%) Netezza
9 9 (3.41%) Tableau
10 8 (3.03%) MicroStrategy
11 4 (1.52%) Sybase
11 4 (1.52%) Logi Analytics
12 3 (1.14%) Ab Initio
13 2 (0.76%) Vertica
14 1 (0.38%) Cognizant
14 1 (0.38%) Trillium
Surrey
Nakama
Salary: From £50,000 to £55,000 per annum
Posted: 2 days ago
Nuneaton, Warwickshire
Big Red Recruitment
Salary: £27850 per annum
Posted: 2 days ago
Derby, Derbyshire
Oscar Associates (UK) Ltd
Salary: £36000 - £42000 per annum + Comprehensive benefits package
Posted: 4 days ago
South East
Venturi
Salary: £50000 - £85000 per annum + 15% bonus + Benefits
Posted: 5 days ago
London
set2recruit
Salary: £35000 - £70000 Per Annum bonus and car scheme
Posted: 6 days ago
London
CLIENT SERVER
Salary: £50k to £60k + benefits
Posted: 7 days ago
Glasgow, Lanarkshire
Wescot Credit Services Limited
Posted: 9 days ago
Derby, Derbyshire
Blues Point Ltd
Salary: From £25,000 to £40,000 per annum
Posted: 11 days ago
City of London
Progressive Recruitment
Salary: £70000 per annum + competitive
Posted: 13 days ago
City of London
Progressive Recruitment
Salary: £55000 per annum + competitive
Posted: 13 days ago
St. Albans
Deloitte
Salary: Excellent + package
Posted: 17 days ago
City of London
Progressive Recruitment
Salary: £55000 per annum + competitive
Posted: 26 days ago
London
Progressive Recruitment
Salary: £45000 - £55000 per annum + great benefits
Posted: 26 days ago