The table below looks at the statistics for Star Schema skills in IT jobs advertised for the London region. Included is a guide to the average salaries offered in IT jobs that have cited Star Schema over the 3 months to 29 January 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
29 Jan 2015
Same period 2014 Same period 2013
Star Schema
Rank 572 574 554
Rank change year-on-year
+2 -20
Permanent jobs citing Star Schema 46 39 71
As % of all permanent IT jobs located in London 0.11% 0.091% 0.16%
As % of the Database & Business Intelligence category 0.39% 0.30% 0.52%
Number of salaries quoted 40 32 60
Average salary £44,000 £56,250 £47,500
Average salary % change year-on-year
-21.77% +18.42%
90% offered a salary of more than £42,450 £45,050 £35,000
10% offered a salary of more than £76,000 £67,250 £75,000
UK excluding London average salary £46,500 £45,000 £37,500
% change year-on-year
+3.33% +20.00%
Star Schema
England

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the London region.

Database & Business Intelligence Category
London
Permanent IT job ads with a match in the
Database & Business Intelligence category
11948 12972 13525
As % of all permanent IT jobs located in London 29.29% 30.23% 29.86%
Number of salaries quoted 10298 11067 11919
Average salary £55,000 £55,000 £50,000
Average salary % change year-on-year
- +10.00%
90% offered a salary of more than £37,500 £37,500 £35,000
10% offered a salary of more than £75,000 £70,000 £77,500
UK excluding London average salary £40,000 £40,000 £38,500
% change year-on-year
- +3.89%

Star Schema
Jobs Demand Trend in London

This chart provides a 3-month moving total of permanent IT jobs citing Star Schema across the London region as a proportion of the total demand within the Database & Business Intelligence category.

Star Schema Jobs Demand Trend in London

Star Schema
Salary Trend in London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Star Schema across the London region.

Star Schema Salary Trend in London

Star Schema
Salary Histogram in London

This chart provides a salary histogram for IT jobs citing Star Schema across the London region over the 3 months to 29 January 2015.

Star Schema Salary Histogram in London

Star Schema
Job Locations in London

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing Star Schema within the London region over the 3 months to 29 January 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
City of London +16 14 £43,000 -28.33% 7
Uxbridge - 6 £44,000 - 1
Croydon - 2 £37,500 -
Star Schema
England

Star Schema
Top 30 Related IT Skills in London

For the 6 months to 29 January 2015, IT jobs across the London region 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 79 (90.80%) SQL
2 75 (86.21%) Data Warehouse
3 72 (82.76%) ETL
4 48 (55.17%) SQL Server
5 47 (54.02%) Finance
6 44 (50.57%) Business Intelligence
7 43 (49.43%) SQL Server Integration Services
8 42 (48.28%) SQL Server Analysis Services
9 37 (42.53%) T-SQL
10 32 (36.78%) Oracle
11 29 (33.33%) Data Modelling
12 28 (32.18%) Microsoft
13 27 (31.03%) Agile Software Development
14 25 (28.74%) Kimball Methodology
15 24 (27.59%) SQL Server Reporting Services
15 24 (27.59%) OLAP
16 19 (21.84%) Analytical Skills
17 17 (19.54%) Data Analysis
17 17 (19.54%) Scrum
17 17 (19.54%) MS Excel
18 16 (18.39%) PL/SQL
18 16 (18.39%) Oracle Database
18 16 (18.39%) Oracle Database 11g
19 14 (16.09%) Data Integration
19 14 (16.09%) Relational Database
20 13 (14.94%) Dimensional Modelling
20 13 (14.94%) Spreadsheet
20 13 (14.94%) Degree
20 13 (14.94%) VBA
21 12 (13.79%) Oracle OLAP

Star Schema
Top Related IT Skills in London by Category

