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 3 months to 27 March 2017 with a comparison to the same period in the previous 2 years.

Star Schema
England / London
3 months to
27 Mar 2017
Same period 2016 Same period 2015
Rank 545 595 609
Rank change year-on-year +50 +14  
Permanent jobs citing Star Schema 31 58 53
As % of all permanent IT jobs advertised in London 0.093% 0.14% 0.12%
As % of the Database & Business Intelligence category 0.31% 0.44% 0.41%
Number of salaries quoted 23 51 48
Median salary £54,000 £55,000 £57,500
Median salary % change year-on-year -1.81% -4.34%  
90% offered a salary of more than £52,500 £44,000 £43,000
10% offered a salary of more than £55,000 £70,000 £85,000
UK excluding London median salary £45,000 £40,000 £40,750
% change year-on-year +12.50% -1.84%  

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

Database & Business Intelligence Skills
London
Permanent job vacancies with a requirement for database and business intelligence skills 10112 13098 13034
As % of all permanent IT job vacancies advertised in London 30.21% 31.22% 30.41%
Number of salaries quoted 8783 11422 11201
Median salary £60,000 £57,500 £55,000
Median salary % change year-on-year +4.34% +4.54%  
90% offered a salary of more than £40,000 £40,000 £38,000
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

Star Schema
Job Vacancy Trend in London

The job posting trend of jobs advertised in London citing Star Schema as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

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
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 3 months to 27 March 2017. 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 Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Uxbridge 0 4 £55,000 +10.00%
West End of London - 2 £45,000 - 1
Star Schema
England

Star Schema
Top 30 Co-occurring IT Skills in London

For the 6 months to 27 March 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 59 (95.16%) Data Warehouse
2 44 (70.97%) SQL
3 32 (51.61%) Oracle
4 29 (46.77%) Business Intelligence
5 28 (45.16%) SQL Server
5 28 (45.16%) Finance
6 24 (38.71%) T-SQL
6 24 (38.71%) Oracle Database
7 23 (37.10%) SQL Server Integration Services
7 23 (37.10%) Microsoft
8 22 (35.48%) ETL
8 22 (35.48%) SQL Server Analysis Services
9 20 (32.26%) Informatica
9 20 (32.26%) MS Excel
10 19 (30.65%) Degree
11 18 (29.03%) Kimball Methodology
12 17 (27.42%) Oracle Database 11g
13 15 (24.19%) Endeca
13 15 (24.19%) Oracle BI EE
13 15 (24.19%) Oracle ODI
13 15 (24.19%) Oracle Database 12c
13 15 (24.19%) Oracle BI Publisher
13 15 (24.19%) Oracle Reports
14 14 (22.58%) Oracle Applications
14 14 (22.58%) Data Modelling
15 12 (19.35%) Performance Tuning
16 11 (17.74%) High Availability
16 11 (17.74%) Information Architecture
17 9 (14.52%) Master Data Management
17 9 (14.52%) Data Management

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:

Applications
1 20 (32.26%) MS Excel
Business Applications
1 14 (22.58%) Oracle Applications
Cloud Services
1 2 (3.23%) SaaS
Database & Business Intelligence
1 59 (95.16%) Data Warehouse
2 28 (45.16%) SQL Server
3 24 (38.71%) Oracle Database
4 23 (37.10%) SQL Server Integration Services
5 22 (35.48%) SQL Server Analysis Services
6 17 (27.42%) Oracle Database 11g
7 15 (24.19%) Endeca
7 15 (24.19%) Oracle BI EE
7 15 (24.19%) Oracle BI Publisher
7 15 (24.19%) Oracle Database 12c
7 15 (24.19%) Oracle ODI
7 15 (24.19%) Oracle Reports
8 8 (12.90%) RDBMS
8 8 (12.90%) Relational Database
8 8 (12.90%) SQL Server Reporting Services
9 3 (4.84%) SQL Server 2008
10 2 (3.23%) Oracle Database 10g
10 2 (3.23%) Snowflake Schema
10 2 (3.23%) SQL Server 2005
10 2 (3.23%) SQL Server 2012
Development Applications
1 3 (4.84%) ERwin
General
1 28 (45.16%) Finance
2 9 (14.52%) Banking
3 6 (9.68%) Investment Banking
4 4 (6.45%) Publishing
5 3 (4.84%) Retail
6 1 (1.61%) Legal
Job Titles
1 22 (35.48%) Developer
2 15 (24.19%) Consultant
2 15 (24.19%) Data Warehouse Developer
2 15 (24.19%) OBIEE Consultant
2 15 (24.19%) Senior Consultant
2 15 (24.19%) Senior OBIEE Consultant
2 15 (24.19%) SQL Developer
2 15 (24.19%) SSIS Developer
3 14 (22.58%) Analyst
3 14 (22.58%) Analyst Developer
3 14 (22.58%) Data Analyst
3 14 (22.58%) Data Warehouse Analyst
3 14 (22.58%) Developer Analyst
3 14 (22.58%) ETL Analyst
3 14 (22.58%) ETL Developer
3 14 (22.58%) SQL Analyst
3 14 (22.58%) SQL Data Analyst
3 14 (22.58%) SSIS Analyst
4 8 (12.90%) DBA
5 7 (11.29%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 2 (3.23%) XML
Miscellaneous
1 7 (11.29%) Credit Risk
1 7 (11.29%) Market Risk
1 7 (11.29%) Replication
2 5 (8.06%) Computer Science
3 2 (3.23%) Analytical Skills
3 2 (3.23%) Enterprise Software
3 2 (3.23%) Fintech
3 2 (3.23%) Semantic Web
4 1 (1.61%) Data Structures
4 1 (1.61%) iSeries
Operating Systems
1 1 (1.61%) AIX
1 1 (1.61%) Unix
Processes & Methodologies
1 29 (46.77%) Business Intelligence
2 22 (35.48%) ETL
3 18 (29.03%) Kimball Methodology
4 14 (22.58%) Data Modelling
5 12 (19.35%) Performance Tuning
6 11 (17.74%) High Availability
6 11 (17.74%) Information Architecture
7 9 (14.52%) Data Management
7 9 (14.52%) Logical Data Model
7 9 (14.52%) Master Data Management
8 8 (12.90%) Capacity Planning
9 7 (11.29%) Mentoring
9 7 (11.29%) Security Management
9 7 (11.29%) Virtual Environments
10 6 (9.68%) Risk Management
11 5 (8.06%) Data Governance
11 5 (8.06%) Data Integration
11 5 (8.06%) Data Visualisation
11 5 (8.06%) Technical Architecture
11 5 (8.06%) Visualisation
Programming Languages
1 44 (70.97%) SQL
2 24 (38.71%) T-SQL
3 3 (4.84%) PL/SQL
Qualifications
1 19 (30.65%) Degree
Quality Assurance & Compliance
1 7 (11.29%) Data Quality
2 1 (1.61%) GDPR
Vendors
1 32 (51.61%) Oracle
2 23 (37.10%) Microsoft
3 20 (32.26%) Informatica
4 5 (8.06%) Tableau
5 4 (6.45%) IBM
6 3 (4.84%) Teradata
7 1 (1.61%) Birst
Central London / West End
The Workshop
Posted: 3 days ago