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

3 months to
24 Jul 2016
Same period 2015 Same period 2014
Star Schema
Rank 578 584 653
Rank change year-on-year
+6 +69
Permanent jobs citing Star Schema 56 91 31
As % of all permanent IT jobs located in London 0.14% 0.20% 0.065%
As % of the Database & Business Intelligence category 0.49% 0.66% 0.21%
Number of salaries quoted 48 38 28
Median salary £55,000 £65,000 £60,000
Median salary % change year-on-year
-15.38% +8.33%
90% offered a salary of more than £44,700 £46,750 £45,000
10% offered a salary of more than £80,000 £87,500 £75,000
UK excluding London median salary £40,000 £42,500 £45,000
% change year-on-year
-5.88% -5.55%
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
11504 13825 15045
As % of all permanent IT jobs located in London 29.16% 31.08% 31.59%
Number of salaries quoted 9968 11690 13109
Median salary £57,500 £57,500 £55,000
Median salary % change year-on-year
- +4.54%
90% offered a salary of more than £40,000 £38,500 £37,000
10% offered a salary of more than £82,500 £75,000 £80,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 24 July 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 24 July 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 +73 14 £50,000 -41.17%
Uxbridge +1 4 £44,000 -8.33%
Star Schema
England

Star Schema
Top 30 Related IT Skills in London

