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

Location
3 months to
30 Jun 2015
Same period 2014 Same period 2013
Star Schema
Rank 734 790 783
Rank change year-on-year
+56 -7
Permanent jobs citing Star Schema 165 143 97
As % of all permanent IT jobs located in the UK 0.15% 0.12% 0.088%
As % of the Database & Business Intelligence category 0.47% 0.38% 0.28%
Number of salaries quoted 89 125 72
Average salary £48,000 £47,500 £42,500
Average salary % change year-on-year
+1.05% +11.76%
90% offered a salary of more than £37,500 £40,000 £35,300
10% offered a salary of more than £85,000 £65,000 £58,500
UK excluding London average salary £43,500 £45,000 £41,000
% change year-on-year
-3.33% +9.75%

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
34997 37588 34729
As % of all permanent IT jobs located in the UK 31.59% 31.26% 31.53%
Number of salaries quoted 29528 32340 30085
Average salary £47,500 £45,000 £42,500
Average salary % change year-on-year
+5.55% +5.88%
90% offered a salary of more than £32,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £70,000
UK excluding London average salary £42,000 £40,000 £38,000
% change year-on-year
+5.00% +5.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 30 June 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 30 June 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 +59 158 £48,000 -1.53% 12
London +82 100 £65,000 +8.33% 7
South East +13 42 £45,000 -10.00% 2
Hampshire +22 21 £43,500 -8.42%
Berkshire +3 11 £40,000 -27.27% 1
West Midlands -1 11 £36,500 -8.75% 1
Reading +3 10 £40,000 -33.33%
Surrey +13 6 £60,000 +33.33%
City of London +35 5 £85,000 +13.33% 6
Worcestershire -5 5 £36,500 -8.75%
Redditch - 5 £36,500 -
Redhill - 5 £60,000 -
Uxbridge - 4 £48,000 - 1
Yorkshire -9 3 £38,500 -14.44%
Staffordshire - 3 £41,500 - 1
Tamworth - 3 £41,500 - 1
Dorset +8 2 - -
Bournemouth -3 2 - -
Havant -4 2 - -
South West -8 2 - - 1
West Yorkshire -13 2 £40,500 -10.00%
Herefordshire - 2 - -
Middlesex - 2 £55,000 -
Wimbledon - 2 - -
Buckinghamshire - 2 £28,000 - 1
Milton Keynes - 2 £28,000 - 1
Leeds +7 1 £38,500 -14.44%
Halifax -10 1 £42,500 -5.55%
Birmingham -18 1 £80,000 +88.23%
Bromley - 1 £45,000 -

Star Schema
Top 30 Related IT Skills

For the 6 months to 30 June 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 191 (72.08%) Business Intelligence
2 181 (68.30%) SQL
3 176 (66.42%) Data Warehouse
4 174 (65.66%) SQL Server
5 163 (61.51%) SQL Server Integration Services
6 160 (60.38%) ETL
7 139 (52.45%) Data Modelling
8 129 (48.68%) Microsoft
9 118 (44.53%) Oracle
10 104 (39.25%) Finance
10 104 (39.25%) SQL Server Reporting Services
10 104 (39.25%) SQL Server Analysis Services
11 90 (33.96%) Kimball Methodology
11 90 (33.96%) Agile Software Development
12 81 (30.57%) Degree
13 74 (27.92%) T-SQL
14 70 (26.42%) Analytics
15 65 (24.53%) Analytical Skills
16 61 (23.02%) Cognos
16 61 (23.02%) SQL Server 2008
17 53 (20.00%) MS Excel
18 52 (19.62%) Performance Tuning
19 49 (18.49%) IBM
20 48 (18.11%) Computer Science
21 45 (16.98%) Data Analysis
21 45 (16.98%) Data Structures
21 45 (16.98%) Big Data
22 42 (15.85%) Data Management
23 41 (15.47%) OLAP
24 40 (15.09%) C#

Star Schema
Top Related IT Skills by Category

