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 28 September 2016 with a comparison to the same period over the previous 2 years.

3 months to
28 Sep 2016
Same period 2015 Same period 2014
Star Schema
Rank 550 631 631
Rank change year-on-year
+81 0
Permanent jobs citing Star Schema 63 40 36
As % of all permanent IT jobs located in London 0.17% 0.091% 0.079%
As % of the Database & Business Intelligence category 0.56% 0.30% 0.26%
Number of salaries quoted 58 27 33
Median salary £62,500 £60,000 £57,500
Median salary % change year-on-year
+4.16% +4.34%
90% offered a salary of more than £51,750 £49,200 £44,000
10% offered a salary of more than £80,000 £79,000 £74,500
UK excluding London median salary £40,000 £41,500 £47,500
% change year-on-year
-3.61% -12.63%
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
11247 13150 13968
As % of all permanent IT jobs located in London 29.57% 29.78% 30.83%
Number of salaries quoted 9790 11141 12120
Median salary £60,000 £57,500 £52,500
Median salary % change year-on-year
+4.34% +9.52%
90% offered a salary of more than £40,000 £40,000 £37,449
10% offered a salary of more than £85,000 £75,000 £80,000
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 28 September 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 28 September 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 +42 2 £70,000 +3.70%
Star Schema
England

Star Schema
Top 30 Related IT Skills in London

