Period
to 23 November 2017

The following table provides summary statistics for permanent job vacancies advertised in London with a requirement for Star Schema skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Star Schema over the 6 months to 23 November 2017 with a comparison to the same period in the previous 2 years.

Star Schema
England > London
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 734 745 804
Rank change year-on-year +11 +59 +41
Permanent jobs citing Star Schema 106 105 106
As % of all permanent IT jobs advertised in London 0.14% 0.14% 0.12%
As % of the Database & Business Intelligence category 0.48% 0.47% 0.39%
Number of salaries quoted 31 93 57
London median annual salary £55,000 £60,000 £60,000
Median salary % change year-on-year -8.33% - +9.09%
10th Percentile £43,500 £45,000 £47,500
90th Percentile £78,750 £82,500 £87,500
England median annual salary £50,000 £54,000 £47,500
% change year-on-year -7.41% +13.68% -1.04%

Star Schema is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
London
Permanent vacancies with a requirement for database or business intelligence skills 22130 22400 27104
As % of all permanent IT jobs advertised in London 29.46% 29.46% 30.57%
Number of salaries quoted 17746 19494 22934
London median annual salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.35% +4.55% +4.76%
10th Percentile £36,250 £35,000 £35,000
90th Percentile £88,750 £87,500 £85,000
England median annual salary £50,000 £47,500 £45,000
% change year-on-year +5.26% +5.56% -

Star Schema
Job Vacancy Trend in London

Job postings citing Star Schema as a percentage of all IT jobs advertised in London.

Job vacancy trend for Star Schema 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 in London.

Salary trend for Star Schema in London

Star Schema
Salary Histogram in London

The salary distribution of IT jobs citing Star Schema in London over the 6 months to 23 November 2017.

Salary histogram for Star Schema in London

Star Schema
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Star Schema within the London region over the 6 months to 23 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Central London +15 18 £61,000 +1.67% 3
Star Schema
England

For the 6 months to 23 November 2017, IT jobs citing Star Schema also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the London region with a requirement for Star Schema.

1 90 (84.91%) Business Intelligence
2 75 (70.75%) Finance
3 61 (57.55%) Microsoft
4 58 (54.72%) Power BI
5 57 (53.77%) Degree
6 56 (52.83%) Relational Database
7 55 (51.89%) Data Warehouse
7 55 (51.89%) Java
8 47 (44.34%) OO
8 47 (44.34%) Asset Management
9 46 (43.40%) Banking
9 46 (43.40%) Wealth Management
9 46 (43.40%) SDLC
10 45 (42.45%) Retail Banking
10 45 (42.45%) Risk Analysis
10 45 (42.45%) Investment Banking
10 45 (42.45%) OOD
10 45 (42.45%) MicroStrategy
10 45 (42.45%) Front Office
10 45 (42.45%) Risk Management
10 45 (42.45%) Financial Institution
11 40 (37.74%) SQL
12 33 (31.13%) ETL
12 33 (31.13%) Kimball Methodology
13 27 (25.47%) SQL Server
14 26 (24.53%) Data Modelling
15 23 (21.70%) Visualisation
16 21 (19.81%) SQL Server Reporting Services
17 20 (18.87%) Data Quality
18 19 (17.92%) SQL Server Integration Services

