The first table below looks at the demand 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 29 July 2014 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category.

Location
3 months to
29 Jul 2014
Same period 2013 Same period 2012
Star Schema
Rank 764 764 783
Rank change year-on-year
0 +19
Permanent jobs citing Star Schema 143 105 121
As % of all permanent IT jobs located in the UK 0.12% 0.097% 0.10%
As % of the Database & Business Intelligence category 0.39% 0.31% 0.33%
Number of salaries quoted 123 74 100
Average salary £50,000 £41,000 £52,500
Average salary % change year-on-year
+21.95% -21.90%
90% offered a salary of more than £36,250 £35,000 £37,500
10% offered a salary of more than £65,000 £55,000 £90,000
UK excluding London average salary £47,250 £41,000 £43,000
% change year-on-year
+15.24% -4.65%
Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
36269 33995 36515
As % of all permanent IT jobs located in the UK 31.03% 31.27% 30.97%
Number of salaries quoted 30978 29341 32185
Average salary £45,000 £42,500 £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 £65,000
UK excluding London average salary £40,000 £39,000 £38,000
% change year-on-year
+2.56% +2.63%

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 29 July 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 29 July 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 +10 135 £50,000 +17.64% 9
South East +40 58 £53,000 +23.25% 4
London -33 33 £60,000 +14.28% 2
Hampshire +13 19 £47,500 +15.85% 1
West Yorkshire -24 14 £45,000 +5.88%
Yorkshire -30 14 £45,000 +5.88%
East Midlands +2 12 £42,500 +11.84% 1
Berkshire +11 11 £60,000 +14.28% 3
Nottinghamshire +9 11 £42,500 +11.84%
Nottingham +1 11 £42,500 +11.84%
Halifax - 11 £45,000 -
City of London -1 10 £70,000 +40.00% 1
West Sussex - 10 £60,000 -
West Midlands +8 8 £37,500 +15.38% 1
Reading +1 8 £60,000 +14.28% 2
Surrey -5 8 £45,000 -5.26%
Woking - 7 £45,000 -
Crawley - 7 £60,000 -
North West +4 6 £37,500 +15.38% 1
Wales - 4 £27,500 - 1
Warwickshire +15 3 £27,850 -14.30% 1
Manchester +11 3 £37,500 +15.38% 1
South West -17 3 £70,000 +86.66%
Scotland -30 3 - -
West Wales - 3 £27,500 -
Worcester - 3 £40,000 -
Worcestershire - 3 £40,000 -
Nuneaton - 3 £27,850 - 1
Leeds - 3 £52,500 -
East Grinstead - 3 £45,000 -

Star Schema
Top 30 Related IT Skills

For the 6 months to 29 July 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 199 (83.61%) Business Intelligence
2 184 (77.31%) Data Warehouse
3 160 (67.23%) SQL Server
4 149 (62.61%) SQL
5 142 (59.66%) ETL
5 142 (59.66%) SQL Server Integration Services
6 111 (46.64%) Data Modelling
6 111 (46.64%) Kimball Methodology
7 93 (39.08%) SQL Server Reporting Services
8 78 (32.77%) Oracle
9 75 (31.51%) Microsoft
10 70 (29.41%) SQL Server Analysis Services
11 68 (28.57%) Finance
12 61 (25.63%) OLAP
13 60 (25.21%) Cognos
14 59 (24.79%) T-SQL
15 58 (24.37%) MS Excel
16 55 (23.11%) Dimensional Modelling
17 52 (21.85%) SQL Server 2008
18 51 (21.43%) Relational Database
19 43 (18.07%) Data Mart
20 34 (14.29%) Agile Software Development
20 34 (14.29%) Inmon Methodology
21 33 (13.87%) Snowflake Schema
22 32 (13.45%) RDBMS
22 32 (13.45%) Cognos Framework Manager
23 31 (13.03%) Oracle Database
23 31 (13.03%) IBM
24 30 (12.61%) Cognos Business Intelligence
25 28 (11.76%) Data Integration

Star Schema
Top Related IT Skills by Category