For the 6 months to 29 January 2015, IT jobs across the London region 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 (6.90%) SharePoint
2 4 (4.60%) SAS
2 4 (4.60%) MQSeries
Applications
1 17 (19.54%) MS Excel
2 13 (14.94%) Spreadsheet
3 2 (2.30%) SPSS
Business Applications
1 1 (1.15%) Cognos TM1
Communications & Networking
1 4 (4.60%) HTTP
Database & Business Intelligence
1 75 (86.21%) Data Warehouse
2 48 (55.17%) SQL Server
3 43 (49.43%) SQL Server Integration Services
4 42 (48.28%) SQL Server Analysis Services
5 24 (27.59%) SQL Server Reporting Services
5 24 (27.59%) OLAP
6 16 (18.39%) Oracle Database
6 16 (18.39%) Oracle Database 11g
7 14 (16.09%) Relational Database
8 12 (13.79%) Oracle OLAP
9 10 (11.49%) OLAP Cube
10 8 (9.20%) MySQL
10 8 (9.20%) QlikView
11 7 (8.05%) Microsoft Analysis Services
11 7 (8.05%) Oracle Reports
12 4 (4.60%) Snowflake Schema
12 4 (4.60%) Oracle BI EE
13 3 (3.45%) Data Mart
13 3 (3.45%) Pentaho
14 2 (2.30%) Data Mining
Development Applications
1 7 (8.05%) Team Foundation Server
2 5 (5.75%) ERwin
3 2 (2.30%) Subversion
3 2 (2.30%) MSBuild
3 2 (2.30%) TeamCity
4 1 (1.15%) FitNesse
4 1 (1.15%) Visual Studio Team System
4 1 (1.15%) Visual Studio
4 1 (1.15%) QuickTest Pro
4 1 (1.15%) Toad
General
1 47 (54.02%) Finance
2 8 (9.20%) Pharmaceutical
2 8 (9.20%) Marketing
3 5 (5.75%) Online Betting
4 3 (3.45%) Front Office
5 2 (2.30%) Banking
5 2 (2.30%) Legal
6 1 (1.15%) Games
6 1 (1.15%) Publishing
6 1 (1.15%) Law
6 1 (1.15%) Billing
Job Titles
1 57 (65.52%) Developer
2 29 (33.33%) Analyst
2 29 (33.33%) Data Warehouse Developer
3 18 (20.69%) Data Analyst
4 15 (17.24%) Data Warehouse Analyst
4 15 (17.24%) Developer Analyst
5 7 (8.05%) Business Analyst
5 7 (8.05%) SQL Developer
6 6 (6.90%) .NET Developer
6 6 (6.90%) Architect
6 6 (6.90%) Senior Developer
6 6 (6.90%) Business Intelligence Developer
6 6 (6.90%) Oracle Data Warehouse Developer
7 5 (5.75%) QlikView Consultant
7 5 (5.75%) Consultant
7 5 (5.75%) Oracle Developer
7 5 (5.75%) ETL Developer
8 4 (4.60%) Programmer
8 4 (4.60%) Data Programmer
9 3 (3.45%) Designer
Libraries, Frameworks & Software Standards
1 8 (9.20%) XML
1 8 (9.20%) .NET
2 7 (8.05%) HTML
2 7 (8.05%) Web Services
3 6 (6.90%) ASP.NET
3 6 (6.90%) AngularJS
3 6 (6.90%) HTML5
4 5 (5.75%) NHibernate
4 5 (5.75%) .NET Framework
4 5 (5.75%) LINQ
4 5 (5.75%) WCF
4 5 (5.75%) ASP.NET MVC
4 5 (5.75%) ADO.NET
5 4 (4.60%) UDDI
5 4 (4.60%) WSDL
5 4 (4.60%) CSS
5 4 (4.60%) SOAP
5 4 (4.60%) XSL
5 4 (4.60%) REST
5 4 (4.60%) ASP.NET MVC 4
Miscellaneous
1 19 (21.84%) Analytical Skills
2 14 (16.09%) Data Integration
3 7 (8.05%) Computer Science
4 6 (6.90%) Replication
4 6 (6.90%) Data Structures
5 5 (5.75%) Mathematics
6 4 (4.60%) Management Information System
6 4 (4.60%) Clustering
6 4 (4.60%) Derivative
7 2 (2.30%) Hedge funds
7 2 (2.30%) Visualisation
7 2 (2.30%) Freedom of Information
7 2 (2.30%) Statistics
8 1 (1.15%) Enterprise Software
8 1 (1.15%) Mobile Games
8 1 (1.15%) NHS
Operating Systems
1 9 (10.34%) UNIX
2 7 (8.05%) Linux
3 1 (1.15%) Windows
Processes & Methodologies
1 72 (82.76%) ETL
2 44 (50.57%) Business Intelligence
3 29 (33.33%) Data Modelling
4 27 (31.03%) Agile Software Development
5 25 (28.74%) Kimball Methodology
6 17 (19.54%) Data Analysis
6 17 (19.54%) Scrum
7 13 (14.94%) Dimensional Modelling
8 7 (8.05%) Performance Tuning
8 7 (8.05%) Analytics
8 7 (8.05%) Migration
9 6 (6.90%) Data Governance
9 6 (6.90%) Kalman Filter
10 5 (5.75%) Mentoring
10 5 (5.75%) MVC
11 4 (4.60%) OO
11 4 (4.60%) OOD
11 4 (4.60%) SOA
11 4 (4.60%) TDD
11 4 (4.60%) Data Management
Programming Languages
1 79 (90.80%) SQL
2 37 (42.53%) T-SQL
3 16 (18.39%) PL/SQL
4 13 (14.94%) VBA
5 10 (11.49%) C#
6 6 (6.90%) Shell Script
7 4 (4.60%) VB.NET
7 4 (4.60%) Python
7 4 (4.60%) R
8 3 (3.45%) Java
9 2 (2.30%) JavaScript
10 1 (1.15%) Perl
Qualifications
1 13 (14.94%) Degree
2 1 (1.15%) ISTQB
2 1 (1.15%) DV Cleared
2 1 (1.15%) Security Cleared
2 1 (1.15%) MCP
2 1 (1.15%) ISEB
2 1 (1.15%) Microsoft Certification
2 1 (1.15%) PMP
2 1 (1.15%) PMI Certification
Quality Assurance & Compliance
1 3 (3.45%) Data Quality
Vendors
1 32 (36.78%) Oracle
2 28 (32.18%) Microsoft
3 7 (8.05%) Informatica
4 6 (6.90%) Cognos
4 6 (6.90%) IBM
5 5 (5.75%) Business Objects
6 4 (4.60%) Teradata
7 2 (2.30%) MicroStrategy
7 2 (2.30%) Tableau
7 2 (2.30%) Cloudera
8 1 (1.15%) Sybase
8 1 (1.15%) Salesforce.com
City, London
Ashdown IT
Salary: £45000 - £55000 per annum + bonus & benefits
Posted: Yesterday
Uxbridge, Middlesex
Ampersand Consulting
Salary: £40000 - £48000 per annum + Benefits
Posted: 3 days ago
North West London
Vadis People
Salary: £45,000-£50,000
Posted: 6 days ago
City, London
Parallel Consulting
Salary: £38000 - £48000 per annum + Bonus
Posted: 6 days ago
London
Bridge Noble
Salary: £50000 - £55000 per annum + Benefits
Posted: 6 days ago
City of London
NFP Group Ltd
Salary: £55000 - £75000 per annum
Posted: 22 days ago
East London
Coral Racing Ltd
Salary: From £50,000 to £65,000 per annum (experience dependent) + bonus + ben
Posted: 27 days ago