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

3 months to
27 May 2016
Same period 2015 Same period 2014
Star Schema
Rank 580 594 681
Rank change year-on-year
+14 +87
Permanent jobs citing Star Schema 64 76 33
As % of all permanent IT jobs located in London 0.16% 0.18% 0.067%
As % of the Database & Business Intelligence category 0.52% 0.55% 0.21%
Number of salaries quoted 51 42 29
Median salary £50,000 £65,000 £60,000
Median salary % change year-on-year
-23.07% +8.33%
90% offered a salary of more than £44,000 £47,550 £45,000
10% offered a salary of more than £72,500 £70,000 £80,000
UK excluding London median salary £52,500 £46,500 £45,000
% change year-on-year
+12.90% +3.33%
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
12335 13932 15557
As % of all permanent IT jobs located in London 30.08% 32.09% 31.78%
Number of salaries quoted 10796 11923 13502
Median salary £57,500 £57,500 £52,500
Median salary % change year-on-year
- +9.52%
90% offered a salary of more than £40,000 £39,000 £36,000
10% offered a salary of more than £80,000 £75,000 £80,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 27 May 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 27 May 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
Uxbridge +17 12 £44,000 -8.33% 1
City of London +46 5 £46,250 -34.39% 4
Croydon -6 1 - -
Star Schema
England

Star Schema
Top 30 Related IT Skills in London

