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

Location
3 months to
22 Aug 2014
Same period 2013 Same period 2012
Star Schema
Rank 762 769 785
Rank change year-on-year
+7 +16
Permanent jobs citing Star Schema 142 102 116
As % of all permanent IT jobs located in the UK 0.12% 0.094% 0.099%
As % of the Database & Business Intelligence category 0.39% 0.30% 0.32%
Number of salaries quoted 117 74 94
Average salary £50,000 £42,500 £50,000
Average salary % change year-on-year
+17.64% -15.00%
90% offered a salary of more than £37,000 £35,000 £37,500
10% offered a salary of more than £70,000 £60,000 £90,000
UK excluding London average salary £46,250 £41,000 £42,500
% change year-on-year
+12.80% -3.52%

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
36164 34220 36263
As % of all permanent IT jobs located in the UK 30.87% 31.48% 30.95%
Number of salaries quoted 30535 29567 31917
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 £65,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 22 August 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 August 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 +40 137 £50,000 +11.11% 12
South East +12 55 £50,000 +17.64%
London -9 36 £60,000 +9.09% 7
Hampshire +1 21 £46,250 +12.80%
City of London +1 15 £67,500 +35.00% 1
Berkshire +2 12 £62,500 +13.63%
Reading +9 10 £60,000 +9.09%
East Midlands -7 10 £42,500 +6.25% 2
West Midlands -3 9 £27,850 -14.30% 1
West Yorkshire -27 9 £45,000 +20.00%
Yorkshire -28 9 £45,000 +20.00%
West Sussex - 9 £60,000 -
East of England +10 8 - - 1
Surrey +4 8 £45,000 -5.26%
Nottinghamshire +4 8 £46,250 +15.62%
Hertfordshire +2 8 - - 1
Nottingham -6 8 £46,250 +15.62%
Crawley - 8 £60,000 -
North West -14 7 £37,500 +15.38% 1
Woking - 7 £45,000 -
Warwickshire +18 6 £27,850 -14.30% 1
Nuneaton -4 6 £27,850 -14.30% 1
Halifax - 6 £45,000 -
Manchester -1 4 £37,500 +15.38%
Leeds - 3 £52,500 -
Derby - 3 £35,000 - 1
Derbyshire - 3 £35,000 - 2
South West -19 2 £70,000 +75.00%
Cumbria - 2 £31,627 - 1
Worcester - 2 £40,000 -

Star Schema
Top 30 Related IT Skills

For the 6 months to 22 August 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 210 (82.03%) Business Intelligence
2 191 (74.61%) Data Warehouse
3 177 (69.14%) SQL Server
4 169 (66.02%) SQL
5 160 (62.50%) SQL Server Integration Services
6 156 (60.94%) ETL
7 117 (45.70%) Data Modelling
8 107 (41.80%) Kimball Methodology
9 101 (39.45%) SQL Server Reporting Services
10 85 (33.20%) Oracle
11 76 (29.69%) T-SQL
11 76 (29.69%) SQL Server Analysis Services
12 74 (28.91%) Microsoft
13 72 (28.13%) Finance
14 68 (26.56%) OLAP
15 65 (25.39%) SQL Server 2008
16 60 (23.44%) MS Excel
17 59 (23.05%) Cognos
17 59 (23.05%) Relational Database
18 55 (21.48%) Dimensional Modelling
19 49 (19.14%) Data Mart
20 39 (15.23%) IBM
21 37 (14.45%) Inmon Methodology
22 36 (14.06%) RDBMS
23 35 (13.67%) Snowflake Schema
23 35 (13.67%) Cognos Framework Manager
24 33 (12.89%) Agile Software Development
25 30 (11.72%) Oracle Database
26 29 (11.33%) Cognos Business Intelligence
27 28 (10.94%) Data Management

Star Schema
Top Related IT Skills by Category