Star Schema
Co-occurring IT Skills in London by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 11 (10.38%) Apache Spark
2 8 (7.55%) Apache
3 2 (1.89%) SAS
3 2 (1.89%) Smallworld
Applications
1 2 (1.89%) Microsoft Excel
1 2 (1.89%) Microsoft Office
Business Applications
1 2 (1.89%) SAP PM
Database & Business Intelligence
1 58 (54.72%) Power BI
2 56 (52.83%) Relational Database
3 55 (51.89%) Data Warehouse
4 27 (25.47%) SQL Server
5 21 (19.81%) SQL Server Reporting Services
6 19 (17.92%) SQL Server Analysis Services
6 19 (17.92%) SQL Server Integration Services
7 16 (15.09%) Semantic Layer
8 11 (10.38%) BusinessObjects
8 11 (10.38%) NoSQL
9 10 (9.43%) BusinessObjects Web Intelligence
9 10 (9.43%) OLAP
10 9 (8.49%) Big Data
10 9 (8.49%) Hadoop
10 9 (8.49%) HBase
10 9 (8.49%) Oracle OLAP
10 9 (8.49%) RDBMS
11 8 (7.55%) Data Mart
11 8 (7.55%) Lumira
11 8 (7.55%) QlikView
Development Applications
1 4 (3.77%) JIRA
1 4 (3.77%) Subversion
1 4 (3.77%) Team Foundation Server
1 4 (3.77%) Visual Studio
General
1 75 (70.75%) Finance
2 46 (43.40%) Banking
3 45 (42.45%) Financial Institution
3 45 (42.45%) Front Office
3 45 (42.45%) Investment Banking
3 45 (42.45%) Retail Banking
4 12 (11.32%) Retail
5 7 (6.60%) Games
5 7 (6.60%) Marketing
5 7 (6.60%) Publishing
6 2 (1.89%) Billing
6 2 (1.89%) Legal
Job Titles
1 32 (30.19%) Developer
2 22 (20.75%) Analyst
3 14 (13.21%) Business Intelligence Developer
4 13 (12.26%) Architect
5 12 (11.32%) Business Developer
6 11 (10.38%) Data Architect
7 10 (9.43%) Data Analyst
8 9 (8.49%) Analyst Developer
8 9 (8.49%) Developer Analyst
8 9 (8.49%) SAP BusinessObjects (BO) Analyst
8 9 (8.49%) SAP BusinessObjects (BO) Developer
9 8 (7.55%) Data Warehouse Analyst
10 7 (6.60%) Business Analyst
10 7 (6.60%) Data Business Analyst
10 7 (6.60%) Data Warehouse Business Analyst
11 6 (5.66%) Data Warehouse Developer
11 6 (5.66%) ETL Developer
11 6 (5.66%) Tableau Developer
12 5 (4.72%) Business Intelligence Lead
13 4 (3.77%) SSRS Developer
Libraries, Frameworks & Software Standards
1 2 (1.89%) D3.js
Miscellaneous
1 12 (11.32%) Analytical Skills
2 8 (7.55%) Data Structures
3 6 (5.66%) Greenfield Project
4 4 (3.77%) Computer Science
4 4 (3.77%) Fintech
5 2 (1.89%) Enterprise Software
5 2 (1.89%) Management Information System
6 1 (0.94%) Virtual Team
Operating Systems
1 10 (9.43%) Linux
2 2 (1.89%) Unix
Processes & Methodologies
1 90 (84.91%) Business Intelligence
2 47 (44.34%) Asset Management
2 47 (44.34%) OO
3 46 (43.40%) SDLC
3 46 (43.40%) Wealth Management
4 45 (42.45%) OOD
4 45 (42.45%) Risk Analysis
4 45 (42.45%) Risk Management
5 33 (31.13%) ETL
5 33 (31.13%) Kimball Methodology
6 26 (24.53%) Data Modelling
7 23 (21.70%) Visualisation
8 19 (17.92%) Data Integration
8 19 (17.92%) Data Management
9 18 (16.98%) Performance Tuning
10 15 (14.15%) Analytics
10 15 (14.15%) Dimensional Modelling
11 14 (13.21%) Agile Software Development
11 14 (13.21%) Data Governance
12 12 (11.32%) Data Visualisation
Programming Languages
1 55 (51.89%) Java
2 40 (37.74%) SQL
3 10 (9.43%) Python
4 9 (8.49%) PL/SQL
4 9 (8.49%) T-SQL
5 2 (1.89%) R
5 2 (1.89%) Scala
5 2 (1.89%) Shell Script
5 2 (1.89%) VB
Qualifications
1 57 (53.77%) Degree
2 8 (7.55%) MBA
Quality Assurance & Compliance
1 20 (18.87%) Data Quality
2 7 (6.60%) QA
Vendors
1 61 (57.55%) Microsoft
2 45 (42.45%) MicroStrategy
3 17 (16.04%) Tableau
4 11 (10.38%) Oracle
4 11 (10.38%) SAP
5 1 (0.94%) Cognos