For the 6 months to 28 September 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 111 (90.24%) Data Warehouse
2 95 (77.24%) Business Intelligence
3 83 (67.48%) ETL
4 79 (64.23%) SQL
5 68 (55.28%) Finance
6 60 (48.78%) Data Modelling
6 60 (48.78%) Microsoft
7 59 (47.97%) Oracle
8 51 (41.46%) SQL Server
9 37 (30.08%) Kimball Methodology
10 35 (28.46%) SQL Server Integration Services
11 28 (22.76%) Informatica
12 27 (21.95%) Analytics
13 26 (21.14%) Data Architecture
14 24 (19.51%) Data Integration
15 23 (18.70%) OLAP
15 23 (18.70%) Management Information System
16 22 (17.89%) MS Excel
16 22 (17.89%) Oracle Database 11g
16 22 (17.89%) Oracle Database
17 21 (17.07%) SQL Server Analysis Services
18 20 (16.26%) Oracle Database 12c
18 20 (16.26%) Relational Database
18 20 (16.26%) Mentoring
19 19 (15.45%) Tableau
19 19 (15.45%) Snowflake Schema
19 19 (15.45%) Enterprise Data Warehouse
20 18 (14.63%) Oracle Reports
20 18 (14.63%) T-SQL
21 17 (13.82%) 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 2 (1.63%) Apache Pig
1 2 (1.63%) Apache Spark
1 2 (1.63%) SAS
2 1 (0.81%) Elasticsearch
2 1 (0.81%) SharePoint
Applications
1 22 (17.89%) MS Excel
2 1 (0.81%) SPSS
Business Applications
1 17 (13.82%) Oracle Applications
2 1 (0.81%) Cognos TM1
Cloud Services
1 7 (5.69%) Amazon AWS
2 2 (1.63%) SaaS
Database & Business Intelligence
1 111 (90.24%) Data Warehouse
2 51 (41.46%) SQL Server
3 35 (28.46%) SQL Server Integration Services
4 23 (18.70%) OLAP
5 22 (17.89%) Oracle Database
5 22 (17.89%) Oracle Database 11g
6 21 (17.07%) SQL Server Analysis Services
7 20 (16.26%) Oracle Database 12c
7 20 (16.26%) Relational Database
8 19 (15.45%) Enterprise Data Warehouse
8 19 (15.45%) Snowflake Schema
9 18 (14.63%) Oracle Reports
10 17 (13.82%) BusinessObjects
11 16 (13.01%) SQL Server 2008
12 14 (11.38%) Oracle BI EE
12 14 (11.38%) Oracle BI Publisher
12 14 (11.38%) Oracle ODI
12 14 (11.38%) RDBMS
13 12 (9.76%) SQL Server 2014
13 12 (9.76%) SQL Server Reporting Services
Development Applications
1 13 (10.57%) ERwin
2 1 (0.81%) Talend Open Studio
General
1 68 (55.28%) Finance
2 14 (11.38%) Retail
3 13 (10.57%) Banking
4 9 (7.32%) Legal
5 5 (4.07%) Law
5 5 (4.07%) Marketing
6 4 (3.25%) Games
7 3 (2.44%) Back Office
7 3 (2.44%) Investment Banking
7 3 (2.44%) Publishing
8 1 (0.81%) Advertising
Job Titles
1 52 (42.28%) Developer
2 39 (31.71%) Architect
3 34 (27.64%) Data Architect
4 23 (18.70%) Business Intelligence Developer
5 22 (17.89%) Data Warehouse Developer
6 18 (14.63%) SQL Developer
7 17 (13.82%) Consultant
8 15 (12.20%) ETL Developer
9 14 (11.38%) OBIEE Consultant
9 14 (11.38%) Senior Consultant
9 14 (11.38%) Senior OBIEE Consultant
9 14 (11.38%) SSIS Developer
10 13 (10.57%) Analyst
11 12 (9.76%) Business Objects Developer
12 11 (8.94%) Report Developer
13 10 (8.13%) Analyst Developer
13 10 (8.13%) Lead Developer
14 9 (7.32%) Data Analyst
15 8 (6.50%) Data Warehouse Architect
15 8 (6.50%) Teradata Architect
Libraries, Frameworks & Software Standards
1 11 (8.94%) MDX
2 4 (3.25%) Web Services
3 3 (2.44%) .NET
3 3 (2.44%) CSS
3 3 (2.44%) HTML
3 3 (2.44%) JSON
3 3 (2.44%) Kafka
3 3 (2.44%) XML
4 2 (1.63%) AngularJS
4 2 (1.63%) CSS3
4 2 (1.63%) HTML5
4 2 (1.63%) REST
4 2 (1.63%) Twitter Bootstrap
4 2 (1.63%) WCF
5 1 (0.81%) ASP.NET
5 1 (0.81%) ASP.NET MVC
Miscellaneous
1 24 (19.51%) Data Integration
2 23 (18.70%) Management Information System
3 10 (8.13%) Visualisation
4 8 (6.50%) Analytical Skills
5 6 (4.88%) Credit Risk
5 6 (4.88%) Market Risk
6 5 (4.07%) Data Structures
7 4 (3.25%) Fintech
8 3 (2.44%) Online Games
9 2 (1.63%) Computer Science
10 1 (0.81%) Client/Server
10 1 (0.81%) Freedom of Information
Operating Systems
1 4 (3.25%) Unix
2 1 (0.81%) Android
2 1 (0.81%) Apple iOS
2 1 (0.81%) Linux
Processes & Methodologies
1 95 (77.24%) Business Intelligence
2 83 (67.48%) ETL
3 60 (48.78%) Data Modelling
4 37 (30.08%) Kimball Methodology
5 27 (21.95%) Analytics
6 26 (21.14%) Data Architecture
7 20 (16.26%) Mentoring
8 17 (13.82%) Data Management
9 15 (12.20%) CRM
9 15 (12.20%) Inmon Methodology
10 14 (11.38%) ETL Development
10 14 (11.38%) Master Data Management
11 13 (10.57%) Data Governance
11 13 (10.57%) Information Architecture
11 13 (10.57%) SDLC
12 12 (9.76%) E-Commerce
12 12 (9.76%) Technical Architecture
12 12 (9.76%) TOGAF
12 12 (9.76%) Zachman Framework
13 11 (8.94%) Migration
Programming Languages
1 79 (64.23%) SQL
2 18 (14.63%) T-SQL
3 16 (13.01%) PL/SQL
4 7 (5.69%) Data Analysis Expressions (DAX)
4 7 (5.69%) Python
5 6 (4.88%) C#
6 5 (4.07%) VBA
7 4 (3.25%) Java
8 3 (2.44%) JavaScript
8 3 (2.44%) R
9 2 (1.63%) Clojure
9 2 (1.63%) Ruby
9 2 (1.63%) Scala
9 2 (1.63%) Shell Script
9 2 (1.63%) TypeScript
9 2 (1.63%) VB.NET
10 1 (0.81%) Bash Shell
Qualifications
1 16 (13.01%) Degree
2 5 (4.07%) Microsoft Certification
Quality Assurance & Compliance
1 14 (11.38%) Data Quality
2 9 (7.32%) QA
System Software
1 1 (0.81%) Apache Flume
Systems Management
1 2 (1.63%) Dollar Universe
2 1 (0.81%) Cisco IPCC
2 1 (0.81%) Hadoop YARN
Vendors
1 60 (48.78%) Microsoft
2 59 (47.97%) Oracle
3 28 (22.76%) Informatica
4 19 (15.45%) Tableau
5 14 (11.38%) Endeca
6 11 (8.94%) IBM
7 10 (8.13%) Teradata
8 8 (6.50%) SAP
9 6 (4.88%) Cognos
10 2 (1.63%) Salesforce.com
11 1 (0.81%) MicroStrategy
11 1 (0.81%) Pega
11 1 (0.81%) Talend
South East London
Recital Consulting
Salary: £50000 - £65000 Per Annum Plus Benefits
Posted: 4 days ago