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 14 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
14 Jul 2014
Same period 2013 Same period 2012
Star Schema
Rank 752 763 770
Rank change year-on-year
+11 +7
Permanent jobs citing Star Schema 144 109 126
As % of all permanent IT jobs located in the UK 0.12% 0.10% 0.11%
As % of the Database & Business Intelligence category 0.40% 0.32% 0.34%
Number of salaries quoted 124 81 105
Average salary £47,500 £41,000 £51,500
Average salary % change year-on-year
+15.85% -20.38%
90% offered a salary of more than £38,500 £35,200 £37,500
10% offered a salary of more than £65,000 £55,000 £87,500
UK excluding London average salary £45,000 £41,000 £42,500
% change year-on-year
+9.75% -3.52%
Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
36414 34092 36866
As % of all permanent IT jobs located in the UK 31.24% 31.28% 30.99%
Number of salaries quoted 31218 29530 32613
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 14 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 14 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 +21 135 £50,000 +17.64% 21
South East +21 54 £53,000 +17.77% 4
London -42 34 £60,000 +11.62% 9
Yorkshire -13 17 £45,000 +9.09% 2
West Yorkshire -25 17 £45,000 +9.09% 2
Hampshire -1 15 £47,500 +15.85% 2
Halifax - 15 £45,000 -
East Midlands -16 11 £42,500 +11.84% 3
City of London +9 10 £75,000 +66.66% 3
Nottinghamshire +6 10 £42,500 +11.84% 1
Nottingham +1 10 £42,500 +11.84% 1
Berkshire -6 10 £60,000 +20.00% 2
West Sussex - 10 £52,500 -
Surrey +5 8 £45,000 -
West Midlands +2 7 £40,000 +53.84% 1
Woking - 7 £45,000 -
Reading +2 6 £60,000 +20.00% 1
Crawley - 6 £60,000 -
North West - 6 £31,627 - 1
Wales - 4 £27,500 -
East Grinstead - 4 £45,000 -
Scotland -28 3 - -
West Wales - 3 £27,500 -
Barrow-in-Furness - 3 £31,627 -
Manchester - 3 £37,500 - 1
Swansea - 3 £27,500 -
Cumbria - 3 £31,627 -
Worcester - 3 £40,000 -
Worcestershire - 3 £40,000 -
Glasgow -19 2 - -

Star Schema
Top 30 Related IT Skills

For the 6 months to 14 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 197 (83.12%) Business Intelligence
2 187 (78.90%) Data Warehouse
3 159 (67.09%) SQL Server
4 147 (62.03%) SQL
5 145 (61.18%) ETL
6 138 (58.23%) SQL Server Integration Services
7 121 (51.05%) Kimball Methodology
8 115 (48.52%) Data Modelling
9 88 (37.13%) SQL Server Reporting Services
10 77 (32.49%) Microsoft
11 74 (31.22%) Oracle
12 69 (29.11%) SQL Server Analysis Services
13 65 (27.43%) Finance
14 60 (25.32%) MS Excel
15 59 (24.89%) Cognos
16 57 (24.05%) OLAP
17 55 (23.21%) Dimensional Modelling
18 54 (22.78%) T-SQL
19 52 (21.94%) Relational Database
20 48 (20.25%) SQL Server 2008
21 39 (16.46%) Data Mart
22 34 (14.35%) Agile Software Development
23 33 (13.92%) RDBMS
24 32 (13.50%) Snowflake Schema
24 32 (13.50%) Cognos Business Intelligence
24 32 (13.50%) Inmon Methodology
25 31 (13.08%) Oracle Database
26 30 (12.66%) Data Integration
27 29 (12.24%) Performance Tuning
27 29 (12.24%) Cognos Framework Manager

Star Schema
Top Related IT Skills by Category