For the 6 months to 22 August 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.52%) SAS
2 5 (1.95%) MQSeries
2 5 (1.95%) SharePoint
Applications
1 60 (23.44%) MS Excel
2 3 (1.17%) PowerPivot
3 1 (0.39%) MS PowerPoint
Business Applications
1 29 (11.33%) Cognos Business Intelligence
2 19 (7.42%) Oracle EBS
3 4 (1.56%) Cognos TM1
4 2 (0.78%) Cognos Controller
5 1 (0.39%) SAP ERP
Cloud Services
1 2 (0.78%) Office 365
2 1 (0.39%) Amazon AWS
2 1 (0.39%) SaaS
Communications & Networking
1 2 (0.78%) TCP/IP
2 1 (0.39%) SAN
2 1 (0.39%) Broadband
2 1 (0.39%) FTP
Database & Business Intelligence
1 191 (74.61%) Data Warehouse
2 177 (69.14%) SQL Server
3 160 (62.50%) SQL Server Integration Services
4 101 (39.45%) SQL Server Reporting Services
5 76 (29.69%) SQL Server Analysis Services
6 68 (26.56%) OLAP
7 65 (25.39%) SQL Server 2008
8 59 (23.05%) Relational Database
9 49 (19.14%) Data Mart
10 36 (14.06%) RDBMS
11 35 (13.67%) Snowflake Schema
11 35 (13.67%) Cognos Framework Manager
12 30 (11.72%) Oracle Database
13 28 (10.94%) Cognos Report Studio
14 25 (9.77%) Oracle BI EE
14 25 (9.77%) Oracle Reports
15 22 (8.59%) Data Mining
16 21 (8.20%) Crystal Reports
17 20 (7.81%) SQL Server 2012
17 20 (7.81%) Cognos Analysis Studio
Development Applications
1 21 (8.20%) ERwin
2 5 (1.95%) Team Foundation Server
2 5 (1.95%) Talend Open Studio
3 3 (1.17%) Git (software)
3 3 (1.17%) Subversion
4 1 (0.39%) Oracle Forms
4 1 (0.39%) Visual Studio
General
1 72 (28.13%) Finance
2 19 (7.42%) Banking
3 14 (5.47%) Telecoms
4 9 (3.52%) Marketing
5 6 (2.34%) Pharmaceutical
6 5 (1.95%) Legal
7 4 (1.56%) Advertising
8 3 (1.17%) Manufacturing
8 3 (1.17%) Aerospace
8 3 (1.17%) Retail
9 2 (0.78%) Automotive
9 2 (0.78%) Law
10 1 (0.39%) Publishing
10 1 (0.39%) Games
10 1 (0.39%) Back Office
10 1 (0.39%) German Language
10 1 (0.39%) Investment Banking
Job Titles
1 166 (64.84%) Developer
2 58 (22.66%) Business Intelligence Developer
3 35 (13.67%) SQL Developer
4 30 (11.72%) Cognos Developer
4 30 (11.72%) Consultant
5 29 (11.33%) Analyst
6 28 (10.94%) Business Intelligence Consultant
7 27 (10.55%) Data Warehouse Developer
8 22 (8.59%) ETL Developer
9 21 (8.20%) Business Developer
10 18 (7.03%) Data Modeller
11 17 (6.64%) Cognos BI Developer
12 15 (5.86%) Senior Developer
12 15 (5.86%) Report Developer
13 13 (5.08%) Architect
13 13 (5.08%) SQL Server Developer
14 11 (4.30%) OBIEE Developer
14 11 (4.30%) Business Analyst
14 11 (4.30%) Oracle Developer
14 11 (4.30%) Data Manager
Libraries, Frameworks & Software Standards
1 25 (9.77%) XML
2 13 (5.08%) MDX
3 12 (4.69%) .NET
4 9 (3.52%) CSS
4 9 (3.52%) SOAP
4 9 (3.52%) HTML
5 4 (1.56%) Web Services
6 2 (0.78%) XSLT
7 1 (0.39%) WCF
7 1 (0.39%) WPF
7 1 (0.39%) Silverlight
Miscellaneous
1 27 (10.55%) Data Integration
2 18 (7.03%) Management Information System
3 12 (4.69%) Computer Science
4 10 (3.91%) Data Extraction
5 6 (2.34%) Replication
6 5 (1.95%) NHS
6 5 (1.95%) Visualisation
6 5 (1.95%) Derivative
7 4 (1.56%) Hedge funds
8 2 (0.78%) Open Source
8 2 (0.78%) Client/Server
9 1 (0.39%) Online Games
9 1 (0.39%) Reference Data
9 1 (0.39%) Statistics
Operating Systems
1 8 (3.13%) UNIX
2 4 (1.56%) Windows
2 4 (1.56%) Linux
Processes & Methodologies
1 210 (82.03%) Business Intelligence
2 156 (60.94%) ETL
3 117 (45.70%) Data Modelling
4 107 (41.80%) Kimball Methodology
5 55 (21.48%) Dimensional Modelling
6 37 (14.45%) Inmon Methodology
7 33 (12.89%) Agile Software Development
8 28 (10.94%) Data Management
9 27 (10.55%) Performance Tuning
10 25 (9.77%) Data Mapping
11 22 (8.59%) Data Architecture
12 19 (7.42%) Analytics
12 19 (7.42%) Time Management
13 18 (7.03%) Release Management
13 18 (7.03%) Master Data Management
14 16 (6.25%) Refactoring
14 16 (6.25%) Business Analysis
14 16 (6.25%) Data Analysis
14 16 (6.25%) Disaster Recovery
15 12 (4.69%) Unit Testing
Programming Languages
1 169 (66.02%) SQL
2 76 (29.69%) T-SQL
3 23 (8.98%) PL/SQL
4 16 (6.25%) C#
5 9 (3.52%) Java
5 9 (3.52%) JavaScript
6 8 (3.13%) Python
7 5 (1.95%) C
7 5 (1.95%) Data Analysis Expressions (DAX)
8 4 (1.56%) PowerShell
8 4 (1.56%) VB
9 3 (1.17%) Shell Script
10 2 (0.78%) XPath
11 1 (0.39%) Perl
Qualifications
1 19 (7.42%) Degree
2 3 (1.17%) ISEB
2 3 (1.17%) Microsoft Certification
2 3 (1.17%) MCSE
2 3 (1.17%) MCSA
2 3 (1.17%) NVQ Level 3
3 2 (0.78%) ISTQB
Quality Assurance & Compliance
1 3 (1.17%) QA
1 3 (1.17%) Data Quality
System Software
1 2 (0.78%) Active Directory
Systems Management
1 1 (0.39%) Control-M
Vendors
1 85 (33.20%) Oracle
2 74 (28.91%) Microsoft
3 59 (23.05%) Cognos
4 39 (15.23%) IBM
5 21 (8.20%) Business Objects
6 19 (7.42%) SAP
7 16 (6.25%) Teradata
8 14 (5.47%) Informatica
9 10 (3.91%) Netezza
9 10 (3.91%) MicroStrategy
10 7 (2.73%) Tableau
11 5 (1.95%) Logi Analytics
11 5 (1.95%) Talend
12 4 (1.56%) Ab Initio
13 3 (1.17%) Sybase
14 2 (0.78%) Vertica
14 2 (0.78%) Trillium
15 1 (0.39%) Cognizant
15 1 (0.39%) Hyperion
15 1 (0.39%) Lattice Semiconductor
Cardiff
Hays IT - Uk Posting account
Salary: £30000.00 - £35000.00 per annum
Posted: Yesterday
Cardiff, South Glamorgan
Computer Recruiter Ltd
Salary: c.£35K (depending upon experience) + Excellent Benefits
Posted: 2 days ago
Derbyshire
Oscar Associates (UK) Ltd
Salary: £30000 - £42000 per annum
Posted: 4 days ago
Hatfield, Hertfordshire
Big Red Recruitment
Salary: £40000 - £45000 per annum
Posted: 4 days ago
Barrow-In-Furness, Cumbria
BAE Systems
Salary: £31000 - £45000 per annum
Posted: 5 days ago
Nuneaton, Warwickshire
Big Red Recruitment
Salary: £27850 per annum
Posted: 5 days ago
London
Progressive Recruitment
Salary: £60000 - £70000 per annum + competitive
Posted: 8 days ago
London
Progressive Recruitment
Salary: £60000 - £72000 per annum + competitive
Posted: 8 days ago
London
Progressive Recruitment
Salary: £45000 - £50000 per annum + car, pension, bonus, health
Posted: 8 days ago
London
Progressive Recruitment
Salary: £45000 - £46000 per annum + competitive
Posted: 8 days ago
Derby
Computer Futures
Salary: £40000 - £45000 per annum + Excellent Benefits
Posted: 10 days ago
London
Progressive Recruitment
Salary: £45000 - £60000 per annum + bonus, car allowance and pension
Posted: 22 days ago