For the 6 months to 24 July 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 100 (84.03%) Data Warehouse
2 87 (73.11%) SQL
3 83 (69.75%) ETL
4 77 (64.71%) Business Intelligence
5 73 (61.34%) Finance
6 65 (54.62%) SQL Server
7 59 (49.58%) Microsoft
8 51 (42.86%) Data Modelling
9 48 (40.34%) SQL Server Integration Services
10 41 (34.45%) Oracle
11 38 (31.93%) MS Excel
12 33 (27.73%) Kimball Methodology
13 27 (22.69%) Analytics
14 25 (21.01%) SQL Server Analysis Services
14 25 (21.01%) Data Integration
15 24 (20.17%) T-SQL
16 23 (19.33%) Data Architecture
17 21 (17.65%) Tableau
17 21 (17.65%) OLAP
18 20 (16.81%) BusinessObjects
18 20 (16.81%) SQL Server 2008
18 20 (16.81%) Relational Database
19 18 (15.13%) ETL Development
20 17 (14.29%) Oracle Reports
21 16 (13.45%) SQL Server Reporting Services
21 16 (13.45%) SQL Server 2014
21 16 (13.45%) Oracle ODI
21 16 (13.45%) Oracle Database
21 16 (13.45%) Data Quality
22 15 (12.61%) Oracle Database 11g

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.68%) Apache Pig
1 2 (1.68%) Apache Spark
1 2 (1.68%) SAS
1 2 (1.68%) SharePoint
Applications
1 38 (31.93%) MS Excel
2 2 (1.68%) SPSS
Business Applications
1 9 (7.56%) Oracle Applications
2 1 (0.84%) Cognos TM1
Cloud Services
1 6 (5.04%) Amazon AWS
2 1 (0.84%) SaaS
Database & Business Intelligence
1 100 (84.03%) Data Warehouse
2 65 (54.62%) SQL Server
3 48 (40.34%) SQL Server Integration Services
4 25 (21.01%) SQL Server Analysis Services
5 21 (17.65%) OLAP
6 20 (16.81%) BusinessObjects
6 20 (16.81%) Relational Database
6 20 (16.81%) SQL Server 2008
7 17 (14.29%) Oracle Reports
8 16 (13.45%) Oracle Database
8 16 (13.45%) Oracle ODI
8 16 (13.45%) SQL Server 2014
8 16 (13.45%) SQL Server Reporting Services
9 15 (12.61%) Oracle Database 11g
10 14 (11.76%) Oracle Database 12c
10 14 (11.76%) RDBMS
11 10 (8.40%) Enterprise Data Warehouse
11 10 (8.40%) MySQL
11 10 (8.40%) Oracle BI Publisher
11 10 (8.40%) Oracle OLAP
Development Applications
1 5 (4.20%) Subversion
2 1 (0.84%) ERwin
General
1 73 (61.34%) Finance
2 12 (10.08%) Retail
3 9 (7.56%) Legal
4 8 (6.72%) Law
5 7 (5.88%) Banking
5 7 (5.88%) Publishing
6 6 (5.04%) Games
7 5 (4.20%) Marketing
8 3 (2.52%) Back Office
9 2 (1.68%) Investment Banking
10 1 (0.84%) Advertising
Job Titles
1 68 (57.14%) Developer
2 35 (29.41%) ETL Developer
3 26 (21.85%) Architect
3 26 (21.85%) Data Architect
3 26 (21.85%) Data Warehouse Developer
4 25 (21.01%) Business Intelligence Developer
5 24 (20.17%) SSIS Developer
6 21 (17.65%) SQL Developer
7 17 (14.29%) Analyst
7 17 (14.29%) Business Objects Developer
8 14 (11.76%) Analyst Developer
9 13 (10.92%) Data Analyst
10 11 (9.24%) Consultant
10 11 (9.24%) Data Warehouse Analyst
10 11 (9.24%) Developer Analyst
10 11 (9.24%) Lead Developer
10 11 (9.24%) Report Developer
10 11 (9.24%) SQL Analyst
10 11 (9.24%) SQL Data Analyst
10 11 (9.24%) SSIS Analyst
Libraries, Frameworks & Software Standards
1 14 (11.76%) MDX
2 6 (5.04%) .NET
3 5 (4.20%) Middleware
3 5 (4.20%) WCF
3 5 (4.20%) WinForms
4 2 (1.68%) JSON
4 2 (1.68%) Kafka
4 2 (1.68%) XML
5 1 (0.84%) ASP.NET
5 1 (0.84%) ASP.NET MVC
5 1 (0.84%) Web Services
Miscellaneous
1 25 (21.01%) Data Integration
2 15 (12.61%) Management Information System
3 12 (10.08%) Visualisation
4 7 (5.88%) Analytical Skills
5 5 (4.20%) Online Games
6 4 (3.36%) Clustering
7 3 (2.52%) Fintech
7 3 (2.52%) Virtual Team
8 2 (1.68%) Computer Science
8 2 (1.68%) Freedom of Information
Operating Systems
1 4 (3.36%) Unix
Processes & Methodologies
1 83 (69.75%) ETL
2 77 (64.71%) Business Intelligence
3 51 (42.86%) Data Modelling
4 33 (27.73%) Kimball Methodology
5 27 (22.69%) Analytics
6 23 (19.33%) Data Architecture
7 18 (15.13%) ETL Development
8 14 (11.76%) Data Management
9 13 (10.92%) Mentoring
10 12 (10.08%) Investment Management
11 11 (9.24%) Data Governance
11 11 (9.24%) Dimensional Modelling
12 10 (8.40%) Agile Software Development
12 10 (8.40%) Performance Tuning
13 9 (7.56%) Data Visualisation
13 9 (7.56%) SDLC
14 7 (5.88%) Data Analytics
14 7 (5.88%) Logical Data Model
14 7 (5.88%) Release Management
14 7 (5.88%) SOA
Programming Languages
1 87 (73.11%) SQL
2 24 (20.17%) T-SQL
3 13 (10.92%) PL/SQL
4 8 (6.72%) C#
5 6 (5.04%) PowerShell
5 6 (5.04%) Python
6 5 (4.20%) C
6 5 (4.20%) VB
6 5 (4.20%) VB.NET
6 5 (4.20%) VBA
7 4 (3.36%) Data Analysis Expressions (DAX)
8 3 (2.52%) Java
9 2 (1.68%) Clojure
9 2 (1.68%) R
9 2 (1.68%) Ruby
9 2 (1.68%) Scala
9 2 (1.68%) Shell Script
Qualifications
1 11 (9.24%) Degree
Quality Assurance & Compliance
1 16 (13.45%) Data Quality
2 6 (5.04%) QA
System Software
1 2 (1.68%) Oracle RAC
Systems Management
1 2 (1.68%) Cisco IPCC
1 2 (1.68%) Dollar Universe
Vendors
1 59 (49.58%) Microsoft
2 41 (34.45%) Oracle
3 21 (17.65%) Tableau
4 13 (10.92%) Informatica
5 11 (9.24%) SAP
6 10 (8.40%) Endeca
7 6 (5.04%) Cognos
8 4 (3.36%) Embarcadero
9 2 (1.68%) IBM
10 1 (0.84%) MicroStrategy
10 1 (0.84%) Pega
10 1 (0.84%) Teradata
London
Harvey Nash plc
Salary: £70000 - £75000 per annum + 10% Bonus & Excellent Package
Posted: 3 days ago
London
Lawrence Harvey Enterprise
Salary: £65000.00 - £80000.00 per annum + car, bonus, flexible working
Posted: 5 days ago
London
Venturi
Salary: £70000 - £75000 per annum + Bonus + Benefits
Posted: 6 days ago