For the 6 months to 14 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 6 (2.53%) SharePoint
1 6 (2.53%) SAS
2 5 (2.11%) MQSeries
Applications
1 60 (25.32%) MS Excel
2 3 (1.27%) PowerPivot
3 1 (0.42%) MS Office
3 1 (0.42%) S-PLUS
3 1 (0.42%) MS PowerPoint
Business Applications
1 32 (13.50%) Cognos Business Intelligence
2 18 (7.59%) Oracle EBS
3 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 187 (78.90%) Data Warehouse
2 159 (67.09%) SQL Server
3 138 (58.23%) SQL Server Integration Services
4 88 (37.13%) SQL Server Reporting Services
5 69 (29.11%) SQL Server Analysis Services
6 57 (24.05%) OLAP
7 52 (21.94%) Relational Database
8 48 (20.25%) SQL Server 2008
9 39 (16.46%) Data Mart
10 33 (13.92%) RDBMS
11 32 (13.50%) Snowflake Schema
12 31 (13.08%) Oracle Database
13 29 (12.24%) Cognos Framework Manager
14 23 (9.70%) SQL Server 2012
14 23 (9.70%) Oracle Reports
15 22 (9.28%) Data Mining
16 21 (8.86%) Oracle BI EE
17 20 (8.44%) Microsoft Analysis Services
18 19 (8.02%) PerformancePoint
19 17 (7.17%) Oracle Database 11g
Development Applications
1 23 (9.70%) ERwin
2 13 (5.49%) Talend Open Studio
3 7 (2.95%) Git (software)
3 7 (2.95%) Subversion
4 5 (2.11%) Team Foundation Server
5 1 (0.42%) Visual Studio
5 1 (0.42%) Oracle Forms
5 1 (0.42%) Toad
5 1 (0.42%) PowerBuilder
General
1 65 (27.43%) Finance
2 19 (8.02%) Banking
3 14 (5.91%) Telecoms
4 8 (3.38%) Marketing
5 5 (2.11%) Legal
6 4 (1.69%) Advertising
6 4 (1.69%) Pharmaceutical
7 3 (1.27%) Aerospace
7 3 (1.27%) Manufacturing
7 3 (1.27%) Retail
8 2 (0.84%) Automotive
9 1 (0.42%) Back Office
9 1 (0.42%) Publishing
9 1 (0.42%) Games
9 1 (0.42%) Investment Banking
9 1 (0.42%) German Language
Job Titles
1 144 (60.76%) Developer
2 47 (19.83%) Business Intelligence Developer
3 28 (11.81%) Consultant
3 28 (11.81%) SQL Developer
4 27 (11.39%) Analyst
5 26 (10.97%) Business Intelligence Consultant
6 25 (10.55%) Data Warehouse Developer
7 21 (8.86%) Cognos Developer
8 19 (8.02%) Data Modeller
9 18 (7.59%) Business Developer
10 16 (6.75%) ETL Developer
11 15 (6.33%) Report Developer
12 14 (5.91%) Architect
13 13 (5.49%) Senior Developer
13 13 (5.49%) OBIEE Developer
14 12 (5.06%) Business Analyst
14 12 (5.06%) SQL Server Developer
15 11 (4.64%) Database Developer
16 10 (4.22%) Data Architect
17 9 (3.80%) SQL Database Developer
Libraries, Frameworks & Software Standards
1 21 (8.86%) XML
2 15 (6.33%) MDX
3 10 (4.22%) .NET
4 8 (3.38%) CSS
4 8 (3.38%) HTML
5 6 (2.53%) SOAP
5 6 (2.53%) Web Services
6 2 (0.84%) XSLT
7 1 (0.42%) .NET Framework
7 1 (0.42%) WCF
7 1 (0.42%) WPF
7 1 (0.42%) Silverlight
7 1 (0.42%) ADO.NET Entity Framework
Miscellaneous
1 30 (12.66%) Data Integration
2 16 (6.75%) Management Information System
3 14 (5.91%) Data Extraction
4 12 (5.06%) Computer Science
5 10 (4.22%) Derivative
6 7 (2.95%) NHS
7 6 (2.53%) Replication
8 5 (2.11%) Visualisation
9 3 (1.27%) Client/Server
10 2 (0.84%) Open Source
10 2 (0.84%) Hedge funds
11 1 (0.42%) FMCG
11 1 (0.42%) Online Games
11 1 (0.42%) Reference Data
Operating Systems
1 5 (2.11%) UNIX
2 4 (1.69%) Windows
Processes & Methodologies
1 197 (83.12%) Business Intelligence
2 145 (61.18%) ETL
3 121 (51.05%) Kimball Methodology
4 115 (48.52%) Data Modelling
5 55 (23.21%) Dimensional Modelling
6 34 (14.35%) Agile Software Development
7 32 (13.50%) Inmon Methodology
8 29 (12.24%) Performance Tuning
9 27 (11.39%) Data Management
10 24 (10.13%) Data Mapping
11 20 (8.44%) Analytics
11 20 (8.44%) Master Data Management
12 18 (7.59%) Business Analysis
13 17 (7.17%) Data Architecture
13 17 (7.17%) Release Management
14 13 (5.49%) Disaster Recovery
15 12 (5.06%) Data Analysis
15 12 (5.06%) Data Cleansing
16 11 (4.64%) Unit Testing
17 10 (4.22%) Refactoring
Programming Languages
1 147 (62.03%) SQL
2 54 (22.78%) T-SQL
3 19 (8.02%) PL/SQL
4 14 (5.91%) C#
5 13 (5.49%) Java
6 8 (3.38%) JavaScript
6 8 (3.38%) Python
7 5 (2.11%) C
7 5 (2.11%) Data Analysis Expressions (DAX)
8 4 (1.69%) VB
9 3 (1.27%) PowerShell
10 2 (0.84%) XPath
11 1 (0.42%) R
11 1 (0.42%) MATLAB
11 1 (0.42%) VB.NET
11 1 (0.42%) Perl
Qualifications
1 18 (7.59%) Degree
2 3 (1.27%) NVQ Level 3
2 3 (1.27%) MCSE
2 3 (1.27%) MCSA
2 3 (1.27%) ISEB
2 3 (1.27%) Microsoft Certification
3 2 (0.84%) ISTQB
Quality Assurance & Compliance
1 3 (1.27%) Data Quality
2 2 (0.84%) QA
System Software
1 4 (1.69%) Active Directory
2 1 (0.42%) Oracle RAC
Systems Management
1 1 (0.42%) Control-M
Vendors
1 77 (32.49%) Microsoft
2 74 (31.22%) Oracle
3 59 (24.89%) Cognos
4 22 (9.28%) IBM
5 20 (8.44%) SAP
6 18 (7.59%) Business Objects
7 15 (6.33%) Informatica
8 13 (5.49%) Talend
9 11 (4.64%) MicroStrategy
10 10 (4.22%) Teradata
11 6 (2.53%) Netezza
11 6 (2.53%) Logi Analytics
12 5 (2.11%) Ab Initio
12 5 (2.11%) Tableau
13 4 (1.69%) Sybase
14 3 (1.27%) Hyperion
15 2 (0.84%) Vertica
15 2 (0.84%) Trillium
16 1 (0.42%) Siebel
16 1 (0.42%) Cognizant
Nottingham, Nottinghamshire
Big Red Recruitment
Salary: £40000 - £45000 per annum
Posted: 2 days ago
City, London
Client Server
Salary: £65k to £80k + bonus + benefits
Posted: 2 days ago
London
CLIENT SERVER
Salary: £65,000 - £80,000 per year
Posted: 2 days ago
Reading, Berkshire
Oxbridge Answers
Salary: 45-75k
Posted: 3 days ago
Kingston Upon Thames, Surrey
Avantia Insurance
Salary: Up to £65,000 per annum + Benefits
Posted: 3 days ago
Derbyshire
Oscar Associates (UK) Ltd
Salary: £30000 - £42000 per annum
Posted: 4 days ago
City, London
Connectus
Salary: £50000 - £60000 per annum + Bonus + Benefits
Posted: 5 days ago
Hampshire
Bridge Noble
Salary: £500 - £55000 per annum
Posted: 5 days ago
Manchester, Lancashire
Lorien Resourcing
Posted: 6 days ago
Birmingham, West Midlands (County)
Arden Resourcing Limited
Salary: From £40,000 to £45,000 per annum + Benefits
Posted: 6 days ago
Havant, Hampshire
SSE
Salary: From £42,023 to £53,718 per annum plus excellent benefits
Posted: 10 days ago
London
Bridge Noble
Salary: £50000 - £60000 per annum + Benefits
Posted: 13 days ago
City of London
Huxley Associates
Posted: 17 days ago
Derby, Derbyshire
Blues Point Ltd
Salary: From £25,000 to £40,000 per annum
Posted: 18 days ago
St. Albans
Deloitte
Salary: Excellent + package
Posted: 23 days ago
London
Progressive Recruitment
Salary: £50000 - £70000 per annum + Benefits
Posted: 26 days ago