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 salaries offered in IT jobs that have cited Star Schema over the 3 months to 5 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
5 Dec 2016
Same period 2015 Same period 2014
Star Schema
Rank 558 635 630
Rank change year-on-year
+77 -5
Permanent jobs citing Star Schema 32 30 36
As % of all permanent IT jobs located in London 0.090% 0.069% 0.079%
As % of the Database & Business Intelligence category 0.30% 0.22% 0.27%
Number of salaries quoted 26 29 34
Median salary £65,000 £60,000 £44,000
Median salary % change year-on-year
+8.33% +36.36%
90% offered a salary of more than £55,000 £45,985 £37,500
10% offered a salary of more than £88,750 £85,000 £72,000
UK excluding London median salary £46,500 £43,250 £48,000
% change year-on-year
+7.51% -9.89%
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
10514 13557 13560
As % of all permanent IT jobs located in London 29.49% 31.35% 29.86%
Number of salaries quoted 9160 11568 11711
Median salary £60,000 £56,000 £55,000
Median salary % change year-on-year
+7.14% +1.81%
90% offered a salary of more than £40,000 £40,000 £37,500
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

Star Schema
Jobs Demand Trend in London

The demand trend of job ads across the London region citing Star Schema as a proportion of all IT jobs with a match in 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 5 December 2016.

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 median salaries quoted in IT jobs citing Star Schema within the London region over the 3 months to 5 December 2016. 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
(Click see detailed
statistics and trends)
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
City of London +30 6 £80,000 - 1
Uxbridge - 6 £55,000 - 1
Wimbledon - 1 - -
Star Schema
England

Star Schema
Top 30 Related IT Skills in London

For the 6 months to 5 December 2016, 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 96 (97.96%) Data Warehouse
2 69 (70.41%) Business Intelligence
3 65 (66.33%) ETL
4 53 (54.08%) SQL
5 52 (53.06%) Oracle
5 52 (53.06%) Finance
6 50 (51.02%) Data Modelling
7 45 (45.92%) Microsoft
8 36 (36.73%) SQL Server
9 29 (29.59%) Informatica
10 28 (28.57%) Kimball Methodology
11 25 (25.51%) SQL Server Integration Services
12 24 (24.49%) Oracle Database
13 22 (22.45%) Oracle Database 11g
13 22 (22.45%) Information Architecture
13 22 (22.45%) Data Management
14 20 (20.41%) Data Integration
14 20 (20.41%) Master Data Management
15 19 (19.39%) Oracle Database 12c
15 19 (19.39%) SQL Server Analysis Services
15 19 (19.39%) MS Excel
16 18 (18.37%) Snowflake Schema
16 18 (18.37%) Data Architecture
17 17 (17.35%) Degree
17 17 (17.35%) Mentoring
18 16 (16.33%) Banking
18 16 (16.33%) Retail
18 16 (16.33%) Technical Architecture
18 16 (16.33%) Management Information System
19 15 (15.31%) Oracle Applications