For the 6 months to 29 July 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 7 (2.94%) SAS
2 5 (2.10%) SharePoint
3 4 (1.68%) MQSeries
Applications
1 58 (24.37%) MS Excel
2 3 (1.26%) PowerPivot
3 1 (0.42%) MS PowerPoint
Business Applications
1 30 (12.61%) Cognos Business Intelligence
2 19 (7.98%) Oracle EBS
3 3 (1.26%) Cognos TM1
4 2 (0.84%) Cognos Controller
5 1 (0.42%) SAP ERP
Cloud Services
1 2 (0.84%) Office 365
2 1 (0.42%) Amazon AWS
2 1 (0.42%) SaaS
Communications & Networking
1 2 (0.84%) TCP/IP
2 1 (0.42%) SAN
2 1 (0.42%) Broadband
2 1 (0.42%) FTP
Database & Business Intelligence
1 184 (77.31%) Data Warehouse
2 160 (67.23%) SQL Server
3 142 (59.66%) SQL Server Integration Services
4 93 (39.08%) SQL Server Reporting Services
5 70 (29.41%) SQL Server Analysis Services
6 61 (25.63%) OLAP
7 52 (21.85%) SQL Server 2008
8 51 (21.43%) Relational Database
9 43 (18.07%) Data Mart
10 33 (13.87%) Snowflake Schema
11 32 (13.45%) RDBMS
11 32 (13.45%) Cognos Framework Manager
12 31 (13.03%) Oracle Database
13 25 (10.50%) Oracle Reports
14 24 (10.08%) Oracle BI EE
15 23 (9.66%) Cognos Report Studio
15 23 (9.66%) Data Mining
16 22 (9.24%) SQL Server 2012
17 19 (7.98%) Crystal Reports
18 18 (7.56%) PerformancePoint
Development Applications
1 22 (9.24%) ERwin
2 11 (4.62%) Talend Open Studio
3 7 (2.94%) Git (software)
3 7 (2.94%) Subversion
4 5 (2.10%) Team Foundation Server
5 1 (0.42%) Visual Studio
5 1 (0.42%) Oracle Forms
General
1 68 (28.57%) Finance
2 18 (7.56%) Banking
3 14 (5.88%) Telecoms
4 7 (2.94%) Marketing
5 5 (2.10%) Legal
6 4 (1.68%) Pharmaceutical
6 4 (1.68%) Advertising
7 3 (1.26%) Retail
7 3 (1.26%) Manufacturing
7 3 (1.26%) Aerospace
8 2 (0.84%) Automotive
9 1 (0.42%) Law
9 1 (0.42%) Back Office
9 1 (0.42%) Investment Banking
9 1 (0.42%) Publishing
9 1 (0.42%) Games
9 1 (0.42%) German Language
Job Titles
1 146 (61.34%) Developer
2 51 (21.43%) Business Intelligence Developer
3 31 (13.03%) SQL Developer
4 28 (11.76%) Consultant
5 27 (11.34%) Business Intelligence Consultant
5 27 (11.34%) Analyst
5 27 (11.34%) Cognos Developer
6 24 (10.08%) Data Warehouse Developer
7 21 (8.82%) Business Developer
8 19 (7.98%) Data Modeller
9 15 (6.30%) Report Developer
10 14 (5.88%) ETL Developer
10 14 (5.88%) Architect
11 13 (5.46%) Senior Developer
11 13 (5.46%) OBIEE Developer
12 12 (5.04%) Cognos BI Developer
12 12 (5.04%) Business Analyst
12 12 (5.04%) SQL Server Developer
13 10 (4.20%) Data Architect
13 10 (4.20%) Database Developer
Libraries, Frameworks & Software Standards
1 23 (9.66%) XML
2 14 (5.88%) MDX
3 11 (4.62%) .NET
4 9 (3.78%) CSS
4 9 (3.78%) HTML
5 7 (2.94%) SOAP
6 6 (2.52%) Web Services
7 2 (0.84%) XSLT
8 1 (0.42%) .NET Framework
8 1 (0.42%) WCF
8 1 (0.42%) WPF
8 1 (0.42%) Silverlight
8 1 (0.42%) ADO.NET Entity Framework
Miscellaneous
1 28 (11.76%) Data Integration
2 17 (7.14%) Management Information System
3 13 (5.46%) Computer Science
4 12 (5.04%) Data Extraction
5 9 (3.78%) Derivative
6 6 (2.52%) Replication
6 6 (2.52%) NHS
6 6 (2.52%) Visualisation
7 3 (1.26%) Client/Server
8 2 (0.84%) Open Source
8 2 (0.84%) Hedge funds
9 1 (0.42%) FMCG
9 1 (0.42%) Statistics
9 1 (0.42%) Online Games
9 1 (0.42%) Reference Data
Operating Systems
1 6 (2.52%) UNIX
2 4 (1.68%) Windows
3 1 (0.42%) Linux
Processes & Methodologies
1 199 (83.61%) Business Intelligence
2 142 (59.66%) ETL
3 111 (46.64%) Data Modelling
3 111 (46.64%) Kimball Methodology
4 55 (23.11%) Dimensional Modelling
5 34 (14.29%) Inmon Methodology
5 34 (14.29%) Agile Software Development
6 28 (11.76%) Performance Tuning
7 27 (11.34%) Data Management
8 25 (10.50%) Data Mapping
9 21 (8.82%) Analytics
10 20 (8.40%) Master Data Management
11 18 (7.56%) Data Architecture
11 18 (7.56%) Release Management
12 17 (7.14%) Business Analysis
13 14 (5.88%) Data Analysis
13 14 (5.88%) Disaster Recovery
14 12 (5.04%) Unit Testing
14 12 (5.04%) Data Cleansing
15 11 (4.62%) Refactoring
Programming Languages
1 149 (62.61%) SQL
2 59 (24.79%) T-SQL
3 19 (7.98%) PL/SQL
4 16 (6.72%) C#
5 11 (4.62%) Java
6 9 (3.78%) JavaScript
7 8 (3.36%) Python
8 5 (2.10%) C
8 5 (2.10%) Data Analysis Expressions (DAX)
9 4 (1.68%) VB
10 3 (1.26%) PowerShell
11 2 (0.84%) XPath
12 1 (0.42%) Shell Script
12 1 (0.42%) VB.NET
12 1 (0.42%) Perl
Qualifications
1 20 (8.40%) Degree
2 3 (1.26%) NVQ Level 3
2 3 (1.26%) MCSE
2 3 (1.26%) MCSA
2 3 (1.26%) ISEB
2 3 (1.26%) Microsoft Certification
3 2 (0.84%) ISTQB
Quality Assurance & Compliance
1 3 (1.26%) Data Quality
2 2 (0.84%) QA
System Software
1 4 (1.68%) Active Directory
2 1 (0.42%) Oracle RAC
Systems Management
1 1 (0.42%) Control-M
Vendors
1 78 (32.77%) Oracle
2 75 (31.51%) Microsoft
3 60 (25.21%) Cognos
4 31 (13.03%) IBM
5 20 (8.40%) SAP
6 19 (7.98%) Business Objects
7 15 (6.30%) Informatica
8 13 (5.46%) Teradata
9 11 (4.62%) MicroStrategy
9 11 (4.62%) Talend
10 8 (3.36%) Netezza
11 7 (2.94%) Tableau
12 6 (2.52%) Logi Analytics
13 5 (2.10%) Ab Initio
14 4 (1.68%) Sybase
15 3 (1.26%) Hyperion
16 2 (0.84%) Vertica
16 2 (0.84%) Trillium
17 1 (0.42%) Siebel
17 1 (0.42%) Cognizant
Nuneaton, Warwickshire
Big Red Recruitment
Salary: £27850 per annum
Posted: 3 days ago
Reading, Berkshire
Oxbridge Answers
Salary: 40-60k
Posted: 3 days ago
Reading, Berkshire
Oxbridge Answers
Salary: 60-75k
Posted: 4 days ago
Derbyshire
Oscar Associates (UK) Ltd
Salary: £30000 - £42000 per annum
Posted: 4 days ago
Kingston Upon Thames, Surrey
Avantia Insurance
Salary: Up to £65,000 per annum + Benefits
Posted: 18 days ago
Hampshire
Bridge Noble
Salary: £500 - £55000 per annum
Posted: 20 days ago