For the 6 months to 27 May 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 99 (81.15%) Data Warehouse
2 90 (73.77%) SQL
3 89 (72.95%) ETL
4 78 (63.93%) Finance
5 73 (59.84%) Business Intelligence
6 66 (54.10%) SQL Server
7 61 (50.00%) Data Modelling
8 56 (45.90%) Microsoft
9 54 (44.26%) SQL Server Integration Services
10 46 (37.70%) MS Excel
11 40 (32.79%) Data Integration
12 32 (26.23%) SQL Server Analysis Services
13 28 (22.95%) Oracle
14 26 (21.31%) Data Quality
14 26 (21.31%) Kimball Methodology
15 25 (20.49%) T-SQL
16 24 (19.67%) Data Management
16 24 (19.67%) Analytics
17 23 (18.85%) Data Governance
18 22 (18.03%) Retail
19 21 (17.21%) MDX
20 20 (16.39%) Big Data
20 20 (16.39%) SQL Server Reporting Services
21 19 (15.57%) ETL Development
22 18 (14.75%) SQL Server 2008
23 17 (13.93%) Data Architecture
24 16 (13.11%) ITIL
24 16 (13.11%) SQL Server 2014
25 15 (12.30%) BusinessObjects
26 14 (11.48%) PRINCE2

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 4 (3.28%) Apache Spark
2 3 (2.46%) Apache Pig
2 3 (2.46%) SAS
2 3 (2.46%) SharePoint
3 1 (0.82%) Apache
Applications
1 46 (37.70%) MS Excel
2 3 (2.46%) SPSS
Business Applications
1 3 (2.46%) Cognos TM1
1 3 (2.46%) Oracle Applications
2 1 (0.82%) Cognos Business Intelligence
2 1 (0.82%) SAP APO
Cloud Services
1 4 (3.28%) Amazon AWS
2 1 (0.82%) Google Cloud Platform
Database & Business Intelligence
1 99 (81.15%) Data Warehouse
2 66 (54.10%) SQL Server
3 54 (44.26%) SQL Server Integration Services
4 32 (26.23%) SQL Server Analysis Services
5 20 (16.39%) Big Data
5 20 (16.39%) SQL Server Reporting Services
6 18 (14.75%) SQL Server 2008
7 16 (13.11%) SQL Server 2014
8 15 (12.30%) BusinessObjects
9 13 (10.66%) OLAP
9 13 (10.66%) Relational Database
10 12 (9.84%) Oracle Reports
11 11 (9.02%) Oracle ODI
12 10 (8.20%) RDBMS
13 9 (7.38%) Oracle Database
14 8 (6.56%) Oracle Database 11g
15 7 (5.74%) Oracle Database 12c
16 6 (4.92%) Oracle OLAP
16 6 (4.92%) Spotfire
17 5 (4.10%) Hadoop
Development Applications
1 5 (4.10%) Subversion
2 2 (1.64%) ERwin
General
1 78 (63.93%) Finance
2 22 (18.03%) Retail
3 7 (5.74%) Law
3 7 (5.74%) Legal
4 6 (4.92%) Publishing
5 5 (4.10%) Games
6 4 (3.28%) Marketing
7 3 (2.46%) Back Office
7 3 (2.46%) Banking
8 2 (1.64%) Investment Banking
9 1 (0.82%) Pharmaceutical
Job Titles
1 63 (51.64%) Developer
2 37 (30.33%) ETL Developer
3 28 (22.95%) Data Warehouse Developer
4 24 (19.67%) SSIS Developer
5 19 (15.57%) Architect
5 19 (15.57%) Data Architect
6 18 (14.75%) Business Intelligence Developer
6 18 (14.75%) SQL Developer
7 15 (12.30%) Analyst
8 12 (9.84%) Analyst Developer
8 12 (9.84%) Business Objects Developer
8 12 (9.84%) Data Analyst
8 12 (9.84%) Developer Analyst
8 12 (9.84%) SQL Analyst
9 11 (9.02%) Business Manager
9 11 (9.02%) Data Warehouse Analyst
9 11 (9.02%) ETL Analyst
9 11 (9.02%) Lead Developer
9 11 (9.02%) SQL Data Analyst
9 11 (9.02%) SSIS Analyst
Libraries, Frameworks & Software Standards
1 21 (17.21%) MDX
2 5 (4.10%) .NET
2 5 (4.10%) Middleware
2 5 (4.10%) WCF
2 5 (4.10%) WinForms
3 3 (2.46%) Kafka
4 2 (1.64%) XML
5 1 (0.82%) JSON
5 1 (0.82%) Web Services
5 1 (0.82%) XML Schema
Miscellaneous
1 40 (32.79%) Data Integration
2 12 (9.84%) Clustering
3 8 (6.56%) Analytical Skills
3 8 (6.56%) Visualisation
4 5 (4.10%) Management Information System
5 4 (3.28%) Online Games
6 3 (2.46%) Fintech
7 2 (1.64%) Freedom of Information
8 1 (0.82%) Data Structures
8 1 (0.82%) Hedge funds
8 1 (0.82%) Ontologies
8 1 (0.82%) Reference Data
Operating Systems
1 4 (3.28%) Unix
2 2 (1.64%) Linux
Processes & Methodologies
1 89 (72.95%) ETL
2 73 (59.84%) Business Intelligence
3 61 (50.00%) Data Modelling
4 26 (21.31%) Kimball Methodology
5 24 (19.67%) Analytics
5 24 (19.67%) Data Management
6 23 (18.85%) Data Governance
7 19 (15.57%) ETL Development
8 17 (13.93%) Data Architecture
9 16 (13.11%) ITIL
10 14 (11.48%) Continuous Improvement
10 14 (11.48%) Enterprise Data Management
10 14 (11.48%) PRINCE2
10 14 (11.48%) Records Management
11 12 (9.84%) Mentoring
12 11 (9.02%) Agile Software Development
13 10 (8.20%) Dimensional Modelling
14 9 (7.38%) Performance Tuning
15 8 (6.56%) Investment Management
15 8 (6.56%) Logical Data Model
Programming Languages
1 90 (73.77%) SQL
2 25 (20.49%) T-SQL
3 14 (11.48%) PowerShell
4 12 (9.84%) PL/SQL
5 8 (6.56%) C#
6 6 (4.92%) Java
7 5 (4.10%) C
7 5 (4.10%) Python
7 5 (4.10%) VB
7 5 (4.10%) VB.NET
8 2 (1.64%) Clojure
8 2 (1.64%) Data Analysis Expressions (DAX)
8 2 (1.64%) R
8 2 (1.64%) Ruby
8 2 (1.64%) Scala
8 2 (1.64%) Shell Script
8 2 (1.64%) VBA
9 1 (0.82%) Bash Shell
9 1 (0.82%) C-shell
9 1 (0.82%) SPARQL
Qualifications
1 14 (11.48%) Degree
Quality Assurance & Compliance
1 26 (21.31%) Data Quality
2 4 (3.28%) QA
System Software
1 3 (2.46%) Oracle RAC
2 1 (0.82%) Apache Flume
Systems Management
1 2 (1.64%) Cisco IPCC
2 1 (0.82%) Hadoop YARN
2 1 (0.82%) Oozie
Vendors
1 56 (45.90%) Microsoft
2 28 (22.95%) Oracle
3 12 (9.84%) Tableau
4 8 (6.56%) Cognos
5 7 (5.74%) SAP
6 5 (4.10%) Informatica
7 4 (3.28%) Embarcadero
7 4 (3.28%) Endeca
7 4 (3.28%) IBM
8 2 (1.64%) Cloudera
8 2 (1.64%) Hortonworks
8 2 (1.64%) MapR
8 2 (1.64%) Teradata
9 1 (0.82%) MicroStrategy
9 1 (0.82%) Pega
London
Harvey Nash plc
Salary: £80000 per annum
Posted: 3 days ago
City, London
TEKsystems
Salary: £40000 - £50000 per annum + brilliant bonuses and benefits
Posted: 3 days ago
London
Vivid Resourcing
Salary: £60 - £65 per annum + benefits
Posted: 7 days ago
Uxbridge
Ampersand Consulting
Salary: £40000 - £48000 per annum + Benefits
Posted: 7 days ago
City of London
Venturi
Salary: £35000 - £60000 per annum + bonus/benefits
Posted: 7 days ago
London
Talent Point
Salary: £50000.00 - £60000.00 per annum
Posted: 17 days ago
London
Talent Point
Salary: £50000.00 - £60000.00 per annum
Posted: 18 days ago
City, London
Business Decision
Salary: Competitive salary and excellent benefits
Posted: 10 days ago