Star Schema
Top Related 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 1 (1.02%) Apache Airflow
1 1 (1.02%) Elasticsearch
1 1 (1.02%) Luigi
Applications
1 19 (19.39%) MS Excel
Business Applications
1 15 (15.31%) Oracle Applications
Cloud Services
1 2 (2.04%) Amazon AWS
1 2 (2.04%) SaaS
Database & Business Intelligence
1 96 (97.96%) Data Warehouse
2 36 (36.73%) SQL Server
3 25 (25.51%) SQL Server Integration Services
4 24 (24.49%) Oracle Database
5 22 (22.45%) Oracle Database 11g
6 19 (19.39%) Oracle Database 12c
6 19 (19.39%) SQL Server Analysis Services
7 18 (18.37%) Snowflake Schema
8 14 (14.29%) Enterprise Data Warehouse
8 14 (14.29%) Oracle Reports
9 13 (13.27%) Oracle BI EE
9 13 (13.27%) Oracle BI Publisher
9 13 (13.27%) Oracle ODI
10 12 (12.24%) OLAP
11 10 (10.20%) SQL Server Reporting Services
12 9 (9.18%) BusinessObjects
12 9 (9.18%) SQL Server 2008
13 8 (8.16%) Relational Database
14 6 (6.12%) RDBMS
15 5 (5.10%) MySQL
Development Applications
1 15 (15.31%) ERwin
2 1 (1.02%) Talend Open Studio
General
1 52 (53.06%) Finance
2 16 (16.33%) Banking
2 16 (16.33%) Retail
3 6 (6.12%) Investment Banking
4 4 (4.08%) Legal
5 2 (2.04%) Law
5 2 (2.04%) Marketing
6 1 (1.02%) Advertising
6 1 (1.02%) Games
6 1 (1.02%) Publishing
Job Titles
1 32 (32.65%) Architect
2 30 (30.61%) Developer
3 27 (27.55%) Data Architect
4 15 (15.31%) Consultant
5 13 (13.27%) Data Warehouse Developer
5 13 (13.27%) OBIEE Consultant
5 13 (13.27%) Senior Consultant
5 13 (13.27%) Senior OBIEE Consultant
6 11 (11.22%) Data Modeller
6 11 (11.22%) SQL Developer
7 10 (10.20%) Analyst
7 10 (10.20%) Business Intelligence Developer
8 9 (9.18%) Analyst Developer
9 8 (8.16%) Data Warehouse Architect
9 8 (8.16%) Oracle Architect
9 8 (8.16%) Teradata Architect
10 7 (7.14%) ETL Developer
11 6 (6.12%) Data Warehouse Analyst
11 6 (6.12%) Developer Analyst
11 6 (6.12%) SQL Data Analyst
Libraries, Frameworks & Software Standards
1 8 (8.16%) MDX
2 4 (4.08%) Web Services
2 4 (4.08%) XML
3 3 (3.06%) .NET
3 3 (3.06%) CSS
3 3 (3.06%) HTML
4 2 (2.04%) AngularJS
4 2 (2.04%) CSS3
4 2 (2.04%) HTML5
4 2 (2.04%) JSON
4 2 (2.04%) REST
4 2 (2.04%) Twitter Bootstrap
4 2 (2.04%) WCF
5 1 (1.02%) ASP.NET
5 1 (1.02%) ASP.NET MVC
5 1 (1.02%) Kafka
Miscellaneous
1 20 (20.41%) Data Integration
2 16 (16.33%) Management Information System
3 11 (11.22%) Credit Risk
3 11 (11.22%) Market Risk
4 5 (5.10%) Analytical Skills
4 5 (5.10%) Computer Science
4 5 (5.10%) Data Structures
4 5 (5.10%) Visualisation
5 2 (2.04%) Enterprise Software
5 2 (2.04%) Fintech
5 2 (2.04%) Replication
5 2 (2.04%) Semantic Web
6 1 (1.02%) Client/Server
6 1 (1.02%) iSeries
6 1 (1.02%) Online Games
Operating Systems
1 3 (3.06%) Unix
2 1 (1.02%) AIX
2 1 (1.02%) Android
2 1 (1.02%) Apple iOS
2 1 (1.02%) Linux
Processes & Methodologies
1 69 (70.41%) Business Intelligence
2 65 (66.33%) ETL
3 50 (51.02%) Data Modelling
4 28 (28.57%) Kimball Methodology
5 22 (22.45%) Data Management
5 22 (22.45%) Information Architecture
6 20 (20.41%) Master Data Management
7 18 (18.37%) Data Architecture
8 17 (17.35%) Mentoring
9 16 (16.33%) Technical Architecture
10 15 (15.31%) Logical Data Model
11 14 (14.29%) TOGAF
11 14 (14.29%) Zachman Framework
12 13 (13.27%) Analytics
12 13 (13.27%) CRM
12 13 (13.27%) E-Commerce
13 12 (12.24%) Inmon Methodology
13 12 (12.24%) Metadata Management
13 12 (12.24%) Migration
13 12 (12.24%) Software Engineering
Programming Languages
1 53 (54.08%) SQL
2 12 (12.24%) PL/SQL
2 12 (12.24%) T-SQL
3 4 (4.08%) C#
3 4 (4.08%) Data Analysis Expressions (DAX)
4 3 (3.06%) JavaScript
5 2 (2.04%) Python
5 2 (2.04%) Shell Script
5 2 (2.04%) TypeScript
5 2 (2.04%) VB.NET
5 2 (2.04%) VBA
6 1 (1.02%) Bash Shell
6 1 (1.02%) Java
6 1 (1.02%) R
Qualifications
1 17 (17.35%) Degree
2 5 (5.10%) Microsoft Certification
Quality Assurance & Compliance
1 9 (9.18%) Data Quality
2 4 (4.08%) QA
System Software
1 1 (1.02%) Apache Flume
Systems Management
1 2 (2.04%) Dollar Universe
2 1 (1.02%) Hadoop YARN
Vendors
1 52 (53.06%) Oracle
2 45 (45.92%) Microsoft
3 29 (29.59%) Informatica
4 13 (13.27%) Endeca
4 13 (13.27%) IBM
5 12 (12.24%) Teradata
6 8 (8.16%) SAP
6 8 (8.16%) Tableau
7 2 (2.04%) Salesforce.com
8 1 (1.02%) Talend
West London
Eutopia Solutions Ltd
Salary: £50000.00 - £60000.00 per annum + bonus
Posted: 3 days ago
Uxbridge
Ampersand Consulting
Salary: £55000 per annum + Benefits
Posted: 5 days ago
London
Charles Taylor Plc
Salary: Market related
Posted: 13 days ago
City, London
Charles Taylor plc
Salary: Market related
Posted: 13 days ago