For the 6 months to 30 June 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 9 (3.40%) SharePoint
1 9 (3.40%) SAS
Applications
1 53 (20.00%) MS Excel
2 22 (8.30%) MS Office
3 10 (3.77%) Spreadsheet
4 7 (2.64%) MS Visio
5 6 (2.26%) PowerPivot
6 2 (0.75%) SPSS
7 1 (0.38%) MS PowerPoint
Business Applications
1 21 (7.92%) Cognos Business Intelligence
2 5 (1.89%) Cognos TM1
3 3 (1.13%) Oracle EBS
3 3 (1.13%) Dynamics CRM
4 1 (0.38%) SAP Oil and Gas
Cloud Services
1 4 (1.51%) Cloud Computing
2 1 (0.38%) Microsoft Azure
Communications & Networking
1 1 (0.38%) HTTP
1 1 (0.38%) TCP/IP
Database & Business Intelligence
1 176 (66.42%) Data Warehouse
2 174 (65.66%) SQL Server
3 163 (61.51%) SQL Server Integration Services
4 104 (39.25%) SQL Server Reporting Services
4 104 (39.25%) SQL Server Analysis Services
5 61 (23.02%) SQL Server 2008
6 45 (16.98%) Big Data
7 41 (15.47%) OLAP
8 36 (13.58%) Relational Database
9 34 (12.83%) Oracle Database
10 33 (12.45%) Oracle Reports
11 29 (10.94%) Oracle Database 11g
12 28 (10.57%) Microsoft Analysis Services
13 26 (9.81%) OLAP Cube
14 25 (9.43%) Data Mart
15 21 (7.92%) SQL Server 2005
15 21 (7.92%) Cognos Framework Manager
16 20 (7.55%) QlikView
17 19 (7.17%) Cognos Report Studio
17 19 (7.17%) Oracle OLAP
Development Applications
1 32 (12.08%) Visual Studio
2 22 (8.30%) SQL Server Management Studio (SSMS)
3 20 (7.55%) Team Foundation Server
4 19 (7.17%) ERwin
5 11 (4.15%) Subversion
6 8 (3.02%) Talend Open Studio
7 6 (2.26%) Toad
8 4 (1.51%) VSS/SourceSafe
9 3 (1.13%) TeamCity
9 3 (1.13%) MSBuild
10 2 (0.75%) HP UFT
10 2 (0.75%) FitNesse
10 2 (0.75%) Visual Studio Team System
General
1 104 (39.25%) Finance
2 24 (9.06%) Retail
3 23 (8.68%) Telecoms
4 14 (5.28%) Banking
5 13 (4.91%) Publishing
5 13 (4.91%) Front Office
6 10 (3.77%) Marketing
7 6 (2.26%) Billing
8 4 (1.51%) Advertising
9 2 (0.75%) Back Office
10 1 (0.38%) Electronics
10 1 (0.38%) Automotive
10 1 (0.38%) Legal
10 1 (0.38%) Manufacturing
10 1 (0.38%) Games
Job Titles
1 160 (60.38%) Developer
2 63 (23.77%) Analyst
3 62 (23.40%) Business Intelligence Developer
4 33 (12.45%) Business Developer
5 26 (9.81%) Architect
6 25 (9.43%) Data Analyst
7 24 (9.06%) Business Analyst
8 22 (8.30%) Data Architect
9 21 (7.92%) Senior Developer
9 21 (7.92%) .NET Developer
10 18 (6.79%) Business Intelligence Analyst
11 17 (6.42%) SQL Developer
11 17 (6.42%) Data Warehouse Developer
12 15 (5.66%) Consultant
13 14 (5.28%) Business Intelligence Consultant
13 14 (5.28%) Cognos Developer
13 14 (5.28%) Cognos BI Developer
14 12 (4.53%) Oracle Developer
14 12 (4.53%) Developer Analyst
15 10 (3.77%) ETL Developer
Libraries, Frameworks & Software Standards
1 38 (14.34%) .NET
2 27 (10.19%) Web Services
3 25 (9.43%) XML
4 24 (9.06%) ASP.NET
5 23 (8.68%) WCF
6 21 (7.92%) ASP.NET MVC
7 19 (7.17%) NHibernate
7 19 (7.17%) .NET Framework
8 18 (6.79%) DAO
8 18 (6.79%) WF
8 18 (6.79%) ASP.NET MVC 2
8 18 (6.79%) Entity Framework
9 10 (3.77%) Middleware
10 9 (3.40%) HTML
11 8 (3.02%) MDX
12 6 (2.26%) ADO.NET
13 5 (1.89%) HTML5
13 5 (1.89%) AngularJS
14 4 (1.51%) ASP.NET Web API
14 4 (1.51%) RESTful
Miscellaneous
1 65 (24.53%) Analytical Skills
2 48 (18.11%) Computer Science
3 45 (16.98%) Data Structures
4 37 (13.96%) Data Integration
5 32 (12.08%) Data Protection Act
5 32 (12.08%) Freedom of Information Act
5 32 (12.08%) Freedom of Information
6 30 (11.32%) Management Information System
7 14 (5.28%) Mathematics
8 8 (3.02%) Visualisation
9 7 (2.64%) Replication
10 4 (1.51%) Client/Server
10 4 (1.51%) Blog
10 4 (1.51%) Data Extraction
10 4 (1.51%) Statistics
11 3 (1.13%) Economics
12 2 (0.75%) Performance Metrics
12 2 (0.75%) Social Media
13 1 (0.38%) Data Centre
13 1 (0.38%) Clustering
Operating Systems
1 36 (13.58%) UNIX
2 33 (12.45%) Windows
3 10 (3.77%) Linux
4 2 (0.75%) Windows Server 2003
4 2 (0.75%) Windows Server 2008
Processes & Methodologies
1 191 (72.08%) Business Intelligence
2 160 (60.38%) ETL
3 139 (52.45%) Data Modelling
4 90 (33.96%) Agile Software Development
4 90 (33.96%) Kimball Methodology
5 70 (26.42%) Analytics
6 52 (19.62%) Performance Tuning
7 45 (16.98%) Data Analysis
8 42 (15.85%) Data Management
9 37 (13.96%) Project Management
10 36 (13.58%) Inmon Methodology
11 33 (12.45%) Scrum
12 32 (12.08%) Data Protection
13 29 (10.94%) Dimensional Modelling
14 26 (9.81%) Data Architecture
15 24 (9.06%) Data Security
16 20 (7.55%) UML
17 19 (7.17%) MVC
17 19 (7.17%) Release Management
17 19 (7.17%) Logical Data Model
Programming Languages
1 181 (68.30%) SQL
2 74 (27.92%) T-SQL
3 40 (15.09%) C#
4 30 (11.32%) PL/SQL
5 11 (4.15%) Shell Script
6 9 (3.40%) Python
6 9 (3.40%) VB.NET
7 8 (3.02%) R
8 7 (2.64%) Java
9 6 (2.26%) JavaScript
10 4 (1.51%) C
10 4 (1.51%) VBA
10 4 (1.51%) VB
11 1 (0.38%) XPath
11 1 (0.38%) PowerShell
Qualifications
1 81 (30.57%) Degree
2 23 (8.68%) Microsoft Certification
3 22 (8.30%) Security Cleared
4 18 (6.79%) MCP
5 13 (4.91%) DV Cleared
6 3 (1.13%) SC Cleared
6 3 (1.13%) MCITP
7 2 (0.75%) ISTQB
7 2 (0.75%) MCSA
7 2 (0.75%) ISEB
7 2 (0.75%) PMI Certification
7 2 (0.75%) Six Sigma Green Belt
8 1 (0.38%) PMP
Quality Assurance & Compliance
1 17 (6.42%) Data Quality
2 14 (5.28%) QA
3 4 (1.51%) Solvency II
System Software
1 4 (1.51%) VMware ESX
Systems Management
1 4 (1.51%) SCCM
1 4 (1.51%) Oracle EDQ
Vendors
1 129 (48.68%) Microsoft
2 118 (44.53%) Oracle
3 61 (23.02%) Cognos
4 49 (18.49%) IBM
5 40 (15.09%) Business Objects
6 38 (14.34%) Informatica
7 30 (11.32%) Tableau
8 22 (8.30%) Teradata
9 19 (7.17%) MicroStrategy
10 18 (6.79%) SAP
10 18 (6.79%) Sybase
11 12 (4.53%) Ab Initio
11 12 (4.53%) Trillium
12 9 (3.40%) Capita
13 8 (3.02%) Talend
14 6 (2.26%) Salesforce.com
14 6 (2.26%) Zuora
15 4 (1.51%) Cloudera
16 3 (1.13%) Red Gate
17 1 (0.38%) Netezza
Berkshire
Exposed Solutions
Salary: £30000 - £35000 per annum
Posted: Yesterday
City, London
Bond Mckenzie
Salary: From £55,000 to £75,000 per annum PLUS BONUS AND BENEFITS
Posted: 3 days ago
City, London
JM
Salary: £80000 - £90000 per annum + Bonus + Excellent Company Benefits
Posted: 3 days ago
Tamworth, Staffordshire
Big Red Recruitment
Salary: £41500 per annum + Non contrib Pension
Posted: 4 days ago
Uxbridge, Middlesex
Ampersand Consulting
Salary: £48000 per annum + Bonus and Benefits
Posted: 5 days ago
City, London
Involved Solutions Ltd
Salary: £38000 - £40000 per annum + Bonus + Benefits
Posted: 5 days ago
Milton Keynes, Buckinghamshire
Interact Consulting
Salary: 25-30k
Posted: 6 days ago
Gateshead
Real Staffing
Salary: £45000 - £50000 per annum + competitive
Posted: 7 days ago
City of London
First Point
Salary: £60000 - £70000 per annum
Posted: 26 days ago