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

3 months to
28 Jun 2016
Same period 2015 Same period 2014
Star Schema
Rank 585 559 665
Rank change year-on-year
-26 +106
Permanent jobs citing Star Schema 60 102 35
As % of all permanent IT jobs located in London 0.15% 0.23% 0.071%
As % of the Database & Business Intelligence category 0.51% 0.72% 0.22%
Number of salaries quoted 48 43 31
Median salary £52,500 £65,000 £60,000
Median salary % change year-on-year
-19.23% +8.33%
90% offered a salary of more than £44,000 £47,500 £45,000
10% offered a salary of more than £78,250 £87,500 £75,000
UK excluding London median salary £52,500 £43,500 £45,000
% change year-on-year
+20.68% -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
11785 14212 15667
As % of all permanent IT jobs located in London 29.45% 32.17% 31.72%
Number of salaries quoted 10269 12055 13675
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 £39,000 £37,309
10% offered a salary of more than £80,000 £77,500 £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 28 June 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 June 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 +69 14 £50,000 -41.17%
Uxbridge +9 7 £44,000 -8.33%
Star Schema
England

Star Schema
Top 30 Related IT Skills in London

For the 6 months to 28 June 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 98 (82.35%) Data Warehouse
2 88 (73.95%) SQL
3 84 (70.59%) ETL
4 81 (68.07%) Finance
5 72 (60.50%) Business Intelligence
6 68 (57.14%) SQL Server
7 63 (52.94%) Microsoft
8 53 (44.54%) SQL Server Integration Services
9 52 (43.70%) Data Modelling
10 44 (36.97%) MS Excel
11 34 (28.57%) Oracle
12 32 (26.89%) SQL Server Analysis Services
13 29 (24.37%) Kimball Methodology
14 28 (23.53%) Data Integration
15 27 (22.69%) Analytics
16 26 (21.85%) T-SQL
17 23 (19.33%) SQL Server Reporting Services
18 21 (17.65%) MDX
19 20 (16.81%) BusinessObjects
20 19 (15.97%) Retail
20 19 (15.97%) Data Architecture
20 19 (15.97%) SQL Server 2008
20 19 (15.97%) Tableau
20 19 (15.97%) Relational Database
21 18 (15.13%) ETL Development
22 17 (14.29%) Data Quality
23 16 (13.45%) SQL Server 2014
23 16 (13.45%) Data Management
23 16 (13.45%) OLAP
24 14 (11.76%) Oracle Reports

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 3 (2.52%) SharePoint
2 2 (1.68%) Apache Pig
2 2 (1.68%) Apache Spark
2 2 (1.68%) SAS
Applications
1 44 (36.97%) MS Excel
2 2 (1.68%) SPSS
Business Applications
1 6 (5.04%) Oracle Applications
2 3 (2.52%) Cognos TM1
3 1 (0.84%) Cognos Business Intelligence
Cloud Services
1 5 (4.20%) Amazon AWS
2 1 (0.84%) Google Cloud Platform
Database & Business Intelligence
1 98 (82.35%) Data Warehouse
2 68 (57.14%) SQL Server
3 53 (44.54%) SQL Server Integration Services
4 32 (26.89%) SQL Server Analysis Services
5 23 (19.33%) SQL Server Reporting Services
6 20 (16.81%) BusinessObjects
7 19 (15.97%) Relational Database
7 19 (15.97%) SQL Server 2008
8 16 (13.45%) OLAP
8 16 (13.45%) SQL Server 2014
9 14 (11.76%) Oracle ODI
9 14 (11.76%) Oracle Reports
10 13 (10.92%) RDBMS
11 12 (10.08%) Oracle Database
12 11 (9.24%) Oracle Database 11g
13 10 (8.40%) Oracle Database 12c
14 8 (6.72%) Big Data
15 7 (5.88%) Enterprise Data Warehouse
15 7 (5.88%) Oracle BI EE
15 7 (5.88%) Oracle BI Publisher
Development Applications
1 5 (4.20%) Subversion
2 1 (0.84%) ERwin
General
1 81 (68.07%) Finance
2 19 (15.97%) Retail
3 8 (6.72%) Legal
4 7 (5.88%) Banking
4 7 (5.88%) Law
4 7 (5.88%) Publishing
5 6 (5.04%) Games
6 5 (4.20%) Marketing
7 3 (2.52%) Back Office
8 2 (1.68%) Investment Banking
Job Titles
1 65 (54.62%) Developer
2 34 (28.57%) ETL Developer
3 26 (21.85%) Data Warehouse Developer
4 24 (20.17%) Business Intelligence Developer
4 24 (20.17%) SSIS Developer
5 20 (16.81%) Architect
5 20 (16.81%) Data Architect
6 19 (15.97%) Analyst
7 18 (15.13%) SQL Developer
8 17 (14.29%) Business Objects Developer
9 14 (11.76%) Analyst Developer
10 13 (10.92%) Data Analyst
11 12 (10.08%) SQL Analyst
12 11 (9.24%) Data Warehouse Analyst
12 11 (9.24%) Developer Analyst
12 11 (9.24%) ETL Analyst
12 11 (9.24%) Lead Developer
12 11 (9.24%) Report Developer
12 11 (9.24%) SQL Data Analyst
12 11 (9.24%) SSIS Analyst
Libraries, Frameworks & Software Standards
1 21 (17.65%) MDX
2 5 (4.20%) .NET
2 5 (4.20%) Middleware
2 5 (4.20%) WCF
2 5 (4.20%) WinForms
3 2 (1.68%) Kafka
4 1 (0.84%) JSON
4 1 (0.84%) XML
Miscellaneous
1 28 (23.53%) Data Integration
2 12 (10.08%) Management Information System
3 11 (9.24%) Visualisation
4 9 (7.56%) Clustering
5 8 (6.72%) Analytical Skills
6 5 (4.20%) Online Games
7 3 (2.52%) Virtual Team
8 2 (1.68%) Computer Science
8 2 (1.68%) Fintech
8 2 (1.68%) Freedom of Information
9 1 (0.84%) Data Structures
Operating Systems
1 4 (3.36%) Unix
Processes & Methodologies
1 84 (70.59%) ETL
2 72 (60.50%) Business Intelligence
3 52 (43.70%) Data Modelling
4 29 (24.37%) Kimball Methodology
5 27 (22.69%) Analytics
6 19 (15.97%) Data Architecture
7 18 (15.13%) ETL Development
8 16 (13.45%) Data Management
9 13 (10.92%) Dimensional Modelling
9 13 (10.92%) Mentoring
10 12 (10.08%) Investment Management
11 11 (9.24%) Data Governance
12 10 (8.40%) Performance Tuning
13 9 (7.56%) Agile Software Development
13 9 (7.56%) Data Visualisation
14 8 (6.72%) Release Management
15 7 (5.88%) Logical Data Model
15 7 (5.88%) SOA
16 6 (5.04%) ITIL
16 6 (5.04%) Systems Analysis
Programming Languages
1 88 (73.95%) SQL
2 26 (21.85%) T-SQL
3 12 (10.08%) PL/SQL
3 12 (10.08%) PowerShell
4 8 (6.72%) C#
5 5 (4.20%) C
5 5 (4.20%) Python
5 5 (4.20%) VB
5 5 (4.20%) VB.NET
5 5 (4.20%) VBA
6 4 (3.36%) Java
7 3 (2.52%) Data Analysis Expressions (DAX)
8 2 (1.68%) Clojure
8 2 (1.68%) R
8 2 (1.68%) Ruby
8 2 (1.68%) Scala
8 2 (1.68%) Shell Script
Qualifications
1 8 (6.72%) Degree
Quality Assurance & Compliance
1 17 (14.29%) Data Quality
2 5 (4.20%) QA
System Software
1 3 (2.52%) Oracle RAC
Systems Management
1 2 (1.68%) Cisco IPCC
1 2 (1.68%) Dollar Universe
Vendors
1 63 (52.94%) Microsoft
2 34 (28.57%) Oracle
3 19 (15.97%) Tableau
4 11 (9.24%) SAP
5 10 (8.40%) Informatica
6 8 (6.72%) Cognos
7 7 (5.88%) Endeca
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: £80000 per annum
Posted: 5 days ago
London
Venturi
Salary: £60000.00 - £85000.00 per annum + Bonus and Benefits
Posted: 4 days ago