The table below looks at the statistics for Star Schema skills in IT jobs advertised for the City of London region. Included is a guide to the average salaries offered in IT jobs that have cited Star Schema over the 3 months to 18 December 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
18 Dec 2014
Same period 2013 Same period 2012
Star Schema
Rank 302 316 307
Rank change year-on-year
+14 -9
Permanent jobs citing Star Schema 11 18 18
As % of all permanent IT jobs located in the City of London 0.10% 0.15% 0.15%
As % of the Database & Business Intelligence category 0.37% 0.52% 0.53%
Number of salaries quoted 11 16 18
Average salary £43,000 £57,500 £46,250
Average salary % change year-on-year
-25.21% +24.32%
UK excluding London average salary £48,000 £45,000 £42,500
% change year-on-year
+6.66% +5.88%
Star Schema
London

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 City of London region.

Database & Business Intelligence Category
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
2952 3457 3399
As % of all permanent IT jobs located in the City of London 26.96% 29.05% 28.96%
Number of salaries quoted 2625 3034 3118
Average salary £55,000 £55,000 £50,000
Average salary % change year-on-year
- +10.00%
90% offered a salary of more than £37,500 £36,000 £35,000
10% offered a salary of more than £75,000 £75,000 £77,500
UK excluding London average salary £40,000 £40,000 £39,000
% change year-on-year
- +2.56%

Star Schema
Jobs Demand Trend in the City of London

This chart provides a 3-month moving total of permanent IT jobs citing Star Schema across the City of London region as a proportion of the total demand within the Database & Business Intelligence category.

Star Schema Jobs Demand Trend in the City of London

Star Schema
Salary Trend in the City of London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Star Schema across the City of London region.

Star Schema Salary Trend in the City of London

Star Schema
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing Star Schema across the City of London region over the 3 months to 18 December 2014.

Star Schema Salary Histogram in the City of London

Star Schema
Top 30 Related IT Skills in the City of London

For the 6 months to 18 December 2014, IT jobs across the City of London region citing Star Schema also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Star Schema.

1 26 (92.86%) ETL
2 25 (89.29%) SQL
3 23 (82.14%) Finance
4 20 (71.43%) Data Warehouse
5 15 (53.57%) SQL Server
6 14 (50.00%) Business Intelligence
6 14 (50.00%) SQL Server Integration Services
6 14 (50.00%) SQL Server Analysis Services
7 12 (42.86%) T-SQL
8 10 (35.71%) Agile Software Development
8 10 (35.71%) SQL Server Reporting Services
8 10 (35.71%) Kimball Methodology
9 9 (32.14%) Data Modelling
10 8 (28.57%) Oracle
10 8 (28.57%) VBA
10 8 (28.57%) Spreadsheet
10 8 (28.57%) Relational Database
10 8 (28.57%) Analytical Skills
11 7 (25.00%) OLAP
12 6 (21.43%) Cognos
13 5 (17.86%) Dimensional Modelling
13 5 (17.86%) Oracle OLAP
13 5 (17.86%) QlikView
13 5 (17.86%) Oracle Database 11g
13 5 (17.86%) Oracle Database
13 5 (17.86%) Performance Tuning
13 5 (17.86%) PL/SQL
13 5 (17.86%) Scrum
13 5 (17.86%) Mentoring
14 4 (14.29%) Regression Testing

Star Schema
Top Related IT Skills in the City of London by Category

For the 6 months to 18 December 2014, IT jobs across the City of London region citing Star Schema also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Star Schema. Up to 20 skills are shown per category.

Application Platforms
1 1 (3.57%) MQSeries
Applications
1 8 (28.57%) Spreadsheet
2 2 (7.14%) MS Excel
Business Applications
1 2 (7.14%) Cognos TM1
Database & Business Intelligence
1 20 (71.43%) Data Warehouse
2 15 (53.57%) SQL Server
3 14 (50.00%) SQL Server Integration Services
3 14 (50.00%) SQL Server Analysis Services
4 10 (35.71%) SQL Server Reporting Services
5 8 (28.57%) Relational Database
6 7 (25.00%) OLAP
7 5 (17.86%) Oracle OLAP
7 5 (17.86%) QlikView
7 5 (17.86%) Oracle Database 11g
7 5 (17.86%) Oracle Database
8 3 (10.71%) MySQL
9 2 (7.14%) Cognos Query Studio
9 2 (7.14%) Cognos Analysis Studio
9 2 (7.14%) Cognos Report Studio
9 2 (7.14%) OLAP Cube
9 2 (7.14%) Oracle Reports
Development Applications
1 4 (14.29%) Team Foundation Server
General
1 23 (82.14%) Finance
2 3 (10.71%) Pharmaceutical
2 3 (10.71%) Marketing
3 2 (7.14%) Law
Job Titles
1 19 (67.86%) Developer
2 6 (21.43%) Data Warehouse Developer
3 4 (14.29%) SQL Developer
3 4 (14.29%) SQL Server Developer
3 4 (14.29%) Consultant
3 4 (14.29%) Senior Developer
3 4 (14.29%) QlikView Consultant
4 3 (10.71%) Designer
5 2 (7.14%) Cognos Developer
5 2 (7.14%) Business Intelligence Developer
6 1 (3.57%) Oracle Data Warehouse Developer
6 1 (3.57%) Excel Developer
6 1 (3.57%) Programmer
6 1 (3.57%) Data Programmer
6 1 (3.57%) Architect
6 1 (3.57%) Business Intelligence Architect
6 1 (3.57%) ETL Architect
6 1 (3.57%) Oracle BI Developer
6 1 (3.57%) SQL Programmer
6 1 (3.57%) TM1 Developer
Libraries, Frameworks & Software Standards
1 4 (14.29%) XML
Miscellaneous
1 8 (28.57%) Analytical Skills
2 4 (14.29%) Hedge funds
3 3 (10.71%) Data Integration
4 1 (3.57%) NHS
Operating Systems
1 1 (3.57%) UNIX
1 1 (3.57%) Linux
Processes & Methodologies
1 26 (92.86%) ETL
2 14 (50.00%) Business Intelligence
3 10 (35.71%) Agile Software Development
3 10 (35.71%) Kimball Methodology
4 9 (32.14%) Data Modelling
5 5 (17.86%) Performance Tuning
5 5 (17.86%) Scrum
5 5 (17.86%) Dimensional Modelling
5 5 (17.86%) Mentoring
6 4 (14.29%) Asset Management
6 4 (14.29%) Regression Testing
6 4 (14.29%) Migration
7 3 (10.71%) Data Analytics
7 3 (10.71%) Analytics
8 2 (7.14%) Kalman Filter
8 2 (7.14%) Data Analysis
9 1 (3.57%) Inmon Methodology
9 1 (3.57%) Information Management
9 1 (3.57%) SOA
Programming Languages
1 25 (89.29%) SQL
2 12 (42.86%) T-SQL
3 8 (28.57%) VBA
4 5 (17.86%) PL/SQL
Vendors
1 8 (28.57%) Oracle
2 6 (21.43%) Cognos
3 4 (14.29%) Business Objects
3 4 (14.29%) Microsoft
4 2 (7.14%) IBM
5 1 (3.57%) Informatica
5 1 (3.57%) Teradata
City, London
Parallel Consulting
Salary: £38000 - £48000 per annum + Bonus
Posted: 2 days ago
City of London
KDR Recruitment
Salary: £40000 - £80000 per annum + Bonus/Benefits
Posted: 5 days ago
City of London
NFP Group Ltd
Salary: £60000 - £70000 per annum
Posted: 8 days ago